added exams

[banana.git] / admin / include / db.inc

diff --git a/admin/include/db.inc b/admin/include/db.inc
index 9bce2c3541fe9a9ed7649008e8beaa79e60f5bbe..7c4da1d54ee759b10d4dfe0a64a819f2284a69be 100644 (file)
--- a/admin/include/db.inc
+++ b/admin/include/db.inc
@@ -1,14 +1,18 @@
 <?php
   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))');
+      $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, timestr string NOT NULL, 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)');
     }
   }
 ?>