X-Git-Url: http://git.squeep.com/?a=blobdiff_plain;f=priv%2Frepo%2Fmigrations%2F20190115085500_create_user_fts_index.exs;h=0c0c512d33a28f62041b5f78844d5ac7e808360d;hb=58f9ce0debb080fe74753a2d068499f0eeab09fc;hp=499d6711388ebff94159d96006ab04a34e5a0dd9;hpb=627e5a0a4992cc19fc65a7e93a09c470c8e2bf33;p=akkoma

diff --git a/priv/repo/migrations/20190115085500_create_user_fts_index.exs b/priv/repo/migrations/20190115085500_create_user_fts_index.exs
index 499d67113..0c0c512d3 100644
--- a/priv/repo/migrations/20190115085500_create_user_fts_index.exs
+++ b/priv/repo/migrations/20190115085500_create_user_fts_index.exs
@@ -2,16 +2,18 @@ defmodule Pleroma.Repo.Migrations.CreateUserFtsIndex do
   use Ecto.Migration
 
   def change do
-    create index(
-             :users,
-             [
-               """
-               (setweight(to_tsvector('simple', regexp_replace(nickname, '\\W', ' ', 'g')), 'A') ||
-               setweight(to_tsvector('simple', regexp_replace(coalesce(name, ''), '\\W', ' ', 'g')), 'B'))
-               """
-             ],
-             name: :users_fts_index,
-             using: :gin
-           )
+    create_if_not_exists(
+      index(
+        :users,
+        [
+          """
+          (setweight(to_tsvector('simple', regexp_replace(nickname, '\\W', ' ', 'g')), 'A') ||
+          setweight(to_tsvector('simple', regexp_replace(coalesce(name, ''), '\\W', ' ', 'g')), 'B'))
+          """
+        ],
+        name: :users_fts_index,
+        using: :gin
+      )
+    )
   end
 end