/*
 Navicat MySQL Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : localhost:3306
 Source Schema         : grade

 Target Server Type    : MySQL
 Target Server Version : 50726
 File Encoding         : 65001

 Date: 07/03/2020 21:28:58
*/


-- ----------------------------
-- Table structure for tp_access
-- ----------------------------
CREATE TABLE `tp_access`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` mediumint(8) UNSIGNED NOT NULL,
  `role_id` mediumint(8) UNSIGNED NOT NULL,
  `details` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 35 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tp_access
-- ----------------------------
INSERT INTO `tp_access` VALUES (1, 19, 2, NULL);
INSERT INTO `tp_access` VALUES (2, 20, 4, NULL);
INSERT INTO `tp_access` VALUES (3, 21, 5, NULL);
INSERT INTO `tp_access` VALUES (4, 24, 1, NULL);
INSERT INTO `tp_access` VALUES (5, 25, 3, NULL);
INSERT INTO `tp_access` VALUES (6, 19, 3, NULL);
INSERT INTO `tp_access` VALUES (7, 21, 4, NULL);
INSERT INTO `tp_access` VALUES (8, 19, 1, NULL);

-- ----------------------------
-- Table structure for tp_book
-- ----------------------------
CREATE TABLE `tp_book`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` mediumint(8) UNSIGNED NOT NULL,
  `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tp_book
-- ----------------------------
INSERT INTO `tp_book` VALUES (1, 19, '《莎士比亚》');
INSERT INTO `tp_book` VALUES (2, 20, '《悲惨世界》');
INSERT INTO `tp_book` VALUES (3, 21, '《西游记》');
INSERT INTO `tp_book` VALUES (4, 24, '《红楼梦》');
INSERT INTO `tp_book` VALUES (5, 25, '《圣经》');
INSERT INTO `tp_book` VALUES (6, 26, '《三个代表》');
INSERT INTO `tp_book` VALUES (7, 27, '《国富论》');
INSERT INTO `tp_book` VALUES (8, 29, '《道德情操论》');
INSERT INTO `tp_book` VALUES (9, 79, '《资本论》');

-- ----------------------------
-- Table structure for tp_one
-- ----------------------------
CREATE TABLE `tp_one`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自动编号',
  `user` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '学生名',
  `math` tinyint(3) UNSIGNED NOT NULL COMMENT '数学成绩',
  `chinese` tinyint(3) NOT NULL,
  `english` tinyint(3) NOT NULL,
  `create_time` datetime(0) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tp_one
-- ----------------------------
INSERT INTO `tp_one` VALUES (1, '张三', 158, 85, 95, '2016-07-23 09:15:30');
INSERT INTO `tp_one` VALUES (2, '李四', 28, 95, 89, '2016-07-23 09:15:50');
INSERT INTO `tp_one` VALUES (3, '王五', 95, 92, 95, '2016-07-23 09:16:02');
INSERT INTO `tp_one` VALUES (4, '马七', 84, 87, 94, '2016-07-23 09:16:16');
INSERT INTO `tp_one` VALUES (25, '赵八', 88, 88, 78, '2017-03-02 02:45:34');

-- ----------------------------
-- Table structure for tp_profile
-- ----------------------------
CREATE TABLE `tp_profile`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` mediumint(8) NOT NULL,
  `hobby` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `status` smallint(3) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 46 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tp_profile
-- ----------------------------
INSERT INTO `tp_profile` VALUES (1, 19, '喜欢大姐姐', 1);
INSERT INTO `tp_profile` VALUES (2, 20, '特爱吃肉', 0);
INSERT INTO `tp_profile` VALUES (3, 21, '朽木露琪亚', -1);
INSERT INTO `tp_profile` VALUES (4, 24, '暗恋小红', 2);
INSERT INTO `tp_profile` VALUES (5, 25, '毕迪丽', 1);
INSERT INTO `tp_profile` VALUES (6, 26, '特兰克斯', -1);
INSERT INTO `tp_profile` VALUES (7, 27, '琦玉爷爷', 1);
INSERT INTO `tp_profile` VALUES (8, 29, '有空就修行', 1);
INSERT INTO `tp_profile` VALUES (9, 79, '会长大人', 0);
INSERT INTO `tp_profile` VALUES (37, 19, '不喜欢吃青椒', 1);

-- ----------------------------
-- Table structure for tp_role
-- ----------------------------
CREATE TABLE `tp_role`  (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tp_role
-- ----------------------------
INSERT INTO `tp_role` VALUES (1, '超级管理员');
INSERT INTO `tp_role` VALUES (2, '评论审核专员');
INSERT INTO `tp_role` VALUES (3, '图片监察员');
INSERT INTO `tp_role` VALUES (4, '帐户处理专员');
INSERT INTO `tp_role` VALUES (5, '广告投放专员');

-- ----------------------------
-- Table structure for tp_two
-- ----------------------------
CREATE TABLE `tp_two`  (
  `uid` mediumint(8) UNSIGNED NOT NULL,
  `gender` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '男',
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tp_two
-- ----------------------------
INSERT INTO `tp_two` VALUES (1, '男');
INSERT INTO `tp_two` VALUES (2, '女');
INSERT INTO `tp_two` VALUES (3, '男');
INSERT INTO `tp_two` VALUES (4, '男');
INSERT INTO `tp_two` VALUES (25, '女');

