1 #!/bin/sh

2

3 cd `dirname $0`/..

4 if ! . ./s4-funcs.sh; then

5 echo "Cannot find s4-funcs.sh, which should be located in $mydir/.."

6 exit 1

7 fi

8

9 cnt0=`query "SELECT count(sql) FROM sqlite_master WHERE name='tblaccesses';"`

10 cnt1=`query "SELECT count(sql) FROM sqlite_master WHERE name='tblaccesses' AND sql LIKE '%cascade%';"`

11

12 if [ x"$cnt0" = x"1" -a x"$cnt1" = x"0" ]; then

13 echo -n Start fixing accesslog table...

14 query <<-EOF && echo ..Done

15 BEGIN;

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);

17 INSERT INTO tblaccesses2 SELECT * FROM tblaccesses;

18 DROP TABLE tblaccesses;

19 ALTER TABLE tblaccesses2 RENAME TO tblaccesses;

20 COMMIT;

21 EOF

22 else

23 echo No need to fix db.

24 fi