All pastes #995720 Raw Edit

Untitled

public text v1 · immutable
#995720 ·published 2008-04-24 12:51 UTC
rendered paste body
CREATE TABLE Plane
(
	regno     VARCHAR(8),
	make      VARCHAR(10),
	model     VARCHAR(10),
        owner     VARCHAR(10) NOT NULL,
        name      VARCHAR(30),
	CONSTRAINT Plane_FK FOREIGN KEY (make,model) REFERENCES Planemodel (varchar(10), varchar(10)),
	CONSTRAINT Plane_PK PRIMARY KEY (regno)
);

I am trying to make "make" and "model" 2 foreign references that occur in Planemodel. Both are varchar(10)

'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 'varchar(10), varchar(10)),
	CONSTRAINT Plane_PK PRIMARY KEY (regno)
)' at line 8'