-- ============================================================
-- The Vibe - Seed Data
-- GTA Zones + Sample Data for Development
-- ============================================================

-- ============================================================
-- GTA ZONES (PostGIS Polygons)
-- ============================================================

INSERT INTO zones (id, name, slug, boundary, center, radius_km, status, priority) VALUES

-- Downtown Toronto (priority 1 - launched first)
(
  uuid_generate_v4(),
  'Downtown Toronto',
  'downtown-toronto',
  ST_GeographyFromText('POLYGON((-79.4200 43.6400, -79.3500 43.6400, -79.3500 43.6700, -79.4200 43.6700, -79.4200 43.6400))'),
  ST_GeographyFromText('POINT(-79.3832 43.6532)'),
  5.0,
  'active',
  10
),

-- Liberty Village
(
  uuid_generate_v4(),
  'Liberty Village',
  'liberty-village',
  ST_GeographyFromText('POLYGON((-79.4300 43.6350, -79.4100 43.6350, -79.4100 43.6450, -79.4300 43.6450, -79.4300 43.6350))'),
  ST_GeographyFromText('POINT(-79.4196 43.6389)'),
  2.0,
  'active',
  9
),

-- North York
(
  uuid_generate_v4(),
  'North York',
  'north-york',
  ST_GeographyFromText('POLYGON((-79.4800 43.7500, -79.3800 43.7500, -79.3800 43.7900, -79.4800 43.7900, -79.4800 43.7500))'),
  ST_GeographyFromText('POINT(-79.4282 43.7615)'),
  6.0,
  'active',
  8
),

-- Scarborough
(
  uuid_generate_v4(),
  'Scarborough',
  'scarborough',
  ST_GeographyFromText('POLYGON((-79.2800 43.7200, -79.1700 43.7200, -79.1700 43.7800, -79.2800 43.7800, -79.2800 43.7200))'),
  ST_GeographyFromText('POINT(-79.2314 43.7568)'),
  8.0,
  'active',
  7
),

-- Mississauga
(
  uuid_generate_v4(),
  'Mississauga',
  'mississauga',
  ST_GeographyFromText('POLYGON((-79.7500 43.5500, -79.5800 43.5500, -79.5800 43.6800, -79.7500 43.6800, -79.7500 43.5500))'),
  ST_GeographyFromText('POINT(-79.6441 43.5890)'),
  12.0,
  'active',
  6
),

-- Etobicoke (coming soon)
(
  uuid_generate_v4(),
  'Etobicoke',
  'etobicoke',
  ST_GeographyFromText('POLYGON((-79.5800 43.6200, -79.4800 43.6200, -79.4800 43.7000, -79.5800 43.7000, -79.5800 43.6200))'),
  ST_GeographyFromText('POINT(-79.5300 43.6580)'),
  7.0,
  'coming_soon',
  5
),

-- East York (coming soon)
(
  uuid_generate_v4(),
  'East York',
  'east-york',
  ST_GeographyFromText('POLYGON((-79.3500 43.6800, -79.2900 43.6800, -79.2900 43.7200, -79.3500 43.7200, -79.3500 43.6800))'),
  ST_GeographyFromText('POINT(-79.3179 43.6967)'),
  4.0,
  'coming_soon',
  4
);

-- ============================================================
-- SAMPLE ADMIN USER
-- ============================================================

-- Password: Admin@123 (bcrypt hash - change in production)
INSERT INTO users (id, email, phone, password_hash, role, first_name, last_name, is_verified, is_active) VALUES
(
  'a0000000-0000-0000-0000-000000000001',
  'admin@thevibe.ca',
  '416-000-0001',
  '$2b$12$LQv3c1yqBWVHxkd0LHAkCOYz6TtxMQJqhN8/LewqmqNF1.4ABCDEF',
  'admin',
  'Platform',
  'Admin',
  TRUE,
  TRUE
);

-- ============================================================
-- SAMPLE RESTAURANTS (Development Only)
-- ============================================================

