支付宝开发

CREATE TABLE `user_alipay_info` (
	`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
	`user_id` int(11) NOT NULL  COMMENT '用户ID',
	`alipay_user_id` varchar(32) DEFAULT NULL COMMENT '支付宝唯一user_id',
	`alipay_nick_name` varchar(128) DEFAULT NULL COMMENT '支付宝用户昵称',
	`alipay_photo` varchar(255) DEFAULT NULL COMMENT '支付宝用户头像',
    `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`),
    UNIQUE KEY `uk_user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户支付宝授权关联信息表';

alter table user_project_wxacode add column `platform_type` tinyint(2) NOT NULL DEFAULT '0' COMMENT '平台类型：0微信，1支付宝';
alter table user_project_wxacode drop primary key;
alter table user_project_wxacode add primary key(`user_id`, `project_id`, `platform_type`);

-- 岗位短链
alter table short_url_info add column `platform_type` tinyint(2) NOT NULL DEFAULT '0' COMMENT '平台类型：0微信，1支付宝';
-- 修改唯一索引
ALTER TABLE short_url_info DROP INDEX `user_id`;
ALTER TABLE short_url_info ADD UNIQUE `uk_user_job_platform_type`(`user_id`, `job_id`, `platform_type`);

alter table batch_share_jobs_record add column `platform_type` tinyint(2) NOT NULL DEFAULT '0' COMMENT '平台类型：0微信，1支付宝';
alter table share_record add column `platform_type` tinyint(2) NOT NULL DEFAULT '0' COMMENT '平台类型：0微信，1支付宝';

ALTER TABLE resume ADD UNIQUE `uk_user_id`(`user_id`) USING BTREE;
ALTER TABLE user_pay_account ADD UNIQUE `uk_user_account_type`(`user_id`, `account_type`, `account_num`) USING BTREE;

# 支付宝配置  https://open.alipay.com/
ali:
  # 支付宝网关
  gatewayUrl: https://openapi.alipay.com/gateway.do
  # 支付宝分配给开发者的应用ID
  appId: 2021003182686162
    # 签名方式
  signType: RSA2
  # 字符编码格式
  charset: UTF-8
  # 字符编码格式
  format: json
  # 接口内容加密密钥
  decryptKey: l47/BFRLVaQCuk3/Q1IRSA==
  # 商户私钥，您的 PKCS8 格式 RSA2 私钥 (使用 支付宝开放平台开发助手 生成的应用私钥)
  merchantPrivateKey: MIIEvwIBADANBgkqhkiG9w0BAQEFAASCBKkwggSlAgEAAoIBAQCVOaDgG8g4IkdHJS2yq5v6NczMli61GJNqPIyu/nF/r3uM1OrJ9pmjJUd4OXxlxXIDbczaG/guhNYGdSh3KzLymm+VMRlkrcyS8Hh08yTzYobJNzR/2LchDY6dacDbdiJCNzZpqLIYcIjbgUXazQHDc14QxJKHWay3ANEcwYIt1cDznF5FUcLmwRYsPyY03Z2PCbEMiD57TTWVQNJXJ51EJeybDog5oJO4SoyWTowviVEAtVwk8AVdZoq1nKxvZT6hGte0RSJHTeBfTs8fcZMR51BaRRa6vg1LrhjLtgPxWecOjejGtsmCDxhTrkMMYnY0uJLUlVpb1LKLFw/IREAXAgMBAAECggEAana8DUgk98+U9PBUgyWmWcQqgkgfuLp46hGa+Xq1NTjYt+hsPn0+rcP6Eo9I7j8JEeMzhOTxkxbYr7DElwjuB2Ihe9qU2FybGLaR6jZSxYYkzcgiH5hZRy6p8iqyGqFU3dMQch+WOJOJQLohQXKD8JMNqH7mX8Sd0c62YoK4wsOnLhIlSV3ESu3QilVGt99fKjeDzqrrZYqFjw+/i0nLTKW0FsFwH/JkOgFTJP0RZ2zh1ovxJpcOoskdo3kmcd+A7y7DABcf+yQ03Ulm8yReiUBMX//NMQhFRKlgGoCePMvl0nikDj1+YUwdMCe0wcFDkQdp3Qb2b4kfDucJQ62w6QKBgQDVsAsP0TBFnnLZXg9NGEtBpXvn/+BEWAERhwuwE6zfmbTtxF/u6KhvxZh9oqbFoE2RPnrHZEsrWtIj3v2DKi1DSsFPkG72YS5ZfJ4csMofoN9F/NptBX+L2ZYQt/i7kAkHNA9DOYQ7Nl4rpKnVNatOLyIwVWVVobM1cdk+1+SxdQKBgQCyxfB04AzwCuQBumU2uW2Fsfd84O2LJ54kH5x7+ohasfbUpRR/NtxyQw0BNob7piUrEZHnxM8zTJPGdUJGvMHV1wcPIqA8WD7VZV5rz6vhz51s9CVH/TCsggGqv7sRFa0rqPE/udrhIT1lndZDa6TbUyXmKlzQNmbmIKuyAveN2wKBgQCoOOusawludTuC5ap0DeEI8AbocCaUhxdoPgE0f3jDmpS17bd8NAqN22ed2FMkF3uZES/FEq6eleQCu0SmYqi5Zfti8Jh6O60qY5Fxkre8SIAc797gnsh3Rzb9OGeG+PAyjIhLatcvajCeeQX+RD700ORAWqnozOBw/YyCDaILFQKBgQCDOuHkKYPVwWjWC+m4Xi2TcqxlswcsmwxvH/VS3Pmy+ehi+DsvlyoDhkzJkylLGQ83qlIcfFBNK+1eRT09h9oSCyJXbeeJ5I1bQGorYeqefDTngeDME4PjXhuzJ8M+K1dPMVjGmrudfzT+nvply2LczRCJAJfZD9ZBH8JpjdwC+QKBgQCCDQseczqKKXeLFLz86Mihgo5r41KROJFZDQGjYXK97VQoopcch/zGDwRYzpNEymEWFJZQUPe05N6zE3cZ8Dy6gKKyNlEwXGj0i+P+2EU0XtDZ5xfFNrnekFBXR3239Ty+QnQhKE0KVLsMUC+5drMG+Lu0jyKaBpXoH5VtPnc7NQ==
  # 支付宝公钥 (支付宝加签后得到的公钥)
  alipayPublicKey: MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAsEAuoo45642CKgBuOs3VnBHInLlb34OrPXL/m+wobcMaSAb2Wd4Hsq5VYENqGrzB+MTuT5RUx4/ndm8DbFuH1EW6Jjciiab+2YsQZmabe1mE3LtkAnVLMdu8cWg7xN4DxclDmHQpIoJVxOj3K16I+RQ96L9B5z+TlWah+W9xpjDxmlYA5ZmTG6h7G3zptBup9Sx/Z6R6ztW9AzrkcIiDzn3nCwaYnunMbhC4fuZjuWzDbRgv+0BXjmU2S9Q0i+3bGKr3/skNuN1+lxAOMG0uOme5kZRsCF6lrqYbJnEOAkHUeFeFsuKtHdrhINE9N5ivjH3+BntNwo/THUUfLY9GQwIDAQAB

logging:
  level:
    com.alibaba.nacos.client.naming: WARN 
    com.alibaba.nacos.client.config.impl: WARN

进入服务器--小程序服务--打开bootstrap.yml--找到common-application.yaml
同级别新增：
          - data-id: ali.yaml
            refresh: true
          - data-id: nacosConfig.yaml
            refresh: true