All pastes #170178 Raw Edit

Jemt

public text v1 · immutable
·published 2006-09-14 12:50 UTC
rendered paste body
Error while execeuting query: CREATE TABLE menulinks
(
	categoryid		int		unsigned	NOT NULL,
	id			int		unsigned	NOT NULL,
	link			varchar(30)			NOT NULL,
	href			varchar(250)			NOT NULL,
	
	primary key (categoryid id),
	FOREIGN KEY (categoryid) REFERENCES menucategories (id) ON DELETE CASCADE ON UPDATE CASCADE
) type = InnoDB:
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 'id),
	FOREIGN KEY (categoryid) REFERENCES menucategories (id) ON DELETE CASCADE ' at line 8 (errno: 1064)
Click 'Ignore' if you'd like to have this error ignored until the end of the script.