diff options
author | Simon Rettberg | 2015-08-31 18:10:47 +0200 |
---|---|---|
committer | Simon Rettberg | 2015-08-31 18:10:47 +0200 |
commit | d31878bcf8ae7646ec5687e15599866c1bfda94d (patch) | |
tree | ebca77a0d5c19f341507d28b4c64fafc5963fa22 /dozentenmodulserver/setup/sat-01-schema.sql | |
parent | Merge branch 'v1.1' of git.openslx.org:openslx-ng/tutor-module into v1.1 (diff) | |
download | tutor-module-d31878bcf8ae7646ec5687e15599866c1bfda94d.tar.gz tutor-module-d31878bcf8ae7646ec5687e15599866c1bfda94d.tar.xz tutor-module-d31878bcf8ae7646ec5687e15599866c1bfda94d.zip |
[server] SMTP Mailing
Diffstat (limited to 'dozentenmodulserver/setup/sat-01-schema.sql')
-rw-r--r-- | dozentenmodulserver/setup/sat-01-schema.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/dozentenmodulserver/setup/sat-01-schema.sql b/dozentenmodulserver/setup/sat-01-schema.sql index dab97282..051ab485 100644 --- a/dozentenmodulserver/setup/sat-01-schema.sql +++ b/dozentenmodulserver/setup/sat-01-schema.sql @@ -196,6 +196,15 @@ CREATE TABLE IF NOT EXISTS `configuration` ( PRIMARY KEY (`parameter`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +CREATE TABLE IF NOT EXISTS `mailqueue` ( + `mailid` char(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, + `userid` char(36) CHARACTER SET ascii COLLATE ascii_bin NOT NULL, + `message` text NOT NULL, + `failcount` int(11) NOT NULL DEFAULT '0', + `dateline` bigint(20) NOT NULL, + PRIMARY KEY (`mailid`) +) 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; |