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: g...@cloud.com [mailto:g...@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;
