diff options
author | Simon Rettberg | 2015-08-17 18:14:08 +0200 |
---|---|---|
committer | Simon Rettberg | 2015-08-17 18:14:08 +0200 |
commit | 76f13bf7a26b79b0f4a45ec7992c4bcd8eeb9ee6 (patch) | |
tree | 172aa0259d6172f9881e3c02b84b0bdf58bb890c /dozentenmodulserver/setup/sat-01-schema.sql | |
parent | [server] Switch to libthrift 0.9.2 (diff) | |
download | tutor-module-76f13bf7a26b79b0f4a45ec7992c4bcd8eeb9ee6.tar.gz tutor-module-76f13bf7a26b79b0f4a45ec7992c4bcd8eeb9ee6.tar.xz tutor-module-76f13bf7a26b79b0f4a45ec7992c4bcd8eeb9ee6.zip |
[server] Add TLS/SSL related classes and functionality (wip)
Diffstat (limited to 'dozentenmodulserver/setup/sat-01-schema.sql')
-rw-r--r-- | dozentenmodulserver/setup/sat-01-schema.sql | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/dozentenmodulserver/setup/sat-01-schema.sql b/dozentenmodulserver/setup/sat-01-schema.sql index 2919ff8a..6c517530 100644 --- a/dozentenmodulserver/setup/sat-01-schema.sql +++ b/dozentenmodulserver/setup/sat-01-schema.sql @@ -189,6 +189,12 @@ CREATE TABLE IF NOT EXISTS `lectureuser` ( PRIMARY KEY (`lectureid`, `userlogin`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; +CREATE TABLE IF NOT EXISTS `configuration` ( + `parameter` varchar(100) CHARACTER SET ascii NOT NULL, + `value` blob NOT NULL, + PRIMARY KEY (`parameter`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; + ALTER TABLE `lectureuser` ADD CONSTRAINT `fk_lectureuser_1` FOREIGN KEY (`lectureid`) REFERENCES `sat`.`lecture` (`lectureid`) ON DELETE CASCADE ON UPDATE CASCADE; |