You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by ed...@apache.org on 2013/12/20 00:06:45 UTC
[02/10] git commit: updated refs/heads/master to 62bb5d8
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 <su...@gmail.com>
Authored: Tue Dec 3 13:04:35 2013 -0800
Committer: Edison Su <su...@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,