diff options
| author | ramon <ramongomez@us.es> | 2016-11-15 16:22:21 +0000 |
|---|---|---|
| committer | ramon <ramongomez@us.es> | 2016-11-15 16:22:21 +0000 |
| commit | d09e1c3b8be0fc368ec5b88a586bb6bfe8dcf776 (patch) | |
| tree | 81f034e110158e9158224805483c6c5f7102bc6d /admin/Database/ogAdmBD.sql | |
| parent | 146d95527531ac58930b28f50d7a57271e7a5a1f (diff) | |
#730: Campo {{{TEXT}}} con valor por defecto provoca error en MySQL 5.7 (Ubuntu 16.04).
git-svn-id: https://opengnsys.es/svn/branches/version1.1@5093 a21b9725-9963-47de-94b9-378ad31fedc9
Diffstat (limited to 'admin/Database/ogAdmBD.sql')
| -rw-r--r-- | admin/Database/ogAdmBD.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/admin/Database/ogAdmBD.sql b/admin/Database/ogAdmBD.sql index c104971a..cdc0f072 100644 --- a/admin/Database/ogAdmBD.sql +++ b/admin/Database/ogAdmBD.sql @@ -29,7 +29,7 @@ CREATE TABLE IF NOT EXISTS `acciones` ( `descrinotificacion` varchar(256) DEFAULT NULL, `ambito` smallint(6) NOT NULL DEFAULT '0', `idambito` int(11) NOT NULL DEFAULT '0', - `restrambito` text NOT NULL, + `restrambito` text, `idprocedimiento` int(11) NOT NULL DEFAULT '0', `idtarea` int(11) NOT NULL DEFAULT '0', `idcentro` int(11) NOT NULL DEFAULT '0', @@ -521,7 +521,7 @@ CREATE TABLE IF NOT EXISTS `ordenadores_particiones` ( `revision` smallint UNSIGNED NOT NULL DEFAULT '0', `idperfilsoft` int(11) NOT NULL DEFAULT '0', `fechadespliegue` datetime NULL, - `cache` text NOT NULL, + `cache` text, UNIQUE KEY `idordenadornumdisknumpar` (`idordenador`,`numdisk`,`numpar`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; @@ -534,7 +534,7 @@ CREATE TABLE IF NOT EXISTS `ordenadores_particiones` ( CREATE TABLE IF NOT EXISTS `parametros` ( `idparametro` int(11) NOT NULL AUTO_INCREMENT, `nemonico` char(3) NOT NULL DEFAULT '', - `descripcion` text NOT NULL, + `descripcion` text, `nomidentificador` varchar(64) NOT NULL DEFAULT '', `nomtabla` varchar(64) NOT NULL DEFAULT '', `nomliteral` varchar(64) NOT NULL DEFAULT '', @@ -821,7 +821,7 @@ CREATE TABLE IF NOT EXISTS `tareas` ( `idcentro` int(11) NOT NULL DEFAULT '0', `ambito` smallint(6) NOT NULL DEFAULT '0', `idambito` int(11) NOT NULL DEFAULT '0', - `restrambito` text NOT NULL, + `restrambito` text, `comentarios` text, `grupoid` int(11) DEFAULT '0', PRIMARY KEY (`idtarea`) |