-- Ember & Vine — demo seed data
-- Import after schema.sql: mysql -u USER -p DBNAME < seed.sql

INSERT INTO categories (id, name, sort_order) VALUES
(1,'Starters',1), (2,'Mains',2), (3,'Desserts',3), (4,'Drinks',4);

INSERT INTO allergens (id, name, icon) VALUES
('gluten','Gluten','🌾'), ('dairy','Dairy','🧀'), ('nuts','Tree Nuts','🌰'),
('peanuts','Peanuts','🥜'), ('shellfish','Shellfish','🦐'), ('egg','Egg','🥚'),
('soy','Soy','🫘'), ('sesame','Sesame','🫙'), ('fish','Fish','🐟');

INSERT INTO items
(id, category_id, name, description, ingredients, price, image_url, calories, protein_g, carbs_g, fat_g, spice_level, is_vegan, is_vegetarian, is_gluten_free) VALUES
(1,1,'Charred Corn Elote Dip','Fire-roasted corn, cotija, lime crema, chili dust, warm tortilla chips.','Corn, cotija cheese, crema, lime, chili powder, corn tortilla chips, cilantro.',11.00,'https://images.unsplash.com/photo-1601050690597-df0568f70950?w=400&q=70',420,9,38,26,2,0,1,0),
(2,1,'Crispy Truffle Fries','Hand-cut fries tossed in truffle oil, parmesan, fresh herbs.','Potatoes, truffle oil, parmesan, parsley, sea salt.',8.00,'https://images.unsplash.com/photo-1573080496219-bb080dd4f877?w=400&q=70',510,7,52,31,0,0,1,0),
(3,1,'Ember-Grilled Wings','Smoked and charred, tossed in bourbon-chili glaze.','Chicken wings, bourbon, chili, soy glaze, scallion.',13.00,'https://images.unsplash.com/photo-1608039755401-742074f0548d?w=400&q=70',640,38,18,44,3,0,0,0),
(4,1,'Burrata & Heirloom Tomato','Creamy burrata, basil oil, aged balsamic, flaky salt.','Burrata, heirloom tomato, basil, olive oil, balsamic.',14.00,'https://images.unsplash.com/photo-1608897013039-887f21d8c804?w=400&q=70',390,16,12,31,0,0,1,1),
(5,1,'Charcoal Shrimp Skewers','Chili-lime marinated shrimp, smoked over open flame.','Shrimp, chili, lime, garlic, olive oil.',15.00,'https://images.unsplash.com/photo-1625943555837-e5da8e5e3f3a?w=400&q=70',310,29,6,17,2,0,0,1),
(6,2,'Ember House Burger','Dry-aged beef, smoked cheddar, brioche, oak-fire glaze.','Beef patty, cheddar, brioche bun, lettuce, tomato, house sauce.',18.00,'https://images.unsplash.com/photo-1568901346375-23c9450c58cd?w=400&q=70',920,48,46,58,0,0,0,0),
(7,2,'Wood-Fired Ribeye 10oz','Grass-fed ribeye, rosemary butter, char-grilled over oak.','Ribeye steak, rosemary, butter, sea salt, cracked pepper.',36.00,'https://images.unsplash.com/photo-1546833999-b9f581a1996d?w=400&q=70',820,58,2,62,0,0,0,1),
(8,2,'Charred Cauliflower Steak','Whole roasted cauliflower, romesco, toasted almonds.','Cauliflower, red pepper romesco, almonds, parsley.',19.00,'https://images.unsplash.com/photo-1568584711271-6c929fa970c7?w=400&q=70',410,12,34,24,0,1,1,1),
(9,2,'Smoked Salmon Fillet','Applewood smoked, citrus glaze, charred asparagus.','Salmon, citrus glaze, asparagus, herbs.',27.00,'https://images.unsplash.com/photo-1467003909585-2f8a72700288?w=400&q=70',560,44,14,34,0,0,0,1),
(10,2,'Fire-Roasted Half Chicken','Spatchcocked, herb brined, roasted over live fire.','Chicken, herb brine, garlic, lemon.',24.00,'https://images.unsplash.com/photo-1598103442097-8b74394b95c6?w=400&q=70',690,56,6,44,0,0,0,1),
(11,2,'Wild Mushroom Risotto','Charred wild mushrooms, parmesan, black truffle oil.','Arborio rice, mushrooms, parmesan, truffle oil, white wine.',21.00,'https://images.unsplash.com/photo-1476124369491-e7addf5db371?w=400&q=70',640,16,78,26,0,0,1,1),
(12,2,'Blackened Cajun Catfish','Cast-iron seared, remoulade, charred corn succotash.','Catfish, cajun spice, remoulade, corn, peppers.',23.00,'https://images.unsplash.com/photo-1580476262798-bddd9f4b7369?w=400&q=70',580,41,22,34,3,0,0,0),
(13,3,'Smoked Chocolate Torte','Dense flourless torte, hickory-smoked ganache.','Dark chocolate, butter, eggs, smoked cream.',9.00,'https://images.unsplash.com/photo-1606313564200-e75d5e30476c?w=400&q=70',480,6,44,31,0,0,1,1),
(14,3,'Charred Peach Cobbler','Grilled peaches, brown butter crumble, vanilla bean ice cream.','Peaches, flour, butter, oats, vanilla ice cream.',10.00,'https://images.unsplash.com/photo-1568571780765-9276ac8b75a2?w=400&q=70',520,5,68,24,0,0,1,0),
(15,3,'Bourbon Bread Pudding','Brioche pudding, bourbon caramel, toasted pecans.','Brioche, cream, eggs, bourbon caramel, pecans.',10.00,'https://images.unsplash.com/photo-1624353365286-3f8d62daad51?w=400&q=70',610,8,70,28,0,0,1,0),
(16,3,'Vegan Berry Crumble','Mixed berries, oat crumble, coconut cream.','Mixed berries, oats, coconut cream, maple syrup.',9.00,'https://images.unsplash.com/photo-1488477181946-6428a0291777?w=400&q=70',390,4,58,15,0,1,1,1),
(17,4,'Smoked Old Fashioned','Bourbon, oak smoke, orange bitters, brandied cherry.','Bourbon, bitters, sugar, orange, cherry.',14.00,'https://images.unsplash.com/photo-1470337458703-46ad1756a187?w=400&q=70',180,0,8,0,0,0,0,1),
(18,4,'Ember Sunrise Mocktail','Blood orange, ginger, soda, fire-charred rosemary.','Blood orange juice, ginger, soda water, rosemary.',8.00,'https://images.unsplash.com/photo-1546171753-97d7676e4602?w=400&q=70',120,0,29,0,0,1,1,1),
(19,4,'Sunrise Cold Brew','House cold brew, oat milk, cinnamon.','Cold brew coffee, oat milk, cinnamon.',6.00,'https://images.unsplash.com/photo-1461023058943-07fcbe16d735?w=400&q=70',90,2,12,3,0,1,1,1),
(20,4,'Grilled Peach Bellini','Prosecco, charred peach purée, mint.','Prosecco, peach purée, mint.',12.00,'https://images.unsplash.com/photo-1536935338788-846bb9981813?w=400&q=70',160,0,15,0,0,0,1,1);

