Hey Rohit, I don't think this is the right solution, we should not depend on the name of the database in the scripts themselves. All the other scripts use the prefix 'cloud.' to work around this. I would prefer it that way so admins can change stuff without have to go through the database scripts, like reading stuff into a test database.
Cheers, Hugo > -----Original Message----- > From: [email protected] [mailto:[email protected]] > Sent: Monday, February 11, 2013 12:13 PM > To: [email protected] > Subject: [1/2] git commit: refs/heads/4.1 - CLOUDSTACK-1226: Fix 4.1-new- > db-schema.sql, use cloud before exec statements > > CLOUDSTACK-1226: Fix 4.1-new-db-schema.sql, use cloud before exec > statements > > Signed-off-by: Rohit Yadav <[email protected]> > > > Project: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/repo > Commit: http://git-wip-us.apache.org/repos/asf/incubator- > cloudstack/commit/e3156a6e > Tree: http://git-wip-us.apache.org/repos/asf/incubator- > cloudstack/tree/e3156a6e > Diff: http://git-wip-us.apache.org/repos/asf/incubator- > cloudstack/diff/e3156a6e > > Branch: refs/heads/4.1 > Commit: e3156a6e16cee9ffeb5d757dd8a775236127410f > Parents: a880f47 > Author: Rohit Yadav <[email protected]> > Authored: Mon Feb 11 16:36:41 2013 +0530 > Committer: Rohit Yadav <[email protected]> > Committed: Mon Feb 11 16:42:48 2013 +0530 > > ---------------------------------------------------------------------- > setup/db/4.1-new-db-schema.sql | 2 ++ > 1 files changed, 2 insertions(+), 0 deletions(-) > ---------------------------------------------------------------------- > > > http://git-wip-us.apache.org/repos/asf/incubator- > cloudstack/blob/e3156a6e/setup/db/4.1-new-db-schema.sql > ---------------------------------------------------------------------- > diff --git a/setup/db/4.1-new-db-schema.sql b/setup/db/4.1-new-db- > schema.sql index e8bafa2..d60eca2 100644 > --- a/setup/db/4.1-new-db-schema.sql > +++ b/setup/db/4.1-new-db-schema.sql > @@ -15,6 +15,8 @@ > -- specific language governing permissions and limitations > -- under the License. > > +use cloud; > + > alter table vm_template add image_data_store_id bigint unsigned; alter > table vm_template add size bigint unsigned; alter table vm_template add > state varchar(255);
