Updated Branches: refs/heads/4.0 3ced4584e -> 91a9cce35
CLOUDSTACK-560 : Add default zone column to account table in cloud_usage table in fresh install and upgrade Project: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/commit/91a9cce3 Tree: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/tree/91a9cce3 Diff: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/diff/91a9cce3 Branch: refs/heads/4.0 Commit: 91a9cce35a67350c856bb10e5fe36f4bf5bac029 Parents: 3ced458 Author: Kishan Kavala <[email protected]> Authored: Mon Dec 10 19:37:57 2012 +0530 Committer: Kishan Kavala <[email protected]> Committed: Mon Dec 10 19:39:59 2012 +0530 ---------------------------------------------------------------------- setup/db/create-schema-premium.sql | 1 + setup/db/db/schema-302to40.sql | 1 + 2 files changed, 2 insertions(+), 0 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/blob/91a9cce3/setup/db/create-schema-premium.sql ---------------------------------------------------------------------- diff --git a/setup/db/create-schema-premium.sql b/setup/db/create-schema-premium.sql index d84718e..2f86c0b 100644 --- a/setup/db/create-schema-premium.sql +++ b/setup/db/create-schema-premium.sql @@ -136,6 +136,7 @@ CREATE TABLE `cloud_usage`.`account` ( `removed` datetime COMMENT 'date removed', `cleanup_needed` tinyint(1) NOT NULL default '0', `network_domain` varchar(100) COMMENT 'Network domain name of the Vms of the account', + `default_zone_id` bigint unsigned, CONSTRAINT `uc_account__uuid` UNIQUE (`uuid`), PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/blob/91a9cce3/setup/db/db/schema-302to40.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-302to40.sql b/setup/db/db/schema-302to40.sql index 0c4efa3..a947ac1 100644 --- a/setup/db/db/schema-302to40.sql +++ b/setup/db/db/schema-302to40.sql @@ -477,3 +477,4 @@ INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'manag UPDATE `cloud`.`configuration` set description ='Uuid of the service offering used by console proxy; if NULL - system offering will be used' where name ='consoleproxy.service.offering'; UPDATE `cloud`.`user` SET PASSWORD=RAND() WHERE id=1; +ALTER TABLE `cloud_usage`.`account` ADD COLUMN `default_zone_id` bigint unsigned;
