From c607df7196c186ef3fc721901bdaf01b5638be98 Mon Sep 17 00:00:00 2001 From: "Ramón M. Gómez" Date: Thu, 23 Jul 2020 18:27:24 +0200 Subject: #992: Set/unset URL to release a client for remote access. --- admin/Database/ogAdmBD-1.1.1c-1.2.0.sql | 14 ++++++++++++-- admin/Database/ogAdmBD.sql | 5 +++-- 2 files changed, 15 insertions(+), 4 deletions(-) (limited to 'admin/Database') 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 e02aad1e..fb16fe46 100644 --- a/admin/Database/ogAdmBD-1.1.1c-1.2.0.sql +++ b/admin/Database/ogAdmBD-1.1.1c-1.2.0.sql @@ -22,15 +22,25 @@ CREATE PROCEDURE altercols() BEGIN ADD inremotepc SMALLINT NOT NULL DEFAULT 0, ADD maintenance SMALLINT NOT NULL DEFAULT 0; END IF; + # Añadir campo con URL para liberar equipo reservado para acceso remoto (ticket #992). + IF NOT EXISTS (SELECT * FROM information_schema.COLUMNS + WHERE COLUMN_NAME='urlrelease' AND TABLE_NAME='remotepc' AND TABLE_SCHEMA=DATABASE()) + THEN + ALTER TABLE remotepc + ADD urlrelease VARCHAR(100) DEFAULT NULL; + END IF; END// # Ejecutar actualización condicional. DELIMITER ';' CALL altercols(); DROP PROCEDURE altercols; -# Redefinir algunos campos como no nulos. +# Redefinir campos como no nulos. ALTER TABLE aulas MODIFY inremotepc SMALLINT NOT NULL DEFAULT 0; ALTER TABLE imagenes MODIFY inremotepc SMALLINT NOT NULL DEFAULT 0; - +# Redefinir campos como nulos por defecto. +ALTER TABLE remotepc + MODIFY urllogin VARCHAR(100) DEFAULT NULL, + MODIFY urllogout VARCHAR(100) DEFAULT NULL; diff --git a/admin/Database/ogAdmBD.sql b/admin/Database/ogAdmBD.sql index 4bac0af0..cc5d001b 100644 --- a/admin/Database/ogAdmBD.sql +++ b/admin/Database/ogAdmBD.sql @@ -794,8 +794,9 @@ DROP TABLE IF EXISTS `remotepc`; CREATE TABLE `remotepc` ( `id` int(11) NOT NULL DEFAULT 0, `reserved` datetime DEFAULT NULL, - `urllogin` varchar(100), - `urllogout` varchar(100), + `urllogin` varchar(100) DEFAULT NULL, + `urllogout` varchar(100) DEFAULT NULL, + `urlrelease` varchar(100) DEFAULT NULL, `language` varchar(5), PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- cgit v1.2.3-18-g5258