Mercurial > hgrepos > hgweb.cgi > 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 wrap: on
line diff
--- a/s4-funcs.sh Fri Feb 19 16:16:24 2016 +0859 +++ b/s4-funcs.sh Fri Feb 19 18:03:37 2016 +0859 @@ -2107,7 +2107,7 @@ cntnew="(select count(val) from ${_t}_s where key='ctime' \ and id in (select id from $_t where $_i=a.id) \ and val > coalesce((select time from acclog where \ - user='$user' and tbl='$2' and rowid=a.rowid),\ + user='$user' and tbl='$2' and tblrowid=a.rowid),\ '1970-01-01'))" cnt="$cntnew as '新着', $cntall as '総数'," dt_class=" td2r td3r"
--- a/s4-init.sh Fri Feb 19 16:16:24 2016 +0859 +++ b/s4-init.sh Fri Feb 19 18:03:37 2016 +0859 @@ -71,8 +71,8 @@ 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);' -create table acclog "(user, tbl, rowid, time, \ - primary key(user, tbl, rowid), \ +create table acclog "(user, tbl, tblrowid, time, \ + primary key(user, tbl, tblrowid), \ foreign key(user) references user(name))" create view gecoses "AS
