From 366baaa372e9c911249ce35f045c5eee1b864d84 Mon Sep 17 00:00:00 2001 From: Paul J R Date: Sun, 23 Sep 2012 08:06:37 +1000 Subject: [PATCH] starting work on the activity log --- gwvpmini/gwvpmini_db.php | 13 +++++++++++-- 1 files changed, 11 insertions(+), 2 deletions(-) diff --git a/gwvpmini/gwvpmini_db.php b/gwvpmini/gwvpmini_db.php index 97437b5..64277bc 100644 --- a/gwvpmini/gwvpmini_db.php +++ b/gwvpmini/gwvpmini_db.php @@ -424,7 +424,15 @@ function gwvpmini_dbCreateSQLiteStructure($dbloc) // this looks like null, , , user:|group:|authed|anon // where authed = any authenticated user, anon = everyone (logged in, not logged in, etc) // read|visible|write = can clone from repo|can see repo exists and see description but not clone from it|can push to repo - // TODO: is this sufficient? i have to think about it + // TODO: is this sufficient? i have to think about it + + $activitysql = ' + CREATE TABLE "activity" ( + "activity_type" TEXT, + "activity_date" TEXT, + "activity_desc" TEXT, + "activity_viewby" TEXT + )'; $configsql = ' CREATE TABLE "config" ( @@ -443,7 +451,8 @@ function gwvpmini_dbCreateSQLiteStructure($dbloc) $DB_CONNECTION->query($initialuser_admin); $DB_CONNECTION->query($initialuser_user); $DB_CONNECTION->query($reposql); - $DB_CONNECTION->query($configsql); + $DB_CONNECTION->query($configsql); + $DB_CONNECTION->query($activitysql); } function gwvpmini_getConfigVal($confname) -- 1.7.0.4