/*
Navicat MySQL Data Transfer

Source Server         : 本地
Source Server Version : 50711
Source Host           : 127.0.0.1:3306
Source Database       : score

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

Date: 2019-03-13 13:13:54
*/


-- ----------------------------
-- Table structure for bp_bclass
-- ----------------------------
CREATE TABLE `bp_bclass` (
  `cl_id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `cp_id` mediumint(8) NOT NULL COMMENT '所属校区',
  `gd_id` mediumint(8) NOT NULL COMMENT '年级',
  `cs_id` smallint(5) NOT NULL COMMENT '教室',
  `cl_name` varchar(20) NOT NULL COMMENT '班级名称',
  `cl_bid` int(10) NOT NULL COMMENT '班主任id',
  `cl_bname` varchar(10) NOT NULL COMMENT '班主任姓名',
  `cl_info` varchar(255) NOT NULL COMMENT '班级描述',
  `type` tinyint(3) NOT NULL DEFAULT '0' COMMENT '班级类型 1行政班 2教学班 3小走班',
  `course` varchar(60) NOT NULL DEFAULT '0' COMMENT '教学，小走班课程id',
  `kh` varchar(255) NOT NULL COMMENT '口号',
  `show_teacher_id` mediumint(6) NOT NULL COMMENT '首页显示',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime NOT NULL COMMENT '更新时间',
  `unit_id` mediumint(8) NOT NULL,
  `word` text NOT NULL COMMENT '班主任寄语',
  PRIMARY KEY (`cl_id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 COMMENT='班级设置';

-- ----------------------------
-- Records of bp_bclass
-- ----------------------------
INSERT INTO `bp_bclass` VALUES ('1', '1', '11', '26', '1班', '18847', '吴启新', '这是班训', '1', '0', '携手彩虹桥，一起共成长！', '18852', '0000-00-00 00:00:00', '2018-12-05 10:14:33', '0', '班主任寄语');
INSERT INTO `bp_bclass` VALUES ('2', '1', '11', '27', '2班', '0', '舒其兵', '', '1', '0', '', '0', '0000-00-00 00:00:00', '2018-12-05 10:14:45', '0', '测试');
INSERT INTO `bp_bclass` VALUES ('3', '1', '12', '28', '1班', '81', '魏灵丹', '', '1', '0', '', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '');
INSERT INTO `bp_bclass` VALUES ('4', '1', '12', '29', '2班', '73', '骆伟', '', '1', '0', '', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '');
INSERT INTO `bp_bclass` VALUES ('5', '1', '10', '30', '1班', '107', '金娜', '', '1', '0', '', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '');
INSERT INTO `bp_bclass` VALUES ('6', '1', '10', '35', '2班', '77', '宋红辉', '', '1', '0', '', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '');
INSERT INTO `bp_bclass` VALUES ('50', '0', '12', '0', '政治,历史,地理(2)班', '72', '程碧华', '', '3', '4,5,6', '', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '');
INSERT INTO `bp_bclass` VALUES ('51', '0', '12', '0', '政治,历史,地理(1)班', '69', '尧新良', '', '3', '4,5,6', '', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '');
INSERT INTO `bp_bclass` VALUES ('52', '1', '10', '32', '冲刺班', '16', '吴启新', '备注12', '0', '0', '', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0', '');

-- ----------------------------
-- Table structure for bp_campus
-- ----------------------------
CREATE TABLE `bp_campus` (
  `cp_id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `cp_name` varchar(20) NOT NULL COMMENT '名称',
  `cp_postcode` mediumint(6) NOT NULL COMMENT '邮政编码',
  `cp_resp` varchar(4) NOT NULL COMMENT '负责人',
  `cp_tel` varchar(14) NOT NULL COMMENT '联系电话',
  `cp_restel` varchar(14) NOT NULL COMMENT '负责人电话',
  `cp_email` varchar(50) NOT NULL COMMENT '邮箱',
  `cp_administrativecode` varchar(12) NOT NULL COMMENT '所在地行政区号码',
  `cp_addr` varchar(30) NOT NULL COMMENT '地址',
  PRIMARY KEY (`cp_id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='分校区信息';

-- ----------------------------
-- Records of bp_campus
-- ----------------------------
INSERT INTO `bp_campus` VALUES ('1', '主校区', '230064', '钟俊', '18055693921', '18055693921', 'tianming@126.com', '340000', '安徽合肥');

-- ----------------------------
-- Table structure for bp_class_staus
-- ----------------------------
CREATE TABLE `bp_class_staus` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '成绩管理专用表(成绩录入状态)',
  `end_time` int(11) DEFAULT NULL COMMENT '考试结束时间',
  `staus` tinyint(1) DEFAULT NULL COMMENT '考试状态(0正在录入，1已录入，已录入)',
  `exam_id` int(11) DEFAULT NULL COMMENT '考试ID',
  `sj_id` int(11) DEFAULT NULL COMMENT '科目id',
  `cl_id` int(11) DEFAULT NULL COMMENT '班级ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bp_class_staus
-- ----------------------------
INSERT INTO `bp_class_staus` VALUES ('1', '1547714233', '2', '1', '1', '1');
INSERT INTO `bp_class_staus` VALUES ('2', '1547714812', '2', '1', '2', '1');
INSERT INTO `bp_class_staus` VALUES ('3', null, '1', '1', '3', '1');
INSERT INTO `bp_class_staus` VALUES ('4', null, '1', '1', '4', '1');
INSERT INTO `bp_class_staus` VALUES ('8', '1547715004', '2', '1', '1', '2');
INSERT INTO `bp_class_staus` VALUES ('9', null, '1', '1', '1', '50');
INSERT INTO `bp_class_staus` VALUES ('10', null, '1', '1', '1', '51');
INSERT INTO `bp_class_staus` VALUES ('11', '1547715139', '2', '1', '2', '2');
INSERT INTO `bp_class_staus` VALUES ('12', null, '1', '1', '2', '50');
INSERT INTO `bp_class_staus` VALUES ('15', '1547791560', '2', '4', '3', '1');
INSERT INTO `bp_class_staus` VALUES ('16', null, '1', '4', '3', '2');
INSERT INTO `bp_class_staus` VALUES ('17', '1547793362', '2', '5', '1', '1');
INSERT INTO `bp_class_staus` VALUES ('18', '1547793669', '2', '5', '1', '2');
INSERT INTO `bp_class_staus` VALUES ('19', '1547793397', '2', '5', '2', '1');
INSERT INTO `bp_class_staus` VALUES ('20', '1547794031', '2', '5', '2', '2');
INSERT INTO `bp_class_staus` VALUES ('21', '1547794090', '2', '6', '3', '1');
INSERT INTO `bp_class_staus` VALUES ('22', '1547794121', '2', '6', '3', '2');
INSERT INTO `bp_class_staus` VALUES ('23', null, '1', '1', '3', '2');

-- ----------------------------
-- Table structure for bp_exam
-- ----------------------------
CREATE TABLE `bp_exam` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '成绩管理专用表(考试管理表)',
  `sy_id` int(10) NOT NULL COMMENT '学年',
  `se_id` int(10) NOT NULL COMMENT '学期',
  `name` varchar(50) DEFAULT NULL COMMENT '考试名称',
  `type` tinyint(1) DEFAULT NULL COMMENT '(1为统考，2为单科考)',
  `start_time` int(11) DEFAULT NULL COMMENT '考试开始时间',
  `end_time` int(11) DEFAULT NULL COMMENT '考试结束时间',
  `inputstart_time` int(11) DEFAULT NULL COMMENT '录入开始时间',
  `inputend_time` int(11) DEFAULT NULL COMMENT '录入结束时间',
  `gd_id` varchar(50) DEFAULT NULL COMMENT '年级ID',
  `cl_id` varchar(50) DEFAULT NULL COMMENT '班级ID',
  `sj_id` varchar(50) DEFAULT NULL COMMENT '科目id',
  `ad_uid` int(11) DEFAULT NULL COMMENT '添加人员ID',
  `staus` int(1) DEFAULT NULL COMMENT '0未发布，1已发布，2已完成，3取消',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bp_exam
-- ----------------------------
INSERT INTO `bp_exam` VALUES ('1', '6', '4', '统考一', '1', '1528473600', '1546272000', '1546876800', '1548259200', '11', '1,2', '1,2,3', '1', '1');
INSERT INTO `bp_exam` VALUES ('4', '6', '4', '单科考一', '2', '1528473600', '1546272000', '1546876800', '1547568000', '11', '1,2', '3', '1', '1');
INSERT INTO `bp_exam` VALUES ('5', '6', '4', '统考二', '1', '1547568000', '1547654400', '1547654400', '1547827200', '11', '1,2', '1,2', '1', '1');
INSERT INTO `bp_exam` VALUES ('6', '6', '4', '单科考二', '2', '1547481600', '1547654400', '1547654400', '1547827200', '11', '1,2', '3', '1', '1');
INSERT INTO `bp_exam` VALUES ('7', '6', '4', '统考3', '1', '1528473600', '1547568000', '1548345600', '1548864000', '10', '5,6,52', '1,2,3', null, '0');

-- ----------------------------
-- Table structure for bp_grade
-- ----------------------------
CREATE TABLE `bp_grade` (
  `gd_id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `gd_entrance` char(4) NOT NULL COMMENT '入学年份',
  `gd_name` varchar(20) NOT NULL COMMENT '名称',
  `gd_status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '年级状态(1:未毕业;2:已毕业)',
  PRIMARY KEY (`gd_id`),
  UNIQUE KEY `gd_entrance` (`gd_entrance`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='年级设置';

-- ----------------------------
-- Records of bp_grade
-- ----------------------------
INSERT INTO `bp_grade` VALUES ('10', '2016', '九年级', '1');
INSERT INTO `bp_grade` VALUES ('11', '2018', '七年级', '1');
INSERT INTO `bp_grade` VALUES ('12', '2017', '八年级', '1');

-- ----------------------------
-- Table structure for bp_score
-- ----------------------------
CREATE TABLE `bp_score` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '成绩管理专用表(具体成绩表)',
  `score` int(10) DEFAULT NULL COMMENT '分数',
  `ad_uid` int(11) DEFAULT NULL COMMENT '用户id',
  `exam_id` int(11) DEFAULT NULL COMMENT '考试ID',
  `sj_id` int(11) DEFAULT NULL COMMENT '科目id',
  `cl_id` int(11) DEFAULT NULL COMMENT '班级ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=597 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of bp_score
-- ----------------------------
INSERT INTO `bp_score` VALUES ('86', '99', '18683', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('87', '100', '18685', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('88', '101', '18687', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('89', '102', '18689', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('90', '103', '18691', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('91', '104', '18693', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('92', '105', '18695', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('93', '106', '18697', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('94', '107', '18699', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('95', '108', '18701', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('96', '109', '18703', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('97', '110', '18705', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('98', '111', '18707', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('99', '112', '18709', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('100', '113', '18711', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('101', '114', '18713', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('102', '115', '18715', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('103', '116', '18717', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('104', '117', '18719', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('105', '118', '18721', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('106', '119', '18723', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('107', '120', '18725', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('108', '121', '18727', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('109', '122', '18729', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('110', '123', '18731', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('111', '124', '18733', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('112', '125', '18735', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('113', '126', '18737', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('114', '127', '18739', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('115', '128', '18741', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('116', '129', '18743', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('117', '130', '18745', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('118', '131', '18747', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('119', '132', '18749', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('120', '133', '18751', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('121', '134', '18753', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('122', '135', '18755', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('123', '136', '18757', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('124', '137', '18759', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('125', '138', '18839', '1', '2', '1');
INSERT INTO `bp_score` VALUES ('127', '50', '18761', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('128', '51', '18763', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('129', '52', '18765', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('130', '53', '18767', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('131', '54', '18769', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('132', '55', '18771', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('133', '56', '18773', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('134', '57', '18775', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('135', '58', '18777', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('136', '59', '18779', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('137', '60', '18781', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('138', '61', '18783', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('139', '62', '18785', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('140', '63', '18787', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('141', '64', '18789', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('142', '65', '18791', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('143', '66', '18793', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('144', '67', '18795', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('145', '68', '18797', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('146', '69', '18799', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('147', '70', '18801', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('148', '71', '18803', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('149', '72', '18805', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('150', '73', '18807', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('151', '74', '18809', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('152', '75', '18811', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('153', '76', '18813', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('154', '77', '18815', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('155', '78', '18817', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('156', '79', '18819', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('157', '80', '18821', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('158', '81', '18823', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('159', '82', '18825', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('160', '83', '18827', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('161', '84', '18829', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('162', '85', '18831', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('163', '86', '18833', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('164', '87', '18835', '1', '1', '2');
INSERT INTO `bp_score` VALUES ('165', '50', '18761', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('166', '51', '18763', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('167', '52', '18765', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('168', '53', '18767', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('169', '54', '18769', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('170', '55', '18771', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('171', '56', '18773', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('172', '57', '18775', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('173', '58', '18777', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('174', '59', '18779', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('175', '60', '18781', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('176', '61', '18783', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('177', '62', '18785', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('178', '63', '18787', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('179', '64', '18789', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('180', '65', '18791', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('181', '66', '18793', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('182', '67', '18795', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('183', '68', '18797', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('184', '69', '18799', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('185', '70', '18801', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('186', '71', '18803', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('187', '72', '18805', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('188', '73', '18807', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('189', '74', '18809', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('190', '75', '18811', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('191', '76', '18813', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('192', '77', '18815', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('193', '78', '18817', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('194', '79', '18819', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('195', '80', '18821', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('196', '81', '18823', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('197', '82', '18825', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('198', '83', '18827', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('199', '84', '18829', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('200', '85', '18831', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('201', '86', '18833', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('202', '87', '18835', '1', '2', '2');
INSERT INTO `bp_score` VALUES ('204', '60', '18683', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('205', '61', '18685', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('206', '62', '18687', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('207', '63', '18689', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('208', '64', '18691', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('209', '65', '18693', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('210', '66', '18695', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('211', '67', '18697', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('212', '68', '18699', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('213', '69', '18701', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('214', '70', '18703', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('215', '71', '18705', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('216', '72', '18707', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('217', '73', '18709', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('218', '74', '18711', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('219', '75', '18713', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('220', '76', '18715', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('221', '77', '18717', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('222', '78', '18719', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('223', '79', '18721', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('224', '80', '18723', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('225', '81', '18725', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('226', '82', '18727', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('227', '83', '18729', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('228', '84', '18731', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('229', '85', '18733', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('230', '86', '18735', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('231', '87', '18737', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('232', '88', '18739', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('233', '89', '18741', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('234', '90', '18743', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('235', '91', '18745', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('236', '92', '18747', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('237', '93', '18749', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('238', '94', '18751', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('239', '95', '18753', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('240', '96', '18755', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('241', '97', '18757', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('242', '98', '18759', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('243', '99', '18839', '4', '3', '1');
INSERT INTO `bp_score` VALUES ('244', '69', '18761', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('245', '70', '18763', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('246', '71', '18765', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('247', '72', '18767', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('248', '73', '18769', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('249', '74', '18771', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('250', '75', '18773', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('251', '76', '18775', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('252', '77', '18777', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('253', '78', '18779', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('254', '79', '18781', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('255', '80', '18783', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('256', '81', '18785', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('257', '82', '18787', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('258', '83', '18789', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('259', '84', '18791', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('260', '85', '18793', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('261', '86', '18795', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('262', '87', '18797', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('263', '88', '18799', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('264', '89', '18801', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('265', '90', '18803', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('266', '91', '18805', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('267', '92', '18807', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('268', '93', '18809', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('269', '94', '18811', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('270', '95', '18813', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('271', '96', '18815', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('272', '97', '18817', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('273', '98', '18819', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('274', '99', '18821', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('275', '100', '18823', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('276', '101', '18825', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('277', '102', '18827', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('278', '103', '18829', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('279', '104', '18831', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('280', '105', '18833', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('281', '106', '18835', '4', '3', '2');
INSERT INTO `bp_score` VALUES ('282', '60', '18683', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('283', '61', '18685', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('284', '62', '18687', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('285', '63', '18689', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('286', '64', '18691', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('287', '65', '18693', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('288', '66', '18695', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('289', '67', '18697', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('290', '68', '18699', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('291', '69', '18701', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('292', '70', '18703', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('293', '71', '18705', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('294', '72', '18707', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('295', '73', '18709', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('296', '74', '18711', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('297', '75', '18713', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('298', '76', '18715', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('299', '77', '18717', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('300', '78', '18719', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('301', '79', '18721', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('302', '80', '18723', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('303', '81', '18725', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('304', '82', '18727', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('305', '83', '18729', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('306', '84', '18731', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('307', '85', '18733', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('308', '86', '18735', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('309', '87', '18737', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('310', '88', '18739', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('311', '89', '18741', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('312', '90', '18743', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('313', '91', '18745', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('314', '92', '18747', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('315', '93', '18749', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('316', '94', '18751', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('317', '95', '18753', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('318', '96', '18755', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('319', '97', '18757', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('320', '98', '18759', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('321', '99', '18839', '5', '1', '1');
INSERT INTO `bp_score` VALUES ('322', '60', '18683', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('323', '61', '18685', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('324', '62', '18687', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('325', '63', '18689', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('326', '64', '18691', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('327', '65', '18693', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('328', '66', '18695', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('329', '67', '18697', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('330', '68', '18699', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('331', '69', '18701', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('332', '70', '18703', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('333', '71', '18705', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('334', '72', '18707', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('335', '73', '18709', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('336', '74', '18711', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('337', '75', '18713', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('338', '76', '18715', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('339', '77', '18717', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('340', '78', '18719', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('341', '79', '18721', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('342', '80', '18723', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('343', '81', '18725', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('344', '82', '18727', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('345', '83', '18729', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('346', '84', '18731', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('347', '85', '18733', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('348', '86', '18735', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('349', '87', '18737', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('350', '88', '18739', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('351', '89', '18741', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('352', '90', '18743', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('353', '91', '18745', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('354', '92', '18747', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('355', '93', '18749', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('356', '94', '18751', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('357', '95', '18753', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('358', '96', '18755', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('359', '97', '18757', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('360', '98', '18759', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('361', '99', '18839', '5', '2', '1');
INSERT INTO `bp_score` VALUES ('362', '60', '18761', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('363', '61', '18763', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('364', '62', '18765', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('365', '63', '18767', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('366', '64', '18769', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('367', '65', '18771', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('368', '66', '18773', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('369', '67', '18775', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('370', '68', '18777', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('371', '69', '18779', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('372', '70', '18781', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('373', '71', '18783', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('374', '72', '18785', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('375', '73', '18787', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('376', '74', '18789', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('377', '75', '18791', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('378', '76', '18793', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('379', '77', '18795', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('380', '78', '18797', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('381', '79', '18799', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('382', '80', '18801', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('383', '81', '18803', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('384', '82', '18805', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('385', '83', '18807', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('386', '84', '18809', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('387', '85', '18811', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('388', '86', '18813', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('389', '87', '18815', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('390', '88', '18817', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('391', '89', '18819', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('392', '90', '18821', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('393', '91', '18823', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('394', '92', '18825', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('395', '93', '18827', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('396', '94', '18829', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('397', '95', '18831', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('398', '96', '18833', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('399', '97', '18835', '5', '1', '2');
INSERT INTO `bp_score` VALUES ('401', '60', '18761', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('402', '61', '18763', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('403', '62', '18765', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('404', '63', '18767', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('405', '64', '18769', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('406', '65', '18771', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('407', '66', '18773', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('408', '67', '18775', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('409', '68', '18777', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('410', '69', '18779', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('411', '70', '18781', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('412', '71', '18783', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('413', '72', '18785', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('414', '73', '18787', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('415', '74', '18789', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('416', '75', '18791', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('417', '76', '18793', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('418', '77', '18795', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('419', '78', '18797', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('420', '79', '18799', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('421', '80', '18801', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('422', '81', '18803', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('423', '82', '18805', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('424', '83', '18807', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('425', '84', '18809', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('426', '85', '18811', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('427', '86', '18813', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('428', '87', '18815', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('429', '88', '18817', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('430', '89', '18819', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('431', '90', '18821', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('432', '91', '18823', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('433', '92', '18825', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('434', '93', '18827', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('435', '94', '18829', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('436', '95', '18831', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('437', '96', '18833', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('438', '97', '18835', '5', '2', '2');
INSERT INTO `bp_score` VALUES ('439', '40', '18683', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('440', '41', '18685', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('441', '42', '18687', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('442', '43', '18689', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('443', '44', '18691', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('444', '45', '18693', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('445', '46', '18695', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('446', '47', '18697', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('447', '48', '18699', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('448', '49', '18701', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('449', '50', '18703', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('450', '51', '18705', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('451', '52', '18707', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('452', '53', '18709', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('453', '54', '18711', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('454', '55', '18713', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('455', '56', '18715', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('456', '57', '18717', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('457', '58', '18719', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('458', '59', '18721', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('459', '60', '18723', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('460', '61', '18725', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('461', '62', '18727', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('462', '63', '18729', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('463', '64', '18731', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('464', '65', '18733', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('465', '66', '18735', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('466', '67', '18737', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('467', '68', '18739', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('468', '69', '18741', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('469', '70', '18743', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('470', '71', '18745', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('471', '72', '18747', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('472', '73', '18749', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('473', '74', '18751', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('474', '75', '18753', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('475', '76', '18755', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('476', '77', '18757', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('477', '78', '18759', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('478', '79', '18839', '6', '3', '1');
INSERT INTO `bp_score` VALUES ('479', '50', '18761', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('480', '51', '18763', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('481', '52', '18765', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('482', '53', '18767', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('483', '54', '18769', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('484', '55', '18771', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('485', '56', '18773', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('486', '57', '18775', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('487', '58', '18777', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('488', '59', '18779', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('489', '60', '18781', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('490', '61', '18783', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('491', '62', '18785', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('492', '63', '18787', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('493', '64', '18789', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('494', '65', '18791', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('495', '66', '18793', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('496', '67', '18795', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('497', '68', '18797', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('498', '69', '18799', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('499', '70', '18801', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('500', '71', '18803', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('501', '72', '18805', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('502', '73', '18807', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('503', '74', '18809', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('504', '75', '18811', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('505', '76', '18813', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('506', '77', '18815', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('507', '78', '18817', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('508', '79', '18819', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('509', '80', '18821', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('510', '81', '18823', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('511', '82', '18825', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('512', '83', '18827', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('513', '84', '18829', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('514', '85', '18831', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('515', '86', '18833', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('516', '87', '18835', '6', '3', '2');
INSERT INTO `bp_score` VALUES ('557', '150', '18683', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('558', '123', '18685', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('559', '124', '18687', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('560', '125', '18689', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('561', '126', '18691', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('562', '127', '18693', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('563', '128', '18695', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('564', '129', '18697', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('565', '130', '18699', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('566', '131', '18701', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('567', '132', '18703', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('568', '133', '18705', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('569', '134', '18707', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('570', '135', '18709', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('571', '136', '18711', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('572', '137', '18713', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('573', '138', '18715', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('574', '139', '18717', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('575', '140', '18719', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('576', '141', '18721', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('577', '142', '18723', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('578', '143', '18725', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('579', '144', '18727', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('580', '145', '18729', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('581', '146', '18731', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('582', '147', '18733', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('583', '148', '18735', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('584', '149', '18737', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('585', '150', '18739', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('586', '151', '18741', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('587', '152', '18743', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('588', '153', '18745', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('589', '154', '18747', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('590', '155', '18749', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('591', '156', '18751', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('592', '157', '18753', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('593', '158', '18755', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('594', '159', '18757', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('595', '160', '18759', '1', '1', '1');
INSERT INTO `bp_score` VALUES ('596', '161', '18839', '1', '1', '1');

-- ----------------------------
-- Table structure for bp_semester
-- ----------------------------
CREATE TABLE `bp_semester` (
  `se_id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `se_cid` tinyint(1) NOT NULL COMMENT '学期(1:第一学期;2:第二学期)',
  `sy_id` int(10) NOT NULL COMMENT '学年',
  `se_stime` int(10) NOT NULL COMMENT '开始时间',
  `se_etime` int(10) NOT NULL COMMENT '结束时间',
  `se_status` tinyint(3) NOT NULL DEFAULT '0' COMMENT '开启状态 1开启 0未开启 用于排课导出课表',
  PRIMARY KEY (`se_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='学期设置';

-- ----------------------------
-- Records of bp_semester
-- ----------------------------
INSERT INTO `bp_semester` VALUES ('3', '1', '6', '1535731200', '1546185600', '0');
INSERT INTO `bp_semester` VALUES ('4', '2', '6', '1546272000', '1565798400', '1');

-- ----------------------------
-- Table structure for bp_syear
-- ----------------------------
CREATE TABLE `bp_syear` (
  `sy_id` int(10) NOT NULL AUTO_INCREMENT,
  `sy_name` varchar(20) NOT NULL COMMENT '名称',
  `sy_stime` int(10) NOT NULL COMMENT '开始时间',
  `sy_etime` int(10) NOT NULL COMMENT '结束时间',
  PRIMARY KEY (`sy_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='学年设置';

-- ----------------------------
-- Records of bp_syear
-- ----------------------------
INSERT INTO `bp_syear` VALUES ('5', '2017-2018学年', '1498838400', '1535644800');
INSERT INTO `bp_syear` VALUES ('6', '2018-2019学年1', '1535731200', '1567180800');
