Author: arkurth
Date: Tue Jun 28 19:15:12 2016
New Revision: 1750559
URL: http://svn.apache.org/viewvc?rev=1750559&view=rev
Log:
VCL-898
Updated schema to allow request.logid to be 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=1750559&r1=1750558&r2=1750559&view=diff
==============================================================================
--- vcl/trunk/mysql/update-vcl.sql (original)
+++ vcl/trunk/mysql/update-vcl.sql Tue Jun 28 19:15:12 2016
@@ -1202,6 +1202,15 @@ CREATE TABLE IF NOT EXISTS `provisioning
-- --------------------------------------------------------
--
+-- Table structure change for table `request`
+--
+
+ALTER TABLE `request` CHANGE `logid` `logid` int(10) unsigned default NULL;
+UPDATE `request` SET `logid` = NULL WHERE `logid` = 0;
+
+-- --------------------------------------------------------
+
+--
-- Table structure change for table `reservation`
--
Modified: vcl/trunk/mysql/vcl.sql
URL:
http://svn.apache.org/viewvc/vcl/trunk/mysql/vcl.sql?rev=1750559&r1=1750558&r2=1750559&view=diff
==============================================================================
--- vcl/trunk/mysql/vcl.sql (original)
+++ vcl/trunk/mysql/vcl.sql Tue Jun 28 19:15:12 2016
@@ -897,7 +897,7 @@ CREATE TABLE IF NOT EXISTS `request` (
`stateid` tinyint(3) unsigned NOT NULL default '0',
`userid` mediumint(8) unsigned NOT NULL default '0',
`laststateid` tinyint(3) unsigned NOT NULL default '0',
- `logid` int(10) unsigned NOT NULL default '0',
+ `logid` int(10) unsigned default NULL,
`forimaging` tinyint(1) unsigned NOT NULL default '0',
`test` tinyint(1) unsigned NOT NULL default '0',
`preload` tinyint(1) unsigned NOT NULL default '0',
