flatrender/services/content/migrations/001_blog_kind_learn_page.sql

-- Adds the Learn + Page values to the content.blog_kind enum so the Blog entity
-- can power the public Learn (tutorials) section and the static CMS pages
-- (About, Privacy, Terms, …) in addition to Blog/Landing.
--
-- Idempotent. ADD VALUE cannot run inside a transaction on older PG, so apply
-- each statement on its own (psql autocommit):
--   docker exec fr2-postgres sh -c 'PGPASSWORD="$POSTGRES_PASSWORD" psql -U "$POSTGRES_USER" -d flatrender -f -' < 001_blog_kind_learn_page.sql
ALTER TYPE content.blog_kind ADD VALUE IF NOT EXISTS 'Learn';
ALTER TYPE content.blog_kind ADD VALUE IF NOT EXISTS 'Page';