You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@vcl.apache.org by jf...@apache.org on 2018/12/11 19:32:34 UTC
[2/2] vcl git commit: VCL-1103 - change vcldsemaphore.pid from
smallint to mediumint
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/develop
Commit: 5743cf340df3d63e3bad8c2c4b800e2f8f6cbbdd
Parents: c92ffda
Author: Josh Thompson <jf...@ncsu.edu>
Authored: Tue Dec 11 14:29:25 2018 -0500
Committer: Josh Thompson <jf...@ncsu.edu>
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`)