aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources/db/migration/V1.10__favorites_user_uri.sql
blob: 8f382398e84f0d896dd03b81653bc7d8ba5773f9 (plain) (blame)
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 '';