From a0dd47a79ca4d5a06979fe22827bf7d4ea178fb7 Mon Sep 17 00:00:00 2001 From: "Ramón M. Gómez" Date: Wed, 21 Oct 2020 10:49:46 +0200 Subject: #992: Expand URL fields to support long hostnames. MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Thanks to Jorge Fernandez Marín for the solution provided. --- admin/Database/ogAdmBD-1.1.1c-1.2.0.sql | 7 ++++--- admin/Database/ogAdmBD.sql | 6 +++--- 2 files changed, 7 insertions(+), 6 deletions(-) diff --git a/admin/Database/ogAdmBD-1.1.1c-1.2.0.sql b/admin/Database/ogAdmBD-1.1.1c-1.2.0.sql index d63a02c0..2310befa 100644 --- a/admin/Database/ogAdmBD-1.1.1c-1.2.0.sql +++ b/admin/Database/ogAdmBD-1.1.1c-1.2.0.sql @@ -27,7 +27,7 @@ CREATE PROCEDURE altercols() BEGIN WHERE COLUMN_NAME='urlrelease' AND TABLE_NAME='remotepc' AND TABLE_SCHEMA=DATABASE()) THEN ALTER TABLE remotepc - ADD urlrelease VARCHAR(100) DEFAULT NULL AFTER urllogout; + ADD urlrelease VARCHAR(255) DEFAULT NULL AFTER urllogout; END IF; # Add flag field to indicate if a local session is open (ticket #992). IF NOT EXISTS (SELECT * FROM information_schema.COLUMNS @@ -59,5 +59,6 @@ ALTER TABLE imagenes MODIFY inremotepc SMALLINT NOT NULL DEFAULT 0; # Redefine some fields as null by default. ALTER TABLE remotepc - MODIFY urllogin VARCHAR(100) DEFAULT NULL, - MODIFY urllogout VARCHAR(100) DEFAULT NULL; + MODIFY urllogin VARCHAR(255) DEFAULT NULL, + MODIFY urllogout VARCHAR(255) DEFAULT NULL, + MODIFY urlrelease VARCHAR(255) DEFAULT NULL; diff --git a/admin/Database/ogAdmBD.sql b/admin/Database/ogAdmBD.sql index 6a8137b5..8520ea69 100644 --- a/admin/Database/ogAdmBD.sql +++ b/admin/Database/ogAdmBD.sql @@ -798,9 +798,9 @@ DROP TABLE IF EXISTS `remotepc`; CREATE TABLE `remotepc` ( `id` int(11) NOT NULL DEFAULT 0, `reserved` datetime DEFAULT NULL, - `urllogin` varchar(100) DEFAULT NULL, - `urllogout` varchar(100) DEFAULT NULL, - `urlrelease` varchar(100) DEFAULT NULL, + `urllogin` varchar(255) DEFAULT NULL, + `urllogout` varchar(255) DEFAULT NULL, + `urlrelease` varchar(255) DEFAULT NULL, `language` varchar(5), `islocal` tinyint NOT NULL DEFAULT 0, PRIMARY KEY (`id`) -- cgit v1.2.3-18-g5258