X-Git-Url: http://git.treefish.org/banana.git/blobdiff_plain/8db41c98817b1b48532dc3cebf4bea166e42bb70..a4f105d41d06053ff3a7b52572bd818b1a027149:/include/db.inc?ds=sidebyside 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