X-Git-Url: https://git.treefish.org/banana.git/blobdiff_plain/7b7f10ba3917a6d5229f13d27aa4e94a9685b00e..7b7a9103e0252d7accb3c456e0f16e50ce3ace96:/include/db.inc?ds=sidebyside diff --git a/include/db.inc b/include/db.inc index 90ce96a..16e36f9 100644 --- a/include/db.inc +++ b/include/db.inc @@ -4,7 +4,7 @@ $db->query('CREATE TABLE IF NOT EXISTS students (mnumber int, firstname string, lastname string, email string, password string, blackboard int DEFAULT 0, lastblackboard TIMESTAMP, PRIMARY KEY (mnumber))'); $db->query('CREATE TABLE IF NOT EXISTS workdone - (mnumber int, session int, manydone int, thisdone string)'); + (mnumber int, session int, manydone int, thisdone string, tstamp TIMESTAMP)'); $db->query('CREATE TABLE IF NOT EXISTS prefs (key string, value string, PRIMARY KEY (key))'); $db->query('CREATE TABLE IF NOT EXISTS sessions