Return-Path: X-Original-To: apmail-incubator-cloudstack-dev-archive@minotaur.apache.org Delivered-To: apmail-incubator-cloudstack-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id CB5CA9D9C for ; Tue, 1 May 2012 00:48:00 +0000 (UTC) Received: (qmail 80322 invoked by uid 500); 1 May 2012 00:47:59 -0000 Delivered-To: apmail-incubator-cloudstack-dev-archive@incubator.apache.org Received: (qmail 80288 invoked by uid 500); 1 May 2012 00:47:59 -0000 Mailing-List: contact cloudstack-dev-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: cloudstack-dev@incubator.apache.org Delivered-To: mailing list cloudstack-dev@incubator.apache.org Received: (qmail 80277 invoked by uid 99); 1 May 2012 00:47:59 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 May 2012 00:47:59 +0000 X-ASF-Spam-Status: No, hits=-5.0 required=5.0 tests=RCVD_IN_DNSWL_HI,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of Prachi.Damle@citrix.com designates 66.165.176.89 as permitted sender) Received: from [66.165.176.89] (HELO SMTP.CITRIX.COM) (66.165.176.89) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 May 2012 00:47:53 +0000 X-IronPort-AV: E=Sophos;i="4.75,507,1330923600"; d="scan'208";a="24701527" Received: from sjcpmailmx02.citrite.net ([10.216.14.75]) by FTLPIPO01.CITRIX.COM with ESMTP/TLS/RC4-MD5; 30 Apr 2012 20:47:31 -0400 Received: from SJCPMAILBOX01.citrite.net ([10.216.4.73]) by SJCPMAILMX02.citrite.net ([10.216.14.75]) with mapi; Mon, 30 Apr 2012 17:47:30 -0700 From: Prachi Damle To: "cloudstack-dev@incubator.apache.org" Date: Mon, 30 Apr 2012 17:47:28 -0700 Subject: FW: [DB ALERT] prachi has made a change in database schema for 3.0.x branch Thread-Topic: [DB ALERT] prachi has made a change in database schema for 3.0.x branch Thread-Index: Ac0nLqjBDe6N/x/QQ8e7ZFlmHDFU9wAAoXwQ Message-ID: <7A92FF96DF135843B4B608FB576BFC3E011B255168E2@SJCPMAILBOX01.citrite.net> References: <20120430233519.8C5CC120C03@905-8.sjc.vmops.com> In-Reply-To: <20120430233519.8C5CC120C03@905-8.sjc.vmops.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: acceptlanguage: en-US Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 As part of the ec2-integration branch merge, DB schema has been changed as = below Run following to work with your existing mgmt. db. ALTER TABLE `cloud`.`account` ADD COLUMN `default_zone_id` bigint unsigned= ; ALTER TABLE `cloud`.`account` ADD CONSTRAINT `fk_account__default_zone_id`= FOREIGN KEY `fk_account__default_zone_id`(`default_zone_id`) REFERENCES `d= ata_center`(`id`) ON DELETE CASCADE; -Prachi =20 -----Original Message----- From: git@cloud.com [mailto:git@cloud.com]=20 Sent: Monday, April 30, 2012 4:35 PM To: #Cloud - Engineering Subject: [DB ALERT] prachi has made a change in database schema for 3.0.x b= ranch ---------CHANGES------------------ a/setup/db/create-schema.sql b/setup/db/create-schema.sql index 33eb7af..d= 7878f7 100755 --- a/setup/db/create-schema.sql +++ b/setup/db/create-schema.sql @@ -1232,8 +1232,10 @@ CREATE TABLE `cloud`.`account` ( `removed` datetime COMMENT 'date removed', `cleanup_needed` tinyint(1) NOT NULL default '0', `network_domain` varchar(255), + `default_zone_id` bigint unsigned, PRIMARY KEY (`id`), INDEX i_account__removed(`removed`), + CONSTRAINT `fk_account__default_zone_id` FOREIGN KEY=20 + `fk_account__default_zone_id`(`default_zone_id`) REFERENCES=20 + `data_center`(`id`) ON DELETE CASCADE, CONSTRAINT `uc_account__uuid` UNIQUE (`uuid`) ) ENGINE=3DInnoDB DEFAULT CHARSET=3Dutf8; =20