8 lines
330 B
SQL
8 lines
330 B
SQL
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;
|