Author: fapeeler
Date: Wed Nov 12 15:23:31 2014
New Revision: 1638816
URL: http://svn.apache.org/r1638816
Log:
VCL-797
table structure edits for pw
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=1638816&r1=1638815&r2=1638816&view=diff
==============================================================================
--- vcl/trunk/mysql/update-vcl.sql (original)
+++ vcl/trunk/mysql/update-vcl.sql Wed Nov 12 15:23:31 2014
@@ -1055,6 +1055,7 @@ CREATE TABLE IF NOT EXISTS `provisioning
CALL AddColumnIfNotExists('reservation', 'connectIP', "varchar(15) default
NULL");
CALL AddColumnIfNotExists('reservation', 'connectport', "smallint(5) unsigned
default NULL");
+ALTER TABLE `reservation` CHANGE `pw` `pw` VARCHAR(40) NULL DEFAULT NULL;
-- --------------------------------------------------------
Modified: vcl/trunk/mysql/vcl.sql
URL:
http://svn.apache.org/viewvc/vcl/trunk/mysql/vcl.sql?rev=1638816&r1=1638815&r2=1638816&view=diff
==============================================================================
--- vcl/trunk/mysql/vcl.sql (original)
+++ vcl/trunk/mysql/vcl.sql Wed Nov 12 15:23:31 2014
@@ -858,7 +858,7 @@ CREATE TABLE IF NOT EXISTS `reservation`
`managementnodeid` smallint(5) unsigned NOT NULL default '1',
`remoteIP` varchar(15) default NULL,
`lastcheck` datetime default '0000-00-00 00:00:00',
- `pw` varchar(10) default NULL,
+ `pw` varchar(40) default NULL,
`connectIP` varchar(15) default NULL,
`connectport` smallint(5) unsigned default NULL,
PRIMARY KEY (`id`),
