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
