dbsetup.php

<?php 
	if (!$included) {
		exit;
	}

	$db = new mysqli($db_host, $db_user, $db_pass, $db_name);
	if ($db->connect_error) {
		die('Could not connect to database. Did you setup config.php?');
	}

	$result = $db->query('SHOW TABLES LIKE "presentations"') or die('Database error 41.');
	if ($result->num_rows == 0) {
		$db->query('CREATE TABLE presentations (
			id INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
			datetime INT UNSIGNED NOT NULL,
			code VARCHAR(100) NOT NULL UNIQUE,
			secret VARCHAR(100) NOT NULL,
			title VARCHAR(255),
			speaker VARCHAR(255),
			link VARCHAR(255)
			)') or die('Database error 5189');

		$db->query('CREATE TABLE presentation_feedback (
			id INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
			presentationid INT NOT NULL
			)') or die('Database error 65719');

		$db->query('CREATE TABLE presentation_questions (
			id INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
			presentationid INT NOT NULL,
			sequenceNumber INT NOT NULL,
			question VARCHAR(255),
			type TINYINT
			)') or die('Database error 71598');

		$db->query('CREATE TABLE presentation_question_responses (
			id INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
			feedbackid INT NOT NULL,
			sequenceNumber INT NOT NULL,
			response VARCHAR(35000)
			)') or die('Database error 14717');

		$db->query('CREATE TABLE presentation_maillimit (
			id INT PRIMARY KEY AUTO_INCREMENT NOT NULL,
			emailaddress VARCHAR(32) NOT NULL UNIQUE,
			datetime INT UNSIGNED
			)') or die('Database error 34150');
	}