FW: [DB ALERT] prachi has made a change in database schema for 3.0.x branch

[Prachi Damle <Pr...@citrix.com>]

As part of the ec2-integration branch merge, DB schema has been changed as below

Run following to work with your existing mgmt. db.

ALTER TABLE `cloud`.`account`  ADD COLUMN `default_zone_id` bigint unsigned;
ALTER TABLE `cloud`.`account`  ADD CONSTRAINT `fk_account__default_zone_id` FOREIGN KEY `fk_account__default_zone_id`(`default_zone_id`) REFERENCES `data_center`(`id`) ON DELETE CASCADE;


-Prachi
 

-----Original Message-----
From: git@cloud.com [mailto:git@cloud.com] 
Sent: Monday, April 30, 2012 4:35 PM
To: #Cloud - Engineering
Subject: [DB ALERT] prachi has made a change in database schema for 3.0.x branch

---------CHANGES------------------
 a/setup/db/create-schema.sql b/setup/db/create-schema.sql index 33eb7af..d7878f7 100755
--- a/setup/db/create-schema.sql
+++ b/setup/db/create-schema.sql
@@ -1232,8 +1232,10 @@ CREATE TABLE  `cloud`.`account` (
   `removed` datetime COMMENT 'date removed',
   `cleanup_needed` tinyint(1) NOT NULL default '0',
   `network_domain` varchar(255),
+  `default_zone_id` bigint unsigned,
   PRIMARY KEY  (`id`),
   INDEX i_account__removed(`removed`),
+  CONSTRAINT `fk_account__default_zone_id` FOREIGN KEY 
+ `fk_account__default_zone_id`(`default_zone_id`) REFERENCES 
+ `data_center`(`id`) ON DELETE CASCADE,
   CONSTRAINT `uc_account__uuid` UNIQUE (`uuid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;