SamTV12345-PodFetch/migrations/postgres/2023-08-27-143946_podcast_e.../up.sql

6 lines
270 B
SQL

-- Your SQL goes here
ALTER TABLE podcast_episodes ADD COLUMN file_episode_path TEXT;
ALTER TABLE podcast_episodes ADD COLUMN file_image_path TEXT;
UPDATE podcast_episodes SET file_episode_path = local_url;
UPDATE podcast_episodes SET file_image_path = local_image_url;