diff options
author | Javier Sánchez Parra <jsanchez@soleta.eu> | 2020-09-10 10:17:43 +0200 |
---|---|---|
committer | OpenGnSys Support Team <soporte-og@soleta.eu> | 2020-09-10 14:52:01 +0200 |
commit | ad61ab775d9cc36aac2694bc5e47017386f1e7db (patch) | |
tree | a3416254eba318a8a7c8b5bdcee48b314a4f2575 /admin/Database/ogAdmBD-1.1.1c-1.2.0.sql | |
parent | a3aa3e336bbe706c92195cb08bc34c4821798642 (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/ogAdmBD-1.1.1c-1.2.0.sql')
-rw-r--r-- | admin/Database/ogAdmBD-1.1.1c-1.2.0.sql | 9 |
1 files changed, 9 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 ';' |