Author: fapeeler Date: Wed May 9 19:11:51 2012 New Revision: 1336354 URL: http://svn.apache.org/viewvc?rev=1336354&view=rev Log: VCL-585 updated db schema for time_source variable
Modified: incubator/vcl/trunk/mysql/update-vcl.sql Modified: incubator/vcl/trunk/mysql/update-vcl.sql URL: http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/update-vcl.sql?rev=1336354&r1=1336353&r2=1336354&view=diff ============================================================================== --- incubator/vcl/trunk/mysql/update-vcl.sql (original) +++ incubator/vcl/trunk/mysql/update-vcl.sql Wed May 9 19:11:51 2012 @@ -777,6 +777,24 @@ CREATE TABLE IF NOT EXISTS `usergrouppri PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `variable` +-- + +CREATE TABLE IF NOT EXISTS `variable` ( + `id` smallint(5) unsigned NOT NULL auto_increment, + `name` varchar(128) NOT NULL, + `serialization` enum('none','yaml','phpserialize') NOT NULL default 'none', + `value` longtext NOT NULL, + `setby` varchar(128) default NULL, + `timestamp` datetime NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `name` (`name`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; + -- -------------------------------------------------------- -- @@ -1072,6 +1090,13 @@ INSERT IGNORE userpriv (usergroupid, pri -- -------------------------------------------------------- -- +-- Inserts for table `variable` +-- + +INSERT IGNORE INTO `variable` (`id`, `name`, `serialization`, `value`) VALUES (1, 'schema-version', 'none', '1'); +INSERT IGNORE INTO `variable` (`id`, `name`, `serialization`, `value`) VALUES (2, 'timesource|global', 'none','time.nist.gov,time-a.nist.gov,time-b.nist.gov,time.windows.com'); + +-- -- Inserts for table `vmprofile` -- @@ -1209,4 +1234,4 @@ DROP PROCEDURE IF EXISTS `AddConstraintI DROP PROCEDURE IF EXISTS `AddConnectMethodMapIfNotExists`; DROP PROCEDURE IF EXISTS `AddOrRenameColumn`; DROP PROCEDURE IF EXISTS `DropExistingConstraints`; -DROP PROCEDURE IF EXISTS `DropExistingIndices`; \ No newline at end of file +DROP PROCEDURE IF EXISTS `DropExistingIndices`;