First
[anni] / priv / repo / migrations / 20220125104429_add_birthday_month_day_index_to_users.exs
1 # Pleroma: A lightweight social networking server
2 # Copyright © 2017-2022 Pleroma Authors <https://pleroma.social/>
3 # SPDX-License-Identifier: AGPL-3.0-only
4
5 defmodule Pleroma.Repo.Migrations.AddBirthdayMonthDayIndexToUsers do
6   use Ecto.Migration
7
8   def change do
9     create(
10       index(:users, ["date_part('month', birthday)", "date_part('day', birthday)"],
11         name: :users_birthday_month_day_index
12       )
13     )
14   end
15 end