sampleTest.sql

CREATE TABLE "Ingredient" (
"name"  TEXT NOT NULL,
PRIMARY KEY ("name" ASC)
);


INSERT INTO "Ingredient" VALUES ('Vodka');
INSERT INTO "Ingredient" VALUES ('Rum');
INSERT INTO "Ingredient" VALUES ('Sherry');
INSERT INTO "Ingredient" VALUES ('Whiskey');
INSERT INTO "Ingredient" VALUES ('Cherry');
INSERT INTO "Ingredient" VALUES ('Orange');
INSERT INTO "Ingredient" VALUES ('Olive');
INSERT INTO "Ingredient" VALUES ('Gin');
INSERT INTO "Ingredient" VALUES ('Lemon Juice');
INSERT INTO "Ingredient" VALUES ('Orange Gin');
INSERT INTO "Ingredient" VALUES ('Sweet Vermouth');
INSERT INTO "Ingredient" VALUES ('7-Up');
INSERT INTO "Ingredient" VALUES ('Cranberry Juice');
INSERT INTO "Ingredient" VALUES ('Dekuyper Razzmatazz');
INSERT INTO "Ingredient" VALUES ('Orange Juice');
INSERT INTO "Ingredient" VALUES ('Sour Mix');
INSERT INTO "Ingredient" VALUES ('Dry Cider');
INSERT INTO "Ingredient" VALUES ('Lager');
INSERT INTO "Ingredient" VALUES ('Sloe Gin');
INSERT INTO "Ingredient" VALUES ('Southern Comfort');
INSERT INTO "Ingredient" VALUES ('Triple Sec');
INSERT INTO "Ingredient" VALUES ('Blue Curacao');
INSERT INTO "Ingredient" VALUES ('Lime Juice');
INSERT INTO "Ingredient" VALUES ('Red Curacao');
INSERT INTO "Ingredient" VALUES ('Tequila');
SELECT * FROM Ingredient;