Return-Path: X-Original-To: apmail-cloudstack-commits-archive@www.apache.org Delivered-To: apmail-cloudstack-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 8558C10330 for ; Tue, 3 Dec 2013 21:05:31 +0000 (UTC) Received: (qmail 48043 invoked by uid 500); 3 Dec 2013 21:05:31 -0000 Delivered-To: apmail-cloudstack-commits-archive@cloudstack.apache.org Received: (qmail 47993 invoked by uid 500); 3 Dec 2013 21:05:31 -0000 Mailing-List: contact commits-help@cloudstack.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cloudstack.apache.org Delivered-To: mailing list commits@cloudstack.apache.org Received: (qmail 47925 invoked by uid 99); 3 Dec 2013 21:05:31 -0000 Received: from tyr.zones.apache.org (HELO tyr.zones.apache.org) (140.211.11.114) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Dec 2013 21:05:31 +0000 Received: by tyr.zones.apache.org (Postfix, from userid 65534) id 1233891C11D; Tue, 3 Dec 2013 21:05:31 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: edison@apache.org To: commits@cloudstack.apache.org Date: Tue, 03 Dec 2013 21:05:32 -0000 Message-Id: <0480203cadc34a9a9c7358c632215648@git.apache.org> In-Reply-To: <02c2d7cf92b0471ca89531f1d68e6cff@git.apache.org> References: <02c2d7cf92b0471ca89531f1d68e6cff@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: [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 Authored: Tue Dec 3 13:04:35 2013 -0800 Committer: edison su 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,