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/864c91ba Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/864c91ba Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/864c91ba Branch: refs/heads/master Commit: 864c91ba7fd7f2b7a1a25db34b770ff400c7c07b Parents: a3fade8 Author: edison su <sudi...@gmail.com> Authored: Tue Dec 3 13:04:35 2013 -0800 Committer: Edison Su <sudi...@gmail.com> Committed: Thu Dec 19 13:35:15 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/864c91ba/setup/db/db/schema-421to430.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-421to430.sql b/setup/db/db/schema-421to430.sql index e3e8f1c..e662429 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,
