X-Git-Url: http://git.pjr.cc/?p=gwvp-mini.git;a=blobdiff_plain;f=gwvpmini%2Fgwvpmini_db.php;h=64277bcde13a2cf8488ff204010a20096381c8d6;hp=97437b59a3f8aa3930c725002bc326beaada3ab1;hb=366baaa372e9c911249ce35f045c5eee1b864d84;hpb=b26baaa1fd812e3c01646323119ca2b97ccdbd1d

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)