1 files changed, 0 insertions, 21 deletions
diff --git a/migrations/2018-04-14-153202_add_stickies_improve_index/up.sql b/migrations/2018-04-14-153202_add_stickies_improve_index/up.sql
deleted file mode 100644
index 74a559e35d..0000000000
--- a/migrations/2018-04-14-153202_add_stickies_improve_index/up.sql
+++ /dev/null
@@ -1,21 +0,0 @@
--- Add support for stickies in threads
-ALTER TABLE threads ADD COLUMN sticky BOOLEAN NOT NULL DEFAULT FALSE;
-
--- CREATE a simple view that returns the list of threads ordered by
--- the last post that occured in the thread.
-CREATE VIEW thread_index AS
-  SELECT t.id AS thread_id,
-         t.title AS title,
-         t.author_name AS thread_author,
-         t.posted AS created,
-         t.sticky AS sticky,
-         p.id AS post_id,
-         p.author_name AS post_author,
-         p.posted AS posted
-    FROM threads t
-    JOIN (SELECT DISTINCT ON (thread_id)
-           id, thread_id, author_name, posted
-          FROM posts
-          ORDER BY thread_id, id DESC) AS p
-    ON t.id = p.thread_id
-    ORDER BY t.sticky DESC, p.id DESC;