diff options
| author | ramon <ramongomez@us.es> | 2014-11-06 12:52:50 +0000 |
|---|---|---|
| committer | ramon <ramongomez@us.es> | 2014-11-06 12:52:50 +0000 |
| commit | 5a10e9265ec66782739878ce07c6bbdac72b39fb (patch) | |
| tree | e496cab446e08a962b9ae4f8eff8f1f9a59f0345 /admin/Database/ogAdmBD.sql | |
| parent | 1f2f1e2154f1d4c20825d28a80c2169c48455f74 (diff) | |
#677: Incluir en tabla de imágenes datos de ordenador modelo, disco y fecha de creación.
Depurar ficheros de actualización de la BD.
git-svn-id: https://opengnsys.es/svn/branches/version1.0@4430 a21b9725-9963-47de-94b9-378ad31fedc9
Diffstat (limited to 'admin/Database/ogAdmBD.sql')
| -rw-r--r-- | admin/Database/ogAdmBD.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/admin/Database/ogAdmBD.sql b/admin/Database/ogAdmBD.sql index b0ddad3c..dc947428 100644 --- a/admin/Database/ogAdmBD.sql +++ b/admin/Database/ogAdmBD.sql @@ -422,12 +422,14 @@ CREATE TABLE IF NOT EXISTS `imagenes` ( `comentarios` text, `grupoid` int(11) DEFAULT NULL, `idrepositorio` int(11) NOT NULL, + `idordenador` int(11) NOT NULL, `numdisk` smallint NOT NULL DEFAULT 1, `numpar` smallint NOT NULL, `codpar` int(8) NOT NULL, `tipo` tinyint NULL, - `imagenid` int NOT NULL DEFAULT '0', + `imagenid` int NOT NULL DEFAULT 0, `ruta` varchar(250) NULL, + `fechacreacion` datetime NULL, PRIMARY KEY (`idimagen`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |