cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CLOUDSTACK-2612) some typo in schema-302to40.sql
Date Thu, 23 May 2013 16:52:20 GMT

    [ https://issues.apache.org/jira/browse/CLOUDSTACK-2612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13665346#comment-13665346
] 

ASF subversion and git services commented on CLOUDSTACK-2612:
-------------------------------------------------------------

Commit cc492305cead9307b9959fa696e11f0fad415c0a in branch refs/heads/master from [~chipchilders]
[ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=cc49230 ]

CLOUDSTACK-2612: Correcting missing db qualifiers in schema-302to40.sql

Signed-off-by: Chip Childers <chip.childers@gmail.com>

                
> 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

Mime
View raw message