From 80af9ff6befbbe4204eab259c72c40df5cd5e5a1 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Thu, 10 Sep 2015 18:51:20 +0200
Subject: [server] Schema changes, distinct delete flag for images

---
 dozentenmodulserver/setup/sat-01-schema.sql | 1 +
 1 file changed, 1 insertion(+)

(limited to 'dozentenmodulserver/setup')

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`),
-- 
cgit v1.2.3-55-g7522