-- =============================================================================
-- 012 — Guest languages (English / Hindi / both) — docs/FEATURES-GUEST-LANGUAGES.md
--   * Admin picks which languages guests see: 'en', 'hi' or 'en_hi' (guest switch + both names).
--   * Every guest-facing menu text gets an optional Hindi twin (*_hi). NULL = fall back to English.
--   * Order items snapshot the Hindi names too (guest order views + KOT print).
--   * Addon snapshots (order_items.addons / session cart JSON) gain optional keys nameHi / groupNameHi.
-- =============================================================================

ALTER TABLE restaurant_settings
  ADD COLUMN guest_languages        ENUM('en','hi','en_hi') NOT NULL DEFAULT 'en' AFTER online_orders_enabled,
  ADD COLUMN guest_default_language ENUM('en','hi')         NOT NULL DEFAULT 'en' AFTER guest_languages,
  ADD COLUMN print_kot_hindi        TINYINT(1)              NOT NULL DEFAULT 1    AFTER guest_default_language;

ALTER TABLE restaurants
  ADD COLUMN description_hi TEXT          NULL AFTER description,
  ADD COLUMN cuisine_hi     VARCHAR(150)  NULL AFTER cuisine;

ALTER TABLE menu_categories
  ADD COLUMN name_hi        VARCHAR(100) NULL AFTER name,
  ADD COLUMN description_hi VARCHAR(500) NULL AFTER description;

ALTER TABLE menu_items
  ADD COLUMN name_hi          VARCHAR(150) NULL AFTER name,
  ADD COLUMN description_hi   TEXT         NULL AFTER description,
  ADD COLUMN featured_note_hi VARCHAR(255) NULL AFTER featured_note;

ALTER TABLE menu_item_variants
  ADD COLUMN name_hi VARCHAR(100) NULL AFTER name;

ALTER TABLE menu_addon_groups
  ADD COLUMN name_hi VARCHAR(100) NULL AFTER name;

ALTER TABLE menu_addons
  ADD COLUMN name_hi VARCHAR(100) NULL AFTER name;

ALTER TABLE order_items
  ADD COLUMN item_name_hi    VARCHAR(150) NULL AFTER item_name,
  ADD COLUMN variant_name_hi VARCHAR(100) NULL AFTER variant_name;