-- Restaurant owner users
INSERT INTO users (id, email, phone, password_hash, role, first_name, last_name, is_verified) VALUES
('b0000000-0000-0000-0000-000000000001', 'owner@pizzanapoli.ca', '416-555-0101', '$2b$12$placeholder', 'restaurant_owner', 'Marco', 'Rossi', TRUE),
('b0000000-0000-0000-0000-000000000002', 'owner@burgerhaus.ca', '416-555-0102', '$2b$12$placeholder', 'restaurant_owner', 'Hans', 'Mueller', TRUE),
('b0000000-0000-0000-0000-000000000003', 'owner@tokyoramen.ca', '416-555-0103', '$2b$12$placeholder', 'restaurant_owner', 'Yuki', 'Tanaka', TRUE);

-- Sample restaurants in Downtown Toronto
INSERT INTO restaurants (id, owner_id, name, slug, description, cuisine_type, phone, email, address, postal_code, location, zone_id, is_active, is_open, rating) VALUES
(
  'c0000000-0000-0000-0000-000000000001',
  'b0000000-0000-0000-0000-000000000001',
  'Pizza Napoli',
  'pizza-napoli',
  'Authentic Neapolitan pizza made with imported ingredients',
  ARRAY['Italian', 'Pizza'],
  '416-555-0101',
  'hello@pizzanapoli.ca',
  '123 King Street West, Toronto, ON',
  'M5H 1J9',
  ST_GeographyFromText('POINT(-79.3867 43.6481)'),
  (SELECT id FROM zones WHERE slug = 'downtown-toronto'),
  TRUE, TRUE, 4.8
),
(
  'c0000000-0000-0000-0000-000000000002',
  'b0000000-0000-0000-0000-000000000002',
  'Burger Haus',
  'burger-haus',
  'Premium smash burgers made fresh daily',
  ARRAY['American', 'Burgers'],
  '416-555-0102',
  'hello@burgerhaus.ca',
  '456 Queen Street West, Toronto, ON',
  'M5V 2B1',
  ST_GeographyFromText('POINT(-79.4034 43.6487)'),
  (SELECT id FROM zones WHERE slug = 'downtown-toronto'),
  TRUE, TRUE, 4.6
),
(
  'c0000000-0000-0000-0000-000000000003',
  'b0000000-0000-0000-0000-000000000003',
  'Tokyo Ramen House',
  'tokyo-ramen-house',
  'Slow-cooked tonkotsu and shoyu ramen bowls',
  ARRAY['Japanese', 'Ramen'],
  '416-555-0103',
  'hello@tokyoramen.ca',
  '789 Dundas Street West, Toronto, ON',
  'M6J 1V4',
  ST_GeographyFromText('POINT(-79.4134 43.6487)'),
  (SELECT id FROM zones WHERE slug = 'downtown-toronto'),
  TRUE, TRUE, 4.7
);

-- Sample menu categories and items for Pizza Napoli
INSERT INTO menu_categories (id, restaurant_id, name, sort_order) VALUES
('d0000000-0000-0000-0000-000000000001', 'c0000000-0000-0000-0000-000000000001', 'Pizzas', 1),
('d0000000-0000-0000-0000-000000000002', 'c0000000-0000-0000-0000-000000000001', 'Appetizers', 2),
('d0000000-0000-0000-0000-000000000003', 'c0000000-0000-0000-0000-000000000001', 'Drinks', 3);

INSERT INTO menu_items (restaurant_id, category_id, name, description, price, dietary_tags, is_featured) VALUES
('c0000000-0000-0000-0000-000000000001', 'd0000000-0000-0000-0000-000000000001', 'Margherita', 'San Marzano tomatoes, fresh mozzarella, basil', 18.00, ARRAY['vegetarian'], TRUE),
('c0000000-0000-0000-0000-000000000001', 'd0000000-0000-0000-0000-000000000001', 'Diavola', 'Spicy salami, tomato, fior di latte', 21.00, ARRAY[]::VARCHAR[], FALSE),
('c0000000-0000-0000-0000-000000000001', 'd0000000-0000-0000-0000-000000000001', 'Quattro Formaggi', 'Mozzarella, gorgonzola, parmesan, ricotta', 23.00, ARRAY['vegetarian'], FALSE),
('c0000000-0000-0000-0000-000000000001', 'd0000000-0000-0000-0000-000000000002', 'Bruschetta', 'Tomato, basil, garlic on grilled bread', 9.00, ARRAY['vegan'], FALSE),
('c0000000-0000-0000-0000-000000000001', 'd0000000-0000-0000-0000-000000000002', 'Arancini', 'Saffron risotto balls, tomato sauce', 11.00, ARRAY['vegetarian'], FALSE),
('c0000000-0000-0000-0000-000000000001', 'd0000000-0000-0000-0000-000000000003', 'San Pellegrino', 'Sparkling water 500ml', 4.00, ARRAY['vegan'], FALSE),
('c0000000-0000-0000-0000-000000000001', 'd0000000-0000-0000-0000-000000000003', 'Italian Soda', 'Aranciata or Limonata', 4.50, ARRAY['vegan'], FALSE);

-- Sample driver user
INSERT INTO users (id, email, phone, password_hash, role, first_name, last_name, is_verified) VALUES
('e0000000-0000-0000-0000-000000000001', 'driver@example.ca', '416-555-0201', '$2b$12$placeholder', 'driver', 'James', 'Driver', TRUE);

INSERT INTO drivers (id, user_id, zone_id, vehicle_type, is_approved, is_background_checked) VALUES
('f0000000-0000-0000-0000-000000000001', 'e0000000-0000-0000-0000-000000000001', (SELECT id FROM zones WHERE slug = 'downtown-toronto'), 'bicycle', TRUE, TRUE);

INSERT INTO driver_locations (driver_id, location, is_online, is_available) VALUES
('f0000000-0000-0000-0000-000000000001', ST_GeographyFromText('POINT(-79.3832 43.6532)'), FALSE, FALSE);

-- Sample customer user
INSERT INTO users (id, email, phone, password_hash, role, first_name, last_name, is_verified) VALUES
('g0000000-0000-0000-0000-000000000001', 'customer@example.ca', '416-555-0301', '$2b$12$placeholder', 'customer', 'Jane', 'Customer', TRUE);

-- ============================================================
-- LIBERTY VILLAGE RESTAURANTS (5 restaurants for MVP demo)
-- Password for all owners: Test@1234
-- bcrypt hash of Test@1234 with 12 rounds
-- ============================================================

INSERT INTO users (id, email, phone, password_hash, role, first_name, last_name, is_verified, is_active) VALUES
('b0000000-0000-0000-0001-000000000001', 'owner@libertyburgerlv.ca',  '416-555-0201', '$2b$12$LQv3c1yqBWVHxkd0LHAkCOYz6TtxMQJqhN8/lewdemohashlvbur', 'restaurant_owner', 'Tyler',  'Brooks',  TRUE, TRUE),
('b0000000-0000-0000-0001-000000000002', 'owner@mangotreelv.ca',      '416-555-0202', '$2b$12$LQv3c1yqBWVHxkd0LHAkCOYz6TtxMQJqhN8/lewdemohashlvman', 'restaurant_owner', 'Priya',  'Sharma',  TRUE, TRUE),
('b0000000-0000-0000-0001-000000000003', 'owner@cohosushilv.ca',      '416-555-0203', '$2b$12$LQv3c1yqBWVHxkd0LHAkCOYz6TtxMQJqhN8/lewdemohashlvcoh', 'restaurant_owner', 'Kenji',  'Nakamura',TRUE, TRUE),
('b0000000-0000-0000-0001-000000000004', 'owner@pizzerialiberta.ca',  '416-555-0204', '$2b$12$LQv3c1yqBWVHxkd0LHAkCOYz6TtxMQJqhN8/lewdemohashlvpiz', 'restaurant_owner', 'Sofia',  'Ricci',   TRUE, TRUE),
('b0000000-0000-0000-0001-000000000005', 'owner@greenbowllv.ca',      '416-555-0205', '$2b$12$LQv3c1yqBWVHxkd0LHAkCOYz6TtxMQJqhN8/lewdemohashlvgrn', 'restaurant_owner', 'Amara',  'Osei',    TRUE, TRUE);

