s4

changeset 174:fe8a381f9483

Column "rowid" in acclog renamed to tblrowid
author HIROSE Yuuji <yuuji@gentei.org>
date Fri, 19 Feb 2016 18:03:37 +0859
parents 31e63d173d38
children 3d12521876f2
files s4-funcs.sh s4-init.sh
diffstat 2 files changed, 3 insertions(+), 3 deletions(-) [+]
line diff
     1.1 --- a/s4-funcs.sh	Fri Feb 19 16:16:24 2016 +0859
     1.2 +++ b/s4-funcs.sh	Fri Feb 19 18:03:37 2016 +0859
     1.3 @@ -2107,7 +2107,7 @@
     1.4      cntnew="(select count(val) from ${_t}_s where key='ctime' \
     1.5  	and id in (select id from $_t where $_i=a.id) \
     1.6  	and val > coalesce((select time from acclog where \
     1.7 -			    user='$user' and tbl='$2' and rowid=a.rowid),\
     1.8 +			    user='$user' and tbl='$2' and tblrowid=a.rowid),\
     1.9  		    '1970-01-01'))"
    1.10      cnt="$cntnew as '新着', $cntall as '総数',"
    1.11      dt_class=" td2r td3r"
     2.1 --- a/s4-init.sh	Fri Feb 19 16:16:24 2016 +0859
     2.2 +++ b/s4-init.sh	Fri Feb 19 18:03:37 2016 +0859
     2.3 @@ -71,8 +71,8 @@
     2.4  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);'
     2.5  create table session '(id text primary key, expire text);'
     2.6  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);'
     2.7 -create table acclog "(user, tbl, rowid, time, \
     2.8 -	primary key(user, tbl, rowid), \
     2.9 +create table acclog "(user, tbl, tblrowid, time, \
    2.10 +	primary key(user, tbl, tblrowid), \
    2.11  	foreign key(user) references user(name))"
    2.12  
    2.13  create view gecoses "AS