playlet/sql/song/song_update_20240424.sql

create table mv_favorite
(
    id          bigint auto_increment
        primary key,
    ssid        varchar(64) not null,
    mv_id       varchar(64) not null,
    create_time datetime    not null
);

create index ssid_index
    on mv_favorite (ssid);

create index ssid_mv_id_index
    on mv_favorite (ssid, mv_id);

create table mv_info
(
    id                     varchar(64)   not null
        primary key,
    task_id                varchar(64) null,
    ssid                   varchar(64)   not null,
    title                  varchar(255) null,
    tags                   varchar(1000) null,
    description            varchar(1000) null,
    lyrics                 varchar(10000) null,
    video_url              varchar(255) null,
    origin_video_url       varchar(255) null,
    audio_url              varchar(255) null,
    origin_audio_url       varchar(255) null,
    image_url              varchar(255) null,
    origin_image_url       varchar(255) null,
    image_large_url        varchar(255) null,
    origin_image_large_url varchar(255) null,
    duration               double null,
    play_count             int default 0 not null,
    upvote_count           int default 0 not null,
    status                 int           not null,
    create_time            datetime      not null,
    nickname               varchar(255) null,
    headImageUrl           varchar(255) null
);

create index ssid_index
    on mv_info (ssid);

alter table mv_info
    add orientation varchar(64) null;

alter table mv_info
    add song_id varchar(64) null;