Author: arkurth
Date: Wed Mar 4 20:28:43 2015
New Revision: 1664136
URL: http://svn.apache.org/r1664136
Log:
VCL-174
Changed natlog.internalIPaddress column to nullable since
nathost.internalIPaddress can be null. The statement to update the natlog table
would fail if nathost.internalIPaddress was null.
Modified:
vcl/trunk/mysql/update-vcl.sql
vcl/trunk/mysql/vcl.sql
Modified: vcl/trunk/mysql/update-vcl.sql
URL:
http://svn.apache.org/viewvc/vcl/trunk/mysql/update-vcl.sql?rev=1664136&r1=1664135&r2=1664136&view=diff
==============================================================================
--- vcl/trunk/mysql/update-vcl.sql (original)
+++ vcl/trunk/mysql/update-vcl.sql Wed Mar 4 20:28:43 2015
@@ -1063,7 +1063,7 @@ CREATE TABLE IF NOT EXISTS `natlog` (
`nathostresourceid` mediumint(8) unsigned NOT NULL,
`publicIPaddress` varchar(15) NOT NULL,
`publicport` smallint(5) unsigned NOT NULL,
- `internalIPaddress` varchar(15) NOT NULL,
+ `internalIPaddress` varchar(15) DEFAULT NULL,
`internalport` smallint(5) unsigned NOT NULL,
`protocol` enum('TCP','UDP') NOT NULL DEFAULT 'TCP',
`timestamp` datetime NOT NULL,
Modified: vcl/trunk/mysql/vcl.sql
URL:
http://svn.apache.org/viewvc/vcl/trunk/mysql/vcl.sql?rev=1664136&r1=1664135&r2=1664136&view=diff
==============================================================================
--- vcl/trunk/mysql/vcl.sql (original)
+++ vcl/trunk/mysql/vcl.sql Wed Mar 4 20:28:43 2015
@@ -679,7 +679,7 @@ CREATE TABLE IF NOT EXISTS `natlog` (
`nathostresourceid` mediumint(8) unsigned NOT NULL,
`publicIPaddress` varchar(15) NOT NULL,
`publicport` smallint(5) unsigned NOT NULL,
- `internalIPaddress` varchar(15) NOT NULL,
+ `internalIPaddress` varchar(15) DEFAULT NULL,
`internalport` smallint(5) unsigned NOT NULL,
`protocol` enum('TCP','UDP') NOT NULL DEFAULT 'TCP',
`timestamp` datetime NOT NULL,
