Mercurial > hgrepos > hgweb.cgi > s4
changeset 582:b37776054ba7
Foreign key restriction fixed
author | HIROSE Yuuji <yuuji@gentei.org> |
---|---|
date | Tue, 02 Jul 2019 12:30:16 +0900 |
parents | 8a206c6342a8 |
children | ae420aaa8f4f |
files | s4-init.sh |
diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- a/s4-init.sh Tue Jul 02 12:29:06 2019 +0900 +++ b/s4-init.sh Tue Jul 02 12:30:16 2019 +0900 @@ -77,7 +77,7 @@ acc=`query "select name from sqlite_master where name='acclog';"` create table tblaccesses "(user, tbl, tblrowid, time, \ unique(user, tbl, tblrowid, time), \ - foreign key(user) references user(name))" + foreign key(user) references user(name) on delete cascade on update cascade)" if [ -z "$tblacc" -a -n "$acc" ]; then echo Regenerating... query "INSERT INTO tblaccesses SELECT * FROM acclog;