ALTER TABLE pages
  ADD COLUMN IF NOT EXISTS is_listed BOOLEAN NOT NULL DEFAULT false,
  ADD COLUMN IF NOT EXISTS is_featured BOOLEAN NOT NULL DEFAULT false,
  ADD COLUMN IF NOT EXISTS listing_section TEXT NOT NULL DEFAULT '',
  ADD COLUMN IF NOT EXISTS listing_title TEXT NOT NULL DEFAULT '',
  ADD COLUMN IF NOT EXISTS listing_description TEXT NOT NULL DEFAULT '',
  ADD COLUMN IF NOT EXISTS listing_sort_order INTEGER NOT NULL DEFAULT 0;

CREATE INDEX IF NOT EXISTS pages_listing_public_idx
  ON pages (is_listed, status, listing_section ASC, listing_sort_order ASC, updated_at DESC);

CREATE INDEX IF NOT EXISTS pages_featured_public_idx
  ON pages (is_featured, status, listing_sort_order ASC, updated_at DESC);