fix update issue in schema-40to410.sql
Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/64ef3c4c Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/64ef3c4c Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/64ef3c4c Branch: refs/heads/advancedsg-leaseweb Commit: 64ef3c4c206ad1fe9e5d3c584a190a3e7bdb3643 Parents: a1ae8d9 Author: Wei Zhou <[email protected]> Authored: Tue Jun 11 18:13:33 2013 +0200 Committer: Wei Zhou <[email protected]> Committed: Tue Jun 11 18:13:33 2013 +0200 ---------------------------------------------------------------------- setup/db/db/schema-40to410.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cloudstack/blob/64ef3c4c/setup/db/db/schema-40to410.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-40to410.sql b/setup/db/db/schema-40to410.sql index bb0537d..884ff11 100644 --- a/setup/db/db/schema-40to410.sql +++ b/setup/db/db/schema-40to410.sql @@ -1657,5 +1657,5 @@ UPDATE `cloud`.`configuration` set category='Advanced' where category='Advanced UPDATE `cloud`.`configuration` set category='Hidden' where category='Hidden '; #update shared sg enabled network with not null name in Advance Security Group enabled network -UPDATE `cloud`.`networks` set name='Shared SG enabled network', display_text='Shared SG enabled network' WHERE name IS null AND traffic_type='Guest' AND data_center_id IN (select id from data_center where networktype='Advanced' and is_~ +UPDATE `cloud`.`networks` set name='Shared SG enabled network', display_text='Shared SG enabled network' WHERE name IS null AND traffic_type='Guest' AND data_center_id IN (select id from data_center where networktype='Advanced' and is_security_group_enabled=1) AND acl_type='Domain';
