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