# HG changeset patch
# User HIROSE Yuuji <yuuji@gentei.org>
# Date 1562038216 -32400
# Node ID b37776054ba738f92dddabe8f5a4a3b5302c7931
# Parent  8a206c6342a8a09c3a21cbaa3d3c25fe2cf184be
Foreign key restriction fixed

diff -r 8a206c6342a8 -r b37776054ba7 s4-init.sh
--- 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;