diff options
author | Simon Rettberg | 2015-09-10 18:51:20 +0200 |
---|---|---|
committer | Simon Rettberg | 2015-09-10 18:51:20 +0200 |
commit | 80af9ff6befbbe4204eab259c72c40df5cd5e5a1 (patch) | |
tree | f1c731d05841a6d2457db68b412f297d72edae76 /dozentenmodulserver/setup | |
parent | [client] LectureDetails: moved fields around to keep the same order as in Ima... (diff) | |
download | tutor-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.sql | 1 |
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`), |