X-Git-Url: http://git.treefish.org/banana.git/blobdiff_plain/719a15658a3577b6682bd8d2f96b66b6d6539bbc..7b7f10ba3917a6d5229f13d27aa4e94a9685b00e:/include/db.inc diff --git a/include/db.inc b/include/db.inc index 3612374..90ce96a 100644 --- a/include/db.inc +++ b/include/db.inc @@ -2,7 +2,7 @@ if (! isset($db)) { if ($db = new PDO('sqlite:banane.db')) { $db->query('CREATE TABLE IF NOT EXISTS students - (mnumber int, firstname string, lastname string, email string, password string, blackboard int DEFAULT 0, PRIMARY KEY (mnumber))'); + (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)'); $db->query('CREATE TABLE IF NOT EXISTS prefs