cloudstack-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bhais...@apache.org
Subject git commit: updated refs/heads/hotfix/CLOUDSTACK-6212 to e1e5e12
Date Sat, 06 Dec 2014 00:28:14 GMT
Repository: cloudstack
Updated Branches:
  refs/heads/hotfix/CLOUDSTACK-6212 [created] e1e5e12aa


CLOUDSTACK-6212: Let vm_instance table's ID field be unique and auto_increment

`vm_instance` table's id column is unique but does not auto_increment like other
resource tables. The fix simply alter the table's id column to have it
auto_increment which may avoid id conflicts in a multi-master mysql setup.

Signed-off-by: Rohit Yadav <rohit.yadav@shapeblue.com>


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

Branch: refs/heads/hotfix/CLOUDSTACK-6212
Commit: e1e5e12aaa649c05f2d5bebe1bdaec00e284dcf0
Parents: 4f748e6
Author: Rohit Yadav <rohit.yadav@shapeblue.com>
Authored: Sat Dec 6 05:54:39 2014 +0530
Committer: Rohit Yadav <rohit.yadav@shapeblue.com>
Committed: Sat Dec 6 05:54:39 2014 +0530

----------------------------------------------------------------------
 setup/db/db/schema-442to450.sql | 1 +
 1 file changed, 1 insertion(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/cloudstack/blob/e1e5e12a/setup/db/db/schema-442to450.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-442to450.sql b/setup/db/db/schema-442to450.sql
index d158c51..4469ecc 100644
--- a/setup/db/db/schema-442to450.sql
+++ b/setup/db/db/schema-442to450.sql
@@ -35,6 +35,7 @@ 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;
 
 DROP VIEW IF EXISTS `cloud`.`disk_offering_view`;
 CREATE VIEW `cloud`.`disk_offering_view` AS


Mime
View raw message