--- /dev/null
+<?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))');
+ }
+ }
+?>