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 2011/03/18 13:24:19 UTC
svn commit: r1082884 - in /incubator/vcl/trunk/mysql: update-vcl.sql vcl.sql
Author: jfthomps
Date: Fri Mar 18 12:24:19 2011
New Revision: 1082884
URL: http://svn.apache.org/viewvc?rev=1082884&view=rev
Log:
VCL-434
added hostcomputerid to sublog table
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=1082884&r1=1082883&r2=1082884&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/update-vcl.sql (original)
+++ incubator/vcl/trunk/mysql/update-vcl.sql Fri Mar 18 12:24:19 2011
@@ -332,6 +332,14 @@ CREATE TABLE IF NOT EXISTS `sitemaintena
-- --------------------------------------------------------
+--
+-- Table structure change for table `sublog`
+--
+
+CALL AddColumnIfNotExists('sublog', 'hostcomputerid', "smallint(5) unsigned default NULL");
+
+-- --------------------------------------------------------
+
--
-- 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=1082884&r1=1082883&r2=1082884&view=diff
==============================================================================
--- incubator/vcl/trunk/mysql/vcl.sql (original)
+++ incubator/vcl/trunk/mysql/vcl.sql Fri Mar 18 12:24:19 2011
@@ -898,6 +898,7 @@ CREATE TABLE IF NOT EXISTS `sublog` (
`IPaddress` varchar(15) default NULL,
`managementnodeid` smallint(5) unsigned NOT NULL default '0',
`predictivemoduleid` smallint(5) unsigned NOT NULL default '8',
+ `hostcomputerid` smallint(5) unsigned default NULL,
KEY `logid` (`logid`),
KEY `imageid` (`imageid`),
KEY `imagerevisionid` (`imagerevisionid`),