...

[banana.git] / include / db.inc

diff --git a/include/db.inc b/include/db.inc
index 3612374f3200e4062b111864a5ac7d0bb8912fbd..16e36f9bc4bbbbf91a308e200414aff684e3c8b8 100644 (file)
--- a/include/db.inc
+++ b/include/db.inc
@@ -2,9 +2,9 @@
   if (! isset($db)) {
     if ($db = new PDO('sqlite:banane.db')) {
       $db->query('CREATE TABLE IF NOT EXISTS students 
   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
       $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
       $db->query('CREATE TABLE IF NOT EXISTS prefs
           (key string, value string, PRIMARY KEY (key))');
       $db->query('CREATE TABLE IF NOT EXISTS sessions