diff options
| author | ramon <ramongomez@us.es> | 2014-11-10 12:28:00 +0000 |
|---|---|---|
| committer | ramon <ramongomez@us.es> | 2014-11-10 12:28:00 +0000 |
| commit | d43c0eb79f394f1ab4f515ffaefd48e7f885ce76 (patch) | |
| tree | 88fbcc0501bfc439975a54521c852c68b128d5dc /admin/Database/ogAdmBD.sql | |
| parent | f88131f66cce87258b89f5266fc3893c9b21beaa (diff) | |
#677: Corregir valores por defecto en la tabla {{{imagenes}}} de la BD.
git-svn-id: https://opengnsys.es/svn/branches/version1.0@4436 a21b9725-9963-47de-94b9-378ad31fedc9
Diffstat (limited to 'admin/Database/ogAdmBD.sql')
| -rw-r--r-- | admin/Database/ogAdmBD.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/admin/Database/ogAdmBD.sql b/admin/Database/ogAdmBD.sql index dc947428..9fc9326e 100644 --- a/admin/Database/ogAdmBD.sql +++ b/admin/Database/ogAdmBD.sql @@ -421,15 +421,15 @@ CREATE TABLE IF NOT EXISTS `imagenes` ( `idcentro` int(11) DEFAULT NULL, `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, + `idrepositorio` int(11) NOT NULL DEFAULT 0, + `idordenador` int(11) NOT NULL DEFAULT 0, + `numdisk` smallint NOT NULL DEFAULT 0, + `numpar` smallint NOT NULL DEFAULT 0, + `codpar` int(8) NOT NULL DEFAULT 0, `tipo` tinyint NULL, `imagenid` int NOT NULL DEFAULT 0, `ruta` varchar(250) NULL, - `fechacreacion` datetime NULL, + `fechacreacion` datetime DEFAULT NULL, PRIMARY KEY (`idimagen`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; |