From 1306eb0cf6244cf1c3c8d1e9acc0e4ea781fb3cc 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.1c-1.2.0.sql | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'admin/Database/ogAdmBD-1.1.1c-1.2.0.sql') diff --git a/admin/Database/ogAdmBD-1.1.1c-1.2.0.sql b/admin/Database/ogAdmBD-1.1.1c-1.2.0.sql index e281ae4e..ab1a9c20 100644 --- a/admin/Database/ogAdmBD-1.1.1c-1.2.0.sql +++ b/admin/Database/ogAdmBD-1.1.1c-1.2.0.sql @@ -46,6 +46,13 @@ CREATE PROCEDURE altercols() BEGIN ADD filesystem varchar(100) NOT NULL DEFAULT '', ADD datasize bigint 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; END// # Run conditional update. DELIMITER ';' -- cgit v1.2.3-18-g5258