Permalink
Fetching contributors…
Cannot retrieve contributors at this time
261 lines (260 sloc) 13.2 KB
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE insults (id INTEGER PRIMARY KEY AUTOINCREMENT, insult, clean);
INSERT INTO "insults" VALUES(1,'if you keep that up, I''ll rip your arm off and beat you with the wet end.','TRUE');
INSERT INTO "insults" VALUES(2,'i''d hit you, but I don''t want to get stupid on my hands.','TRUE');
INSERT INTO "insults" VALUES(3,'how many different kinds of stupid are you trying to be?','TRUE');
INSERT INTO "insults" VALUES(4,'after talking to you, I now understand why animals eat their young.','TRUE');
INSERT INTO "insults" VALUES(5,'don''t feel bad, I think your poor self-image is *completely* justified.','TRUE');
INSERT INTO "insults" VALUES(6,'I would have been your father, but the other guy had exact change.','TRUE');
INSERT INTO "insults" VALUES(7,'your mom is so fat, fat people run around her for exercise.','TRUE');
INSERT INTO "insults" VALUES(8,'your mom is so old, she farts dust.','TRUE');
CREATE TABLE cookie_flavors (id INTEGER PRIMARY KEY AUTOINCREMENT, flavor);
INSERT INTO "cookie_flavors" VALUES(1,'chocolate chip');
INSERT INTO "cookie_flavors" VALUES(2,'sugar');
INSERT INTO "cookie_flavors" VALUES(3,'peanut butter');
INSERT INTO "cookie_flavors" VALUES(4,'shortbread');
INSERT INTO "cookie_flavors" VALUES(5,'M&M''s');
INSERT INTO "cookie_flavors" VALUES(6,'oatmeal');
INSERT INTO "cookie_flavors" VALUES(7,'pecan');
INSERT INTO "cookie_flavors" VALUES(8,'double chocolate chip');
INSERT INTO "cookie_flavors" VALUES(9,'double chocolate');
INSERT INTO "cookie_flavors" VALUES(10,'almond');
INSERT INTO "cookie_flavors" VALUES(11,'oatmeal chocolate chip');
INSERT INTO "cookie_flavors" VALUES(12,'chocolate-covered cherry');
INSERT INTO "cookie_flavors" VALUES(13,'ginger');
INSERT INTO "cookie_flavors" VALUES(14,'molasses');
INSERT INTO "cookie_flavors" VALUES(15,'snickerdoodle');
INSERT INTO "cookie_flavors" VALUES(16,'oatmeal raisin');
INSERT INTO "cookie_flavors" VALUES(17,'white chocolate macadamia nut');
INSERT INTO "cookie_flavors" VALUES(18,'frosted sugar');
INSERT INTO "cookie_flavors" VALUES(19,'lemon sugar');
INSERT INTO "cookie_flavors" VALUES(20,'shortbread');
INSERT INTO "cookie_flavors" VALUES(21,'butter pecan');
INSERT INTO "cookie_flavors" VALUES(22,'banana walnut');
INSERT INTO "cookie_flavors" VALUES(23,'chocolate rainbow');
INSERT INTO "cookie_flavors" VALUES(24,'gingerbread');
INSERT INTO "cookie_flavors" VALUES(25,'white chocolate mocha');
INSERT INTO "cookie_flavors" VALUES(26,'dark chocolate cranberry');
INSERT INTO "cookie_flavors" VALUES(27,'white chocolate cranberry');
INSERT INTO "cookie_flavors" VALUES(28,'mocha cappuccino');
INSERT INTO "cookie_flavors" VALUES(30,'black-and-white');
INSERT INTO "cookie_flavors" VALUES(32,'christmas');
INSERT INTO "cookie_flavors" VALUES(35,'kleicha');
INSERT INTO "cookie_flavors" VALUES(36,'Moravian spice');
INSERT INTO "cookie_flavors" VALUES(37,'bacon');
CREATE TABLE "skittles_colors" (
"ID" INTEGER PRIMARY KEY AUTOINCREMENT,
"color" TEXT
);
INSERT INTO "skittles_colors" VALUES(1,'red');
INSERT INTO "skittles_colors" VALUES(2,'blue');
INSERT INTO "skittles_colors" VALUES(3,'green');
INSERT INTO "skittles_colors" VALUES(4,'orange');
INSERT INTO "skittles_colors" VALUES(5,'purple');
INSERT INTO "skittles_colors" VALUES(6,'cherry');
INSERT INTO "skittles_colors" VALUES(7,'blueberry');
INSERT INTO "skittles_colors" VALUES(8,'blackberry');
INSERT INTO "skittles_colors" VALUES(9,'grape');
INSERT INTO "skittles_colors" VALUES(10,'lime green');
INSERT INTO "skittles_colors" VALUES(11,'watermelon');
INSERT INTO "skittles_colors" VALUES(12,'sour apple');
CREATE TABLE "sandwich_type" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"sandwich_type" TEXT
);
INSERT INTO "sandwich_type" VALUES(1,'turkey on rye');
INSERT INTO "sandwich_type" VALUES(2,'ham and cheese on italian');
INSERT INTO "sandwich_type" VALUES(3,'bologna on white');
INSERT INTO "sandwich_type" VALUES(4,'phily chesse stake on italian');
INSERT INTO "sandwich_type" VALUES(5,'ham, pepperoni, pepper jack cheese on flat bread');
INSERT INTO "sandwich_type" VALUES(6,'black forest ham with american cheese on whole wheat');
INSERT INTO "sandwich_type" VALUES(7,'bacon, lettuce, tomato on rye');
INSERT INTO "sandwich_type" VALUES(8,'grilled chicken on hamburger bun');
INSERT INTO "sandwich_type" VALUES(9,'peanut butter and jelly with crust cut off');
INSERT INTO "sandwich_type" VALUES(10,'applewood smoked ham,provolone cheese garnished,lettuce,tomato,mayo on italian');
CREATE TABLE "shake_flavor" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"shake_flavor" TEXT
);
INSERT INTO "shake_flavor" VALUES(1,'strawberry');
INSERT INTO "shake_flavor" VALUES(2,'chocolate');
INSERT INTO "shake_flavor" VALUES(3,'vanilla');
INSERT INTO "shake_flavor" VALUES(4,'chocolate mocha latte');
INSERT INTO "shake_flavor" VALUES(5,'peanut butter swirl');
INSERT INTO "shake_flavor" VALUES(6,'banana');
INSERT INTO "shake_flavor" VALUES(7,'double chocolate fudge');
INSERT INTO "shake_flavor" VALUES(8,'caramel apple');
INSERT INTO "shake_flavor" VALUES(9,'blackberry');
INSERT INTO "shake_flavor" VALUES(10,'coffee bean');
INSERT INTO "shake_flavor" VALUES(11,'reeses cup');
INSERT INTO "shake_flavor" VALUES(12,'heath Toffee');
INSERT INTO "shake_flavor" VALUES(13,'cappuccino');
INSERT INTO "shake_flavor" VALUES(14,'blueberry');
INSERT INTO "shake_flavor" VALUES(15,'brownie');
INSERT INTO "shake_flavor" VALUES(16,'strawberry cheesecake');
INSERT INTO "shake_flavor" VALUES(17,'fresh watermelon');
INSERT INTO "shake_flavor" VALUES(18,'fresh egg nog');
INSERT INTO "shake_flavor" VALUES(19,'chocolate malt');
INSERT INTO "shake_flavor" VALUES(20,'pineapple');
INSERT INTO "shake_flavor" VALUES(21,'peach');
INSERT INTO "shake_flavor" VALUES(22,'M&M');
INSERT INTO "shake_flavor" VALUES(23,'chocolate chip mint');
INSERT INTO "shake_flavor" VALUES(24,'oreo');
INSERT INTO "shake_flavor" VALUES(25,'snickers');
INSERT INTO "shake_flavor" VALUES(26,'red cherry');
INSERT INTO "shake_flavor" VALUES(27,'walnut');
INSERT INTO "shake_flavor" VALUES(28,'cookies and creme');
CREATE TABLE "element_type" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"element_type" TEXT
);
INSERT INTO "element_type" VALUES(1,'Antimony');
INSERT INTO "element_type" VALUES(2,'Arsenic');
INSERT INTO "element_type" VALUES(3,'Aluminum');
INSERT INTO "element_type" VALUES(4,'Selenium');
INSERT INTO "element_type" VALUES(5,'Hydrogen');
INSERT INTO "element_type" VALUES(6,'Oxygen');
INSERT INTO "element_type" VALUES(7,'Nitrogen');
INSERT INTO "element_type" VALUES(8,'Rhenium');
INSERT INTO "element_type" VALUES(9,'Nickel');
INSERT INTO "element_type" VALUES(10,'Neodymium');
INSERT INTO "element_type" VALUES(11,'Neptunium');
INSERT INTO "element_type" VALUES(12,'Germanium');
INSERT INTO "element_type" VALUES(13,'Iron');
INSERT INTO "element_type" VALUES(14,'Americium');
INSERT INTO "element_type" VALUES(15,'Ruthenium');
INSERT INTO "element_type" VALUES(16,'Uranium');
INSERT INTO "element_type" VALUES(17,'Europium');
INSERT INTO "element_type" VALUES(18,'Zirconium');
INSERT INTO "element_type" VALUES(19,'Lutetium');
INSERT INTO "element_type" VALUES(20,'Vanadium');
INSERT INTO "element_type" VALUES(21,'Lanthanum');
INSERT INTO "element_type" VALUES(22,'Osmium');
INSERT INTO "element_type" VALUES(23,'Astatine');
INSERT INTO "element_type" VALUES(24,'Radium');
INSERT INTO "element_type" VALUES(25,'Gold');
INSERT INTO "element_type" VALUES(26,'Protactinium');
INSERT INTO "element_type" VALUES(27,'Indium');
INSERT INTO "element_type" VALUES(28,'Gallium');
INSERT INTO "element_type" VALUES(29,'Iodine');
INSERT INTO "element_type" VALUES(30,'Thorium');
INSERT INTO "element_type" VALUES(31,'Thulium');
INSERT INTO "element_type" VALUES(32,'Thallium');
INSERT INTO "element_type" VALUES(33,'Yttrium');
INSERT INTO "element_type" VALUES(34,'Ytterbium');
INSERT INTO "element_type" VALUES(35,'Actinium');
INSERT INTO "element_type" VALUES(36,'Rubidium');
INSERT INTO "element_type" VALUES(37,'Boron');
INSERT INTO "element_type" VALUES(38,'Gadolinium');
INSERT INTO "element_type" VALUES(39,'Niobium');
INSERT INTO "element_type" VALUES(40,'Iridium');
INSERT INTO "element_type" VALUES(41,'Strontium');
INSERT INTO "element_type" VALUES(42,'Silicon');
INSERT INTO "element_type" VALUES(43,'Silver');
INSERT INTO "element_type" VALUES(44,'Samarium');
INSERT INTO "element_type" VALUES(45,'Bismuth');
INSERT INTO "element_type" VALUES(46,'Bromine');
INSERT INTO "element_type" VALUES(47,'Lithium');
INSERT INTO "element_type" VALUES(48,'Beryllium');
INSERT INTO "element_type" VALUES(49,'Barium');
INSERT INTO "element_type" VALUES(50,'Holmium');
INSERT INTO "element_type" VALUES(51,'Helium');
INSERT INTO "element_type" VALUES(52,'Hafnium');
INSERT INTO "element_type" VALUES(53,'Erbium');
INSERT INTO "element_type" VALUES(54,'Phosphorus');
INSERT INTO "element_type" VALUES(55,'Francium');
INSERT INTO "element_type" VALUES(56,'Fluorine');
INSERT INTO "element_type" VALUES(57,'Terbium');
INSERT INTO "element_type" VALUES(58,'Manganese');
INSERT INTO "element_type" VALUES(59,'Mercury');
INSERT INTO "element_type" VALUES(60,'Molybdenum');
INSERT INTO "element_type" VALUES(61,'Magnesium');
INSERT INTO "element_type" VALUES(62,'Dysprosium');
INSERT INTO "element_type" VALUES(63,'Scandium');
INSERT INTO "element_type" VALUES(64,'Cerium');
INSERT INTO "element_type" VALUES(65,'Cesium');
INSERT INTO "element_type" VALUES(66,'Lead');
INSERT INTO "element_type" VALUES(67,'Praseodymium');
INSERT INTO "element_type" VALUES(68,'Platinum');
INSERT INTO "element_type" VALUES(69,'Plutonium');
INSERT INTO "element_type" VALUES(70,'Palladium');
INSERT INTO "element_type" VALUES(71,'Promethium');
INSERT INTO "element_type" VALUES(72,'Potassium');
INSERT INTO "element_type" VALUES(73,'Polonium');
INSERT INTO "element_type" VALUES(74,'Tantalum');
INSERT INTO "element_type" VALUES(75,'Technetium');
INSERT INTO "element_type" VALUES(76,'Titanium');
INSERT INTO "element_type" VALUES(77,'Tellurium');
INSERT INTO "element_type" VALUES(78,'Cadmium');
INSERT INTO "element_type" VALUES(79,'Calcium');
INSERT INTO "element_type" VALUES(80,'Chromium');
INSERT INTO "element_type" VALUES(81,'Curium');
INSERT INTO "element_type" VALUES(82,'Sulfur');
INSERT INTO "element_type" VALUES(83,'Californium');
INSERT INTO "element_type" VALUES(84,'Fermium');
INSERT INTO "element_type" VALUES(85,'Berkelium');
INSERT INTO "element_type" VALUES(86,'Mendelevium');
INSERT INTO "element_type" VALUES(87,'Einsteinium');
INSERT INTO "element_type" VALUES(88,'Nobelium');
INSERT INTO "element_type" VALUES(89,'Argon');
INSERT INTO "element_type" VALUES(90,'Krypton');
INSERT INTO "element_type" VALUES(91,'Neon');
INSERT INTO "element_type" VALUES(92,'Radon');
INSERT INTO "element_type" VALUES(93,'Xenon');
INSERT INTO "element_type" VALUES(94,'Zinc');
INSERT INTO "element_type" VALUES(95,'Rhodium');
INSERT INTO "element_type" VALUES(96,'Chlorine');
INSERT INTO "element_type" VALUES(97,'Carbon');
INSERT INTO "element_type" VALUES(98,'Cobalt');
INSERT INTO "element_type" VALUES(99,'Copper');
INSERT INTO "element_type" VALUES(100,'Tungsten');
INSERT INTO "element_type" VALUES(101,'Tin');
INSERT INTO "element_type" VALUES(102,'Sodium');
INSERT INTO "element_type" VALUES(103,'Rutherfordium');
INSERT INTO "element_type" VALUES(104,'Dubnium');
INSERT INTO "element_type" VALUES(105,'Seaborgium');
INSERT INTO "element_type" VALUES(106,'Bohrium');
INSERT INTO "element_type" VALUES(107,'Hassium');
INSERT INTO "element_type" VALUES(108,'Meitnerium');
INSERT INTO "element_type" VALUES(109,'Darmstatium');
INSERT INTO "element_type" VALUES(110,'Roentgenium');
INSERT INTO "element_type" VALUES(111,'Ununbium');
INSERT INTO "element_type" VALUES(112,'Ununtrium');
INSERT INTO "element_type" VALUES(113,'Ununquadium');
INSERT INTO "element_type" VALUES(114,'Ununpentium');
INSERT INTO "element_type" VALUES(115,'Ununhexium');
INSERT INTO "element_type" VALUES(116,'Ununseptium');
INSERT INTO "element_type" VALUES(117,'Ununoctnium');
CREATE TABLE "pie_flavor" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"pie_flavor" TEXT
);
INSERT INTO "pie_flavor" VALUES(1,'apple');
INSERT INTO "pie_flavor" VALUES(2,'blueberry');
INSERT INTO "pie_flavor" VALUES(3,'blackberry');
INSERT INTO "pie_flavor" VALUES(4,'peach');
INSERT INTO "pie_flavor" VALUES(5,'chocolate');
INSERT INTO "pie_flavor" VALUES(6,'vanilla');
INSERT INTO "pie_flavor" VALUES(7,'peacan');
INSERT INTO "pie_flavor" VALUES(8,'cherry');
INSERT INTO "pie_flavor" VALUES(9,'pumpkin');
INSERT INTO "pie_flavor" VALUES(10,'strawberry');
INSERT INTO "pie_flavor" VALUES(11,'rhubarb');
INSERT INTO "pie_flavor" VALUES(12,'curry chicken');
INSERT INTO "pie_flavor" VALUES(13,'chicken pot');
INSERT INTO "pie_flavor" VALUES(14,'turkey pot');
INSERT INTO "pie_flavor" VALUES(15,'coconut');
INSERT INTO "pie_flavor" VALUES(16,'ice cream');
INSERT INTO "pie_flavor" VALUES(17,'peanut butter');
INSERT INTO "pie_flavor" VALUES(18,'bannana nut');
INSERT INTO "pie_flavor" VALUES(19,'3.14 math');
DELETE FROM sqlite_sequence;
INSERT INTO "sqlite_sequence" VALUES('insults',8);
INSERT INTO "sqlite_sequence" VALUES('cookie_flavors',36);
INSERT INTO "sqlite_sequence" VALUES('skittles_colors',12);
INSERT INTO "sqlite_sequence" VALUES('sandwich_type',10);
INSERT INTO "sqlite_sequence" VALUES('element_type',117);
INSERT INTO "sqlite_sequence" VALUES('shake_flavor',28);
INSERT INTO "sqlite_sequence" VALUES('pie_flavor',19);
COMMIT;