src/main/resources/db/migration/V1.10__favorites_user_uri.sql


1
2
3

ALTER TABLE favorites ADD COLUMN user_uri char(255) DEFAULT NULL;
UPDATE favorites SET user_uri='' WHERE user_uri IS NULL;
ALTER TABLE favorites MODIFY COLUMN user_uri char(255) NOT NULL DEFAULT '';