diff options
Diffstat (limited to 'dozentenmodulserver/setup/sat-01-schema.sql')
| -rw-r--r-- | dozentenmodulserver/setup/sat-01-schema.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/dozentenmodulserver/setup/sat-01-schema.sql b/dozentenmodulserver/setup/sat-01-schema.sql index 6a4e6800..f1d693fe 100644 --- a/dozentenmodulserver/setup/sat-01-schema.sql +++ b/dozentenmodulserver/setup/sat-01-schema.sql @@ -182,7 +182,8 @@ CREATE TABLE IF NOT EXISTS `user` ( `issuperuser` tinyint(1) NOT NULL DEFAULT '0', `emailnotifications` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`userid`), - KEY `fk_user_1_idx` (`organizationid`) + KEY `fk_user_1_idx` (`organizationid`), + KEY `mail_idx` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `virtualizer` ( |