From 84fa8d6f9e1bdaffbb87a007211caf1c4eb181a7 Mon Sep 17 00:00:00 2001 From: ramon 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