path: root/src/main/resources/db/specific/postgresql/V1.10__favorites_user_uri.sql

ALTER TABLE favorites ADD COLUMN user_uri character varying (255) DEFAULT NULL;
UPDATE favorites SET user_uri='' WHERE user_uri IS NULL;
ALTER TABLE favorites ALTER COLUMN user_uri SET DEFAULT '';