Jim C. wrote:
CREATE TABLE "credits" ( "person" integer NOT NULL default '0', "chanid" int NOT NULL default '0', "starttime" timestamp NOT NULL default '1970-01-01 00:00:00+00', "role" VARCHAR NOT NULL, CONSTRAINT role_check CHECK "role" IN ('actor','director','producer','executive_producer','writer','guest_star', 'host','adapter','presenter','commentator','guest'), <-------
See the arrow. It seems like you commented out some stuff below it. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]