Updated Branches: refs/heads/4.0 3f1f366c9 -> b04ac1d3b
Backport from master Project: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/commit/b04ac1d3 Tree: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/tree/b04ac1d3 Diff: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/diff/b04ac1d3 Branch: refs/heads/4.0 Commit: b04ac1d3bbbd74aed17cf1114942f5a6ff8e792e Parents: 3f1f366 Author: Hugo Trippaers <[email protected]> Authored: Mon Aug 27 09:24:12 2012 +0200 Committer: Hugo Trippaers <[email protected]> Committed: Mon Aug 27 09:24:12 2012 +0200 ---------------------------------------------------------------------- setup/db/db/schema-302to40.sql | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/blob/b04ac1d3/setup/db/db/schema-302to40.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-302to40.sql b/setup/db/db/schema-302to40.sql index 4ba6344..977505e 100644 --- a/setup/db/db/schema-302to40.sql +++ b/setup/db/db/schema-302to40.sql @@ -237,7 +237,7 @@ ALTER TABLE physical_network_service_providers DROP FOREIGN KEY fk_pnetwork_serv SET @constraintname = (select CONCAT(CONCAT('DROP INDEX ', A.CONSTRAINT_NAME), ' ON physical_network_service_providers' ) from information_schema.key_column_usage A JOIN information_schema.key_column_usage B ON B.table_name = 'physical_network_service_providers' AND B.COLUMN_NAME = 'provider_name' AND A.COLUMN_NAME ='physical_network_id' AND B.CONSTRAINT_NAME=A.CONSTRAINT_NAME -where A.table_name = 'physical_network_service_providers'); +where A.table_name = 'physical_network_service_providers' LIMIT 1); PREPARE stmt1 FROM @constraintname; EXECUTE stmt1;
