Слияние кода завершено, страница обновится автоматически
/*
Navicat Premium Data Transfer
Source Server : 腾讯云
Source Server Type : MySQL
Source Server Version : 50550
Source Host : localhost:3306
Source Schema : paike-backup
Target Server Type : MySQL
Target Server Version : 50550
File Encoding : 65001
Date: 09/07/2019 10:41:10
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for auction_access
-- ----------------------------
DROP TABLE IF EXISTS `auction_access`;
CREATE TABLE `auction_access` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`role_id` int(10) unsigned NOT NULL,
`nav_id` varchar(255) NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of auction_access
-- ----------------------------
BEGIN;
INSERT INTO `auction_access` VALUES (25, 44, '1#51#52#392#386#387#388#401#389#410#411#412#390#407#408#409#403#404#405#406');
INSERT INTO `auction_access` VALUES (17, 47, '1#51#52#392#382#383#384#385#400#391');
INSERT INTO `auction_access` VALUES (28, 21, '1#51#52#392#376#377#416#418#5#6#14#394#393#354#397#398#399#10#11#395#396#373#374#413#414#415#375#378#379#417');
COMMIT;
-- ----------------------------
-- Table structure for auction_admin
-- ----------------------------
DROP TABLE IF EXISTS `auction_admin`;
CREATE TABLE `auction_admin` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`headsmall` varchar(255) DEFAULT NULL COMMENT '头像',
`u_no` varchar(45) DEFAULT NULL COMMENT '用户编号',
`username` varchar(255) DEFAULT NULL COMMENT '用户名',
`phone` varchar(50) DEFAULT NULL COMMENT '手机号',
`email` varchar(200) DEFAULT NULL COMMENT '邮箱',
`password` varchar(255) DEFAULT NULL,
`role_id` int(10) unsigned DEFAULT NULL COMMENT '用户角色ID',
`status` int(10) unsigned DEFAULT NULL COMMENT '状态：1 正常，2 被禁用',
`login_error_time` varchar(45) DEFAULT NULL COMMENT '登录错误次数',
`last_ip` varchar(255) DEFAULT NULL,
`last_time` int(10) unsigned DEFAULT NULL,
`ticket` varchar(255) DEFAULT NULL COMMENT '登录令牌（每个账号每次登录都会刷新令牌，MD5加密）',
`create_time` int(11) DEFAULT NULL,
`role_type` char(1) DEFAULT NULL COMMENT '用户角色类型：和role表同步type',
`class_id` int(11) DEFAULT NULL,
`realname` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of auction_admin
-- ----------------------------
BEGIN;
INSERT INTO `auction_admin` VALUES (1, '', '10001', 'admin', '', '', 'e10adc3949ba59abbe56e057f20f883e', 21, 1, '', '58.32.13.127', 1542002200, '', 0, '1', NULL, NULL);
INSERT INTO `auction_admin` VALUES (38, NULL, NULL, 's02', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', 47, 1, NULL, NULL, NULL, NULL, 1541906473, '3', 25, '己振海');
INSERT INTO `auction_admin` VALUES (39, NULL, NULL, 's03', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', 47, 1, NULL, NULL, NULL, NULL, 1541906473, '3', 27, '欧阳幼霜');
INSERT INTO `auction_admin` VALUES (40, NULL, NULL, 's04', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', 47, 1, NULL, NULL, NULL, NULL, 1541906473, '3', 28, '驹嘉德');
INSERT INTO `auction_admin` VALUES (37, NULL, NULL, 's01', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', 47, 1, NULL, '180.172.108.79', 1541907286, NULL, 1541906473, '3', 23, '鄞雪曼');
INSERT INTO `auction_admin` VALUES (41, NULL, NULL, 's05', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', 47, 1, NULL, '180.172.108.79', 1541906778, NULL, 1541906473, '3', 29, '岳谷之');
INSERT INTO `auction_admin` VALUES (42, NULL, NULL, 's06', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', 47, 1, NULL, '180.172.108.79', 1541906905, NULL, 1541906473, '3', 30, '顿向槐');
INSERT INTO `auction_admin` VALUES (43, NULL, NULL, 's07', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', 47, 1, NULL, '180.172.108.79', 1541906879, NULL, 1541906473, '3', 31, '朋夜雪');
INSERT INTO `auction_admin` VALUES (44, NULL, NULL, 's08', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', 47, 1, NULL, NULL, NULL, NULL, 1541906473, '3', 29, '叶清嘉');
INSERT INTO `auction_admin` VALUES (45, NULL, NULL, 's09', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', 47, 1, NULL, NULL, NULL, NULL, 1541906473, '3', 32, '娄雪珍');
INSERT INTO `auction_admin` VALUES (46, NULL, NULL, 's10', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', 47, 1, NULL, NULL, NULL, NULL, 1541906473, '3', 32, '雪子怡');
INSERT INTO `auction_admin` VALUES (47, NULL, NULL, 't01', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', 44, 1, NULL, '180.172.108.79', 1541907302, NULL, 1541906486, '2', NULL, '改天韵');
INSERT INTO `auction_admin` VALUES (48, NULL, NULL, 't02', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', 44, 1, NULL, NULL, NULL, NULL, 1541906486, '2', NULL, '云承弼');
INSERT INTO `auction_admin` VALUES (49, NULL, NULL, 't03', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', 44, 1, NULL, NULL, NULL, NULL, 1541906486, '2', NULL, '逯夜梅');
INSERT INTO `auction_admin` VALUES (50, NULL, NULL, 't04', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', 44, 1, NULL, NULL, NULL, NULL, 1541906486, '2', NULL, '卿鸿波');
INSERT INTO `auction_admin` VALUES (51, NULL, NULL, 't05', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', 44, 1, NULL, NULL, NULL, NULL, 1541906486, '2', NULL, '智巍然');
INSERT INTO `auction_admin` VALUES (52, NULL, NULL, 't06', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', 44, 1, NULL, NULL, NULL, NULL, 1541906486, '2', NULL, '宰思宸');
INSERT INTO `auction_admin` VALUES (53, NULL, NULL, 't07', NULL, NULL, 'e10adc3949ba59abbe56e057f20f883e', 44, 1, NULL, NULL, NULL, NULL, 1541906486, '2', NULL, '郁易云');
COMMIT;
-- ----------------------------
-- Table structure for auction_api
-- ----------------------------
DROP TABLE IF EXISTS `auction_api`;
CREATE TABLE `auction_api` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`api_name` varchar(255) NOT NULL,
`controller` varchar(255) NOT NULL,
`function` varchar(255) NOT NULL,
`param` varchar(255) NOT NULL COMMENT '参数',
`return` varchar(255) NOT NULL COMMENT '返回',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `think_api_id_uindex` (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=75 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of auction_api
-- ----------------------------
BEGIN;
INSERT INTO `auction_api` VALUES (1, 'Center', 'Center', 'demo', '', '');
INSERT INTO `auction_api` VALUES (2, 'User', 'User', 'login', '{\n \"username\" : \"zc \",\n \"password\" : \"123456\"\n}', '');
INSERT INTO `auction_api` VALUES (3, 'User', 'User', 'verify', '', '');
INSERT INTO `auction_api` VALUES (4, 'Center', 'Center', 'enclosureList', '{\n \"p\" : 1,\n \"listRows\" : \"20\"\n}', '');
INSERT INTO `auction_api` VALUES (5, 'User', 'User', 'updatePwd', '{\"o_pwd\":\"123456\",\"n_pwd\":\"111111\",\"r_pwd\":\"111111\"}', '');
INSERT INTO `auction_api` VALUES (6, 'Center', 'Center', 'enclosureDetail', '{\n \"id\" : \"1\"\n}', '');
INSERT INTO `auction_api` VALUES (7, 'User', 'User', 'logout', '', '');
INSERT INTO `auction_api` VALUES (8, 'Center', 'Center', 'carList', '{\n \"p\" : 1,\n \"listRows\" : \"40\",\n \"keyword\" : \"\"\n}', '');
INSERT INTO `auction_api` VALUES (9, 'User', 'User', 'getUserInfo', '', '');
INSERT INTO `auction_api` VALUES (10, 'User', 'User', 'companyList', '', '');
INSERT INTO `auction_api` VALUES (11, 'User', 'User', 'companyAdd', '{}', '');
INSERT INTO `auction_api` VALUES (12, 'User', 'User', 'companyUpdate', '', '');
INSERT INTO `auction_api` VALUES (13, 'companyDel', 'companyDel', 'companyAdd', '', '');
INSERT INTO `auction_api` VALUES (14, 'User', 'User', 'companyDel', '', '');
INSERT INTO `auction_api` VALUES (15, 'User', 'User', 'roleList', '', '');
INSERT INTO `auction_api` VALUES (16, 'User', 'User', 'roleAdd', '{\"role_name\":\"\"}', '');
INSERT INTO `auction_api` VALUES (17, 'User', 'User', 'roleUpdate', '', '');
INSERT INTO `auction_api` VALUES (18, 'User', 'User', 'roleDel', '{\"id\":\"25\",\"role_name\":\"555\"}', '');
INSERT INTO `auction_api` VALUES (19, 'User', 'User', 'userList', '', '');
INSERT INTO `auction_api` VALUES (20, 'User', 'User', 'getCompanyList', '', '');
INSERT INTO `auction_api` VALUES (21, 'User', 'User', 'getCareerList', '', '');
INSERT INTO `auction_api` VALUES (22, 'User', 'User', 'userAdd', '{\"username\":\"用户\",\"career_label\":\"司机\",\"career_id\":\"2\",\"company_label\":\"666\",\"company_id\":\"19\",\"role_label\":\"阿斯顿\",\"role_id\":\"42\",\"email\":\"78670540@qq.com\",\"password\":\"176\",\"phone\":\"think123\"}', '');
INSERT INTO `auction_api` VALUES (23, 'User', 'User', 'userUpdate', '{\"id\":\"113\",\"company_id\":\"14\",\"username\":\"新的用户啊\",\"career_id\":\"1\",\"role_id\":\"43\",\"company_title\":\"洒\",\"career_title\":\"监控员\",\"role_name\":\"我是角色\",\"career_label\":\"管理员\",\"company_label\":\"哈哈哈\",\"role_label\":\"我是角色\",\"email\":\"5555@qq.com\",\"password\":\"231\",\"phone\":\"thin', '');
INSERT INTO `auction_api` VALUES (24, 'User', 'User', 'userDel', '{\"id\":\"112\",\"company_id\":\"19\",\"username\":\"用户阿萨德\",\"career_id\":\"1\",\"role_id\":\"42\",\"company_title\":\"666\",\"career_title\":\"管理员\",\"role_name\":\"阿斯顿\"}', '');
INSERT INTO `auction_api` VALUES (25, 'api', 'api', 'ossUpload', '{\n \"type\" : \"1\"\n}', '');
INSERT INTO `auction_api` VALUES (26, 'Center', 'Center', 'msgList', '{\"p\":1,\"listRows\":20,\"type\":1}', '');
INSERT INTO `auction_api` VALUES (27, 'Api', 'Api', 'upload', '{\n \"type\" : \"photo\"\n}', '');
INSERT INTO `auction_api` VALUES (28, 'Center', 'Center', 'msgDetail', '{\"id\":567}', '');
INSERT INTO `auction_api` VALUES (29, 'Center', 'Center', 'delMsg', '{\"id\":\"567\"}', '');
INSERT INTO `auction_api` VALUES (30, 'Center', 'Center', 'setMsgAllRead', '', '');
INSERT INTO `auction_api` VALUES (31, 'Center', 'Center', 'aboutUs', '{\n \"id\" : \"110\"\n}', '');
INSERT INTO `auction_api` VALUES (32, 'Center', 'Center', 'setMsgRead', '{\"id\":\"1315,\"}', '');
INSERT INTO `auction_api` VALUES (33, 'Center', 'Center', 'enclosureAdd', '{\n \"title\" : \"从 v 更好很好\",\n \"type\" : \"1\",\n \"content\" : \"asdass\"\n}', '');
INSERT INTO `auction_api` VALUES (34, 'Center', 'Center', 'enclosureDelete', '{\n \"id\" : \"1\"\n}', '');
INSERT INTO `auction_api` VALUES (35, 'Center', 'Center', 'carTypeListInterface', '', '');
INSERT INTO `auction_api` VALUES (36, 'Center', 'Center', '', '', '');
INSERT INTO `auction_api` VALUES (37, 'Center', 'Center', 'carEquipmentDetail', '', '');
INSERT INTO `auction_api` VALUES (38, 'Center', 'Center', 'carStatusListInterface', '', '');
INSERT INTO `auction_api` VALUES (39, 'Center', 'Center', 'carLogoListInterface', '', '');
INSERT INTO `auction_api` VALUES (40, 'Center', 'Center', 'carColorListInterface', '', '');
INSERT INTO `auction_api` VALUES (41, 'Center', 'Center', 'carPersonLoginListInterface', '', '');
INSERT INTO `auction_api` VALUES (42, 'Center', 'Center', 'carContainerTypeListInterface', '', '');
INSERT INTO `auction_api` VALUES (43, 'Center', 'Center', 'carBackDoorTypeListInterface', '', '');
INSERT INTO `auction_api` VALUES (44, 'Center', 'Center', 'carOperation', '{}', '');
INSERT INTO `auction_api` VALUES (45, 'Center', 'Center', 'carGroupList', '{\n \"p\" : \"1\",\n \"listRows\" : \"10000\"\n}', '');
INSERT INTO `auction_api` VALUES (46, 'Center', 'Center', 'carDelete', '{\"ids\":\"14\"}', '');
INSERT INTO `auction_api` VALUES (47, 'Center', 'Center', 'carDetail', '{\"ids\":\"17\"}', '');
INSERT INTO `auction_api` VALUES (48, 'Home', 'Home', 'nowData', '', '');
INSERT INTO `auction_api` VALUES (49, 'Home', 'Home', 'carDataInfo', '{\n \"p\" : \"1\",\n \"keyword\" : \"\"\n}', '');
INSERT INTO `auction_api` VALUES (50, 'Home', 'Home', 'carHistoryLocation', '{\n \"s_time\" : \"2018-08-01\",\n \"e_time\" : \"2018-08-02 23:00:00\",\n \"car_id\" : \"20\"\n}', '');
INSERT INTO `auction_api` VALUES (51, 'Home', 'Home', 'carAttrUpdate', '{\n \"sec\" : \"38\",\n \"car_attr_id\" : \"7\",\n \"car_id\" : \"20\"\n}', '');
INSERT INTO `auction_api` VALUES (52, 'Home', 'Home', 'carListByGroup', '{\"keyword\":\"\"}', '');
INSERT INTO `auction_api` VALUES (53, 'Home', 'Home', 'carMapList', '{\n \"p\" : \"1\",\n \"keyword\" : \"\"\n}', '');
INSERT INTO `auction_api` VALUES (54, 'Home', 'Home', 'isUnReadMsg', '', '');
INSERT INTO `auction_api` VALUES (55, 'Center', 'Center', 'systemConfig', '{\n \"id\" : \"110\"\n}', '');
INSERT INTO `auction_api` VALUES (56, 'Center', 'Center', 'systemConfigSet', '{\n \"timezone\" : \"-10\",\n \"speed\" : \"1\",\n \"temperature\" : \"2\"\n}', '');
INSERT INTO `auction_api` VALUES (57, 'vv', 'vv', '借口不存在', '{\n \"p\" : 1,\n \"listRows\" : \"70\"\n}', '');
INSERT INTO `auction_api` VALUES (58, 'Center', 'Center', '无接口', '{\n \"id\" : \"\"\n}', '');
INSERT INTO `auction_api` VALUES (59, 'Home', 'Home', 'getHotSearch', '{\"username\":\"Egor\",\"password\":\"123456\",\"verify\":\"\"}', '');
INSERT INTO `auction_api` VALUES (60, 'Test', 'Test', 'lockDemo', '{\"username\":\"Egor\",\"password\":\"123456\",\"verify\":\"\"}', '');
INSERT INTO `auction_api` VALUES (61, 'Home', 'Home', 'candidateList', '', '');
INSERT INTO `auction_api` VALUES (62, 'Home', 'Home', 'vote', '{\"content\":[{\"candidate_id\":\"3\",\"tenure\":\"1\",\"recommend\":\"1\"},{\"candidate_id\":\"4\",\"tenure\":\"2\",\"recommend\":\"2\"},{\"candidate_id\":\"5\",\"tenure\":\"3\",\"recommend\":\"3\"},{\"candidate_id\":\"6\",\"tenure\":\"1\",\"recommend\":\"1\"},{\"candidate_id\":\"7\",\"tenure\":\"2\",\"recommend', '');
INSERT INTO `auction_api` VALUES (63, 'Home', 'Home', 'is_close', '', '');
INSERT INTO `auction_api` VALUES (64, 'News', 'News', 'index', '', '');
INSERT INTO `auction_api` VALUES (65, 'News', 'News', 'detail', '{\"id\":\"26\"}', '');
INSERT INTO `auction_api` VALUES (66, 'Job', 'Job', 'index', '', '');
INSERT INTO `auction_api` VALUES (67, 'Home', 'Home', 'index', '', '');
INSERT INTO `auction_api` VALUES (68, 'Home', 'Home', 'subjectDetail', '{\"id\":\"\"}', '');
INSERT INTO `auction_api` VALUES (69, 'Home', 'Home', 'courtList', '', '');
INSERT INTO `auction_api` VALUES (70, 'Home', 'Home', 'getSubjectList', '{}', '');
INSERT INTO `auction_api` VALUES (71, 'Home', 'Home', 'addressList', '', '');
INSERT INTO `auction_api` VALUES (72, 'Home', 'Home', 'appleySubject', '{\"appointment_time\":\"2018-11-01 22时整\",\"username\":\"11\",\"phone\":\"11111111111\"}', '');
INSERT INTO `auction_api` VALUES (73, 'Home', 'Home', 'applySubject', '{\"id\":26,\"username\":\"Egor\",\"phone\":18930517060,\"time\":\"2019-09-09 08:12:31\"}', '');
INSERT INTO `auction_api` VALUES (74, 'Judge', 'Judge', 'login', '{\"username\":\"1\",\"password\":\"1111\"}', '');
COMMIT;
-- ----------------------------
-- Table structure for auction_api_log
-- ----------------------------
DROP TABLE IF EXISTS `auction_api_log`;
CREATE TABLE `auction_api_log` (
`id` int(32) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`apiversion` varchar(32) NOT NULL COMMENT 'Api版本号',
`safecode` varchar(32) NOT NULL DEFAULT '0' COMMENT 'Api安全码',
`handler` varchar(32) NOT NULL COMMENT 'Api控制器',
`method` varchar(32) NOT NULL COMMENT 'Api方法',
`handle_start_time` int(32) NOT NULL COMMENT 'Api开始执行时间',
`handle_time` int(32) NOT NULL COMMENT 'Api执行时间',
`handle_stop_time` int(32) NOT NULL COMMENT 'Api停止执行时间',
`request_data` longtext NOT NULL COMMENT 'Api请求数据',
`return_data` longtext NOT NULL COMMENT 'Api返回数据',
`client_ip` varchar(32) NOT NULL COMMENT 'Api请求IP',
`user_token` text NOT NULL COMMENT 'Api的用户token',
`user_uuid` varchar(32) NOT NULL COMMENT 'Api用户设备号',
`user_id` int(32) NOT NULL COMMENT 'Api用户ID',
`user_nickname` varchar(32) NOT NULL COMMENT 'Api用户昵称',
`error` varchar(32) NOT NULL COMMENT '错误码',
`error_msg` varchar(32) NOT NULL DEFAULT '0' COMMENT '错误提示',
`status` tinyint(4) NOT NULL COMMENT 'Api执行状态 1开始执行 2执行完毕',
`nonce` varchar(32) NOT NULL COMMENT '唯一随机数',
`sign` varchar(255) NOT NULL COMMENT '数字签名',
`device` varchar(45) NOT NULL COMMENT '设备名',
PRIMARY KEY (`id`) USING BTREE,
KEY `method` (`method`,`nonce`,`handler`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for auction_class
-- ----------------------------
DROP TABLE IF EXISTS `auction_class`;
CREATE TABLE `auction_class` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`node` int(11) DEFAULT NULL,
`pid` int(11) DEFAULT NULL,
`grade` char(1) DEFAULT NULL,
`year` char(4) DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of auction_class
-- ----------------------------
BEGIN;
INSERT INTO `auction_class` VALUES (23, '网络181', 2, 22, '', '', '2018-11-11 11:21:13');
INSERT INTO `auction_class` VALUES (22, '网络与通信工程学院', 1, 0, '', NULL, '2018-11-11 11:21:13');
INSERT INTO `auction_class` VALUES (24, '软件工程学院学院', 1, 0, '', NULL, '2018-11-11 11:21:13');
INSERT INTO `auction_class` VALUES (25, '软件151', 2, 24, '', '', '2018-11-11 11:21:13');
INSERT INTO `auction_class` VALUES (26, '外国语学院', 1, 0, '', NULL, '2018-11-11 11:21:13');
INSERT INTO `auction_class` VALUES (27, '韩语161', 2, 26, '', '', '2018-11-11 11:21:13');
INSERT INTO `auction_class` VALUES (28, '日语171', 2, 26, '2', '2017', '2018-11-11 11:21:13');
INSERT INTO `auction_class` VALUES (29, '网络171', 2, 22, '2', '2017', '2018-11-11 11:21:13');
INSERT INTO `auction_class` VALUES (30, '安全171', 2, 22, '2', '2017', '2018-11-11 11:21:13');
INSERT INTO `auction_class` VALUES (31, '网络161', 2, 22, '3', '2016', '2018-11-11 11:21:13');
INSERT INTO `auction_class` VALUES (32, '安全151', 2, 22, '4', '2015', '2018-11-11 11:21:13');
COMMIT;
-- ----------------------------
-- Table structure for auction_course
-- ----------------------------
DROP TABLE IF EXISTS `auction_course`;
CREATE TABLE `auction_course` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`teacher_id` int(11) DEFAULT NULL,
`content` varchar(255) DEFAULT NULL,
`class_id` int(11) DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of auction_course
-- ----------------------------
BEGIN;
INSERT INTO `auction_course` VALUES (14, 'PHP实战开发', 47, '介绍如何使用PHP', 29, '2018-11-11 00:00:00');
INSERT INTO `auction_course` VALUES (15, 'JAVA实战', 47, '介绍如何使用JAVA', 30, '2018-11-11 00:00:00');
COMMIT;
-- ----------------------------
-- Table structure for auction_course_room
-- ----------------------------
DROP TABLE IF EXISTS `auction_course_room`;
CREATE TABLE `auction_course_room` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`teacher_id` int(11) DEFAULT NULL,
`course_id` int(11) DEFAULT NULL,
`class_id` int(11) DEFAULT NULL,
`room_id` int(11) DEFAULT NULL,
`section` int(11) DEFAULT NULL,
`status` char(1) DEFAULT NULL COMMENT '审核状态：0 未通过，1 已通过',
`date` date DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of auction_course_room
-- ----------------------------
BEGIN;
INSERT INTO `auction_course_room` VALUES (4, 47, 15, 31, 6, 3, '1', '2018-11-15', '2018-11-11 00:00:00');
INSERT INTO `auction_course_room` VALUES (3, 47, 14, 29, 6, 2, '2', '2018-11-15', '2018-11-11 00:00:00');
INSERT INTO `auction_course_room` VALUES (5, 47, 14, 29, 6, 6, '0', '2018-11-15', '2018-11-11 00:00:00');
INSERT INTO `auction_course_room` VALUES (6, 47, 15, 30, 6, 6, '1', '2018-11-15', '2018-11-11 00:00:00');
COMMIT;
-- ----------------------------
-- Table structure for auction_feedback
-- ----------------------------
DROP TABLE IF EXISTS `auction_feedback`;
CREATE TABLE `auction_feedback` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL,
`title` varchar(255) DEFAULT NULL,
`type` char(255) DEFAULT NULL,
`content` varchar(255) DEFAULT NULL,
`back_content` varchar(255) DEFAULT NULL,
`teacher_id` int(11) DEFAULT NULL,
`is_anony` char(1) NOT NULL DEFAULT '1' COMMENT '是否匿名：0 否，1 是',
`create_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of auction_feedback
-- ----------------------------
BEGIN;
INSERT INTO `auction_feedback` VALUES (2, 41, '怎么看不到内容啊', '3', '打开系统看不到内容', '因为你没有权限呀', 47, '0', '2018-11-11 11:25:10');
COMMIT;
-- ----------------------------
-- Table structure for auction_file
-- ----------------------------
DROP TABLE IF EXISTS `auction_file`;
CREATE TABLE `auction_file` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sort` int(1) DEFAULT '0',
`create_time` int(11) DEFAULT NULL,
`status` int(1) DEFAULT '1',
`update_time` int(11) DEFAULT NULL,
`download` int(11) DEFAULT '0',
`location` varchar(20) DEFAULT 'local',
`sha1` varchar(50) DEFAULT NULL,
`md5` varchar(32) DEFAULT NULL,
`size` int(11) DEFAULT NULL,
`base64` text,
`ext` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`path` varchar(255) DEFAULT NULL,
`url` text,
`uid` int(11) DEFAULT '0',
`thumb` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `think_file_id_uindex` (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='文件表';
-- ----------------------------
-- Records of auction_file
-- ----------------------------
BEGIN;
INSERT INTO `auction_file` VALUES (1, 0, 1541891130, 1, 1541891130, 0, 'location', '47bcf60fca8c0f706afbe24fa49e6ccefa04a337', '1d04eea2c52e59bceb827491924b9f2d', 28066, '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '学生示例表.xlsx', '/Uploads/resume/student/2018-11-11/5be7643a9a4b8.xlsx', 'http://localhost//Uploads/resume/student/2018-11-11/5be7643a9a4b8.xlsx', 0, '/Uploads/photo/2018-11-11/500-5be7643a9a4b8.xlsx');
INSERT INTO `auction_file` VALUES (2, 0, 1541891140, 1, 1541891140, 0, 'location', '6b8089d6bc90a89e7e77eaffb5b154b51d37d02d', 'aed65cdc1053c7f171ce2bb59f6743db', 24553, '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '教师示例表.xlsx', '/Uploads/resume/teacher/2018-11-11/5be76444bddef.xlsx', 'http://localhost//Uploads/resume/teacher/2018-11-11/5be76444bddef.xlsx', 0, '/Uploads/photo/2018-11-11/500-5be76444bddef.xlsx');
INSERT INTO `auction_file` VALUES (3, 0, 1541891694, 1, 1541891694, 0, 'location', '47bcf60fca8c0f706afbe24fa49e6ccefa04a337', '1d04eea2c52e59bceb827491924b9f2d', 28066, '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '学生示例表.xlsx', '/Uploads/resume/student/2018-11-11/5be7666e6deb3.xlsx', 'http://localhost//Uploads/resume/student/2018-11-11/5be7666e6deb3.xlsx', 0, '/Uploads/photo/2018-11-11/500-5be7666e6deb3.xlsx');
INSERT INTO `auction_file` VALUES (4, 0, 1541891702, 1, 1541891702, 0, 'location', '6b8089d6bc90a89e7e77eaffb5b154b51d37d02d', 'aed65cdc1053c7f171ce2bb59f6743db', 24553, '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '教师示例表.xlsx', '/Uploads/resume/teacher/2018-11-11/5be76676cd886.xlsx', 'http://localhost//Uploads/resume/teacher/2018-11-11/5be76676cd886.xlsx', 0, '/Uploads/photo/2018-11-11/500-5be76676cd886.xlsx');
INSERT INTO `auction_file` VALUES (5, 0, 1541891961, 1, 1541891961, 0, 'location', '47bcf60fca8c0f706afbe24fa49e6ccefa04a337', '1d04eea2c52e59bceb827491924b9f2d', 28066, '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '学生示例表.xlsx', '/Uploads/resume/student/2018-11-11/5be76779365c2.xlsx', 'http://localhost//Uploads/resume/student/2018-11-11/5be76779365c2.xlsx', 0, '/Uploads/photo/2018-11-11/500-5be76779365c2.xlsx');
INSERT INTO `auction_file` VALUES (6, 0, 1541891969, 1, 1541891969, 0, 'location', '6b8089d6bc90a89e7e77eaffb5b154b51d37d02d', 'aed65cdc1053c7f171ce2bb59f6743db', 24553, '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '教师示例表.xlsx', '/Uploads/resume/teacher/2018-11-11/5be7678173546.xlsx', 'http://localhost//Uploads/resume/teacher/2018-11-11/5be7678173546.xlsx', 0, '/Uploads/photo/2018-11-11/500-5be7678173546.xlsx');
INSERT INTO `auction_file` VALUES (7, 0, 1541892382, 1, 1541892382, 0, 'location', '5e591c371ac17007c450d6e28850ce7aeafaa405', 'b7545721273cc3ecab8fa1e60fe3268d', 28071, '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '学生示例表.xlsx', '/Uploads/resume/student/2018-11-11/5be7691e7fa06.xlsx', 'http://localhost//Uploads/resume/student/2018-11-11/5be7691e7fa06.xlsx', 0, '/Uploads/photo/2018-11-11/500-5be7691e7fa06.xlsx');
INSERT INTO `auction_file` VALUES (8, 0, 1541892389, 1, 1541892389, 0, 'location', '6b8089d6bc90a89e7e77eaffb5b154b51d37d02d', 'aed65cdc1053c7f171ce2bb59f6743db', 24553, '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '教师示例表.xlsx', '/Uploads/resume/teacher/2018-11-11/5be769261fd3e.xlsx', 'http://localhost//Uploads/resume/teacher/2018-11-11/5be769261fd3e.xlsx', 0, '/Uploads/photo/2018-11-11/500-5be769261fd3e.xlsx');
INSERT INTO `auction_file` VALUES (9, 0, 1541897780, 1, 1541897780, 0, 'location', '6b8089d6bc90a89e7e77eaffb5b154b51d37d02d', 'aed65cdc1053c7f171ce2bb59f6743db', 24553, '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '教师示例表.xlsx', '/Uploads/resume/teacher/2018-11-11/5be77e346454d.xlsx', 'http://www.seosite.cn//Uploads/resume/teacher/2018-11-11/5be77e346454d.xlsx', 0, '/Uploads/photo/2018-11-11/500-5be77e346454d.xlsx');
INSERT INTO `auction_file` VALUES (10, 0, 1541897790, 1, 1541897790, 0, 'location', '6b8089d6bc90a89e7e77eaffb5b154b51d37d02d', 'aed65cdc1053c7f171ce2bb59f6743db', 24553, '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '教师示例表.xlsx', '/Uploads/resume/teacher/2018-11-11/5be77e3e303c8.xlsx', 'http://www.seosite.cn//Uploads/resume/teacher/2018-11-11/5be77e3e303c8.xlsx', 0, '/Uploads/photo/2018-11-11/500-5be77e3e303c8.xlsx');
INSERT INTO `auction_file` VALUES (11, 0, 1541897820, 1, 1541897820, 0, 'location', '6b8089d6bc90a89e7e77eaffb5b154b51d37d02d', 'aed65cdc1053c7f171ce2bb59f6743db', 24553, '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '教师示例表.xlsx', '/Uploads/resume/teacher/2018-11-11/5be77e5caef56.xlsx', 'http://www.seosite.cn//Uploads/resume/teacher/2018-11-11/5be77e5caef56.xlsx', 0, '/Uploads/photo/2018-11-11/500-5be77e5caef56.xlsx');
INSERT INTO `auction_file` VALUES (12, 0, 1541897875, 1, 1541897875, 0, 'location', '6b8089d6bc90a89e7e77eaffb5b154b51d37d02d', 'aed65cdc1053c7f171ce2bb59f6743db', 24553, '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '教师示例表.xlsx', '/Uploads/resume/teacher/2018-11-11/5be77e93a70e1.xlsx', 'http://www.seosite.cn//Uploads/resume/teacher/2018-11-11/5be77e93a70e1.xlsx', 0, '/Uploads/photo/2018-11-11/500-5be77e93a70e1.xlsx');
INSERT INTO `auction_file` VALUES (13, 0, 1541898205, 1, 1541898205, 0, 'location', '6b8089d6bc90a89e7e77eaffb5b154b51d37d02d', 'aed65cdc1053c7f171ce2bb59f6743db', 24553, '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '教师示例表.xlsx', '/Uploads/resume/teacher/2018-11-11/5be77fdd60cca.xlsx', 'http://www.seosite.cn//Uploads/resume/teacher/2018-11-11/5be77fdd60cca.xlsx', 0, '/Uploads/photo/2018-11-11/500-5be77fdd60cca.xlsx');
INSERT INTO `auction_file` VALUES (14, 0, 1541898294, 1, 1541898294, 0, 'location', '6b8089d6bc90a89e7e77eaffb5b154b51d37d02d', 'aed65cdc1053c7f171ce2bb59f6743db', 24553, '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '教师示例表.xlsx', '/Uploads/resume/teacher/2018-11-11/5be780365baf6.xlsx', 'http://www.seosite.cn//Uploads/resume/teacher/2018-11-11/5be780365baf6.xlsx', 0, '/Uploads/photo/2018-11-11/500-5be780365baf6.xlsx');
INSERT INTO `auction_file` VALUES (15, 0, 1541906473, 1, 1541906473, 0, 'location', '34f96db4298723976b495ebc1455e8c448e9c63f', '4811c0af0a752cd559dfc8b977cbc045', 40579, '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '学生示例表.xlsx', '/Uploads/resume/student/2018-11-11/5be7a02920ee4.xlsx', 'http://www.seosite.cn//Uploads/resume/student/2018-11-11/5be7a02920ee4.xlsx', 0, '/Uploads/photo/2018-11-11/500-5be7a02920ee4.xlsx');
INSERT INTO `auction_file` VALUES (16, 0, 1541906486, 1, 1541906486, 0, 'location', '508b465399885baac33f939a6097d337fbdbb126', '1fdbdb98b8e3a95d893691a6b6c12ed7', 26671, '', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', '教师示例表.xlsx', '/Uploads/resume/teacher/2018-11-11/5be7a0363f070.xlsx', 'http://www.seosite.cn//Uploads/resume/teacher/2018-11-11/5be7a0363f070.xlsx', 0, '/Uploads/photo/2018-11-11/500-5be7a0363f070.xlsx');
COMMIT;
-- ----------------------------
-- Table structure for auction_nav
-- ----------------------------
DROP TABLE IF EXISTS `auction_nav`;
CREATE TABLE `auction_nav` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`nav_name` varchar(255) DEFAULT NULL,
`controller` varchar(255) DEFAULT NULL,
`function` varchar(255) DEFAULT NULL,
`pid` int(10) unsigned DEFAULT NULL,
`type` int(10) unsigned DEFAULT NULL,
`icon` varchar(45) DEFAULT 'fa-list-alt',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=419 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of auction_nav
-- ----------------------------
BEGIN;
INSERT INTO `auction_nav` VALUES (1, '首页', 'index', 'index', 0, 0, 'fa-tachometer');
INSERT INTO `auction_nav` VALUES (2, '发布站内信', 'integral', 'gonggao', 107, 0, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (7, '添加角色', 'admin', 'addrole', 84, 0, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (8, '编辑角色', 'admin', 'editrole', 84, 0, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (9, '删除角色', 'admin', 'deleterole', 84, 0, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (11, '添加管理员', 'admin', 'addadmin', 10, 0, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (6, '角色管理', 'admin', 'rolelist', 5, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (14, '权限设置', 'Admin', 'access', 6, 0, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (374, '实训室列表', 'Pt', 'index', 373, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (30, '预约列表', 'Appointment', 'index', 29, 0, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (300, '视频列表', 'Video', 'videoVideotape', 166, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (51, '平台总计', 'Index', 'main', 1, 0, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (52, '修改密码', 'Index', 'pwd', 1, 0, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (376, '学生管理', 'Student', 'index', 0, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (109, '广告列表', 'banner', 'lists', 108, 0, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (110, '增加广告', 'banner', 'add', 108, 0, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (5, '管理工具', 'System', 'index', 0, 0, 'fa-cog');
INSERT INTO `auction_nav` VALUES (148, 'api列表', 'test', 'api', 147, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (149, 'api日志', 'test', 'api_log', 147, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (161, '数据表列表', 'Test', 'tableList', 147, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (346, '反馈列表', 'Feedback', 'index', 345, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (299, '图片列表', 'Picture', 'picturesList', 173, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (314, '标签列表', 'Tag', 'index', 313, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (348, '候选人列表', 'Candidate', 'index', 347, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (316, '订单列表', 'Order', 'index', 315, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (356, '标的物列表', 'subject', 'index', 355, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (351, '投票列表', 'Vote', 'index', 350, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (354, '节点管理', 'System', 'nodes', 5, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (357, '添加标的物', 'subject', 'add', 355, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (359, '法院列表', 'Court', 'index', 358, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (360, '添加法院', 'Court', 'add', 358, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (375, '添加实训室', 'Pt', 'add', 373, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (362, '招聘列表', 'Job', 'index', 361, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (363, '发布招聘', 'Job', 'add', 361, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (365, '资讯列表', 'News', 'index', 364, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (366, '发布资讯', 'News', 'add', 364, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (377, '学生列表', 'Student', 'index', 376, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (368, '友情链接列表', 'Friend', 'index', 367, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (369, '添加友情链接', 'Friend', 'add', 367, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (10, '管理员列表', 'admin', 'adminlist', 5, 0, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (394, '添加角色', 'Admin', 'addrole', 6, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (395, '编辑管理员', 'Admin', 'editadmin', 10, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (393, '编辑角色', 'Admin', 'editrole', 6, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (392, '首页', 'Index', 'index', 1, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (373, '实训室管理', 'Pt', 'index', 0, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (378, '教师管理', 'Teacher', 'index', 0, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (379, '教师列表', 'Teacher', 'index', 378, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (381, '课表列表', 'Timetable', 'index', 380, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (382, '学生端', 'StudentManager', 'index', 0, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (383, '我的课表', 'StudentManager', 'timetable', 382, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (384, '实训室列表', 'StudentManager', 'pt', 382, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (385, '意见反馈', 'StudentManager', 'feedback', 382, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (386, '教师端', 'TeacherManager', 'index', 0, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (387, '我的课表', 'TeacherManager', 'index', 386, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (388, '意见反馈', 'TeacherManager', 'feedback', 386, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (389, '实训室管理', 'TeacherManager', 'pt', 386, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (390, '我的课程', 'TeacherManager', 'course', 386, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (391, '讲师推荐', 'StudentManager', 'study', 382, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (396, '删除管理员', 'Admin', 'deleteadmin', 10, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (397, '添加节点', 'System', 'nodesAdd', 354, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (398, '编辑节点', 'System', 'nodesEdit', 354, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (399, '删除节点', 'System', 'nodesDel', 354, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (400, '提交意见反馈', 'StudentManager', 'feedbackAdd', 385, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (401, '意见回复', 'TeacherManager', 'feedbackReply', 388, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (403, '我的推荐', 'TeacherManager', 'study', 386, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (404, '添加推荐', 'TeacherManager', 'studyAdd', 403, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (405, '编辑推荐', 'TeacherManager', 'studyEdit', 403, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (406, '删除推荐', 'TeacherManager', 'studyDelete', 403, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (407, '添加课程', 'TeacherManager', 'courseAdd', 390, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (408, '编辑课程', 'TeacherManager', 'courseEdit', 390, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (409, '删除课程', 'TeacherManager', 'courseDelete', 390, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (410, '申请实训室', 'TeacherManager', 'ptApply', 389, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (411, '我的申请', 'TeacherManager', 'ptApplyList', 389, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (412, '申请实训室时间时间', 'TeacherManager', 'ptApplyDateList', 389, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (413, '查看申请', 'Pt', 'applyList', 374, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (414, '通过审核', 'Pt', 'enable', 374, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (415, '拒绝审核', 'Pt', 'disable', 374, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (416, '导入数据', 'Student', 'add', 377, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (417, '导入教师', 'Teacher', 'add', 379, 1, 'fa-list-alt');
INSERT INTO `auction_nav` VALUES (418, '导入测试', 'Base', 'file_upload', 377, 1, 'fa-list-alt');
COMMIT;
-- ----------------------------
-- Table structure for auction_role
-- ----------------------------
DROP TABLE IF EXISTS `auction_role`;
CREATE TABLE `auction_role` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`role_name` varchar(255) DEFAULT NULL,
`type` int(10) unsigned DEFAULT NULL,
`status` int(10) unsigned DEFAULT NULL,
`uid` int(11) DEFAULT NULL COMMENT '所属某个用户下面的角色',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=48 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of auction_role
-- ----------------------------
BEGIN;
INSERT INTO `auction_role` VALUES (21, '管理员', 1, 1, NULL);
INSERT INTO `auction_role` VALUES (44, '教师', 1, 1, NULL);
INSERT INTO `auction_role` VALUES (47, '学生', 1, 1, NULL);
COMMIT;
-- ----------------------------
-- Table structure for auction_room
-- ----------------------------
DROP TABLE IF EXISTS `auction_room`;
CREATE TABLE `auction_room` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`content` varchar(255) DEFAULT NULL,
`author` varchar(255) DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of auction_room
-- ----------------------------
BEGIN;
INSERT INTO `auction_room` VALUES (5, '计算机实训室01', '计算机相关', '姜晓武', '2018-11-11 11:20:45');
INSERT INTO `auction_room` VALUES (6, '计算机实训室02', '计算机相关、、', '姜晓武', '2018-11-11 11:20:55');
COMMIT;
-- ----------------------------
-- Table structure for auction_send_email
-- ----------------------------
DROP TABLE IF EXISTS `auction_send_email`;
CREATE TABLE `auction_send_email` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`email` varchar(200) NOT NULL,
`subject` varchar(255) NOT NULL,
`body` text NOT NULL,
`type` char(1) NOT NULL COMMENT '邮箱类型：1 注册，2 修改邮箱',
`create_time` int(11) NOT NULL,
`code` varchar(45) NOT NULL COMMENT '验证码',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COMMENT='发送验证码';
-- ----------------------------
-- Table structure for auction_sms
-- ----------------------------
DROP TABLE IF EXISTS `auction_sms`;
CREATE TABLE `auction_sms` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`uid` int(11) NOT NULL COMMENT '用户id',
`phone` varchar(45) NOT NULL COMMENT '用户手机号',
`content` varchar(255) NOT NULL COMMENT '发送内容',
`code` int(11) NOT NULL COMMENT '验证码',
`status` tinyint(4) NOT NULL COMMENT '发送状态',
`type` int(1) NOT NULL COMMENT '1 注册，2 修改密码，3 其他',
`create_time` int(11) NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=277 DEFAULT CHARSET=utf8 COMMENT='短信表';
-- ----------------------------
-- Table structure for auction_study
-- ----------------------------
DROP TABLE IF EXISTS `auction_study`;
CREATE TABLE `auction_study` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`teacher_id` int(11) DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`linkurl` varchar(255) DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of auction_study
-- ----------------------------
BEGIN;
INSERT INTO `auction_study` VALUES (2, 47, 'PHP书籍', 'https://www.jd.com', '2018-11-11 00:00:00');
INSERT INTO `auction_study` VALUES (3, 47, 'JAVA书籍', 'https://www.jd.com', '2018-11-11 00:00:00');
COMMIT;
-- ----------------------------
-- Table structure for auction_timetable
-- ----------------------------
DROP TABLE IF EXISTS `auction_timetable`;
CREATE TABLE `auction_timetable` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` date DEFAULT NULL,
`class_id` int(11) DEFAULT NULL,
`section1` int(11) DEFAULT NULL,
`section2` int(11) DEFAULT NULL,
`section3` int(11) DEFAULT NULL,
`section4` int(11) DEFAULT NULL,
`section5` int(11) DEFAULT NULL,
`section6` int(11) DEFAULT NULL,
`section7` int(11) DEFAULT NULL,
`section8` int(11) DEFAULT NULL,
`section9` int(11) DEFAULT NULL,
`section10` int(11) DEFAULT NULL,
`create_time` datetime DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of auction_timetable
-- ----------------------------
BEGIN;
INSERT INTO `auction_timetable` VALUES (2, '2018-11-15', 30, NULL, NULL, NULL, NULL, NULL, 6, NULL, NULL, NULL, NULL, '2018-11-11 11:25:43');
INSERT INTO `auction_timetable` VALUES (3, '2018-11-15', 31, NULL, NULL, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2018-11-11 11:26:00');
COMMIT;
-- ----------------------------
-- Table structure for auction_token
-- ----------------------------
DROP TABLE IF EXISTS `auction_token`;
CREATE TABLE `auction_token` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'tokenID',
`uid` int(11) DEFAULT NULL COMMENT '用户ID',
`user_token` longtext COMMENT '用户token',
`expire_time` int(11) DEFAULT NULL COMMENT '用户过期时间 ',
`platform` varchar(20) DEFAULT 'app' COMMENT '平台',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of auction_token
-- ----------------------------
BEGIN;
INSERT INTO `auction_token` VALUES (1, 1, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6IjEiLCJ1c2VybmFtZSI6Ik1BODQ2MjkyIn0.pQDH4Tyf7Ukze-fdrXtGc87JEdAaIG-8Ev2kXcr9f2g', 0, 'website');
INSERT INTO `auction_token` VALUES (2, 15, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6IjE1IiwidXNlcm5hbWUiOiJNQTE2OTM2OSJ9.bO7_JoOqzRLmZ5Gp_A803LyvD3ioD_D4ddWDbIxrpRM', 0, 'website');
INSERT INTO `auction_token` VALUES (3, 14, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6IjE0IiwidXNlcm5hbWUiOiJNQTU2NDcwMCJ9.rExI6HXC6AVRh_rsDw3f_uchWXrT3grKAmdzgWoJy3E', 0, 'website');
INSERT INTO `auction_token` VALUES (4, 140, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6IjE0MCIsInVzZXJuYW1lIjoiTUE3NDgwNDUifQ.KgcbcR8mBq97r6vxWRQ2XNA_rAU0xiOpIM714ixtgRs', 0, 'website');
INSERT INTO `auction_token` VALUES (5, 163, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6IjE2MyIsInVzZXJuYW1lIjoiTUEzNTczMDEifQ.NkJH6-dN846L3cfolbQTiNJaxT8oUrkf3rGh8G1VT90', 0, 'website');
INSERT INTO `auction_token` VALUES (6, 165, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6IjE2NSIsInVzZXJuYW1lIjoiTUE0MDgxOTIifQ.p-oBigcJ-Zm3hFsTnKnf15V8KPRjguCQgeXcAw7wLEE', 0, 'website');
INSERT INTO `auction_token` VALUES (7, 159, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6IjE1OSIsInVzZXJuYW1lIjoiTUExODAxNDIifQ.wJIdpDw2SYJqSCOkjDnoZFXQJyF4QICa3zA9Bl46_cQ', 0, 'website');
INSERT INTO `auction_token` VALUES (8, 167, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6IjE2NyIsInVzZXJuYW1lIjoiTUE0OTc4ODgifQ.on8rgJ6JUabcoOLr3iTkuzMz6XGR6cpOnKGAzEweQ1E', 0, 'website');
INSERT INTO `auction_token` VALUES (9, 168, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6IjE2OCIsInVzZXJuYW1lIjoiTUEyODYxMjIifQ.qIVuYwfSbtFk6rkk1PaGgbev7fRxy3Z7Qcms_EtAL_s', 0, 'website');
INSERT INTO `auction_token` VALUES (10, 170, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6IjE3MCIsInVzZXJuYW1lIjoiTUE1MTA5MjAifQ.c0v-j9Pve_vmG-ttqszkOCqE2bnD-Rn4p7Za-pK0YBA', 0, 'website');
INSERT INTO `auction_token` VALUES (11, 172, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6IjE3MiIsInVzZXJuYW1lIjoiTUEyNjk3MTIifQ.EcurEN2t-oV4cT9OBAPeF41r12m37Lco3rHv948CFWQ', 0, 'website');
INSERT INTO `auction_token` VALUES (12, 173, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6IjE3MyIsInVzZXJuYW1lIjoiTUE5NjA0OTkifQ.XleEmBLkgIXU02b3oUDoQqkSDM13Nbb5MYuD8zBtMY8', 0, 'website');
INSERT INTO `auction_token` VALUES (13, 2, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6IjIiLCJ1c2VybmFtZSI6Ik1BNTg4Mzk3In0.6Lewi8KJMA-akPczpYY7JnrKmO-Iy1IdEUlxGDHDiS0', 0, 'website');
INSERT INTO `auction_token` VALUES (14, 174, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6IjE3NCIsInVzZXJuYW1lIjoiTUE4NDIzNzkifQ.Ht__nYI6oG1awcYl0We1KB-wq82fyAwAf3YolWQnbdU', 0, 'website');
INSERT INTO `auction_token` VALUES (15, 86, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6Ijg2IiwidXNlcm5hbWUiOiJNQTQ0NTQ0NSJ9.IXz80LWNDmOV7wOMt_sgWP7x4CdJ7NCIdPp2ghOx0RE', 0, 'website');
INSERT INTO `auction_token` VALUES (16, 175, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6IjE3NSIsInVzZXJuYW1lIjoiTUE2NjUxMDQifQ.lQUlRlLBsw160wsFuDckvB3-2GJdFvrx_sWbQHcDz_0', 0, 'website');
INSERT INTO `auction_token` VALUES (17, 177, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6IjE3NyIsInVzZXJuYW1lIjoiTUEyNTU3MjkifQ.kqn48iNvT8_awyOQZiHjEadVcrpQnHaJXS0Zd58DQIs', 0, 'website');
INSERT INTO `auction_token` VALUES (18, 85, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6Ijg1IiwidXNlcm5hbWUiOiJNQTUzNzE1OSJ9.b3VnjO-a9Vh53f43_j-TOH7v3nZ9rW9elBgcVJIRw3Q', 0, 'website');
COMMIT;
SET FOREIGN_KEY_CHECKS = 1;
Вы можете оставить комментарий после Вход в систему
Неприемлемый контент может быть отображен здесь и не будет показан на странице. Вы можете проверить и изменить его с помощью соответствующей функции редактирования.
Если вы подтверждаете, что содержание не содержит непристойной лексики/перенаправления на рекламу/насилия/вульгарной порнографии/нарушений/пиратства/ложного/незначительного или незаконного контента, связанного с национальными законами и предписаниями, вы можете нажать «Отправить» для подачи апелляции, и мы обработаем ее как можно скорее.
Опубликовать ( 0 )