Mercurial > hgrepos > hgweb.cgi > s4

annotate scripts/s4-fix-tblaclog.sh @ 580:a9faeb10a33b

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add script for fixing tblaccesses table schema
author HIROSE Yuuji <yuuji@gentei.org>
date Wed, 19 Jun 2019 09:13:57 +0900
parents
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
580
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
1 #!/bin/sh
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
2
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
3 cd `dirname $0`/..
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
4 if ! . ./s4-funcs.sh; then
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
5 echo "Cannot find s4-funcs.sh, which should be located in $mydir/.."
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
6 exit 1
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
7 fi
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
8
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
9 cnt0=`query "SELECT count(sql) FROM sqlite_master WHERE name='tblaccesses';"`
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
10 cnt1=`query "SELECT count(sql) FROM sqlite_master WHERE name='tblaccesses' AND sql LIKE '%cascade%';"`
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
11
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
12 if [ x"$cnt0" = x"1" -a x"$cnt1" = x"0" ]; then
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
13 echo -n Start fixing accesslog table...
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
14 query <<-EOF && echo ..Done
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
15 BEGIN;
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
16 CREATE TABLE "tblaccesses2" (user, tbl, tblrowid, time, primary key (user, tbl, tblrowid, time), FOREIGN KEY(user) REFERENCES user(name) ON DELETE CASCADE ON UPDATE CASCADE);
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
17 INSERT INTO tblaccesses2 SELECT * FROM tblaccesses;
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
18 DROP TABLE tblaccesses;
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
19 ALTER TABLE tblaccesses2 RENAME TO tblaccesses;
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
20 COMMIT;
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
21 EOF
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
22 else
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
23 echo No need to fix db.
a9faeb10a33b Add script for fixing tblaccesses table schema
HIROSE Yuuji <yuuji@gentei.org>
parents:
diff changeset
24 fi

yatex.org