create table(:todo_list_items) do
add :todo_item_id, references(:todo_items)
add :todo_list_id, references(:todo_lists)
timestamps()
end
def change do
create table(:user_project, primary_key: false) do
add(:project_id, references(:project, on_delete: :delete_all), primary_key: true)
add(:user_id, references(:user, on_delete: :delete_all), primary_key: true)
timestamps()
end
create(index(:user_project, [:project_id]))
create(index(:user_project, [:user_id]))
create(
unique_index(:user_project, [:user_id, :project_id], name: :user_id_project_id_unique_index)
)
Loading...