diff --git a/s4-init.sh b/s4-init.sh index f66fb60..6aaeebc 100755 --- a/s4-init.sh +++ b/s4-init.sh @@ -71,9 +71,10 @@ create table par '(sessid text, var text, type text, val text, primary key(sessid, var, val) foreign key(sessid) references session(id) on update cascade on delete cascade);' create table session '(id text primary key, expire text);' create table cookie '(sessid text, var text, type text, val text, primary key(sessid, var) foreign key(sessid) references session(id) on update cascade on delete cascade);' + +# For compatibility tblacc=`query "select name from sqlite_master where name='tblaccesses';"` acc=`query "select name from sqlite_master where name='acclog';"` -echo tblacc="[$tblacc]" acc="[$acc]" create table tblaccesses "(user, tbl, tblrowid, time, \ unique(user, tbl, tblrowid, time), \ foreign key(user) references user(name))" @@ -82,6 +83,7 @@ query "INSERT INTO tblaccesses SELECT * FROM acclog; DROP TABLE acclog;" fi +# Ver.2 of acclog create view acclog "AS SELECT user, tbl, tblrowid, max(time) time FROM tblaccesses GROUP by user, tbl, tblrowid;"