X-Git-Url: http://git.treefish.org/banana.git/blobdiff_plain/75c95fb6291c3baacfe1883b3f1207c2b34fd78c..df32c63a6e9666eb062f806262aa23ed43c6eb99:/include/dbscheme.inc

diff --git a/include/dbscheme.inc b/include/dbscheme.inc
new file mode 100644
index 0000000..02feb33
--- /dev/null
+++ b/include/dbscheme.inc
@@ -0,0 +1,14 @@
+<?php
+$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, 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))');
+$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)');
+?>
\ No newline at end of file