agent_server/storage/sql/inc/agent_inc_20220402_1.sql

CREATE TABLE `ag_app_pack` (
                               `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
                               `uid` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'uid',
                               `agent_uid` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '代理UID',
                               `channel_code` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '渠UID',
                               `mom_app_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'app名称',
                               `mom_app_uid` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '母包UID',
                               `mom_app_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '母包app包名',
                               `android_or_ios` int NOT NULL COMMENT 'android_or_ios',
                               `app_download` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '母包下载地址',
                               `mom_app_version` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '母包app版本',
                               `created_at` datetime DEFAULT NULL,
                               `updated_at` datetime DEFAULT NULL,
                               `status` int NOT NULL DEFAULT '1' COMMENT '1成功，2失败，3打包中',
                               PRIMARY KEY (`id`),
                               UNIQUE KEY `x_uid` (`uid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE `ag_app` ADD
    `app_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'app_id';