diff options
| author | Ramón M. Gómez <ramongomez@us.es> | 2020-07-17 10:33:28 +0200 |
|---|---|---|
| committer | Ramón M. Gómez <ramongomez@us.es> | 2020-07-17 10:33:28 +0200 |
| commit | 2b15bdbeff76715a7c56792c362b04621ab2e967 (patch) | |
| tree | 08524d85d35e0d9fb0c831dd4783de5654d0b6ab /admin/Database/ogAdmBD-1.1.1b-1.2.0.sql | |
| parent | 3b5fb9d7283a872fb4524c794ed6311a9d50589f (diff) | |
#991: Updating SQL files.
Diffstat (limited to 'admin/Database/ogAdmBD-1.1.1b-1.2.0.sql')
| l---------[-rw-r--r--] | admin/Database/ogAdmBD-1.1.1b-1.2.0.sql | 23 |
1 files changed, 1 insertions, 22 deletions
diff --git a/admin/Database/ogAdmBD-1.1.1b-1.2.0.sql b/admin/Database/ogAdmBD-1.1.1b-1.2.0.sql index 1a52583b..d122cb44 100644..120000 --- a/admin/Database/ogAdmBD-1.1.1b-1.2.0.sql +++ b/admin/Database/ogAdmBD-1.1.1b-1.2.0.sql @@ -1,22 +1 @@ -### 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; - +ogAdmBD-1.1.1c-1.2.0.sql
\ No newline at end of file |