You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by we...@apache.org on 2013/06/26 11:30:25 UTC
[15/25] git commit: updated refs/heads/advancedsg-leaseweb to c5383c8
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/5267975e
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/5267975e
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/5267975e
Branch: refs/heads/advancedsg-leaseweb
Commit: 5267975ef0410eed8380d5f71702d52bd37ab969
Parents: 64ef3c4
Author: Wei Zhou <w....@leaseweb.com>
Authored: Fri Jun 14 10:32:47 2013 +0200
Committer: Wei Zhou <w....@leaseweb.com>
Committed: Fri Jun 14 14:21:59 2013 +0200
----------------------------------------------------------------------
setup/db/db/schema-2214to30.sql | 1 +
1 file changed, 1 insertion(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/cloudstack/blob/5267975e/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;