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 D0E909CDC for ; Tue, 14 Aug 2012 00:07:20 +0000 (UTC) Received: (qmail 2604 invoked by uid 500); 14 Aug 2012 00:07:20 -0000 Delivered-To: apmail-incubator-cloudstack-dev-archive@incubator.apache.org Received: (qmail 2490 invoked by uid 500); 14 Aug 2012 00:07:20 -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 2470 invoked by uid 99); 14 Aug 2012 00:07:20 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Aug 2012 00:07:20 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of darren@godaddy.com designates 208.109.78.207 as permitted sender) Received: from [208.109.78.207] (HELO smtpoutwbe05.prod.mesa1.secureserver.net) (208.109.78.207) by apache.org (qpsmtpd/0.29) with SMTP; Tue, 14 Aug 2012 00:07:11 +0000 Received: (qmail 21371 invoked from network); 14 Aug 2012 00:06:48 -0000 Received: from unknown (HELO gem-wbe30.prod.mesa1.secureserver.net) (64.202.189.164) by smtpoutwbe05.prod.mesa1.secureserver.net with SMTP; 14 Aug 2012 00:06:48 -0000 Received: (qmail 3043 invoked by uid 99); 14 Aug 2012 00:06:48 -0000 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" X-Originating-IP: 172.19.45.147 User-Agent: Workspace Webmail 5.6.24 Message-Id: <20120813170647.d3d18d9a633cb81ed61112bf108fc615.0f7b7f6fc3.wbe@email00.secureserver.net> From: "Darren Shepherd" To: cloudstack-dev@incubator.apache.org Subject: schema maintenance Date: Mon, 13 Aug 2012 17:06:47 -0700 Mime-Version: 1.0 Has there been any talk about not maintaining a monolithic=0Acreate_schema.= sql and doing a more DB migrate style? From a=0Asupportability perspective= its way easier if your SQL is just always=0Adeltas from the last. For exa= mple, you ship version 1 and create=0Aschema1.sql. Version 2 you add some = stuff so you create a schema2.sql=0Athat adds what you need to the database= (just delta). So if somebody=0Ainstalls from scratch they run schema1.sql= and schema2.sql. If you=0Aalready have version 1, you just run schema2.sq= l.=0A=0AThis is an extremely common approach and cuts down the need to test= the=0ADB from scratch and upgrade.=0A=0ADarren=0A=0A=0A