-- =====================================================================
-- 010: "Menu book" — a page-flip, printed-menu style view guests can switch to.
--      Admin decides: on/off, default view, theme, auto-generated vs uploaded page
--      photos, cover texts/image, and whether images/descriptions are shown.
-- =====================================================================

ALTER TABLE restaurant_settings
  ADD COLUMN menu_book_enabled           TINYINT(1)   NOT NULL DEFAULT 1 AFTER loyalty_enabled,
  ADD COLUMN menu_default_view           ENUM('cards','book') NOT NULL DEFAULT 'cards' AFTER menu_book_enabled,
  ADD COLUMN menu_book_theme             ENUM('classic','elegant','modern','rustic') NOT NULL DEFAULT 'classic' AFTER menu_default_view,
  ADD COLUMN menu_book_source            ENUM('auto','pages') NOT NULL DEFAULT 'auto' AFTER menu_book_theme,
  ADD COLUMN menu_book_pages             JSON NULL AFTER menu_book_source,            -- uploaded page image URLs, in order
  ADD COLUMN menu_book_cover_title       VARCHAR(100) NULL AFTER menu_book_pages,     -- default: restaurant name
  ADD COLUMN menu_book_cover_subtitle    VARCHAR(160) NULL AFTER menu_book_cover_title,
  ADD COLUMN menu_book_cover_image_url   VARCHAR(500) NULL AFTER menu_book_cover_subtitle, -- default: restaurant cover image
  ADD COLUMN menu_book_show_images       TINYINT(1)   NOT NULL DEFAULT 1 AFTER menu_book_cover_image_url,
  ADD COLUMN menu_book_show_descriptions TINYINT(1)   NOT NULL DEFAULT 1 AFTER menu_book_show_images;
