From 1306eb0cf6244cf1c3c8d1e9acc0e4ea781fb3cc Mon Sep 17 00:00:00 2001
From: albertogp <albertogp@uma.es>
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

