-- Migration 008: Model SEO Content
-- Run: psql -d sneakerpicks -f db/migrations/008_model_content.sql

BEGIN;

CREATE TABLE IF NOT EXISTS model_content (
  id SERIAL PRIMARY KEY,
  brand_slug TEXT NOT NULL,
  model_slug TEXT NOT NULL,
  model_name TEXT NOT NULL,
  intro TEXT,
  description TEXT,
  faq JSONB,
  generated_at TIMESTAMPTZ DEFAULT NOW(),
  updated_at TIMESTAMPTZ DEFAULT NOW(),
  UNIQUE(brand_slug, model_slug)
);

CREATE INDEX IF NOT EXISTS idx_model_content_lookup ON model_content(brand_slug, model_slug);

COMMIT;
