diff options
| author | albertogp <albertogp@uma.es> | 2021-04-27 21:37:56 +0200 |
|---|---|---|
| committer | albertogp <albertogp@uma.es> | 2021-05-04 12:55:29 +0200 |
| commit | 1306eb0cf6244cf1c3c8d1e9acc0e4ea781fb3cc (patch) | |
| tree | 62056e685dd45858a9fde1b677336ce6c46ae6c1 /admin/Database/ogAdmBD-1.1.0pre-1.1.0a.sql | |
| parent | 56c079ad5c48e367f8c37d901de72c1e38f5a104 (diff) | |
"#ID-1037 Preparando todos los ficheros para versión 1.2.1"
Diffstat (limited to 'admin/Database/ogAdmBD-1.1.0pre-1.1.0a.sql')
| -rw-r--r-- | admin/Database/ogAdmBD-1.1.0pre-1.1.0a.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/admin/Database/ogAdmBD-1.1.0pre-1.1.0a.sql b/admin/Database/ogAdmBD-1.1.0pre-1.1.0a.sql index 131e7ba7..8992109c 100644 --- a/admin/Database/ogAdmBD-1.1.0pre-1.1.0a.sql +++ b/admin/Database/ogAdmBD-1.1.0pre-1.1.0a.sql @@ -42,6 +42,13 @@ CREATE PROCEDURE addcols() BEGIN ALTER TABLE ordenadores_particiones ADD uso TINYINT NOT NULL DEFAULT 0; END IF; + # Add tipodisco (ticket #1037). + IF NOT EXISTS (SELECT * FROM information_schema.COLUMNS + WHERE COLUMN_NAME='tdisk' AND TABLE_NAME='ordenadores_particiones' AND TABLE_SCHEMA=DATABASE()) + THEN + ALTER TABLE ordenadores_particiones + ADD tdisk VARCHAR(4) DEFAULT NULL AFTER idordenador; + END IF; # Añadir nº de serie (ticket #713) IF NOT EXISTS (SELECT * FROM information_schema.COLUMNS WHERE COLUMN_NAME='numserie' AND TABLE_NAME='ordenadores' AND TABLE_SCHEMA=DATABASE()) @@ -125,6 +132,13 @@ CREATE PROCEDURE addcols() BEGIN ALTER TABLE ordenadores_particiones ADD revision SMALLINT UNSIGNED NOT NULL DEFAULT 0 AFTER idimagen; END IF; + # Add tipodisco (ticket #1037). + IF NOT EXISTS (SELECT * FROM information_schema.COLUMNS + WHERE COLUMN_NAME='tdisk' AND TABLE_NAME='ordenadores_particiones' AND TABLE_SCHEMA=DATABASE()) + THEN + ALTER TABLE ordenadores_particiones + ADD tdisk VARCHAR(4) DEFAULT NULL AFTER idordenador; + END IF; # Incluir campo sistema operativo en el perfil de software (tickets #738 #713) IF NOT EXISTS (SELECT * FROM information_schema.COLUMNS WHERE COLUMN_NAME='idnombreso' AND TABLE_NAME='perfilessoft' AND TABLE_SCHEMA=DATABASE()) |