Mailing-List: contact cloudstack-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cloudstack-dev@incubator.apache.org
Received-SPF: pass (nike.apache.org: domain of rohityadav89@gmail.com
 designates 74.125.83.49 as permitted sender)
MIME-Version: 1.0
Sender: rohityadav89@gmail.com
From: Rohit Yadav <bhaisaab@apache.org>
Date: Fri, 15 Feb 2013 16:28:06 +0530
Message-ID: 
 <CANLSSBXiCbytD2YrWD7p-hwbJpUrwPOc7SBR3VfL1ck9Ov=ihg@mail.gmail.com>
Subject: Merge 4.1-new-db-schema.sql to db/db/schema-40to410.sql
To: Edison Su <edison.su@citrix.com>, cloudstack-dev@incubator.apache.org
Cc: Sheng Yang <Sheng.Yang@citrix.com>, Alex Huang <Alex.Huang@citrix.com>,
	Kishan Kavala <Kishan.Kavala@citrix.com>, Min Chen <min.chen@citrix.com>
Content-Type: text/plain; charset=ISO-8859-1

Edison, you'd created a 4.1-new-db-schema sql, may I merge
4.1-new-db-schema.sql  to db/db/schema-40to410.sql? We'll also need a
db/db/schema-40to410-cleanup.sql and upgrading class.

There is some difference between the 4.0 create-schema.sql and that in
4.1: http://people.apache.org/~bhaisaab/diff-create-schema-40-41.sql

Alex suggested in last discussion that we should not change the schema
file and have upgrade paths and cleanup paths. This would help us do
rolling upgrades. But Alex, there are a lot of difference between the
4.0 schema and 4.1 schema sqls (about 4k lines of diff):
http://people.apache.org/~bhaisaab/diff4041sqls.sql If we don't want
developers to change anything in the schema files, how do you propose
we fix it now for 4.1? Move all these changes to 40to41 sql?

Sheng (ipv6), Kishan (regions), Vijay (autoscale) I see some create
schema changes, should we move them to db/db/schema-40to410.sql?

Min, the create-schema-view did not exist for 4.0, should we keep it
as it as, our move it as upgrade path?

For 4.1, we should do following changes so DatabaseCreator could be
refactored and used starting 4.2/master:
- Change version to 4.0 in create-schema
- Make sure there is difference between 4.0 and 4.1 create-schema sqls
- Move new additions to db/db/schema-40to410.sql, define a cleanup
path/sql and upgrading class from 40-41
- Fix cloudstack-setup-databases, for 4.1 we won't use
databasecreator, stick with the present script (won't risk regressions
and whatnot)

Regards.