X-Git-Url: http://git.pjr.cc/?p=gwvp-mini.git;a=blobdiff_plain;f=gwvpmini%2Fgwvpmini_db.php;h=972746e89949593be0a14b510da6dd0787f607b0;hp=64277bcde13a2cf8488ff204010a20096381c8d6;hb=3a319290353bbe27aa901b4f1c48ccb44dca28ed;hpb=366baaa372e9c911249ce35f045c5eee1b864d84 diff --git a/gwvpmini/gwvpmini_db.php b/gwvpmini/gwvpmini_db.php index 64277bc..972746e 100644 --- a/gwvpmini/gwvpmini_db.php +++ b/gwvpmini/gwvpmini_db.php @@ -426,11 +426,20 @@ function gwvpmini_dbCreateSQLiteStructure($dbloc) // 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 + + // type for now will only be "git" + // date is obvious + // desc is a desction of the activity + // link is of the form "repo,reponame,repoid:user,username,useremail,userid" so it + // can be attached simply + // viewby is a simple list of uid's that should be able to see it... "r" for all registered + // "a" for everyone $activitysql = ' CREATE TABLE "activity" ( "activity_type" TEXT, "activity_date" TEXT, "activity_desc" TEXT, + "activity_link" TEXT, "activity_viewby" TEXT )';