Create index for `show_birthday`

Signed-off-by: marcin mikołajczak <git@mkljczk.pl>

1 files changed, 12 insertions, 0 deletions

diff --git a/priv/repo/migrations/20220116183110_add_birthday_to_users.exs b/priv/repo/migrations/20220116183110_add_birthday_to_users.exs
new file mode 100644
index 000000000..0b22ecc69
--- /dev/null
+++ b/priv/repo/migrations/20220116183110_add_birthday_to_users.exs
@@ -0,0 +1,12 @@
+defmodule Pleroma.Repo.Migrations.AddBirthdayToUsers do
+  use Ecto.Migration
+
+  def change do
+    alter table(:users) do
+      add_if_not_exists(:birthday, :date)
+      add_if_not_exists(:show_birthday, :boolean, default: false, null: false)
+    end
+
+    create_if_not_exists(index(:users, [:show_birthday]))
+  end
+end