From reading the mysql site re 4.1 changes vis-a-vis 4.0:
DEFAULT values no longer can be specified for AUTO_INCREMENT columns.
(In 4.0, a DEFAULT value is silently ignored; in 4.1, an error occurs).
(ref http://www.mysql.com/doc/en/Upgrading-from-4.0.html)
So my guess: just change all
DEFAULT '0' NOT NULL auto_increment
into
NOT NULL auto_increment
Odhiambo Washington wrote:
There seems to be a problem with either, me, dbmail, or mysql ;)
[EMAIL PROTECTED] /shared/srcs/DBMAIL/dbmail-1.2/sql/mysql]
9$ mysql < create_tables_innoDB.mysql
ERROR 1067 at line 7: Invalid default value for 'alias_idnr'
That default value is 0. Perhaps that is illegal? I am no SQL
guru.
-Wash
--
________________________________________________________________
Paul Stevens mailto:[EMAIL PROTECTED]
NET FACILITIES GROUP PGP: finger [EMAIL PROTECTED]
The Netherlands________________________________http://www.nfg.nl
