CREATE TABLE vendor (
V_code INTEGER NOT NULL UNIQUE,
V_name VARCHAR(35) NOT NULL,
V_contact VARCHAR(25) NOT NULL,
V_Year_founded DATE NOT NULL,
V_phone CHAR(12) NOT NULL,
V_state CHAR(2) NOT NULL,
PRIMARY KEY (V_code)) engine=InnoDB;
CREATE TABLE product (
P_code INTEGER NOT NULL UNIQUE,
P_descript VARCHAR(35) NOT NULL,
P_quan SMALLINT NOT NULL,
P_price DECIMAL(8,2) NOT NULL,
P_discount DECIMAL(5,2) NOT NULL,
V_code INTEGER,
PRIMARY KEY (P_code),
FOREIGN KEY (V_code) REFERENCES vendor(V_code)
)engine=InnoDB;
Insert values into the tables
INSERT INTO vendor
VALUES (21225,'Bryson, Inc.','Smithson','1990-10-08','723-223-3234','TN'),
(21226,'D&E Supply','Corener','1985-08-08','974-113-3255','VA'),
(21227,'Rubicon Systems','Hakford','1979-03-08','322-113-3255','CA');
INSERT INTO product
VALUES
(01,'Titanium drill bit',75, 141.50, 0.06,21226),
(02,'Gold drill bit', 66, 19.50, 0.08,21227),
(03,'Silver drill bit', 62, 8.50, 0.5,21225),
(04,'Aluminum drill', 61, 6.50, 0.9,21225),
(05,'Silver drill bit', 62, 12.50, 0.5,21227),
(06,'Gold drill bit', 66, 16.50, 0.28,21225);
What I have tried:
I have gone over the code but cant find my mistake