Updated Branches: refs/heads/api_refactoring edb00bb61 -> c0a0318f2
setup/db: Fix missing semicolon in db create view command 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/c0a0318f Tree: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/tree/c0a0318f Diff: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/diff/c0a0318f Branch: refs/heads/api_refactoring Commit: c0a0318f29ad73c00793e98d24ab315dfea0a1e0 Parents: edb00bb Author: Rohit Yadav <[email protected]> Authored: Thu Jan 3 11:24:12 2013 -0800 Committer: Rohit Yadav <[email protected]> Committed: Thu Jan 3 11:24:12 2013 -0800 ---------------------------------------------------------------------- setup/db/create-schema.sql | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/blob/c0a0318f/setup/db/create-schema.sql ---------------------------------------------------------------------- diff --git a/setup/db/create-schema.sql b/setup/db/create-schema.sql index 34ac66f..dcea142 100755 --- a/setup/db/create-schema.sql +++ b/setup/db/create-schema.sql @@ -3173,7 +3173,7 @@ CREATE VIEW free_ip_view AS select count(user_ip_address.id) free_ip from user_ip_address inner join vlan on vlan.id = user_ip_address.vlan_db_id and vlan.vlan_type = "VirtualNetwork" -where state = "Free" +where state = "Free"; DROP VIEW IF EXISTS `cloud`.`account_view`; CREATE VIEW account_view AS
