Author: jfthomps
Date: Tue Mar 31 13:40:40 2015
New Revision: 1670339
URL: http://svn.apache.org/r1670339
Log:
update-vcl.sql: modified insert into provisioning table for OpenNebula, changes
subselect to select from "module" instead of "vcl.module" for sites where the
vcl database name is not "vcl"
Modified:
vcl/trunk/mysql/update-vcl.sql
Modified: vcl/trunk/mysql/update-vcl.sql
URL:
http://svn.apache.org/viewvc/vcl/trunk/mysql/update-vcl.sql?rev=1670339&r1=1670338&r2=1670339&view=diff
==============================================================================
--- vcl/trunk/mysql/update-vcl.sql (original)
+++ vcl/trunk/mysql/update-vcl.sql Tue Mar 31 13:40:40 2015
@@ -1649,7 +1649,7 @@ INSERT IGNORE INTO `provisioning` (`name
INSERT IGNORE INTO `provisioning` (`name`, `prettyname`, `moduleid`) VALUES
('libvirt','Libvirt Virtualization API', (SELECT `id` FROM `module` WHERE
`name` LIKE 'provisioning_libvirt'));
INSERT IGNORE INTO `provisioning` (`name`, `prettyname`, `moduleid`) VALUES
('none','None', (SELECT `id` FROM `module` WHERE `name` = 'base_module'));
INSERT IGNORE INTO `provisioning` (`name`, `prettyname`, `moduleid`) VALUES
('openstack', 'OpenStack Provisioning', (SELECT `id` FROM `module` WHERE `name`
LIKE 'provisioning_openstack'));
-INSERT IGNORE INTO `provisioning` (`name`, `prettyname`, `moduleid`) VALUES
('one', 'OpenNebula', (SELECT id FROM vcl.module where
name='provisioning_one'));
+INSERT IGNORE INTO `provisioning` (`name`, `prettyname`, `moduleid`) VALUES
('one', 'OpenNebula', (SELECT id FROM module where name='provisioning_one'));
UPDATE IGNORE `provisioning` SET `name` = 'xcat', `prettyname` = 'xCAT' WHERE
`name` = 'xcat_13';
