summaryrefslogtreecommitdiff
path: root/priv/repo/migrations/20220406185124_create_posts.exs
blob: 223265cde16aadfb4c71fc889c37482e937d53ec (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
defmodule Aggiedit.Repo.Migrations.CreatePosts do
  use Ecto.Migration

  def change do
    create table(:posts) do
      add :title, :text
      add :body, :text
      add :user_id, references(:users, on_delete: :nothing)
      add :upload_id, references(:uploads, on_delete: :nothing)
      add :room_id, references(:rooms, on_delete: :nothing)

      timestamps()
    end

    create index(:posts, [:user_id])
    create index(:posts, [:upload_id])
    create index(:posts, [:room_id])
  end
end