cloudstack-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From wid...@apache.org
Subject [1/2] git commit: updated refs/heads/master to a741875
Date Fri, 28 Aug 2015 07:56:38 GMT
Repository: cloudstack
Updated Branches:
  refs/heads/master da9cc334a -> a7418751c


Fix schema-421to430.sql issue after MariaDB upgrade


Project: http://git-wip-us.apache.org/repos/asf/cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/cloudstack/commit/99786516
Tree: http://git-wip-us.apache.org/repos/asf/cloudstack/tree/99786516
Diff: http://git-wip-us.apache.org/repos/asf/cloudstack/diff/99786516

Branch: refs/heads/master
Commit: 99786516d7eb25fcf2e971bc3d2e7532a3a39b1f
Parents: da9cc33
Author: Wei Zhou <w.zhou@tech.leaseweb.com>
Authored: Thu Aug 27 16:21:22 2015 +0200
Committer: Wei Zhou <w.zhou@tech.leaseweb.com>
Committed: Thu Aug 27 16:21:22 2015 +0200

----------------------------------------------------------------------
 setup/db/db/schema-421to430.sql | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/cloudstack/blob/99786516/setup/db/db/schema-421to430.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-421to430.sql b/setup/db/db/schema-421to430.sql
index 3f2ad02..0a96ea0 100644
--- a/setup/db/db/schema-421to430.sql
+++ b/setup/db/db/schema-421to430.sql
@@ -111,8 +111,7 @@ CREATE TABLE `cloud`.`async_job_join_map` (
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 #realhostip changes, before changing table and adding default value
-UPDATE `cloud`.`configuration` SET value = CONCAT("*.",(SELECT `temptable`.`value` FROM (SELECT
* FROM `cloud`.`configuration` WHERE `name`="consoleproxy.url.domain") AS `temptable` WHERE
`temptable`.`name`="consoleproxy.url.domain")) WHERE `name`="consoleproxy.url.domain";
-UPDATE `cloud`.`configuration` SET `value` = CONCAT("*.",(SELECT `temptable`.`value` FROM
(SELECT * FROM `cloud`.`configuration` WHERE `name`="secstorage.ssl.cert.domain") AS `temptable`
WHERE `temptable`.`name`="secstorage.ssl.cert.domain")) WHERE `name`="secstorage.ssl.cert.domain";
+UPDATE `cloud`.`configuration` SET value=CONCAT("*.",value) WHERE `name`="consoleproxy.url.domain"
OR `name`="secstorage.ssl.cert.domain";
 
 ALTER TABLE `cloud`.`configuration` ADD COLUMN `default_value` VARCHAR(4095) COMMENT 'Default
value for a configuration parameter';
 ALTER TABLE `cloud`.`configuration` ADD COLUMN `updated` datetime COMMENT 'Time this was
updated by the server. null means this row is obsolete.';


Mime
View raw message