18 lines
533 B
1
defmodule Blog.Repo.Migrations.CreateSparkles do
2
use Ecto.Migration
3
4
def change do
5
create table(:sparkles) do
6
add :content, :text, null: false
7
add :author, :string, null: false
8
add :sparkle_id, references(:sparkles, on_delete: :delete_all), null: true
9
add :root_sparkle_id, references(:sparkles, on_delete: :delete_all), null: true
10
11
timestamps()
12
end
13
14
create index(:sparkles, [:sparkle_id])
15
create index(:sparkles, [:root_sparkle_id])
16
create index(:sparkles, [:author])
17
end
18
end
19