aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources/db/specific/postgresql/V1.27__followers_unique.sql
diff options
context:
space:
mode:
Diffstat (limited to 'src/main/resources/db/specific/postgresql/V1.27__followers_unique.sql')
-rw-r--r--src/main/resources/db/specific/postgresql/V1.27__followers_unique.sql4
1 files changed, 0 insertions, 4 deletions
diff --git a/src/main/resources/db/specific/postgresql/V1.27__followers_unique.sql b/src/main/resources/db/specific/postgresql/V1.27__followers_unique.sql
deleted file mode 100644
index 5a15d9ae..00000000
--- a/src/main/resources/db/specific/postgresql/V1.27__followers_unique.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-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) \ No newline at end of file