diff options
| author | ramon <ramongomez@us.es> | 2017-04-20 11:05:32 +0000 |
|---|---|---|
| committer | ramon <ramongomez@us.es> | 2017-04-20 11:05:32 +0000 |
| commit | 31ad04664ba58d8a75393c109b5f22b2dea0e253 (patch) | |
| tree | aef385314a3a57cd4ebd4ef8ecfca2e11d9fdc37 /admin/Database/ogAdmBD.sql | |
| parent | d7352ab5fde6aad12e9094515354709cebeb93de (diff) | |
#730: Evitar errores en la BD cuando MySQL está configurado con el modo {{{NO_ZERO_DATE}}} (por defecto en MySQL 5.7 de Ubuntu 16.04).
git-svn-id: https://opengnsys.es/svn/branches/version1.1@5272 a21b9725-9963-47de-94b9-378ad31fedc9
Diffstat (limited to 'admin/Database/ogAdmBD.sql')
| -rw-r--r-- | admin/Database/ogAdmBD.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/admin/Database/ogAdmBD.sql b/admin/Database/ogAdmBD.sql index 97116ed0..290d4f23 100644 --- a/admin/Database/ogAdmBD.sql +++ b/admin/Database/ogAdmBD.sql @@ -22,8 +22,8 @@ CREATE TABLE IF NOT EXISTS `acciones` ( `sesion` int(11) NOT NULL DEFAULT '0', `idcomando` int(11) NOT NULL DEFAULT '0', `parametros` text, - `fechahorareg` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', - `fechahorafin` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + `fechahorareg` datetime NOT NULL DEFAULT '1970-01-01 00:00:00', + `fechahorafin` datetime NOT NULL DEFAULT '1970-01-01 00:00:00', `estado` tinyint(1) NOT NULL DEFAULT '0', `resultado` tinyint(1) NOT NULL DEFAULT '0', `descrinotificacion` varchar(256) DEFAULT NULL, |