cloudstack-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Prachi Damle <Prachi.Da...@citrix.com>
Subject FW: [DB ALERT] prachi has made a change in database schema for master branch
Date Fri, 25 May 2012 21:52:31 GMT
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: git@cloud.com [mailto:git@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 <prachi@cloud.com>
Date:   Fri May 25 14:35:31 2012 -0700

    merge awsapi deps to master

commit 49cdc2317bca206b48d6470713cad4fc59c51f48
Author: prachi <prachi@cloud.com>
Date:   Fri May 25 14:34:49 2012 -0700

    merge awsapi build script changes to master

commit 3fd17ae0290a632984c6599ac315062b756f1bea
Author: prachi <prachi@cloud.com>
Date:   Fri May 25 14:33:22 2012 -0700

    Merge awsapi related changes to CloudStack

commit bc7dbd7d9681dc2729326ff78fb5fe586b336b25
Author: prachi <prachi@cloud.com>
Date:   Fri May 25 14:32:08 2012 -0700

    Merging awsapi component to master

commit 9aaaab0ebed00d28bf578aa20a7100ac6ce223d8
Author: prachi <prachi@cloud.com>
Date:   Fri May 25 14:30:37 2012 -0700

    Merging awsapi-setup to master

commit f1fae9d57f428e22437bc272cbbf604f8c9f91d7
Author: prachi <prachi@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 <prachi@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------------------


Mime
View raw message