X-Git-Url: http://git.treefish.org/banana.git/blobdiff_plain/7b7f10ba3917a6d5229f13d27aa4e94a9685b00e..10fa45cd744a59490f4a7e4cb047589d9a8314c0:/include/db.inc 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