-- Migration: add externe_identifier and body_text columns to motions
-- externe_identifier: e.g. "kst-36600-VII-28" from DocumentVersie.ExterneIdentifier
-- body_text: full plain-text motion body scraped from officielebekendmakingen.nl

ALTER TABLE motions ADD COLUMN IF NOT EXISTS externe_identifier VARCHAR;
ALTER TABLE motions ADD COLUMN IF NOT EXISTS body_text VARCHAR;