From d072920a676743dd4ba9d4cc4af080eee9809a01 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Tue, 12 Jul 2016 16:54:36 +0200
Subject: [exams] Show list of upcomfing exam lectures; allow adding exam
 period based on upcoming exam

---
 modules-available/exams/install.inc.php | 5 +++++
 1 file changed, 5 insertions(+)

(limited to 'modules-available/exams/install.inc.php')

diff --git a/modules-available/exams/install.inc.php b/modules-available/exams/install.inc.php
index 0cb1af8e..18be0be6 100644
--- a/modules-available/exams/install.inc.php
+++ b/modules-available/exams/install.inc.php
@@ -4,6 +4,7 @@ $res = array();
 
 $res[] = tableCreate('exams', '
 	 `examid` int(11) NOT NULL AUTO_INCREMENT,
+	 `lectureid` char(36) CHARACTER SET ascii COLLATE ascii_bin DEFAULT NULL
 	 `starttime` int(11) NOT NULL,
 	 `endtime` int(11) NOT NULL,
 	 `description` varchar(500) DEFAULT NULL,
@@ -24,6 +25,10 @@ if (Database::exec("ALTER TABLE exams ADD INDEX `idx_daterange` ( `starttime` ,
 	$res[] = UPDATE_DONE;
 }
 
+if (!tableHasColumn('exams', 'lectureid')) {
+	Database::exec("ALTER TABLE `exams` ADD `lectureid` CHAR(36) CHARACTER SET ascii COLLATE ascii_bin NULL DEFAULT NULL AFTER `examid`");
+}
+
 Database::exec("ALTER TABLE `exams` CHANGE `description` `description` varchar(500) DEFAULT NULL");
 
 if (in_array(UPDATE_DONE, $res)) {
-- 
cgit v1.2.3-55-g7522