cloudstack-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From mc...@apache.org
Subject git commit: updated refs/heads/master to 0720139
Date Thu, 05 Sep 2013 21:51:56 GMT
Updated Branches:
  refs/heads/master 25281ae7a -> 072013911


Properly set template state to either Active or Inactive in
schema-420to430.sql.

Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/07201391
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/07201391
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/07201391

Branch: refs/heads/master
Commit: 072013911703c906ba6af0374d25afb494e74737
Parents: 25281ae
Author: Min Chen <min.chen@citrix.com>
Authored: Thu Sep 5 14:51:30 2013 -0700
Committer: Min Chen <min.chen@citrix.com>
Committed: Thu Sep 5 14:51:30 2013 -0700

----------------------------------------------------------------------
 setup/db/db/schema-420to430.sql | 4 ++++
 1 file changed, 4 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/cloudstack/blob/07201391/setup/db/db/schema-420to430.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-420to430.sql b/setup/db/db/schema-420to430.sql
index 7857886..44a884d 100644
--- a/setup/db/db/schema-420to430.sql
+++ b/setup/db/db/schema-420to430.sql
@@ -101,6 +101,10 @@ ALTER TABLE `cloud`.`disk_offering` ADD COLUMN `state` CHAR(40) NOT NULL
DEFAULT
 UPDATE `cloud`.`disk_offering` SET `state`='Inactive' WHERE `removed` IS NOT NULL;
 UPDATE `cloud`.`disk_offering` SET `removed`=NULL;
 
+UPDATE `cloud`.`vm_template` SET `state`='Inactive' WHERE `removed` IS NOT NULL;
+UPDATE `cloud`.`vm_template` SET `state`='Active' WHERE `removed` IS NULL;
+UPDATE `cloud`.`vm_template` SET `removed`=NULL;
+
 DROP VIEW IF EXISTS `cloud`.`disk_offering_view`;
 CREATE VIEW `cloud`.`disk_offering_view` AS
     select


Mime
View raw message