-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
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.
>
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)
iD8DBQFDJ5INUQ+xExmY+AsRAiSKAKDFHtdqLEyu2rtaruGuMPgwGw2pdACgnba0
EyJiNf+hn+nVdtX6sW/7pJU=
=HhMR
-----END PGP SIGNATURE-----
