diff options
| author | ramon <ramongomez@us.es> | 2016-04-12 10:23:01 +0000 |
|---|---|---|
| committer | ramon <ramongomez@us.es> | 2016-04-12 10:23:01 +0000 |
| commit | 84fa8d6f9e1bdaffbb87a007211caf1c4eb181a7 (patch) | |
| tree | 1cc52f907c7a2cf2e29312f50ba2ddf1e2f7a28d /admin/Database/ogAdmBD.sql | |
| parent | bac2d636d1c1cfee17430e236f759af7ff8e82c4 (diff) | |
#737: Incluir y actualizar campos de nº de revisión de imagen creada y restaurada.
git-svn-id: https://opengnsys.es/svn/branches/version1.1@4879 a21b9725-9963-47de-94b9-378ad31fedc9
Diffstat (limited to 'admin/Database/ogAdmBD.sql')
| -rw-r--r-- | admin/Database/ogAdmBD.sql | 2 |
1 files changed, 2 insertions, 0 deletions
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, |