INSERT INTO item_allergens (item_id, allergen_id) VALUES
(1,'dairy'),(1,'gluten'),
(2,'dairy'),
(3,'soy'),
(4,'dairy'),
(5,'shellfish'),
(6,'gluten'),(6,'dairy'),(6,'egg'),
(7,'dairy'),
(8,'nuts'),
(12,'egg'),(12,'fish'),
(13,'dairy'),(13,'egg'),
(14,'gluten'),(14,'dairy'),
(15,'gluten'),(15,'dairy'),(15,'egg'),(15,'nuts');

-- Suggestion engine rules table: kept simple/explainable for demo walkthroughs
INSERT INTO suggestion_rules (trigger_item_id, suggested_item_id, type, message, threshold_cents, time_window) VALUES
(6, 2, 'pairing', 'Pairs well with Truffle Fries', NULL, NULL),
(6, 17, 'pairing', 'Guests often add a Smoked Old Fashioned', NULL, NULL),
(2, 2, 'upsell', 'Upgrade to Truffle Parmesan for +$3', NULL, NULL),
(7, 11, 'pairing', 'Try it with Wild Mushroom Risotto', NULL, NULL),
(9, 18, 'pairing', 'A citrus mocktail complements the salmon', NULL, NULL),
(NULL, 13, 'threshold', 'You''re $4 away from free dessert delivery!', 6000, NULL),
(NULL, 19, 'time', 'Good morning — start with a Sunrise Cold Brew', NULL, 'breakfast'),
(NULL, 20, 'time', 'It''s Happy Hour — Grilled Peach Bellini, today only', NULL, 'happy_hour');