From a0dd47a79ca4d5a06979fe22827bf7d4ea178fb7 Mon Sep 17 00:00:00 2001
From: "Ramón M. Gómez" <ramongomez@us.es>
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 ++++---
 1 file changed, 4 insertions(+), 3 deletions(-)

(limited to 'admin/Database/ogAdmBD-1.1.1c-1.2.0.sql')

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;
-- 
cgit v1.2.3-18-g5258

