summaryrefslogtreecommitdiff
path: root/priv/repo/migrations/20240530011739_add_missing_foreign_keys.exs
blob: 158f9701b3333d7c67fa4050aa4dcee46068d465 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
defmodule Pleroma.Repo.Migrations.AddMissingForeignKeys do
  use Ecto.Migration

  def change do
    create_if_not_exists(index(:announcement_read_relationships, :announcement_id))
    create_if_not_exists(index(:bookmarks, :activity_id))
    create_if_not_exists(index(:bookmarks, :folder_id))
    create_if_not_exists(index(:chats, :recipient))
    create_if_not_exists(index(:mfa_tokens, :authorization_id))
    create_if_not_exists(index(:mfa_tokens, :user_id))
    create_if_not_exists(index(:notifications, :activity_id))
    create_if_not_exists(index(:oauth_authorizations, :app_id))
    create_if_not_exists(index(:oauth_authorizations, :user_id))
    create_if_not_exists(index(:password_reset_tokens, :user_id))
    create_if_not_exists(index(:push_subscriptions, :token_id))
    create_if_not_exists(index(:report_notes, :activity_id))
    create_if_not_exists(index(:report_notes, :user_id))
    create_if_not_exists(index(:user_notes, :target_id))
  end
end