diff options
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` ( |