Author: jfthomps
Date: Thu Sep  2 17:11:30 2010
New Revision: 992023

URL: http://svn.apache.org/viewvc?rev=992023&view=rev
Log:
VCL-208
Ability to easily put the VCL site into a maintenance state

added CREATE TABLE's for sitemaintenance table

Modified:
    incubator/vcl/trunk/mysql/update-2.2.sql
    incubator/vcl/trunk/mysql/vcl.sql

Modified: incubator/vcl/trunk/mysql/update-2.2.sql
URL: 
http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/update-2.2.sql?rev=992023&r1=992022&r2=992023&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/update-2.2.sql (original)
+++ incubator/vcl/trunk/mysql/update-2.2.sql Thu Sep  2 17:11:30 2010
@@ -299,6 +299,28 @@ CALL AddUniqueIndex('provisioning', 'nam
 
 -- --------------------------------------------------------
 
+--
+-- Table structure for table `sitemaintenance`
+--
+
+CREATE TABLE IF NOT EXISTS `sitemaintenance` (
+  `id` smallint(5) unsigned NOT NULL auto_increment,
+  `start` datetime NOT NULL,
+  `end` datetime NOT NULL,
+  `ownerid` mediumint(8) unsigned NOT NULL,
+  `created` datetime NOT NULL,
+  `reason` text,
+  `usermessage` text NOT NULL,
+  `informhoursahead` smallint(5) unsigned NOT NULL,
+  `allowreservations` tinyint(1) unsigned NOT NULL,
+  PRIMARY KEY  (`id`),
+  KEY `start` (`start`),
+  KEY `end` (`end`),
+  KEY `ownerid` (`ownerid`)
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
 -- 
 -- Table structure change for table `request`
 -- 

Modified: incubator/vcl/trunk/mysql/vcl.sql
URL: 
http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/vcl.sql?rev=992023&r1=992022&r2=992023&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/vcl.sql (original)
+++ incubator/vcl/trunk/mysql/vcl.sql Thu Sep  2 17:11:30 2010
@@ -825,6 +825,28 @@ CREATE TABLE IF NOT EXISTS `shibauth` (
 -- --------------------------------------------------------
 
 --
+-- Table structure for table `sitemaintenance`
+--
+
+CREATE TABLE IF NOT EXISTS `sitemaintenance` (
+  `id` smallint(5) unsigned NOT NULL auto_increment,
+  `start` datetime NOT NULL,
+  `end` datetime NOT NULL,
+  `ownerid` mediumint(8) unsigned NOT NULL,
+  `created` datetime NOT NULL,
+  `reason` text,
+  `usermessage` text NOT NULL,
+  `informhoursahead` smallint(5) unsigned NOT NULL,
+  `allowreservations` tinyint(1) unsigned NOT NULL,
+  PRIMARY KEY  (`id`),
+  KEY `start` (`start`),
+  KEY `end` (`end`),
+  KEY `ownerid` (`ownerid`)
+) ENGINE=InnoDB  DEFAULT CHARSET=latin1;
+
+-- --------------------------------------------------------
+
+--
 -- Table structure for table `state`
 -- 
 


Reply via email to