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