INSERT INTO restaurants (id, owner_id, name, slug, description, cuisine_type, phone, email, address, city, province, postal_code, location, zone_id, is_active, is_open, accepts_orders, avg_prep_time_minutes, min_order_amount, rating, total_reviews) VALUES
(
  'c0000000-0000-0001-0000-000000000001',
  'b0000000-0000-0000-0001-000000000001',
  'Liberty Burger Co.',
  'liberty-burger-co',
  'Smash burgers, crispy fries, and cold craft sodas in the heart of Liberty Village',
  ARRAY['Burgers', 'American'],
  '416-555-0201',
  'hello@libertyburgerlv.ca',
  '50 Liberty Street, Toronto, ON',
  'Toronto', 'ON', 'M6K 3L7',
  ST_GeographyFromText('POINT(-79.4198 43.6387)'),
  (SELECT id FROM zones WHERE slug = 'liberty-village'),
  TRUE, TRUE, TRUE, 15, 12.00, 4.7, 142
),
(
  'c0000000-0000-0001-0000-000000000002',
  'b0000000-0000-0000-0001-000000000002',
  'Mango Tree',
  'mango-tree',
  'Modern Indian kitchen with butter chicken, dosas, and daily chef specials',
  ARRAY['Indian', 'South Asian'],
  '416-555-0202',
  'hello@mangotreelv.ca',
  '17 Fraser Avenue, Toronto, ON',
  'Toronto', 'ON', 'M6K 1Y7',
  ST_GeographyFromText('POINT(-79.4210 43.6395)'),
  (SELECT id FROM zones WHERE slug = 'liberty-village'),
  TRUE, TRUE, TRUE, 20, 15.00, 4.5, 98
),
(
  'c0000000-0000-0001-0000-000000000003',
  'b0000000-0000-0000-0001-000000000003',
  'Coho Sushi',
  'coho-sushi',
  'Sustainable Pacific sushi, izakaya bites, and sake served fresh daily',
  ARRAY['Japanese', 'Sushi'],
  '416-555-0203',
  'hello@cohosushilv.ca',
  '23 Hanna Avenue, Toronto, ON',
  'Toronto', 'ON', 'M6K 1W9',
  ST_GeographyFromText('POINT(-79.4185 43.6375)'),
  (SELECT id FROM zones WHERE slug = 'liberty-village'),
  TRUE, TRUE, TRUE, 18, 18.00, 4.8, 211
),
(
  'c0000000-0000-0001-0000-000000000004',
  'b0000000-0000-0000-0001-000000000004',
  'Pizzeria Liberta',
  'pizzeria-liberta',
  'Wood-fired Neapolitan pizzas and house-made pastas in a cozy Liberty Village spot',
  ARRAY['Italian', 'Pizza'],
  '416-555-0204',
  'hello@pizzerialiberta.ca',
  '71 East Liberty Street, Toronto, ON',
  'Toronto', 'ON', 'M6K 3P6',
  ST_GeographyFromText('POINT(-79.4220 43.6400)'),
  (SELECT id FROM zones WHERE slug = 'liberty-village'),
  TRUE, TRUE, TRUE, 22, 14.00, 4.6, 176
),
(
  'c0000000-0000-0001-0000-000000000005',
  'b0000000-0000-0000-0001-000000000005',
  'Green Bowl',
  'green-bowl',
  'Nourishing grain bowls, cold-press juices, and plant-based fare for every body',
  ARRAY['Vegan', 'Salads', 'Healthy'],
  '416-555-0205',
  'hello@greenbowllv.ca',
  '11 Ordnance Street, Toronto, ON',
  'Toronto', 'ON', 'M6K 0C1',
  ST_GeographyFromText('POINT(-79.4175 43.6365)'),
  (SELECT id FROM zones WHERE slug = 'liberty-village'),
  TRUE, TRUE, TRUE, 12, 10.00, 4.9, 309
);

-- ---- Liberty Burger Co. menu ----
INSERT INTO menu_categories (id, restaurant_id, name, sort_order) VALUES
('d0000000-0000-0001-0000-000000000001', 'c0000000-0000-0001-0000-000000000001', 'Burgers', 1),
('d0000000-0000-0001-0000-000000000002', 'c0000000-0000-0001-0000-000000000001', 'Sides', 2),
('d0000000-0000-0001-0000-000000000003', 'c0000000-0000-0001-0000-000000000001', 'Drinks', 3);

