Hello, I am using MySQL 4.0.24 SA 3.04 amavisd-new 2.3.3 OpenBSD 3.8
I am having difficulty creating a proper SQL schema. I am using the one in the amavisd-new documenation but it gives me errors reletating I believe with my older MySQL version. Their schema contains lines like: CREATE TABLE users ( id PRIMARY KEY, -- unique id, not necessarily auto-assigned priority integer NOT NULL DEFAULT '7', -- sort field, 0 is low prior. policy_id integer unsigned NOT NULL DEFAULT '1', -- JOINs with policy.id email varchar(255) NOT NULL, fullname varchar(255) DEFAULT NULL, -- not used by amavisd-new local char(1), -- Y/N (optional field, see note further down) KEY email (email) ); Resulting in this error: ERROR 1064 at line 1: 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 'PRIMARY KEY, priority integer NOT NULL DEFAULT '7', What should be changed near PRIMARY KEY ? __________________________________________________________ Find your next car at http://autos.yahoo.ca