You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@vcl.apache.org by jf...@apache.org on 2012/03/21 19:16:12 UTC
svn commit: r1303487 - in /incubator/vcl/trunk/mysql: update-vcl.sql vcl.sql
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;