ALTER TABLE "social_post_media"
  ADD COLUMN "processing_progress" SMALLINT NOT NULL DEFAULT 100;

UPDATE "social_post_media"
SET "processing_progress" = 0
WHERE "processing_status" = 'PROCESSING';

ALTER TABLE "social_post_media"
  ADD CONSTRAINT "social_post_media_processing_progress_check"
  CHECK ("processing_progress" BETWEEN 0 AND 100);