/* Navicat Premium Data Transfer Source Server : ivo1 Source Server Type : MySQL Source Server Version : 50718 Source Host : sh-cynosdbmysql-grp-e911sges.sql.tencentcdb.com:29062 Source Schema : tduck Target Server Type : MySQL Target Server Version : 50718 File Encoding : 65001 Date: 24/06/2021 11:05:57 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for ac_user -- ---------------------------- DROP TABLE IF EXISTS `ac_user`; CREATE TABLE `ac_user` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '姓名', `avatar` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '头像', `gender` tinyint(1) NOT NULL DEFAULT 0 COMMENT '性别0未知 1男2女', `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱', `phone_number` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码', `reg_channel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NULL DEFAULT NULL COMMENT '注册渠道', `last_login_channel` tinyint(4) NULL DEFAULT NULL COMMENT '最后登录渠道', `last_login_time` datetime(0) NULL DEFAULT NULL COMMENT '最后登录时间', `last_login_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '最后登录Ip', `deleted` tinyint(1) NULL DEFAULT 0 COMMENT '状态', `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP (0), `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP (0), PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 220 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for ac_user_authorize -- ---------------------------- DROP TABLE IF EXISTS `ac_user_authorize`; CREATE TABLE `ac_user_authorize` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `type` tinyint(1) NOT NULL COMMENT '第三方平台类型', `app_id` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '平台AppId', `open_id` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '平台OpenId', `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '平台用户名', `user_id` bigint(11) NULL DEFAULT NULL COMMENT '用户Id', `user_info` json NULL COMMENT '平台用户信息', `create_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP (0), `update_time` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP (0), PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '第三方用户授权信息' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for pr_project_template -- ---------------------------- DROP TABLE IF EXISTS `pr_project_template`; CREATE TABLE `pr_project_template` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `key` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '模板唯一标识', `cover_img` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '封面图', `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '项目名称', `describe` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '项目描述', `like_count` int(10) NULL DEFAULT 0 COMMENT '喜欢数', `category_id` int(2) NOT NULL COMMENT '项目类型', `status` tinyint(2) NOT NULL DEFAULT 0 COMMENT '状态', `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '更新时间', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `code`(`key`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 59 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for pr_project_template_category -- ---------------------------- DROP TABLE IF EXISTS `pr_project_template_category`; CREATE TABLE `pr_project_template_category` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主题名称', `sort` int(11) NULL DEFAULT NULL COMMENT '排序', `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '更新时间', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目模板分类' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for pr_project_template_item -- ---------------------------- DROP TABLE IF EXISTS `pr_project_template_item`; CREATE TABLE `pr_project_template_item` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `project_key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '项目key', `form_item_id` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表单项Id', `type` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '表单项类型 ', `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '表单项标题', `show_label` tinyint(1) NOT NULL COMMENT '是否显示标签', `default_value` json NULL COMMENT '表单项默认值', `required` tinyint(1) NOT NULL COMMENT '是否必填', `placeholder` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '输入型提示文字', `sort` bigint(20) NULL DEFAULT 0 COMMENT '排序', `span` int(10) NOT NULL DEFAULT 24 COMMENT '栅格宽度', `expand` json NULL COMMENT '扩展字段 表单项独有字段', `reg_list` json NULL COMMENT '正则表达式 ', `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '更新时间', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '创建时间', `is_display_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '展示类型组件', PRIMARY KEY (`id`) USING BTREE, INDEX `project_key`(`project_key`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1030 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目表单项' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for pr_project_theme -- ---------------------------- DROP TABLE IF EXISTS `pr_project_theme`; CREATE TABLE `pr_project_theme` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主题名称', `style` json NOT NULL COMMENT '主题风格\r\n', `head_img_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '头部图片', `color` json NOT NULL COMMENT '颜色代码', `btns_color` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '按钮颜色', `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '更新时间', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 216 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目主题外观模板' ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for pr_user_project -- ---------------------------- DROP TABLE IF EXISTS `pr_user_project`; CREATE TABLE `pr_user_project` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `key` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '项目code', `source_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '来源Id', `source_type` tinyint(5) NULL DEFAULT NULL COMMENT '来源类型', `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '项目名称', `describe` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '项目描述', `user_id` bigint(20) NOT NULL COMMENT '用户ID', `type` tinyint(2) NULL DEFAULT NULL COMMENT '项目类型', `status` tinyint(2) NOT NULL DEFAULT 0 COMMENT '状态', `is_deleted` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否删除', `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '更新时间', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `code`(`key`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2429 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for pr_user_project_item -- ---------------------------- DROP TABLE IF EXISTS `pr_user_project_item`; CREATE TABLE `pr_user_project_item` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `project_key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '项目key', `form_item_id` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '表单项Id', `type` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '表单项类型 ', `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '表单项标题', `is_display_type` tinyint(1) NOT NULL DEFAULT 0 COMMENT '展示类型组件', `show_label` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否显示标签', `default_value` json NULL COMMENT '表单项默认值', `required` tinyint(1) NOT NULL COMMENT '是否必填', `placeholder` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '输入型提示文字', `sort` bigint(20) NULL DEFAULT 0 COMMENT '排序', `span` int(10) NOT NULL DEFAULT 24 COMMENT '栅格宽度', `expand` json NULL COMMENT '扩展字段 表单项独有字段', `reg_list` json NULL COMMENT '正则表达式 ', `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '更新时间', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE, INDEX `project_key`(`project_key`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 19989 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目表单项' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for pr_user_project_logic -- ---------------------------- DROP TABLE IF EXISTS `pr_user_project_logic`; CREATE TABLE `pr_user_project_logic` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '逻辑Id', `project_key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '项目key', `form_item_id` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '问题Id', `expression` tinyint(1) NOT NULL COMMENT '条件选项 ', `condition_list` json NOT NULL COMMENT '条件列表', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '创建时间', `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, INDEX `project_key`(`project_key`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 104 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目逻辑' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for pr_user_project_result -- ---------------------------- DROP TABLE IF EXISTS `pr_user_project_result`; CREATE TABLE `pr_user_project_result` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `project_key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '项目key', `serial_number` int(11) NULL DEFAULT NULL COMMENT '序号', `original_data` json NULL COMMENT '填写结果', `process_data` json NULL COMMENT '填写结果', `submit_ua` json NULL COMMENT '提交ua', `submit_os` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提交系统', `submit_browser` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提交浏览器', `submit_request_ip` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '请求ip', `submit_address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提交地址', `complete_time` int(11) NULL DEFAULT NULL COMMENT '完成时间 毫秒', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '创建时间', `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '更新时间', PRIMARY KEY (`id`) USING BTREE, INDEX `project_key`(`project_key`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1851 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目表单项' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for pr_user_project_setting -- ---------------------------- DROP TABLE IF EXISTS `pr_user_project_setting`; CREATE TABLE `pr_user_project_setting` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `project_key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '项目key', `submit_prompt_img` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提交提示图片', `submit_prompt_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提交提示文字', `submit_jump_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提交跳转连接', `is_public_result` tinyint(1) NULL DEFAULT NULL COMMENT '公开提交结果', `is_wx_write` tinyint(1) NULL DEFAULT NULL COMMENT '只在微信填写', `is_everyone_write_once` tinyint(1) NULL DEFAULT NULL COMMENT '每人只能填写一次', `is_everyone_day_write_once` tinyint(1) NULL DEFAULT NULL COMMENT '每人每天只能填写一次', `write_once_prompt_text` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '填写之后提示', `new_write_notify_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '新反馈通知邮件', `new_write_notify_wx` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '新反馈通知微信', `is_record_wx_user` tinyint(1) NULL DEFAULT NULL COMMENT '记录微信用户个人信息', `timed_collection_begin_time` datetime(0) NULL DEFAULT NULL COMMENT '定时收集开始时间', `timed_collection_end_time` datetime(0) NULL DEFAULT NULL COMMENT '定时收集结束时间', `timed_not_enabled_prompt_text` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '定时未启动提示文字', `timed_deactivate_prompt_text` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '定时停用会提示文字', `timed_quantitative_quantity` int(100) NULL DEFAULT NULL COMMENT '定时定量数量', `timed_end_prompt_text` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '定时定量完成提示', `share_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分享图片', `share_title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分享标题', `share_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分享描述', `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '更新时间', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `project_key`(`project_key`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 365 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目表单项' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for pr_user_project_theme -- ---------------------------- DROP TABLE IF EXISTS `pr_user_project_theme`; CREATE TABLE `pr_user_project_theme` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `project_key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '项目key', `theme_id` bigint(20) NULL DEFAULT NULL COMMENT '主题Id', `submit_btn_text` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '提交按钮文字', `logo_img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'logo图片', `logo_position` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'logo位置', `background_color` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '背景颜色', `background_img` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '背景图片', `show_title` tinyint(1) NULL DEFAULT 1 COMMENT '是否显示标题', `show_describe` tinyint(1) NULL DEFAULT 1 COMMENT '是否显示描述语', `show_number` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '显示序号', `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '更新时间', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `project_key`(`project_key`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 639 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '项目表单项' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for wx_mp_user -- ---------------------------- DROP TABLE IF EXISTS `wx_mp_user`; CREATE TABLE `wx_mp_user` ( `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键', `appid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '公众号AppId', `nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '昵称', `sex` tinyint(1) NULL DEFAULT NULL COMMENT '性别', `head_img_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '头像', `union_id` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `open_id` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '国家', `province` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '省', `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '城市', `is_subscribe` tinyint(1) NULL DEFAULT 1 COMMENT '是否关注', `user_id` bigint(20) NULL DEFAULT NULL COMMENT '用户Id', `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) ON UPDATE CURRENT_TIMESTAMP (0) COMMENT '更新时间', `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP (0) COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE, INDEX `wx_union_id`(`head_img_url`(191)) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '微信公众号用户 ' ROW_FORMAT = DYNAMIC; SET FOREIGN_KEY_CHECKS = 1; INSERT INTO `tduck`.`ac_user`(`id`, `name`, `avatar`, `gender`, `email`, `phone_number`, `password`, `reg_channel`, `last_login_channel`, `last_login_time`, `last_login_ip`, `deleted`, `create_time`, `update_time`) VALUES (201, 'Tduck001', 'https://oss.smileyi.top/757b505cfd34c64c85ca5b5690ee5293/4c415e1c1af04af68d740e667819bece.png', 0, 'test@tduck.com', NULL, 'ef797c8118f02dfb649607dd5d3f8c7623048c9c063d532cc95c5ed7a898a64f', '1', 2, '2021-06-24 11:08:21', '111.30.56.26', 0, '2020-11-12 11:50:50', '2021-06-24 11:08:21');