railway-prod2/sql/getui.sql

-- sys_config 插入个推参数
INSERT INTO `sys_config` VALUES (6, '个推-appId', 'getui.appId', 'Y3xRJmer116Bb1HhqnZav7', 'N', 'admin', '2021-12-09 08:47:52', '', NULL, NULL);
INSERT INTO `sys_config` VALUES (7, '个推-appKey', 'getui.appKey', 'N2oftDIHyC9o1Ue73Cx3fA', 'N', 'admin', '2021-12-09 08:48:34', '', NULL, NULL);
INSERT INTO `sys_config` VALUES (8, '个推-appSecret', 'getui.appSecret', 'AxCTRofHoO6XY47mpP2Vs8', 'N', 'admin', '2021-12-09 08:49:10', '', NULL, NULL);
INSERT INTO `sys_config` VALUES (9, '个推-masterSecret', 'getui.masterSecret', 'OZhDEZbGTZ9tc8P8IQ3Mk3', 'N', 'admin', '2021-12-09 08:49:41', '', NULL, NULL);

-- 创建系统计划任务表，并插入个推task
DROP TABLE IF EXISTS `sys_scheduled_task`;
CREATE TABLE `sys_scheduled_task` (
    `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
    `name` varchar(50) NOT NULL COMMENT '任务名称',
    `cron` varchar(30) NOT NULL COMMENT '任务cron',
    `open` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1开启，0关闭',
    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='系统计划任务表';

INSERT INTO `sys_scheduled_task` VALUES (1, 'getui', '0/10 * * * * ? ', 1);

-- 创建个推消息表
DROP TABLE IF EXISTS `bus_push_msg`;
CREATE TABLE `bus_push_msg` (
    `id` int NOT NULL AUTO_INCREMENT,
    `user_id` bigint NOT NULL COMMENT '用户id',
    `client_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客户端id，APP端提供',
    `client_type` tinyint NOT NULL DEFAULT '0' COMMENT '客户端类型：0-android;1-ios',
    `title` varchar(255) DEFAULT NULL COMMENT '消息标题',
    `content` varchar(1000) NOT NULL DEFAULT '' COMMENT '消息内容',
    `ios_alert_msg` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT 'IOS专用',
    `create_time` datetime NOT NULL COMMENT '创建时间',
    `push_time` datetime DEFAULT NULL COMMENT '推送时间',
    `push_status` char(1) NOT NULL DEFAULT '0' COMMENT '推送状态：0-未推送；1-推送成功；2-推送失败；3-服务器响应异常；',
    `push_result_desc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' COMMENT '推送结果说明',
    `push_loop` tinyint NOT NULL DEFAULT '0' COMMENT '推送轮数',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='个推消息表';