X-Git-Url: https://git.squeep.com/?a=blobdiff_plain;f=priv%2Frepo%2Fmigrations%2F20180813003722_create_filters.exs;h=7803558dff4f9b2a0ecba8dbfa2f58fce0b05399;hb=0c2c057c75e21ec411599016b705801f98565cf8;hp=a273004ee8e7a0420b7a88c2f1974ea9430971ae;hpb=b0ec4f33e661cb14730a622d64dbc721e2723825;p=akkoma

diff --git a/priv/repo/migrations/20180813003722_create_filters.exs b/priv/repo/migrations/20180813003722_create_filters.exs
index a273004ee..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, :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