Claudio Ortolina
b191d87dfd
Remove the primary key, and just set a unique index on scrobbled time and title, which allows skipping duplicates.
19 lines
504 B
Elixir
19 lines
504 B
Elixir
defmodule MusicLibrary.Repo.Migrations.CreateScrobbledTracks do
|
|
use Ecto.Migration
|
|
|
|
def change do
|
|
create table(:scrobbled_tracks, primary_key: false) do
|
|
add :scrobbled_at_uts, :integer
|
|
add :musicbrainz_id, :string
|
|
add :title, :string
|
|
add :cover_url, :string
|
|
add :scrobbled_at_label, :string
|
|
add :artist, :map
|
|
add :album, :map
|
|
add :last_fm_data, :map
|
|
end
|
|
|
|
create index(:scrobbled_tracks, [:scrobbled_at_uts, :title], unique: true)
|
|
end
|
|
end
|