app/social/migrations/0005_x_text_posts.sql

-- X text-only posts. This is additive and preserves all existing media posts.
-- Apply this migration explicitly in production; SQLite test databases use
-- the updated SQLAlchemy model through social_auto_migrate.

begin;

alter table social_posts
  alter column media_asset_id drop not null;

commit;