Author: jfthomps
Date: Thu Sep 16 17:54:42 2010
New Revision: 997866
URL: http://svn.apache.org/viewvc?rev=997866&view=rev
Log:
added comments field to blockRequest 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=997866&r1=997865&r2=997866&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/update-2.2.sql (original)
+++ incubator/vcl/trunk/mysql/update-2.2.sql Thu Sep 16 17:54:42 2010
@@ -215,6 +215,7 @@ CALL AddColumnIfNotExists('blockComputer
--
CALL AddColumnIfNotExists('blockRequest', 'status',
"enum('requested','accepted','completed','rejected','deleted') NOT NULL DEFAULT
'accepted'");
+CALL AddColumnIfNotExists('blockRequest', 'comments', "text");
-- --------------------------------------------------------
Modified: incubator/vcl/trunk/mysql/vcl.sql
URL:
http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/vcl.sql?rev=997866&r1=997865&r2=997866&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/vcl.sql (original)
+++ incubator/vcl/trunk/mysql/vcl.sql Thu Sep 16 17:54:42 2010
@@ -87,6 +87,7 @@ CREATE TABLE IF NOT EXISTS `blockRequest
`expireTime` datetime NOT NULL,
`processing` tinyint(1) unsigned NOT NULL,
`status` enum('requested','accepted','completed','rejected','deleted') NOT
NULL DEFAULT 'accepted',
+ `comments` text,
PRIMARY KEY (`id`),
KEY `imageid` (`imageid`),
KEY `groupid` (`groupid`),
