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 -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
