提测文档

CREATE TABLE `ddyp_public_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `user_name` varchar(50) DEFAULT NULL COMMENT '微信用户名',
  `openid` varchar(100) DEFAULT NULL COMMENT '公众号openid',
  `unionid` varchar(100) DEFAULT NULL COMMENT 'unionid',
  `is_subscribe` tinyint(1) DEFAULT NULL COMMENT '是否关注公众号：0取消关注 1关注',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='公众号点点易聘的用户信息';

-- 添加非空
ALTER TABLE ddyp_public_user MODIFY COLUMN openid varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公众号openid';
-- 添加唯一约束
ALTER TABLE ddyp_public_user ADD UNIQUE (openid);