ALTER TABLE meta_subjects DROP CONSTRAINT either_subject_or_redirect_not_null;

ALTER TABLE meta_subjects ALTER subject DROP NOT NULL;

UPDATE meta_subjects SET subject = NULL WHERE subject = 'invalid:subject.null';