[AMaViS-user] Creating maddr problem

I'm attempting to create the table maddr according to the README however
below is the error. I'm using SLES 9.0.

mysql> CREATE TABLE maddr (
-> id SERIAL PRIMARY KEY,
-> email varchar(255) NOT NULL,
-> domain varchar(255) NOT NULL
->
-> ) ENGINE=InnoDB;
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'SERIAL PRIMARY KEY,
email varchar(255) NOT NULL,
d

I've successfull been able to create the other three tables though. 'msgs',
'msgrcpt', and 'quarantine'




-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/...fo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/