X-Git-Url: http://git.treefish.org/banana.git/blobdiff_plain/7b7f10ba3917a6d5229f13d27aa4e94a9685b00e..7c6abf783f4b583b0c8bc43ad434fcce37a3dcc7:/include/db.inc

diff --git a/include/db.inc b/include/db.inc
index 90ce96a..efd7aae 100644
--- a/include/db.inc
+++ b/include/db.inc
@@ -4,11 +4,15 @@
       $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
-          (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)');
     }
   }
 ?>