c566912f5ef3390bb74d902ccbf8f1fdf4ccd32b
[akkoma] / priv / repo / migrations / 20190315101315_create_registrations.exs
1 defmodule Pleroma.Repo.Migrations.CreateRegistrations do
2 use Ecto.Migration
3
4 def change do
5 create table(:registrations) do
6 add :user_id, references(:users, type: :uuid, on_delete: :delete_all)
7 add :provider, :string
8 add :uid, :string
9 add :info, :map, default: %{}
10
11 timestamps()
12 end
13
14 create unique_index(:registrations, [:provider, :uid])
15 create unique_index(:registrations, [:user_id, :provider])
16 end
17 end