s4: scripts/s4-fix-tblaclog.sh annotate

s4

Add script for fixing tblaccesses table schema

author	HIROSE Yuuji <yuuji@gentei.org>
date	Wed, 19 Jun 2019 09:13:57 +0900
parents
children

rev	line source
yuuji@580	1 #!/bin/sh
yuuji@580	2
yuuji@580	3 cd `dirname $0`/..
yuuji@580	4 if ! . ./s4-funcs.sh; then
yuuji@580	5 echo "Cannot find s4-funcs.sh, which should be located in $mydir/.."
yuuji@580	6 exit 1
yuuji@580	7 fi
yuuji@580	8
yuuji@580	9 cnt0=`query "SELECT count(sql) FROM sqlite_master WHERE name='tblaccesses';"`
yuuji@580	10 cnt1=`query "SELECT count(sql) FROM sqlite_master WHERE name='tblaccesses' AND sql LIKE '%cascade%';"`
yuuji@580	11
yuuji@580	12 if [ x"$cnt0" = x"1" -a x"$cnt1" = x"0" ]; then
yuuji@580	13 echo -n Start fixing accesslog table...
yuuji@580	14 query <<-EOF && echo ..Done
yuuji@580	15 BEGIN;
yuuji@580	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);
yuuji@580	17 INSERT INTO tblaccesses2 SELECT * FROM tblaccesses;
yuuji@580	18 DROP TABLE tblaccesses;
yuuji@580	19 ALTER TABLE tblaccesses2 RENAME TO tblaccesses;
yuuji@580	20 COMMIT;
yuuji@580	21 EOF
yuuji@580	22 else
yuuji@580	23 echo No need to fix db.
yuuji@580	24 fi