svn commit: r1336354 - /incubator/vcl/trunk/mysql/update-vcl.sql

[fapeeler]

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`;