

-- Insert demo restaurants
INSERT INTO restaurants (id, owner_id, name, description, cuisine_type, theme) VALUES
(
  '660e8400-e29b-41d4-a716-446655440001',
  '550e8400-e29b-41d4-a716-446655440000',
  '{"en": "Bella Italia", "de": "Bella Italia", "ar": "بيلا إيطاليا", "tr": "Bella Italia"}',
  '{"en": "Authentic Italian Cuisine", "de": "Authentische italienische Küche", "ar": "مطبخ إيطالي أصيل", "tr": "Otantik İtalyan Mutfağı"}',
  'italian',
  '{"primaryColor": "#2563eb", "secondaryColor": "#1e40af", "fontFamily": "Lato"}'
),
(
  '660e8400-e29b-41d4-a716-446655440002',
  '550e8400-e29b-41d4-a716-446655440000',
  '{"en": "Sushi Master", "de": "Sushi Meister", "ar": "سوشي ماستر", "tr": "Sushi Ustası"}',
  '{"en": "Premium Japanese Sushi", "de": "Premium japanisches Sushi", "ar": "سوشي ياباني فاخر", "tr": "Premium Japon Suşi"}',
  'japanese',
  '{"primaryColor": "#dc2626", "secondaryColor": "#991b1b", "fontFamily": "Roboto"}'
);

-- Insert demo categories for Bella Italia
INSERT INTO categories (id, restaurant_id, name, description, order_index) VALUES
(
  '770e8400-e29b-41d4-a716-446655440001',
  '660e8400-e29b-41d4-a716-446655440001',
  '{"en": "Appetizers", "de": "Vorspeisen", "ar": "المقبلات", "tr": "Başlangıçlar"}',
  '{"en": "Start your meal right", "de": "Beginnen Sie Ihre Mahlzeit richtig", "ar": "ابدأ وجبتك بشكل صحيح", "tr": "Yemeğinize doğru başlayın"}',
  1
),
(
  '770e8400-e29b-41d4-a716-446655440002',
  '660e8400-e29b-41d4-a716-446655440001',
  '{"en": "Pasta", "de": "Pasta", "ar": "باستا", "tr": "Makarna"}',
  '{"en": "Fresh homemade pasta", "de": "Frische hausgemachte Pasta", "ar": "باستا طازجة محلية الصنع", "tr": "Taze ev yapımı makarna"}',
  2
);

-- Insert demo menu items for Bella Italia
INSERT INTO menu_items (id, restaurant_id, category_id, name, description, price, allergens, ingredients) VALUES
(
  '880e8400-e29b-41d4-a716-446655440001',
  '660e8400-e29b-41d4-a716-446655440001',
  '770e8400-e29b-41d4-a716-446655440001',
  '{"en": "Bruschetta", "de": "Bruschetta", "ar": "بروسكيتا", "tr": "Bruschetta"}',
  '{"en": "Toasted bread with tomatoes and garlic", "de": "Geröstetes Brot mit Tomaten und Knoblauch", "ar": "خبز محمص مع طماطم وثوم", "tr": "Domatesli ve sarımsaklı kızarmış ekmek"}',
  8.99,
  '["gluten", "garlic"]',
  '["bread", "tomatoes", "garlic", "olive oil", "basil"]'
),
(
  '880e8400-e29b-41d4-a716-446655440002',
  '660e8400-e29b-41d4-a716-446655440001',
  '770e8400-e29b-41d4-a716-446655440002',
  '{"en": "Spaghetti Carbonara", "de": "Spaghetti Carbonara", "ar": "سباغيتي كاربونارا", "tr": "Spagetti Carbonara"}',
  '{"en": "Classic carbonara with pancetta", "de": "Klassische Carbonara mit Pancetta", "ar": "كاربونارا كلاسيكية مع لحم البانسيتا", "tr": "Pancettalı klasik carbonara"}',
  16.99,
  '["gluten", "eggs", "dairy"]',
  '["spaghetti", "eggs", "pancetta", "pecorino", "black pepper"]'
);

