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/03 22:05:32 UTC
[2/2] git commit: updated refs/heads/4.3 to eb56c4d
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 <su...@gmail.com>
Authored: Tue Dec 3 13:04:35 2013 -0800
Committer: edison su <su...@gmail.com>
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,