#992: Set/unset URL to release a client for remote access.

2 files changed, 15 insertions, 4 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 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;