/*
 Navicat Premium Data Transfer

 Source Server         : 陈
 Source Server Type    : MySQL
 Source Server Version : 80027
 Source Host           : localhost:3306
 Source Schema         : shop

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

 Date: 10/11/2022 12:16:03
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for chengji
-- ----------------------------
DROP TABLE IF EXISTS `chengji`;
CREATE TABLE `chengji`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `major` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `grade` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `sid` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `kemu` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `score` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of chengji
-- ----------------------------
INSERT INTO `chengji` VALUES (1, 'shu', '2020', '15', 'laosan', 'nan', 'shuxu', '100');
INSERT INTO `chengji` VALUES (2, 'sji1', '2019', '45', 'ajs1', 'nan', 'snia1', '60');
INSERT INTO `chengji` VALUES (3, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `chengji` VALUES (4, '1', '2', '2', '2', '2', '2', '2');
INSERT INTO `chengji` VALUES (8, '计算机', '2015', '5', '6', '女', '计算机网络', '50');
INSERT INTO `chengji` VALUES (9, '计算机', '2015', '5', '5', '男', 'IT英语', '5');
INSERT INTO `chengji` VALUES (10, '计算机', '2015', '到饭否嘀咕如果', '热热退热退热', '男', '计算机网络', '而如题如题');

-- ----------------------------
-- Table structure for classify
-- ----------------------------
DROP TABLE IF EXISTS `classify`;
CREATE TABLE `classify`  (
  `id` int(0) NOT NULL,
  `name` char(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL
) ENGINE = InnoDB CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of classify
-- ----------------------------
INSERT INTO `classify` VALUES (1, '兰蔻');
INSERT INTO `classify` VALUES (2, '娇兰');
INSERT INTO `classify` VALUES (3, '雅诗兰黛');

-- ----------------------------
-- Table structure for content
-- ----------------------------
DROP TABLE IF EXISTS `content`;
CREATE TABLE `content`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `number` int(0) NOT NULL,
  `title` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `techers` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `address` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `time` datetime(0) NOT NULL,
  `quantity` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of content
-- ----------------------------
INSERT INTO `content` VALUES (1, 111111, '数学', '傅海峰', '理工楼', '2022-05-18 19:00:58', '30');
INSERT INTO `content` VALUES (2, 22222, '文学', '胡同', '社科楼', '2022-05-20 19:01:30', '100');
INSERT INTO `content` VALUES (3, 33333, '软工', '花亭湖', '体育楼', '2022-05-19 19:02:28', '50');
INSERT INTO `content` VALUES (4, 1, '1', '1', '1', '2022-05-20 00:00:00', '1');

-- ----------------------------
-- Table structure for cosmeticform
-- ----------------------------
DROP TABLE IF EXISTS `cosmeticform`;
CREATE TABLE `cosmeticform`  (
  `cosmetic_nember` char(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `cosmetic_name` char(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `cosmetic_made` char(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `cosmetic_price` float NOT NULL,
  `cosmetic_mess` char(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `cosmetic_pic` char(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `id` int(0) NOT NULL
) ENGINE = InnoDB CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of cosmeticform
-- ----------------------------
INSERT INTO `cosmeticform` VALUES ('lan_a1001', '兰蔻清莹柔肤水', '法国lancom', 229, '含量：400g', 'lan1.jpg', 1);
INSERT INTO `cosmeticform` VALUES ('lan_10002', '兰蔻乳液', '法国lancom', 588, '补水', 'lan2.jpg', 1);
INSERT INTO `cosmeticform` VALUES ('EsteeLauder1001', '雅诗兰黛眼霜', 'EsteeLauder', 389, '去黑眼圈', 'est1.jpg', 3);

-- ----------------------------
-- Table structure for course1
-- ----------------------------
DROP TABLE IF EXISTS `course1`;
CREATE TABLE `course1`  (
  `cno` int(0) NOT NULL AUTO_INCREMENT,
  `cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ccredit` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `cpno` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`cno`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of course1
-- ----------------------------
INSERT INTO `course1` VALUES (12, '数学', '5466556', '255');
INSERT INTO `course1` VALUES (13, '语文', '3344', '5656');
INSERT INTO `course1` VALUES (18, '英语', '555', '8598');
INSERT INTO `course1` VALUES (21, '55', '66', '55');
INSERT INTO `course1` VALUES (23, '4', '4', '4');
INSERT INTO `course1` VALUES (24, '5', '5', '5');
INSERT INTO `course1` VALUES (25, '45435', '4553', '45435');
INSERT INTO `course1` VALUES (26, '6', '6', '6');

-- ----------------------------
-- Table structure for coursesinfo
-- ----------------------------
DROP TABLE IF EXISTS `coursesinfo`;
CREATE TABLE `coursesinfo`  (
  `id` int(0) NOT NULL,
  `date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `monday` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `tuesday` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `wednesday` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `thursday` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `friday` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `saturday` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `sunday` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`date`, `id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of coursesinfo
-- ----------------------------
INSERT INTO `coursesinfo` VALUES (1316, '第一节', '语文', '英语', '数学', '物理', '体育', '语文', '无');
INSERT INTO `coursesinfo` VALUES (1316, '第七节', '音乐', '生物', '语文', '化学', '政治', '无', '地理');
INSERT INTO `coursesinfo` VALUES (1316, '第三节', '地理', '地理', '政治', '计算机', '英语', '生物', '无');
INSERT INTO `coursesinfo` VALUES (1316, '第九节', '生物', '数学', '化学', '政治', '音乐', '无', '英语');
INSERT INTO `coursesinfo` VALUES (1316, '第二节', '政治', '计算机', '生物', '语文', '美术', '英语', '无');
INSERT INTO `coursesinfo` VALUES (1316, '第五节', '英语', '数学', '历史', '地理', '化学', '无', '无');
INSERT INTO `coursesinfo` VALUES (1316, '第八节', '历史', '化学', '物理', '物理', '语文', '无', '政治');
INSERT INTO `coursesinfo` VALUES (1316, '第六节', '美术', '物理', '语文', '生物', '历史', '无', '无');
INSERT INTO `coursesinfo` VALUES (1316, '第十节', '化学', '英语', '地理', '英语', '物理', '无', '历史');
INSERT INTO `coursesinfo` VALUES (1316, '第四节', '数学', '政治', '建模', '数学', '数学', '化学', '无');

-- ----------------------------
-- Table structure for electiveinfo
-- ----------------------------
DROP TABLE IF EXISTS `electiveinfo`;
CREATE TABLE `electiveinfo`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `computer` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '计算机',
  `photography` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '摄影',
  `psychology` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '心理学',
  `modeling` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '建模',
  `cooking` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '烹饪',
  `dancing` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '跳舞',
  `skating` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '滑雪',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1319 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of electiveinfo
-- ----------------------------
INSERT INTO `electiveinfo` VALUES (1316, '已选', '未选', '未选', '已选', '未选', '未选', '未选');
INSERT INTO `electiveinfo` VALUES (1317, '1', '1', '2244', '1', '1', '1', '1');
INSERT INTO `electiveinfo` VALUES (1318, 'gfggfg', 'ererere', '2244', '1', 'ererere', 'rererer', 'rerer');

-- ----------------------------
-- Table structure for emp
-- ----------------------------
DROP TABLE IF EXISTS `emp`;
CREATE TABLE `emp`  (
  `Id` int(0) NOT NULL AUTO_INCREMENT,
  `empName` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `password` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `gender` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `age` int(0) NOT NULL,
  PRIMARY KEY (`Id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of emp
-- ----------------------------
INSERT INTO `emp` VALUES (1, '陈应敏', '222', '男', 12);
INSERT INTO `emp` VALUES (2, '21', '23', '女', 12);
INSERT INTO `emp` VALUES (3, '111', '2222', '女', 444);

-- ----------------------------
-- Table structure for food
-- ----------------------------
DROP TABLE IF EXISTS `food`;
CREATE TABLE `food`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `city` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `price` decimal(10, 2) NOT NULL,
  `popular` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `note` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of food
-- ----------------------------
INSERT INTO `food` VALUES (1, '牛肉拉面', '兰州', 8.00, '良好', '111');
INSERT INTO `food` VALUES (2, '铁锅炖大鹅', '哈尔滨', 20.00, '较好', '222');
INSERT INTO `food` VALUES (3, '米饭', '全国各地', 10.00, '好', '344');
INSERT INTO `food` VALUES (4, '浆水面', '天水', 7.00, '一般', '1122');
INSERT INTO `food` VALUES (5, '花牛苹果', '天水', 1.50, '好', '33');
INSERT INTO `food` VALUES (6, '红富士', '山东', 1.40, '好', '呃呃呃');
INSERT INTO `food` VALUES (7, '米线', '云南', 15.00, '良好', '啊啊啊');
INSERT INTO `food` VALUES (8, '烩面', '临洮', 12.00, '好', '1121212');
INSERT INTO `food` VALUES (9, '炒面', '西安', 14.00, '较好', '惺惺惜惺惺');
INSERT INTO `food` VALUES (10, '炒面', '西安', 11.00, '1额外', 'zhenbucuo a ');

-- ----------------------------
-- Table structure for manager
-- ----------------------------
DROP TABLE IF EXISTS `manager`;
CREATE TABLE `manager`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `userName` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `name` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `password` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `phone` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `address` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of manager
-- ----------------------------
INSERT INTO `manager` VALUES (1, 'admin', '普通用户', '123', '121333', '山西');
INSERT INTO `manager` VALUES (2, 'root', '超级用户', 'root', '1334', '上海');
INSERT INTO `manager` VALUES (3, '1', '1', '1', '2', '1');
INSERT INTO `manager` VALUES (4, 'fdfguyyu', '二二二', 'qqqqqq', '123456667', '福冈软体');
INSERT INTO `manager` VALUES (5, '12', '12', '12', '12', NULL);
INSERT INTO `manager` VALUES (6, '12', '12', '12', '121313131', '1213331');
INSERT INTO `manager` VALUES (7, '3232', '房贷的发放', 're', '332323', '32567');
INSERT INTO `manager` VALUES (8, 'chenyingmin', '2', '123', '133434', NULL);

-- ----------------------------
-- Table structure for markinfo
-- ----------------------------
DROP TABLE IF EXISTS `markinfo`;
CREATE TABLE `markinfo`  (
  `id` int(0) NOT NULL,
  `time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `chinese` int(0) NULL DEFAULT NULL,
  `math` int(0) NULL DEFAULT NULL,
  `english` int(0) NULL DEFAULT NULL,
  `physics` int(0) NULL DEFAULT NULL,
  `geography` int(0) NULL DEFAULT NULL,
  `chemistry` int(0) NULL DEFAULT NULL,
  `history` int(0) NULL DEFAULT NULL,
  `biology` int(0) NULL DEFAULT NULL,
  `politics` int(0) NULL DEFAULT NULL,
  `art` int(0) NULL DEFAULT NULL,
  `music` int(0) NULL DEFAULT NULL,
  `sports` int(0) NULL DEFAULT NULL,
  `computer` int(0) NULL DEFAULT NULL,
  `modeling` int(0) NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of markinfo
-- ----------------------------
INSERT INTO `markinfo` VALUES (1316, '20年上期中', 88, 78, 88, 55, 65, 69, 53, 99, 79, 96, 66, 88, 78, 85);
INSERT INTO `markinfo` VALUES (1316, '20年上期末', 98, 85, 77, 65, 69, 88, 77, 86, 64, 59, 77, 66, 95, 68);
INSERT INTO `markinfo` VALUES (1316, '20年下期中', 99, 85, 66, 94, 88, 84, 55, 98, 48, 65, 88, 76, 96, 88);
INSERT INTO `markinfo` VALUES (1316, '20年下期末', 65, 98, 88, 65, 98, 85, 68, 99, 77, 66, 65, 69, 69, 95);
INSERT INTO `markinfo` VALUES (1316, '21年上期中', 95, 58, 69, 86, 68, 74, 71, 61, 63, 93, 82, 81, 79, 90);
INSERT INTO `markinfo` VALUES (1316, '21年上期末', 78, 67, 88, 68, 89, 74, 90, 85, 79, 92, 82, 86, 70, 69);
INSERT INTO `markinfo` VALUES (1316, '21年下期中', 67, 88, 75, 90, 92, 86, 75, 79, 68, 89, 90, 83, 88, 93);
INSERT INTO `markinfo` VALUES (1316, '21年下期末', 78, 90, 84, 72, 83, 92, 79, 90, 82, 86, 79, 81, 83, 94);
INSERT INTO `markinfo` VALUES (1316, '22年上期中', 78, 85, 92, 69, 91, 76, 84, 93, 76, 69, 80, 83, 95, 90);
INSERT INTO `markinfo` VALUES (1316, '22年上期末', 84, 89, 75, 69, 66, 78, 90, 82, 89, 83, 79, 90, 80, 82);

-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `number` int(0) NOT NULL,
  `title` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `user` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `time` datetime(0) NOT NULL,
  `note` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of news
-- ----------------------------
INSERT INTO `news` VALUES (1, 1111, '考试', '教务处', '2022-06-05 13:54:42', '操作系统期末');
INSERT INTO `news` VALUES (2, 2222, '放假', '教务处', '2022-06-15 11:55:48', '全校');
INSERT INTO `news` VALUES (3, 1, '1', '1', '2022-04-12 00:00:00', '1');
INSERT INTO `news` VALUES (4, 1, '1', '2', '2022-04-12 00:00:00', '1');

-- ----------------------------
-- Table structure for notice
-- ----------------------------
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice`  (
  `noticeid` int(0) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `role` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `time` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`noticeid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of notice
-- ----------------------------
INSERT INTO `notice` VALUES (1, '目标', '1号', '2020', '作业');
INSERT INTO `notice` VALUES (3, '新闻', '2号', '2022', '作业');
INSERT INTO `notice` VALUES (4, '英语', '3号', '2021', '作业');
INSERT INTO `notice` VALUES (10, '44', '', '', '');
INSERT INTO `notice` VALUES (11, '44', '55', '66', '88');
INSERT INTO `notice` VALUES (12, '11', '11', '11', '11');
INSERT INTO `notice` VALUES (13, '1', '32', '323', '2323');
INSERT INTO `notice` VALUES (14, '2', '2', '2', '2');
INSERT INTO `notice` VALUES (16, 'wererer', 'ererewr', 'erer', 'rererewr');

-- ----------------------------
-- Table structure for orderform
-- ----------------------------
DROP TABLE IF EXISTS `orderform`;
CREATE TABLE `orderform`  (
  `id` int(0) NOT NULL,
  `logname` char(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `mess` char(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `sum` float NOT NULL
) ENGINE = InnoDB CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of orderform
-- ----------------------------
INSERT INTO `orderform` VALUES (0, '1', '1:(lan_a1001,兰蔻清莹柔肤水,法国lancom,229.0)', 229);

-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `number` int(0) NOT NULL,
  `userName` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `password` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `phone` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `address` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `sClass` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `education` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES (1, 2020045, 'chenyingmin', '123', '1332323', '临洮', '软工2班', '本科');
INSERT INTO `student` VALUES (2, 2015777, '傅海峰', '1212', '345666', '山西', '计科1班', '研究生');
INSERT INTO `student` VALUES (3, 3, '1', '123456', '3', '2', '2', '2');
INSERT INTO `student` VALUES (7, 2, 'admin', '123', '133434', '2', '2', '2');

-- ----------------------------
-- Table structure for student1
-- ----------------------------
DROP TABLE IF EXISTS `student1`;
CREATE TABLE `student1`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `sname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `ssex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `sage` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `sdept` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of student1
-- ----------------------------
INSERT INTO `student1` VALUES (1, '杨平', '男', '2113332', '数学与应用数学');
INSERT INTO `student1` VALUES (2, '项羽', '男', '22', '软件工程');
INSERT INTO `student1` VALUES (9, '55', '55', '55', '55');
INSERT INTO `student1` VALUES (11, '444', '44', '44', '44');
INSERT INTO `student1` VALUES (12, 'rrt', 'trtr', '2113332', 'rtrt');
INSERT INTO `student1` VALUES (13, 'rrt', 'trtr', '2113332', 'rtrt');
INSERT INTO `student1` VALUES (14, 'rrt', 'trtr', '', 'rtrt');

-- ----------------------------
-- Table structure for stuinfo
-- ----------------------------
DROP TABLE IF EXISTS `stuinfo`;
CREATE TABLE `stuinfo`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `stuName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `gender` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `age` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `grade` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `headTeacher` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `dormitory` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of stuinfo
-- ----------------------------
INSERT INTO `stuinfo` VALUES (1, '1', '1', '1', '1', '1', '1', '1', '1', '1');
INSERT INTO `stuinfo` VALUES (2, '2', '123', '1', '1', '1', '133434', NULL, '1', NULL);
INSERT INTO `stuinfo` VALUES (3, '3', '2', 'ewew', 'eeew', '1', '133434', NULL, 'wewew', NULL);

-- ----------------------------
-- Table structure for t_menu
-- ----------------------------
DROP TABLE IF EXISTS `t_menu`;
CREATE TABLE `t_menu`  (
  `menu_id` int(0) NOT NULL AUTO_INCREMENT,
  `menu_name` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `menu_url` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `menu__state` int(0) NULL DEFAULT NULL,
  `menu_note` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `memu_parent_id` int(0) NULL DEFAULT NULL,
  PRIMARY KEY (`menu_id`) USING BTREE,
  INDEX `memu_parent_id`(`memu_parent_id`) USING BTREE,
  CONSTRAINT `t_menu_ibfk_1` FOREIGN KEY (`memu_parent_id`) REFERENCES `t_menu` (`menu_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_menu
-- ----------------------------
INSERT INTO `t_menu` VALUES (0, '后台管理', NULL, 1, NULL, NULL);
INSERT INTO `t_menu` VALUES (1, '系统管理', NULL, 1, NULL, 0);
INSERT INTO `t_menu` VALUES (2, '课程管理', NULL, 1, NULL, 0);
INSERT INTO `t_menu` VALUES (3, '权限管理', NULL, 1, NULL, 0);
INSERT INTO `t_menu` VALUES (4, '个人信息管理', NULL, 1, NULL, 0);
INSERT INTO `t_menu` VALUES (5, '新闻管理', 'xin.html', 1, NULL, 1);
INSERT INTO `t_menu` VALUES (6, '公告管理', 'gong.html', 1, NULL, 1);
INSERT INTO `t_menu` VALUES (7, '人员管理', 'ren.html', 1, NULL, 2);

-- ----------------------------
-- Table structure for t_role
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role`  (
  `role_id` int(0) NOT NULL AUTO_INCREMENT,
  `role_name` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `role_state` int(0) NOT NULL,
  `role_note` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_role
-- ----------------------------
INSERT INTO `t_role` VALUES (1, '超级管理员', 1, '无');
INSERT INTO `t_role` VALUES (2, '学生', 1, '二u');
INSERT INTO `t_role` VALUES (3, '教师', 1, '1');
INSERT INTO `t_role` VALUES (4, '通知管理员', 1, '1');
INSERT INTO `t_role` VALUES (5, '课程管理员', 1, '1');

-- ----------------------------
-- Table structure for t_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `t_role_menu`;
CREATE TABLE `t_role_menu`  (
  `role_id` int(0) NOT NULL,
  `menu_id` int(0) NOT NULL,
  PRIMARY KEY (`role_id`, `menu_id`) USING BTREE,
  INDEX `menu_id`(`menu_id`) USING BTREE,
  CONSTRAINT `t_role_menu_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `t_role` (`role_id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `t_role_menu_ibfk_2` FOREIGN KEY (`menu_id`) REFERENCES `t_menu` (`menu_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_role_menu
-- ----------------------------
INSERT INTO `t_role_menu` VALUES (1, 0);
INSERT INTO `t_role_menu` VALUES (1, 1);
INSERT INTO `t_role_menu` VALUES (1, 2);
INSERT INTO `t_role_menu` VALUES (1, 3);
INSERT INTO `t_role_menu` VALUES (1, 4);
INSERT INTO `t_role_menu` VALUES (1, 5);
INSERT INTO `t_role_menu` VALUES (1, 6);
INSERT INTO `t_role_menu` VALUES (1, 7);

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user`  (
  `user_id` int(0) NOT NULL AUTO_INCREMENT,
  `user_loginname` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `user_password` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `user_name` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `user_state` int(0) NOT NULL,
  `user_roleid` int(0) NOT NULL,
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE INDEX `user_loginname`(`user_loginname`) USING BTREE,
  INDEX `user_roleid`(`user_roleid`) USING BTREE,
  CONSTRAINT `t_user_ibfk_1` FOREIGN KEY (`user_roleid`) REFERENCES `t_role` (`role_id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES (1, 'admin', '123', 'admin', 1, 1);
INSERT INTO `t_user` VALUES (2, '11', '11', '11', 1, 2);

-- ----------------------------
-- Table structure for teacher1
-- ----------------------------
DROP TABLE IF EXISTS `teacher1`;
CREATE TABLE `teacher1`  (
  `number1` int(0) NOT NULL AUTO_INCREMENT,
  `tname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `tage` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `tdept` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `tsex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`number1`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of teacher1
-- ----------------------------
INSERT INTO `teacher1` VALUES (1, '杨老师', '50', '60', '男');
INSERT INTO `teacher1` VALUES (3, '武老师', '35', '24', '男');
INSERT INTO `teacher1` VALUES (4, '易老师', '45', '54', '男');
INSERT INTO `teacher1` VALUES (5, '李老师', '60', '25', 'nv');
INSERT INTO `teacher1` VALUES (6, '张老师', '45', '23', '女');

-- ----------------------------
-- Table structure for techer
-- ----------------------------
DROP TABLE IF EXISTS `techer`;
CREATE TABLE `techer`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `userName` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `name` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `password` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `phone` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `address` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `course` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of techer
-- ----------------------------
INSERT INTO `techer` VALUES (1, '101010', '111', '123', '1332', '广西', '数学');
INSERT INTO `techer` VALUES (2, '1111', '111', '111', '111111', '山西', '文学');
INSERT INTO `techer` VALUES (3, '22222', '111', '222', '222222', '上海', '计科');
INSERT INTO `techer` VALUES (4, '1', '1', '1', '1', '1', '1');
INSERT INTO `techer` VALUES (5, '5', '5', '5', '5', '5', '5');
INSERT INTO `techer` VALUES (6, '11', '3', '123456', '3', '3', '3');

-- ----------------------------
-- Table structure for tuser
-- ----------------------------
DROP TABLE IF EXISTS `tuser`;
CREATE TABLE `tuser`  (
  `tid` int(0) NOT NULL AUTO_INCREMENT,
  `tuserName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `tpassword` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `tnote` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`tid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of tuser
-- ----------------------------
INSERT INTO `tuser` VALUES (2, 'root', '456', '普通');
INSERT INTO `tuser` VALUES (3, 'wuu', '555', '中等管理员     ');
INSERT INTO `tuser` VALUES (10, 'admin', '12', '12');
INSERT INTO `tuser` VALUES (11, 'admin1', '12', '123');
INSERT INTO `tuser` VALUES (13, '111', '55', '66');
INSERT INTO `tuser` VALUES (15, 'user', '123', '41');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `logname` char(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `password` char(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `phone` char(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `address` char(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `realname` char(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  PRIMARY KEY (`logname`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', '1', '1', '1', '1');
INSERT INTO `user` VALUES ('2', '2', '2', '2', '2');

-- ----------------------------
-- Table structure for userinfo
-- ----------------------------
DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo`  (
  `id` int(0) NOT NULL AUTO_INCREMENT,
  `userName` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `password` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  `note` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of userinfo
-- ----------------------------
INSERT INTO `userinfo` VALUES (1, 'root', '123', '121');
INSERT INTO `userinfo` VALUES (2, 'admin', '123', '普通管理员');
INSERT INTO `userinfo` VALUES (3, 'root', 'root', '超级管理员');
INSERT INTO `userinfo` VALUES (5, 'aaaa', 'aaab', 'aaaaa');
INSERT INTO `userinfo` VALUES (6, 'admin', 'root', '122');

-- ----------------------------
-- Table structure for vteacher
-- ----------------------------
DROP TABLE IF EXISTS `vteacher`;
CREATE TABLE `vteacher`  (
  `tid` int(0) NOT NULL AUTO_INCREMENT,
  `tname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cld` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `vaue` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`tid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of vteacher
-- ----------------------------
INSERT INTO `vteacher` VALUES (20, '样加', '55', '英语', '45');
INSERT INTO `vteacher` VALUES (23, '物加', '40', '物理', '45');
INSERT INTO `vteacher` VALUES (24, '杨无', '45', '语文', NULL);

SET FOREIGN_KEY_CHECKS = 1;