BEGIN;

ALTER TABLE creative_projects
    DROP CONSTRAINT IF EXISTS creative_projects_cast_members_check,
    DROP CONSTRAINT IF EXISTS creative_projects_play_count_check,
    DROP COLUMN IF EXISTS cast_members,
    DROP COLUMN IF EXISTS producer,
    DROP COLUMN IF EXISTS audience_profile,
    DROP COLUMN IF EXISTS play_count,
    DROP COLUMN IF EXISTS short_drama_type;

COMMIT;
