http://git-wip-us.apache.org/repos/asf/cloudstack/blob/d47b4a99/setup/db/db/schema-412to420-cleanup.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-412to420-cleanup.sql b/setup/db/db/schema-412to420-cleanup.sql new file mode 100644 index 0000000..2a7ab6a --- /dev/null +++ b/setup/db/db/schema-412to420-cleanup.sql @@ -0,0 +1,26 @@ +-- Licensed to the Apache Software Foundation (ASF) under one +-- or more contributor license agreements. See the NOTICE file +-- distributed with this work for additional information +-- regarding copyright ownership. The ASF licenses this file +-- to you under the Apache License, Version 2.0 (the +-- "License"); you may not use this file except in compliance +-- with the License. You may obtain a copy of the License at +-- +-- http://www.apache.org/licenses/LICENSE-2.0 +-- +-- Unless required by applicable law or agreed to in writing, +-- software distributed under the License is distributed on an +-- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY +-- KIND, either express or implied. See the License for the +-- specific language governing permissions and limitations +-- under the License. + +--; +-- Schema cleanup from 4.1.0 to 4.2.0; +--; + +#have to drop the foreign key in order to delete primary key; will re-insert the foreign key later +ALTER TABLE `cloud`.`remote_access_vpn` DROP foreign key `fk_remote_access_vpn__vpn_server_addr_id`; +ALTER TABLE `cloud`.`remote_access_vpn` DROP primary key; +ALTER TABLE `cloud`.`remote_access_vpn` ADD primary key (`id`); +ALTER TABLE `cloud`.`remote_access_vpn` ADD CONSTRAINT `fk_remote_access_vpn__vpn_server_addr_id` FOREIGN KEY (`vpn_server_addr_id`) REFERENCES `user_ip_address` (`id`);
