From 2b15bdbeff76715a7c56792c362b04621ab2e967 Mon Sep 17 00:00:00 2001 From: "Ramón M. Gómez" Date: Fri, 17 Jul 2020 10:33:28 +0200 Subject: #991: Updating SQL files. --- admin/Database/ogAdmBD-1.1.1b-1.2.0.sql | 23 +---------------------- 1 file changed, 1 insertion(+), 22 deletions(-) mode change 100644 => 120000 admin/Database/ogAdmBD-1.1.1b-1.2.0.sql (limited to 'admin/Database/ogAdmBD-1.1.1b-1.2.0.sql') diff --git a/admin/Database/ogAdmBD-1.1.1b-1.2.0.sql b/admin/Database/ogAdmBD-1.1.1b-1.2.0.sql deleted file mode 100644 index 1a52583b..00000000 --- a/admin/Database/ogAdmBD-1.1.1b-1.2.0.sql +++ /dev/null @@ -1,22 +0,0 @@ -### Fichero de actualización de la base de datos. -# OpenGnsys 1.1.1, 1.1.1a, 1.1.1b - OpenGnsys 1.2.0 -#use ogAdmBD - -DROP PROCEDURE IF EXISTS addcols; -# Procedimiento para actualización condicional de tablas. -DELIMITER '//' -CREATE PROCEDURE addcols() BEGIN - # Añadir campos fila y columna para localización de ordenador en el aula (ticket #944). - IF NOT EXISTS (SELECT * FROM information_schema.COLUMNS - WHERE COLUMN_NAME='n_row' AND TABLE_NAME='ordenadores' AND TABLE_SCHEMA=DATABASE()) - THEN - ALTER TABLE ordenadores - ADD n_row SMALLINT DEFAULT 0, - ADD n_col SMALLINT DEFAULT 0; - END IF; -END// -# Ejecutar actualización condicional. -DELIMITER ';' -CALL addcols(); -DROP PROCEDURE addcols; - diff --git a/admin/Database/ogAdmBD-1.1.1b-1.2.0.sql b/admin/Database/ogAdmBD-1.1.1b-1.2.0.sql new file mode 120000 index 00000000..d122cb44 --- /dev/null +++ b/admin/Database/ogAdmBD-1.1.1b-1.2.0.sql @@ -0,0 +1 @@ +ogAdmBD-1.1.1c-1.2.0.sql \ No newline at end of file -- cgit v1.2.3-18-g5258