twotalesanimation
8 lines
364 B
SQL
8 lines
364 B
SQL
-- Export paths are {outputRoot}/{showId}/[{episode}]/{shotCode}/{version}.
|
|
-- A stored "render.outputRoot" of "//SAN/renders" injected a stray "renders/"
|
|
-- segment; strip it so the root is just the SAN mount point.
|
|
UPDATE "system_config"
|
|
SET "value" = regexp_replace("value", '/+renders/*$', '')
|
|
WHERE "key" = 'render.outputRoot'
|
|
AND "value" ~ '/+renders/*$';
|