summaryrefslogtreecommitdiffstats
path: root/admin/Database
diff options
context:
space:
mode:
Diffstat (limited to 'admin/Database')
-rw-r--r--admin/Database/ogAdmBD-1.1.1c-1.2.0.sql14
-rw-r--r--admin/Database/ogAdmBD.sql5
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;