ALTER TABLE transcode_jobs ADD COLUMN video_folder VARCHAR(64) DEFAULT NULL AFTER video_id;
ALTER TABLE transcode_jobs ADD COLUMN storage_id INT UNSIGNED DEFAULT NULL AFTER video_folder;


UPDATE transcode_jobs j JOIN videos v ON v.id = j.video_id SET j.video_folder = v.video_folder, j.storage_id = v.storage_id WHERE j.video_folder IS NULL;
