Repository: cloudstack Updated Branches: refs/heads/master b61733d04 -> 701199fca
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 <[email protected]> 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/master Commit: e1e5e12aaa649c05f2d5bebe1bdaec00e284dcf0 Parents: 4f748e6 Author: Rohit Yadav <[email protected]> Authored: Sat Dec 6 05:54:39 2014 +0530 Committer: Rohit Yadav <[email protected]> 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
