Repository: cloudstack Updated Branches: refs/heads/hotfix/CLOUDSTACK-6212 e1e5e12aa -> a11ddf307
CLOUDSTACK-6212: auto_increment for some other resource tables This fix alters table columns which are primary keys but don't have them auto_increment such as region, domain_router, user_vm etc. Signed-off-by: Rohit Yadav <rohit.ya...@shapeblue.com> Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/a11ddf30 Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/a11ddf30 Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/a11ddf30 Branch: refs/heads/hotfix/CLOUDSTACK-6212 Commit: a11ddf307747ef03785c27519fb535a36d4be145 Parents: e1e5e12 Author: Rohit Yadav <rohit.ya...@shapeblue.com> Authored: Sat Dec 6 06:26:31 2014 +0530 Committer: Rohit Yadav <rohit.ya...@shapeblue.com> Committed: Sat Dec 6 06:26:31 2014 +0530 ---------------------------------------------------------------------- setup/db/db/schema-442to450.sql | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cloudstack/blob/a11ddf30/setup/db/db/schema-442to450.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-442to450.sql b/setup/db/db/schema-442to450.sql index 4469ecc..3981415 100644 --- a/setup/db/db/schema-442to450.sql +++ b/setup/db/db/schema-442to450.sql @@ -35,7 +35,15 @@ CREATE VIEW `cloud`.`storage_tag_view` AS ALTER TABLE `cloud`.`volumes` ADD COLUMN `provisioning_type` VARCHAR(32) NOT NULL DEFAULT 'thin' COMMENT 'pre allocation setting of the volume'; ALTER TABLE `cloud`.`disk_offering` ADD COLUMN `provisioning_type` VARCHAR(32) NOT NULL DEFAULT 'thin' COMMENT 'pre allocation setting of the volume'; -ALTER TABLE `cloud`.`vm_instance` MODIFY id bigint unsigned AUTO_INCREMENT UNIQUE NOT NULL; + +-- Have primary keys of following table AUTO_INCREMENT +ALTER TABLE `cloud`.`region` MODIFY `id` int unsigned AUTO_INCREMENT UNIQUE NOT NULL; +ALTER TABLE `cloud`.`vm_instance` MODIFY `id` bigint unsigned AUTO_INCREMENT UNIQUE NOT NULL; +ALTER TABLE `cloud`.`user_vm` MODIFY `id` bigint unsigned AUTO_INCREMENT UNIQUE NOT NULL; +ALTER TABLE `cloud`.`domain_router` MODIFY `id` bigint unsigned AUTO_INCREMENT UNIQUE NOT NULL; +ALTER TABLE `cloud`.`service_offering` MODIFY `id` bigint unsigned AUTO_INCREMENT NOT NULL; +ALTER TABLE `cloud`.`load_balancing_rules` MODIFY `id` bigint unsigned AUTO_INCREMENT NOT NULL; +ALTER TABLE `cloud`.`port_forwarding_rules` MODIFY `id` bigint unsigned AUTO_INCREMENT NOT NULL; DROP VIEW IF EXISTS `cloud`.`disk_offering_view`; CREATE VIEW `cloud`.`disk_offering_view` AS
