VCL-1103 - change vcldsemaphore.pid from smallint to mediumint vcl.sql: changed definition of vcldsemaphore.pid to be mediumint instead of smallint
update-vcl.sql: -changed definition of vcldsemaphore.pid to be mediumint instead of smallint -added alter table to change vcldsemaphore.pid to be mediumint instead of smallint Project: http://git-wip-us.apache.org/repos/asf/vcl/repo Commit: http://git-wip-us.apache.org/repos/asf/vcl/commit/5743cf34 Tree: http://git-wip-us.apache.org/repos/asf/vcl/tree/5743cf34 Diff: http://git-wip-us.apache.org/repos/asf/vcl/diff/5743cf34 Branch: refs/heads/VCL-1082_lastcheckin_db_epoch Commit: 5743cf340df3d63e3bad8c2c4b800e2f8f6cbbdd Parents: c92ffda Author: Josh Thompson <[email protected]> Authored: Tue Dec 11 14:29:25 2018 -0500 Committer: Josh Thompson <[email protected]> Committed: Tue Dec 11 14:29:25 2018 -0500 ---------------------------------------------------------------------- mysql/update-vcl.sql | 4 +++- mysql/vcl.sql | 2 +- 2 files changed, 4 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/vcl/blob/5743cf34/mysql/update-vcl.sql ---------------------------------------------------------------------- diff --git a/mysql/update-vcl.sql b/mysql/update-vcl.sql index 0746771..03ac8a0 100644 --- a/mysql/update-vcl.sql +++ b/mysql/update-vcl.sql @@ -1547,12 +1547,14 @@ CREATE TABLE IF NOT EXISTS `variable` ( CREATE TABLE IF NOT EXISTS `vcldsemaphore` ( `identifier` varchar(256) NOT NULL, `reservationid` mediumint(9) unsigned NOT NULL, - `pid` smallint(5) unsigned NOT NULL, + `pid` mediumint(8) unsigned NOT NULL, `expires` datetime NOT NULL, PRIMARY KEY (`identifier`), KEY `reservationid` (`reservationid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; +ALTER TABLE `vcldsemaphore` CHANGE `pid` `pid` mediumint(8) unsigned NOT NULL; + -- -------------------------------------------------------- -- http://git-wip-us.apache.org/repos/asf/vcl/blob/5743cf34/mysql/vcl.sql ---------------------------------------------------------------------- diff --git a/mysql/vcl.sql b/mysql/vcl.sql index 58093ca..720fbf8 100644 --- a/mysql/vcl.sql +++ b/mysql/vcl.sql @@ -1481,7 +1481,7 @@ CREATE TABLE IF NOT EXISTS `variable` ( CREATE TABLE IF NOT EXISTS `vcldsemaphore` ( `identifier` varchar(256) NOT NULL, `reservationid` mediumint(9) unsigned NOT NULL, - `pid` smallint(5) unsigned NOT NULL, + `pid` mediumint(8) unsigned NOT NULL, `expires` datetime NOT NULL, PRIMARY KEY (`identifier`), KEY `reservationid` (`reservationid`)
