Add AUTO_INCREMENT in details dao
Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/eb56c4d8 Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/eb56c4d8 Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/eb56c4d8 Branch: refs/heads/4.3 Commit: eb56c4d863d4d27e2d140185d12aa603ff5f44f8 Parents: 7722796 Author: edison su <[email protected]> Authored: Tue Dec 3 13:04:35 2013 -0800 Committer: edison su <[email protected]> Committed: Tue Dec 3 13:05:04 2013 -0800 ---------------------------------------------------------------------- setup/db/db/schema-421to430.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cloudstack/blob/eb56c4d8/setup/db/db/schema-421to430.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-421to430.sql b/setup/db/db/schema-421to430.sql index 45f874c..dae1d2c 100644 --- a/setup/db/db/schema-421to430.sql +++ b/setup/db/db/schema-421to430.sql @@ -45,7 +45,7 @@ ALTER TABLE `cloud`.`load_balancing_rules` ADD COLUMN `lb_protocol` VARCHAR(40); DROP TABLE IF EXISTS `cloud`.`vm_snapshot_details`; CREATE TABLE `cloud`.`vm_snapshot_details` ( - `id` bigint unsigned UNIQUE NOT NULL, + `id` bigint unsigned UNIQUE NOT NULL AUTO_INCREMENT, `vm_snapshot_id` bigint unsigned NOT NULL, `name` varchar(255) NOT NULL, `value` varchar(255) NOT NULL, @@ -54,7 +54,7 @@ CREATE TABLE `cloud`.`vm_snapshot_details` ( DROP TABLE IF EXISTS `cloud`.`snapshot_details`; CREATE TABLE `cloud`.`snapshot_details` ( - `id` bigint unsigned UNIQUE NOT NULL, + `id` bigint unsigned UNIQUE NOT NULL AUTO_INCREMENT, `snapshot_id` bigint unsigned NOT NULL, `name` varchar(255) NOT NULL, `value` varchar(255) NOT NULL,