-- Insert demo categories for Sushi Master
INSERT INTO categories (id, restaurant_id, name, description, order_index) VALUES
(
  '770e8400-e29b-41d4-a716-446655440003',
  '660e8400-e29b-41d4-a716-446655440002',
  '{"en": "Nigiri", "de": "Nigiri", "ar": "نيجيري", "tr": "Nigiri"}',
  '{"en": "Hand-pressed sushi", "de": "Handgeformtes Sushi", "ar": "سوشي مضغوط يدويا", "tr": "Elle preslenmiş suşi"}',
  1
),
(
  '770e8400-e29b-41d4-a716-446655440004',
  '660e8400-e29b-41d4-a716-446655440002',
  '{"en": "Maki Rolls", "de": "Maki Rollen", "ar": "لفائف ماكي", "tr": "Maki Ruloları"}',
  '{"en": "Classic rolled sushi", "de": "Klassische Sushi-Rollen", "ar": "سوشي ملفوف كلاسيكي", "tr": "Klasik rulo suşi"}',
  2
);

-- Insert demo menu items for Sushi Master
INSERT INTO menu_items (id, restaurant_id, category_id, name, description, price, allergens, ingredients) VALUES
(
  '880e8400-e29b-41d4-a716-446655440003',
  '660e8400-e29b-41d4-a716-446655440002',
  '770e8400-e29b-41d4-a716-446655440003',
  '{"en": "Salmon Nigiri", "de": "Lachs Nigiri", "ar": "نيجيري السلمون", "tr": "Somon Nigiri"}',
  '{"en": "Fresh salmon on pressed rice", "de": "Frischer Lachs auf gepresstem Reis", "ar": "سلمون طازج على أرز مضغوط", "tr": "Preslenmiş pilav üzerine taze somon"}',
  7.99,
  '["fish"]',
  '["salmon", "sushi rice", "wasabi"]'
),
(
  '880e8400-e29b-41d4-a716-446655440004',
  '660e8400-e29b-41d4-a716-446655440002',
  '770e8400-e29b-41d4-a716-446655440004',
  '{"en": "California Roll", "de": "California Rolle", "ar": "لفة كاليفورنيا", "tr": "Kaliforniya Rulosu"}',
  '{"en": "Crab, avocado and cucumber roll", "de": "Krabben, Avocado und Gurken-Rolle", "ar": "لفة السلطعون والأفوكادو والخيار", "tr": "Yengeç, avokado ve salatalık rulosu"}',
  12.99,
  '["shellfish", "eggs"]',
  '["crab meat", "avocado", "cucumber", "rice", "nori", "sesame seeds"]'
);

-- Insert demo subscriptions
INSERT INTO subscriptions (id, restaurant_id, plan_name, status, current_period_start, current_period_end) VALUES
(
  '990e8400-e29b-41d4-a716-446655440001',
  '660e8400-e29b-41d4-a716-446655440001',
  'professional',
  'active',
  CURRENT_TIMESTAMP,
  CURRENT_TIMESTAMP + INTERVAL '1 month'
),
(
  '990e8400-e29b-41d4-a716-446655440002',
  '660e8400-e29b-41d4-a716-446655440002',
  'professional',
  'active',
  CURRENT_TIMESTAMP,
  CURRENT_TIMESTAMP + INTERVAL '1 month'
);

-- Insert demo integrations
INSERT INTO integrations (id, restaurant_id, type, provider, status, last_sync) VALUES
(
  'aa0e8400-e29b-41d4-a716-446655440001',
  '660e8400-e29b-41d4-a716-446655440001',
  'pos',
  'lightspeed',
  'active',
  CURRENT_TIMESTAMP
),
(
  'aa0e8400-e29b-41d4-a716-446655440002',
  '660e8400-e29b-41d4-a716-446655440002',
  'delivery',
  'uber_eats',
  'active',
  CURRENT_TIMESTAMP
);
