playlet/sql/central/central_update_20240521.sql

create table pay_item_group
(
    id               bigint auto_increment
        primary key,
    priority         int          default 0         not null,
    group_code       varchar(255) default 'default' not null,
    group_name       varchar(255) null,
    package_name     varchar(255)                   not null comment '包名',
    app_platform     int                            not null comment '应用平台',
    channel_name     varchar(255) default '*'       not null comment '渠道',
    app_version_name varchar(255) default '*'       not null comment '版本',
    city             varchar(255) default '*'       not null comment '城市或地区',
    create_time      datetime                       not null,
    update_time      datetime                       not null,
    remark           varchar(255) null,
    status           int          default 0         not null comment '0:启用 1:禁用'
);

create index package_name_index
    on pay_item_group (package_name);

create table pay_item_ref_group
(
    id       bigint auto_increment
        primary key,
    group_id bigint        not null,
    item_id  bigint        not null,
    sort     int default 0 not null
);

create index group_id_index
    on pay_item_ref_group (group_id);