X-Git-Url: http://git.treefish.org/banana.git/blobdiff_plain/4678f209fb04682d0981cadb566d63f5726f9e09..8db41c98817b1b48532dc3cebf4bea166e42bb70:/include/db.inc

diff --git a/include/db.inc b/include/db.inc
new file mode 100644
index 0000000..3612374
--- /dev/null
+++ b/include/db.inc
@@ -0,0 +1,14 @@
+<?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 workdone
+          (mnumber int, session int, manydone int, thisdone string)');
+      $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))'); 
+    }
+  }
+?>