Merge branch 'develop' of https://git.pleroma.social/pleroma/pleroma into develop

[akkoma] / priv / repo / migrations / 20190115085500_create_user_fts_index.exs

diff --git a/priv/repo/migrations/20190115085500_create_user_fts_index.exs b/priv/repo/migrations/20190115085500_create_user_fts_index.exs
index 499d6711388ebff94159d96006ab04a34e5a0dd9..0c0c512d33a28f62041b5f78844d5ac7e808360d 100644 (file)
--- 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