/*
Navicat MySQL Data Transfer

Source Server         : 杨豪
Source Server Version : 50719
Source Host           : localhost:3306
Source Database       : tces

Target Server Type    : MYSQL
Target Server Version : 50719
File Encoding         : 65001

Date: 2019-09-12 11:00:57
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for batch
-- ----------------------------
DROP TABLE IF EXISTS `batch`;
CREATE TABLE `batch` (
  `bid` int(11) NOT NULL AUTO_INCREMENT,
  `b_uid` varchar(255) NOT NULL,
  `open` varchar(255) NOT NULL,
  PRIMARY KEY (`bid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of batch
-- ----------------------------

-- ----------------------------
-- Table structure for function
-- ----------------------------
DROP TABLE IF EXISTS `function`;
CREATE TABLE `function` (
  `fid` varchar(255) NOT NULL,
  `fname` varchar(255) NOT NULL,
  `faddress` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`fid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of function
-- ----------------------------
INSERT INTO `function` VALUES ('1', '添加用户', null);
INSERT INTO `function` VALUES ('2', '班级管理', null);
INSERT INTO `function` VALUES ('3', '指标维护', null);
INSERT INTO `function` VALUES ('4', '教研室分配', null);

-- ----------------------------
-- Table structure for organization
-- ----------------------------
DROP TABLE IF EXISTS `organization`;
CREATE TABLE `organization` (
  `oid` varchar(255) NOT NULL,
  `oname` varchar(255) NOT NULL,
  `otype` varchar(255) NOT NULL,
  PRIMARY KEY (`oid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of organization
-- ----------------------------
INSERT INTO `organization` VALUES ('1', 'java8班', '1');
INSERT INTO `organization` VALUES ('2', 'java教研室', '2');
INSERT INTO `organization` VALUES ('3', 'java9班', '1');

-- ----------------------------
-- Table structure for question
-- ----------------------------
DROP TABLE IF EXISTS `question`;
CREATE TABLE `question` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `p_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `scroe` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `A` varchar(255) DEFAULT NULL,
  `B` varchar(255) DEFAULT NULL,
  `C` varchar(255) DEFAULT NULL,
  `D` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of question
-- ----------------------------

-- ----------------------------
-- Table structure for result
-- ----------------------------
DROP TABLE IF EXISTS `result`;
CREATE TABLE `result` (
  `rid` int(11) NOT NULL AUTO_INCREMENT,
  `b_uid` varchar(255) NOT NULL,
  `P_uid` varchar(255) NOT NULL,
  `scroe` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  PRIMARY KEY (`rid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of result
-- ----------------------------

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `rid` varchar(255) NOT NULL,
  `rname` varchar(255) NOT NULL,
  PRIMARY KEY (`rid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES ('0', '学生');
INSERT INTO `role` VALUES ('1', '教师');
INSERT INTO `role` VALUES ('2', '管理员');

-- ----------------------------
-- Table structure for role_function
-- ----------------------------
DROP TABLE IF EXISTS `role_function`;
CREATE TABLE `role_function` (
  `rid` varchar(255) NOT NULL,
  `fid` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of role_function
-- ----------------------------

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `uid` varchar(255) NOT NULL,
  `uname` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `utype` varchar(255) NOT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('10000', 'admin', '123456', '2');
INSERT INTO `user` VALUES ('10001', '黄炜', '123456', '1');
INSERT INTO `user` VALUES ('169001702', '杨豪', '123456', '0');
INSERT INTO `user` VALUES ('16901701', '杨学', '123456', '0');

-- ----------------------------
-- Table structure for user_orgnization
-- ----------------------------
DROP TABLE IF EXISTS `user_orgnization`;
CREATE TABLE `user_orgnization` (
  `oid` varchar(255) NOT NULL,
  `uid` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_orgnization
-- ----------------------------

-- ----------------------------
-- Table structure for user_role
-- ----------------------------
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
  `uid` varchar(255) NOT NULL,
  `rid` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_role
-- ----------------------------
INSERT INTO `user_role` VALUES ('10000', '2');
INSERT INTO `user_role` VALUES ('10001', '1');
INSERT INTO `user_role` VALUES ('169001701', '0');
INSERT INTO `user_role` VALUES ('169001702', '0');
INSERT INTO `user_role` VALUES ('169001703', '0');