From 2b15bdbeff76715a7c56792c362b04621ab2e967 Mon Sep 17 00:00:00 2001
From: "Ramón M. Gómez" <ramongomez@us.es>
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

