s4

changeset 580:a9faeb10a33b

find changesets by author, revision, files, or words in the commit message
Add script for fixing tblaccesses table schema
author HIROSE Yuuji <yuuji@gentei.org>
date Wed, 19 Jun 2019 09:13:57 +0900
parents 6e727ab07c98
children 8a206c6342a8
files scripts/s4-fix-tblaclog.sh
diffstat 1 files changed, 24 insertions(+), 0 deletions(-) [+]
line diff
     1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/scripts/s4-fix-tblaclog.sh	Wed Jun 19 09:13:57 2019 +0900
     1.3 @@ -0,0 +1,24 @@
     1.4 +#!/bin/sh
     1.5 +
     1.6 +cd `dirname $0`/..
     1.7 +if ! . ./s4-funcs.sh; then
     1.8 +  echo "Cannot find s4-funcs.sh, which should be located in $mydir/.."
     1.9 +  exit 1
    1.10 +fi
    1.11 +
    1.12 +cnt0=`query "SELECT count(sql) FROM sqlite_master WHERE name='tblaccesses';"`
    1.13 +cnt1=`query "SELECT count(sql) FROM sqlite_master WHERE name='tblaccesses' AND sql LIKE '%cascade%';"`
    1.14 +
    1.15 +if [ x"$cnt0" = x"1" -a x"$cnt1" = x"0" ]; then
    1.16 +  echo -n Start fixing accesslog table...
    1.17 +  query <<-EOF && echo ..Done
    1.18 +	BEGIN;
    1.19 +	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);
    1.20 +	INSERT INTO tblaccesses2 SELECT * FROM tblaccesses;
    1.21 +	DROP TABLE tblaccesses;
    1.22 +	ALTER TABLE tblaccesses2 RENAME TO tblaccesses;
    1.23 +	COMMIT;
    1.24 +	EOF
    1.25 +else
    1.26 +  echo No need to fix db.
    1.27 +fi