diff options
| author | Simon Rettberg | 2015-09-30 18:27:39 +0200 |
|---|---|---|
| committer | Simon Rettberg | 2015-09-30 18:27:39 +0200 |
| commit | 4547c2515a0a5fcd5700277d3a57e790ec5fba94 (patch) | |
| tree | f971333fe2441e8146e7ec7279f2e77d9a3e3aa4 /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-4547c2515a0a5fcd5700277d3a57e790ec5fba94.tar.gz tutor-module-4547c2515a0a5fcd5700277d3a57e790ec5fba94.tar.xz tutor-module-4547c2515a0a5fcd5700277d3a57e790ec5fba94.zip | |
[server] Fix detection of old imported users in DB
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` ( |