playlet/sql/song/song_update_20240419.sql

create table playlist
(
    id          varchar(64)   not null
        primary key,
    ssid        varchar(64)   not null,
    title       varchar(255) null,
    description varchar(255) null,
    image_url   varchar(255) null,
    create_time datetime      not null,
    update_time datetime      not null,
    status      int default 0 not null
);

create index ssid_index
    on playlist (ssid);

create table playlist_ref_song
(
    id          bigint auto_increment
        primary key,
    playlist_id varchar(64) not null,
    song_id     varchar(64) not null,
    create_time datetime    not null
);

create index playlist_id_index
    on playlist_ref_song (playlist_id);

create index song_id_index
    on playlist_ref_song (song_id);