That is what I had figured on. I was just wondering cause I ran the script and got that error...
Thank you. On Wed, 2005-09-14 at 08:46 +0200, Paul J Stevens wrote: > Steven, > > The create script has been running virtually unchanged since 2.0.0 > > This is very likely something specific to mysql-5. > > Steven Lynn wrote: > > Has anybody run the mysql_create_innodb.sql script on MySQL 5? > > > > I get an error on: > > > > CREATE TABLE dbmail_pbsp ( > > idnr bigint(21) NOT NULL auto_increment, > > since datetime default '0' not null, > > ipnumber varchar(40) NOT NULL, > > PRIMARY KEY (idnr), > > UNIQUE INDEX ipnumber_index (ipnumber), > > INDEX since_index (since) > > ) TYPE=InnoDB; > > > > Column 'since' has the wrong default value for datetime... If someone > > has run on mysql 4.x and has had no problems, let me know and I will > > stop talking. ;) > > > > -- > > Steven Lynn > > [EMAIL PROTECTED] > > > > Paul J Stevens wrote: > > > > > >>>Dbmail 2.0.7 released > >>> > >>>This is a bugfix release only. > >>> > >>>* Removed all unsafe code from the signal handlers. This should > >>>mostly benefit FreeBSD users which may have suffered from unreliable > >>>behaviour in the process pool code. > >>>* Added 'ON UPDATE CASCADE' to all foreign key restraints in the > >>>MySQL (InnoDB) and Postgresql create_table files. > >>>* POP3 AUTH command no longer returns list of supported > >>>authentication mechanisms when issued without arguments. > >>> > >>> > > > > _______________________________________________ > Dbmail mailing list > Dbmail@dbmail.org > https://mailman.fastxs.nl/mailman/listinfo/dbmail > >
signature.asc
Description: This is a digitally signed message part
