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,