X-Git-Url: http://git.treefish.org/banana.git/blobdiff_plain/7b7f10ba3917a6d5229f13d27aa4e94a9685b00e..b22b28d88c9f6d951e1008e71843436b7df42b6a:/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