MySQL Forums
Forum List  »  Spanish

#1067 - Invalid default value for 'date'
Posted by: Eric FM
Date: April 22, 2007 08:22AM

Buenas! Estoy intentando importar un archivo sql a MySQL, concretamente al de iespana.es, que corre en la versión 5.0.26. El problema es que al ejecutar las siguientes órdenes

CREATE TABLE `smf_calendar` (
`ID_EVENT` smallint(5) unsigned NOT NULL auto_increment,
`startDate` date NOT NULL default '0001-01-01',
`endDate` date NOT NULL default '0001-01-01',
`ID_BOARD` smallint(5) unsigned NOT NULL default '0',
`ID_TOPIC` mediumint(8) unsigned NOT NULL default '0',
`title` varchar(48) NOT NULL default '',
`ID_MEMBER` mediumint(8) unsigned NOT NULL default '0',
PRIMARY KEY (`ID_EVENT`),
KEY `startDate` (`startDate`),
KEY `endDate` (`endDate`),
KEY `topic` (`ID_TOPIC`,`ID_MEMBER`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

me da el error #1067 - Invalid default value for 'date'.

He estado buscando solución para este error, he probado diferentes formatos de fecha, pero no consigo que me cree la tabla. Me podéis decir como remediarlo? Gracias!

Options: ReplyQuote


Subject
Views
Written By
Posted
#1067 - Invalid default value for 'date'
12559
April 22, 2007 08:22AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.