Adding hot_rank columns in place of function sorting. (#2952)

[lemmy.git] / migrations / 2023-06-06-104440_index_post_url / up.sql

diff --git a/migrations/2023-06-06-104440_index_post_url/up.sql b/migrations/2023-06-06-104440_index_post_url/up.sql
index 4f8ea66ff79ca3efc8dbbda637dffcfad7386bf8..ce3532887214ca2ff17deb7a938891399026a144 100644 (file)
--- a/migrations/2023-06-06-104440_index_post_url/up.sql
+++ b/migrations/2023-06-06-104440_index_post_url/up.sql
@@ -1 +1,9 @@
+-- Make a hard limit of 512 for the post.url column
+-- Truncate existing long rows.
+update post set url = left(url, 512) where length(url) > 512;
+
+-- Enforce the limit
+alter table post alter column url type varchar (512);
+
+-- Add the index
 create index idx_post_url on post(url);