· 9 years ago · Jan 15, 2017, 11:14 PM
1CREATE TABLE IF NOT EXISTS aromareference (ID int(5) NOT NULL AUTO_INCREMENT,
2HopsID int(5) DEFAULT NULL,
3DescriptorID int(5) DEFAULT NULL,
4CONSTRAINT FOREIGN KEY (HopsID) REFERENCES hops (ProductID),
5CONSTRAINT FOREIGN KEY (DescriptorID) REFERENCES hopsdescriptors (DescriptorID),
6PRIMARY KEY(ID));
7
8+------------+
9| Centennial |
10+------------+
11| Floral |
12| Citrus |
13+------------+