-- +goose Up
-- Posts, page intros and announcements can be written as raw HTML instead of
-- Markdown; the *_md column holds the source either way, format says which.
ALTER TABLE posts    ADD COLUMN format text NOT NULL DEFAULT 'markdown' CHECK (format IN ('markdown', 'html'));
ALTER TABLE pages    ADD COLUMN format text NOT NULL DEFAULT 'markdown' CHECK (format IN ('markdown', 'html'));
ALTER TABLE sections ADD COLUMN format text NOT NULL DEFAULT 'markdown' CHECK (format IN ('markdown', 'html'));

-- +goose Down
ALTER TABLE posts DROP COLUMN format;
ALTER TABLE pages DROP COLUMN format;
ALTER TABLE sections DROP COLUMN format;