api/migrations/2023-12-30-214938_playlists_tracks/up.sql

8 lines
282 B
MySQL
Raw Permalink Normal View History

2024-01-01 02:18:33 +00:00
create table if not exists playlists_tracks
(
playlist_id varchar(24) references playlists (id) on delete cascade,
track_id varchar(24) references tracks (id) on delete cascade,
2024-01-07 14:43:56 +00:00
added_at timestamp default now() not null,
2024-01-01 02:18:33 +00:00
primary key (playlist_id, track_id)
2023-12-31 00:21:07 +00:00
);