INSERT INTO menu_items (restaurant_id, category_id, name, description, price, dietary_tags, is_featured, is_available) VALUES
('c0000000-0000-0001-0000-000000000001', 'd0000000-0000-0001-0000-000000000001', 'The Liberty Smash', 'Double smash patty, American cheese, house sauce, pickles, brioche bun', 16.00, ARRAY[]::VARCHAR[], TRUE, TRUE),
('c0000000-0000-0001-0000-000000000001', 'd0000000-0000-0001-0000-000000000001', 'BBQ Bacon Stack', 'Triple patty, crispy bacon, aged cheddar, BBQ, caramelized onions', 21.00, ARRAY[]::VARCHAR[], TRUE, TRUE),
('c0000000-0000-0001-0000-000000000001', 'd0000000-0000-0001-0000-000000000001', 'Mushroom Swiss', 'Sautéed cremini mushrooms, Swiss cheese, garlic aioli, arugula', 17.00, ARRAY['vegetarian'], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000001', 'd0000000-0000-0001-0000-000000000001', 'Crispy Chicken Burger', 'Buttermilk fried chicken thigh, slaw, spicy mayo, pickles', 18.00, ARRAY[]::VARCHAR[], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000001', 'd0000000-0000-0001-0000-000000000002', 'Smash Fries', 'Hand-cut fries tossed in house seasoning', 6.00, ARRAY['vegan'], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000001', 'd0000000-0000-0001-0000-000000000002', 'Poutine', 'Fries, Quebec curds, chicken gravy', 11.00, ARRAY[]::VARCHAR[], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000001', 'd0000000-0000-0001-0000-000000000003', 'Craft Soda', 'Cane sugar soda — cola, ginger beer, or orange cream', 4.00, ARRAY['vegan'], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000001', 'd0000000-0000-0001-0000-000000000003', 'Milkshake', 'Thick shake — vanilla, chocolate, or strawberry', 8.00, ARRAY['vegetarian'], FALSE, TRUE);

-- ---- Mango Tree menu ----
INSERT INTO menu_categories (id, restaurant_id, name, sort_order) VALUES
('d0000000-0000-0001-0000-000000000004', 'c0000000-0000-0001-0000-000000000002', 'Mains', 1),
('d0000000-0000-0001-0000-000000000005', 'c0000000-0000-0001-0000-000000000002', 'Breads & Rice', 2),
('d0000000-0000-0001-0000-000000000006', 'c0000000-0000-0001-0000-000000000002', 'Drinks', 3);

INSERT INTO menu_items (restaurant_id, category_id, name, description, price, dietary_tags, is_featured, is_available) VALUES
('c0000000-0000-0001-0000-000000000002', 'd0000000-0000-0001-0000-000000000004', 'Butter Chicken', 'Tandoor-roasted chicken in house tomato-cream masala, served with rice', 19.00, ARRAY['gluten-free'], TRUE, TRUE),
('c0000000-0000-0001-0000-000000000002', 'd0000000-0000-0001-0000-000000000004', 'Saag Paneer', 'House-made paneer simmered in spiced spinach gravy', 17.00, ARRAY['vegetarian', 'gluten-free'], TRUE, TRUE),
('c0000000-0000-0001-0000-000000000002', 'd0000000-0000-0001-0000-000000000004', 'Lamb Rogan Josh', 'Slow-braised Ontario lamb in Kashmiri spice gravy', 24.00, ARRAY['gluten-free'], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000002', 'd0000000-0000-0001-0000-000000000004', 'Dal Makhani', 'Black lentils slow-cooked overnight with cream and butter', 15.00, ARRAY['vegetarian', 'gluten-free'], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000002', 'd0000000-0000-0001-0000-000000000005', 'Garlic Naan', 'Tandoor-baked flatbread brushed with garlic butter — 2 pieces', 5.00, ARRAY['vegetarian'], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000002', 'd0000000-0000-0001-0000-000000000005', 'Basmati Rice', 'Aromatic long-grain basmati, cardamom and bay leaf', 4.00, ARRAY['vegan', 'gluten-free'], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000002', 'd0000000-0000-0001-0000-000000000006', 'Mango Lassi', 'Alphonso mango blended with yogurt and cardamom', 6.00, ARRAY['vegetarian'], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000002', 'd0000000-0000-0001-0000-000000000006', 'Masala Chai', 'House-spiced tea with oat milk', 4.50, ARRAY['vegetarian'], FALSE, TRUE);

-- ---- Coho Sushi menu ----
INSERT INTO menu_categories (id, restaurant_id, name, sort_order) VALUES
('d0000000-0000-0001-0000-000000000007', 'c0000000-0000-0001-0000-000000000003', 'Rolls', 1),
('d0000000-0000-0001-0000-000000000008', 'c0000000-0000-0001-0000-000000000003', 'Nigiri & Sashimi', 2),
('d0000000-0000-0001-0000-000000000009', 'c0000000-0000-0001-0000-000000000003', 'Izakaya Bites', 3);

INSERT INTO menu_items (restaurant_id, category_id, name, description, price, dietary_tags, is_featured, is_available) VALUES
('c0000000-0000-0001-0000-000000000003', 'd0000000-0000-0001-0000-000000000007', 'Coho Roll', 'BC salmon, cucumber, avocado, ponzu drizzle — 8 pieces', 16.00, ARRAY['gluten-free'], TRUE, TRUE),
('c0000000-0000-0001-0000-000000000003', 'd0000000-0000-0001-0000-000000000007', 'Spicy Tuna Crunch', 'Spicy tuna, tempura flakes, sriracha mayo — 8 pieces', 17.00, ARRAY[]::VARCHAR[], TRUE, TRUE),
('c0000000-0000-0001-0000-000000000003', 'd0000000-0000-0001-0000-000000000007', 'Veggie Dragon', 'Cucumber, pickled daikon, avocado, sesame — 8 pieces', 13.00, ARRAY['vegan', 'gluten-free'], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000003', 'd0000000-0000-0001-0000-000000000008', 'Salmon Nigiri', 'Two pieces hand-pressed sushi rice with Atlantic salmon', 8.00, ARRAY['gluten-free'], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000003', 'd0000000-0000-0001-0000-000000000008', 'Tuna Sashimi', 'Five slices of bluefin tuna, wasabi, pickled ginger', 18.00, ARRAY['gluten-free'], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000003', 'd0000000-0000-0001-0000-000000000009', 'Edamame', 'Steamed salted soybeans', 5.00, ARRAY['vegan', 'gluten-free'], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000003', 'd0000000-0000-0001-0000-000000000009', 'Gyoza', 'Pan-fried pork and cabbage dumplings, ponzu dip — 6 pieces', 11.00, ARRAY[]::VARCHAR[], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000003', 'd0000000-0000-0001-0000-000000000009', 'Miso Soup', 'Tofu, wakame, green onion in dashi broth', 4.00, ARRAY['vegetarian'], FALSE, TRUE);

-- ---- Pizzeria Liberta menu ----
INSERT INTO menu_categories (id, restaurant_id, name, sort_order) VALUES
('d0000000-0000-0001-0000-000000000010', 'c0000000-0000-0001-0000-000000000004', 'Pizzas', 1),
('d0000000-0000-0001-0000-000000000011', 'c0000000-0000-0001-0000-000000000004', 'Pasta', 2),
('d0000000-0000-0001-0000-000000000012', 'c0000000-0000-0001-0000-000000000004', 'Drinks', 3);

INSERT INTO menu_items (restaurant_id, category_id, name, description, price, dietary_tags, is_featured, is_available) VALUES
('c0000000-0000-0001-0000-000000000004', 'd0000000-0000-0001-0000-000000000010', 'Margherita DOC', 'San Marzano DOP tomatoes, buffalo mozzarella, fresh basil, EVOO', 20.00, ARRAY['vegetarian'], TRUE, TRUE),
('c0000000-0000-0001-0000-000000000004', 'd0000000-0000-0001-0000-000000000010', 'Nduja Piccante', 'Calabrian nduja sausage, San Marzano, fior di latte, chili', 23.00, ARRAY[]::VARCHAR[], TRUE, TRUE),
('c0000000-0000-0001-0000-000000000004', 'd0000000-0000-0001-0000-000000000010', 'Funghi e Tartufo', 'Mixed mushrooms, truffle oil, taleggio, thyme — no tomato', 25.00, ARRAY['vegetarian'], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000004', 'd0000000-0000-0001-0000-000000000010', 'Prosciutto Rucola', 'Prosciutto di Parma, aged parmesan, cherry tomatoes, baby arugula', 26.00, ARRAY[]::VARCHAR[], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000004', 'd0000000-0000-0001-0000-000000000011', 'Cacio e Pepe', 'House tonnarelli, pecorino romano, toasted black pepper', 19.00, ARRAY['vegetarian'], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000004', 'd0000000-0000-0001-0000-000000000011', 'Orecchiette Salsiccia', 'House pasta, pork sausage, broccoli rabe, chili, garlic', 22.00, ARRAY[]::VARCHAR[], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000004', 'd0000000-0000-0001-0000-000000000012', 'San Pellegrino', 'Sparkling water 500ml', 4.00, ARRAY['vegan'], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000004', 'd0000000-0000-0001-0000-000000000012', 'Aranciata', 'Blood orange soda, San Pellegrino', 4.50, ARRAY['vegan'], FALSE, TRUE);

-- ---- Green Bowl menu ----
INSERT INTO menu_categories (id, restaurant_id, name, sort_order) VALUES
('d0000000-0000-0001-0000-000000000013', 'c0000000-0000-0001-0000-000000000005', 'Grain Bowls', 1),
('d0000000-0000-0001-0000-000000000014', 'c0000000-0000-0001-0000-000000000005', 'Salads', 2),
('d0000000-0000-0001-0000-000000000015', 'c0000000-0000-0001-0000-000000000005', 'Juices & Smoothies', 3);

INSERT INTO menu_items (restaurant_id, category_id, name, description, price, dietary_tags, is_featured, is_available) VALUES
('c0000000-0000-0001-0000-000000000005', 'd0000000-0000-0001-0000-000000000013', 'The Liberty Bowl', 'Brown rice, roasted sweet potato, black beans, avocado, tahini drizzle', 15.00, ARRAY['vegan', 'gluten-free'], TRUE, TRUE),
('c0000000-0000-0001-0000-000000000005', 'd0000000-0000-0001-0000-000000000013', 'Protein Power Bowl', 'Quinoa, grilled tofu, edamame, pickled beet, miso-ginger dressing', 16.00, ARRAY['vegan', 'gluten-free'], TRUE, TRUE),
('c0000000-0000-0001-0000-000000000005', 'd0000000-0000-0001-0000-000000000013', 'Harvest Farro Bowl', 'Farro, roasted squash, kale, dried cranberry, pepitas, apple cider vin', 14.00, ARRAY['vegan'], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000005', 'd0000000-0000-0001-0000-000000000014', 'Massaged Kale Caesar', 'Kale, house vegan caesar, hemp parmesan, sourdough croutons', 13.00, ARRAY['vegan'], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000005', 'd0000000-0000-0001-0000-000000000014', 'Beet & Arugula', 'Roasted golden beet, arugula, walnuts, goat cheese, balsamic glaze', 14.00, ARRAY['vegetarian', 'gluten-free'], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000005', 'd0000000-0000-0001-0000-000000000015', 'Green Machine', 'Spinach, cucumber, celery, green apple, ginger, lemon', 9.00, ARRAY['vegan', 'gluten-free'], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000005', 'd0000000-0000-0001-0000-000000000015', 'Mango Turmeric Smoothie', 'Frozen mango, banana, turmeric, oat milk, maple', 10.00, ARRAY['vegan', 'gluten-free'], FALSE, TRUE),
('c0000000-0000-0001-0000-000000000005', 'd0000000-0000-0001-0000-000000000015', 'Cold Brew', 'Single-origin cold brew, 12oz', 5.50, ARRAY['vegan'], FALSE, TRUE);

-- Update the seeded driver to also cover Liberty Village zone
UPDATE drivers
SET zone_id = (SELECT id FROM zones WHERE slug = 'liberty-village')
WHERE id = 'f0000000-0000-0000-0000-000000000001';

UPDATE driver_locations
SET location = ST_GeographyFromText('POINT(-79.4196 43.6389)')
WHERE driver_id = 'f0000000-0000-0000-0000-000000000001';