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 diff
1.1 --- a/s4-init.sh Tue Jul 02 12:29:06 2019 +0900 1.2 +++ b/s4-init.sh Tue Jul 02 12:30:16 2019 +0900 1.3 @@ -77,7 +77,7 @@ 1.4 acc=`query "select name from sqlite_master where name='acclog';"` 1.5 create table tblaccesses "(user, tbl, tblrowid, time, \ 1.6 unique(user, tbl, tblrowid, time), \ 1.7 - foreign key(user) references user(name))" 1.8 + foreign key(user) references user(name) on delete cascade on update cascade)" 1.9 if [ -z "$tblacc" -a -n "$acc" ]; then 1.10 echo Regenerating... 1.11 query "INSERT INTO tblaccesses SELECT * FROM acclog;