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 '';