#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.

2 files changed, 13 insertions, 0 deletions

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 ';'
diff --git a/admin/Database/ogAdmBD.sql b/admin/Database/ogAdmBD.sql
index cc5d001b..8264a696 100644
--- a/admin/Database/ogAdmBD.sql
+++ b/admin/Database/ogAdmBD.sql
@@ -447,6 +447,10 @@ CREATE TABLE `imagenes` (
   `ruta` varchar(250) NULL,
   `fechacreacion` datetime DEFAULT NULL,
   `inremotepc` tinyint NOT NULL DEFAULT 0,
+  `clonator` varchar(100) NOT NULL DEFAULT '',
+  `compressor` varchar(100) NOT NULL DEFAULT '',
+  `filesystem` varchar(100) NOT NULL DEFAULT '',
+  `datasize` bigint NOT NULL DEFAULT 0,
   PRIMARY KEY (`idimagen`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;