You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by ts...@apache.org on 2013/04/12 13:58:41 UTC
[08/50] [abbrv] git commit: updated refs/heads/marvin_refactor to
30e2971
Schema changes to create affinity group tables
Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/1ba6740f
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/1ba6740f
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/1ba6740f
Branch: refs/heads/marvin_refactor
Commit: 1ba6740fc1aa30a9111c8375e45646947962b384
Parents: d108fb4
Author: Prachi Damle <pr...@cloud.com>
Authored: Thu Mar 14 17:32:33 2013 -0700
Committer: Prachi Damle <pr...@cloud.com>
Committed: Thu Apr 11 13:22:49 2013 -0700
----------------------------------------------------------------------
setup/db/db/schema-410to420.sql | 23 +++++++++++++++++++++++
1 files changed, 23 insertions(+), 0 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/cloudstack/blob/1ba6740f/setup/db/db/schema-410to420.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-410to420.sql b/setup/db/db/schema-410to420.sql
index c7c8b5b..77bb8d6 100644
--- a/setup/db/db/schema-410to420.sql
+++ b/setup/db/db/schema-410to420.sql
@@ -142,6 +142,29 @@ CREATE TABLE `cloud`.`user_vm_clone_setting` (
INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'UserVmManager', 'vmware.create.full.clone' , 'false', 'If set to true, creates VMs as full clones on ESX hypervisor');
+CREATE TABLE `cloud`.`affinity_group` (
+ `id` bigint unsigned NOT NULL auto_increment,
+ `name` varchar(255) NOT NULL,
+ `type` varchar(255) NOT NULL,
+ `uuid` varchar(40),
+ `description` varchar(4096) NULL,
+ `domain_id` bigint unsigned NOT NULL,
+ `account_id` bigint unsigned NOT NULL,
+ UNIQUE (`name`, `account_id`),
+ PRIMARY KEY (`id`),
+ CONSTRAINT `fk_affinity_group__account_id` FOREIGN KEY(`account_id`) REFERENCES `account`(`id`),
+ CONSTRAINT `fk_affinity_group__domain_id` FOREIGN KEY(`domain_id`) REFERENCES `domain`(`id`),
+ CONSTRAINT `uc_affinity_group__uuid` UNIQUE (`uuid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+CREATE TABLE `cloud`.`affinity_group_vm_map` (
+ `id` bigint unsigned NOT NULL auto_increment,
+ `affinity_group_id` bigint unsigned NOT NULL,
+ `instance_id` bigint unsigned NOT NULL,
+ PRIMARY KEY (`id`),
+ CONSTRAINT `fk_agvm__group_id` FOREIGN KEY(`affinity_group_id`) REFERENCES `affinity_group`(`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
-- Re-enable foreign key checking, at the end of the upgrade path
SET foreign_key_checks = 1;