summaryrefslogtreecommitdiffstats
path: root/dozentenmodulserver/setup
diff options
context:
space:
mode:
authorSimon Rettberg2015-09-10 18:51:20 +0200
committerSimon Rettberg2015-09-10 18:51:20 +0200
commit80af9ff6befbbe4204eab259c72c40df5cd5e5a1 (patch)
treef1c731d05841a6d2457db68b412f297d72edae76 /dozentenmodulserver/setup
parent[client] LectureDetails: moved fields around to keep the same order as in Ima... (diff)
downloadtutor-module-80af9ff6befbbe4204eab259c72c40df5cd5e5a1.tar.gz
tutor-module-80af9ff6befbbe4204eab259c72c40df5cd5e5a1.tar.xz
tutor-module-80af9ff6befbbe4204eab259c72c40df5cd5e5a1.zip
[server] Schema changes, distinct delete flag for images
Diffstat (limited to 'dozentenmodulserver/setup')
-rw-r--r--dozentenmodulserver/setup/sat-01-schema.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/dozentenmodulserver/setup/sat-01-schema.sql b/dozentenmodulserver/setup/sat-01-schema.sql
index d44b0ed2..c6caef39 100644
--- a/dozentenmodulserver/setup/sat-01-schema.sql
+++ b/dozentenmodulserver/setup/sat-01-schema.sql
@@ -75,6 +75,7 @@ CREATE TABLE IF NOT EXISTS `imageversion` (
`isprocessed` tinyint(1) NOT NULL,
`mastersha1` binary(20) DEFAULT NULL,
`virtualizerconfig` blob NULL DEFAULT NULL COMMENT 'Specific configuration of the virtualizer for this image. For vmware, this is basically a dump of the *.vmx.',
+ `deletestate` ENUM( 'KEEP', 'SHOULD_DELETE', 'WANT_DELETE' ) CHARACTER SET ascii COLLATE ascii_bin NOT NULL DEFAULT 'KEEP'
PRIMARY KEY (`imageversionid`),
KEY `version_access` (`imagebaseid`,`isvalid`,`createtime`),
KEY `fk_imageversion_2_idx` (`uploaderid`),