playlet/sql/central/central_update_20241211.sql

create table auth_netease_config
(
    id           int auto_increment
        primary key,
    package_name varchar(255)  not null,
    app_platform int           not null,
    secret_id    varchar(255)  not null comment '产品秘钥 id',
    business_id  varchar(255)  not null comment '业务id',
    secret_key   varchar(255)  not null comment '产品私钥',
    version      varchar(255)  not null comment '接口版本号',
    status       int default 0 not null
) collate = utf8mb4_unicode_ci;

create index package_platform_index
    on auth_netease_config (package_name, app_platform);


INSERT INTO central.auth_netease_config (id, package_name, app_platform, secret_id, business_id, secret_key, version,
                                         status)
VALUES (1, 'com.xingchat.muse', 1, '5299ec9603d78d53e10fdddb127c9ca3', 'c6b5dc09a5e445d28366ba23657274fc',
        '3a11e7637cc993bbe868b3e52728ed72', 'v1', 0);
INSERT INTO central.auth_netease_config (id, package_name, app_platform, secret_id, business_id, secret_key, version,
                                         status)
VALUES (2, 'com.writigmeow.xzm', 1, '5299ec9603d78d53e10fdddb127c9ca3', 'b9ee77bc67a147688966c8f67ed4748b',
        '3a11e7637cc993bbe868b3e52728ed72', 'v1', 0);