Bf9FrNVF

1CREATE TABLE IF NOT EXISTS Produce
2(
3ProdID SMALLINT UNSIGNED NOT NULL PRIMARY KEY,
4ProdName VARCHAR(40) NOT NULL,
5Variety VARCHAR(40) NULL,
6InStock SMALLINT UNSIGNED NOT NULL,
7OnOrder SMALLINT UNSIGNED NOT NULL,
8SeasonAttr TINYINT UNSIGNED NOT NULL
9);
10
11INSERT INTO Produce
12VALUES (101, 'Apples', 'Red Delicious', 2000, 1000, 4),
13(102, 'Apples', 'Fuji', 1500, 1200, 4),
14(103, 'Apples', 'Golden Delicious', 500, 1000, 4),
15(104, 'Apples', 'Granny Smith', 300, 800, 4),
16(105, 'Oranges', 'Valencia', 1200, 1600, 15),
17(106, 'Oranges', 'Seville', 1300, 1000, 15),
18(107, 'Grapes', 'Red seedless', 3500, 1500, 4),
19(108, 'Grapes', 'Green seedless', 3500, 1500, 4),
20(109, 'Carrots', NULL, 4500, 1500, 6),
21(110, 'Broccoli', NULL, 800, 2500, 6),
22(111, 'Cherries', 'Bing', 2500, 2500, 2),
23(112, 'Cherries', 'Rainier', 1500, 1500, 2),
24(113, 'Zucchini', NULL, 1000, 1300, 2),
25(114, 'Mushrooms', 'Shitake', 800, 900, 15),
26(115, 'Mushrooms', 'Porcini', 400, 600, 15),
27(116, 'Mushrooms', 'Portobello', 900, 1100, 15),
28(117, 'Cucumbers', NULL, 2500, 1200, 2);