diff options
| author | Simon Rettberg | 2016-07-12 16:54:36 +0200 |
|---|---|---|
| committer | Simon Rettberg | 2016-07-12 16:54:36 +0200 |
| commit | d072920a676743dd4ba9d4cc4af080eee9809a01 (patch) | |
| tree | d5df552bd3878d8704447593cffedd24ffb8f90b /modules-available/exams/install.inc.php | |
| parent | [exams] Fix layout/type (diff) | |
| download | slx-admin-d072920a676743dd4ba9d4cc4af080eee9809a01.tar.gz slx-admin-d072920a676743dd4ba9d4cc4af080eee9809a01.tar.xz slx-admin-d072920a676743dd4ba9d4cc4af080eee9809a01.zip | |
[exams] Show list of upcomfing exam lectures; allow adding exam period based on upcoming exam
Diffstat (limited to 'modules-available/exams/install.inc.php')
| -rw-r--r-- | modules-available/exams/install.inc.php | 5 |
1 files changed, 5 insertions, 0 deletions
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)) { |