# HG changeset patch
# User HIROSE Yuuji <yuuji@gentei.org>
# Date 1560903237 -32400
# Node ID a9faeb10a33bc1e428c0e203bd09b7828a65e0a2
# Parent  6e727ab07c98e2a11e4e105f35fba80c36883987
Add script for fixing tblaccesses table schema

diff -r 6e727ab07c98 -r a9faeb10a33b scripts/s4-fix-tblaclog.sh
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/scripts/s4-fix-tblaclog.sh	Wed Jun 19 09:13:57 2019 +0900
@@ -0,0 +1,24 @@
+#!/bin/sh
+
+cd `dirname $0`/..
+if ! . ./s4-funcs.sh; then
+  echo "Cannot find s4-funcs.sh, which should be located in $mydir/.."
+  exit 1
+fi
+
+cnt0=`query "SELECT count(sql) FROM sqlite_master WHERE name='tblaccesses';"`
+cnt1=`query "SELECT count(sql) FROM sqlite_master WHERE name='tblaccesses' AND sql LIKE '%cascade%';"`
+
+if [ x"$cnt0" = x"1" -a x"$cnt1" = x"0" ]; then
+  echo -n Start fixing accesslog table...
+  query <<-EOF && echo ..Done
+	BEGIN;
+	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);
+	INSERT INTO tblaccesses2 SELECT * FROM tblaccesses;
+	DROP TABLE tblaccesses;
+	ALTER TABLE tblaccesses2 RENAME TO tblaccesses;
+	COMMIT;
+	EOF
+else
+  echo No need to fix db.
+fi