[jira] [Created] (CLOUDSTACK-2612) some typo in schema-302to40.sql

["Tomasz Zieba (JIRA)" <ji...@apache.org>]

Tomasz Zieba created CLOUDSTACK-2612:
----------------------------------------

             Summary: some typo in schema-302to40.sql
                 Key: CLOUDSTACK-2612
                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-2612
             Project: CloudStack
          Issue Type: Bug
      Security Level: Public (Anyone can view this level - this is the default.)
    Affects Versions: 4.0.2
         Environment: upgrade from CS 3.0.2 to CS 4.0.2
            Reporter: Tomasz Zieba


Please change the following lines to make upgrade successful:

/usr/share/cloud/setup/db/schema-302to40.sql

137c137
< DELETE FROM `cloud`.`storage_pool_host_ref` WHERE pool_id IN (SELECT id FROM storage_pool WHERE removed IS NOT NULL);
---
> DELETE FROM `cloud`.`storage_pool_host_ref` WHERE pool_id IN (SELECT id FROM cloud.storage_pool WHERE removed IS NOT NULL);
182c182
< DELETE FROM `cloud`.`storage_pool_host_ref` WHERE pool_id IN (SELECT id FROM storage_pool WHERE removed IS NOT NULL);
---
> DELETE FROM `cloud`.`storage_pool_host_ref` WHERE pool_id IN (SELECT id FROM cloud.storage_pool WHERE removed IS NOT NULL);
189c189
< ALTER TABLE `storage_pool` ADD `user_info` VARCHAR( 255 ) NULL COMMENT 'Authorization information for the storage pool. Used by network filesystems' AFTER `host_address`;
---
> ALTER TABLE `cloud`.`storage_pool` ADD `user_info` VARCHAR( 255 ) NULL COMMENT 'Authorization information for the storage pool. Used by network filesystems' AFTER `host_address`;
235c235
< ALTER TABLE physical_network_service_providers DROP FOREIGN KEY fk_pnetwork_service_providers__physical_network_id;
---
> ALTER TABLE `cloud`.`physical_network_service_providers` DROP FOREIGN KEY fk_pnetwork_service_providers__physical_network_id;
237c237
< SET @constraintname = (select CONCAT(CONCAT('DROP INDEX ', A.CONSTRAINT_NAME), ' ON physical_network_service_providers' )
---
> SET @constraintname = (select CONCAT(CONCAT('DROP INDEX ', A.CONSTRAINT_NAME), ' ON cloud.physical_network_service_providers' )
246c246
< AlTER TABLE physical_network_service_providers ADD CONSTRAINT `fk_pnetwork_service_providers__physical_network_id` FOREIGN KEY (`physical_network_id`) REFERENCES `physical_network`(`id`) ON DELETE CASCADE;
---
> AlTER TABLE `cloud`.`physical_network_service_providers` ADD CONSTRAINT `fk_pnetwork_service_providers__physical_network_id` FOREIGN KEY (`physical_network_id`) REFERENCES `cloud`.`physical_network`(`id`) ON DELETE CASCADE;
481,482d480
<
<


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira