2.1.x-2.2.x upgrade: in "volumes" table use state=Destroy instead of "Destroyed"

alena11081 · alena11081 · commit 7f473dad6fb2 · 2011-04-15T11:45:55.000-07:00
diff --git a/setup/db/db/schema-21to22.sql b/setup/db/db/schema-21to22.sql
@@ -270,7 +270,7 @@ ALTER TABLE `cloud`.`volumes` ADD COLUMN `chain_info` text;
 ALTER TABLE `cloud`.`volumes` MODIFY COLUMN `volume_type` VARCHAR(64) NOT NULL;
 
 ALTER TABLE `cloud`.`volumes` ADD COLUMN `state` VARCHAR(32);
-UPDATE `cloud`.`volumes` SET state='Destroyed' WHERE removed IS NOT NULL OR destroyed=1 OR status='Creating' OR status='Corrupted' OR status='Failed';
+UPDATE `cloud`.`volumes` SET state='Destroy' WHERE removed IS NOT NULL OR destroyed=1 OR status='Creating' OR status='Corrupted' OR status='Failed';
 UPDATE `cloud`.`volumes` SET state='Ready' WHERE removed IS NULL AND (destroyed=0 OR destroyed is NULL) AND status='Created';
 ALTER TABLE `cloud`.`volumes` MODIFY COLUMN `state` VARCHAR(32) NOT NULL;
 
