For master branch only: As part of the awsapi component 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: Friday, May 25, 2012 2:13 PM To: #Cloud - Engineering Subject: [DB ALERT] prachi has made a change in database schema for master branch ---------CHANGES------------------ a/setup/db/create-schema.sql b/setup/db/create-schema.sql index 94cfafe..dd22564 100755 --- a/setup/db/create-schema.sql +++ b/setup/db/create-schema.sql @@ -1233,8 +1233,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; ---------CHANGES------------------ ---------COMMITS------------------ commit 74beef1012cdced032ee359b159b258c5e77cdc5 Author: prachi <pra...@cloud.com> Date: Fri May 25 14:35:31 2012 -0700 merge awsapi deps to master commit 49cdc2317bca206b48d6470713cad4fc59c51f48 Author: prachi <pra...@cloud.com> Date: Fri May 25 14:34:49 2012 -0700 merge awsapi build script changes to master commit 3fd17ae0290a632984c6599ac315062b756f1bea Author: prachi <pra...@cloud.com> Date: Fri May 25 14:33:22 2012 -0700 Merge awsapi related changes to CloudStack commit bc7dbd7d9681dc2729326ff78fb5fe586b336b25 Author: prachi <pra...@cloud.com> Date: Fri May 25 14:32:08 2012 -0700 Merging awsapi component to master commit 9aaaab0ebed00d28bf578aa20a7100ac6ce223d8 Author: prachi <pra...@cloud.com> Date: Fri May 25 14:30:37 2012 -0700 Merging awsapi-setup to master commit f1fae9d57f428e22437bc272cbbf604f8c9f91d7 Author: prachi <pra...@cloud.com> Date: Tue May 8 15:01:36 2012 -0700 CS-14753: When Vm is deployed with a Security Group , it also gets associated with the default security group. Changes: - StartVM needed to be changed to add default security group only when none is present. - DeployVm: createAdvancedSecurityGroupVirtualMachine changed to follow the same rule - add default SG only if none is specified. commit 0c1c9141f4b63e55dc7fea53b9acbfa74b249074 Author: prachi <pra...@cloud.com> Date: Wed Apr 11 15:58:36 2012 -0700 DeployVMCmd: Do not place the instance in default security group if groupId is provided ---------COMMITS------------------