Updated Branches: refs/heads/4.1 4612656de -> 63c14d614
CLOUDSTACK-3005: fix template_spool_ref.local_patch error after upgrade from 2.2.14 to 3.X Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/63c14d61 Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/63c14d61 Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/63c14d61 Branch: refs/heads/4.1 Commit: 63c14d6142ee1903eb2f55518f79ae4dd0b4d343 Parents: 4612656 Author: Wei Zhou <[email protected]> Authored: Fri Jun 14 10:32:47 2013 +0200 Committer: Wei Zhou <[email protected]> Committed: Fri Jun 14 10:33:21 2013 +0200 ---------------------------------------------------------------------- setup/db/db/schema-2214to30.sql | 1 + 1 file changed, 1 insertion(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/cloudstack/blob/63c14d61/setup/db/db/schema-2214to30.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-2214to30.sql b/setup/db/db/schema-2214to30.sql index e288b0f..326e9a7 100755 --- a/setup/db/db/schema-2214to30.sql +++ b/setup/db/db/schema-2214to30.sql @@ -665,6 +665,7 @@ ALTER TABLE `cloud`.`dc_storage_network_ip_range` ADD COLUMN `gateway` varchar(1 ALTER TABLE `cloud`.`volumes` ADD COLUMN `last_pool_id` bigint unsigned; UPDATE `cloud`.`volumes` SET `last_pool_id` = `pool_id`; UPDATE `cloud`.`volumes` SET `path` = SUBSTRING_INDEX(`path`, '/', -1); +UPDATE `cloud`.`template_spool_ref` SET `local_path` = SUBSTRING_INDEX(`local_path`, '/', -1); ALTER TABLE `cloud`.`user_ip_address` ADD COLUMN `is_system` int(1) unsigned NOT NULL default '0'; ALTER TABLE `cloud`.`volumes` ADD COLUMN `update_count` bigint unsigned NOT NULL DEFAULT 0;
