path: root/src/main/resources/db/migration/V1.27__followers_unique.sql

DELETE
FROM followers A USING followers B
WHERE A.user_id=B.user_id AND A.ts<=B.ts AND A.acct=B.acct AND A.ctid<B.ctid;
ALTER TABLE followers ADD UNIQUE (user_id, acct)