X-Git-Url: http://git.treefish.org/banana.git/blobdiff_plain/b22b28d88c9f6d951e1008e71843436b7df42b6a..40b00377877560ee2c6c4d5a771824059deac819:/include/db.inc?ds=sidebyside diff --git a/include/db.inc b/include/db.inc index 16e36f9..efd7aae 100644 --- a/include/db.inc +++ b/include/db.inc @@ -8,7 +8,11 @@ $db->query('CREATE TABLE IF NOT EXISTS prefs (key string, value string, PRIMARY KEY (key))'); $db->query('CREATE TABLE IF NOT EXISTS sessions - (id int NOT NULL, examples string, nexamples int, PRIMARY KEY (id))'); + (id int NOT NULL, examples string, nexamples int, PRIMARY KEY (id))'); + $db->query('CREATE TABLE IF NOT EXISTS exams + (id int NOT NULL, score string, PRIMARY KEY (id))'); + $db->query('CREATE TABLE IF NOT EXISTS examscore + (mnumber int, exam int, scorestr string, tstamp TIMESTAMP)'); } } ?>