diff options
| author | Ramón M. Gómez <ramongomez@us.es> | 2020-06-01 20:00:49 +0200 |
|---|---|---|
| committer | Ramón M. Gómez <ramongomez@us.es> | 2020-06-01 20:00:49 +0200 |
| commit | f827bf6c4e5f2aaaccc08361e0a63ac2e087f831 (patch) | |
| tree | a2cd2756b7ac08b74083253eda921baf8e5349e5 /admin | |
| parent | 34f40d6cc0ee6e8dff503da93ce4b61b13cd5d88 (diff) | |
#944: Update database files.
Diffstat (limited to 'admin')
| l--------- | admin/Database/ogAdmBD-1.1.0-1.1.1.sql | 1 | ||||
| l--------- | admin/Database/ogAdmBD-1.1.0-1.1.1b.sql | 1 | ||||
| -rw-r--r-- | admin/Database/ogAdmBD-1.1.0a-1.1.1b.sql (renamed from admin/Database/ogAdmBD-1.1.0a-1.1.1.sql) | 2 | ||||
| l--------- | admin/Database/ogAdmBD-1.1.1-1.2.0.sql | 1 | ||||
| l--------- | admin/Database/ogAdmBD-1.1.1a-1.2.0.sql | 1 | ||||
| -rw-r--r-- | admin/Database/ogAdmBD-1.1.1b-1.2.0.sql (renamed from admin/Database/ogAdmBD-1.1.1.sql) | 2 | ||||
| l--------- | admin/Database/ogAdmBD-1.1.1pre-1.1.1.sql | 1 | ||||
| l--------- | admin/Database/ogAdmBD-1.1.1pre-1.1.1b.sql | 1 | ||||
| -rw-r--r-- | admin/Database/ogAdmBD.sql | 2 |
9 files changed, 8 insertions, 4 deletions
diff --git a/admin/Database/ogAdmBD-1.1.0-1.1.1.sql b/admin/Database/ogAdmBD-1.1.0-1.1.1.sql deleted file mode 120000 index fd52f3c8..00000000 --- a/admin/Database/ogAdmBD-1.1.0-1.1.1.sql +++ /dev/null @@ -1 +0,0 @@ -ogAdmBD-1.1.0a-1.1.1.sql
\ No newline at end of file diff --git a/admin/Database/ogAdmBD-1.1.0-1.1.1b.sql b/admin/Database/ogAdmBD-1.1.0-1.1.1b.sql new file mode 120000 index 00000000..244cb4e5 --- /dev/null +++ b/admin/Database/ogAdmBD-1.1.0-1.1.1b.sql @@ -0,0 +1 @@ +ogAdmBD-1.1.0a-1.1.1b.sql
\ No newline at end of file diff --git a/admin/Database/ogAdmBD-1.1.0a-1.1.1.sql b/admin/Database/ogAdmBD-1.1.0a-1.1.1b.sql index e5a6bd4e..53e36ca4 100644 --- a/admin/Database/ogAdmBD-1.1.0a-1.1.1.sql +++ b/admin/Database/ogAdmBD-1.1.0a-1.1.1b.sql @@ -1,5 +1,5 @@ ### Fichero de actualización de la base de datos. -# OpenGnsys 1.1.0, 1.1.0a, 1.1.1pre - OpenGnsys 1.1.1 +# OpenGnsys 1.1.0, 1.1.0a, 1.1.1pre - OpenGnsys 1.1.1b #use ogAdmBD # Eliminar procedimiento y disparador para evitar errores de ejecución. diff --git a/admin/Database/ogAdmBD-1.1.1-1.2.0.sql b/admin/Database/ogAdmBD-1.1.1-1.2.0.sql new file mode 120000 index 00000000..decf63ea --- /dev/null +++ b/admin/Database/ogAdmBD-1.1.1-1.2.0.sql @@ -0,0 +1 @@ +ogAdmBD-1.1.1b-1.2.0.sql
\ No newline at end of file diff --git a/admin/Database/ogAdmBD-1.1.1a-1.2.0.sql b/admin/Database/ogAdmBD-1.1.1a-1.2.0.sql new file mode 120000 index 00000000..decf63ea --- /dev/null +++ b/admin/Database/ogAdmBD-1.1.1a-1.2.0.sql @@ -0,0 +1 @@ +ogAdmBD-1.1.1b-1.2.0.sql
\ No newline at end of file diff --git a/admin/Database/ogAdmBD-1.1.1.sql b/admin/Database/ogAdmBD-1.1.1b-1.2.0.sql index 228d609d..1a52583b 100644 --- a/admin/Database/ogAdmBD-1.1.1.sql +++ b/admin/Database/ogAdmBD-1.1.1b-1.2.0.sql @@ -1,5 +1,5 @@ ### Fichero de actualización de la base de datos. -# OpenGnsys 1.1.1 +# OpenGnsys 1.1.1, 1.1.1a, 1.1.1b - OpenGnsys 1.2.0 #use ogAdmBD DROP PROCEDURE IF EXISTS addcols; diff --git a/admin/Database/ogAdmBD-1.1.1pre-1.1.1.sql b/admin/Database/ogAdmBD-1.1.1pre-1.1.1.sql deleted file mode 120000 index fd52f3c8..00000000 --- a/admin/Database/ogAdmBD-1.1.1pre-1.1.1.sql +++ /dev/null @@ -1 +0,0 @@ -ogAdmBD-1.1.0a-1.1.1.sql
\ No newline at end of file diff --git a/admin/Database/ogAdmBD-1.1.1pre-1.1.1b.sql b/admin/Database/ogAdmBD-1.1.1pre-1.1.1b.sql new file mode 120000 index 00000000..244cb4e5 --- /dev/null +++ b/admin/Database/ogAdmBD-1.1.1pre-1.1.1b.sql @@ -0,0 +1 @@ +ogAdmBD-1.1.0a-1.1.1b.sql
\ No newline at end of file diff --git a/admin/Database/ogAdmBD.sql b/admin/Database/ogAdmBD.sql index 77e0f0ce..6b961ea1 100644 --- a/admin/Database/ogAdmBD.sql +++ b/admin/Database/ogAdmBD.sql @@ -534,6 +534,8 @@ CREATE TABLE `ordenadores` ( `paginavalidacion` varchar(100), `agentkey` varchar(32), `oglivedir` varchar(50) NOT NULL DEFAULT 'ogLive', + `n_row` smallint NOT NULL DEFAULT 0, + `n_col` smallint NOT NULL DEFAULT 0, PRIMARY KEY (`idordenador`), KEY `idaulaip` (`idaula` ASC, `ip` ASC) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |