From 61bae9a407ae9480e46e3a33d0b7d1f4c940b02c Mon Sep 17 00:00:00 2001 From: marcin mikołajczak Date: Sun, 23 Jan 2022 09:54:24 +0100 Subject: Create index for `show_birthday` MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Signed-off-by: marcin mikołajczak --- .../repo/migrations/20220116183110_add_birthday_to_users.exs | 12 ++++++++++++ .../migrations/29220116183110_add_birth_date_to_users.exs | 10 ---------- 2 files changed, 12 insertions(+), 10 deletions(-) create mode 100644 priv/repo/migrations/20220116183110_add_birthday_to_users.exs delete mode 100644 priv/repo/migrations/29220116183110_add_birth_date_to_users.exs 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 diff --git a/priv/repo/migrations/29220116183110_add_birth_date_to_users.exs b/priv/repo/migrations/29220116183110_add_birth_date_to_users.exs deleted file mode 100644 index 57fedaee2..000000000 --- a/priv/repo/migrations/29220116183110_add_birth_date_to_users.exs +++ /dev/null @@ -1,10 +0,0 @@ -defmodule Pleroma.Repo.Migrations.AddBirthDateToUsers 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 - end -end -- cgit v1.2.3