diff options
author | Simon Rettberg | 2015-09-16 10:32:43 +0200 |
---|---|---|
committer | Simon Rettberg | 2015-09-16 10:32:43 +0200 |
commit | 19332a7b0e67c0d7a2c813431d2a4e24c22075e5 (patch) | |
tree | 093f9ff6e240615e09faa13e35798dc94e057d03 /dozentenmodulserver/setup | |
parent | Merge branch 'v1.1' of git.openslx.org:openslx-ng/tutor-module into v1.1 (diff) | |
download | tutor-module-19332a7b0e67c0d7a2c813431d2a4e24c22075e5.tar.gz tutor-module-19332a7b0e67c0d7a2c813431d2a4e24c22075e5.tar.xz tutor-module-19332a7b0e67c0d7a2c813431d2a4e24c22075e5.zip |
[server] Add missing index to imageversion table
Diffstat (limited to 'dozentenmodulserver/setup')
-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 eadd5e4d..6a4e6800 100644 --- a/dozentenmodulserver/setup/sat-01-schema.sql +++ b/dozentenmodulserver/setup/sat-01-schema.sql @@ -79,7 +79,8 @@ CREATE TABLE IF NOT EXISTS `imageversion` ( PRIMARY KEY (`imageversionid`), KEY `version_access` (`imagebaseid`,`isvalid`,`createtime`), KEY `fk_imageversion_2_idx` (`uploaderid`), - KEY `expire_index` (`expiretime`) + KEY `expire_index` (`expiretime`), + KEY `deletestate` (`deletestate`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `imageversion_x_software` ( |