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


Reply via email to