eZ Platform / Publish update var dir paths

update_paths.sql

-- Update image paths 
UPDATE ezimagefile SET filepath = REPLACE(filepath, 'var/storage', 'var/my/storage');

-- Before this you may run legacy script to cleanup dfs data to wipe out caches from the table: php bin/php/dfscleanup.php

-- Update DFS tables (only relevant if you use Clustering)
UPDATE IGNORE ezdfsfile 
SET name = REPLACE(name, 'var/storage', 'var/ca/storage'), 
    name_trunk = REPLACE(name_trunk, 'var/storage', 'var/my/storage'), 
    name_hash = MD5(REPLACE(name, 'var/storage', 'var/my/storage'))
WHERE name like '%var/storage%';

-- Remember to clear all (platform & legacy) cache afterwards
-- Credits @bdunogier