pleroma

commit: 249fe88d12345c1c93f1812871cd70424b9e9a0d
parent 61bae9a407ae9480e46e3a33d0b7d1f4c940b02c
Author: marcin mikołajczak <git@mkljczk.pl>
Date:   Tue, 25 Jan 2022 10:45:32 +0100

Birthdays: users_birthday_month_day_index

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

Diffstat:
A
priv/repo/migrations/20220125104429_add_birthday_month_day_index_to_users.exs
11
+++++++++++

1 file changed, 11 insertions(+), 0 deletions(-)
diff --git a/priv/repo/migrations/20220125104429_add_birthday_month_day_index_to_users.exs b/priv/repo/migrations/20220125104429_add_birthday_month_day_index_to_users.exs
@@ -0,0 +1,11 @@
+defmodule Pleroma.Repo.Migrations.AddBirthdayMonthDayIndexToUsers do
+  use Ecto.Migration
+
+  def change do
+    create(
+      index(:users, ["date_part('month', birthday)", "date_part('day', birthday)"],
+        name: :users_birthday_month_day_index
+      )
+    )
+  end
+end