X-Git-Url: https://git.squeep.com/?a=blobdiff_plain;f=priv%2Frepo%2Fmigrations%2F20180813003722_create_filters.exs;h=7803558dff4f9b2a0ecba8dbfa2f58fce0b05399;hb=73609211a425922a5068d3912a36b82abe24e12c;hp=8e7129f342c3c9cd24fbce573e0c7226306c30f3;hpb=aac48d0cc6893c231c88d5cd7fe0334353bbf299;p=akkoma

diff --git a/priv/repo/migrations/20180813003722_create_filters.exs b/priv/repo/migrations/20180813003722_create_filters.exs
index 8e7129f34..7803558df 100644
--- a/priv/repo/migrations/20180813003722_create_filters.exs
+++ b/priv/repo/migrations/20180813003722_create_filters.exs
@@ -2,19 +2,22 @@ defmodule Pleroma.Repo.Migrations.CreateFilters do
   use Ecto.Migration
 
   def change do
-    create table(:filters) do
-      add :user_id, references(:users, on_delete: :delete_all)
-      add :filter_id, :integer
-      add :hide, :boolean
-      add :phrase, :string
-      add :context, {:array, :string}
-      add :expires_at, :utc_datetime
-      add :whole_word, :boolean
+    create_if_not_exists table(:filters) do
+      add(:user_id, references(:users, on_delete: :delete_all))
+      add(:filter_id, :integer)
+      add(:hide, :boolean)
+      add(:phrase, :string)
+      add(:context, {:array, :string})
+      add(:expires_at, :utc_datetime)
+      add(:whole_word, :boolean)
 
       timestamps()
     end
 
-    create index(:filters, [:user_id])
-    create index(:filters, [:phrase], where: "hide = true", name: :hided_phrases_index)
+    create_if_not_exists(index(:filters, [:user_id]))
+
+    create_if_not_exists(
+      index(:filters, [:phrase], where: "hide = true", name: :hided_phrases_index)
+    )
   end
 end