From: Paul J R <me@pjr.cc>
Date: Sat, 22 Sep 2012 22:06:37 +0000 (+1000)
Subject: starting work on the activity log
X-Git-Url: http://git.pjr.cc/?p=gwvp-mini.git;a=commitdiff_plain;h=366baaa372e9c911249ce35f045c5eee1b864d84

starting work on the activity log
---

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, <repoid>, <read|visible|write>, user:<uid>|group:<gid>|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)