From ad61ab775d9cc36aac2694bc5e47017386f1e7db Mon Sep 17 00:00:00 2001
From: Javier Sánchez Parra <jsanchez@soleta.eu>
Date: Thu, 10 Sep 2020 10:17:43 +0200
Subject: #1004 Add new fields to imagenes table

Extend database to store new fields that contain information about "clonator",
"compressor", "filesystem" and "datasize".

This patch also creates a /tmp/image.info file that is consumed by ogClient.
---
 admin/Database/ogAdmBD-1.1.1c-1.2.0.sql | 9 +++++++++
 1 file changed, 9 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 fb16fe46..f3aa2be9 100644
--- a/admin/Database/ogAdmBD-1.1.1c-1.2.0.sql
+++ b/admin/Database/ogAdmBD-1.1.1c-1.2.0.sql
@@ -29,6 +29,15 @@ CREATE PROCEDURE altercols() BEGIN
 		ALTER TABLE remotepc
 			ADD urlrelease VARCHAR(100) DEFAULT NULL;
 	END IF;
+	IF NOT EXISTS (SELECT * FROM information_schema.COLUMNS
+			WHERE COLUMN_NAME='clonator' AND TABLE_NAME='imagenes' AND TABLE_SCHEMA=DATABASE())
+	THEN
+		ALTER TABLE imagenes
+			ADD clonator varchar(100) NOT NULL DEFAULT '',
+			ADD compressor varchar(100) NOT NULL DEFAULT '',
+			ADD filesystem varchar(100) NOT NULL DEFAULT '',
+			ADD datasize bigint NOT NULL DEFAULT 0;
+	END IF;
 END//
 # Ejecutar actualización condicional.
 DELIMITER ';'
-- 
cgit v1.2.3-18-g5258

