From 84fa8d6f9e1bdaffbb87a007211caf1c4eb181a7 Mon Sep 17 00:00:00 2001
From: ramon <ramongomez@us.es>
Date: Tue, 12 Apr 2016 10:23:01 +0000
Subject: #737: Incluir y actualizar campos de nº de revisión de imagen creada
 y restaurada.
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

git-svn-id: https://opengnsys.es/svn/branches/version1.1@4879 a21b9725-9963-47de-94b9-378ad31fedc9
---
 admin/Database/ogAdmBD.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'admin/Database/ogAdmBD.sql')

diff --git a/admin/Database/ogAdmBD.sql b/admin/Database/ogAdmBD.sql
index 5e4b7fbd..9c18bf11 100644
--- a/admin/Database/ogAdmBD.sql
+++ b/admin/Database/ogAdmBD.sql
@@ -413,6 +413,7 @@ INSERT INTO `idiomas` (`ididioma`, `descripcion`, `nemonico`) VALUES
 CREATE TABLE IF NOT EXISTS `imagenes` (
   `idimagen` int(11) NOT NULL AUTO_INCREMENT,
   `nombreca` varchar(50) NOT NULL,
+  `revision` smallint UNSIGNED NOT NULL DEFAULT 0,
   `descripcion` varchar(250) NOT NULL DEFAULT '',
   `idperfilsoft` int(11) DEFAULT NULL,
   `idcentro` int(11) DEFAULT NULL,
@@ -515,6 +516,7 @@ CREATE TABLE IF NOT EXISTS `ordenadores_particiones` (
   `idsistemafichero` smallint(11) NOT NULL,
   `idnombreso` smallint(11) NOT NULL,
   `idimagen` int(11) NOT NULL,
+  `revision` smallint UNSIGNED NOT NULL DEFAULT 0,
   `idperfilsoft` int(11) NOT NULL,
   `fechadespliegue` datetime NULL,
   `cache` text NOT NULL,
-- 
cgit v1.2.3-18-g5258

