Author: arkurth
Date: Mon Jan 5 16:13:54 2015
New Revision: 1649569
URL: http://svn.apache.org/r1649569
Log:
VCL-764
Changed computerloadlog.loadstateid to not allow null values.
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=1649569&r1=1649568&r2=1649569&view=diff
==============================================================================
--- vcl/trunk/mysql/update-vcl.sql (original)
+++ vcl/trunk/mysql/update-vcl.sql Mon Jan 5 16:13:54 2015
@@ -804,6 +804,8 @@ UPDATE computer SET datedeleted = NOW()
CALL AddIndexIfNotExists('computerloadlog', 'loadstateid');
CALL AddIndexIfNotExists('computerloadlog', 'computerid');
+ALTER TABLE `computerloadlog` CHANGE `loadstateid` `loadstateid` SMALLINT( 8 )
UNSIGNED NOT NULL;
+
-- --------------------------------------------------------
--
Modified: vcl/trunk/mysql/vcl.sql
URL:
http://svn.apache.org/viewvc/vcl/trunk/mysql/vcl.sql?rev=1649569&r1=1649568&r2=1649569&view=diff
==============================================================================
--- vcl/trunk/mysql/vcl.sql (original)
+++ vcl/trunk/mysql/vcl.sql Mon Jan 5 16:13:54 2015
@@ -279,7 +279,7 @@ CREATE TABLE IF NOT EXISTS `computerload
`id` int(12) unsigned NOT NULL auto_increment,
`reservationid` mediumint(8) unsigned NOT NULL,
`computerid` smallint(8) unsigned NOT NULL,
- `loadstateid` smallint(8) unsigned default NULL,
+ `loadstateid` smallint(8) unsigned NOT NULL,
`timestamp` datetime default NULL,
`additionalinfo` text,
PRIMARY KEY (`id`),
