Author: arkurth
Date: Thu May 28 17:47:56 2009
New Revision: 779696
URL: http://svn.apache.org/viewvc?rev=779696&view=rev
Log:
Added definition for variable table to vcl.sql.
Modified:
incubator/vcl/trunk/mysql/vcl.sql
Modified: incubator/vcl/trunk/mysql/vcl.sql
URL:
http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/vcl.sql?rev=779696&r1=779695&r2=779696&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/vcl.sql (original)
+++ incubator/vcl/trunk/mysql/vcl.sql Thu May 28 17:47:56 2009
@@ -990,6 +990,22 @@
-- --------------------------------------------------------
+--
+-- Table structure for table `variable`
+--
+
+CREATE TABLE IF NOT EXISTS `variable` (
+ `id` smallint(5) unsigned NOT NULL auto_increment,
+ `name` varchar(128) NOT NULL,
+ `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 AUTO_INCREMENT=1 ;
+
+-- --------------------------------------------------------
+
--
-- Table structure for table `vmhost`
--
