/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50553
Source Host           : 127.0.0.1:3306
Source Database       : hedao

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

Date: 2020-01-30 17:32:17
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for t_area
-- ----------------------------
DROP TABLE IF EXISTS `t_area`;
CREATE TABLE `t_area` (
  `id` int(11) NOT NULL,
  `name` varchar(64) DEFAULT NULL COMMENT '区域名称',
  `parent_id` int(11) DEFAULT NULL,
  `parent_ids` varchar(64) DEFAULT NULL COMMENT '所有的父区域',
  `seq` int(11) DEFAULT NULL,
  `type` varchar(32) DEFAULT NULL COMMENT '区域类型，省市县',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_area
-- ----------------------------

-- ----------------------------
-- Table structure for t_attachment
-- ----------------------------
DROP TABLE IF EXISTS `t_attachment`;
CREATE TABLE `t_attachment` (
  `id` int(11) NOT NULL,
  `type` varchar(32) DEFAULT NULL COMMENT '附件类型',
  `origin` varchar(32) DEFAULT NULL COMMENT '所属主体',
  `origin_id` int(11) DEFAULT NULL COMMENT '所属主体ID',
  `path` varchar(255) DEFAULT NULL COMMENT '存储路径',
  `origin_name` varchar(255) DEFAULT NULL COMMENT '原文件名',
  `create_user` varchar(32) DEFAULT NULL COMMENT '上传人',
  `create_time` varchar(32) DEFAULT NULL COMMENT '上传时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_attachment
-- ----------------------------

-- ----------------------------
-- Table structure for t_news
-- ----------------------------
DROP TABLE IF EXISTS `t_news`;
CREATE TABLE `t_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(128) DEFAULT '' COMMENT '标题',
  `content` text COMMENT '内容',
  `author` varchar(64) DEFAULT NULL COMMENT '作者',
  `pub_date` varchar(32) DEFAULT NULL COMMENT '发表日期',
  `num_click` int(11) DEFAULT '0' COMMENT '浏览次数',
  `seq` int(11) DEFAULT '0' COMMENT '序号',
  `create_user` varchar(32) DEFAULT NULL COMMENT '创建人',
  `create_time` varchar(20) DEFAULT NULL COMMENT '创建日期',
  `update_time` varchar(20) DEFAULT NULL COMMENT '最后更新时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_news
-- ----------------------------

-- ----------------------------
-- Table structure for t_reach
-- ----------------------------
DROP TABLE IF EXISTS `t_reach`;
CREATE TABLE `t_reach` (
  `id` int(11) NOT NULL,
  `name` varchar(64) DEFAULT NULL,
  `area_id` int(11) DEFAULT NULL,
  `river_id` int(11) DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL COMMENT '上级河段',
  `lat_from` float(11,2) DEFAULT NULL,
  `lat_end` float(11,2) DEFAULT NULL,
  `lon_from` float(11,2) DEFAULT NULL,
  `lon_end` float(11,2) DEFAULT NULL,
  `describe` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_reach
-- ----------------------------

-- ----------------------------
-- Table structure for t_reach_admin
-- ----------------------------
DROP TABLE IF EXISTS `t_reach_admin`;
CREATE TABLE `t_reach_admin` (
  `reach_id` int(11) NOT NULL COMMENT '河段ID',
  `user_id` int(11) NOT NULL COMMENT '管理员ID',
  PRIMARY KEY (`reach_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_reach_admin
-- ----------------------------

-- ----------------------------
-- Table structure for t_rights
-- ----------------------------
DROP TABLE IF EXISTS `t_rights`;
CREATE TABLE `t_rights` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL COMMENT '权限名称',
  `code` varchar(32) NOT NULL COMMENT '权限代码',
  `parent_id` tinyint(8) NOT NULL DEFAULT '0' COMMENT '父模块名称',
  `pids` varchar(255) DEFAULT NULL,
  `remarks` varchar(32) NOT NULL COMMENT '备注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=233 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_rights
-- ----------------------------
INSERT INTO `t_rights` VALUES ('1', '业务办理', '01', '0', null, '');
INSERT INTO `t_rights` VALUES ('2', '系统管理', '02', '0', null, '');
INSERT INTO `t_rights` VALUES ('11', '在线提问管理', '01-01', '1', '1', '');
INSERT INTO `t_rights` VALUES ('12', '服务工程师管理', '01-02', '1', '1', '');
INSERT INTO `t_rights` VALUES ('13', '统计报表', '01-03', '1', '1', '');
INSERT INTO `t_rights` VALUES ('14', '二维码管理', '01-04', '1', '1', '');
INSERT INTO `t_rights` VALUES ('21', '系统管理', '02-01', '2', '2', '');
INSERT INTO `t_rights` VALUES ('22', '基础数据管理', '02-02', '2', '2', '');
INSERT INTO `t_rights` VALUES ('111', '查看待解决问题', '01-01-01', '11', '1,11', '');
INSERT INTO `t_rights` VALUES ('112', '管理待解决问题', '01-01-02', '11', '1,11', '');
INSERT INTO `t_rights` VALUES ('113', '查看已解决问题', '01-01-03', '11', '1,11', '');
INSERT INTO `t_rights` VALUES ('114', '管理已解决问题', '01-01-04', '11', '1,11', '');
INSERT INTO `t_rights` VALUES ('115', '查看超时预警问题', '01-01-05', '11', '1,11', '');
INSERT INTO `t_rights` VALUES ('116', '查看超时预警问题', '01-01-06', '11', '1,11', '');
INSERT INTO `t_rights` VALUES ('117', '查看派单记录', '01-01-07', '11', '1,11', '');
INSERT INTO `t_rights` VALUES ('118', '管理派单记录', '01-01-08', '11', '1,11', '');
INSERT INTO `t_rights` VALUES ('121', '查看待审批列表', '01-02-01', '12', '1,12', '');
INSERT INTO `t_rights` VALUES ('122', '管理待审批列表', '01-02-02', '12', '1,12', '');
INSERT INTO `t_rights` VALUES ('123', '查看已审批列表', '01-02-03', '12', '1,12', '');
INSERT INTO `t_rights` VALUES ('131', '查看在线提问统计', '01-03-01', '13', '1,13', '');
INSERT INTO `t_rights` VALUES ('132', '查看问题解答报表', '01-03-02', '13', '1,13', '');
INSERT INTO `t_rights` VALUES ('133', '查看超时解答报表', '01-03-03', '13', '1,13', '');
INSERT INTO `t_rights` VALUES ('134', '查看工程师解答统计', '01-03-04', '13', '1,13', '');
INSERT INTO `t_rights` VALUES ('141', '生成二维码', '01-04-01', '14', '1,14', '');
INSERT INTO `t_rights` VALUES ('142', '查看操作记录', '01-04-02', '14', '1,14', '');
INSERT INTO `t_rights` VALUES ('143', '管理操作记录', '01-04-03', '14', '1,14', '');
INSERT INTO `t_rights` VALUES ('211', '查看系统用户列表', '02-01-01', '21', '2,21', '');
INSERT INTO `t_rights` VALUES ('212', '管理系统用户', '02-01-02', '21', '2,21', '');
INSERT INTO `t_rights` VALUES ('213', '查看系统角色列表', '02-01-03', '21', '2,21', '');
INSERT INTO `t_rights` VALUES ('214', '管理系统角色', '02-01-04', '21', '2,21', '');
INSERT INTO `t_rights` VALUES ('215', '查看系统参数', '02-01-05', '21', '2,21', '');
INSERT INTO `t_rights` VALUES ('216', '管理系统参数', '02-01-06', '21', '2,21', '');
INSERT INTO `t_rights` VALUES ('221', '查看事业部列表', '02-02-01', '22', '2,22', '');
INSERT INTO `t_rights` VALUES ('222', '管理事业部', '02-02-02', '22', '2,22', '');
INSERT INTO `t_rights` VALUES ('223', '查看产品类型列表', '02-02-03', '22', '2,22', '');
INSERT INTO `t_rights` VALUES ('224', '管理产品类型', '02-02-04', '22', '2,22', '');
INSERT INTO `t_rights` VALUES ('225', '查看产品部件列表 ', '02-02-05', '22', '2,22', '');
INSERT INTO `t_rights` VALUES ('226', '管理产品部件 ', '02-02-06', '22', '2,22', '');
INSERT INTO `t_rights` VALUES ('227', '查看擅长项列表', '02-02-07', '22', '2,22', '');
INSERT INTO `t_rights` VALUES ('228', '管理擅长项', '02-02-08', '22', '2,22', '');
INSERT INTO `t_rights` VALUES ('229', '查看用户绑定', '02-02-09', '22', '2,22', '');
INSERT INTO `t_rights` VALUES ('230', '管理用户绑定', '02-02-10', '22', '2,22', '');
INSERT INTO `t_rights` VALUES ('231', '查看报修记录', '02-02-11', '22', '2,22', '');
INSERT INTO `t_rights` VALUES ('232', '管理报修记录', '02-02-12', '22', '2,22', '');

-- ----------------------------
-- Table structure for t_rights_assign
-- ----------------------------
DROP TABLE IF EXISTS `t_rights_assign`;
CREATE TABLE `t_rights_assign` (
  `rights_id` int(11) NOT NULL COMMENT '权限ID，外键',
  `role_id` int(11) NOT NULL COMMENT '角色ID，外键',
  PRIMARY KEY (`rights_id`,`role_id`),
  KEY `角色ID` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_rights_assign
-- ----------------------------
INSERT INTO `t_rights_assign` VALUES ('1', '1');
INSERT INTO `t_rights_assign` VALUES ('2', '1');
INSERT INTO `t_rights_assign` VALUES ('3', '1');
INSERT INTO `t_rights_assign` VALUES ('10', '1');
INSERT INTO `t_rights_assign` VALUES ('14', '1');
INSERT INTO `t_rights_assign` VALUES ('18', '1');
INSERT INTO `t_rights_assign` VALUES ('22', '1');
INSERT INTO `t_rights_assign` VALUES ('30', '1');
INSERT INTO `t_rights_assign` VALUES ('34', '1');
INSERT INTO `t_rights_assign` VALUES ('38', '1');
INSERT INTO `t_rights_assign` VALUES ('40', '1');
INSERT INTO `t_rights_assign` VALUES ('42', '1');
INSERT INTO `t_rights_assign` VALUES ('46', '1');
INSERT INTO `t_rights_assign` VALUES ('50', '1');
INSERT INTO `t_rights_assign` VALUES ('101', '1');
INSERT INTO `t_rights_assign` VALUES ('141', '1');
INSERT INTO `t_rights_assign` VALUES ('182', '1');
INSERT INTO `t_rights_assign` VALUES ('183', '1');
INSERT INTO `t_rights_assign` VALUES ('221', '1');
INSERT INTO `t_rights_assign` VALUES ('223', '1');
INSERT INTO `t_rights_assign` VALUES ('225', '1');
INSERT INTO `t_rights_assign` VALUES ('301', '1');
INSERT INTO `t_rights_assign` VALUES ('302', '1');
INSERT INTO `t_rights_assign` VALUES ('303', '1');
INSERT INTO `t_rights_assign` VALUES ('304', '1');
INSERT INTO `t_rights_assign` VALUES ('305', '1');
INSERT INTO `t_rights_assign` VALUES ('306', '1');
INSERT INTO `t_rights_assign` VALUES ('307', '1');
INSERT INTO `t_rights_assign` VALUES ('308', '1');
INSERT INTO `t_rights_assign` VALUES ('310', '1');
INSERT INTO `t_rights_assign` VALUES ('311', '1');
INSERT INTO `t_rights_assign` VALUES ('312', '1');
INSERT INTO `t_rights_assign` VALUES ('341', '1');
INSERT INTO `t_rights_assign` VALUES ('343', '1');
INSERT INTO `t_rights_assign` VALUES ('345', '1');
INSERT INTO `t_rights_assign` VALUES ('346', '1');
INSERT INTO `t_rights_assign` VALUES ('381', '1');
INSERT INTO `t_rights_assign` VALUES ('383', '1');
INSERT INTO `t_rights_assign` VALUES ('385', '1');
INSERT INTO `t_rights_assign` VALUES ('386', '1');
INSERT INTO `t_rights_assign` VALUES ('388', '1');
INSERT INTO `t_rights_assign` VALUES ('391', '1');
INSERT INTO `t_rights_assign` VALUES ('393', '1');
INSERT INTO `t_rights_assign` VALUES ('395', '1');
INSERT INTO `t_rights_assign` VALUES ('401', '1');
INSERT INTO `t_rights_assign` VALUES ('403', '1');
INSERT INTO `t_rights_assign` VALUES ('404', '1');
INSERT INTO `t_rights_assign` VALUES ('405', '1');
INSERT INTO `t_rights_assign` VALUES ('421', '1');
INSERT INTO `t_rights_assign` VALUES ('423', '1');
INSERT INTO `t_rights_assign` VALUES ('463', '1');
INSERT INTO `t_rights_assign` VALUES ('467', '1');
INSERT INTO `t_rights_assign` VALUES ('471', '1');
INSERT INTO `t_rights_assign` VALUES ('501', '1');
INSERT INTO `t_rights_assign` VALUES ('502', '1');
INSERT INTO `t_rights_assign` VALUES ('503', '1');
INSERT INTO `t_rights_assign` VALUES ('504', '1');
INSERT INTO `t_rights_assign` VALUES ('505', '1');
INSERT INTO `t_rights_assign` VALUES ('506', '1');
INSERT INTO `t_rights_assign` VALUES ('1', '2');
INSERT INTO `t_rights_assign` VALUES ('2', '2');
INSERT INTO `t_rights_assign` VALUES ('3', '2');
INSERT INTO `t_rights_assign` VALUES ('10', '2');
INSERT INTO `t_rights_assign` VALUES ('14', '2');
INSERT INTO `t_rights_assign` VALUES ('18', '2');
INSERT INTO `t_rights_assign` VALUES ('22', '2');
INSERT INTO `t_rights_assign` VALUES ('26', '2');
INSERT INTO `t_rights_assign` VALUES ('30', '2');
INSERT INTO `t_rights_assign` VALUES ('34', '2');
INSERT INTO `t_rights_assign` VALUES ('38', '2');
INSERT INTO `t_rights_assign` VALUES ('40', '2');
INSERT INTO `t_rights_assign` VALUES ('42', '2');
INSERT INTO `t_rights_assign` VALUES ('46', '2');
INSERT INTO `t_rights_assign` VALUES ('50', '2');
INSERT INTO `t_rights_assign` VALUES ('54', '2');
INSERT INTO `t_rights_assign` VALUES ('100', '2');
INSERT INTO `t_rights_assign` VALUES ('101', '2');
INSERT INTO `t_rights_assign` VALUES ('102', '2');
INSERT INTO `t_rights_assign` VALUES ('103', '2');
INSERT INTO `t_rights_assign` VALUES ('104', '2');
INSERT INTO `t_rights_assign` VALUES ('105', '2');
INSERT INTO `t_rights_assign` VALUES ('106', '2');
INSERT INTO `t_rights_assign` VALUES ('107', '2');
INSERT INTO `t_rights_assign` VALUES ('108', '2');
INSERT INTO `t_rights_assign` VALUES ('109', '2');
INSERT INTO `t_rights_assign` VALUES ('110', '2');
INSERT INTO `t_rights_assign` VALUES ('140', '2');
INSERT INTO `t_rights_assign` VALUES ('141', '2');
INSERT INTO `t_rights_assign` VALUES ('142', '2');
INSERT INTO `t_rights_assign` VALUES ('143', '2');
INSERT INTO `t_rights_assign` VALUES ('144', '2');
INSERT INTO `t_rights_assign` VALUES ('145', '2');
INSERT INTO `t_rights_assign` VALUES ('146', '2');
INSERT INTO `t_rights_assign` VALUES ('147', '2');
INSERT INTO `t_rights_assign` VALUES ('148', '2');
INSERT INTO `t_rights_assign` VALUES ('149', '2');
INSERT INTO `t_rights_assign` VALUES ('150', '2');
INSERT INTO `t_rights_assign` VALUES ('181', '2');
INSERT INTO `t_rights_assign` VALUES ('182', '2');
INSERT INTO `t_rights_assign` VALUES ('183', '2');
INSERT INTO `t_rights_assign` VALUES ('184', '2');
INSERT INTO `t_rights_assign` VALUES ('185', '2');
INSERT INTO `t_rights_assign` VALUES ('186', '2');
INSERT INTO `t_rights_assign` VALUES ('187', '2');
INSERT INTO `t_rights_assign` VALUES ('188', '2');
INSERT INTO `t_rights_assign` VALUES ('189', '2');
INSERT INTO `t_rights_assign` VALUES ('190', '2');
INSERT INTO `t_rights_assign` VALUES ('191', '2');
INSERT INTO `t_rights_assign` VALUES ('192', '2');
INSERT INTO `t_rights_assign` VALUES ('221', '2');
INSERT INTO `t_rights_assign` VALUES ('222', '2');
INSERT INTO `t_rights_assign` VALUES ('223', '2');
INSERT INTO `t_rights_assign` VALUES ('224', '2');
INSERT INTO `t_rights_assign` VALUES ('225', '2');
INSERT INTO `t_rights_assign` VALUES ('226', '2');
INSERT INTO `t_rights_assign` VALUES ('227', '2');
INSERT INTO `t_rights_assign` VALUES ('228', '2');
INSERT INTO `t_rights_assign` VALUES ('261', '2');
INSERT INTO `t_rights_assign` VALUES ('262', '2');
INSERT INTO `t_rights_assign` VALUES ('263', '2');
INSERT INTO `t_rights_assign` VALUES ('264', '2');
INSERT INTO `t_rights_assign` VALUES ('265', '2');
INSERT INTO `t_rights_assign` VALUES ('266', '2');
INSERT INTO `t_rights_assign` VALUES ('267', '2');
INSERT INTO `t_rights_assign` VALUES ('268', '2');
INSERT INTO `t_rights_assign` VALUES ('269', '2');
INSERT INTO `t_rights_assign` VALUES ('270', '2');
INSERT INTO `t_rights_assign` VALUES ('271', '2');
INSERT INTO `t_rights_assign` VALUES ('301', '2');
INSERT INTO `t_rights_assign` VALUES ('302', '2');
INSERT INTO `t_rights_assign` VALUES ('303', '2');
INSERT INTO `t_rights_assign` VALUES ('304', '2');
INSERT INTO `t_rights_assign` VALUES ('305', '2');
INSERT INTO `t_rights_assign` VALUES ('306', '2');
INSERT INTO `t_rights_assign` VALUES ('307', '2');
INSERT INTO `t_rights_assign` VALUES ('308', '2');
INSERT INTO `t_rights_assign` VALUES ('309', '2');
INSERT INTO `t_rights_assign` VALUES ('310', '2');
INSERT INTO `t_rights_assign` VALUES ('311', '2');
INSERT INTO `t_rights_assign` VALUES ('312', '2');
INSERT INTO `t_rights_assign` VALUES ('313', '2');
INSERT INTO `t_rights_assign` VALUES ('341', '2');
INSERT INTO `t_rights_assign` VALUES ('342', '2');
INSERT INTO `t_rights_assign` VALUES ('343', '2');
INSERT INTO `t_rights_assign` VALUES ('344', '2');
INSERT INTO `t_rights_assign` VALUES ('345', '2');
INSERT INTO `t_rights_assign` VALUES ('346', '2');
INSERT INTO `t_rights_assign` VALUES ('381', '2');
INSERT INTO `t_rights_assign` VALUES ('382', '2');
INSERT INTO `t_rights_assign` VALUES ('383', '2');
INSERT INTO `t_rights_assign` VALUES ('384', '2');
INSERT INTO `t_rights_assign` VALUES ('385', '2');
INSERT INTO `t_rights_assign` VALUES ('386', '2');
INSERT INTO `t_rights_assign` VALUES ('387', '2');
INSERT INTO `t_rights_assign` VALUES ('388', '2');
INSERT INTO `t_rights_assign` VALUES ('389', '2');
INSERT INTO `t_rights_assign` VALUES ('390', '2');
INSERT INTO `t_rights_assign` VALUES ('391', '2');
INSERT INTO `t_rights_assign` VALUES ('392', '2');
INSERT INTO `t_rights_assign` VALUES ('393', '2');
INSERT INTO `t_rights_assign` VALUES ('394', '2');
INSERT INTO `t_rights_assign` VALUES ('395', '2');
INSERT INTO `t_rights_assign` VALUES ('396', '2');
INSERT INTO `t_rights_assign` VALUES ('397', '2');
INSERT INTO `t_rights_assign` VALUES ('398', '2');
INSERT INTO `t_rights_assign` VALUES ('399', '2');
INSERT INTO `t_rights_assign` VALUES ('400', '2');
INSERT INTO `t_rights_assign` VALUES ('401', '2');
INSERT INTO `t_rights_assign` VALUES ('402', '2');
INSERT INTO `t_rights_assign` VALUES ('403', '2');
INSERT INTO `t_rights_assign` VALUES ('404', '2');
INSERT INTO `t_rights_assign` VALUES ('405', '2');
INSERT INTO `t_rights_assign` VALUES ('421', '2');
INSERT INTO `t_rights_assign` VALUES ('422', '2');
INSERT INTO `t_rights_assign` VALUES ('423', '2');
INSERT INTO `t_rights_assign` VALUES ('424', '2');
INSERT INTO `t_rights_assign` VALUES ('461', '2');
INSERT INTO `t_rights_assign` VALUES ('462', '2');
INSERT INTO `t_rights_assign` VALUES ('463', '2');
INSERT INTO `t_rights_assign` VALUES ('464', '2');
INSERT INTO `t_rights_assign` VALUES ('465', '2');
INSERT INTO `t_rights_assign` VALUES ('466', '2');
INSERT INTO `t_rights_assign` VALUES ('467', '2');
INSERT INTO `t_rights_assign` VALUES ('468', '2');
INSERT INTO `t_rights_assign` VALUES ('469', '2');
INSERT INTO `t_rights_assign` VALUES ('470', '2');
INSERT INTO `t_rights_assign` VALUES ('471', '2');
INSERT INTO `t_rights_assign` VALUES ('472', '2');
INSERT INTO `t_rights_assign` VALUES ('501', '2');
INSERT INTO `t_rights_assign` VALUES ('502', '2');
INSERT INTO `t_rights_assign` VALUES ('503', '2');
INSERT INTO `t_rights_assign` VALUES ('504', '2');
INSERT INTO `t_rights_assign` VALUES ('505', '2');
INSERT INTO `t_rights_assign` VALUES ('506', '2');
INSERT INTO `t_rights_assign` VALUES ('541', '2');
INSERT INTO `t_rights_assign` VALUES ('542', '2');
INSERT INTO `t_rights_assign` VALUES ('544', '2');
INSERT INTO `t_rights_assign` VALUES ('545', '2');
INSERT INTO `t_rights_assign` VALUES ('546', '2');
INSERT INTO `t_rights_assign` VALUES ('547', '2');
INSERT INTO `t_rights_assign` VALUES ('548', '2');
INSERT INTO `t_rights_assign` VALUES ('549', '2');
INSERT INTO `t_rights_assign` VALUES ('550', '2');
INSERT INTO `t_rights_assign` VALUES ('551', '2');
INSERT INTO `t_rights_assign` VALUES ('552', '2');
INSERT INTO `t_rights_assign` VALUES ('553', '2');
INSERT INTO `t_rights_assign` VALUES ('554', '2');
INSERT INTO `t_rights_assign` VALUES ('555', '2');
INSERT INTO `t_rights_assign` VALUES ('556', '2');
INSERT INTO `t_rights_assign` VALUES ('557', '2');
INSERT INTO `t_rights_assign` VALUES ('558', '2');
INSERT INTO `t_rights_assign` VALUES ('559', '2');
INSERT INTO `t_rights_assign` VALUES ('1', '3');
INSERT INTO `t_rights_assign` VALUES ('2', '3');
INSERT INTO `t_rights_assign` VALUES ('3', '3');
INSERT INTO `t_rights_assign` VALUES ('22', '3');
INSERT INTO `t_rights_assign` VALUES ('30', '3');
INSERT INTO `t_rights_assign` VALUES ('34', '3');
INSERT INTO `t_rights_assign` VALUES ('38', '3');
INSERT INTO `t_rights_assign` VALUES ('40', '3');
INSERT INTO `t_rights_assign` VALUES ('42', '3');
INSERT INTO `t_rights_assign` VALUES ('46', '3');
INSERT INTO `t_rights_assign` VALUES ('50', '3');
INSERT INTO `t_rights_assign` VALUES ('223', '3');
INSERT INTO `t_rights_assign` VALUES ('301', '3');
INSERT INTO `t_rights_assign` VALUES ('303', '3');
INSERT INTO `t_rights_assign` VALUES ('306', '3');
INSERT INTO `t_rights_assign` VALUES ('308', '3');
INSERT INTO `t_rights_assign` VALUES ('310', '3');
INSERT INTO `t_rights_assign` VALUES ('345', '3');
INSERT INTO `t_rights_assign` VALUES ('346', '3');
INSERT INTO `t_rights_assign` VALUES ('381', '3');
INSERT INTO `t_rights_assign` VALUES ('383', '3');
INSERT INTO `t_rights_assign` VALUES ('385', '3');
INSERT INTO `t_rights_assign` VALUES ('386', '3');
INSERT INTO `t_rights_assign` VALUES ('391', '3');
INSERT INTO `t_rights_assign` VALUES ('392', '3');
INSERT INTO `t_rights_assign` VALUES ('393', '3');
INSERT INTO `t_rights_assign` VALUES ('395', '3');
INSERT INTO `t_rights_assign` VALUES ('396', '3');
INSERT INTO `t_rights_assign` VALUES ('403', '3');
INSERT INTO `t_rights_assign` VALUES ('421', '3');
INSERT INTO `t_rights_assign` VALUES ('423', '3');
INSERT INTO `t_rights_assign` VALUES ('461', '3');
INSERT INTO `t_rights_assign` VALUES ('463', '3');
INSERT INTO `t_rights_assign` VALUES ('465', '3');
INSERT INTO `t_rights_assign` VALUES ('467', '3');
INSERT INTO `t_rights_assign` VALUES ('471', '3');
INSERT INTO `t_rights_assign` VALUES ('502', '3');
INSERT INTO `t_rights_assign` VALUES ('503', '3');
INSERT INTO `t_rights_assign` VALUES ('505', '3');
INSERT INTO `t_rights_assign` VALUES ('506', '3');
INSERT INTO `t_rights_assign` VALUES ('1', '4');
INSERT INTO `t_rights_assign` VALUES ('2', '4');
INSERT INTO `t_rights_assign` VALUES ('3', '4');
INSERT INTO `t_rights_assign` VALUES ('26', '4');
INSERT INTO `t_rights_assign` VALUES ('34', '4');
INSERT INTO `t_rights_assign` VALUES ('46', '4');
INSERT INTO `t_rights_assign` VALUES ('266', '4');
INSERT INTO `t_rights_assign` VALUES ('345', '4');
INSERT INTO `t_rights_assign` VALUES ('346', '4');
INSERT INTO `t_rights_assign` VALUES ('463', '4');
INSERT INTO `t_rights_assign` VALUES ('467', '4');
INSERT INTO `t_rights_assign` VALUES ('471', '4');
INSERT INTO `t_rights_assign` VALUES ('1', '5');
INSERT INTO `t_rights_assign` VALUES ('2', '5');
INSERT INTO `t_rights_assign` VALUES ('3', '5');
INSERT INTO `t_rights_assign` VALUES ('26', '5');
INSERT INTO `t_rights_assign` VALUES ('34', '5');
INSERT INTO `t_rights_assign` VALUES ('46', '5');
INSERT INTO `t_rights_assign` VALUES ('50', '5');
INSERT INTO `t_rights_assign` VALUES ('261', '5');
INSERT INTO `t_rights_assign` VALUES ('345', '5');
INSERT INTO `t_rights_assign` VALUES ('346', '5');
INSERT INTO `t_rights_assign` VALUES ('463', '5');
INSERT INTO `t_rights_assign` VALUES ('467', '5');
INSERT INTO `t_rights_assign` VALUES ('471', '5');
INSERT INTO `t_rights_assign` VALUES ('501', '5');
INSERT INTO `t_rights_assign` VALUES ('1', '6');
INSERT INTO `t_rights_assign` VALUES ('2', '6');
INSERT INTO `t_rights_assign` VALUES ('3', '6');
INSERT INTO `t_rights_assign` VALUES ('26', '6');
INSERT INTO `t_rights_assign` VALUES ('34', '6');
INSERT INTO `t_rights_assign` VALUES ('46', '6');
INSERT INTO `t_rights_assign` VALUES ('50', '6');
INSERT INTO `t_rights_assign` VALUES ('262', '6');
INSERT INTO `t_rights_assign` VALUES ('345', '6');
INSERT INTO `t_rights_assign` VALUES ('346', '6');
INSERT INTO `t_rights_assign` VALUES ('463', '6');
INSERT INTO `t_rights_assign` VALUES ('467', '6');
INSERT INTO `t_rights_assign` VALUES ('471', '6');
INSERT INTO `t_rights_assign` VALUES ('501', '6');
INSERT INTO `t_rights_assign` VALUES ('1', '7');
INSERT INTO `t_rights_assign` VALUES ('2', '7');
INSERT INTO `t_rights_assign` VALUES ('3', '7');
INSERT INTO `t_rights_assign` VALUES ('26', '7');
INSERT INTO `t_rights_assign` VALUES ('34', '7');
INSERT INTO `t_rights_assign` VALUES ('46', '7');
INSERT INTO `t_rights_assign` VALUES ('263', '7');
INSERT INTO `t_rights_assign` VALUES ('345', '7');
INSERT INTO `t_rights_assign` VALUES ('346', '7');
INSERT INTO `t_rights_assign` VALUES ('463', '7');
INSERT INTO `t_rights_assign` VALUES ('467', '7');
INSERT INTO `t_rights_assign` VALUES ('471', '7');
INSERT INTO `t_rights_assign` VALUES ('1', '8');
INSERT INTO `t_rights_assign` VALUES ('2', '8');
INSERT INTO `t_rights_assign` VALUES ('3', '8');
INSERT INTO `t_rights_assign` VALUES ('26', '8');
INSERT INTO `t_rights_assign` VALUES ('34', '8');
INSERT INTO `t_rights_assign` VALUES ('46', '8');
INSERT INTO `t_rights_assign` VALUES ('264', '8');
INSERT INTO `t_rights_assign` VALUES ('345', '8');
INSERT INTO `t_rights_assign` VALUES ('346', '8');
INSERT INTO `t_rights_assign` VALUES ('463', '8');
INSERT INTO `t_rights_assign` VALUES ('467', '8');
INSERT INTO `t_rights_assign` VALUES ('471', '8');
INSERT INTO `t_rights_assign` VALUES ('1', '9');
INSERT INTO `t_rights_assign` VALUES ('2', '9');
INSERT INTO `t_rights_assign` VALUES ('3', '9');
INSERT INTO `t_rights_assign` VALUES ('26', '9');
INSERT INTO `t_rights_assign` VALUES ('34', '9');
INSERT INTO `t_rights_assign` VALUES ('46', '9');
INSERT INTO `t_rights_assign` VALUES ('265', '9');
INSERT INTO `t_rights_assign` VALUES ('345', '9');
INSERT INTO `t_rights_assign` VALUES ('346', '9');
INSERT INTO `t_rights_assign` VALUES ('463', '9');
INSERT INTO `t_rights_assign` VALUES ('467', '9');
INSERT INTO `t_rights_assign` VALUES ('471', '9');
INSERT INTO `t_rights_assign` VALUES ('1', '10');
INSERT INTO `t_rights_assign` VALUES ('2', '10');
INSERT INTO `t_rights_assign` VALUES ('3', '10');
INSERT INTO `t_rights_assign` VALUES ('26', '10');
INSERT INTO `t_rights_assign` VALUES ('34', '10');
INSERT INTO `t_rights_assign` VALUES ('46', '10');
INSERT INTO `t_rights_assign` VALUES ('267', '10');
INSERT INTO `t_rights_assign` VALUES ('345', '10');
INSERT INTO `t_rights_assign` VALUES ('346', '10');
INSERT INTO `t_rights_assign` VALUES ('463', '10');
INSERT INTO `t_rights_assign` VALUES ('467', '10');
INSERT INTO `t_rights_assign` VALUES ('471', '10');
INSERT INTO `t_rights_assign` VALUES ('1', '11');
INSERT INTO `t_rights_assign` VALUES ('2', '11');
INSERT INTO `t_rights_assign` VALUES ('3', '11');
INSERT INTO `t_rights_assign` VALUES ('26', '11');
INSERT INTO `t_rights_assign` VALUES ('34', '11');
INSERT INTO `t_rights_assign` VALUES ('42', '11');
INSERT INTO `t_rights_assign` VALUES ('46', '11');
INSERT INTO `t_rights_assign` VALUES ('268', '11');
INSERT INTO `t_rights_assign` VALUES ('345', '11');
INSERT INTO `t_rights_assign` VALUES ('346', '11');
INSERT INTO `t_rights_assign` VALUES ('421', '11');
INSERT INTO `t_rights_assign` VALUES ('423', '11');
INSERT INTO `t_rights_assign` VALUES ('463', '11');
INSERT INTO `t_rights_assign` VALUES ('467', '11');
INSERT INTO `t_rights_assign` VALUES ('471', '11');
INSERT INTO `t_rights_assign` VALUES ('1', '12');
INSERT INTO `t_rights_assign` VALUES ('2', '12');
INSERT INTO `t_rights_assign` VALUES ('3', '12');
INSERT INTO `t_rights_assign` VALUES ('26', '12');
INSERT INTO `t_rights_assign` VALUES ('34', '12');
INSERT INTO `t_rights_assign` VALUES ('46', '12');
INSERT INTO `t_rights_assign` VALUES ('269', '12');
INSERT INTO `t_rights_assign` VALUES ('345', '12');
INSERT INTO `t_rights_assign` VALUES ('346', '12');
INSERT INTO `t_rights_assign` VALUES ('463', '12');
INSERT INTO `t_rights_assign` VALUES ('467', '12');
INSERT INTO `t_rights_assign` VALUES ('471', '12');
INSERT INTO `t_rights_assign` VALUES ('1', '13');
INSERT INTO `t_rights_assign` VALUES ('2', '13');
INSERT INTO `t_rights_assign` VALUES ('3', '13');
INSERT INTO `t_rights_assign` VALUES ('26', '13');
INSERT INTO `t_rights_assign` VALUES ('34', '13');
INSERT INTO `t_rights_assign` VALUES ('46', '13');
INSERT INTO `t_rights_assign` VALUES ('270', '13');
INSERT INTO `t_rights_assign` VALUES ('345', '13');
INSERT INTO `t_rights_assign` VALUES ('346', '13');
INSERT INTO `t_rights_assign` VALUES ('463', '13');
INSERT INTO `t_rights_assign` VALUES ('467', '13');
INSERT INTO `t_rights_assign` VALUES ('471', '13');
INSERT INTO `t_rights_assign` VALUES ('1', '14');
INSERT INTO `t_rights_assign` VALUES ('2', '14');
INSERT INTO `t_rights_assign` VALUES ('3', '14');
INSERT INTO `t_rights_assign` VALUES ('26', '14');
INSERT INTO `t_rights_assign` VALUES ('34', '14');
INSERT INTO `t_rights_assign` VALUES ('46', '14');
INSERT INTO `t_rights_assign` VALUES ('271', '14');
INSERT INTO `t_rights_assign` VALUES ('345', '14');
INSERT INTO `t_rights_assign` VALUES ('346', '14');
INSERT INTO `t_rights_assign` VALUES ('463', '14');
INSERT INTO `t_rights_assign` VALUES ('467', '14');
INSERT INTO `t_rights_assign` VALUES ('471', '14');
INSERT INTO `t_rights_assign` VALUES ('1', '15');
INSERT INTO `t_rights_assign` VALUES ('2', '15');
INSERT INTO `t_rights_assign` VALUES ('3', '15');
INSERT INTO `t_rights_assign` VALUES ('10', '15');
INSERT INTO `t_rights_assign` VALUES ('14', '15');
INSERT INTO `t_rights_assign` VALUES ('18', '15');
INSERT INTO `t_rights_assign` VALUES ('22', '15');
INSERT INTO `t_rights_assign` VALUES ('30', '15');
INSERT INTO `t_rights_assign` VALUES ('34', '15');
INSERT INTO `t_rights_assign` VALUES ('38', '15');
INSERT INTO `t_rights_assign` VALUES ('40', '15');
INSERT INTO `t_rights_assign` VALUES ('42', '15');
INSERT INTO `t_rights_assign` VALUES ('46', '15');
INSERT INTO `t_rights_assign` VALUES ('50', '15');
INSERT INTO `t_rights_assign` VALUES ('54', '15');
INSERT INTO `t_rights_assign` VALUES ('101', '15');
INSERT INTO `t_rights_assign` VALUES ('106', '15');
INSERT INTO `t_rights_assign` VALUES ('107', '15');
INSERT INTO `t_rights_assign` VALUES ('108', '15');
INSERT INTO `t_rights_assign` VALUES ('141', '15');
INSERT INTO `t_rights_assign` VALUES ('146', '15');
INSERT INTO `t_rights_assign` VALUES ('147', '15');
INSERT INTO `t_rights_assign` VALUES ('148', '15');
INSERT INTO `t_rights_assign` VALUES ('182', '15');
INSERT INTO `t_rights_assign` VALUES ('187', '15');
INSERT INTO `t_rights_assign` VALUES ('188', '15');
INSERT INTO `t_rights_assign` VALUES ('189', '15');
INSERT INTO `t_rights_assign` VALUES ('192', '15');
INSERT INTO `t_rights_assign` VALUES ('221', '15');
INSERT INTO `t_rights_assign` VALUES ('222', '15');
INSERT INTO `t_rights_assign` VALUES ('223', '15');
INSERT INTO `t_rights_assign` VALUES ('224', '15');
INSERT INTO `t_rights_assign` VALUES ('226', '15');
INSERT INTO `t_rights_assign` VALUES ('227', '15');
INSERT INTO `t_rights_assign` VALUES ('301', '15');
INSERT INTO `t_rights_assign` VALUES ('302', '15');
INSERT INTO `t_rights_assign` VALUES ('303', '15');
INSERT INTO `t_rights_assign` VALUES ('304', '15');
INSERT INTO `t_rights_assign` VALUES ('305', '15');
INSERT INTO `t_rights_assign` VALUES ('306', '15');
INSERT INTO `t_rights_assign` VALUES ('307', '15');
INSERT INTO `t_rights_assign` VALUES ('308', '15');
INSERT INTO `t_rights_assign` VALUES ('309', '15');
INSERT INTO `t_rights_assign` VALUES ('310', '15');
INSERT INTO `t_rights_assign` VALUES ('312', '15');
INSERT INTO `t_rights_assign` VALUES ('341', '15');
INSERT INTO `t_rights_assign` VALUES ('343', '15');
INSERT INTO `t_rights_assign` VALUES ('345', '15');
INSERT INTO `t_rights_assign` VALUES ('346', '15');
INSERT INTO `t_rights_assign` VALUES ('381', '15');
INSERT INTO `t_rights_assign` VALUES ('383', '15');
INSERT INTO `t_rights_assign` VALUES ('385', '15');
INSERT INTO `t_rights_assign` VALUES ('386', '15');
INSERT INTO `t_rights_assign` VALUES ('388', '15');
INSERT INTO `t_rights_assign` VALUES ('389', '15');
INSERT INTO `t_rights_assign` VALUES ('390', '15');
INSERT INTO `t_rights_assign` VALUES ('391', '15');
INSERT INTO `t_rights_assign` VALUES ('393', '15');
INSERT INTO `t_rights_assign` VALUES ('394', '15');
INSERT INTO `t_rights_assign` VALUES ('395', '15');
INSERT INTO `t_rights_assign` VALUES ('397', '15');
INSERT INTO `t_rights_assign` VALUES ('398', '15');
INSERT INTO `t_rights_assign` VALUES ('401', '15');
INSERT INTO `t_rights_assign` VALUES ('402', '15');
INSERT INTO `t_rights_assign` VALUES ('403', '15');
INSERT INTO `t_rights_assign` VALUES ('404', '15');
INSERT INTO `t_rights_assign` VALUES ('405', '15');
INSERT INTO `t_rights_assign` VALUES ('421', '15');
INSERT INTO `t_rights_assign` VALUES ('423', '15');
INSERT INTO `t_rights_assign` VALUES ('461', '15');
INSERT INTO `t_rights_assign` VALUES ('462', '15');
INSERT INTO `t_rights_assign` VALUES ('463', '15');
INSERT INTO `t_rights_assign` VALUES ('464', '15');
INSERT INTO `t_rights_assign` VALUES ('465', '15');
INSERT INTO `t_rights_assign` VALUES ('466', '15');
INSERT INTO `t_rights_assign` VALUES ('467', '15');
INSERT INTO `t_rights_assign` VALUES ('468', '15');
INSERT INTO `t_rights_assign` VALUES ('469', '15');
INSERT INTO `t_rights_assign` VALUES ('471', '15');
INSERT INTO `t_rights_assign` VALUES ('472', '15');
INSERT INTO `t_rights_assign` VALUES ('501', '15');
INSERT INTO `t_rights_assign` VALUES ('502', '15');
INSERT INTO `t_rights_assign` VALUES ('503', '15');
INSERT INTO `t_rights_assign` VALUES ('504', '15');
INSERT INTO `t_rights_assign` VALUES ('505', '15');
INSERT INTO `t_rights_assign` VALUES ('506', '15');
INSERT INTO `t_rights_assign` VALUES ('546', '15');
INSERT INTO `t_rights_assign` VALUES ('548', '15');
INSERT INTO `t_rights_assign` VALUES ('550', '15');
INSERT INTO `t_rights_assign` VALUES ('558', '15');
INSERT INTO `t_rights_assign` VALUES ('1', '16');
INSERT INTO `t_rights_assign` VALUES ('2', '16');
INSERT INTO `t_rights_assign` VALUES ('3', '16');
INSERT INTO `t_rights_assign` VALUES ('10', '16');
INSERT INTO `t_rights_assign` VALUES ('14', '16');
INSERT INTO `t_rights_assign` VALUES ('18', '16');
INSERT INTO `t_rights_assign` VALUES ('22', '16');
INSERT INTO `t_rights_assign` VALUES ('30', '16');
INSERT INTO `t_rights_assign` VALUES ('34', '16');
INSERT INTO `t_rights_assign` VALUES ('38', '16');
INSERT INTO `t_rights_assign` VALUES ('40', '16');
INSERT INTO `t_rights_assign` VALUES ('42', '16');
INSERT INTO `t_rights_assign` VALUES ('46', '16');
INSERT INTO `t_rights_assign` VALUES ('50', '16');
INSERT INTO `t_rights_assign` VALUES ('100', '16');
INSERT INTO `t_rights_assign` VALUES ('101', '16');
INSERT INTO `t_rights_assign` VALUES ('102', '16');
INSERT INTO `t_rights_assign` VALUES ('103', '16');
INSERT INTO `t_rights_assign` VALUES ('104', '16');
INSERT INTO `t_rights_assign` VALUES ('106', '16');
INSERT INTO `t_rights_assign` VALUES ('108', '16');
INSERT INTO `t_rights_assign` VALUES ('140', '16');
INSERT INTO `t_rights_assign` VALUES ('141', '16');
INSERT INTO `t_rights_assign` VALUES ('142', '16');
INSERT INTO `t_rights_assign` VALUES ('143', '16');
INSERT INTO `t_rights_assign` VALUES ('144', '16');
INSERT INTO `t_rights_assign` VALUES ('146', '16');
INSERT INTO `t_rights_assign` VALUES ('148', '16');
INSERT INTO `t_rights_assign` VALUES ('181', '16');
INSERT INTO `t_rights_assign` VALUES ('182', '16');
INSERT INTO `t_rights_assign` VALUES ('183', '16');
INSERT INTO `t_rights_assign` VALUES ('184', '16');
INSERT INTO `t_rights_assign` VALUES ('185', '16');
INSERT INTO `t_rights_assign` VALUES ('187', '16');
INSERT INTO `t_rights_assign` VALUES ('189', '16');
INSERT INTO `t_rights_assign` VALUES ('192', '16');
INSERT INTO `t_rights_assign` VALUES ('221', '16');
INSERT INTO `t_rights_assign` VALUES ('223', '16');
INSERT INTO `t_rights_assign` VALUES ('227', '16');
INSERT INTO `t_rights_assign` VALUES ('301', '16');
INSERT INTO `t_rights_assign` VALUES ('303', '16');
INSERT INTO `t_rights_assign` VALUES ('305', '16');
INSERT INTO `t_rights_assign` VALUES ('306', '16');
INSERT INTO `t_rights_assign` VALUES ('307', '16');
INSERT INTO `t_rights_assign` VALUES ('308', '16');
INSERT INTO `t_rights_assign` VALUES ('309', '16');
INSERT INTO `t_rights_assign` VALUES ('310', '16');
INSERT INTO `t_rights_assign` VALUES ('312', '16');
INSERT INTO `t_rights_assign` VALUES ('341', '16');
INSERT INTO `t_rights_assign` VALUES ('343', '16');
INSERT INTO `t_rights_assign` VALUES ('345', '16');
INSERT INTO `t_rights_assign` VALUES ('346', '16');
INSERT INTO `t_rights_assign` VALUES ('381', '16');
INSERT INTO `t_rights_assign` VALUES ('383', '16');
INSERT INTO `t_rights_assign` VALUES ('385', '16');
INSERT INTO `t_rights_assign` VALUES ('389', '16');
INSERT INTO `t_rights_assign` VALUES ('390', '16');
INSERT INTO `t_rights_assign` VALUES ('391', '16');
INSERT INTO `t_rights_assign` VALUES ('393', '16');
INSERT INTO `t_rights_assign` VALUES ('394', '16');
INSERT INTO `t_rights_assign` VALUES ('395', '16');
INSERT INTO `t_rights_assign` VALUES ('396', '16');
INSERT INTO `t_rights_assign` VALUES ('397', '16');
INSERT INTO `t_rights_assign` VALUES ('398', '16');
INSERT INTO `t_rights_assign` VALUES ('399', '16');
INSERT INTO `t_rights_assign` VALUES ('400', '16');
INSERT INTO `t_rights_assign` VALUES ('401', '16');
INSERT INTO `t_rights_assign` VALUES ('403', '16');
INSERT INTO `t_rights_assign` VALUES ('421', '16');
INSERT INTO `t_rights_assign` VALUES ('423', '16');
INSERT INTO `t_rights_assign` VALUES ('463', '16');
INSERT INTO `t_rights_assign` VALUES ('467', '16');
INSERT INTO `t_rights_assign` VALUES ('471', '16');
INSERT INTO `t_rights_assign` VALUES ('501', '16');
INSERT INTO `t_rights_assign` VALUES ('502', '16');
INSERT INTO `t_rights_assign` VALUES ('503', '16');
INSERT INTO `t_rights_assign` VALUES ('504', '16');
INSERT INTO `t_rights_assign` VALUES ('505', '16');
INSERT INTO `t_rights_assign` VALUES ('506', '16');
INSERT INTO `t_rights_assign` VALUES ('1', '17');
INSERT INTO `t_rights_assign` VALUES ('2', '17');
INSERT INTO `t_rights_assign` VALUES ('3', '17');
INSERT INTO `t_rights_assign` VALUES ('10', '17');
INSERT INTO `t_rights_assign` VALUES ('14', '17');
INSERT INTO `t_rights_assign` VALUES ('18', '17');
INSERT INTO `t_rights_assign` VALUES ('22', '17');
INSERT INTO `t_rights_assign` VALUES ('30', '17');
INSERT INTO `t_rights_assign` VALUES ('34', '17');
INSERT INTO `t_rights_assign` VALUES ('38', '17');
INSERT INTO `t_rights_assign` VALUES ('40', '17');
INSERT INTO `t_rights_assign` VALUES ('42', '17');
INSERT INTO `t_rights_assign` VALUES ('46', '17');
INSERT INTO `t_rights_assign` VALUES ('50', '17');
INSERT INTO `t_rights_assign` VALUES ('54', '17');
INSERT INTO `t_rights_assign` VALUES ('100', '17');
INSERT INTO `t_rights_assign` VALUES ('101', '17');
INSERT INTO `t_rights_assign` VALUES ('102', '17');
INSERT INTO `t_rights_assign` VALUES ('103', '17');
INSERT INTO `t_rights_assign` VALUES ('104', '17');
INSERT INTO `t_rights_assign` VALUES ('105', '17');
INSERT INTO `t_rights_assign` VALUES ('106', '17');
INSERT INTO `t_rights_assign` VALUES ('107', '17');
INSERT INTO `t_rights_assign` VALUES ('108', '17');
INSERT INTO `t_rights_assign` VALUES ('140', '17');
INSERT INTO `t_rights_assign` VALUES ('141', '17');
INSERT INTO `t_rights_assign` VALUES ('142', '17');
INSERT INTO `t_rights_assign` VALUES ('143', '17');
INSERT INTO `t_rights_assign` VALUES ('144', '17');
INSERT INTO `t_rights_assign` VALUES ('145', '17');
INSERT INTO `t_rights_assign` VALUES ('146', '17');
INSERT INTO `t_rights_assign` VALUES ('147', '17');
INSERT INTO `t_rights_assign` VALUES ('148', '17');
INSERT INTO `t_rights_assign` VALUES ('181', '17');
INSERT INTO `t_rights_assign` VALUES ('182', '17');
INSERT INTO `t_rights_assign` VALUES ('183', '17');
INSERT INTO `t_rights_assign` VALUES ('184', '17');
INSERT INTO `t_rights_assign` VALUES ('185', '17');
INSERT INTO `t_rights_assign` VALUES ('187', '17');
INSERT INTO `t_rights_assign` VALUES ('188', '17');
INSERT INTO `t_rights_assign` VALUES ('189', '17');
INSERT INTO `t_rights_assign` VALUES ('192', '17');
INSERT INTO `t_rights_assign` VALUES ('221', '17');
INSERT INTO `t_rights_assign` VALUES ('222', '17');
INSERT INTO `t_rights_assign` VALUES ('223', '17');
INSERT INTO `t_rights_assign` VALUES ('224', '17');
INSERT INTO `t_rights_assign` VALUES ('226', '17');
INSERT INTO `t_rights_assign` VALUES ('227', '17');
INSERT INTO `t_rights_assign` VALUES ('228', '17');
INSERT INTO `t_rights_assign` VALUES ('301', '17');
INSERT INTO `t_rights_assign` VALUES ('302', '17');
INSERT INTO `t_rights_assign` VALUES ('303', '17');
INSERT INTO `t_rights_assign` VALUES ('304', '17');
INSERT INTO `t_rights_assign` VALUES ('305', '17');
INSERT INTO `t_rights_assign` VALUES ('306', '17');
INSERT INTO `t_rights_assign` VALUES ('308', '17');
INSERT INTO `t_rights_assign` VALUES ('309', '17');
INSERT INTO `t_rights_assign` VALUES ('341', '17');
INSERT INTO `t_rights_assign` VALUES ('342', '17');
INSERT INTO `t_rights_assign` VALUES ('343', '17');
INSERT INTO `t_rights_assign` VALUES ('344', '17');
INSERT INTO `t_rights_assign` VALUES ('345', '17');
INSERT INTO `t_rights_assign` VALUES ('346', '17');
INSERT INTO `t_rights_assign` VALUES ('381', '17');
INSERT INTO `t_rights_assign` VALUES ('382', '17');
INSERT INTO `t_rights_assign` VALUES ('383', '17');
INSERT INTO `t_rights_assign` VALUES ('384', '17');
INSERT INTO `t_rights_assign` VALUES ('385', '17');
INSERT INTO `t_rights_assign` VALUES ('386', '17');
INSERT INTO `t_rights_assign` VALUES ('388', '17');
INSERT INTO `t_rights_assign` VALUES ('389', '17');
INSERT INTO `t_rights_assign` VALUES ('390', '17');
INSERT INTO `t_rights_assign` VALUES ('391', '17');
INSERT INTO `t_rights_assign` VALUES ('392', '17');
INSERT INTO `t_rights_assign` VALUES ('393', '17');
INSERT INTO `t_rights_assign` VALUES ('394', '17');
INSERT INTO `t_rights_assign` VALUES ('395', '17');
INSERT INTO `t_rights_assign` VALUES ('397', '17');
INSERT INTO `t_rights_assign` VALUES ('401', '17');
INSERT INTO `t_rights_assign` VALUES ('403', '17');
INSERT INTO `t_rights_assign` VALUES ('421', '17');
INSERT INTO `t_rights_assign` VALUES ('423', '17');
INSERT INTO `t_rights_assign` VALUES ('461', '17');
INSERT INTO `t_rights_assign` VALUES ('462', '17');
INSERT INTO `t_rights_assign` VALUES ('463', '17');
INSERT INTO `t_rights_assign` VALUES ('464', '17');
INSERT INTO `t_rights_assign` VALUES ('465', '17');
INSERT INTO `t_rights_assign` VALUES ('466', '17');
INSERT INTO `t_rights_assign` VALUES ('467', '17');
INSERT INTO `t_rights_assign` VALUES ('468', '17');
INSERT INTO `t_rights_assign` VALUES ('469', '17');
INSERT INTO `t_rights_assign` VALUES ('470', '17');
INSERT INTO `t_rights_assign` VALUES ('471', '17');
INSERT INTO `t_rights_assign` VALUES ('472', '17');
INSERT INTO `t_rights_assign` VALUES ('501', '17');
INSERT INTO `t_rights_assign` VALUES ('502', '17');
INSERT INTO `t_rights_assign` VALUES ('503', '17');
INSERT INTO `t_rights_assign` VALUES ('504', '17');
INSERT INTO `t_rights_assign` VALUES ('505', '17');
INSERT INTO `t_rights_assign` VALUES ('506', '17');
INSERT INTO `t_rights_assign` VALUES ('541', '17');
INSERT INTO `t_rights_assign` VALUES ('546', '17');
INSERT INTO `t_rights_assign` VALUES ('548', '17');
INSERT INTO `t_rights_assign` VALUES ('550', '17');
INSERT INTO `t_rights_assign` VALUES ('558', '17');
INSERT INTO `t_rights_assign` VALUES ('1', '18');
INSERT INTO `t_rights_assign` VALUES ('2', '18');
INSERT INTO `t_rights_assign` VALUES ('3', '18');
INSERT INTO `t_rights_assign` VALUES ('10', '18');
INSERT INTO `t_rights_assign` VALUES ('14', '18');
INSERT INTO `t_rights_assign` VALUES ('18', '18');
INSERT INTO `t_rights_assign` VALUES ('22', '18');
INSERT INTO `t_rights_assign` VALUES ('30', '18');
INSERT INTO `t_rights_assign` VALUES ('34', '18');
INSERT INTO `t_rights_assign` VALUES ('38', '18');
INSERT INTO `t_rights_assign` VALUES ('40', '18');
INSERT INTO `t_rights_assign` VALUES ('42', '18');
INSERT INTO `t_rights_assign` VALUES ('46', '18');
INSERT INTO `t_rights_assign` VALUES ('50', '18');
INSERT INTO `t_rights_assign` VALUES ('101', '18');
INSERT INTO `t_rights_assign` VALUES ('106', '18');
INSERT INTO `t_rights_assign` VALUES ('107', '18');
INSERT INTO `t_rights_assign` VALUES ('108', '18');
INSERT INTO `t_rights_assign` VALUES ('141', '18');
INSERT INTO `t_rights_assign` VALUES ('146', '18');
INSERT INTO `t_rights_assign` VALUES ('147', '18');
INSERT INTO `t_rights_assign` VALUES ('148', '18');
INSERT INTO `t_rights_assign` VALUES ('182', '18');
INSERT INTO `t_rights_assign` VALUES ('187', '18');
INSERT INTO `t_rights_assign` VALUES ('188', '18');
INSERT INTO `t_rights_assign` VALUES ('189', '18');
INSERT INTO `t_rights_assign` VALUES ('192', '18');
INSERT INTO `t_rights_assign` VALUES ('221', '18');
INSERT INTO `t_rights_assign` VALUES ('223', '18');
INSERT INTO `t_rights_assign` VALUES ('227', '18');
INSERT INTO `t_rights_assign` VALUES ('301', '18');
INSERT INTO `t_rights_assign` VALUES ('302', '18');
INSERT INTO `t_rights_assign` VALUES ('303', '18');
INSERT INTO `t_rights_assign` VALUES ('304', '18');
INSERT INTO `t_rights_assign` VALUES ('305', '18');
INSERT INTO `t_rights_assign` VALUES ('306', '18');
INSERT INTO `t_rights_assign` VALUES ('308', '18');
INSERT INTO `t_rights_assign` VALUES ('310', '18');
INSERT INTO `t_rights_assign` VALUES ('341', '18');
INSERT INTO `t_rights_assign` VALUES ('343', '18');
INSERT INTO `t_rights_assign` VALUES ('345', '18');
INSERT INTO `t_rights_assign` VALUES ('346', '18');
INSERT INTO `t_rights_assign` VALUES ('381', '18');
INSERT INTO `t_rights_assign` VALUES ('382', '18');
INSERT INTO `t_rights_assign` VALUES ('383', '18');
INSERT INTO `t_rights_assign` VALUES ('384', '18');
INSERT INTO `t_rights_assign` VALUES ('385', '18');
INSERT INTO `t_rights_assign` VALUES ('390', '18');
INSERT INTO `t_rights_assign` VALUES ('391', '18');
INSERT INTO `t_rights_assign` VALUES ('392', '18');
INSERT INTO `t_rights_assign` VALUES ('393', '18');
INSERT INTO `t_rights_assign` VALUES ('394', '18');
INSERT INTO `t_rights_assign` VALUES ('395', '18');
INSERT INTO `t_rights_assign` VALUES ('397', '18');
INSERT INTO `t_rights_assign` VALUES ('399', '18');
INSERT INTO `t_rights_assign` VALUES ('401', '18');
INSERT INTO `t_rights_assign` VALUES ('403', '18');
INSERT INTO `t_rights_assign` VALUES ('421', '18');
INSERT INTO `t_rights_assign` VALUES ('423', '18');
INSERT INTO `t_rights_assign` VALUES ('461', '18');
INSERT INTO `t_rights_assign` VALUES ('462', '18');
INSERT INTO `t_rights_assign` VALUES ('463', '18');
INSERT INTO `t_rights_assign` VALUES ('464', '18');
INSERT INTO `t_rights_assign` VALUES ('465', '18');
INSERT INTO `t_rights_assign` VALUES ('466', '18');
INSERT INTO `t_rights_assign` VALUES ('467', '18');
INSERT INTO `t_rights_assign` VALUES ('468', '18');
INSERT INTO `t_rights_assign` VALUES ('469', '18');
INSERT INTO `t_rights_assign` VALUES ('471', '18');
INSERT INTO `t_rights_assign` VALUES ('472', '18');
INSERT INTO `t_rights_assign` VALUES ('501', '18');
INSERT INTO `t_rights_assign` VALUES ('502', '18');
INSERT INTO `t_rights_assign` VALUES ('503', '18');
INSERT INTO `t_rights_assign` VALUES ('504', '18');
INSERT INTO `t_rights_assign` VALUES ('505', '18');
INSERT INTO `t_rights_assign` VALUES ('506', '18');
INSERT INTO `t_rights_assign` VALUES ('1', '20');
INSERT INTO `t_rights_assign` VALUES ('2', '20');
INSERT INTO `t_rights_assign` VALUES ('3', '20');
INSERT INTO `t_rights_assign` VALUES ('10', '20');
INSERT INTO `t_rights_assign` VALUES ('14', '20');
INSERT INTO `t_rights_assign` VALUES ('18', '20');
INSERT INTO `t_rights_assign` VALUES ('22', '20');
INSERT INTO `t_rights_assign` VALUES ('30', '20');
INSERT INTO `t_rights_assign` VALUES ('34', '20');
INSERT INTO `t_rights_assign` VALUES ('38', '20');
INSERT INTO `t_rights_assign` VALUES ('40', '20');
INSERT INTO `t_rights_assign` VALUES ('42', '20');
INSERT INTO `t_rights_assign` VALUES ('46', '20');
INSERT INTO `t_rights_assign` VALUES ('50', '20');
INSERT INTO `t_rights_assign` VALUES ('101', '20');
INSERT INTO `t_rights_assign` VALUES ('141', '20');
INSERT INTO `t_rights_assign` VALUES ('182', '20');
INSERT INTO `t_rights_assign` VALUES ('221', '20');
INSERT INTO `t_rights_assign` VALUES ('223', '20');
INSERT INTO `t_rights_assign` VALUES ('301', '20');
INSERT INTO `t_rights_assign` VALUES ('303', '20');
INSERT INTO `t_rights_assign` VALUES ('306', '20');
INSERT INTO `t_rights_assign` VALUES ('308', '20');
INSERT INTO `t_rights_assign` VALUES ('341', '20');
INSERT INTO `t_rights_assign` VALUES ('343', '20');
INSERT INTO `t_rights_assign` VALUES ('345', '20');
INSERT INTO `t_rights_assign` VALUES ('346', '20');
INSERT INTO `t_rights_assign` VALUES ('381', '20');
INSERT INTO `t_rights_assign` VALUES ('383', '20');
INSERT INTO `t_rights_assign` VALUES ('385', '20');
INSERT INTO `t_rights_assign` VALUES ('389', '20');
INSERT INTO `t_rights_assign` VALUES ('390', '20');
INSERT INTO `t_rights_assign` VALUES ('395', '20');
INSERT INTO `t_rights_assign` VALUES ('401', '20');
INSERT INTO `t_rights_assign` VALUES ('403', '20');
INSERT INTO `t_rights_assign` VALUES ('421', '20');
INSERT INTO `t_rights_assign` VALUES ('423', '20');
INSERT INTO `t_rights_assign` VALUES ('463', '20');
INSERT INTO `t_rights_assign` VALUES ('467', '20');
INSERT INTO `t_rights_assign` VALUES ('471', '20');
INSERT INTO `t_rights_assign` VALUES ('501', '20');
INSERT INTO `t_rights_assign` VALUES ('502', '20');
INSERT INTO `t_rights_assign` VALUES ('503', '20');
INSERT INTO `t_rights_assign` VALUES ('504', '20');
INSERT INTO `t_rights_assign` VALUES ('505', '20');
INSERT INTO `t_rights_assign` VALUES ('506', '20');
INSERT INTO `t_rights_assign` VALUES ('1', '24');
INSERT INTO `t_rights_assign` VALUES ('2', '24');
INSERT INTO `t_rights_assign` VALUES ('3', '24');
INSERT INTO `t_rights_assign` VALUES ('10', '24');
INSERT INTO `t_rights_assign` VALUES ('14', '24');
INSERT INTO `t_rights_assign` VALUES ('18', '24');
INSERT INTO `t_rights_assign` VALUES ('22', '24');
INSERT INTO `t_rights_assign` VALUES ('30', '24');
INSERT INTO `t_rights_assign` VALUES ('34', '24');
INSERT INTO `t_rights_assign` VALUES ('38', '24');
INSERT INTO `t_rights_assign` VALUES ('40', '24');
INSERT INTO `t_rights_assign` VALUES ('42', '24');
INSERT INTO `t_rights_assign` VALUES ('46', '24');
INSERT INTO `t_rights_assign` VALUES ('50', '24');
INSERT INTO `t_rights_assign` VALUES ('101', '24');
INSERT INTO `t_rights_assign` VALUES ('105', '24');
INSERT INTO `t_rights_assign` VALUES ('141', '24');
INSERT INTO `t_rights_assign` VALUES ('145', '24');
INSERT INTO `t_rights_assign` VALUES ('182', '24');
INSERT INTO `t_rights_assign` VALUES ('186', '24');
INSERT INTO `t_rights_assign` VALUES ('192', '24');
INSERT INTO `t_rights_assign` VALUES ('221', '24');
INSERT INTO `t_rights_assign` VALUES ('223', '24');
INSERT INTO `t_rights_assign` VALUES ('227', '24');
INSERT INTO `t_rights_assign` VALUES ('301', '24');
INSERT INTO `t_rights_assign` VALUES ('303', '24');
INSERT INTO `t_rights_assign` VALUES ('305', '24');
INSERT INTO `t_rights_assign` VALUES ('306', '24');
INSERT INTO `t_rights_assign` VALUES ('308', '24');
INSERT INTO `t_rights_assign` VALUES ('309', '24');
INSERT INTO `t_rights_assign` VALUES ('310', '24');
INSERT INTO `t_rights_assign` VALUES ('341', '24');
INSERT INTO `t_rights_assign` VALUES ('343', '24');
INSERT INTO `t_rights_assign` VALUES ('344', '24');
INSERT INTO `t_rights_assign` VALUES ('345', '24');
INSERT INTO `t_rights_assign` VALUES ('346', '24');
INSERT INTO `t_rights_assign` VALUES ('381', '24');
INSERT INTO `t_rights_assign` VALUES ('383', '24');
INSERT INTO `t_rights_assign` VALUES ('385', '24');
INSERT INTO `t_rights_assign` VALUES ('391', '24');
INSERT INTO `t_rights_assign` VALUES ('393', '24');
INSERT INTO `t_rights_assign` VALUES ('394', '24');
INSERT INTO `t_rights_assign` VALUES ('395', '24');
INSERT INTO `t_rights_assign` VALUES ('397', '24');
INSERT INTO `t_rights_assign` VALUES ('398', '24');
INSERT INTO `t_rights_assign` VALUES ('400', '24');
INSERT INTO `t_rights_assign` VALUES ('401', '24');
INSERT INTO `t_rights_assign` VALUES ('403', '24');
INSERT INTO `t_rights_assign` VALUES ('421', '24');
INSERT INTO `t_rights_assign` VALUES ('423', '24');
INSERT INTO `t_rights_assign` VALUES ('461', '24');
INSERT INTO `t_rights_assign` VALUES ('462', '24');
INSERT INTO `t_rights_assign` VALUES ('463', '24');
INSERT INTO `t_rights_assign` VALUES ('464', '24');
INSERT INTO `t_rights_assign` VALUES ('465', '24');
INSERT INTO `t_rights_assign` VALUES ('466', '24');
INSERT INTO `t_rights_assign` VALUES ('467', '24');
INSERT INTO `t_rights_assign` VALUES ('468', '24');
INSERT INTO `t_rights_assign` VALUES ('469', '24');
INSERT INTO `t_rights_assign` VALUES ('471', '24');
INSERT INTO `t_rights_assign` VALUES ('472', '24');
INSERT INTO `t_rights_assign` VALUES ('501', '24');
INSERT INTO `t_rights_assign` VALUES ('502', '24');
INSERT INTO `t_rights_assign` VALUES ('503', '24');
INSERT INTO `t_rights_assign` VALUES ('504', '24');
INSERT INTO `t_rights_assign` VALUES ('505', '24');
INSERT INTO `t_rights_assign` VALUES ('506', '24');
INSERT INTO `t_rights_assign` VALUES ('1', '25');
INSERT INTO `t_rights_assign` VALUES ('2', '25');
INSERT INTO `t_rights_assign` VALUES ('3', '25');
INSERT INTO `t_rights_assign` VALUES ('10', '25');
INSERT INTO `t_rights_assign` VALUES ('14', '25');
INSERT INTO `t_rights_assign` VALUES ('18', '25');
INSERT INTO `t_rights_assign` VALUES ('22', '25');
INSERT INTO `t_rights_assign` VALUES ('30', '25');
INSERT INTO `t_rights_assign` VALUES ('34', '25');
INSERT INTO `t_rights_assign` VALUES ('38', '25');
INSERT INTO `t_rights_assign` VALUES ('40', '25');
INSERT INTO `t_rights_assign` VALUES ('42', '25');
INSERT INTO `t_rights_assign` VALUES ('46', '25');
INSERT INTO `t_rights_assign` VALUES ('50', '25');
INSERT INTO `t_rights_assign` VALUES ('54', '25');
INSERT INTO `t_rights_assign` VALUES ('100', '25');
INSERT INTO `t_rights_assign` VALUES ('101', '25');
INSERT INTO `t_rights_assign` VALUES ('102', '25');
INSERT INTO `t_rights_assign` VALUES ('104', '25');
INSERT INTO `t_rights_assign` VALUES ('106', '25');
INSERT INTO `t_rights_assign` VALUES ('107', '25');
INSERT INTO `t_rights_assign` VALUES ('108', '25');
INSERT INTO `t_rights_assign` VALUES ('109', '25');
INSERT INTO `t_rights_assign` VALUES ('110', '25');
INSERT INTO `t_rights_assign` VALUES ('140', '25');
INSERT INTO `t_rights_assign` VALUES ('141', '25');
INSERT INTO `t_rights_assign` VALUES ('142', '25');
INSERT INTO `t_rights_assign` VALUES ('144', '25');
INSERT INTO `t_rights_assign` VALUES ('146', '25');
INSERT INTO `t_rights_assign` VALUES ('147', '25');
INSERT INTO `t_rights_assign` VALUES ('148', '25');
INSERT INTO `t_rights_assign` VALUES ('149', '25');
INSERT INTO `t_rights_assign` VALUES ('150', '25');
INSERT INTO `t_rights_assign` VALUES ('181', '25');
INSERT INTO `t_rights_assign` VALUES ('182', '25');
INSERT INTO `t_rights_assign` VALUES ('183', '25');
INSERT INTO `t_rights_assign` VALUES ('185', '25');
INSERT INTO `t_rights_assign` VALUES ('187', '25');
INSERT INTO `t_rights_assign` VALUES ('188', '25');
INSERT INTO `t_rights_assign` VALUES ('189', '25');
INSERT INTO `t_rights_assign` VALUES ('190', '25');
INSERT INTO `t_rights_assign` VALUES ('191', '25');
INSERT INTO `t_rights_assign` VALUES ('192', '25');
INSERT INTO `t_rights_assign` VALUES ('221', '25');
INSERT INTO `t_rights_assign` VALUES ('222', '25');
INSERT INTO `t_rights_assign` VALUES ('223', '25');
INSERT INTO `t_rights_assign` VALUES ('224', '25');
INSERT INTO `t_rights_assign` VALUES ('226', '25');
INSERT INTO `t_rights_assign` VALUES ('227', '25');
INSERT INTO `t_rights_assign` VALUES ('228', '25');
INSERT INTO `t_rights_assign` VALUES ('301', '25');
INSERT INTO `t_rights_assign` VALUES ('302', '25');
INSERT INTO `t_rights_assign` VALUES ('303', '25');
INSERT INTO `t_rights_assign` VALUES ('304', '25');
INSERT INTO `t_rights_assign` VALUES ('305', '25');
INSERT INTO `t_rights_assign` VALUES ('306', '25');
INSERT INTO `t_rights_assign` VALUES ('307', '25');
INSERT INTO `t_rights_assign` VALUES ('308', '25');
INSERT INTO `t_rights_assign` VALUES ('309', '25');
INSERT INTO `t_rights_assign` VALUES ('310', '25');
INSERT INTO `t_rights_assign` VALUES ('311', '25');
INSERT INTO `t_rights_assign` VALUES ('313', '25');
INSERT INTO `t_rights_assign` VALUES ('341', '25');
INSERT INTO `t_rights_assign` VALUES ('342', '25');
INSERT INTO `t_rights_assign` VALUES ('343', '25');
INSERT INTO `t_rights_assign` VALUES ('344', '25');
INSERT INTO `t_rights_assign` VALUES ('345', '25');
INSERT INTO `t_rights_assign` VALUES ('346', '25');
INSERT INTO `t_rights_assign` VALUES ('381', '25');
INSERT INTO `t_rights_assign` VALUES ('382', '25');
INSERT INTO `t_rights_assign` VALUES ('383', '25');
INSERT INTO `t_rights_assign` VALUES ('384', '25');
INSERT INTO `t_rights_assign` VALUES ('385', '25');
INSERT INTO `t_rights_assign` VALUES ('386', '25');
INSERT INTO `t_rights_assign` VALUES ('387', '25');
INSERT INTO `t_rights_assign` VALUES ('388', '25');
INSERT INTO `t_rights_assign` VALUES ('389', '25');
INSERT INTO `t_rights_assign` VALUES ('390', '25');
INSERT INTO `t_rights_assign` VALUES ('391', '25');
INSERT INTO `t_rights_assign` VALUES ('392', '25');
INSERT INTO `t_rights_assign` VALUES ('393', '25');
INSERT INTO `t_rights_assign` VALUES ('394', '25');
INSERT INTO `t_rights_assign` VALUES ('395', '25');
INSERT INTO `t_rights_assign` VALUES ('396', '25');
INSERT INTO `t_rights_assign` VALUES ('397', '25');
INSERT INTO `t_rights_assign` VALUES ('398', '25');
INSERT INTO `t_rights_assign` VALUES ('399', '25');
INSERT INTO `t_rights_assign` VALUES ('400', '25');
INSERT INTO `t_rights_assign` VALUES ('401', '25');
INSERT INTO `t_rights_assign` VALUES ('402', '25');
INSERT INTO `t_rights_assign` VALUES ('403', '25');
INSERT INTO `t_rights_assign` VALUES ('404', '25');
INSERT INTO `t_rights_assign` VALUES ('421', '25');
INSERT INTO `t_rights_assign` VALUES ('422', '25');
INSERT INTO `t_rights_assign` VALUES ('423', '25');
INSERT INTO `t_rights_assign` VALUES ('424', '25');
INSERT INTO `t_rights_assign` VALUES ('461', '25');
INSERT INTO `t_rights_assign` VALUES ('462', '25');
INSERT INTO `t_rights_assign` VALUES ('463', '25');
INSERT INTO `t_rights_assign` VALUES ('464', '25');
INSERT INTO `t_rights_assign` VALUES ('465', '25');
INSERT INTO `t_rights_assign` VALUES ('466', '25');
INSERT INTO `t_rights_assign` VALUES ('467', '25');
INSERT INTO `t_rights_assign` VALUES ('468', '25');
INSERT INTO `t_rights_assign` VALUES ('469', '25');
INSERT INTO `t_rights_assign` VALUES ('470', '25');
INSERT INTO `t_rights_assign` VALUES ('471', '25');
INSERT INTO `t_rights_assign` VALUES ('472', '25');
INSERT INTO `t_rights_assign` VALUES ('501', '25');
INSERT INTO `t_rights_assign` VALUES ('502', '25');
INSERT INTO `t_rights_assign` VALUES ('503', '25');
INSERT INTO `t_rights_assign` VALUES ('504', '25');
INSERT INTO `t_rights_assign` VALUES ('505', '25');
INSERT INTO `t_rights_assign` VALUES ('506', '25');
INSERT INTO `t_rights_assign` VALUES ('541', '25');
INSERT INTO `t_rights_assign` VALUES ('542', '25');
INSERT INTO `t_rights_assign` VALUES ('544', '25');
INSERT INTO `t_rights_assign` VALUES ('545', '25');
INSERT INTO `t_rights_assign` VALUES ('546', '25');
INSERT INTO `t_rights_assign` VALUES ('547', '25');
INSERT INTO `t_rights_assign` VALUES ('548', '25');
INSERT INTO `t_rights_assign` VALUES ('549', '25');
INSERT INTO `t_rights_assign` VALUES ('550', '25');
INSERT INTO `t_rights_assign` VALUES ('551', '25');
INSERT INTO `t_rights_assign` VALUES ('552', '25');
INSERT INTO `t_rights_assign` VALUES ('553', '25');
INSERT INTO `t_rights_assign` VALUES ('554', '25');
INSERT INTO `t_rights_assign` VALUES ('555', '25');
INSERT INTO `t_rights_assign` VALUES ('556', '25');
INSERT INTO `t_rights_assign` VALUES ('557', '25');
INSERT INTO `t_rights_assign` VALUES ('558', '25');
INSERT INTO `t_rights_assign` VALUES ('559', '25');
INSERT INTO `t_rights_assign` VALUES ('1', '26');
INSERT INTO `t_rights_assign` VALUES ('2', '26');
INSERT INTO `t_rights_assign` VALUES ('3', '26');
INSERT INTO `t_rights_assign` VALUES ('10', '26');
INSERT INTO `t_rights_assign` VALUES ('14', '26');
INSERT INTO `t_rights_assign` VALUES ('18', '26');
INSERT INTO `t_rights_assign` VALUES ('22', '26');
INSERT INTO `t_rights_assign` VALUES ('30', '26');
INSERT INTO `t_rights_assign` VALUES ('34', '26');
INSERT INTO `t_rights_assign` VALUES ('38', '26');
INSERT INTO `t_rights_assign` VALUES ('40', '26');
INSERT INTO `t_rights_assign` VALUES ('42', '26');
INSERT INTO `t_rights_assign` VALUES ('46', '26');
INSERT INTO `t_rights_assign` VALUES ('50', '26');
INSERT INTO `t_rights_assign` VALUES ('100', '26');
INSERT INTO `t_rights_assign` VALUES ('101', '26');
INSERT INTO `t_rights_assign` VALUES ('102', '26');
INSERT INTO `t_rights_assign` VALUES ('103', '26');
INSERT INTO `t_rights_assign` VALUES ('106', '26');
INSERT INTO `t_rights_assign` VALUES ('107', '26');
INSERT INTO `t_rights_assign` VALUES ('108', '26');
INSERT INTO `t_rights_assign` VALUES ('140', '26');
INSERT INTO `t_rights_assign` VALUES ('141', '26');
INSERT INTO `t_rights_assign` VALUES ('142', '26');
INSERT INTO `t_rights_assign` VALUES ('143', '26');
INSERT INTO `t_rights_assign` VALUES ('146', '26');
INSERT INTO `t_rights_assign` VALUES ('147', '26');
INSERT INTO `t_rights_assign` VALUES ('148', '26');
INSERT INTO `t_rights_assign` VALUES ('181', '26');
INSERT INTO `t_rights_assign` VALUES ('182', '26');
INSERT INTO `t_rights_assign` VALUES ('183', '26');
INSERT INTO `t_rights_assign` VALUES ('184', '26');
INSERT INTO `t_rights_assign` VALUES ('187', '26');
INSERT INTO `t_rights_assign` VALUES ('188', '26');
INSERT INTO `t_rights_assign` VALUES ('189', '26');
INSERT INTO `t_rights_assign` VALUES ('192', '26');
INSERT INTO `t_rights_assign` VALUES ('221', '26');
INSERT INTO `t_rights_assign` VALUES ('223', '26');
INSERT INTO `t_rights_assign` VALUES ('227', '26');
INSERT INTO `t_rights_assign` VALUES ('228', '26');
INSERT INTO `t_rights_assign` VALUES ('301', '26');
INSERT INTO `t_rights_assign` VALUES ('303', '26');
INSERT INTO `t_rights_assign` VALUES ('305', '26');
INSERT INTO `t_rights_assign` VALUES ('306', '26');
INSERT INTO `t_rights_assign` VALUES ('308', '26');
INSERT INTO `t_rights_assign` VALUES ('309', '26');
INSERT INTO `t_rights_assign` VALUES ('310', '26');
INSERT INTO `t_rights_assign` VALUES ('341', '26');
INSERT INTO `t_rights_assign` VALUES ('343', '26');
INSERT INTO `t_rights_assign` VALUES ('345', '26');
INSERT INTO `t_rights_assign` VALUES ('346', '26');
INSERT INTO `t_rights_assign` VALUES ('381', '26');
INSERT INTO `t_rights_assign` VALUES ('382', '26');
INSERT INTO `t_rights_assign` VALUES ('383', '26');
INSERT INTO `t_rights_assign` VALUES ('385', '26');
INSERT INTO `t_rights_assign` VALUES ('389', '26');
INSERT INTO `t_rights_assign` VALUES ('390', '26');
INSERT INTO `t_rights_assign` VALUES ('391', '26');
INSERT INTO `t_rights_assign` VALUES ('392', '26');
INSERT INTO `t_rights_assign` VALUES ('393', '26');
INSERT INTO `t_rights_assign` VALUES ('394', '26');
INSERT INTO `t_rights_assign` VALUES ('395', '26');
INSERT INTO `t_rights_assign` VALUES ('396', '26');
INSERT INTO `t_rights_assign` VALUES ('397', '26');
INSERT INTO `t_rights_assign` VALUES ('398', '26');
INSERT INTO `t_rights_assign` VALUES ('399', '26');
INSERT INTO `t_rights_assign` VALUES ('401', '26');
INSERT INTO `t_rights_assign` VALUES ('403', '26');
INSERT INTO `t_rights_assign` VALUES ('421', '26');
INSERT INTO `t_rights_assign` VALUES ('423', '26');
INSERT INTO `t_rights_assign` VALUES ('461', '26');
INSERT INTO `t_rights_assign` VALUES ('462', '26');
INSERT INTO `t_rights_assign` VALUES ('463', '26');
INSERT INTO `t_rights_assign` VALUES ('464', '26');
INSERT INTO `t_rights_assign` VALUES ('465', '26');
INSERT INTO `t_rights_assign` VALUES ('466', '26');
INSERT INTO `t_rights_assign` VALUES ('467', '26');
INSERT INTO `t_rights_assign` VALUES ('468', '26');
INSERT INTO `t_rights_assign` VALUES ('469', '26');
INSERT INTO `t_rights_assign` VALUES ('470', '26');
INSERT INTO `t_rights_assign` VALUES ('471', '26');
INSERT INTO `t_rights_assign` VALUES ('472', '26');
INSERT INTO `t_rights_assign` VALUES ('501', '26');
INSERT INTO `t_rights_assign` VALUES ('502', '26');
INSERT INTO `t_rights_assign` VALUES ('503', '26');
INSERT INTO `t_rights_assign` VALUES ('504', '26');
INSERT INTO `t_rights_assign` VALUES ('505', '26');
INSERT INTO `t_rights_assign` VALUES ('506', '26');
INSERT INTO `t_rights_assign` VALUES ('2', '28');
INSERT INTO `t_rights_assign` VALUES ('38', '28');
INSERT INTO `t_rights_assign` VALUES ('381', '28');
INSERT INTO `t_rights_assign` VALUES ('383', '28');
INSERT INTO `t_rights_assign` VALUES ('385', '28');
INSERT INTO `t_rights_assign` VALUES ('393', '28');

-- ----------------------------
-- Table structure for t_river
-- ----------------------------
DROP TABLE IF EXISTS `t_river`;
CREATE TABLE `t_river` (
  `id` int(11) NOT NULL,
  `name` varchar(32) NOT NULL DEFAULT '' COMMENT '名称',
  `cate` varchar(32) DEFAULT NULL COMMENT '类型，河流，湖泊',
  `len` float(11,2) DEFAULT '0.00' COMMENT '长度',
  `area` float(11,2) DEFAULT '0.00' COMMENT '流域面积',
  `origin` varchar(32) DEFAULT NULL COMMENT '源头',
  `level` varchar(32) DEFAULT NULL COMMENT '级别，省市县',
  `lat_from` float(11,2) DEFAULT '0.00' COMMENT '起始经度',
  `lat_end` float(11,2) DEFAULT '0.00' COMMENT '经度结束 ',
  `lon_from` float(11,2) DEFAULT '0.00' COMMENT '起始纬度',
  `lon_end` float(11,2) DEFAULT '0.00' COMMENT '纬度，结束 ',
  `describe` varchar(255) DEFAULT NULL COMMENT '描述',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_river
-- ----------------------------

-- ----------------------------
-- Table structure for t_role
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL COMMENT '角色名称',
  `code` varchar(32) NOT NULL COMMENT '角色编码',
  `memo` varchar(64) DEFAULT NULL,
  `time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `bzf_role_code_unique` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_role
-- ----------------------------
INSERT INTO `t_role` VALUES ('1', '系统管理员', '10000', '', null);
INSERT INTO `t_role` VALUES ('2', '河道管理员', '20000', '', '0');
INSERT INTO `t_role` VALUES ('3', '河段管理员', '30000', '', '0');

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户名',
  `username` varchar(32) NOT NULL,
  `password` varchar(32) NOT NULL COMMENT '密码',
  `openid` varchar(32) DEFAULT NULL COMMENT '微信OPENID',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `phone` char(11) DEFAULT NULL COMMENT '联系电话',
  `role_id` int(11) DEFAULT NULL COMMENT '角色ID，外键',
  `disable` char(1) NOT NULL DEFAULT '0' COMMENT '1表示禁用，0表示可用',
  `nickname` varchar(255) DEFAULT NULL,
  `idno` varchar(32) NOT NULL COMMENT '身份证号',
  `company` varchar(64) DEFAULT NULL COMMENT '工作单位',
  `state` varchar(32) DEFAULT NULL COMMENT '审核状态',
  `bind_state` tinyint(32) DEFAULT '1' COMMENT '绑定状态，是否绑定了微信号，是否绑定了手机号',
  `memo` varchar(255) NOT NULL,
  `create_time` varchar(32) DEFAULT NULL COMMENT '创建时间',
  `create_user` varchar(32) DEFAULT NULL COMMENT '创建人',
  `last_login` varchar(32) DEFAULT NULL,
  `last_ip` varchar(32) DEFAULT NULL,
  `email` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_username_unique` (`username`),
  KEY `角色ID外键` (`role_id`),
  CONSTRAINT `t_user_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `t_role` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES ('1', 'admin', 'admin', '管理员811', '//tva1.sinaimg.cn/crop.0.0.118.118.180/5db11ff4gw1e77d3nqrv8j203b03cweg.jpg', '15388094958', '1', '0', '高楼平地起', '', null, null, null, '', '2019-05-01', null, null, null, null);
INSERT INTO `t_user` VALUES ('4', 'test', 'test', null, '//tva1.sinaimg.cn/crop.0.0.118.118.180/5db11ff4gw1e77d3nqrv8j203b03cweg.jpg', '', '2', '0', '刘亮', '', null, null, null, '', '2019-06-09', null, null, null, null);
INSERT INTO `t_user` VALUES ('5', '1212', '', null, null, null, null, '0', '高楼平地起', '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('6', '1212', '', null, null, null, null, '0', '高楼平地起', '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('7', '33223', '', null, null, null, null, '0', '高楼平地起22', '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('8', '2323', '', null, null, null, null, '0', '地起2', '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('9', '2323', '', null, null, null, null, '0', '高楼平地起34', '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('10', '2323', '', null, null, null, null, '0', '高楼平地起34', '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('11', '23', '', null, null, null, null, '0', '高楼平地起34', '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('12', '23', '', null, null, null, null, '0', '高楼平地起', '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('13', '2323', '', null, null, null, null, '0', '高楼平地起34', '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('14', '23', '', null, null, null, null, '0', '高楼平地起34', '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('15', '2323', '', null, null, null, null, '0', '高楼平地起', '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('16', '2323', '', null, null, null, null, '0', '高楼平地起3434', '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('17', '2323', '', null, null, null, null, '0', '343434', '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('18', '2323', '', null, null, null, null, '0', '233', '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('19', '23', '', null, null, null, null, '0', '高楼平地起', '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('20', '2244', '', null, null, null, null, '0', '高楼平地起', '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('21', '3434', '', null, null, null, null, '0', '高楼平地起', '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('22', '34', '', null, null, null, null, '0', '高楼平地起', '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('23', '34', '', null, null, null, null, '0', '高楼平地2', '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('24', '343434', '', null, null, null, null, '0', '高楼平地起', '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('25', '3434', '', null, null, null, null, '0', '高楼平地起', '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('26', '3434', '', null, null, null, null, '0', null, '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('27', '43', '', null, null, null, null, '0', null, '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('28', '34', '', null, null, null, null, '0', null, '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('29', '34', '', null, null, null, null, '0', null, '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('30', '34', '', null, null, null, null, '0', null, '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('31', '3434', '', null, null, null, null, '0', null, '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('32', '34', '', null, null, null, null, '0', null, '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('33', '34', '', null, null, null, null, '0', null, '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('34', '34', '', null, null, null, null, '0', null, '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('35', '34', '', null, null, null, null, '0', null, '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('36', '34', '', null, null, null, null, '0', null, '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('37', '34', '', null, null, null, null, '0', null, '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('38', '34', '', null, null, null, null, '0', null, '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('39', '44', '', null, null, null, null, '0', null, '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('40', '43', '', null, null, null, null, '0', null, '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('41', '34', '', null, null, null, null, '0', null, '', null, null, '1', '', null, null, null, null, null);
INSERT INTO `t_user` VALUES ('42', '545', '', null, null, null, null, '0', null, '', null, null, '1', '', null, null, null, null, null);

-- ----------------------------
-- Table structure for t_weifa
-- ----------------------------
DROP TABLE IF EXISTS `t_weifa`;
CREATE TABLE `t_weifa` (
  `id` int(11) NOT NULL,
  `no` varchar(32) DEFAULT NULL COMMENT '编号',
  `river_id` int(11) DEFAULT NULL COMMENT '河道ID',
  `reach_id` int(11) DEFAULT NULL COMMENT '河段ID',
  `describe` text COMMENT '违法描述',
  `origin` varchar(255) DEFAULT NULL COMMENT '来源，群众举报，巡察发现',
  `occur_date` datetime DEFAULT NULL COMMENT '违法日期',
  `method` varchar(255) DEFAULT NULL COMMENT '处理办法',
  `attach` varchar(255) DEFAULT NULL COMMENT '附件ID，,号隔开',
  `create_user` varchar(32) DEFAULT NULL COMMENT '上传人',
  `create_time` varchar(32) DEFAULT NULL COMMENT '上传时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_weifa
-- ----------------------------

-- ----------------------------
-- Table structure for t_zhifa
-- ----------------------------
DROP TABLE IF EXISTS `t_zhifa`;
CREATE TABLE `t_zhifa` (
  `id` int(11) NOT NULL,
  `no` varchar(32) DEFAULT NULL COMMENT '执法编号 ',
  `weifa_id` int(11) DEFAULT NULL COMMENT '违法信息ID',
  `zhifa_date` varchar(32) DEFAULT NULL COMMENT '执法日期',
  `member` varchar(255) DEFAULT NULL COMMENT '执法人员',
  `type` varchar(255) DEFAULT NULL COMMENT '执法方式',
  `process` varchar(255) DEFAULT NULL COMMENT '执法过程',
  `attach` varchar(255) DEFAULT NULL COMMENT '相关附件(图片或是文件)',
  `create_user` varchar(32) DEFAULT NULL COMMENT '上传人',
  `create_time` varchar(32) DEFAULT NULL COMMENT '上传时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of t_zhifa
-- ----------------------------