From 00cf45421042d623dc0602b82f925823abaddcd5 Mon Sep 17 00:00:00 2001 From: albertogp Date: Tue, 27 Apr 2021 21:37:56 +0200 Subject: "#ID-1037 Preparando todos los ficheros para versión 1.2.1" MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- admin/Database/ogAdmBD-1.1.0pre-1.1.0a.sql | 14 ++++++++++++++ 1 file changed, 14 insertions(+) (limited to 'admin/Database/ogAdmBD-1.1.0pre-1.1.0a.sql') 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()) -- cgit v1.2.3-18-g5258