added exams

[banana.git] / include / db.inc

diff --git a/include/db.inc b/include/db.inc
index 16e36f9bc4bbbbf91a308e200414aff684e3c8b8..efd7aae6a678270247a0f81b65f5c51bb6a15d50 100644 (file)
--- 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)');
     }
   }
 ?>