wscp-miping/web_cp-mysqldump出来的-可用.sql

-- MySQL dump 10.13  Distrib 8.0.23, for Win64 (x86_64)
--
-- Host: localhost    Database: web_cp
-- ------------------------------------------------------
-- Server version	8.0.23

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `a01`
--

DROP TABLE IF EXISTS `a01`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `a01` (
  `user_uid` varchar(50) NOT NULL COMMENT '主键',
  `bid` varchar(50) DEFAULT NULL COMMENT '部门id',
  `user_name` varchar(50) DEFAULT NULL COMMENT '姓名',
  `sort` int DEFAULT NULL COMMENT '排序',
  `present_occupation` varchar(250) DEFAULT NULL COMMENT '现任职务',
  `del_status` int DEFAULT NULL COMMENT '  //状态 1 为正常 2 为删除状态',
  `birthday` varchar(50) DEFAULT NULL COMMENT '出生年月',
  `immediately_post` varchar(50) DEFAULT NULL COMMENT '原任职务',
  `employment_period` varchar(50) DEFAULT NULL COMMENT '任职时间',
  `system_id` varchar(50) DEFAULT NULL COMMENT '子系统编码',
  `one_card` varchar(50) DEFAULT NULL COMMENT '一卡通',
  `if_sysn_userinfo` int DEFAULT NULL COMMENT '是否同步到用户表 1 是 2否',
  `a01_ext1` varchar(255) DEFAULT NULL COMMENT '扩展1',
  `a01_ext2` varchar(255) DEFAULT NULL COMMENT '扩展2',
  `a01_ext3` varchar(255) DEFAULT NULL COMMENT '扩展3',
  `a01_ext4` varchar(255) DEFAULT NULL COMMENT '扩展4',
  `a01_ext5` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`user_uid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `a01`
--

LOCK TABLES `a01` WRITE;
/*!40000 ALTER TABLE `a01` DISABLE KEYS */;
INSERT INTO `a01` VALUES ('084c67c1804347b014598e9ee9ea7c31','0dbfb1fc9ee04bd7a5803b2b11abe126','测试创建登录2',3,'',1,NULL,NULL,NULL,'89f8b0e5202b064c570c356ff9b4fe5b','123456789',1,'','','','',''),('1d65315737b412995ec05f5f1d005b7c','91c61a07a7a44ae89ef886a42985d340','姓名',3,'',1,NULL,NULL,NULL,'89f8b0e5202b064c570c356ff9b4fe5b','444444444',1,'','','','',''),('2dbcbc8c21f0f27860b89bfbe67f15fa','0dbfb1fc9ee04bd7a5803b2b11abe126','测试创建登录',2,'',1,NULL,NULL,NULL,'89f8b0e5202b064c570c356ff9b4fe5b','321654987',1,'','','','',''),('41ba0a4bc610169efa404f5abfda6768','dbff2fecf3d746d7adb95aa09fc9a9bc','123123',1,'请问请问',1,NULL,NULL,NULL,'89f8b0e5202b064c570c356ff9b4fe5b','635241',1,'','','','',''),('4632ca6309d04a3b0aae2c8dd51a92d9','a9c47ba036324faca2f9a345c7a133f1','测试权限',1,'',1,NULL,NULL,NULL,'89f8b0e5202b064c570c356ff9b4fe5b','789456123',1,'','','','',''),('6b3b93f9f2ec3a2d0a5764623c84594a','0dbfb1fc9ee04bd7a5803b2b11abe126','添加测试人员',1,'',1,NULL,NULL,NULL,'89f8b0e5202b064c570c356ff9b4fe5b','147258369',1,'','','','','');
/*!40000 ALTER TABLE `a01` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `b01`
--

DROP TABLE IF EXISTS `b01`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `b01` (
  `id` varchar(50) NOT NULL COMMENT '主键',
  `disp_order` int DEFAULT NULL COMMENT '排序',
  `dep_name` varchar(200) DEFAULT NULL COMMENT '部门名称',
  `pid` varchar(50) DEFAULT NULL COMMENT '父id',
  `del_status` int DEFAULT NULL COMMENT '状态 1为正常 2为删除',
  `system_id` varchar(50) DEFAULT NULL COMMENT '子系统编码',
  `b01_ext1` varchar(255) DEFAULT NULL COMMENT '扩展字段1',
  `b01_ext2` varchar(255) DEFAULT NULL COMMENT '扩展字段2',
  `b01_ext3` varchar(255) DEFAULT NULL COMMENT '扩展字段3',
  `homologous_dep` varchar(50) DEFAULT NULL COMMENT '数据同步时对应的部门id',
  `path` varchar(1000) DEFAULT NULL COMMENT '父级路劲',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `b01`
--

LOCK TABLES `b01` WRITE;
/*!40000 ALTER TABLE `b01` DISABLE KEYS */;
INSERT INTO `b01` VALUES ('020b32b5521b45528daa91cc84c2775e',4,'liuliuliu6','e35d38d20538468ab244a58e68556c45',1,'89f8b0e5202b064c570c356ff9b4fe5b','','','',NULL,'/-1/e35d38d20538468ab244a58e68556c45/020b32b5521b45528daa91cc84c2775e/'),('0dbfb1fc9ee04bd7a5803b2b11abe126',1,'单位子集','e35d38d20538468ab244a58e68556c45',1,'89f8b0e5202b064c570c356ff9b4fe5b','','','',NULL,'/-1/e35d38d20538468ab244a58e68556c45/0dbfb1fc9ee04bd7a5803b2b11abe126/'),('5128f393ff5448cc94123adae8c07d8d',1,'gogogog','0dbfb1fc9ee04bd7a5803b2b11abe126',1,'89f8b0e5202b064c570c356ff9b4fe5b','','','',NULL,'/-1/e35d38d20538468ab244a58e68556c45/0dbfb1fc9ee04bd7a5803b2b11abe126/5128f393ff5448cc94123adae8c07d8d/'),('91c61a07a7a44ae89ef886a42985d340',6,'liuliuliu7','e35d38d20538468ab244a58e68556c45',1,'89f8b0e5202b064c570c356ff9b4fe5b','','','',NULL,'/-1/e35d38d20538468ab244a58e68556c45/91c61a07a7a44ae89ef886a42985d340/'),('a9c47ba036324faca2f9a345c7a133f1',4,'liuliuliu3','e35d38d20538468ab244a58e68556c45',1,'89f8b0e5202b064c570c356ff9b4fe5b','','','',NULL,'/-1/e35d38d20538468ab244a58e68556c45/a9c47ba036324faca2f9a345c7a133f1/'),('b53ef7b80b184a66af56b7d1e0b95360',4,'liuliuliu4','e35d38d20538468ab244a58e68556c45',1,'89f8b0e5202b064c570c356ff9b4fe5b','','','',NULL,'/-1/e35d38d20538468ab244a58e68556c45/b53ef7b80b184a66af56b7d1e0b95360/'),('ca814c4927ef49bfaa6921a1b0dabb74',3,'liuliuliu2','e35d38d20538468ab244a58e68556c45',1,'89f8b0e5202b064c570c356ff9b4fe5b','','','',NULL,'/-1/e35d38d20538468ab244a58e68556c45/ca814c4927ef49bfaa6921a1b0dabb74/'),('d8868c9b1232485b8d27cbe2b2c68924',2,'liuliuliu','e35d38d20538468ab244a58e68556c45',1,'89f8b0e5202b064c570c356ff9b4fe5b','','','',NULL,'/-1/e35d38d20538468ab244a58e68556c45/d8868c9b1232485b8d27cbe2b2c68924/'),('dbff2fecf3d746d7adb95aa09fc9a9bc',4,'liuliuliu5','e35d38d20538468ab244a58e68556c45',1,'89f8b0e5202b064c570c356ff9b4fe5b','','','',NULL,'/-1/e35d38d20538468ab244a58e68556c45/dbff2fecf3d746d7adb95aa09fc9a9bc/'),('e35d38d20538468ab244a58e68556c45',1,'单位父级','-1',1,'89f8b0e5202b064c570c356ff9b4fe5b','','','',NULL,'/-1/e35d38d20538468ab244a58e68556c45/');
/*!40000 ALTER TABLE `b01` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `custom_report`
--

DROP TABLE IF EXISTS `custom_report`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `custom_report` (
  `id` varchar(50) NOT NULL COMMENT '主键',
  `report_name` varchar(500) DEFAULT NULL COMMENT '报表名称',
  `work_id` int DEFAULT NULL COMMENT '所属工作id',
  `table_id` int DEFAULT NULL COMMENT '所属表id',
  `system_id` varchar(50) DEFAULT NULL COMMENT '子系统id',
  `create_time` varchar(50) DEFAULT NULL COMMENT '创建时间',
  `create_user_id` int DEFAULT NULL COMMENT '创建者id',
  `report_json_str` longtext COMMENT '报表的json格式str',
  `report_type` int DEFAULT NULL COMMENT '1:单人表；2多人表',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `custom_report`
--

LOCK TABLES `custom_report` WRITE;
/*!40000 ALTER TABLE `custom_report` DISABLE KEYS */;
/*!40000 ALTER TABLE `custom_report` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dep_b01`
--

DROP TABLE IF EXISTS `dep_b01`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `dep_b01` (
  `id` varchar(50) NOT NULL COMMENT 'id',
  `bid` varchar(50) DEFAULT NULL COMMENT '部门id',
  `dg_id` varchar(50) DEFAULT NULL COMMENT '部门分组id',
  `wid` int DEFAULT NULL COMMENT '工作id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dep_b01`
--

LOCK TABLES `dep_b01` WRITE;
/*!40000 ALTER TABLE `dep_b01` DISABLE KEYS */;
/*!40000 ALTER TABLE `dep_b01` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dep_group`
--

DROP TABLE IF EXISTS `dep_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `dep_group` (
  `id` varchar(50) NOT NULL,
  `dep_group_name` varchar(50) DEFAULT NULL COMMENT '部门名称',
  `del_status` int DEFAULT NULL COMMENT '是否删除,1为正常 2为删除',
  `wid` int DEFAULT NULL COMMENT '工作id',
  `sort` int DEFAULT NULL COMMENT '排序',
  `system_id` varchar(50) DEFAULT NULL COMMENT '子系统id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dep_group`
--

LOCK TABLES `dep_group` WRITE;
/*!40000 ALTER TABLE `dep_group` DISABLE KEYS */;
/*!40000 ALTER TABLE `dep_group` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dep_middle_table`
--

DROP TABLE IF EXISTS `dep_middle_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `dep_middle_table` (
  `dep_id` varchar(50) NOT NULL COMMENT '部门id',
  `parent_id` varchar(50) DEFAULT NULL COMMENT '父节点',
  `dep_name` varchar(200) DEFAULT NULL COMMENT '部门名称',
  `dep_sort` int DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`dep_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dep_middle_table`
--

LOCK TABLES `dep_middle_table` WRITE;
/*!40000 ALTER TABLE `dep_middle_table` DISABLE KEYS */;
/*!40000 ALTER TABLE `dep_middle_table` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dfileinfo`
--

DROP TABLE IF EXISTS `dfileinfo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `dfileinfo` (
  `f_id` varchar(50) NOT NULL COMMENT 'id',
  `f_file_title` varchar(500) DEFAULT NULL COMMENT '文件名',
  `f_file_address` varchar(500) DEFAULT NULL COMMENT '文件地址',
  `f_file_ext` varchar(50) DEFAULT NULL COMMENT '文件后缀',
  `f_file_add_time` varchar(50) DEFAULT NULL COMMENT '文件添加时间',
  PRIMARY KEY (`f_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dfileinfo`
--

LOCK TABLES `dfileinfo` WRITE;
/*!40000 ALTER TABLE `dfileinfo` DISABLE KEYS */;
/*!40000 ALTER TABLE `dfileinfo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `display_field`
--

DROP TABLE IF EXISTS `display_field`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `display_field` (
  `id` varchar(50) NOT NULL,
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `default_name` varchar(50) DEFAULT NULL COMMENT '默认名称',
  `sort` int DEFAULT NULL COMMENT '排序',
  `whether_show` int DEFAULT NULL COMMENT '是否展示(0:不展示; 1:展示;)',
  `table_id` int DEFAULT NULL COMMENT '考评表id',
  `field` varchar(50) DEFAULT NULL COMMENT '字段名',
  `from_name` varchar(50) DEFAULT NULL COMMENT '值存在哪个表的表名',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `display_field`
--

LOCK TABLES `display_field` WRITE;
/*!40000 ALTER TABLE `display_field` DISABLE KEYS */;
INSERT INTO `display_field` VALUES ('0d8cca445b43feb85f4b55860c6154b4','单位扩展1','单位扩展1',1,0,2,'b01_ext1','b01'),('13fd6029e7e7236548044eee6a6d4b66','人员扩展2','人员扩展2',5,0,2,'a01_ext2','a01'),('4a1193920c08f0ba56ca1eb286fac848','单位','单位',9,0,2,'dep_name','b01'),('57c5be9f0a50d1026a5d4e59b13b6d09','单位扩展1','单位扩展1',1,0,1,'b01_ext1','b01'),('6fb1a6b8a7beca0de54d9ac1ad746a9a','职务','职务',10,0,1,'present_occupation','a01'),('70cc030d9f297d03f3c1133e9db4b4e5','人员扩展5','人员扩展5',8,0,1,'a01_ext5','a01'),('73e250fe6ff81c9f97df29d625e0f9aa','单位','单位',9,0,1,'dep_name','b01'),('88f0837e074ca8b9776056c86c6bf1a5','人员扩展1','人员扩展1',4,0,1,'a01_ext1','a01'),('8c8067dd123bc27a5e05b3017abf7496','单位扩展3','单位扩展3',3,0,1,'b01_ext3','b01'),('8ea50a21308426cf54d5520db46aaa59','人员扩展2','人员扩展2',5,0,1,'a01_ext2','a01'),('9664462edaf3cf6b35574ca703c08d42','单位扩展2','单位扩展2',2,0,2,'b01_ext2','b01'),('9c830e8202b0c39c20d86bf25de8c1c9','人员扩展4','人员扩展4',7,0,2,'a01_ext4','a01'),('a5c0a876148b79b15cb21ee75dde099f','职务','职务',10,0,2,'present_occupation','a01'),('b62394059cc3807faacb9bd390596231','人员扩展4','人员扩展4',7,0,1,'a01_ext4','a01'),('d040aff338efe83eab0ca42f61b7768d','单位扩展3','单位扩展3',3,0,2,'b01_ext3','b01'),('d4331a23adc2fdb31f8d2f2d9a6dce38','人员扩展1','人员扩展1',4,0,2,'a01_ext1','a01'),('dbeb3a262c9186d109cd0621c0e3f26a','人员扩展3','人员扩展3',6,0,1,'a01_ext3','a01'),('e7375377153541275096fc2b7b3addc8','单位扩展2','单位扩展2',2,0,1,'b01_ext2','b01'),('e757c6d9f98bd2120bd9cc306ea5fc56','人员扩展5','人员扩展5',8,0,2,'a01_ext5','a01'),('f3acb9ef716558eff9bba4366f3b9976','人员扩展3','人员扩展3',6,0,2,'a01_ext3','a01');
/*!40000 ALTER TABLE `display_field` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fillin_status`
--

DROP TABLE IF EXISTS `fillin_status`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `fillin_status` (
  `id` varchar(50) NOT NULL COMMENT '主键id',
  `table_id` int DEFAULT NULL COMMENT '考评表id',
  `kp_object_id` varchar(50) DEFAULT NULL COMMENT '被评对象id',
  `write_id` int DEFAULT NULL COMMENT '填报用户id',
  `fillin_status` int DEFAULT NULL COMMENT '填写状态(1:未填写/2:填写中/3:填写完成)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fillin_status`
--

LOCK TABLES `fillin_status` WRITE;
/*!40000 ALTER TABLE `fillin_status` DISABLE KEYS */;
/*!40000 ALTER TABLE `fillin_status` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fillin_status_1`
--

DROP TABLE IF EXISTS `fillin_status_1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `fillin_status_1` (
  `id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键id',
  `table_id` int DEFAULT NULL COMMENT '考评表id',
  `kp_object_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '被评对象id',
  `write_id` int DEFAULT NULL COMMENT '填报用户id',
  `fillin_status` int DEFAULT NULL COMMENT '填写状态(1:未填写/2:填写中/3:填写完成)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fillin_status_1`
--

LOCK TABLES `fillin_status_1` WRITE;
/*!40000 ALTER TABLE `fillin_status_1` DISABLE KEYS */;
INSERT INTO `fillin_status_1` VALUES ('3f6fd40c764545a990cd4926324c9790',1,'d8868c9b1232485b8d27cbe2b2c68924',16,3),('51830759e4f848ae8be90545a51dce2c',1,'020b32b5521b45528daa91cc84c2775e',16,3),('91033c9e158740f6bcb116dc2ad8f072',1,'ca814c4927ef49bfaa6921a1b0dabb74',16,3),('9249181914b8475b97f8b55e6ec95576',2,'fec063695deb4d698030b816da868ee1',16,3),('a2123a73bdcb4ccfa02f51e2daf63ba4',2,'55b467c546de422d829623e9158f191f',16,3),('ccbca81897794798b0eb93b9332ed85f',2,'582629f07b174cba871fd7ba145dedbe',16,3),('f55848d09db1408390173e6892aaba8f',1,'a9c47ba036324faca2f9a345c7a133f1',16,3);
/*!40000 ALTER TABLE `fillin_status_1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kp_assessor_identity`
--

DROP TABLE IF EXISTS `kp_assessor_identity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kp_assessor_identity` (
  `id` varchar(50) NOT NULL COMMENT '主键id',
  `name` varchar(50) DEFAULT NULL COMMENT '填表人身份名称',
  `weights` double DEFAULT NULL COMMENT '权重',
  `sort` int DEFAULT NULL COMMENT '排序',
  `table_id` varchar(50) DEFAULT NULL COMMENT '考评表id',
  `del_status` int DEFAULT NULL COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kp_assessor_identity`
--

LOCK TABLES `kp_assessor_identity` WRITE;
/*!40000 ALTER TABLE `kp_assessor_identity` DISABLE KEYS */;
/*!40000 ALTER TABLE `kp_assessor_identity` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kp_batch_identity_1`
--

DROP TABLE IF EXISTS `kp_batch_identity_1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kp_batch_identity_1` (
  `id` varchar(50) NOT NULL COMMENT '主键',
  `pc_id` varchar(50) DEFAULT NULL COMMENT '批次id',
  `write_id` int DEFAULT NULL COMMENT '填报id',
  `table_id` int DEFAULT NULL COMMENT '所属考评表id',
  `filler_identity_id` varchar(50) DEFAULT NULL COMMENT '填表人身份id',
  `add_time` varchar(50) DEFAULT NULL COMMENT '时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kp_batch_identity_1`
--

LOCK TABLES `kp_batch_identity_1` WRITE;
/*!40000 ALTER TABLE `kp_batch_identity_1` DISABLE KEYS */;
/*!40000 ALTER TABLE `kp_batch_identity_1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kp_batch_table`
--

DROP TABLE IF EXISTS `kp_batch_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kp_batch_table` (
  `id` varchar(50) NOT NULL COMMENT '主键(批次id)',
  `name` varchar(200) DEFAULT NULL COMMENT '批次名',
  `start_time` varchar(50) DEFAULT NULL COMMENT '填报开始时间',
  `end_time` varchar(50) DEFAULT NULL COMMENT '填报结束时间',
  `del_status` int DEFAULT NULL COMMENT '是否删除',
  `create_time` varchar(50) DEFAULT NULL COMMENT '创建时间',
  `last_update` varchar(50) DEFAULT NULL COMMENT '上次跟新这条记录时间',
  `work_id` varchar(50) DEFAULT NULL COMMENT '考评工作id',
  `remark` int DEFAULT NULL COMMENT '实际参加人数',
  `system_id` varchar(50) DEFAULT NULL COMMENT '子系统id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kp_batch_table`
--

LOCK TABLES `kp_batch_table` WRITE;
/*!40000 ALTER TABLE `kp_batch_table` DISABLE KEYS */;
INSERT INTO `kp_batch_table` VALUES ('a3990d83af973bd48e58def890054791','批次1','2022-01-24 22:49:21','2022-01-27 22:49:21',1,'2022-01-24 22:49:16',NULL,'1',1,'89f8b0e5202b064c570c356ff9b4fe5b');
/*!40000 ALTER TABLE `kp_batch_table` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kp_filter_relation_1`
--

DROP TABLE IF EXISTS `kp_filter_relation_1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kp_filter_relation_1` (
  `id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
  `work_id` int DEFAULT NULL COMMENT '考评工作id',
  `pc_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '批次id',
  `write_id` int DEFAULT NULL COMMENT '填报用户id',
  `table_id` int DEFAULT NULL COMMENT '考评表id',
  `object_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '被评对象id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kp_filter_relation_1`
--

LOCK TABLES `kp_filter_relation_1` WRITE;
/*!40000 ALTER TABLE `kp_filter_relation_1` DISABLE KEYS */;
/*!40000 ALTER TABLE `kp_filter_relation_1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kp_regulation`
--

DROP TABLE IF EXISTS `kp_regulation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kp_regulation` (
  `rule_id` varchar(50) NOT NULL COMMENT '主键',
  `work_id` int DEFAULT NULL COMMENT '考评工作id',
  `table_id` int DEFAULT NULL COMMENT '考评表id',
  `question_type` varchar(50) DEFAULT NULL COMMENT '题目类型（1：选择题；2：打分题）',
  `left_comparator` varchar(50) DEFAULT NULL COMMENT '左边比较符（1：大于；2等于；3：大于等于）',
  `left_compare_val` double DEFAULT NULL COMMENT '左区间值',
  `right_comparator` varchar(50) DEFAULT NULL COMMENT '右边比较符（1：小于；2等于；3：小于等于）',
  `right_compare_val` double DEFAULT NULL COMMENT '右区间值',
  `rule_setting_type` int DEFAULT NULL COMMENT '规则设置类型（1：到单个被评对象；2：到单个部门；3到多个部门）',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `add_time` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL COMMENT '新增时间',
  `create_uid` int DEFAULT NULL COMMENT '创建者id',
  `del_status` int DEFAULT NULL COMMENT '是否删除(1:正常,2:删除)',
  `setting_number` int DEFAULT NULL COMMENT '打分提设置分数范围（只有打分提这个值才有用）',
  `setting_comparator` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL COMMENT '打分题分范围比较符',
  `table_status` int DEFAULT NULL COMMENT '是否单表保存验证 不验证（默认）1  验证2',
  PRIMARY KEY (`rule_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kp_regulation`
--

LOCK TABLES `kp_regulation` WRITE;
/*!40000 ALTER TABLE `kp_regulation` DISABLE KEYS */;
/*!40000 ALTER TABLE `kp_regulation` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kp_regulation_dep_mapping`
--

DROP TABLE IF EXISTS `kp_regulation_dep_mapping`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kp_regulation_dep_mapping` (
  `id` varchar(50) NOT NULL COMMENT '主键',
  `rule_id` varchar(50) DEFAULT NULL COMMENT '所属规则id',
  `dep_id` varchar(50) DEFAULT NULL COMMENT '部门id',
  `add_time` varchar(50) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kp_regulation_dep_mapping`
--

LOCK TABLES `kp_regulation_dep_mapping` WRITE;
/*!40000 ALTER TABLE `kp_regulation_dep_mapping` DISABLE KEYS */;
/*!40000 ALTER TABLE `kp_regulation_dep_mapping` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kp_regulation_detail`
--

DROP TABLE IF EXISTS `kp_regulation_detail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kp_regulation_detail` (
  `rule_detail_id` varchar(50) NOT NULL COMMENT '主键',
  `rule_id` varchar(50) DEFAULT NULL COMMENT '所属规则',
  `kp_option_id` int DEFAULT NULL COMMENT '考评项目id',
  `kp_option_name` varchar(255) DEFAULT NULL COMMENT '考评项目名称',
  `add_time` varchar(50) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`rule_detail_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kp_regulation_detail`
--

LOCK TABLES `kp_regulation_detail` WRITE;
/*!40000 ALTER TABLE `kp_regulation_detail` DISABLE KEYS */;
/*!40000 ALTER TABLE `kp_regulation_detail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kp_result_1_other`
--

DROP TABLE IF EXISTS `kp_result_1_other`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kp_result_1_other` (
  `id` varchar(50) NOT NULL COMMENT '主键 uuid',
  `table_id` int DEFAULT NULL COMMENT '测评表id',
  `table_name` varchar(1000) DEFAULT NULL COMMENT '测评表名',
  `kp_object_id` text COMMENT '考评对象id',
  `kp_object_name` text COMMENT '考评对象名称',
  `kp_head` varchar(1000) DEFAULT NULL COMMENT '考评项目',
  `kp_item` varchar(1000) DEFAULT NULL COMMENT '考评选项',
  `tb_identity` varchar(1000) DEFAULT NULL COMMENT '填报人身份',
  `sign_val` varchar(1000) DEFAULT NULL,
  `result` varchar(2000) DEFAULT NULL COMMENT '结果',
  `type` int DEFAULT NULL COMMENT '类型 1应评人数；2提交人数；3提交率；4结果排名；5班子排名；',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kp_result_1_other`
--

LOCK TABLES `kp_result_1_other` WRITE;
/*!40000 ALTER TABLE `kp_result_1_other` DISABLE KEYS */;
INSERT INTO `kp_result_1_other` VALUES ('04b86403-57ca-48f6-b8c6-0bc3596da6d2',2,'人员表','55b467c546de422d829623e9158f191f','3c934b802d7e034408ea889cca8b5682','','','无身份','MEUCIQCfP8KlOM+AzsxqDn1YmckZ4GdW/EJVUHozqruaHIPWMAIgS3mvg+Zu0vw3ox3Lrvt0VT0uf/UC73Y2psqNXtZTuQc=','10',1),('2c24eecc-2b40-47a0-886c-402081db80ce',1,'班子表','020b32b5521b45528daa91cc84c2775e','3729553e6491a735c277376aaec2a804','','','无身份','MEUCIQCvf/t4Z2jFRV4CuZ1Pk1dYdsuuTRgGNuvtieYV5MAH1wIgE6v2Wor+z7BcQWL32Nga5aFC720dcYeEEcM6HSH63CY=','1',2),('3a8956f0-ed6d-45c8-a3fb-1c31132792ca',2,'人员表','582629f07b174cba871fd7ba145dedbe','dc49f009a1d201843b66852b563a290c','','','无身份','MEQCICqIzNe0csVvO49tQm2/hm/LI6b6Ha4gnHJzTHwus2qJAiAt7VsIbPDpnx7bgycRUwikSIj93XwqkKvq6qBNvlmu5A==','0.100000',3),('3e197d28-486c-42e5-8f2a-7e9ac30ce501',2,'人员表','fec063695deb4d698030b816da868ee1','dbcf498cb44bf583c75ae272e9d7219d','','','无身份','MEQCIHwEY6Mh3BZsZr8wZVQoNX4e6YQ91+4Fw+/IiD3y6WKzAiBIZs5MoS/dZOHvIfOQSHfeq0NGIjW8iIg2OpRLnKotYQ==','0.100000',3),('477da374-f104-401f-9f9b-2ea5833a07f9',2,'人员表','582629f07b174cba871fd7ba145dedbe','dc49f009a1d201843b66852b563a290c','','','无身份','MEQCIFN78ZKlb+sgp7DneaNEXoc4lKhMFJXur4yrIh5UwYr+AiBljJQ2EhUHHSgFp2ELeK9PvifW9hrpBqG81frm+SWHLg==','1',2),('4ccc8ce9-48ef-4a5e-8031-4ffb4b18a2b1',1,'班子表','d8868c9b1232485b8d27cbe2b2c68924','f2018983bbed11adf85a5a6821251978','','','无身份','MEYCIQCaLQouSfQdRA9rn4cvyK3WN+DG+6JPgHXxS3KmGLTVlQIhAL5xw6r8Hev4lQUZbDoZMP/cupEav602vAujq0U/dQoP','0.100000',3),('5857502e-49df-46df-8e10-0c1336c533ca',2,'人员表','582629f07b174cba871fd7ba145dedbe','dc49f009a1d201843b66852b563a290c','','','无身份','MEUCIFGuOGo4m9/9adMM8tL478HojWf2wJsMoERdtho55L6gAiEA/Pnbz7irL2QGu+sSXSzAVfqCF3gBrcOjAvOrMkR2rag=','10',1),('787e1a62-85d1-44ec-bdfb-bb95c5b9681c',2,'人员表','55b467c546de422d829623e9158f191f','3c934b802d7e034408ea889cca8b5682','','','无身份','MEUCIA+mQfWiIp9v1NHXG1Esde3/1WjwVFzeO6k5FotuJpMFAiEAxWILk/cB8r49QdfFNbLaRRUsSc6TNVmYUyhLLGMp/YM=','0.100000',3),('97402db4-2b33-4459-831d-ec28fc38db4b',1,'班子表','a9c47ba036324faca2f9a345c7a133f1','6b8837130ae0f48258d2b1f0732a574b','','','无身份','MEYCIQDdAT0CVP+gzmwc3X81J2+AZw+dXI261KsOAA2kwoYpSAIhAPgEXGkssIo3+41V/Hk9q0cRaDz1nTBkUTTrfe3hxMQE','1',2),('a6203d09-5050-4e9c-ac28-b32b349e830c',1,'班子表','d8868c9b1232485b8d27cbe2b2c68924','f2018983bbed11adf85a5a6821251978','','','无身份','MEUCIGgngZLGVm2c0wEHjFI/us/X+pfgenxD1H5mNX3/8EVZAiEAsHDWDuTwiCCX0nvwpfeh0QTMz0XXzgtgDyYQPNpjl60=','10',1),('ba772b13-7abd-4aac-a861-b6e1c09cc1b5',1,'班子表','ca814c4927ef49bfaa6921a1b0dabb74','a0ff1b1c70f557a2e8d85094eab7a5ad','','','无身份','MEYCIQCgQgzadptFfXfPGsBMP/HYQvnFWlkrQLE0WMcoSp1ucQIhAKv6uEVQHtrGtqAB3I6SaA0O+EMBMi8T0aDFGg63Ydqi','0.100000',3),('cd9a4e8d-e7ba-4884-8b63-4a34f9fd583e',1,'班子表','d8868c9b1232485b8d27cbe2b2c68924','f2018983bbed11adf85a5a6821251978','','','无身份','MEQCICpyp/4Zb7eXcAh4YkDZNmXrRNuzh6idGxeYi7OLhoNjAiAiEqhUJWeZs3hr/Ga0mf0symTopuVbImQnKtQJ/ShBiw==','1',2),('d926ddb6-0457-4815-b2dc-285ad4775dbd',2,'人员表','fec063695deb4d698030b816da868ee1','dbcf498cb44bf583c75ae272e9d7219d','','','无身份','MEYCIQDl5wSB5Fq7mHh6JyEituaFoV2iJLMYHaVWk/L8UhJIyQIhAO3/jGJ38i1dwCNeKxPhYhJcXVGVb2zq1KThhdlc6/g+','10',1),('d95dae1b-6b19-48da-ab05-41076adf65a8',1,'班子表','ca814c4927ef49bfaa6921a1b0dabb74','a0ff1b1c70f557a2e8d85094eab7a5ad','','','无身份','MEUCIB9yWrQz2whnrzJYu+/ItTOYxaQoeh4K0sIoUWU1TSN+AiEAh7MrIIG/eNwWy0C6jWams8SWm3568yU/ujs1OL7qwN4=','1',2),('dc1cb9f8-6da8-4480-ab5a-641060d0c6fd',2,'人员表','55b467c546de422d829623e9158f191f','3c934b802d7e034408ea889cca8b5682','','','无身份','MEUCIQCSamtMfHiu1QV5QEaFJJD82LlN+TvcG9IJ+FY0c7kkQwIgVwRCskzRNTcGtLlSx1+v27PihPuArEEnz+1qrNC3hFA=','1',2),('ddae1e77-7f6d-451e-9eb0-d04c22845edf',1,'班子表','a9c47ba036324faca2f9a345c7a133f1','6b8837130ae0f48258d2b1f0732a574b','','','无身份','MEUCIQDiwR5C1GKCLgH/BcvNslHKtBG78k9UOnB/XCaVBs9EMQIgMKvMHvflgf8mChxdNnzB0sMNx5PFkFrwQwQx/osneHM=','0.100000',3),('ddc9361c-6a71-4897-b97e-215b26ea43b9',1,
/*!40000 ALTER TABLE `kp_result_1_other` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kp_result_1_poll`
--

DROP TABLE IF EXISTS `kp_result_1_poll`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kp_result_1_poll` (
  `id` varchar(50) NOT NULL COMMENT '主键 uuid',
  `table_id` int DEFAULT NULL COMMENT '测评表id',
  `table_name` varchar(1000) DEFAULT NULL COMMENT '测评表名',
  `kp_object_id` text COMMENT '考评对象id',
  `kp_object_name` text COMMENT '考评对象名称',
  `kp_head` varchar(1000) DEFAULT NULL COMMENT '考评项目',
  `kp_item` varchar(1000) DEFAULT NULL COMMENT '考评选项',
  `tb_identity` varchar(1000) DEFAULT NULL COMMENT '填报人身份',
  `sign_val` varchar(1000) DEFAULT NULL,
  `result` varchar(2000) DEFAULT NULL COMMENT '结果',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kp_result_1_poll`
--

LOCK TABLES `kp_result_1_poll` WRITE;
/*!40000 ALTER TABLE `kp_result_1_poll` DISABLE KEYS */;
INSERT INTO `kp_result_1_poll` VALUES ('008ce145-ff65-45ed-a666-bc279500bee1',1,'班子表','020b32b5521b45528daa91cc84c2775e','3729553e6491a735c277376aaec2a804','测评项目3','B','无身份','MEYCIQCfoN00+w38Oe4jhERS0OJDBpR8ph3RlmiugP7RUfxt1QIhAM71Hn1D+riwhDwUeVOSt+6bsO0DM2Q3kp69ljUe9+37','0'),('009f7092-5b70-461a-bb09-c9e3e895f604',1,'班子表','020b32b5521b45528daa91cc84c2775e','3729553e6491a735c277376aaec2a804','测评项目2','D','无身份','MEQCIDsza/V3ZipiydpHYwvFX0RrR1JMuPaQmntVI/FxW6x/AiALF6af1emwQD6gSI/BaGRoFVyMR7w3jS1m6ExGvt901g==','0'),('026b171d-4a34-4200-a543-e729d366b231',1,'班子表','d8868c9b1232485b8d27cbe2b2c68924','f2018983bbed11adf85a5a6821251978','测评项目2','D','无身份','MEQCIBnP9edgMZHZeBMu3Ykb0fSPfBDpkdHEfxQqc2m1CuyRAiBYp+8LyBTigprNgdX6PRGcjBlAYpMHr72oHm9v6MqcwQ==','0'),('03856f21-15ab-458b-b72d-c0676d314d35',1,'班子表','020b32b5521b45528daa91cc84c2775e','3729553e6491a735c277376aaec2a804','测评项目2','C','$合计$','MEQCIHZg00bVK/nxUaf0U6Ac1r7+STCK41Re2exJvN3qeZYkAiA98GOnsTVrYAs87eEaeddf69nzmK6mjugYvBx/2yiXcA==','0'),('03c7a7c2-bbcd-4597-a978-3aa8dafe72d7',1,'班子表','020b32b5521b45528daa91cc84c2775e','3729553e6491a735c277376aaec2a804','测评项目1','A','无身份','MEUCIQD7UA2x4/OEEnglaRVoYsV4ENQBdp//C+bEhTpOCywQDQIgDKHe/WbyMPKsOsx06F/TcR3PI82ixqzXkKtkcihBaZg=','1'),('03c834d3-e59c-4833-9024-c12aa5567b7e',1,'班子表','a9c47ba036324faca2f9a345c7a133f1','6b8837130ae0f48258d2b1f0732a574b','测评项目1','D','无身份','MEUCIB+stO2AHG+UnYm21ZGkuaXpkb3ESnWKERS4a2McV1noAiEA4cz8FBI8gefcuRoOWKtjBNo5LVwn6x6zMsM9BZqiDWQ=','0'),('0625fdc9-5f9b-44df-9855-255f185936df',2,'人员表','fec063695deb4d698030b816da868ee1','dbcf498cb44bf583c75ae272e9d7219d','能','$未填$','无身份','MEUCIQC1FH++10uXBHSdfRXUvEBBm60kymqXDNcjO5ME+iBXdwIgTNaC7/5OFAlxTbLC5xcrNoOLHTadJu1xqT28TGxAsOc=','0'),('06dce210-3cd1-49e2-b08b-df4cd9d1e9fe',1,'班子表','020b32b5521b45528daa91cc84c2775e','3729553e6491a735c277376aaec2a804','测评项目3','A','无身份','MEUCIQDkqH3B2ZJzBxgRPCGZ63FNJPAzoOFH3+vCv05l3r0cCwIgQUWWkvFnkoZ89s1+Kr86KZ6b917/kD76QrtroUVMNkk=','1'),('08be79ae-17e5-4065-aec2-e0331799fb2b',2,'人员表','55b467c546de422d829623e9158f191f','3c934b802d7e034408ea889cca8b5682','德','A','$合计$','MEQCIGQv84yzBkskeC/KxrkbUXg53h4tfBRuJVLNaBJ5B8RuAiAA+y0fHSKzDl5qt7zTinFc5EW5PLpG+kWqlkY8C1Gjfw==','1'),('0930558d-0601-4daf-80e1-72118ad8bb49',1,'班子表','d8868c9b1232485b8d27cbe2b2c68924','f2018983bbed11adf85a5a6821251978','测评项目3','A','无身份','MEUCIBsnunwN/lD6IUGRyfWse17n+bEwDHXIPgvwewCtBPOBAiEApaednoqcjwP4WuDSdMAJojIpmi5fVY8DAPAkPf0bThQ=','1'),('09c2f0f6-11df-4e5f-b2d2-fcb7542c08be',1,'班子表','ca814c4927ef49bfaa6921a1b0dabb74','a0ff1b1c70f557a2e8d85094eab7a5ad','测评项目3','B','$合计$','MEQCIEsENzqNW/rCnFCnaMFFK1D7ILqshw8fR1f2LjXgHCcMAiBbWu/u1MhDG60hZ8v9n2oIbXFRHRXoRoEmGdrPhXP7ew==','0'),('0acbf593-3143-43da-a92b-4fb16eaabbf4',1,'班子表','ca814c4927ef49bfaa6921a1b0dabb74','a0ff1b1c70f557a2e8d85094eab7a5ad','测评项目3','A','$合计$','MEYCIQC0XuUVoZz3/ChwEhLWYmA3Yu2H13rwWwtMAtKstE4NzgIhAISKLI7DhDdVTXKrLENLCa0zoyFBbCpwzYrmX3L88BpP','1'),('0c083d38-a58c-4976-a42a-9e542420e197',1,'班子表','a9c47ba036324faca2f9a345c7a133f1','6b8837130ae0f48258d2b1f0732a574b','测评项目2','A||B||C||D||','$合计$','MEUCIDChNr85sF0T8esSH9wlBlkGR84pPRvbMl1q07CEOrNRAiEAxahQdiWPEq97gV5IfvvHnCBKBsJYEZLGYXenjwvqW3c=','1'),('0c7dc9e7-b7c7-4337-9525-6a48e711e5fe',2,'人员表','582629f07b174cba871fd7ba145dedbe','dc49f009a1d201843b66852b563a290c','德','$未填$','无身份','MEYCIQCQv7DZOQMdduO5Wk0NBJe9jcthUPU15+1IdmIEboXuXAIhALZV7DNz5Nzx2tUzAymO7sch3EBdXfnkr7+1s9pj5BLp','0'),('0dfeec32-24d2-4a3f-af3f-d907a5439283',2,'人员表','582629f07b174cba871fd7ba145dedbe','dc49f009a1d201843b66852b563a290c','德','A','$合计$','MEYCIQCj1lQrmjaEJ2L9O00nH04Lodwy6O+okaTHrkenDIkHZQIhAJr3SMKK5aXPZfqF6WBb+0OAAXWPYNe/o2WojC7thAc9','1'),('116ea17c-e1b5-4bc0-a619-52d79f1e458b',1,'班子表','a9c47ba036324faca2f9a345c7a133f1','6b8837130ae0f48258d2b1f0732a574b','测评项目3','C','无身份','MEUCIFwPv0xTL3uMaVptB
/*!40000 ALTER TABLE `kp_result_1_poll` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kp_result_1_pov`
--

DROP TABLE IF EXISTS `kp_result_1_pov`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kp_result_1_pov` (
  `id` varchar(50) NOT NULL COMMENT '主键 uuid',
  `table_id` int DEFAULT NULL COMMENT '测评表id',
  `table_name` varchar(1000) DEFAULT NULL COMMENT '测评表名',
  `kp_object_id` text COMMENT '考评对象id',
  `kp_object_name` text COMMENT '考评对象名称',
  `kp_head` varchar(1000) DEFAULT NULL COMMENT '考评项目',
  `kp_item` varchar(1000) DEFAULT NULL COMMENT '考评选项',
  `tb_identity` varchar(1000) DEFAULT NULL COMMENT '填报人身份',
  `sign_val` varchar(1000) DEFAULT NULL,
  `result` varchar(2000) DEFAULT NULL COMMENT '结果',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kp_result_1_pov`
--

LOCK TABLES `kp_result_1_pov` WRITE;
/*!40000 ALTER TABLE `kp_result_1_pov` DISABLE KEYS */;
INSERT INTO `kp_result_1_pov` VALUES ('0443b27d-a078-460c-90a0-4623619a80b7',1,'班子表','ca814c4927ef49bfaa6921a1b0dabb74','5c5eaaa562249c1868681861f83427e0fff8075cc3958f3ef29c33b821c45da4028b4affd93a864c5938fb07da5b8a81','测评项目1','C','$合计$','MEUCIQDSZfu2YlyC0VWiWXJwMP4CgGygHl7yI3l/3Bw1F/f94QIgFK3RlENklnmXEKcdU0XxBCXTxlE6ew63oRTnik4tm0w=','0.000000'),('046f6d6d-c127-42ba-bd22-f5733043cc77',1,'班子表','ca814c4927ef49bfaa6921a1b0dabb74','5c5eaaa562249c1868681861f83427e0fff8075cc3958f3ef29c33b821c45da4028b4affd93a864c5938fb07da5b8a81','测评项目1','B','$合计$','MEQCIAMNgjWfwKIbx1F/To7dkT7gLmzDkFw5ON1Hd9u4LbSIAiBJSqfHyPuwoge5s5+4MGnUDfLhcSZ35owVJaep4Wslcw==','0.000000'),('064e91c7-a08f-403a-81b3-c997482b9c33',1,'班子表','020b32b5521b45528daa91cc84c2775e','0bd51616d79f6db7ca4bef1fd077eae2eaaf9a3e93b305b4780fcd29c4a6d187028b4affd93a864c5938fb07da5b8a81','测评项目3','D','无身份','MEUCIBY2a+wewO4KdsQ7WPJZyeKpLYds7uJwCVSRh2EIWGYSAiEAqfaknyyZF2qV2YyjI9wm4Wrxwf+JKAKWnw+OGP55X+8=','0.000000'),('0944b3e1-2da9-4c01-bba4-d8b3c44e9fd2',2,'人员表','55b467c546de422d829623e9158f191f','3c934b802d7e034408ea889cca8b5682','能','C','无身份','MEUCIQCb/wYvS5eJ2DNJu93n+25y/EdD/r2e2R864o0mRi/ZYQIgSoJ8HmxMlQCcLz8ozhWcha35nCI1qv19VvSd6dTXv44=','0.000000'),('0b76a07a-f78a-42ff-b8d2-1bc907a394d7',2,'人员表','582629f07b174cba871fd7ba145dedbe','dc49f009a1d201843b66852b563a290c','能','D','无身份','MEQCICNJPaMTqwBdNnhE0Zk4TeUH54uF2pH95JywWTGIE32EAiA9d3JNm55i/f+JCf0cp3V5qVeg0beU6YsyXTxFvepGAg==','0.000000'),('0c2b8415-e60e-4ebf-a101-6b38976db057',2,'人员表','582629f07b174cba871fd7ba145dedbe','dc49f009a1d201843b66852b563a290c','德','D','无身份','MEUCIQCIJIJIwcctYEp3K+dli9IllkV2a2GvYkOntdNQcg7VigIgKBdyhfc9bbzBVAMoaxpaamrrjUDcnB9viA4os/wNis0=','0.000000'),('0e4ee0e7-57fe-4f2b-a59f-57b7d4f1e47d',2,'人员表','fec063695deb4d698030b816da868ee1','dbcf498cb44bf583c75ae272e9d7219d','德','D','无身份','MEUCIQDW9AnU8Qvcuw0+GPZiV4T4W4qGScbhf0J0g4oL/MVccQIgGjdKFL1llzw2mRlVhOz78XW/+eQNAqAZbk28YVKrgpw=','0.000000'),('0ff1efe6-3237-49d4-acfd-23ccbeb2ddec',1,'班子表','d8868c9b1232485b8d27cbe2b2c68924','a16b352e8b68f5f152f03b172b4674d83a85b7aa47c6672a09f7ce7556c0bf7e028b4affd93a864c5938fb07da5b8a81','测评项目2','A','$合计$','MEUCIFX5RGNaOs970cjC25s9BppEWRFdCSStik78zNkSvHerAiEA0sK62w3zLo0yGHS4XzLR6lcuAUvr+1ksQ464K/HKacc=','1.000000'),('100f74fb-0dff-4a74-968d-f3262b0f1236',1,'班子表','d8868c9b1232485b8d27cbe2b2c68924','a16b352e8b68f5f152f03b172b4674d83a85b7aa47c6672a09f7ce7556c0bf7e028b4affd93a864c5938fb07da5b8a81','测评项目1','D','无身份','MEQCIHSOh11ujaijlt8E3Zv5X318CWK/rbekphye/tnsxyBsAiB3f613rlK35GrGQRjBtV4GpllOlKXdaJVvjv7WgymuUw==','0.000000'),('158e9efe-3865-4fd3-813e-5f6703001f0d',2,'人员表','fec063695deb4d698030b816da868ee1','dbcf498cb44bf583c75ae272e9d7219d','能','D','无身份','MEUCIBpTUdQQQ7pk5vyrBCGRsqCNOj6yAyLqSbqcok6PT+HKAiEAuX0g8UEe1y+JwCqtUwFOI/PAxA7wKjGuvqFk//XaOdE=','0.000000'),('1714c7d4-be1a-4411-9c53-d1d42bcd037d',1,'班子表','a9c47ba036324faca2f9a345c7a133f1','1d3ee9add639d47a6db1693a675b81ad5680ce5f8983d543e0e53188b4762be5028b4affd93a864c5938fb07da5b8a81','测评项目3','A','$合计$','MEUCIBe1J64ustTS3ORs6zgQ8V7toXqhOFBSPFD813Q6CXR5AiEAm0eXiMb8RJCt51Qa25yby+hp+EzRE8x8AA1mYOIV6ak=','1.000000'),('17b2a3da-5cc4-4635-b29b-5360a67b4c0a',1,'班子表','a9c47ba036324faca2f9a345c7a133f1','1d3ee9add639d47a6db1693a675b81ad5680ce5f8983d543e0e53188b4762be5028b4affd93a864c5938fb07da5b8a81','测评项目2','A','$合计$','MEUCIHN2XT7sb1+NTLBw0Kvfesu4XQGIQ4rRDcxsM89GJysdAiEA3JsBcbBYPksQOUcrHpBudhffyKs4IRdjhX71IcSfZvk=','1.000000'),('19f7b52d-421b-4d16-b816-ea50a7a6818b',1,'班子表','d8868c9b1232485b8d27cbe2b2c68924','a16b352e8b68f5f152f03b172b4674d83a85b7aa47c6672a09f7ce7556c0bf7e028b4affd93a864c5938fb07da5b8a81','测评项目3','B','无身份','MEUCIQCSZWAARAy5ebFDrcRCNh5Lb3Jfjrd1sHBN58Odfh5/1wIgIa4ApDOrPhAkz6HZ5y2ii6FhcG5TsySWwjDgGry0/No=','0.000000'),('1a7a861a-d4ac-454c-aeb0-7a52cece0946',1,'班子表','a9c47ba036324faca2f9a345c7a133f1','1d3ee9add639d47a6db1693a675b81ad5680ce5f
/*!40000 ALTER TABLE `kp_result_1_pov` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kp_result_1_score`
--

DROP TABLE IF EXISTS `kp_result_1_score`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kp_result_1_score` (
  `id` varchar(50) NOT NULL COMMENT '主键 uuid',
  `table_id` int DEFAULT NULL COMMENT '测评表id',
  `table_name` varchar(1000) DEFAULT NULL COMMENT '测评表名',
  `kp_object_id` text COMMENT '考评对象id',
  `kp_object_name` text COMMENT '考评对象名称',
  `kp_head` varchar(1000) DEFAULT NULL COMMENT '考评项目',
  `kp_item` varchar(1000) DEFAULT NULL COMMENT '考评选项',
  `tb_identity` varchar(1000) DEFAULT NULL COMMENT '填报人身份',
  `sign_val` varchar(1000) DEFAULT NULL,
  `result` varchar(2000) DEFAULT NULL COMMENT '结果',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kp_result_1_score`
--

LOCK TABLES `kp_result_1_score` WRITE;
/*!40000 ALTER TABLE `kp_result_1_score` DISABLE KEYS */;
INSERT INTO `kp_result_1_score` VALUES ('03d52015-7a72-41e8-b571-de01c36d155b',2,'人员表','fec063695deb4d698030b816da868ee1','dbcf498cb44bf583c75ae272e9d7219d','能','','无身份','MEUCIQDTCAhv4hzR0IRb++ZUMEIuJBz+eFYbeh4YbeH4YD0g5wIgYw8nM8ziOXnjXljyIYsebdjY4G9YeemYS0H0Gd8W0rU=','0.000000'),('056466c6-e6dc-4da5-8828-7768948ef569',1,'班子表','020b32b5521b45528daa91cc84c2775e','3729553e6491a735c277376aaec2a804','测评项目2','','无身份','MEQCIDCcVipbs4ZMbEMQ2OwxIoBTbBcOJvfC08A2fp3jzaVfAiB6PcN2F0zRUwJre2vj1Wfgit0G0aA7Dp6+aPPRWVUYJg==','100.000000'),('081ea9bb-33bd-4e98-9b52-b381fc678372',2,'人员表','582629f07b174cba871fd7ba145dedbe','dc49f009a1d201843b66852b563a290c','','','$总分$','MEYCIQCnwZxb98813GpVe/JAdfLHT9b8jBFU6Anz0xOk1f2dTQIhALs46DdGn1PCrAlSKOIOi8YtxN9KQNCcHpK1qX0jY38c','100.000000'),('0a90911f-5fb9-4255-a00c-60b4d5c8a09d',1,'班子表','d8868c9b1232485b8d27cbe2b2c68924','f2018983bbed11adf85a5a6821251978','测评项目2','','无身份','MEQCIGmtxce3e7b8gmIQ/BJfqRByDjrC710Rs9SUzB6GZJnOAiA8Q5ryxrWVBNWKn0o5qIOqZBQhXMz3goqwDcdsKgOQaQ==','100.000000'),('0b932512-8cf7-46cf-8295-63058d603880',2,'人员表','55b467c546de422d829623e9158f191f','3c934b802d7e034408ea889cca8b5682','德','','无身份','MEUCIDMiXcRpkTDhkEDTZLMrsXvDiIiq/Jg1+BUeKBd0ve7oAiEAw9AS0gip4lC31drbAGm+r93Oz3khNwH6MrUkWlUXb2E=','100.000000'),('10522c85-1031-46c9-94d4-2c75d966a6ea',2,'人员表','55b467c546de422d829623e9158f191f','3c934b802d7e034408ea889cca8b5682','德','','$合计$','MEUCIQCoj0vUBbZFnGfVifx1zCmuVguwiVcfXuAEf2gOmV4y0AIgWX1A+X+ngpU04KJ78iS1IgG+sHk11/G5oSVV6pmqi0I=','100.000000'),('1916d4ca-757c-4b74-b31a-7c7638cda306',1,'班子表','ca814c4927ef49bfaa6921a1b0dabb74','a0ff1b1c70f557a2e8d85094eab7a5ad','测评项目2','','无身份','MEYCIQC1piQ6n9ho+Gwo2vMcSViq/ulprcg89iRXDbVB168egAIhANFwww6cz0XSgrmDSIUPRz+lfa0p7V0XhtYKTLXan+/X','100.000000'),('1e6f339f-d44d-4c95-8008-96b58b33604c',1,'班子表','a9c47ba036324faca2f9a345c7a133f1','6b8837130ae0f48258d2b1f0732a574b','测评项目2','','无身份','MEUCIQCR4kWgcwRMGAYK5ikWf4fe8s7M3A6Fl6XE4hngGcfXGgIgPm6NS1NPSZkQmPPB/P5Ugx3esxFNdJMKkr4scCpLy3U=','100.000000'),('1f97794d-09db-4a37-9cac-231a836a2082',2,'人员表','fec063695deb4d698030b816da868ee1','dbcf498cb44bf583c75ae272e9d7219d','德','','无身份','MEYCIQDv4nwtNAgdhIRuUYye91nIN5knBPQIM9q/EB6/8TSk9gIhAKA7R6Ur7H3V6kxeOopEnQLTT3bh2a+gNsmQ0KFlNl+8','100.000000'),('22b2b063-eb87-469c-ace6-5a916d67271d',1,'班子表','d8868c9b1232485b8d27cbe2b2c68924','f2018983bbed11adf85a5a6821251978','测评项目3','','$合计$','MEUCIQDDAJzhJn+vFj3fnI/oP0/lRTEWvDzrzdW6UX0oZV3OdwIgGDeVThSGptZQLEtMUL3BMOSBuZxUJsy1wWnfesjRV78=','100.000000'),('3196cfe8-5dec-4275-8947-38e2e5eb61a8',1,'班子表','a9c47ba036324faca2f9a345c7a133f1','6b8837130ae0f48258d2b1f0732a574b','测评项目3','','无身份','MEQCIAO8nKULSfpj0dJwht8x7+sd/4Vl59TvLyQxmvD7541QAiAz2Siu92o5JOuY79uPASG1uZ/Vc2z6yqm83WqGoJTdtg==','100.000000'),('3badb0d8-1e14-4669-8f8d-098d2c49eaa9',1,'班子表','d8868c9b1232485b8d27cbe2b2c68924','f2018983bbed11adf85a5a6821251978','测评项目1','','无身份','MEQCIEAB4Cfh2SYRUJP6wpznobUr+87LK5C3OtdL27hc/xs0AiB4ifI9YzHP8E0jIhV1B9lvYsX2VrI6b0yODgZRarEW4Q==','100.000000'),('3d5b2ccd-9492-418a-9b46-91da7fb6a86c',1,'班子表','020b32b5521b45528daa91cc84c2775e','3729553e6491a735c277376aaec2a804','','','$总分$','MEYCIQC+F1K63AotefHhm0eXKdzixwc0n3TZetGMQHYSvvbvVwIhAPe8kidLxYE1n+1mCKyE/nFpbE7Nr9XaViqyLr6RHVtA','300.000000'),('43f493d7-b496-4330-bfa4-a5477b106c32',1,'班子表','d8868c9b1232485b8d27cbe2b2c68924','f2018983bbed11adf85a5a6821251978','测评项目3','','无身份','MEUCIA726MZW/Qead8cghryoEVlnE/s4BMj7RcitEzbPhnAJAiEAvQd8ozIadRlnEsiI+aTrawEJ9CD3U1/34f3pYDz81FA=','100.000000'),('46e3556d-4a7d-4f82-b7e9-ca92a6e3efef',1,'班子表','a9c47ba036324faca2f9a345c7a133f1','6b8837130ae0f48258d2b1f0732a574b','测评项目2','','$合计$','MEUCICWDLJXEt37BL/+1+DTZlsn/Se4tCh8ylqMR9Sk/7p74AiEA0IylbasD+DkMkV9IH35Jclgu7A1EfdKBHyor6wcq+es=','100.000000'),('53154ed0-1460-4ea5-859a-d798fa55fcc1',1,'班子表','020b32b5521b45528daa91cc84c2775e','3729553e6491a735c27
/*!40000 ALTER TABLE `kp_result_1_score` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kp_result_1_scorepov`
--

DROP TABLE IF EXISTS `kp_result_1_scorepov`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kp_result_1_scorepov` (
  `id` varchar(50) NOT NULL COMMENT '主键 uuid',
  `table_id` int DEFAULT NULL COMMENT '测评表id',
  `table_name` varchar(1000) DEFAULT NULL COMMENT '测评表名',
  `kp_object_id` text COMMENT '考评对象id',
  `kp_object_name` text COMMENT '考评对象名称',
  `kp_head` varchar(1000) DEFAULT NULL COMMENT '考评项目',
  `kp_item` varchar(1000) DEFAULT NULL COMMENT '考评选项',
  `tb_identity` varchar(1000) DEFAULT NULL COMMENT '填报人身份',
  `sign_val` varchar(1000) DEFAULT NULL,
  `result` varchar(2000) DEFAULT NULL COMMENT '结果',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kp_result_1_scorepov`
--

LOCK TABLES `kp_result_1_scorepov` WRITE;
/*!40000 ALTER TABLE `kp_result_1_scorepov` DISABLE KEYS */;
INSERT INTO `kp_result_1_scorepov` VALUES ('0172bdd6-e350-4fd5-81dc-9e8b3bc6b0de',1,'班子表','020b32b5521b45528daa91cc84c2775e','3729553e6491a735c277376aaec2a804','测评项目3','','无身份','MEUCIF9mOuBh4+2FeAqQ58d80VtCaYDdaY9ygVvvYp29HhseAiEAtcS8pRdes2pI1W5nm+s0mlbIO9uAKZQHJ5qOx+BUmU8=','1.000000'),('15e5009f-4452-4887-84b7-a12510e96472',1,'班子表','ca814c4927ef49bfaa6921a1b0dabb74','a0ff1b1c70f557a2e8d85094eab7a5ad','测评项目2','','$合计$','MEUCICyNkrkpyKW6AVXA1ElJBryfcy+ynlna4rmWJsA/aaMSAiEAwQAhaUeAk5JisqzyvP01sJc9j0GMealSduizWjqXSsQ=','1.000000'),('17c44b07-2574-47e2-aee0-004ad457fdab',2,'人员表','582629f07b174cba871fd7ba145dedbe','dc49f009a1d201843b66852b563a290c','','','$总分$','MEUCIQD11FYYxRo0TiaH1yCnmmJCLvRltXphXPzNH7jYeqcuqgIgMUCiYCCA0DeFd5xF5ho3ouu9RzMGer6ymmoTO1qf0xA=','0.500000'),('182bc466-ceba-495a-bfc4-1543efffc6d9',1,'班子表','a9c47ba036324faca2f9a345c7a133f1','6b8837130ae0f48258d2b1f0732a574b','测评项目1','','$合计$','MEQCIHXt+ATGO3IFP0mkezPk+VmZSOpWZtmZ7HgvD1VDjbTXAiAgLyii8PC4PJtvodpQK97Cs4CxcPN/IZYH9/vDRioaow==','1.000000'),('1846e054-f648-418c-940d-d8d0bb31cfdd',1,'班子表','d8868c9b1232485b8d27cbe2b2c68924','f2018983bbed11adf85a5a6821251978','测评项目3','','$合计$','MEUCIAoZ/6jmPaqB5Jq4YSpGgEtjk6KIb8skdAR59NPnofCkAiEA2KPu9u4u3xk8sz7p1thDwUY/VWGeT0VfJD52/UQdAlE=','1.000000'),('2d16f0c0-dbb3-4ea5-a178-d90e825f3347',2,'人员表','fec063695deb4d698030b816da868ee1','dbcf498cb44bf583c75ae272e9d7219d','德','','无身份','MEUCIQCKbMbkX4wSod26PJF98dUnZSVMRB5ACUTjxtFX7d89wAIgKKEqJ6k6vyhWfHQaCAz7dZQpu3/hBtwoGQdrAzDNJd0=','1.000000'),('2e1df7f1-a785-460a-8562-fdf43bd0303f',1,'班子表','020b32b5521b45528daa91cc84c2775e','3729553e6491a735c277376aaec2a804','测评项目1','','无身份','MEQCIGbtJrETgDBSy+7vUjAfsobuxpYkbCdwiMN9o4m/ufYVAiBDXSqL2J32OXhngh/1WqAJAf6H7CGGwg5l+JogM7OJhw==','1.000000'),('3a32ad19-d6a6-488b-a3c7-9befe48751a0',1,'班子表','a9c47ba036324faca2f9a345c7a133f1','6b8837130ae0f48258d2b1f0732a574b','测评项目2','','$合计$','MEUCICSBItmF1jGdDA7ec+g19fI5/Tf8YqZxkiWeYZcIIjO8AiEA3AUyUWQ5yOxkRbI4/DHuLrwf2AJd5UVzxE7hMb80iwo=','1.000000'),('3b0bef0d-32e6-4442-af49-7623f61ec701',2,'人员表','fec063695deb4d698030b816da868ee1','dbcf498cb44bf583c75ae272e9d7219d','德','','$合计$','MEQCIAs9PSlnShO2NbvzscRqAFaks+jJQ5AXynyEqFKduYp3AiAbTIIm4R3gnlfqAsXga7/rgAoY3uiUITB3fKwBqT7vcQ==','1.000000'),('3d44cce8-13e9-4690-b85b-e7f020b7df85',1,'班子表','a9c47ba036324faca2f9a345c7a133f1','6b8837130ae0f48258d2b1f0732a574b','测评项目3','','无身份','MEUCIQCih5/iW81LDfl2D6xmiWl9ps84R1ZL2PrCE3YKjtjAGAIgRGvnAV4DSz1kqX1ksKf7RQMhfANyT0hOQsg3AeLeUvg=','1.000000'),('457417bc-4d5d-4409-bbcc-92071d231c81',2,'人员表','582629f07b174cba871fd7ba145dedbe','dc49f009a1d201843b66852b563a290c','能','','无身份','MEUCIQDUnCqvXgGV+47noBmWrGOXDrQVKkyGK+h2ZYalqhrrlQIgT9wut72Q6+EMfe2k7pA74NHCapra33n52KYn3RRNmIQ=','0.000000'),('479a1de8-2ee6-47e9-b143-c7cbcf8a2cc0',1,'班子表','a9c47ba036324faca2f9a345c7a133f1','6b8837130ae0f48258d2b1f0732a574b','','','$总分$','MEUCIQCFiY+hzTvkAafQVkRlaTfi4USdFrG/l4y223+ofilzgAIgP+OB6QK3dDiAPviq8s290sAiGyY2+GNVcxyzs8SohiQ=','1.000000'),('47a85bad-27d5-4c09-bd6a-230735a00019',2,'人员表','55b467c546de422d829623e9158f191f','3c934b802d7e034408ea889cca8b5682','德','','$合计$','MEYCIQC0pKGYSqCW8X5WpdeJSAPH+tgPI40ZtbZY+XXTx+SSpAIhANIj6ypch9qll7lyuhnyJQ16GLU4byD0IPyfso07r00q','1.000000'),('4bec44cb-c936-43cb-b565-94eef0fe5746',1,'班子表','d8868c9b1232485b8d27cbe2b2c68924','f2018983bbed11adf85a5a6821251978','','','$总分$','MEUCIEqHVxYOQYN5hXEGD4kYhzSuDB2BtL+ShCzeLvF8+UlzAiEA2xoBn8vqhMrGfs+JV+DnOq+6qGJ3hCZnU/ofAxkKX3o=','1.000000'),('4d239609-2896-4def-ad6b-6aac66762a2d',1,'班子表','020b32b5521b45528daa91cc84c2775e','3729553e6491a735c277376aaec2a804','测评项目2','','无身份','MEUCIQCaqzDeHg1A0cVvexPMz3vn3tWXVfGTCPnB/187A5uq9wIgbGffShjPKZayvdDD9iHdHExAu0F2+Exkpjs07iF6Olw=','1.000000'),('4f5dcb6d-bad1-4d36-a06c-113e29335eaa',1,'班子表','020b32b5521b45528daa91cc84c2775e','3729553e6491a735c277376aaec2a804','测评项目1','','$合计
/*!40000 ALTER TABLE `kp_result_1_scorepov` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kp_result_1_text`
--

DROP TABLE IF EXISTS `kp_result_1_text`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kp_result_1_text` (
  `id` varchar(50) NOT NULL COMMENT '主键 uuid',
  `table_id` int DEFAULT NULL COMMENT '测评表id',
  `table_name` varchar(1000) DEFAULT NULL COMMENT '测评表名',
  `kp_object_id` text COMMENT '考评对象id',
  `kp_object_name` text COMMENT '考评对象名称',
  `kp_head` varchar(1000) DEFAULT NULL COMMENT '考评项目',
  `kp_item` varchar(1000) DEFAULT NULL COMMENT '考评选项',
  `tb_identity` varchar(1000) DEFAULT NULL COMMENT '填报人身份',
  `sign_val` varchar(1000) DEFAULT NULL,
  `result` varchar(2000) DEFAULT NULL COMMENT '结果',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kp_result_1_text`
--

LOCK TABLES `kp_result_1_text` WRITE;
/*!40000 ALTER TABLE `kp_result_1_text` DISABLE KEYS */;
/*!40000 ALTER TABLE `kp_result_1_text` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kp_shuzhi_baogao`
--

DROP TABLE IF EXISTS `kp_shuzhi_baogao`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kp_shuzhi_baogao` (
  `id` varchar(50) NOT NULL,
  `kp_object_id` varchar(50) DEFAULT NULL COMMENT '被评对象id',
  `file_original_name` varchar(2000) DEFAULT NULL COMMENT '文件名',
  `belongto_dep` int NOT NULL COMMENT '是否属于部门（要么属于人 要么属于部门） 0是部门 1是人',
  `work_id` int NOT NULL COMMENT '工作id',
  `file_save_path` varchar(2000) DEFAULT NULL COMMENT '文件路径(dfileninfo中id)',
  `swf_file_path` varchar(2000) DEFAULT NULL COMMENT 'swf路径(抛弃字段)',
  `upload_time` varchar(50) NOT NULL COMMENT '上传时间',
  `upload_user` varchar(2000) DEFAULT NULL COMMENT '上传用户',
  `del_status` int NOT NULL COMMENT '伪删除 1是正常 2是删除',
  `match_success` int NOT NULL COMMENT '去数据库进行匹配 如果只匹配到一个则匹配成功(0)  否则 失败(1)',
  `ti_shi_message` varchar(2000) DEFAULT NULL COMMENT '提示信息  上传失败的时候把错误信息存放到这个字段中',
  `system_id` varchar(50) DEFAULT NULL COMMENT '所属子系统id',
  `table_id` int DEFAULT NULL COMMENT '所属表id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kp_shuzhi_baogao`
--

LOCK TABLES `kp_shuzhi_baogao` WRITE;
/*!40000 ALTER TABLE `kp_shuzhi_baogao` DISABLE KEYS */;
/*!40000 ALTER TABLE `kp_shuzhi_baogao` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kp_table`
--

DROP TABLE IF EXISTS `kp_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kp_table` (
  `tid` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) DEFAULT NULL COMMENT '考评表名称',
  `write_table` varchar(50) DEFAULT NULL COMMENT '保存数据动态表名',
  `kp_workid` int DEFAULT NULL COMMENT '考评工作id',
  `sort` int DEFAULT NULL COMMENT '排序号',
  `copy_tableid` int DEFAULT NULL COMMENT '从表复制',
  `kp_object_type` int DEFAULT NULL COMMENT '考评对象类型: 1 考评班子;2考评人',
  `show_table_type` int DEFAULT NULL COMMENT '考评表类型(1、多人（被评对象）表\r\n            支持考评表格选项、数值、文本录入。\r\n            支持添加干部字段\r\n            2、单人（被评对象）表\r\n            支持最后一项竖排\r\n            支持合并列，合并行。\r\n            4、试卷（问卷）表)',
  `del_status` int DEFAULT NULL COMMENT '是否删除(1:正常,2:删除)',
  `assessor_identity_status` int DEFAULT NULL COMMENT '是否存在填表人身份(1:有,2:没有)',
  `self_evaluation` int DEFAULT NULL COMMENT '是否自评(1:自评,0:不自评)',
  `show_table_type_mobile` int DEFAULT NULL COMMENT '默认值为1',
  PRIMARY KEY (`tid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kp_table`
--

LOCK TABLES `kp_table` WRITE;
/*!40000 ALTER TABLE `kp_table` DISABLE KEYS */;
INSERT INTO `kp_table` VALUES (1,'班子表','kp_table_1_1',1,1,NULL,1,1,1,2,2,1),(2,'人员表','kp_table_1_2',1,2,NULL,2,1,1,2,2,1);
/*!40000 ALTER TABLE `kp_table` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kp_table_1_1`
--

DROP TABLE IF EXISTS `kp_table_1_1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kp_table_1_1` (
  `id` varchar(50) NOT NULL COMMENT '主键id',
  `user_id` int DEFAULT NULL COMMENT '用户id',
  `pc_id` varchar(50) DEFAULT NULL COMMENT '批次id',
  `kp_object_id` varchar(50) DEFAULT NULL COMMENT '被评对象id',
  `person_card` int DEFAULT NULL COMMENT '参评人员类型标识',
  `f_2` varchar(1) DEFAULT NULL,
  `f_3` varchar(1) DEFAULT NULL,
  `f_4` varchar(1) DEFAULT NULL,
  `f_5` varchar(1) DEFAULT NULL,
  `f_7` varchar(1) DEFAULT NULL,
  `f_8` varchar(1) DEFAULT NULL,
  `f_9` varchar(1) DEFAULT NULL,
  `f_10` varchar(1) DEFAULT NULL,
  `f_12` varchar(1) DEFAULT NULL,
  `f_13` varchar(1) DEFAULT NULL,
  `f_14` varchar(1) DEFAULT NULL,
  `f_15` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kp_table_1_1`
--

LOCK TABLES `kp_table_1_1` WRITE;
/*!40000 ALTER TABLE `kp_table_1_1` DISABLE KEYS */;
INSERT INTO `kp_table_1_1` VALUES ('17f2e5bc0a274cba9fa0f1ec74de8320',16,'a3990d83af973bd48e58def890054791','ca814c4927ef49bfaa6921a1b0dabb74',0,'1','0','0','0','1','0','0','0','1','0','0','0'),('1ddb6080746d47b7be694f128f5772f3',16,'a3990d83af973bd48e58def890054791','d8868c9b1232485b8d27cbe2b2c68924',0,'1','0','0','0','1','0','0','0','1','0','0','0'),('2b93efbce751449585e85742fde93547',16,'a3990d83af973bd48e58def890054791','a9c47ba036324faca2f9a345c7a133f1',0,'1','0','0','0','1','0','0','0','1','0','0','0'),('e83057649d39412f8f1fa0ae19934505',16,'a3990d83af973bd48e58def890054791','020b32b5521b45528daa91cc84c2775e',0,'1','0','0','0','1','0','0','0','1','0','0','0');
/*!40000 ALTER TABLE `kp_table_1_1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kp_table_1_2`
--

DROP TABLE IF EXISTS `kp_table_1_2`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kp_table_1_2` (
  `id` varchar(50) NOT NULL COMMENT '主键id',
  `user_id` int DEFAULT NULL COMMENT '用户id',
  `pc_id` varchar(50) DEFAULT NULL COMMENT '批次id',
  `kp_object_id` varchar(50) DEFAULT NULL COMMENT '被评对象id',
  `person_card` int DEFAULT NULL COMMENT '参评人员类型标识',
  `f_17` varchar(1) DEFAULT NULL,
  `f_18` varchar(1) DEFAULT NULL,
  `f_19` varchar(1) DEFAULT NULL,
  `f_20` varchar(1) DEFAULT NULL,
  `f_22` varchar(1) DEFAULT NULL,
  `f_23` varchar(1) DEFAULT NULL,
  `f_24` varchar(1) DEFAULT NULL,
  `f_25` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kp_table_1_2`
--

LOCK TABLES `kp_table_1_2` WRITE;
/*!40000 ALTER TABLE `kp_table_1_2` DISABLE KEYS */;
INSERT INTO `kp_table_1_2` VALUES ('401ad78367ba4f979da357f66b897418',16,'a3990d83af973bd48e58def890054791','582629f07b174cba871fd7ba145dedbe',0,'1','0','0','0','1','0','0','0'),('692b513ca9a74358a2fdb3684cf90c85',16,'a3990d83af973bd48e58def890054791','fec063695deb4d698030b816da868ee1',0,'1','0','0','0','1','0','0','0'),('6c0ebcc9c7f842cdbbd3fcbb75fed86b',16,'a3990d83af973bd48e58def890054791','55b467c546de422d829623e9158f191f',0,'1','0','0','0','1','0','0','0');
/*!40000 ALTER TABLE `kp_table_1_2` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kp_table_head`
--

DROP TABLE IF EXISTS `kp_table_head`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kp_table_head` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `pid` int DEFAULT NULL COMMENT '父节点id',
  `field_name` varchar(500) DEFAULT NULL COMMENT '项目名称',
  `type` int DEFAULT NULL COMMENT '类型 (1:选项,0:题目,2:题目分类名)',
  `score` double DEFAULT NULL COMMENT '分数',
  `is_included` int DEFAULT NULL COMMENT '是否计入得票率',
  `waiver_weight` double DEFAULT NULL COMMENT '弃权权重',
  `group_name` varchar(50) DEFAULT NULL COMMENT '分组名',
  `table_id` int DEFAULT NULL COMMENT '关联表id',
  `edit_table_type` int DEFAULT NULL COMMENT '可编辑类型(0:不能编辑,1.文本填写,2.数值填写)',
  `complete_allitem_status` int DEFAULT NULL COMMENT '考评选项必须全部填写完毕',
  `sort` int DEFAULT NULL COMMENT '排序',
  `del_status` int DEFAULT NULL COMMENT '是否删除(1:正常,2:删除)',
  `option_class` int DEFAULT NULL COMMENT '题型:(1:单选题;2:多选题;3:填空题;',
  `scope_limitation` varchar(50) DEFAULT NULL COMMENT '填值长度范围限制(1&2,3&4   1:填值类型 (1:文本类型;2:数值类型)  2,3:2-3的长度范围  4:如果为数值类型则为保留小数长度)',
  `append_position` int DEFAULT NULL COMMENT '追加位置(0:正常,1:最右侧,2:最下方)',
  `is_included_score` int DEFAULT NULL COMMENT '未填是否计入得分(1:是,2:否)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kp_table_head`
--

LOCK TABLES `kp_table_head` WRITE;
/*!40000 ALTER TABLE `kp_table_head` DISABLE KEYS */;
INSERT INTO `kp_table_head` VALUES (1,-1,'测评项目1',0,100,0,NULL,NULL,1,0,1,1,1,1,NULL,0,2),(2,1,'A',1,1,1,NULL,'',1,0,NULL,0,1,NULL,NULL,0,1),(3,1,'B',1,0.8,1,NULL,'',1,0,NULL,1,1,NULL,NULL,0,1),(4,1,'C',1,0.6,1,NULL,'',1,0,NULL,2,1,NULL,NULL,0,1),(5,1,'D',1,0.4,1,NULL,'',1,0,NULL,3,1,NULL,NULL,0,1),(6,-1,'测评项目2',0,100,0,NULL,NULL,1,0,1,2,1,1,NULL,0,2),(7,6,'A',1,1,1,NULL,'',1,0,NULL,0,1,NULL,NULL,0,1),(8,6,'B',1,0.8,1,NULL,'',1,0,NULL,1,1,NULL,NULL,0,1),(9,6,'C',1,0.6,1,NULL,'',1,0,NULL,2,1,NULL,NULL,0,1),(10,6,'D',1,0.4,1,NULL,'',1,0,NULL,3,1,NULL,NULL,0,1),(11,-1,'测评项目3',0,100,0,NULL,NULL,1,0,1,3,1,1,NULL,0,2),(12,11,'A',1,1,1,NULL,'',1,0,NULL,0,1,NULL,NULL,0,1),(13,11,'B',1,0.8,1,NULL,'',1,0,NULL,1,1,NULL,NULL,0,1),(14,11,'C',1,0.6,1,NULL,'',1,0,NULL,2,1,NULL,NULL,0,1),(15,11,'D',1,0.4,1,NULL,'',1,0,NULL,3,1,NULL,NULL,0,1),(16,-1,'德',0,100,0,NULL,NULL,2,0,1,1,1,1,NULL,0,2),(17,16,'A',1,1,1,NULL,'',2,0,NULL,0,1,NULL,NULL,0,1),(18,16,'B',1,0.8,1,NULL,'',2,0,NULL,1,1,NULL,NULL,0,1),(19,16,'C',1,0.6,1,NULL,'',2,0,NULL,2,1,NULL,NULL,0,1),(20,16,'D',1,0.4,1,NULL,'',2,0,NULL,3,1,NULL,NULL,0,1),(21,-1,'能',0,100,0,NULL,NULL,2,0,1,2,1,1,NULL,0,2),(22,21,'A',1,0,1,NULL,'',2,0,NULL,0,1,NULL,NULL,0,1),(23,21,'B',1,0,1,NULL,'',2,0,NULL,1,1,NULL,NULL,0,1),(24,21,'C',1,0,1,NULL,'',2,0,NULL,2,1,NULL,NULL,0,1),(25,21,'D',1,0,1,NULL,'',2,0,NULL,3,1,NULL,NULL,0,1);
/*!40000 ALTER TABLE `kp_table_head` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kp_table_objcet`
--

DROP TABLE IF EXISTS `kp_table_objcet`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kp_table_objcet` (
  `id` varchar(50) NOT NULL COMMENT '主键id',
  `kp_object_id` varchar(50) DEFAULT NULL COMMENT '考评对象id; 1考评对象是人，保存的是考评对象的personId；2考评对象是班子的时候，保存的是班子的父级节点',
  `kp_type_id` int DEFAULT NULL COMMENT '考评对象类型: 1 考评班子;2考评人',
  `table_id` int DEFAULT NULL COMMENT '考评表id',
  `sort` int DEFAULT NULL COMMENT '排序',
  `del_status` int DEFAULT NULL COMMENT '是否删除(1:正常,2:删除)',
  `my_status` int DEFAULT NULL COMMENT '区分状态 1是人员',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kp_table_objcet`
--

LOCK TABLES `kp_table_objcet` WRITE;
/*!40000 ALTER TABLE `kp_table_objcet` DISABLE KEYS */;
INSERT INTO `kp_table_objcet` VALUES ('21178c2f5f9866ed48a220e9823465b7','fec063695deb4d698030b816da868ee1',2,2,1,1,2),('4704a6fa0ce2e7595ea9b0299acb4f62','020b32b5521b45528daa91cc84c2775e',1,1,3,1,1),('7cc82e28459889ead481161d444bab5b','ca814c4927ef49bfaa6921a1b0dabb74',1,1,2,1,1),('9bdf0c53064f11a7e67507af591ca056','d8868c9b1232485b8d27cbe2b2c68924',1,1,1,1,1),('a2fdd55a4eb18f1386d09c9135a91774','a9c47ba036324faca2f9a345c7a133f1',1,1,4,1,1),('c7b82d61c38d67ad6ca7083d964f5d1f','582629f07b174cba871fd7ba145dedbe',2,2,3,1,2),('f49af1b730d73f4c2dbc910dc7e29cd0','55b467c546de422d829623e9158f191f',2,2,2,1,2);
/*!40000 ALTER TABLE `kp_table_objcet` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kp_work_manager`
--

DROP TABLE IF EXISTS `kp_work_manager`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kp_work_manager` (
  `wid` int NOT NULL AUTO_INCREMENT COMMENT '考评工作id',
  `name` varchar(200) DEFAULT NULL COMMENT '考评工作名称',
  `year` varchar(50) DEFAULT NULL COMMENT '考评工作年份',
  `copy_work` int DEFAULT NULL COMMENT '复制工作id',
  `create_time` varchar(50) DEFAULT NULL COMMENT '创建时间',
  `update_time` varchar(50) DEFAULT NULL COMMENT '更新时间',
  `write_identity_mode` int DEFAULT NULL COMMENT '填表人身份模式(1: 后台管理员设置,2: 填表人自己选择)',
  `person_doc_download` int DEFAULT NULL COMMENT '是否可下载述职报告',
  `person_doc_show` int DEFAULT NULL COMMENT '是否可预览述职报告',
  `del_status` int DEFAULT NULL COMMENT '是否删除(1:正常,2:删除)',
  `create_user` varchar(50) DEFAULT NULL COMMENT '创建者',
  `system_id` varchar(50) DEFAULT NULL COMMENT '子系统id',
  `work_group` varchar(50) DEFAULT NULL COMMENT '属于哪个分类',
  `work_status` varchar(50) DEFAULT NULL COMMENT '状态（1正常2归档）',
  `turnover_ratio` int DEFAULT NULL COMMENT '提交达标率(当提交率达到标准值时,表明此工作已达标)',
  `filling_explanation` varchar(50) DEFAULT NULL COMMENT '路径长度',
  `examination_status` int DEFAULT NULL COMMENT '自检状态(1:正常; 2:错误; 3:警告)',
  `examination_time` varchar(50) DEFAULT NULL COMMENT '最后一次自检时间',
  `picture_anonymity` longtext COMMENT '匿名导出图片',
  `x_axis` int DEFAULT NULL COMMENT 'x轴',
  `y_axis` int DEFAULT NULL COMMENT 'y轴',
  `file_name` varchar(255) DEFAULT NULL COMMENT '文件名',
  `file_size` varchar(255) DEFAULT NULL COMMENT '文件大小',
  `cal_result_time` varchar(50) DEFAULT NULL COMMENT '计算结果时间',
  `person_doc_public` int DEFAULT NULL COMMENT '是否对外公开述职报告（0：否；1：是）',
  PRIMARY KEY (`wid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kp_work_manager`
--

LOCK TABLES `kp_work_manager` WRITE;
/*!40000 ALTER TABLE `kp_work_manager` DISABLE KEYS */;
INSERT INTO `kp_work_manager` VALUES (1,'2021测试工作','2021',NULL,'2022-01-24 22:45:03',NULL,1,1,1,1,'2','89f8b0e5202b064c570c356ff9b4fe5b','','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2022-01-25 16:44:00',0);
/*!40000 ALTER TABLE `kp_work_manager` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kpobject_label`
--

DROP TABLE IF EXISTS `kpobject_label`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kpobject_label` (
  `id` varchar(50) NOT NULL,
  `name` varchar(255) DEFAULT NULL COMMENT '名称',
  `pid` varchar(50) DEFAULT NULL COMMENT '父级节点',
  `sort` int DEFAULT NULL COMMENT '排序',
  `son_user_show` int DEFAULT NULL COMMENT '是否开发给二级单位(1:是,0:否)',
  `w_id` int DEFAULT NULL COMMENT '工作id',
  `system_id` varchar(50) DEFAULT NULL COMMENT '子系统编码',
  `del_status` int DEFAULT NULL COMMENT '是否删除(1:正常,2:删除)',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kpobject_label`
--

LOCK TABLES `kpobject_label` WRITE;
/*!40000 ALTER TABLE `kpobject_label` DISABLE KEYS */;
/*!40000 ALTER TABLE `kpobject_label` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kpobject_label_a01`
--

DROP TABLE IF EXISTS `kpobject_label_a01`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kpobject_label_a01` (
  `id` varchar(50) NOT NULL,
  `label_id` varchar(50) DEFAULT NULL COMMENT '标签id',
  `user_uid` varchar(50) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kpobject_label_a01`
--

LOCK TABLES `kpobject_label_a01` WRITE;
/*!40000 ALTER TABLE `kpobject_label_a01` DISABLE KEYS */;
/*!40000 ALTER TABLE `kpobject_label_a01` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kpobject_writeuser`
--

DROP TABLE IF EXISTS `kpobject_writeuser`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kpobject_writeuser` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键自增',
  `write_id` int DEFAULT NULL COMMENT '填报id',
  `object_id` varchar(50) DEFAULT NULL COMMENT '被评对象id',
  `type` int DEFAULT NULL COMMENT '1.单位,2.用户',
  `pc_id` varchar(50) DEFAULT NULL COMMENT '批次id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kpobject_writeuser`
--

LOCK TABLES `kpobject_writeuser` WRITE;
/*!40000 ALTER TABLE `kpobject_writeuser` DISABLE KEYS */;
/*!40000 ALTER TABLE `kpobject_writeuser` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kpobject_writeuser_1`
--

DROP TABLE IF EXISTS `kpobject_writeuser_1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kpobject_writeuser_1` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键自增',
  `write_id` int DEFAULT NULL COMMENT '填报id',
  `object_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '被评对象id',
  `type` int DEFAULT NULL COMMENT '1.单位,2.用户',
  `pc_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '批次id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kpobject_writeuser_1`
--

LOCK TABLES `kpobject_writeuser_1` WRITE;
/*!40000 ALTER TABLE `kpobject_writeuser_1` DISABLE KEYS */;
INSERT INTO `kpobject_writeuser_1` VALUES (1,16,'d8868c9b1232485b8d27cbe2b2c68924',1,'a3990d83af973bd48e58def890054791'),(2,16,'ca814c4927ef49bfaa6921a1b0dabb74',1,'a3990d83af973bd48e58def890054791'),(3,16,'020b32b5521b45528daa91cc84c2775e',1,'a3990d83af973bd48e58def890054791'),(4,16,'a9c47ba036324faca2f9a345c7a133f1',1,'a3990d83af973bd48e58def890054791'),(5,16,'fec063695deb4d698030b816da868ee1',2,'a3990d83af973bd48e58def890054791'),(6,16,'55b467c546de422d829623e9158f191f',2,'a3990d83af973bd48e58def890054791'),(7,16,'582629f07b174cba871fd7ba145dedbe',2,'a3990d83af973bd48e58def890054791'),(8,17,'d8868c9b1232485b8d27cbe2b2c68924',1,'a3990d83af973bd48e58def890054791'),(9,17,'ca814c4927ef49bfaa6921a1b0dabb74',1,'a3990d83af973bd48e58def890054791'),(10,17,'020b32b5521b45528daa91cc84c2775e',1,'a3990d83af973bd48e58def890054791'),(11,17,'a9c47ba036324faca2f9a345c7a133f1',1,'a3990d83af973bd48e58def890054791'),(12,17,'fec063695deb4d698030b816da868ee1',2,'a3990d83af973bd48e58def890054791'),(13,17,'55b467c546de422d829623e9158f191f',2,'a3990d83af973bd48e58def890054791'),(14,17,'582629f07b174cba871fd7ba145dedbe',2,'a3990d83af973bd48e58def890054791'),(15,18,'d8868c9b1232485b8d27cbe2b2c68924',1,'a3990d83af973bd48e58def890054791'),(16,18,'ca814c4927ef49bfaa6921a1b0dabb74',1,'a3990d83af973bd48e58def890054791'),(17,18,'020b32b5521b45528daa91cc84c2775e',1,'a3990d83af973bd48e58def890054791'),(18,18,'a9c47ba036324faca2f9a345c7a133f1',1,'a3990d83af973bd48e58def890054791'),(19,18,'fec063695deb4d698030b816da868ee1',2,'a3990d83af973bd48e58def890054791'),(20,18,'55b467c546de422d829623e9158f191f',2,'a3990d83af973bd48e58def890054791'),(21,18,'582629f07b174cba871fd7ba145dedbe',2,'a3990d83af973bd48e58def890054791'),(22,19,'d8868c9b1232485b8d27cbe2b2c68924',1,'a3990d83af973bd48e58def890054791'),(23,19,'ca814c4927ef49bfaa6921a1b0dabb74',1,'a3990d83af973bd48e58def890054791'),(24,19,'020b32b5521b45528daa91cc84c2775e',1,'a3990d83af973bd48e58def890054791'),(25,19,'a9c47ba036324faca2f9a345c7a133f1',1,'a3990d83af973bd48e58def890054791'),(26,19,'fec063695deb4d698030b816da868ee1',2,'a3990d83af973bd48e58def890054791'),(27,19,'55b467c546de422d829623e9158f191f',2,'a3990d83af973bd48e58def890054791'),(28,19,'582629f07b174cba871fd7ba145dedbe',2,'a3990d83af973bd48e58def890054791'),(29,20,'d8868c9b1232485b8d27cbe2b2c68924',1,'a3990d83af973bd48e58def890054791'),(30,20,'ca814c4927ef49bfaa6921a1b0dabb74',1,'a3990d83af973bd48e58def890054791'),(31,20,'020b32b5521b45528daa91cc84c2775e',1,'a3990d83af973bd48e58def890054791'),(32,20,'a9c47ba036324faca2f9a345c7a133f1',1,'a3990d83af973bd48e58def890054791'),(33,20,'fec063695deb4d698030b816da868ee1',2,'a3990d83af973bd48e58def890054791'),(34,20,'55b467c546de422d829623e9158f191f',2,'a3990d83af973bd48e58def890054791'),(35,20,'582629f07b174cba871fd7ba145dedbe',2,'a3990d83af973bd48e58def890054791'),(36,21,'d8868c9b1232485b8d27cbe2b2c68924',1,'a3990d83af973bd48e58def890054791'),(37,21,'ca814c4927ef49bfaa6921a1b0dabb74',1,'a3990d83af973bd48e58def890054791'),(38,21,'020b32b5521b45528daa91cc84c2775e',1,'a3990d83af973bd48e58def890054791'),(39,21,'a9c47ba036324faca2f9a345c7a133f1',1,'a3990d83af973bd48e58def890054791'),(40,21,'fec063695deb4d698030b816da868ee1',2,'a3990d83af973bd48e58def890054791'),(41,21,'55b467c546de422d829623e9158f191f',2,'a3990d83af973bd48e58def890054791'),(42,21,'582629f07b174cba871fd7ba145dedbe',2,'a3990d83af973bd48e58def890054791'),(43,22,'d8868c9b1232485b8d27cbe2b2c68924',1,'a3990d83af973bd48e58def890054791'),(44,22,'ca814c4927ef49bfaa6921a1b0dabb74',1,'a3990d83af973bd48e58def890054791'),(45,22,'020b32b5521b45528daa91cc84c2775e',1,'a3990d83af973bd48e58def890054791'),(46,22,'a9c47ba036324faca2f9a345c7a133f1',1,'a3990d83af973bd48e58def890054791'),(47,22,'fec063695deb4d698030b816da868ee1',2,'a3990d83af973bd48e58def890054791'),(48,22,'55b467c546de422d829623e9158f191f',2,'a3990d83af973bd48e58def890054791'),(49,22,'582629f07b174cba871fd7ba145dedbe',2,'a3990d83af973bd48e58def890054791'),(50,23,'d8868c9b1232485b8d27cbe2b2c68924',1,'a3990d83af973bd48e58def890054791'),(51,23,'ca814c4927ef49bfaa6921a1b0dabb74',1,'a3990d83af973bd48
/*!40000 ALTER TABLE `kpobject_writeuser_1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kppc_userinfo`
--

DROP TABLE IF EXISTS `kppc_userinfo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `kppc_userinfo` (
  `id` varchar(50) NOT NULL COMMENT '主键',
  `pc_id` varchar(50) DEFAULT NULL COMMENT '批次id',
  `write_id` int DEFAULT NULL COMMENT '填报id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kppc_userinfo`
--

LOCK TABLES `kppc_userinfo` WRITE;
/*!40000 ALTER TABLE `kppc_userinfo` DISABLE KEYS */;
INSERT INTO `kppc_userinfo` VALUES ('2108b3b337514e329062fb4adcc18ad7','a3990d83af973bd48e58def890054791',25),('26074060328b44d49f5a23be3f626f12','a3990d83af973bd48e58def890054791',16),('4bdbd3a9752f4e699fdcc1d5ca1e72a5','a3990d83af973bd48e58def890054791',24),('5474f4c9a64a4c4c83689da6a028cf66','a3990d83af973bd48e58def890054791',17),('5c3abeffe0b646d09f0efe3c8659408a','a3990d83af973bd48e58def890054791',22),('61efc100e8ad4492b18ae474ab5bc6d3','a3990d83af973bd48e58def890054791',19),('8af73f3db0954a0b939e249a951b8a4c','a3990d83af973bd48e58def890054791',21),('bf3e017beb8549a0899beb9326113074','a3990d83af973bd48e58def890054791',18),('c356aa2e17d749d1a030cab51a7722b8','a3990d83af973bd48e58def890054791',20),('f9c2273c135940e7a1998503f654b089','a3990d83af973bd48e58def890054791',23);
/*!40000 ALTER TABLE `kppc_userinfo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_des1`
--

DROP TABLE IF EXISTS `log_des1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `log_des1` (
  `log_id` varchar(50) NOT NULL,
  `log_type` int NOT NULL COMMENT '状态值,1是访问 2是添加 3编辑 4删除 5登录 6离开7异常8其他',
  `controller_name` varchar(500) NOT NULL COMMENT '控制器路径',
  `action_name` varchar(100) NOT NULL COMMENT '方法名',
  `operator` varchar(50) DEFAULT NULL COMMENT '登入的loginName',
  `operate_time` varchar(50) NOT NULL COMMENT '访问时间',
  `request_type` varchar(50) DEFAULT NULL COMMENT '请求方式(get\\post\\update\\delect)',
  `request_ip` varchar(50) DEFAULT NULL COMMENT '请求id',
  `request_url` varchar(200) DEFAULT NULL COMMENT '请求路径',
  `request_para` varchar(200) DEFAULT NULL COMMENT '传递参数(键)',
  `request_val` longtext COMMENT '传递参数(值)',
  `old_val` longtext COMMENT '原来的值',
  `new_val` longtext COMMENT '新值',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `signature` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '签名',
  PRIMARY KEY (`log_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_des1`
--

LOCK TABLES `log_des1` WRITE;
/*!40000 ALTER TABLE `log_des1` DISABLE KEYS */;
INSERT INTO `log_des1` VALUES ('0000cd20b3694d9a8cd31a52859644f7',1,'com.syxsoft.cadre.auth.controller.RoleinfoController','getOneRole','2','2022-01-19 15:59:52','POST','127.0.0.1','http://127.0.0.1:1721/roleinfo/getOneRole','[rid]','[4]',NULL,NULL,'','MEUCIQCVHevOP5sO3kAcZULo/snUCHkosXhNTtBiBn8pGeyLdwIgPy03bP9fDv2MC5K1CqTc7CQjmTK8nyk2FC3yP+gTlYs='),('000a498331b4429ca079eb4980de92a4',1,'com.syxsoft.cadre.auth.controller.MenuController','getPermissMenu','2','2022-01-14 16:53:50','POST','127.0.0.1','http://127.0.0.1:1721/menu/getPermissMenu','[]','[]',NULL,NULL,'',NULL),('001a058519564ea3a1c81e61c2ba9e1f',1,'com.syxsoft.cadre.evaluation.controller.KpFormIdentityController','SelectTree','2','2022-01-24 22:48:11','GET','127.0.0.1','http://127.0.0.1:1721/kpformidentity/getztree','[tid, wid, systemId]','[2, 1, 89f8b0e5202b064c570c356ff9b4fe5b]',NULL,NULL,'',NULL),('0029a84e73da4091bfe7651f5b8b284c',1,'com.syxsoft.cadre.auth.controller.DictionariesController','getSelected','','2022-01-21 12:16:56','GET','127.0.0.1','http://127.0.0.1:1721/dictionaries/getSelected','[s005001ListStr, systemId]','[[\"systemName\"], null]',NULL,NULL,'','MEYCIQDUX6C8zsPQf31QDJvzdI/HDi918cW5j/KlFwrUcc68rAIhAMQBQgm4bPcxfkTxDVXszO6POe301MYsfsrxZc5bdgij'),('002da459c4ed4efcb5374616d68eda87',1,'com.syxsoft.cadre.auth.controller.SubsystemController','findOneSystemDetails','7','2022-01-17 16:09:27','GET','127.0.0.1','http://127.0.0.1:1721/subsystem/findOneSystemDetails','[systemId]','[89f8b0e5202b064c570c356ff9b4fe5b]',NULL,NULL,'',NULL),('002e90bb4e0f497984d6881334a5ab16',1,'com.syxsoft.cadre.evaluation.controller.UsermanagerController','selectDepUser','2','2022-01-25 16:20:30','GET','127.0.0.1','http://127.0.0.1:1721/usermanager/selectdepuser','[tid, systemId]','[null, 89f8b0e5202b064c570c356ff9b4fe5b]',NULL,NULL,'',NULL),('00374ca9f96043fa85c5273f5505a279',1,'com.syxsoft.cadre.evaluation.controller.DepmanagerController','selectDep','9','2022-01-24 11:06:33','GET','127.0.0.1','http://127.0.0.1:1721/depment/selectdep','[tid, systemId]','[null, 89f8b0e5202b064c570c356ff9b4fe5b]',NULL,NULL,'',NULL),('004b379e2d01446982f1a7e35ac6a4f9',1,'com.syxsoft.cadre.auth.controller.DictionariesController','getSelected','','2022-01-12 16:08:45','GET','127.0.0.1','http://127.0.0.1:1721/dictionaries/getSelected','[s005001ListStr, systemId]','[[\"systemName\"], null]',NULL,NULL,'',NULL),('005d62a08bf3474ab145f8c3c63a7eb4',7,'com.syxsoft.cadre.evaluation.controller.KpResultController','clearAndCal','2','2022-01-24 23:59:38','POST','127.0.0.1','http://127.0.0.1:1721/KpResult/clearAndCal','[kpWorkId, piCiIdArr, systemId]','[1, a3990d83af973bd48e58def890054791, 89f8b0e5202b064c570c356ff9b4fe5b]',NULL,NULL,'计算失败！',NULL),('0087696ced2e407a83b6bc731b2e8c88',1,'com.syxsoft.cadre.auth.controller.MenuController','getfunctionByMid','7','2022-01-18 09:40:54','GET','127.0.0.1','http://127.0.0.1:1721/menu/getfunctionByMid','[mid, systemId]','[33, 89f8b0e5202b064c570c356ff9b4fe5b]',NULL,NULL,'',NULL),('00fa5add65d0437f8232b3bde67ee2fe',1,'com.syxsoft.cadre.auth.controller.MenuController','getfunctionByMid','1','2022-01-18 15:55:58','GET','127.0.0.1','http://127.0.0.1:1721/menu/getfunctionByMid','[mid, systemId]','[3, -1]',NULL,NULL,'','MEQCIG7yyh+HKct5vVhJjn+MPoPTiOrK4NMXHF/Q8tw+vz42AiBzgkKXmXvtGvDtTKz9noiAyvPA6JYhk7kcjtgm4Mf+bw=='),('010477176739453294007d548925f78e',1,'com.syxsoft.cadre.auth.controller.RoleinfoController','getRoleList','2','2022-01-19 16:04:30','POST','127.0.0.1','http://127.0.0.1:1721/roleinfo/getRoleList','[roleName, uid, systemId]','[, 10, 89f8b0e5202b064c570c356ff9b4fe5b]',NULL,NULL,'','MEUCIDb8/oA/64+ADadihhTVJEjL9qQDd7KGMCIgWjOF54JfAiEAwC/hJoOd3abmSn+RrH8CdmT3jg4V+nfoooUz0nqdgdA='),('011187e3debb4251b9ab94e250801601',1,'com.syxsoft.cadre.auth.controller.DictionariesController','getSelected','','2022-01-14 15:03:09','GET','127.0.0.1','http://127.0.0.1:1721/dictionaries/getSelected','[s005001ListStr, systemId]','[[\"pageWording\"], -1]',NULL,NULL,'',NULL),('011874ae973c40908ae36b803efac834',1,'com.syxsoft.cadre.auth.controller.SubsystemController','findO
/*!40000 ALTER TABLE `log_des1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_mapping`
--

DROP TABLE IF EXISTS `log_mapping`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `log_mapping` (
  `log_id` int NOT NULL AUTO_INCREMENT COMMENT 'uuid',
  `controller_name` varchar(500) DEFAULT NULL COMMENT '模块名称',
  `action_name` varchar(100) DEFAULT NULL COMMENT '操作名称',
  `controller_mapping` varchar(100) DEFAULT NULL COMMENT '模块中文',
  `action_mapping` varchar(100) DEFAULT NULL COMMENT '操作中文',
  PRIMARY KEY (`log_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=203 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_mapping`
--

LOCK TABLES `log_mapping` WRITE;
/*!40000 ALTER TABLE `log_mapping` DISABLE KEYS */;
INSERT INTO `log_mapping` VALUES (1,'com.syxsoft.cadre.auth.controller.DictionariesController','insertOne','字典管理(内置)','新增一条字典数据'),(2,'com.syxsoft.cadre.auth.controller.DictionariesController','selectAllPage','字典管理(内置)','查询内置数据'),(3,'com.syxsoft.cadre.auth.controller.DictionariesController','selectAll','字典管理(内置)','查询内置数据'),(4,'com.syxsoft.cadre.auth.controller.DictionariesController','getSelected','字典管理(内置)','查询内置数据'),(5,'com.syxsoft.cadre.auth.controller.DictionariesController','getSelectedOne','字典管理(内置)','查询内置数据'),(6,'com.syxsoft.cadre.auth.controller.DictionariesController','add','字典管理(内置)','新增一条字典内置数据'),(7,'com.syxsoft.cadre.auth.controller.DictionariesController','edit','字典管理(内置)','修改一条字典内置数据'),(8,'com.syxsoft.cadre.auth.controller.DictionariesController','del','字典管理(内置)','删除一条字典内置数据'),(9,'com.syxsoft.cadre.auth.controller.MenuController','getAllMenu','菜单管理','查询所有菜单'),(10,'com.syxsoft.cadre.auth.controller.MenuController','addMenu','菜单管理','新增一条菜单'),(11,'com.syxsoft.cadre.auth.controller.MenuController','editMenu','菜单管理','修改一条菜单'),(12,'com.syxsoft.cadre.auth.controller.MenuController','updateMenu','菜单管理','修改一条菜单'),(13,'com.syxsoft.cadre.auth.controller.MenuController','delMenu','菜单管理','删除一条菜单'),(14,'com.syxsoft.cadre.auth.controller.MenuController','getfunctionByMid','菜单管理','查询当前菜单下所有按钮'),(15,'com.syxsoft.cadre.auth.controller.MenuController','addFunc','菜单管理','新增按钮'),(16,'com.syxsoft.cadre.auth.controller.MenuController','getOneFunc','菜单管理','查询一个按钮'),(17,'com.syxsoft.cadre.auth.controller.MenuController','editFunc','菜单管理','修改一个按钮名称'),(18,'com.syxsoft.cadre.auth.controller.MenuController','delFunc','菜单管理','删除一个按钮名称'),(19,'com.syxsoft.cadre.auth.controller.MenuController','copyFunc','菜单管理','复制一个菜单'),(20,'com.syxsoft.cadre.auth.controller.MenuController','delAllFunc','菜单管理','删除当前菜单下所有方法'),(21,'com.syxsoft.cadre.auth.controller.MenuController','getAllMenuFuncByRid','菜单管理','查询角色下所有菜单'),(22,'com.syxsoft.cadre.auth.controller.MenuController','saveMenuFuncs','菜单管理','保存角色对应的菜单与方法'),(23,'com.syxsoft.cadre.auth.controller.MenuController','getFuns','菜单管理','查询所有方法'),(24,'com.syxsoft.cadre.auth.controller.MenuController','getPermissMenu','菜单管理','查询角色菜单'),(25,'com.syxsoft.cadre.auth.controller.RoleinfoController','getRoleList','角色管理','查询所有角色'),(26,'com.syxsoft.cadre.auth.controller.RoleinfoController','getRoleListMore','角色管理','查询所有角色'),(27,'com.syxsoft.cadre.auth.controller.RoleinfoController','addrole','角色管理','新增一个角色'),(28,'com.syxsoft.cadre.auth.controller.RoleinfoController','editrole','角色管理','修改一个角色'),(29,'com.syxsoft.cadre.auth.controller.RoleinfoController','getOneRole','角色管理','查询一个角色'),(30,'com.syxsoft.cadre.auth.controller.RoleinfoController','delrole','角色管理','删除一个角色'),(31,'com.syxsoft.cadre.auth.controller.RoleinfoController','selectRoleGroupMore','角色管理','查询所有角色分组'),(32,'com.syxsoft.cadre.auth.controller.RoleinfoController','insertRoleGroup','角色管理','新增一个角色分组'),(33,'com.syxsoft.cadre.auth.controller.RoleinfoController','selectRoleGroup','角色管理','查询当前角色分组下所有角色'),(34,'com.syxsoft.cadre.auth.controller.RoleinfoController','updateRoleGroup','角色管理','修改一个角色分组'),(35,'com.syxsoft.cadre.auth.controller.RoleinfoController','delRoleGroup','角色管理','删除一个角色分组'),(36,'com.syxsoft.cadre.auth.controller.RoleinfoController','sel
/*!40000 ALTER TABLE `log_mapping` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log_route`
--

DROP TABLE IF EXISTS `log_route`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `log_route` (
  `route_id` varchar(50) NOT NULL,
  `route_table` varchar(50) DEFAULT NULL COMMENT '日志表名',
  `start_time` varchar(50) DEFAULT NULL COMMENT '开始时间',
  `end_time` varchar(50) DEFAULT NULL COMMENT '结束时间',
  `route_sort` int DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`route_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log_route`
--

LOCK TABLES `log_route` WRITE;
/*!40000 ALTER TABLE `log_route` DISABLE KEYS */;
INSERT INTO `log_route` VALUES ('0a956f56b4fd478390d8f5fa276102cf','log_des1','2019-07-01 00:00:00','2022-01-25 16:58:19',1);
/*!40000 ALTER TABLE `log_route` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `login_write_user`
--

DROP TABLE IF EXISTS `login_write_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `login_write_user` (
  `id` varchar(50) NOT NULL COMMENT '主键',
  `login_name` varchar(50) DEFAULT NULL COMMENT '登录用户名',
  `write_id` int DEFAULT NULL COMMENT '填报id',
  `batch_id` varchar(50) DEFAULT NULL COMMENT '批次id',
  `work_id` varchar(50) DEFAULT NULL COMMENT '工作id',
  `system_id` varchar(50) DEFAULT NULL COMMENT '系统id',
  `one_card` varchar(255) DEFAULT NULL COMMENT '一卡通',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `login_write_user`
--

LOCK TABLES `login_write_user` WRITE;
/*!40000 ALTER TABLE `login_write_user` DISABLE KEYS */;
/*!40000 ALTER TABLE `login_write_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `person_middle_table`
--

DROP TABLE IF EXISTS `person_middle_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `person_middle_table` (
  `person_name` varchar(50) DEFAULT NULL COMMENT '姓名',
  `dep_id` varchar(50) DEFAULT NULL COMMENT '所属部门id',
  `job_title` varchar(255) DEFAULT NULL COMMENT '职务',
  `person_sort` int DEFAULT NULL COMMENT '人员排序',
  `person_key` varchar(50) DEFAULT NULL COMMENT '一卡通'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `person_middle_table`
--

LOCK TABLES `person_middle_table` WRITE;
/*!40000 ALTER TABLE `person_middle_table` DISABLE KEYS */;
/*!40000 ALTER TABLE `person_middle_table` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `revocation_record`
--

DROP TABLE IF EXISTS `revocation_record`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `revocation_record` (
  `id` varchar(50) NOT NULL COMMENT '主键id',
  `pc_id` varchar(50) DEFAULT NULL COMMENT '批次id',
  `login_name` varchar(50) DEFAULT NULL COMMENT '登入名',
  `revocation_time` varchar(50) DEFAULT NULL COMMENT '撤销时间',
  `revocation_user` varchar(50) DEFAULT NULL COMMENT '操作撤销的用户',
  `status` int DEFAULT NULL COMMENT '状态 1表示成功2表示失败',
  `revocation_described` varchar(50) DEFAULT NULL COMMENT '撤销描述',
  `identity_type` int DEFAULT NULL COMMENT '匿名还是实名',
  `one_card` varchar(255) DEFAULT NULL COMMENT '一卡通',
  `system_id` varchar(50) DEFAULT NULL COMMENT '子系统',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `revocation_record`
--

LOCK TABLES `revocation_record` WRITE;
/*!40000 ALTER TABLE `revocation_record` DISABLE KEYS */;
/*!40000 ALTER TABLE `revocation_record` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `role_b01`
--

DROP TABLE IF EXISTS `role_b01`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `role_b01` (
  `id` varchar(50) NOT NULL COMMENT 'id,唯一标识',
  `r_id` int DEFAULT NULL COMMENT '角色id',
  `b_id` varchar(50) DEFAULT NULL COMMENT '部门id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `role_b01`
--

LOCK TABLES `role_b01` WRITE;
/*!40000 ALTER TABLE `role_b01` DISABLE KEYS */;
/*!40000 ALTER TABLE `role_b01` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `role_group`
--

DROP TABLE IF EXISTS `role_group`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `role_group` (
  `group_id` varchar(50) NOT NULL COMMENT '角色分组id',
  `role_group_name` varchar(500) DEFAULT NULL COMMENT '角色分组名称',
  `del_status` int DEFAULT NULL COMMENT '是否被删除 1为正常 2为删除',
  `sort` int DEFAULT NULL COMMENT '排序',
  `system_id` varchar(50) DEFAULT NULL COMMENT '子系统id',
  PRIMARY KEY (`group_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `role_group`
--

LOCK TABLES `role_group` WRITE;
/*!40000 ALTER TABLE `role_group` DISABLE KEYS */;
INSERT INTO `role_group` VALUES ('331d6cc557b78341ec1e975f3464c97a','长沙理工大学中层干部年度考核内置角色',1,1,'89f8b0e5202b064c570c356ff9b4fe5b');
/*!40000 ALTER TABLE `role_group` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `s005_1`
--

DROP TABLE IF EXISTS `s005_1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `s005_1` (
  `id` varchar(50) NOT NULL COMMENT '选项key',
  `s005001` varchar(50) DEFAULT NULL COMMENT '选项类性的id （ExField 表里的id）',
  `s005003` int DEFAULT NULL COMMENT '排序\r\n            ',
  `s005004` varchar(1000) DEFAULT NULL,
  `s005007` varchar(50) DEFAULT NULL COMMENT '父级节点',
  `s005008` varchar(50) DEFAULT NULL COMMENT '预留',
  `del_status` int DEFAULT NULL COMMENT '是否删除',
  `system_id` varchar(50) DEFAULT NULL COMMENT '子系统id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `s005_1`
--

LOCK TABLES `s005_1` WRITE;
/*!40000 ALTER TABLE `s005_1` DISABLE KEYS */;
INSERT INTO `s005_1` VALUES ('1','writeIdentityMode',1,'后台管理员设置',NULL,NULL,1,NULL),('2','writeIdentityMode',2,'自己选择',NULL,NULL,1,NULL),('1','kpObjectType',1,'班子',NULL,NULL,1,NULL),('2','kpObjectType',2,'人员',NULL,NULL,1,NULL),('1','showTableType',1,'多人表',NULL,NULL,1,NULL),('2','showTableType',2,'单人表',NULL,NULL,1,NULL),('3','showTableType',3,'文本表',NULL,NULL,2,NULL),('4','showTableType',4,'问卷表',NULL,NULL,1,NULL),('1','optionClass',1,'单选题',NULL,NULL,1,NULL),('2','optionClass',2,'多选题',NULL,NULL,1,NULL),('3','optionClass',3,'填空题',NULL,NULL,1,NULL),('4','optionClass',4,'问答题',NULL,NULL,2,NULL),('2652db4ba28129294a8c5c660a73ffaa','gapEndday',1,'6',NULL,'批次距离多少天',1,'-1'),('ed74a0704a5048050700ccfacdc704d8','timeNumber',2,'24',NULL,'小时数间距',1,'-1'),('aba494d9da321f775b39b85fa1a135f2','countNumber',3,'12',NULL,'存在多少个数',1,'-1'),('span_one_card','pageWording',1,'一卡通号','','一卡通号',1,'-1'),('span_person_type','pageWording',2,'教工代表','','教工代表',1,'-1'),('03d273f823ea45a7abdf59c919cb0125','realNamePath',1,'a5bbb48e3b2c9c89472bc712d2abff13',NULL,'单点登录地址',1,NULL),('82c6b98cbbc64e7a83ae51c62a91dddc','isOpenSSO',1,'3b900eff66978414151dd18fe787cb55',NULL,'是否开启单点登录',1,NULL),('5ff721ff73344bb0875d6959722a0dcb','systemName',1,'f570c9b08677985005ad3e963b152b36a608c8b39dd3b35408ad1249b7fd293f',NULL,'系统名称',1,NULL),('span_one_card','pageWording',1,'一卡通号','','一卡通号',1,'89f8b0e5202b064c570c356ff9b4fe5b'),('span_person_type','pageWording',2,'教工代表','','教工代表',1,'89f8b0e5202b064c570c356ff9b4fe5b'),('cc51667424f23c5943f631f2aacca748','gapEndday',1,'0',NULL,'批次距离多少天',1,'89f8b0e5202b064c570c356ff9b4fe5b'),('e9959aa087946e6465e19314b824ccb8','timeNumber',2,'6',NULL,'小时间隔段',1,'89f8b0e5202b064c570c356ff9b4fe5b'),('765b00c253bd99288a8ae958fd4cbcfa','countNumber',3,'6',NULL,'点数',1,'89f8b0e5202b064c570c356ff9b4fe5b'),('d737a96412c460e51394ba6a533508a2','submissionRate',4,'90',NULL,'提交合格率',1,'89f8b0e5202b064c570c356ff9b4fe5b'),('31bd582fa3183e072352dbab34ed4229','b01_ext1',3,'单位扩展1','b01','单位扩展1',1,'89f8b0e5202b064c570c356ff9b4fe5b'),('ec5dddcee8eadb6cc00b4ac57ae292ac','b01_ext2',4,'单位扩展2','b01','单位扩展2',1,'89f8b0e5202b064c570c356ff9b4fe5b'),('40230e389be9a9bfae10788799c7a353','b01_ext3',5,'单位扩展3','b01','单位扩展3',1,'89f8b0e5202b064c570c356ff9b4fe5b'),('c33cfd1ca7c8960bbd77ebb4275dd6fb','a01_ext1',6,'人员扩展1','a01','人员扩展1',1,'89f8b0e5202b064c570c356ff9b4fe5b'),('9fc3a971fb59546afeee5cdb600e840e','a01_ext2',7,'人员扩展2','a01','人员扩展2',1,'89f8b0e5202b064c570c356ff9b4fe5b'),('76b4a84aa95adcdade2db5838abfb3c9','a01_ext3',8,'人员扩展3','a01','人员扩展3',1,'89f8b0e5202b064c570c356ff9b4fe5b'),('b6a65775956b52eaa41c54f4a7afa085','a01_ext4',9,'人员扩展4','a01','人员扩展4',1,'89f8b0e5202b064c570c356ff9b4fe5b'),('1c7ae4de58b8020fedb64a3320a8d23f','a01_ext5',10,'人员扩展5','a01','人员扩展5',1,'89f8b0e5202b064c570c356ff9b4fe5b'),('c30361fcf83ba49b4fb9f15fdd1bf51e','dep_name',11,'单位','b01','单位',1,'89f8b0e5202b064c570c356ff9b4fe5b'),('0d1880f3721dc8f76643171a61eab94b','present_occupation',12,'职务','a01','职务',1,'89f8b0e5202b064c570c356ff9b4fe5b');
/*!40000 ALTER TABLE `s005_1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `short_message_recording`
--

DROP TABLE IF EXISTS `short_message_recording`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `short_message_recording` (
  `id` varchar(50) NOT NULL COMMENT '主键GUID',
  `telephone` varchar(50) NOT NULL COMMENT '联系电话',
  `short_content` varchar(50) NOT NULL COMMENT '短信类容',
  `verification_code` varchar(50) NOT NULL COMMENT '验证码',
  `short_id` varchar(50) NOT NULL COMMENT '短信id（平台返回的id）',
  `add_time` varchar(50) NOT NULL COMMENT '短信发送时间系统时间  数据库默认获取当前时间  不需要添加',
  `massge_type` int NOT NULL COMMENT '短信类型： 验证码 、回复型',
  `return_status_code` int NOT NULL COMMENT '短信发送是否成功 1成功 0失败',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `short_message_recording`
--

LOCK TABLES `short_message_recording` WRITE;
/*!40000 ALTER TABLE `short_message_recording` DISABLE KEYS */;
INSERT INTO `short_message_recording` VALUES ('1fceaa89b953eaca6033d249cad596f1','18571542526','您本次验证码为405252,10分钟内有效!','405252','405252','2021-12-28 16:31:53',0,1),('341b888b2c472c306c2d80aeab2c61f6','18571542526','您本次验证码为908955,10分钟内有效!','908955','908955','2021-12-28 13:55:52',0,1),('4a5a5eb946d0bfbd37efd80f7dce1065','18571542526','您本次验证码为264639,10分钟内有效!','264639','264639','2021-12-28 15:10:55',0,1),('4e6df4771ecac7342a4b49afe2186c81','18571542526','您本次验证码为687747,10分钟内有效!','687747','687747','2021-12-28 16:35:49',0,1),('8e8c9a14f28ff7f4a488a591f6500fd5','18571542526','您本次验证码为922801,10分钟内有效!','922801','922801','2021-12-29 09:45:23',0,1),('eab3b6535c659cc664a2b146a713522a','18571542526','您本次验证码为933835,10分钟内有效!','933835','933835','2021-12-28 16:34:44',0,1);
/*!40000 ALTER TABLE `short_message_recording` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subsystem_table`
--

DROP TABLE IF EXISTS `subsystem_table`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `subsystem_table` (
  `system_id` varchar(50) NOT NULL COMMENT 'uuid,子系统id',
  `system_name` varchar(500) DEFAULT NULL COMMENT '系统名称',
  `whether_open` int DEFAULT NULL COMMENT '是否开启,1为开启,2为关闭',
  `create_time` varchar(50) DEFAULT NULL COMMENT '创建时间',
  `start_time` varchar(50) DEFAULT NULL COMMENT '开启时间',
  `end_time` varchar(50) DEFAULT NULL COMMENT '结束时间',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `personnel_information` int DEFAULT NULL COMMENT '是否开启人员信息校对 1是开启 0是关闭',
  `assessment_monitoring` int DEFAULT NULL COMMENT '是否开启考评监控 1是开启 0是关闭',
  `system_logo` longtext COMMENT '存储图片的base64码',
  `file_name` varchar(100) DEFAULT NULL COMMENT '文件名',
  `file_size` varchar(20) DEFAULT NULL COMMENT '文件大小',
  `synchronous_account` int DEFAULT NULL COMMENT '是否同步账号, 1同步 2不同步,如果同步需要在sysuserinfo添加实名账号',
  `whether_synchronization` int DEFAULT NULL COMMENT '是否同步过,1没有同步过 2 同步过',
  PRIMARY KEY (`system_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subsystem_table`
--

LOCK TABLES `subsystem_table` WRITE;
/*!40000 ALTER TABLE `subsystem_table` DISABLE KEYS */;
INSERT INTO `subsystem_table` VALUES ('-1','初始化系统',1,'2020.04.16 15:26:06','2020.04.16 15:26:06','','初始化系统',NULL,NULL,NULL,NULL,NULL,1,1),('89f8b0e5202b064c570c356ff9b4fe5b','长沙理工大学中层干部年度考核',1,'2021-12-20 21:12:33',NULL,NULL,NULL,0,0,NULL,NULL,NULL,1,1);
/*!40000 ALTER TABLE `subsystem_table` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sysfunction`
--

DROP TABLE IF EXISTS `sysfunction`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sysfunction` (
  `f_id` int NOT NULL AUTO_INCREMENT COMMENT '主键自增',
  `m_id` int DEFAULT NULL COMMENT '菜单id',
  `f_name` varchar(50) DEFAULT NULL COMMENT '功能名称',
  `f_function` varchar(50) DEFAULT NULL COMMENT '功能调用的方法名称',
  `f_picname` varchar(200) DEFAULT NULL COMMENT '图片',
  `status` int DEFAULT NULL COMMENT '状态',
  `f_sort` int DEFAULT NULL COMMENT '排序',
  `system_id` varchar(50) DEFAULT NULL COMMENT '子系统id',
  `f_type` int DEFAULT NULL COMMENT '按钮状态 0 表格上的按钮 1 是图片 2是缩放块里面的 3 是非表格按钮',
  `f_css` varchar(255) DEFAULT NULL COMMENT '方法的css样式名',
  `f_url` varchar(255) DEFAULT NULL COMMENT '如果存在多个权限控制时候区分',
  `f_buttonid` varchar(50) DEFAULT NULL COMMENT '按钮id',
  `port_url` varchar(255) DEFAULT NULL COMMENT '接口地址',
  PRIMARY KEY (`f_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=201 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sysfunction`
--

LOCK TABLES `sysfunction` WRITE;
/*!40000 ALTER TABLE `sysfunction` DISABLE KEYS */;
INSERT INTO `sysfunction` VALUES (1,22,'删除','del()','',1,3,'-1',1,'easyui-linkbutton my-tools','',NULL,'12'),(2,14,'创建实名','add()','',1,6,'-1',0,'easyui-linkbutton','/admin/work/createAccount/create_account_index.html?type=2',NULL,'12'),(3,14,'实名修改','edit()','',1,7,'-1',1,'easyui-linkbutton my-tools','/admin/work/createAccount/create_account_index.html?type=2',NULL,'12'),(4,14,'实名删除','del()','',1,8,'-1',1,'easyui-linkbutton my-tools','/admin/work/createAccount/create_account_index.html?type=2',NULL,'12'),(5,14,'导出所选','uploadChecked()','',1,9,'-1',2,'iconfont','/admin/work/createAccount/create_account_index.html?type=2',NULL,'12'),(6,14,'批量创建实名','loadAll()','',1,10,'-1',2,'iconfont','/admin/work/createAccount/create_account_index.html?type=2',NULL,'12'),(7,2,'新增','add()','',1,1,'-1',0,'easyui-linkbutton',NULL,NULL,'12'),(8,2,'编辑','edit()','',1,2,'-1',1,'easyui-linkbutton my-tools',NULL,NULL,'12'),(9,2,'删除','del()','',1,3,'-1',1,'easyui-linkbutton my-tools',NULL,NULL,'12'),(10,2,'批量配置管理账户','addMoreAdmin()','',1,4,'-1',0,'easyui-linkbutton',NULL,NULL,'12'),(11,2,'管理账号授权','setrole()','',1,5,'-1',0,'easyui-linkbutton',NULL,NULL,'12'),(14,2,'批量解锁','batchUnlock()','',1,9,'-1',2,'iconfont',NULL,NULL,'12'),(15,2,'批量锁定','batchLock()','',1,8,'-1',2,'iconfont',NULL,NULL,'12'),(16,3,'新增','add()','',1,4,'-1',0,'easyui-linkbutton','/admin/evaluate/role_management/role_index_management.html?type=2',NULL,'23'),(17,3,'编辑','edit()','',1,5,'-1',1,'easyui-linkbutton my-tools','/admin/evaluate/role_management/role_index_management.html?type=2',NULL,'23'),(18,3,'删除','del()','',1,6,'-1',1,'easyui-linkbutton my-tools','/admin/evaluate/role_management/role_index_management.html?type=2',NULL,'212'),(19,3,'批量创建','createMore()','',1,8,'-1',2,'iconfont','/admin/evaluate/role_management/role_index_management.html?type=2',NULL,'12'),(20,3,'角色授权','setB01Role()','',1,7,'-1',2,'iconfont','/admin/evaluate/role_management/role_index_management.html?type=2',NULL,'12'),(21,9,'单独导入','uploadfile()','',1,1,'-1',0,'easyui-linkbutton my-toolbtn-atop','',NULL,'12'),(22,9,'批量导入','batchLead()','',1,2,'-1',0,'easyui-linkbutton my-toolbtn-atop','',NULL,'12'),(23,9,'下载','downloadFile()','',1,3,'-1',1,'easyui-linkbutton my-tools','',NULL,'12'),(24,9,'删除','del()','',1,4,'-1',1,'easyui-linkbutton my-tools','',NULL,'21'),(25,9,'刷新表格','refreshload()','',1,5,'-1',2,'iconfont','',NULL,'2'),(29,3,'添加角色分组','addRoleGroup()','',1,1,'-1',0,'easyui-linkbutton','/admin/evaluate/role_management/role_index_management.html?type=1',NULL,'12'),(30,3,'修改角色分组','editGroup()','',1,2,'-1',1,'easyui-linkbutton my-tools','/admin/evaluate/role_management/role_index_management.html?type=1',NULL,'1212'),(31,3,'删除角色分组','delGroup()','',1,3,'-1',1,'easyui-linkbutton my-tools','/admin/evaluate/role_management/role_index_management.html?type=1',NULL,'12'),(32,22,'新增','add()','',1,1,'-1',0,'easyui-linkbutton my-toolbtn-atop','',NULL,'12'),(33,22,'修改','edit()','',1,2,'-1',1,'easyui-linkbutton my-tools','',NULL,'12'),(34,12,'删除','del()','',1,3,'-1',1,'easyui-linkbutton my-tools','',NULL,'12'),(35,12,'编辑','edit()','',1,2,'-1',1,'easyui-linkbutton my-tools','',NULL,'12'),(36,13,'新增','add()','',1,1,'-1',0,'easyui-linkbutton','',NULL,'2'),(37,13,'修改','edit()','',1,2,'-1',1,'easyui-linkbutton my-tools','',NULL,NULL),(38,13,'删除','del()','',1,3,'-1',1,'easyui-linkbutton my-tools','',NULL,NULL),(39,21,'修改','edit()','',1,1,'-1',3,'easyui-linkbutton my-toolbtn-a','',NULL,NULL),(40,21,' 清空父级','clearFu()','',1,2,'-1',3,'easyui-linkbutton my-toolbtn-a','',NULL,NULL),(41,5,'新增','add()','',1,1,'-1',
/*!40000 ALTER TABLE `sysfunction` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sysmenus`
--

DROP TABLE IF EXISTS `sysmenus`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sysmenus` (
  `m_id` int NOT NULL AUTO_INCREMENT COMMENT '主键自增',
  `p_id` int DEFAULT NULL COMMENT '父id',
  `m_name` varchar(50) DEFAULT NULL COMMENT '菜单名称',
  `m_url` varchar(500) DEFAULT NULL COMMENT '地址',
  `m_area` varchar(50) DEFAULT NULL COMMENT '区域',
  `m_controller` varchar(50) DEFAULT NULL COMMENT '控制器',
  `m_sort` int DEFAULT NULL COMMENT '排序值',
  `m_picname` varchar(200) DEFAULT NULL COMMENT '图片',
  `m_is_show_in_menu` int DEFAULT NULL COMMENT '是否显示在菜单中',
  `m_status` int DEFAULT NULL COMMENT '状态',
  `system_id` varchar(50) DEFAULT NULL COMMENT '子系统编码',
  PRIMARY KEY (`m_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sysmenus`
--

LOCK TABLES `sysmenus` WRITE;
/*!40000 ALTER TABLE `sysmenus` DISABLE KEYS */;
INSERT INTO `sysmenus` VALUES (1,-1,'系统管理','#',NULL,NULL,1,'/images/main/menu/system_management.png',1,1,'-1'),(2,1,'配置管理账号','/admin/evaluate/user_management/user_management.html',NULL,NULL,1,'#',1,1,'-1'),(3,1,'角色管理','/admin/evaluate/role_management/role_index_management.html',NULL,NULL,2,'#',1,1,'-1'),(4,1,'系统配置','/admin/evaluate/page_wording/page_wording_index.html',NULL,NULL,9,'#',1,1,'-1'),(5,1,'教工代表类别','/admin/evaluate/label_management/label_management_index.html',NULL,NULL,10,'#',1,1,'-1'),(6,-1,'组织机构管理','#',NULL,NULL,2,'/images/main/menu/organizational_structure_management.png',1,1,'-1'),(7,6,'单位管理','/admin/evaluate/dep_management/index.html',NULL,NULL,1,'#',1,1,'-1'),(8,6,'人员管理','/admin/evaluate/dep_management/user_index.html',NULL,NULL,2,'#',1,1,'-1'),(9,6,'述职报告管理后置','/admin/evaluate/report_work_management/ShuZhiBaoGaoIndex.html',NULL,NULL,3,'#',2,1,'-1'),(10,6,'教工代表维护','/admin/evaluate/label_management/label_user_index.html',NULL,NULL,4,'#',1,1,'-1'),(11,-1,'工作管理','#',NULL,NULL,3,'/images/main/menu/work_management.png',1,1,'-1'),(12,11,'考评工作','/admin/work/kp_work/index.html',NULL,NULL,1,'#',1,1,'-1'),(13,11,'批次管理','/admin/work/batch/batch_index.html',NULL,NULL,2,'#',1,1,'-1'),(14,11,'创建账号','/admin/work/createAccount/create_account_index.html',NULL,NULL,5,'#',1,1,'-1'),(15,11,'考评进度','/admin/work/reviewProgress/review_progress.html',NULL,NULL,3,'#',1,1,'-1'),(16,-1,'结果统计','#',NULL,NULL,5,'/images/main/menu/statistical_result.png',1,1,'-1'),(17,16,'结果统计','/admin/test_result/export_report/index.html',NULL,NULL,2,'#',1,1,'-1'),(18,-1,'实名用户','#',NULL,NULL,6,'/images/main/menu/real_name_user.png',1,1,'-1'),(19,18,'填报','/admin/work/real_name_landing/fillin_management.html',NULL,NULL,1,'#',1,1,'-1'),(20,11,'考评监控','/admin/work/monitoring/kp_monitoring.html',NULL,NULL,6,'#',1,1,'-1'),(21,1,'菜单管理','/admin/evaluate/menu/menu_index.html',NULL,NULL,6,'#',1,1,'-1'),(22,16,'自定义报表设置','/admin/customReportSettings/index.html',NULL,NULL,3,'#',1,1,'-1'),(23,1,'子系统管理','/admin/evaluate/subsystem/subsystem_manage.html',NULL,NULL,4,'#',1,1,'-1'),(24,6,'人员信息校对','/admin/work/person_pinfo_roofread/person_pinfo_roofread.html',NULL,NULL,2,'/images/main/menu/organizational_structure_management.png',1,1,'-1'),(25,1,'同步数据','/admin/evaluate/synchronizationAccount/synchronization_account.html',NULL,NULL,6,'#',1,1,'-1'),(26,1,'日志管理','/admin/evaluate/log/log_index.html',NULL,NULL,7,'#',1,1,'-1'),(27,11,'参评人员监控','/admin/work/reviewProgress/kp_people_status.html',NULL,NULL,4,'#',1,1,'-1'),(28,1,'系统参数配置','/admin/system/index.html',NULL,NULL,1,'#',1,1,'-1'),(29,16,'数据运算','/admin/test_result/cal_result/index.html',NULL,NULL,1,'#',1,1,'-1'),(30,6,'述职报告管理','/admin/evaluate/report_work_management/index.html',NULL,NULL,3,'#',1,1,'-1'),(31,-1,'系统管理','#',NULL,NULL,1,'/images/main/menu/system_management.png',1,1,'89f8b0e5202b064c570c356ff9b4fe5b'),(32,31,'配置管理账号','/admin/evaluate/user_management/user_management.html',NULL,NULL,1,'#',1,1,'89f8b0e5202b064c570c356ff9b4fe5b'),(33,31,'角色管理','/admin/evaluate/role_management/role_index_management.html',NULL,NULL,2,'#',1,1,'89f8b0e5202b064c570c356ff9b4fe5b'),(34,31,'系统配置','/admin/evaluate/page_wording/page_wording_index.html',NULL,NULL,9,'#',1,1,'89f8b0e5202b064c570c356ff9b4fe5b'),(35,31,'教工代表类别','/admin/evaluate/label_management/label_management_index.html',NULL,NULL,10,'#',1,1,'89f8b0e5202b064c570c356ff9b4fe5b'),(36,31,'菜单管理','/admin/evaluate/menu/menu_index.html',NULL,NULL,6,'#',1,1,'89f8b0e5202b064c570c356ff9b4fe5b'),(37,31,'同步数据','/admin/evaluate/synchronizationAccount/synchronization_account.html',NULL,NULL,6,'#',1,1,'89f8b0e5202b064c570c356ff9b4fe5b'),(38,31,'日志管理','/admin/evaluate/log/log_index.html',NULL,NULL,7,'#',1,1,'89f8b0e5202b064c570c356ff9b4fe5b'),(39
/*!40000 ALTER TABLE `sysmenus` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `syspermisslist`
--

DROP TABLE IF EXISTS `syspermisslist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `syspermisslist` (
  `pl_id` int NOT NULL AUTO_INCREMENT COMMENT '主键自增',
  `r_id` int DEFAULT NULL COMMENT '角色id',
  `m_id` int DEFAULT NULL COMMENT '菜单id',
  `f_id` int DEFAULT NULL COMMENT '功能id',
  PRIMARY KEY (`pl_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `syspermisslist`
--

LOCK TABLES `syspermisslist` WRITE;
/*!40000 ALTER TABLE `syspermisslist` DISABLE KEYS */;
INSERT INTO `syspermisslist` VALUES (1,1,1,0),(2,2,19,0),(3,3,18,0),(4,3,19,0),(5,1,23,0),(6,1,28,0),(7,4,31,0),(8,4,32,0),(9,4,32,104),(10,4,32,105),(11,4,32,106),(12,4,32,107),(13,4,32,108),(14,4,32,110),(15,4,32,109),(16,4,33,0),(17,4,33,116),(18,4,33,117),(19,4,33,118),(20,4,33,111),(21,4,33,112),(22,4,33,113),(23,4,33,115),(24,4,33,114),(25,4,36,0),(26,4,36,122),(27,4,36,123),(28,4,37,0),(29,4,38,0),(30,4,34,0),(31,4,35,0),(32,4,35,119),(33,4,35,120),(34,4,35,121),(35,4,39,0),(36,4,40,0),(37,4,40,124),(38,4,40,125),(39,4,40,126),(40,4,40,127),(41,4,40,128),(42,4,40,129),(43,4,40,130),(44,4,41,0),(45,4,41,131),(46,4,41,132),(47,4,41,133),(48,4,41,134),(49,4,41,135),(50,4,41,136),(51,4,44,0),(52,4,44,147),(53,4,44,148),(54,4,44,149),(55,4,44,150),(56,4,44,151),(57,4,44,152),(58,4,44,153),(59,4,42,0),(60,4,42,137),(61,4,42,138),(62,4,42,139),(63,4,42,140),(64,4,42,141),(65,4,45,0),(66,4,45,155),(67,4,45,154),(68,4,45,156),(69,4,43,0),(70,4,43,142),(71,4,43,143),(72,4,43,144),(73,4,43,145),(74,4,43,146),(75,4,46,0),(76,4,47,0),(77,4,47,165),(78,4,47,158),(79,4,47,157),(80,4,47,159),(81,4,47,160),(82,4,47,161),(83,4,47,162),(84,4,47,163),(85,4,47,164),(86,4,47,166),(87,4,48,0),(88,4,48,167),(89,4,48,168),(90,4,48,169),(91,4,48,170),(92,4,48,171),(93,4,48,172),(94,4,48,173),(95,4,48,176),(96,4,48,175),(97,4,48,174),(98,4,50,0),(99,4,50,189),(100,4,50,190),(101,4,52,0),(102,4,49,0),(103,4,49,182),(104,4,49,183),(105,4,49,184),(106,4,49,185),(107,4,49,186),(108,4,49,177),(109,4,49,178),(110,4,49,179),(111,4,49,180),(112,4,49,181),(113,4,49,187),(114,4,49,188),(115,4,51,0),(116,4,53,0),(117,4,56,0),(118,4,56,196),(119,4,56,197),(120,4,54,0),(121,4,55,0),(122,4,55,192),(123,4,55,193),(124,4,55,191),(125,4,55,195),(126,4,55,194),(127,4,57,0),(128,4,58,0),(129,5,58,0),(130,6,57,0),(131,6,58,0);
/*!40000 ALTER TABLE `syspermisslist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sysrole`
--

DROP TABLE IF EXISTS `sysrole`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sysrole` (
  `r_id` int NOT NULL AUTO_INCREMENT COMMENT '主键自增',
  `name` varchar(500) DEFAULT NULL COMMENT '角色名称',
  `sort` int DEFAULT NULL COMMENT '排序',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `del_status` int DEFAULT NULL COMMENT '状态值（1：启用；2：删除）',
  `type` varchar(50) DEFAULT NULL COMMENT '角色类型\r\n-1 管理员\r\n0 子系统管理员\r\n1 匿名测评用户\r\n2 实名测评用户\r\n3其他类型权限',
  `system_id` varchar(50) DEFAULT NULL COMMENT '子系统编码',
  `role_group_id` varchar(50) DEFAULT NULL COMMENT '角色分组id',
  PRIMARY KEY (`r_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sysrole`
--

LOCK TABLES `sysrole` WRITE;
/*!40000 ALTER TABLE `sysrole` DISABLE KEYS */;
INSERT INTO `sysrole` VALUES (1,'管理员',1,'管理员',1,'-1','-1',NULL),(2,'匿名用户',3,'匿名用户',1,'1','-1',NULL),(3,'实名用户',2,'实名用户',1,'2','-1',NULL),(4,'长沙理工大学中层干部年度考核子系统管理员',1,NULL,1,'0','89f8b0e5202b064c570c356ff9b4fe5b','331d6cc557b78341ec1e975f3464c97a'),(5,'长沙理工大学中层干部年度考核匿名用户',3,'匿名用户',1,'1','89f8b0e5202b064c570c356ff9b4fe5b','331d6cc557b78341ec1e975f3464c97a'),(6,'长沙理工大学中层干部年度考核实名用户',2,'实名用户',1,'2','89f8b0e5202b064c570c356ff9b4fe5b','331d6cc557b78341ec1e975f3464c97a'),(7,'123',2,NULL,1,'3','89f8b0e5202b064c570c356ff9b4fe5b','331d6cc557b78341ec1e975f3464c97a'),(8,'李四',1,NULL,1,'3','89f8b0e5202b064c570c356ff9b4fe5b','331d6cc557b78341ec1e975f3464c97a'),(9,'又是一个分组',7,NULL,1,'3','89f8b0e5202b064c570c356ff9b4fe5b','331d6cc557b78341ec1e975f3464c97a');
/*!40000 ALTER TABLE `sysrole` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sysuserinfo`
--

DROP TABLE IF EXISTS `sysuserinfo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sysuserinfo` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键自增',
  `login_name` varchar(50) NOT NULL,
  `login_password` varchar(50) DEFAULT NULL COMMENT '账号密码',
  `real_name` varchar(500) DEFAULT NULL COMMENT '真实姓名',
  `status` int DEFAULT NULL COMMENT '用户状态,-1:被锁定 1 初始化状态 2 已分配 3 填报中 4 已提交',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `type` int DEFAULT NULL COMMENT '用户类型1 实名测评的底层账号,0为普通用户,2二级子系统管理员',
  `del_status` int DEFAULT NULL COMMENT '是否删除 1为正常 2为删除',
  `add_time` varchar(50) DEFAULT NULL COMMENT '添加时间',
  `submit_time` varchar(50) DEFAULT NULL COMMENT '提交时间',
  `one_card` varchar(50) DEFAULT NULL COMMENT '一卡通',
  `system_id` varchar(50) DEFAULT NULL COMMENT '子系统编码',
  `exists_template` int DEFAULT NULL COMMENT '是否为二维码无账号填报的模板',
  `distribution_state` int DEFAULT NULL COMMENT '是否有下发,1为已经下发,2为未下发',
  `business_status` int DEFAULT NULL COMMENT '是否被锁定 1 正常 2锁定',
  `lose_num` int DEFAULT NULL,
  `lock_time` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `modify_time` varchar(50) DEFAULT NULL,
  `signature` varchar(2000) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `u_login_name` (`login_name`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sysuserinfo`
--

LOCK TABLES `sysuserinfo` WRITE;
/*!40000 ALTER TABLE `sysuserinfo` DISABLE KEYS */;
INSERT INTO `sysuserinfo` VALUES (1,'admin','26a282308406894a1e11f8dd1aa45f43','超级管理员',1,NULL,0,1,'2022-01-20 01:12:33',NULL,'admin','-1',NULL,NULL,1,0,'2021-10-28 10:15:00','2022-01-20 00:00:00',NULL),(2,'d73bffd4f96649cebbf3af31af2673e0','26a282308406894a1e11f8dd1aa45f43','长沙理工大学中层干部年度考核管理员',1,NULL,0,1,'2022-01-20 01:12:33',NULL,'administrator','89f8b0e5202b064c570c356ff9b4fe5b',NULL,NULL,1,0,'2021-10-28 10:15:00','2022-01-20 21:12:33',NULL),(3,'5c3cc21fcb324f2f9f326323f571c93d','5fec4ba8376f207d1ff2f0cac0882b01','赵阳',1,'',0,1,'2021-12-24 10:30:08',NULL,'18571542526','89f8b0e5202b064c570c356ff9b4fe5b',NULL,NULL,1,0,'2021-10-28 10:15:00','2021-12-24 10:30:08',NULL),(4,'8a2323c3c0244aacba5d11b21696d4ce','5a260dde94744b74ef6499c6bd5f5d66','测试账号1',1,'',0,1,'2022-01-11 10:39:33',NULL,'asdfg','89f8b0e5202b064c570c356ff9b4fe5b',NULL,NULL,1,0,NULL,'2022-01-11 10:39:33',NULL),(5,'4b1b75f63bc64401b2dfb36ad6d5945e','e40f01afbb1b9ae3dd6747ced5bca532','添加测试人员',1,NULL,0,1,'2022-01-13 10:09:30',NULL,'147258369','89f8b0e5202b064c570c356ff9b4fe5b',NULL,NULL,1,0,NULL,'2022-01-13 10:09:30',NULL),(6,'1e1e078274964728ab25cc644f89275e','d2e1263da46a2abdde14cca3cd2a0402','测试创建登录',1,NULL,0,1,'2022-01-14 09:49:02',NULL,'321654987','89f8b0e5202b064c570c356ff9b4fe5b',NULL,NULL,1,0,NULL,'2022-01-14 09:49:02',NULL),(7,'38fc9784bf624435a68d68254126bcdc','6118f9c3bb36a45235af3d4ce65c657a','测试创建登录2',1,NULL,0,1,'2022-01-17 09:35:16',NULL,'123456789','89f8b0e5202b064c570c356ff9b4fe5b',NULL,NULL,1,0,'5bc1fd7de8fd0365a3b81fc311ca12c7fed34207479c2af1d3048df4c7255813','2022-01-17 09:35:16',NULL),(8,'25449a36e294434aab0b72d48b475aa1','f9277477fc6238b01456aa4084edb202','管理员666',1,'',2,1,'2022-01-19 09:56:50',NULL,'666666666','89f8b0e5202b064c570c356ff9b4fe5b',NULL,NULL,1,2,NULL,'2022-01-19 09:56:50','MEUCIFdKlGmBPHG6Ytcwxs4UNazC5V2oxwdHg/rKwVtM+5UKAiEA7opX7eNWO9zO5tAAG32l/eUNWMoLMekiOxf+9h0PimY='),(9,'90f8132d6535412698553d9ec7d3abeb','4111bd55455032e2a06eacfa78f7444a','姓名',1,NULL,0,1,'2022-01-19 10:04:03',NULL,'444444444','89f8b0e5202b064c570c356ff9b4fe5b',NULL,NULL,1,0,'2021-10-28 10:15:00','2022-01-19 10:04:03',NULL),(10,'aa52dd5e8e1249cd808c48938533fc12','26a282308406894a1e11f8dd1aa45f43','888888',1,'',2,1,'2022-01-19 16:04:23',NULL,'888888','89f8b0e5202b064c570c356ff9b4fe5b',NULL,NULL,1,0,'2021-10-28 10:15:00','2022-01-19 16:04:23',NULL),(12,'fa124ce6a98b4e0eb610020229adae13','26a282308406894a1e11f8dd1aa45f43','2222',1,'',2,1,'2022-01-19 18:27:20',NULL,'administrator2','89f8b0e5202b064c570c356ff9b4fe5b',NULL,NULL,1,0,NULL,'2022-01-19 18:27:20','MEUCIQDNn6VJcs57NOLzN+lj6WMP4rgQQVd+Ls8mL4nmFKVZtwIgBIgduNj6zg+sPc8a3DS24jAGvAKv55cGMQzuP6fFNgU='),(13,'6445413ac39e4f9594a370391962922e','6060d2b4bd3450fab6cbdaf61f74f8e2','123123',1,NULL,0,1,'2022-01-20 09:48:03',NULL,'635241','89f8b0e5202b064c570c356ff9b4fe5b',NULL,NULL,1,0,NULL,'2022-01-20 09:48:03',NULL),(14,'e243e5de657b42d2b6db70e401d689cb','8e73520eefd6fe20d11462283355282a','测试权限',1,NULL,0,1,'2022-01-24 19:13:11',NULL,'789456123','89f8b0e5202b064c570c356ff9b4fe5b',NULL,NULL,1,0,NULL,'2022-01-24 19:13:11',NULL),(15,'67a413b420d34b17b27ce523015d8bb5','26a282308406894a1e11f8dd1aa45f43','测试权限',1,'',2,1,'2022-01-24 19:20:10',NULL,'456123789','89f8b0e5202b064c570c356ff9b4fe5b',NULL,NULL,1,0,NULL,'2022-01-24 19:20:10','MEQCIFKUemiDJRzWOT6sNmBz77PWAuSR45WJI5FTIHa02cvFAiBT9e6nsxOlf/PHLlQb8E//jDFTgNwqy7cuaav//hSbWA=='),(16,'00009276','',NULL,4,'',0,1,'2022-01-24 22:49:02','2022-01-24 23:02:24',NULL,'89f8b0e5202b064c570c356ff9b4fe5b',NULL,1,1,0,NULL,'2022-01-24 22:49:02',NULL),(17,'00016894','',NULL,2,'',0,1,'2022-01-24 22:49:02',NULL,NULL,'89f8b0e5202b064c570c356ff9b4fe5b',NULL,1,1,0,NULL,'2022-01-24 22:49:03',NULL),(18,'00021213','',NULL,2,'',0,1,'2022-01-24 22:49:02',NULL,NULL,'89f8b0e5202b064c570c356ff9b4fe5b',NULL,1,1,0,NULL,'2022-01-24 22:49:03',NULL),(19,'00030236','',NULL,2,'',0,1,'2022-01-24 22:49:02',NULL,NULL,'89f8b0e5202b064c570c356ff9b4fe5b',NULL,1,1,0,NULL,'2022-01-24 22:49:03',NULL),(
/*!40000 ALTER TABLE `sysuserinfo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sysuserinfo_role`
--

DROP TABLE IF EXISTS `sysuserinfo_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sysuserinfo_role` (
  `ur_id` int NOT NULL AUTO_INCREMENT COMMENT '主键',
  `u_id` int DEFAULT NULL COMMENT '账号id',
  `r_id` int DEFAULT NULL COMMENT '角色id',
  PRIMARY KEY (`ur_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=146 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sysuserinfo_role`
--

LOCK TABLES `sysuserinfo_role` WRITE;
/*!40000 ALTER TABLE `sysuserinfo_role` DISABLE KEYS */;
INSERT INTO `sysuserinfo_role` VALUES (1,1,1),(2,2,4),(3,3,6),(4,4,6),(5,5,6),(6,6,6),(7,7,6),(8,9,6),(10,10,8),(12,13,6),(13,14,6),(40,12,7),(41,12,9),(42,15,9),(43,15,7),(44,16,5),(45,17,5),(46,18,5),(47,19,5),(48,20,5),(49,21,5),(50,22,5),(51,23,5),(52,24,5),(53,25,5),(54,26,5),(55,27,5),(56,28,5),(57,29,5),(58,30,5),(59,31,5),(60,32,5),(61,33,5),(62,34,5),(63,35,5),(64,36,5),(65,37,5),(66,38,5),(67,39,5),(68,40,5),(69,41,5),(70,42,5),(71,43,5),(72,44,5),(73,45,5),(74,46,5),(75,47,5),(76,48,5),(77,49,5),(78,50,5),(79,51,5),(80,52,5),(81,53,5),(82,54,5),(83,55,5),(84,56,5),(85,57,5),(86,58,5),(87,59,5),(88,60,5),(89,61,5),(90,62,5),(91,63,5),(92,64,5),(93,65,5),(94,66,5),(95,67,5),(96,68,5),(97,69,5),(98,70,5),(99,71,5),(100,72,5),(101,73,5),(102,74,5),(103,75,5),(104,76,5),(105,77,5),(106,78,5),(107,79,5),(108,80,5),(109,81,5),(110,82,5),(111,83,5),(112,84,5),(113,85,5),(114,86,5),(115,87,5),(116,88,5),(117,89,5),(118,90,5),(119,91,5),(120,92,5),(121,93,5),(122,94,5),(123,95,5),(124,96,5),(125,97,5),(126,98,5),(127,99,5),(128,100,5),(129,101,5),(130,102,5),(131,103,5),(132,104,5),(133,105,5),(134,106,5),(135,107,5),(136,108,5),(137,109,5),(138,110,5),(139,111,5),(140,112,5),(141,113,5),(142,114,5),(143,115,5),(144,8,7),(145,8,8);
/*!40000 ALTER TABLE `sysuserinfo_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `w_1_a01`
--

DROP TABLE IF EXISTS `w_1_a01`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `w_1_a01` (
  `user_uid` varchar(50) NOT NULL COMMENT '主键',
  `bid` varchar(50) DEFAULT NULL COMMENT '部门id',
  `user_name` varchar(50) DEFAULT NULL COMMENT '姓名',
  `sort` int DEFAULT NULL COMMENT '排序',
  `present_occupation` varchar(250) DEFAULT NULL COMMENT '现任职务',
  `del_status` int DEFAULT NULL COMMENT '  //状态 1 为正常 2 为删除状态',
  `birthday` varchar(50) DEFAULT NULL COMMENT '出生年月',
  `immediately_post` varchar(50) DEFAULT NULL COMMENT '原任职务',
  `employment_period` varchar(50) DEFAULT NULL COMMENT '任职时间',
  `system_id` varchar(50) DEFAULT NULL COMMENT '子系统编码',
  `one_card` varchar(50) DEFAULT NULL COMMENT '一卡通',
  `if_sysn_userinfo` int DEFAULT NULL COMMENT '是否同步到用户表 1 是 2否',
  `a01_ext1` varchar(255) DEFAULT NULL COMMENT '扩展1',
  `a01_ext2` varchar(255) DEFAULT NULL COMMENT '扩展2',
  `a01_ext3` varchar(255) DEFAULT NULL COMMENT '扩展3',
  `a01_ext4` varchar(255) DEFAULT NULL COMMENT '扩展4',
  `a01_ext5` varchar(1000) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `w_1_a01`
--

LOCK TABLES `w_1_a01` WRITE;
/*!40000 ALTER TABLE `w_1_a01` DISABLE KEYS */;
INSERT INTO `w_1_a01` VALUES ('084c67c1804347b014598e9ee9ea7c31','0dbfb1fc9ee04bd7a5803b2b11abe126','测试创建登录2',3,'',1,NULL,NULL,NULL,'89f8b0e5202b064c570c356ff9b4fe5b','123456789',1,'','','','',''),('1d65315737b412995ec05f5f1d005b7c','91c61a07a7a44ae89ef886a42985d340','姓名',3,'',1,NULL,NULL,NULL,'89f8b0e5202b064c570c356ff9b4fe5b','444444444',1,'','','','',''),('2dbcbc8c21f0f27860b89bfbe67f15fa','0dbfb1fc9ee04bd7a5803b2b11abe126','测试创建登录',2,'',1,NULL,NULL,NULL,'89f8b0e5202b064c570c356ff9b4fe5b','321654987',1,'','','','',''),('41ba0a4bc610169efa404f5abfda6768','dbff2fecf3d746d7adb95aa09fc9a9bc','123123',1,'请问请问',1,NULL,NULL,NULL,'89f8b0e5202b064c570c356ff9b4fe5b','635241',1,'','','','',''),('4632ca6309d04a3b0aae2c8dd51a92d9','a9c47ba036324faca2f9a345c7a133f1','测试权限',1,'',1,NULL,NULL,NULL,'89f8b0e5202b064c570c356ff9b4fe5b','789456123',1,'','','','',''),('6b3b93f9f2ec3a2d0a5764623c84594a','0dbfb1fc9ee04bd7a5803b2b11abe126','添加测试人员',1,'',1,NULL,NULL,NULL,'89f8b0e5202b064c570c356ff9b4fe5b','147258369',1,'','','','',''),('fec063695deb4d698030b816da868ee1','d8868c9b1232485b8d27cbe2b2c68924','赵阳',1,'1',1,NULL,NULL,NULL,'89f8b0e5202b064c570c356ff9b4fe5b','',0,'','','','',''),('55b467c546de422d829623e9158f191f','d8868c9b1232485b8d27cbe2b2c68924','邓国为',2,'1',1,NULL,NULL,NULL,'89f8b0e5202b064c570c356ff9b4fe5b','',0,'','','','',''),('582629f07b174cba871fd7ba145dedbe','d8868c9b1232485b8d27cbe2b2c68924','郭燕',3,'1',1,NULL,NULL,NULL,'89f8b0e5202b064c570c356ff9b4fe5b','',0,'','','','','');
/*!40000 ALTER TABLE `w_1_a01` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `w_1_b01`
--

DROP TABLE IF EXISTS `w_1_b01`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `w_1_b01` (
  `id` varchar(50) NOT NULL COMMENT '主键',
  `disp_order` int DEFAULT NULL COMMENT '排序',
  `dep_name` varchar(200) DEFAULT NULL COMMENT '部门名称',
  `pid` varchar(50) DEFAULT NULL COMMENT '父id',
  `del_status` int DEFAULT NULL COMMENT '状态 1为正常 2为删除',
  `system_id` varchar(50) DEFAULT NULL COMMENT '子系统编码',
  `b01_ext1` varchar(255) DEFAULT NULL COMMENT '扩展字段1',
  `b01_ext2` varchar(255) DEFAULT NULL COMMENT '扩展字段2',
  `b01_ext3` varchar(255) DEFAULT NULL COMMENT '扩展字段3',
  `homologous_dep` varchar(50) DEFAULT NULL COMMENT '数据同步时对应的部门id',
  `path` varchar(1000) DEFAULT NULL COMMENT '父级路劲'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `w_1_b01`
--

LOCK TABLES `w_1_b01` WRITE;
/*!40000 ALTER TABLE `w_1_b01` DISABLE KEYS */;
INSERT INTO `w_1_b01` VALUES ('020b32b5521b45528daa91cc84c2775e',4,'单位3','e35d38d20538468ab244a58e68556c45',1,'89f8b0e5202b064c570c356ff9b4fe5b','','','',NULL,'/-1/e35d38d20538468ab244a58e68556c45/020b32b5521b45528daa91cc84c2775e/'),('0dbfb1fc9ee04bd7a5803b2b11abe126',1,'单位子集','e35d38d20538468ab244a58e68556c45',1,'89f8b0e5202b064c570c356ff9b4fe5b','','','',NULL,'/-1/e35d38d20538468ab244a58e68556c45/0dbfb1fc9ee04bd7a5803b2b11abe126/'),('5128f393ff5448cc94123adae8c07d8d',1,'gogogog','0dbfb1fc9ee04bd7a5803b2b11abe126',1,'89f8b0e5202b064c570c356ff9b4fe5b','','','',NULL,'/-1/e35d38d20538468ab244a58e68556c45/0dbfb1fc9ee04bd7a5803b2b11abe126/5128f393ff5448cc94123adae8c07d8d/'),('91c61a07a7a44ae89ef886a42985d340',6,'liuliuliu7','e35d38d20538468ab244a58e68556c45',1,'89f8b0e5202b064c570c356ff9b4fe5b','','','',NULL,'/-1/e35d38d20538468ab244a58e68556c45/91c61a07a7a44ae89ef886a42985d340/'),('a9c47ba036324faca2f9a345c7a133f1',4,'单位4','e35d38d20538468ab244a58e68556c45',1,'89f8b0e5202b064c570c356ff9b4fe5b','','','',NULL,'/-1/e35d38d20538468ab244a58e68556c45/a9c47ba036324faca2f9a345c7a133f1/'),('b53ef7b80b184a66af56b7d1e0b95360',4,'liuliuliu4','e35d38d20538468ab244a58e68556c45',1,'89f8b0e5202b064c570c356ff9b4fe5b','','','',NULL,'/-1/e35d38d20538468ab244a58e68556c45/b53ef7b80b184a66af56b7d1e0b95360/'),('ca814c4927ef49bfaa6921a1b0dabb74',3,'单位2','e35d38d20538468ab244a58e68556c45',1,'89f8b0e5202b064c570c356ff9b4fe5b','','','',NULL,'/-1/e35d38d20538468ab244a58e68556c45/ca814c4927ef49bfaa6921a1b0dabb74/'),('d8868c9b1232485b8d27cbe2b2c68924',2,'单位1','e35d38d20538468ab244a58e68556c45',1,'89f8b0e5202b064c570c356ff9b4fe5b','','','',NULL,'/-1/e35d38d20538468ab244a58e68556c45/d8868c9b1232485b8d27cbe2b2c68924/'),('dbff2fecf3d746d7adb95aa09fc9a9bc',4,'liuliuliu5','e35d38d20538468ab244a58e68556c45',1,'89f8b0e5202b064c570c356ff9b4fe5b','','','',NULL,'/-1/e35d38d20538468ab244a58e68556c45/dbff2fecf3d746d7adb95aa09fc9a9bc/'),('e35d38d20538468ab244a58e68556c45',1,'单位父级','-1',1,'89f8b0e5202b064c570c356ff9b4fe5b','','','',NULL,'/-1/e35d38d20538468ab244a58e68556c45/');
/*!40000 ALTER TABLE `w_1_b01` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2022-05-16 10:42:15