提测文档

lingtu: 
  ## 开发环境
  ## notifyUrl: https://ddyp.lurb.online/dev/e
  ## 测试环境
  notifyUrl: https://ddyp.lurb.online/test/e
  ## 生产环境
  ## notifyUrl: https://lkl.lurb.online/gw/e

## leqin  lingtu
server:
  api: 
    type: lingtu

--用户签约结果表
CREATE TABLE `user_certified_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_id` int(11) NOT NULL COMMENT '用户ID',
  `card_id` varchar(50) DEFAULT NULL COMMENT '身份证号',
  `card_name` varchar(50) DEFAULT NULL COMMENT '身份证姓名',
  `card_front` varchar(255) DEFAULT NULL COMMENT '身份证正面图片',
  `card_back` varchar(255) DEFAULT NULL COMMENT '身份证反面图片',
  `card_certified` tinyint(4) DEFAULT '0' COMMENT '身份证认证状态（默认0-未认证，1-待认证，2-已认证，3-认证失败，4-上传影像失败，5-上传身份证影像成功，6-签署成功以及上传身份证影像成功）',
  `card_certified_info` varchar(4000) DEFAULT NULL COMMENT '身份证认证订单信息',
  `card_certified_fail_reason` varchar(255) DEFAULT NULL COMMENT '身份证认证失败原因',
  `extra_info` varchar(1024) DEFAULT NULL COMMENT '补充信息',
  `type` tinyint(2) DEFAULT NULL COMMENT '平台类型：1：乐勤；2：灵兔',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户签约表';

-- 把User表中身份证号和身份证姓名不为空并且状态为2或6的数据导入到user_certified_info表中并且把type字段赋值为1
INSERT INTO user_certified_info (user_id, card_id, card_name, card_front, card_back, card_certified, card_certified_info, card_certified_fail_reason, type, create_time, update_time)
SELECT id, card_id, card_name, card_front, card_back, card_certified, card_certified_info, card_certified_fail_reason, 1, create_time, update_time
FROM user
WHERE (card_id IS NOT NULL AND card_name IS NOT NULL)
AND (card_certified = 2 OR card_certified = 6);

-- 删除user表字段：
ALTER TABLE `user` DROP COLUMN card_id;
ALTER TABLE `user` DROP COLUMN card_name;
ALTER TABLE `user` DROP COLUMN card_front;
ALTER TABLE `user` DROP COLUMN card_back;
ALTER TABLE `user` DROP COLUMN card_certified;
ALTER TABLE `user` DROP COLUMN card_certified_info;
ALTER TABLE `user` DROP COLUMN card_certified_fail_reason;