From: Alexander Schmidt Date: Mon, 8 Oct 2012 15:20:53 +0000 (+0200) Subject: ... X-Git-Url: https://git.treefish.org/banana.git/commitdiff_plain/b22b28d88c9f6d951e1008e71843436b7df42b6a?hp=a4f105d41d06053ff3a7b52572bd818b1a027149 ... --- diff --git a/include/db.inc b/include/db.inc index 90ce96a..16e36f9 100644 --- a/include/db.inc +++ b/include/db.inc @@ -4,7 +4,7 @@ $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