Updated Branches:
  refs/heads/planner_reserve 3a7893529 -> eb3911678

Renaming the index on op_host_planner_reservation


Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/eb391167
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/eb391167
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/eb391167

Branch: refs/heads/planner_reserve
Commit: eb39116789b3a272922b8741a12f162c25a51f49
Parents: 3a78935
Author: Prachi Damle <pra...@cloud.com>
Authored: Fri May 10 16:03:31 2013 -0700
Committer: Prachi Damle <pra...@cloud.com>
Committed: Fri May 10 16:03:31 2013 -0700

----------------------------------------------------------------------
 setup/db/db/schema-410to420.sql |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/cloudstack/blob/eb391167/setup/db/db/schema-410to420.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-410to420.sql b/setup/db/db/schema-410to420.sql
index 65ddaaa..86124ea 100644
--- a/setup/db/db/schema-410to420.sql
+++ b/setup/db/db/schema-410to420.sql
@@ -928,7 +928,7 @@ CREATE TABLE `cloud`.`op_host_planner_reservation` (
   `host_id` bigint unsigned,
   `resource_usage` varchar(255) COMMENT 'Shared(between planners) Vs Dedicated 
(exclusive usage to a planner)',
   PRIMARY KEY  (`id`),
-  INDEX `i_op_host_planner_reservation__host_type`(`host_id`, `resource_type`),
+  INDEX `i_op_host_planner_reservation__host_resource_usage`(`host_id`, 
`resource_usage`),
   CONSTRAINT `fk_planner_reservation__host_id` FOREIGN KEY (`host_id`) 
REFERENCES `host`(`id`) ON DELETE CASCADE,
   CONSTRAINT `fk_planner_reservation__data_center_id` FOREIGN KEY 
(`data_center_id`) REFERENCES `cloud`.`data_center`(`id`) ON DELETE CASCADE,
   CONSTRAINT `fk_planner_reservation__pod_id` FOREIGN KEY (`pod_id`) 
REFERENCES `cloud`.`host_pod_ref`(`id`) ON DELETE CASCADE,

Reply via email to