CREATE TABLE `app_user` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `app_id` varchar(32) NOT NULL COMMENT '小程序appid',
    `open_id` varchar(32) NOT NULL COMMENT '小程序openid',
    `name` varchar(32) NOT NULL COMMENT '用户名称',
    `pic` varchar(256) NOT NULL COMMENT '用户头像',
    `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON
    UPDATE
        CURRENT_TIMESTAMP,
        PRIMARY KEY (`id`),
        UNIQUE KEY `app_open_id` (`app_id`, `open_id`)
) ENGINE = InnoDB AUTO_INCREMENT = 4 DEFAULT CHARSET = utf8mb4 COMMENT = '小程序用户表'