-- Brand content (replaces hardcoded src/data/brand-content.ts)
-- Admin-editable per-brand content for /merken/[slug] pages

CREATE TABLE IF NOT EXISTS brand_content (
  slug              TEXT PRIMARY KEY,
  name              TEXT NOT NULL,
  tagline           TEXT,
  description       TEXT,
  long_description  TEXT,
  founded           TEXT,
  headquarters      TEXT,
  founders          TEXT,
  logo_url          TEXT,
  hero_image_url    TEXT,
  popular_models    JSONB DEFAULT '[]',
  seo_title         TEXT,
  seo_description   TEXT,
  enabled           BOOLEAN NOT NULL DEFAULT true,
  sort_order        SMALLINT DEFAULT 0,
  created_at        TIMESTAMPTZ NOT NULL DEFAULT now(),
  updated_at        TIMESTAMPTZ NOT NULL DEFAULT now()
);

CREATE INDEX IF NOT EXISTS idx_brand_content_enabled ON brand_content (enabled, sort_order);
