Author: jfthomps
Date: Wed Mar 21 18:16:12 2012
New Revision: 1303487

URL: http://svn.apache.org/viewvc?rev=1303487&view=rev
Log:
VCL-527
Allow users to reinstall newer revisions

added changelog.other for logging any change to a reservation that does not 
have an explicit field for the change

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

Modified: incubator/vcl/trunk/mysql/update-vcl.sql
URL: 
http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/update-vcl.sql?rev=1303487&r1=1303486&r2=1303487&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/update-vcl.sql (original)
+++ incubator/vcl/trunk/mysql/update-vcl.sql Wed Mar 21 18:16:12 2012
@@ -317,6 +317,14 @@ CALL AddColumnIfNotExists('blockTimes', 
 
 -- --------------------------------------------------------
 
+--
+--  Table structure for table `changelog`
+--
+
+CALL AddColumnIfNotExists('changelog', 'other', "varchar(255) default NULL");
+
+-- --------------------------------------------------------
+
 -- 
 --  Table structure for table `computer`
 --

Modified: incubator/vcl/trunk/mysql/vcl.sql
URL: 
http://svn.apache.org/viewvc/incubator/vcl/trunk/mysql/vcl.sql?rev=1303487&r1=1303486&r2=1303487&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/vcl.sql (original)
+++ incubator/vcl/trunk/mysql/vcl.sql Wed Mar 21 18:16:12 2012
@@ -161,6 +161,7 @@ CREATE TABLE IF NOT EXISTS `changelog` (
   `remoteIP` varchar(15) default NULL,
   `wasavailable` tinyint(1) unsigned default NULL,
   `timestamp` datetime NOT NULL default '0000-00-00 00:00:00',
+  `other` varchar(255) default NULL,
   PRIMARY KEY  (`id`),
   KEY `logid` (`logid`)
 ) ENGINE=InnoDB  DEFAULT CHARSET=latin1;


Reply via email to