mobilizon/priv/repo/migrations/20191206144028_create_shares.exs
Thomas Citharel 334d66bf5d
Add admin interface to manage instances subscriptions
Signed-off-by: Thomas Citharel <tcit@tcit.fr>
2019-12-15 21:56:16 +01:00

24 lines
587 B
Elixir

defmodule Mobilizon.Repo.Migrations.CreateShares do
use Ecto.Migration
def up do
create table(:shares) do
add(:uri, :string, null: false)
add(:actor_id, references(:actors, on_delete: :delete_all), null: false)
add(:owner_actor_id, references(:actors, on_delete: :delete_all), null: false)
timestamps()
end
create_if_not_exists(
index(:shares, [:uri, :actor_id], unique: true, name: :shares_uri_actor_id_index)
)
end
def down do
drop_if_exists(index(:shares, [:uri, :actor_id]))
drop_if_exists(table(:shares))
end
end