incubator-cloudstack-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kis...@apache.org
Subject git commit: CLOUDSTACK-560 : Add default zone column to account table in cloud_usage table in fresh install and upgrade
Date Mon, 10 Dec 2012 14:08:42 GMT
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 <kishan@cloud.com>
Authored: Mon Dec 10 19:37:57 2012 +0530
Committer: Kishan Kavala <kishan@cloud.com>
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;


Mime
View raw message