summaryrefslogtreecommitdiffstats
path: root/dozentenmodulserver/setup
diff options
context:
space:
mode:
Diffstat (limited to 'dozentenmodulserver/setup')
-rw-r--r--dozentenmodulserver/setup/sat-01-schema.sql3
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` (