diff options
| author | Ramón M. Gómez <ramongomez@us.es> | 2020-10-21 10:49:46 +0200 |
|---|---|---|
| committer | Ramón M. Gómez <ramongomez@us.es> | 2020-10-21 10:49:46 +0200 |
| commit | a0dd47a79ca4d5a06979fe22827bf7d4ea178fb7 (patch) | |
| tree | c0b2209b494a37db50d3845ba010a3d596d9dab0 /admin/Database/ogAdmBD-1.1.1c-1.2.0.sql | |
| parent | 627a82c8ba2bcd312853b33c131eda298774a3ec (diff) | |
#992: Expand URL fields to support long hostnames.
Thanks to Jorge Fernandez Marín for the solution provided.
Diffstat (limited to 'admin/Database/ogAdmBD-1.1.1c-1.2.0.sql')
| -rw-r--r-- | admin/Database/ogAdmBD-1.1.1c-1.2.0.sql | 7 |
1 files changed, 4 insertions, 3 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; |