summaryrefslogtreecommitdiffstats
path: root/admin/Database
diff options
context:
space:
mode:
authorJavier Sánchez Parra <jsanchez@soleta.eu>2020-09-10 10:17:43 +0200
committerOpenGnSys Support Team <soporte-og@soleta.eu>2020-09-10 14:52:01 +0200
commitad61ab775d9cc36aac2694bc5e47017386f1e7db (patch)
treea3416254eba318a8a7c8b5bdcee48b314a4f2575 /admin/Database
parenta3aa3e336bbe706c92195cb08bc34c4821798642 (diff)
#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.
Diffstat (limited to 'admin/Database')
-rw-r--r--admin/Database/ogAdmBD-1.1.1c-1.2.0.sql9
-rw-r--r--admin/Database/ogAdmBD.sql4
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 ;