From ad61ab775d9cc36aac2694bc5e47017386f1e7db Mon Sep 17 00:00:00 2001 From: Javier Sánchez Parra 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