UPDATE episode_storyboards storyboard
SET project_id = episode.project_id, episode_id = NULL
FROM project_episodes episode
JOIN creative_projects project ON project.id = episode.project_id
WHERE storyboard.episode_id = episode.id AND project.project_type = 'video_redraw';

ALTER TABLE project_episodes DROP COLUMN redraw_script;
