X-Git-Url: https://git.treefish.org/banana.git/blobdiff_plain/8db41c98817b1b48532dc3cebf4bea166e42bb70..311a7991e63b57767d675dda37476a0cbd2bb0d8:/admin/include/db.inc?ds=sidebyside

diff --git a/admin/include/db.inc b/admin/include/db.inc
index 9bce2c3..f7c4e6c 100644
--- a/admin/include/db.inc
+++ b/admin/include/db.inc
@@ -1,14 +1,7 @@
 <?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, timestr string NOT NULL, PRIMARY KEY (id))'); 
+      require 'dbscheme.inc';
     }
   }
 ?>