Updated Branches: refs/heads/master 540524267 -> 199806c1b
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/199806c1 Tree: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/tree/199806c1 Diff: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/diff/199806c1 Branch: refs/heads/master Commit: 199806c1be28c9706090d55c63ffb814c3cb80be Parents: 5405242 Author: Kishan Kavala <[email protected]> Authored: Mon Dec 10 19:37:57 2012 +0530 Committer: Kishan Kavala <[email protected]> Committed: Mon Dec 10 19:37:57 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/199806c1/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/199806c1/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;
