不记得是哪个项目里的数据表文件,保存了以防万一:
/*
Navicat Premium Data Transfer
Source Server : local
Source Server Type : MySQL
Source Server Version : 80020
Source Host : localhost:3306
Source Schema : sanguo
Target Server Type : MySQL
Target Server Version : 80020
File Encoding : 65001
Date: 04/12/2020 13:02:14
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for apply_out
-- ----------------------------
DROP TABLE IF EXISTS `apply_out`;
CREATE TABLE `apply_out` (
`id` int(0) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
`type` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'activity-活动审核,user-用户,team-社团,enroll-活动报名',
`status` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'toman' COMMENT 'success-通过,fail-失败,toman-待处理',
`apply_time` datetime(0) NULL DEFAULT NULL COMMENT '提交审核时间',
`apply_cnt_id` int(0) NULL DEFAULT NULL COMMENT '提交审核对象的id',
`reply_msg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '回复消息',
`last_man_time` datetime(0) NULL DEFAULT NULL COMMENT '通过时间',
`pass_uid` int(0) NULL DEFAULT NULL COMMENT '通过的用户id',
`pass_aname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '通过的管理员name',
`apply_count` int(0) NULL DEFAULT 0 COMMENT '提交该审核的次数',
`apply_uid` int(0) NULL DEFAULT NULL COMMENT '提交申请者的用户id',
`apply_tid` int(0) NULL DEFAULT NULL COMMENT '提交申请的社团id',
`last_man_aname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '最后操作的管理员用户名',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '报名、审核、申请表,数据结构重复,暂时废弃' ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;