diff --git a/s4-init.sh b/s4-init.sh index 10b27c9..823b0d2 100755 --- a/s4-init.sh +++ b/s4-init.sh @@ -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;