/*
 Navicat Premium Data Transfer

 Source Server         : xcc-121.196.124.158
 Source Server Type    : MySQL
 Source Server Version : 50733
 Source Host           : 121.196.124.158:3308
 Source Schema         : crowd-test-service

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

 Date: 21/04/2021 17:26:41
*/

USE `crowd-test-service`;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for application_type
-- ----------------------------
DROP TABLE IF EXISTS `application_type`;
CREATE TABLE `application_type` (
  `AT_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '应用类型ID',
  `AT_CODE` varchar(255) NOT NULL COMMENT '应用类型CODE',
  `AT_NAME` varchar(255) DEFAULT NULL COMMENT '应用类型名称',
  `AT_IMAGE` varchar(255) DEFAULT NULL COMMENT '应用类型图片',
  `AT_COUNT` bigint(20) DEFAULT NULL COMMENT '应用类型统计数',
  `AT_INTRODUCTION` longtext COMMENT '应用类型介绍',
  PRIMARY KEY (`AT_ID`,`AT_CODE`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of application_type
-- ----------------------------
BEGIN;
INSERT INTO `application_type` VALUES (1, 'OS', '操作系统', 'ApplicationType/操作系统.png', 0, '信创中OS公司有麒麟OS、统信UOS、普华OS、中科方德等。操作系统是管理计算机硬件与软件资源的计算机程序。操作系统需要处理如管理与配置内存、决定系统资源供需的优先次序、控制输入设备与输出设备、操作网络与管理文件系统等基本事务。操作系统也提供一个让用户与系统交互的操作界面。');
INSERT INTO `application_type` VALUES (4, 'ANTIVIRUS', '安全软件', 'ApplicationType/防病毒软件.png', 0, '信创中防病毒软件公司有360、安天、奇安信等。有防病毒软件是一种计算机程序，可进行检测、防护，并采取行动来解除或删除恶意软件程序，如病毒和蠕虫。');
INSERT INTO `application_type` VALUES (5, 'BROWESER', '浏览器', 'ApplicationType/浏览器.png', 0, '信创中浏览器公司有奇安信、海泰方圆等。浏览器是用来检索、展示以及传递Web信息资源的应用程序。');
INSERT INTO `application_type` VALUES (6, 'OFFICE', '办公软件', 'ApplicationType/办公软件.png', 0, '信创中办公软件公司有金山、永中等。办公软件是指可以进行文字处理、表格制作、幻灯片制作、图形图像处理、简单数据库的处理等方面工作的软件。');
INSERT INTO `application_type` VALUES (7, 'FINANCE', '财务软件', 'ApplicationType/财务软件.png', 0, '财务软件是比较常见的企业管理软件。财务软件主要立足于企业财务帐目，企业资金帐户，企业收支状况等方面的管理，用途明确，使用很简单。财务软件它以图形化的管理界面，提问式的操作导航，打破了传统财务软件文字加数字的繁琐模式。');
INSERT INTO `application_type` VALUES (8, 'CLOUDDESKTOP', '云桌面', 'ApplicationType/云桌面.png', 0, '云桌面又称桌面虚拟化、云电脑，是替代传统电脑的一种新模式。');
INSERT INTO `application_type` VALUES (9, 'MANAGE', '管理软件', 'ApplicationType/管理软件.png', 0, '管理软件系统工程是目前IT技术的一大类，包括ERP、BPM、CRM、HR、PM、KM、OA等众多的内容。');
INSERT INTO `application_type` VALUES (10, 'NETWORK', '网络工具', 'ApplicationType/网络工具.png', 0, '网络工具即LNS（LonWorks Network Service)是一个LonWorks控制网络的操作系统。');
INSERT INTO `application_type` VALUES (11, 'OTHER', '其他', 'ApplicationType/其他.png', 0, '其他');
COMMIT;

-- ----------------------------
-- Table structure for application_type_to_test_type
-- ----------------------------
DROP TABLE IF EXISTS `application_type_to_test_type`;
CREATE TABLE `application_type_to_test_type` (
  `ATTTT_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '应用类型和测试类型对应ID',
  `ATTTT_AT_CODE` varbinary(255) NOT NULL COMMENT '应用类型CODE',
  `ATTTT_TT_CODE` varbinary(255) NOT NULL COMMENT '测试类型CODE',
  PRIMARY KEY (`ATTTT_ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for bank_card
-- ----------------------------
DROP TABLE IF EXISTS `bank_card`;
CREATE TABLE `bank_card` (
  `BC_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户银行卡ID',
  `BC_USER` varchar(255) DEFAULT NULL COMMENT '银行持卡人',
  `BC_NUMBER` varchar(255) DEFAULT NULL COMMENT '银行卡号',
  `BC_BL_CODE` varchar(255) DEFAULT NULL COMMENT '银行CODE',
  `BC_U_ID` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `BC_DELETED` int(4) NOT NULL COMMENT '是否被删除',
  PRIMARY KEY (`BC_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for bank_logo
-- ----------------------------
DROP TABLE IF EXISTS `bank_logo`;
CREATE TABLE `bank_logo` (
  `BL_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '银行卡ID',
  `BL_NAME` varchar(255) DEFAULT NULL COMMENT '银行名称',
  `BL_LOGO_URL` varchar(255) DEFAULT NULL COMMENT '银行商标',
  `BL_CODE` varchar(255) DEFAULT NULL COMMENT '银行CODE',
  PRIMARY KEY (`BL_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for competition
-- ----------------------------
DROP TABLE IF EXISTS `competition`;
CREATE TABLE `competition` (
  `C_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '比赛ID',
  `C_NAME` varchar(255) DEFAULT NULL COMMENT '比赛名称',
  `C_LINK_URL` varchar(255) DEFAULT NULL COMMENT '比赛链接',
  `C_START_TIME` timestamp NULL DEFAULT NULL COMMENT '比赛时间',
  `C_UNIT` varchar(255) DEFAULT NULL COMMENT '主办单位',
  `C_IMAGE` varchar(255) DEFAULT NULL COMMENT '大赛缩略图',
  `C_IS_DELETED` int(2) DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`C_ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of competition
-- ----------------------------
BEGIN;
INSERT INTO `competition` VALUES (1, '关于举办2020年全国大学生软件测试大赛的通知', 'http://www.mooctest.org/#/NoticeDetail/83', '2020-08-28 10:30:54', '慕测科技', 'http://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/Partner/mooctest.png', 0);
INSERT INTO `competition` VALUES (2, '2020年全国大学生软件测试大赛火热报名中！', 'http://www.mooctest.org/#/NoticeDetail/92', '2020-09-01 10:30:54', '慕测科技', 'http://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/Partner/mooctest.png', 0);
INSERT INTO `competition` VALUES (3, '基于信创产业生态的众包测试月度赛报名开始啦！', 'http://www.mooctest.org/#/NoticeDetail/112', '2020-11-27 21:42:17', '慕测科技', 'http://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/Partner/mooctest.png', 0);
INSERT INTO `competition` VALUES (4, '2020年全国大学生软件测试大赛举办圆满成功！', 'http://www.mooctest.org/#/NoticeDetail/111', '2020-11-19 10:30:54', '慕测科技', 'http://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/Partner/mooctest.png', 0);
INSERT INTO `competition` VALUES (5, '12月移动应用测试月度赛结果公布！', 'http://www.mooctest.org/#/NoticeDetail/114', '2020-12-08 10:32:27', '慕测科技', 'http://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/Partner/mooctest.png', 0);
COMMIT;

-- ----------------------------
-- Table structure for configuration
-- ----------------------------
DROP TABLE IF EXISTS `configuration`;
CREATE TABLE `configuration` (
  `CF_ID` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '配置项ID',
  `CF_NAME` varchar(255) DEFAULT NULL COMMENT '配置项名称',
  `CF_VALUE` longtext COMMENT '配置项值',
  PRIMARY KEY (`CF_ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of configuration
-- ----------------------------
BEGIN;
INSERT INTO `configuration` VALUES (1, 'title', '{\"title\": \"番禺职业技术学院信创实训室\"}');
INSERT INTO `configuration` VALUES (2, 'subtitle', '{\"subtitle\": \"©2021Q2 MoocTest\"}');
INSERT INTO `configuration` VALUES (3, 'logoTitle', '{\"logoTitle\":\"慕测排行\"}');
INSERT INTO `configuration` VALUES (7, 'home_searchTypeArr', '{\"home_searchTypeArr\": [{\"name\": \"全部\",\"value\": \"all\"},{\"name\": \"项目\",\"value\": \"0\"}]}');
INSERT INTO `configuration` VALUES (8, 'home_searchTypeArr_all', '{\"home_searchTypeArr_all\": [{\"name\": \"全部\",\"value\": \"all\"},{\"name\": \"项目\",\"value\": \"0\"},{\"name\": \"机构\",\"value\": \"1\"},{\"name\": \"资源\",\"value\": \"2\"},{\"name\": \"专家\",\"value\": \"3\"}]}');
INSERT INTO `configuration` VALUES (9, 'home_searchType', '{\"home_searchType\":0}');
INSERT INTO `configuration` VALUES (10, 'home_homeTabArr_left', '{\"home_homeTabArr_left\":[{\"label\": \"首页\", \"name\": \"homepage\", \"linkTo\": \"/home\"},{\"label\": \"信创广场\", \"name\": \"square\", \"linkTo\": \"/square\"},{\"label\": \"众测技术\", \"name\": \"technology\", \"linkTo\": \"/technology\"}]}');
INSERT INTO `configuration` VALUES (11, 'home_searchTypeArr_left_all', '{\"home_homeTabArr_left_all\":[{\"label\": \"首页\", \"name\": \"homepage\", \"linkTo\": \"/home\"},{\"label\": \"信创广场\", \"name\": \"square\", \"linkTo\": \"/square\"},{\"label\": \"众测技术\", \"name\": \"technology\", \"linkTo\": \"/technology\"},{\"label\": \"排行榜\", \"name\": \"ranking\", \"linkTo\": \"www.mooctest.net\"}]}');
INSERT INTO `configuration` VALUES (12, 'home_homeTabArr_right', '{\"home_homeTabArr_right\":[]}');
INSERT INTO `configuration` VALUES (13, 'home_homeTabArr_right_all', '{\"home_homeTabArr_right_all\":[{\"label\": \"找机构\", \"name\": \"findInstitution\", \"linkTo\": \"/agency/list/show\"},{\"label\": \"找专家\", \"name\": \"findExpert\", \"linkTo\": \"/expert/list\"}]}');
INSERT INTO `configuration` VALUES (14, 'home_homeTabArr_default', '{\"home_homeTabArr_default\":\"homepage\"}');
INSERT INTO `configuration` VALUES (15, 'HOME_DISPLAY', '{\"HOME_DISPLAY\":{\"mooctest_rank\": true,\"test_menu\": true,\"test_card\": true, \"resource_and_tool\": true, \"brand_card\": false, \"institution_card\": false,\"login_card\": true,\"hot_crowd\": false, \"hot_agency\": false, \"hot_user\": false,\"hot_contest\": true,\"hot_task\": true,\"hot_project\": false}}');
INSERT INTO `configuration` VALUES (16, 'HOME_DISPLAY_all', '{\"HOME_DISPLAY_all\":{\"mooctest_rank\": true,\"test_menu\": true,\"test_card\": true, \"resource_and_tool\": true, \"brand_card\": true, \"institution_card\": true,\"login_card\": true,\"hot_crowd\": true, \"hot_agency\": true, \"hot_user\": true,\"hot_contest\": true,\"hot_task\": true,\"hot_project\": true}}');
INSERT INTO `configuration` VALUES (17, 'technology_searchTypeArr', '{\"technology_searchTypeArr\":[{\"name\": \"众测工具\",\"value\": \"2\",\"label\": \"工具\"},{\"name\": \"技术文章\",\"value\": \"0\",\"label\": \"文章\"},{\"name\": \"论文专著\",\"value\": \"1\",\"label\": \"专著\"}]}');
INSERT INTO `configuration` VALUES (18, 'technology_searchTypeArr_all', '{\"technology_searchTypeArr_all\":[{\"name\": \"众测工具\",\"value\": \"2\",\"label\": \"工具\"},{\"name\": \"众测案例\",\"value\": \"3\",\"label\": \"案例\"},{\"name\": \"技术文章\",\"value\": \"0\",\"label\": \"文章\"},{\"name\": \"论文专著\",\"value\": \"1\",\"label\": \"专著\"}]}');
INSERT INTO `configuration` VALUES (19, 'technology_searchType', '{\"technology_searchType\":\"2\"}');
INSERT INTO `configuration` VALUES (20, 'TECHNOLOGY_DISPLAY', '{\"TECHNOLOGY_DISPLAY\":{\"hot_article\": true}}');
INSERT INTO `configuration` VALUES (21, 'square_searchTabArr', '{\"square_searchTabArr\":[{\"label\": \"任务\", \"name\": \"task\"}]}');
INSERT INTO `configuration` VALUES (22, 'square_searchTabArr_all', '{\"square_searchTabArr_all\":[{\"label\": \"项目\", \"name\": \"project\"},{\"label\": \"任务\", \"name\": \"task\"}]}');
INSERT INTO `configuration` VALUES (23, 'square_menuArr', '{\"square_menuArr\":[{\"label\": \"首页\", \"name\": \"squareHome\"},{\"label\": \"测试项目\", \"name\": \"project\"},{\"label\": \"测试任务\", \"name\": \"task\"}]}');
INSERT INTO `configuration` VALUES (24, 'square_menuArr_all', '{\"square_menuArr_all\":[{\"label\": \"首页\", \"name\": \"squareHome\"},{\"label\": \"测试项目\", \"name\": \"project\"},{\"label\": \"测试任务\", \"name\": \"task\"}]}');
INSERT INTO `configuration` VALUES (25, 'square_searchType', '{\"square_searchType\":\"project\"}');
INSERT INTO `configuration` VALUES (26, 'square_currTab', '{\"square_currTab\":\"squareHome\"}');
INSERT INTO `configuration` VALUES (27, 'SQUARE_DISPLAY', '{\"SQUARE_DISPLAY\":{\"popular_project\": false,\"popular_task\": true}}');
INSERT INTO `configuration` VALUES (28, 'user_info', '{\"user_info\":[{\"label\": \"基本信息\", \"linkTo\": \"/personal/mine\"},{\"label\": \"我的资质\", \"linkTo\": \"/personal/qualification\"},{\"label\": \"我的银行卡\", \"linkTo\": \"/personal/bankCard\"}]}');
INSERT INTO `configuration` VALUES (29, 'user_info_all', '{\"user_info_all\":[{\"label\": \"基本信息\", \"linkTo\": \"/personal/mine\"},{\"label\": \"我的资质\", \"linkTo\": \"/personal/qualification\"},{\"label\": \"我的银行卡\", \"linkTo\": \"/personal/bankCard\"}]}');
INSERT INTO `configuration` VALUES (30, 'account_security', '{\"account_security\":[{\"label\": \"修改登录密码\", \"linkTo\": \"/personal/modifyPsw\"},{\"label\": \"身份认证\", \"linkTo\": \"/personal/authentication\"}]}');
INSERT INTO `configuration` VALUES (31, 'account_security_all', '{\"account_security_all\":[{\"label\": \"修改登录密码\", \"linkTo\": \"/personal/modifyPsw\"},{\"label\":\"手机绑定\",\"linkTo\":\"/personal/phoneBinding\"},{\"label\":\"邮箱绑定\",\"linkTo\":\"/personal/mailBinding\"},{\"label\": \"身份认证\", \"linkTo\": \"/personal/authentication\"}]}');
INSERT INTO `configuration` VALUES (32, 'login_description', '{\"login_description\":\"番禺职业技术学院信创实训室\"}');
INSERT INTO `configuration` VALUES (34, 'footer_provider_number', '{\"footer_provider_number\":\"苏ICP备09019504号\"}');
INSERT INTO `configuration` VALUES (35, 'footer_provider_number_url', '{\"footer_provider_number_url\":\"http://www.beian.miit.gov.cn/\"}');
INSERT INTO `configuration` VALUES (36, 'footer_mobile', '{\"footer_mobile\":\"电话：15375405363\"}');
INSERT INTO `configuration` VALUES (37, 'footer_fax', '{\"footer_fax\":\"传真：020-32068111\"}');
INSERT INTO `configuration` VALUES (38, 'footer_email', '{\"footer_email\":\"电子邮箱：cst@mooctest.net\"}');
INSERT INTO `configuration` VALUES (39, 'footer_title_one', '{\"footer_title_one\":\"南京慕测信息科技有限公司\"}');
INSERT INTO `configuration` VALUES (40, 'footer_title_two', '{\"footer_title_two\":\"软件定义世界，数据驱动未来\"}');
INSERT INTO `configuration` VALUES (41, 'logo_white', '{\"logo_white\":\"/var/www/Platform/logo-white.png\"}');
INSERT INTO `configuration` VALUES (42, 'logo_background', '{\"logo_background\":\"/var/www/Platform/logo-transparent.png\"}');
INSERT INTO `configuration` VALUES (43, 'logo_transparent', '{\"logo_transparent\":\"/var/www/Platform/logo-transparent.png\"}');
INSERT INTO `configuration` VALUES (44, 'footer_QRcode', '{\"footer_QRcode\":\"/var/www/Platform/QRcode.png\"}');
INSERT INTO `configuration` VALUES (47, 'home_background_url', '{\"home_background_url\":\"/var/www/Platform/home-background.jpeg\"}');
INSERT INTO `configuration` VALUES (49, 'manage_url', '{\"manage_url\":\"http://121.196.124.158:9004/crowdTask\"}');
INSERT INTO `configuration` VALUES (50, 'copy_right', '{\"copy_right\":\"版权所有©南京慕测信息科技有限公司\"}');
INSERT INTO `configuration` VALUES (51, 'internet_content_provider', '{\"internet_content_provider\":\"苏公网安备 44011602000570号\"}');
INSERT INTO `configuration` VALUES (52, 'name_QRcode', '{\"name_QRcode\":\"官方微信公众号\"}');
INSERT INTO `configuration` VALUES (53, 'police_photo_url', '{\"police_photo_url\":\"/var/www/Platform/police.png\"}');
INSERT INTO `configuration` VALUES (54, 'mooctest_rank_url', '{\"mooctest_rank_url\":\"http://139.224.0.118:8200/#/\"}');
INSERT INTO `configuration` VALUES (55, 'mooctest_rank_logo_url', '{\"mooctest_rank_logo_url\":\"/var/www/Platform/ranking-bcg.png\"}');
INSERT INTO `configuration` VALUES (56, 'login_title', '{\"login_title\":\"hi，欢迎使用信创实验室\"}');
INSERT INTO `configuration` VALUES (57, 'task_recommend_url', '{\"task_recommend_url\":\"http://8.134.39.104:7477/userinformation.html\"}');
COMMIT;

-- ----------------------------
-- Table structure for crowd_test_project
-- ----------------------------
DROP TABLE IF EXISTS `crowd_test_project`;
CREATE TABLE `crowd_test_project` (
  `CTP_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '众包项目ID',
  `CTP_CODE` varchar(255) NOT NULL COMMENT '众包项目标识',
  `CTP_NAME` varchar(255) NOT NULL COMMENT '众包项目名称',
  `CTP_U_ID` bigint(20) NOT NULL COMMENT '众包项目发起者用户ID',
  `CTP_RM_ID` bigint(20) DEFAULT NULL COMMENT '区域管理员用户ID',
  `CTP_PDT_ID` bigint(20) DEFAULT NULL COMMENT '众包项目分配方式ID',
  `CTP_FIELD_TYPE` varchar(255) DEFAULT 'KJFW' COMMENT '众包项目领域类型',
  `CTP_PLATFORM` varchar(255) DEFAULT 'ANDROID' COMMENT '众包项目应用类型',
  `CTP_TYPE` varchar(255) DEFAULT 'JKCS' COMMENT '测试类型',
  `CTP_LINK_MAN` varchar(255) DEFAULT NULL COMMENT '众包项目联系人',
  `CTP_Link_MAN_MOBILE` varchar(255) DEFAULT NULL COMMENT '众包项目联系人手机号',
  `CTP_DESCRIPTION` longtext COMMENT '众包项目需求描述',
  `CTP_PROJECT_FILE` varchar(255) DEFAULT NULL COMMENT '众包项目文件(安装包)',
  `CTP_REQUIREMENT_FILE` varchar(255) DEFAULT NULL COMMENT '众包项目需求文档',
  `CTP_DISTRIBUTION_TYPE` int(10) DEFAULT NULL COMMENT '众包测试分配方式',
  `CTP_DISTRIBUTION_PROVINCE` varchar(255) DEFAULT NULL COMMENT '众包项目分配省份',
  `CTP_DISTRIBUTION_CITY` varchar(255) DEFAULT NULL COMMENT '众包项目分配城市',
  `CTP_QUOTED_PRICE` double(255,2) DEFAULT NULL COMMENT '众包项目报价',
  `CTP_REST_PRICE` double(255,2) DEFAULT NULL COMMENT '众包项目的剩余预算',
  `CTP_FIXED_PRICE` double(255,2) DEFAULT NULL COMMENT '众包项目定价',
  `CTP_VALUATION_STANDARD` varchar(255) DEFAULT '暂无' COMMENT '计价标准',
  `CTP_ENTRUST_UNIT` varchar(255) DEFAULT NULL COMMENT '众包项目委托单位',
  `CTP_JOIN_COUNT` int(10) DEFAULT '0' COMMENT '众包项目参与人数',
  `CTP_STATUS` int(10) DEFAULT NULL COMMENT '众包项目状态',
  `CTP_DEAD_LINE` timestamp NULL DEFAULT NULL COMMENT '众包项目截至时间',
  `CTP_END_TIME` timestamp NULL DEFAULT NULL COMMENT '众包项目交付时间',
  `CTP_IS_DELETED` int(10) DEFAULT NULL COMMENT '众包项目是否被删除',
  `CTP_CREATE_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '众包项目创建时间',
  PRIMARY KEY (`CTP_ID`,`CTP_CODE`) USING BTREE,
  KEY `KP_CTP_U_ID` (`CTP_U_ID`) USING BTREE,
  KEY `KP_CTP_RM_ID` (`CTP_RM_ID`) USING BTREE,
  KEY `KP_CTP_PDT_ID` (`CTP_PDT_ID`) USING BTREE,
  KEY `CTP_CODE` (`CTP_CODE`) USING BTREE,
  KEY `CTP_ID` (`CTP_ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of crowd_test_project
-- ----------------------------
BEGIN;
INSERT INTO `crowd_test_project` VALUES (3, 'PROJ-2021041915001', '基础篇 实验一、什么是信创', 4, NULL, 2, 'BASESF', 'OS', '[\"DZCS\"]', '系统发包管理员', '13657094937', '本节实验讲述信创及其产业的相关知识，实验群体应通过本节了解信创的由来及发展状况。', '', '/var/www/RequirementDoc/基础篇 【实验一、什么是信创】需求文档_4_1618907669810.doc', NULL, NULL, NULL, 1000.00, 1000.00, NULL, '50/人天', NULL, 0, 1, '2023-12-12 00:00:00', NULL, 0, '2021-04-20 19:35:16');
INSERT INTO `crowd_test_project` VALUES (4, 'PROJ-2021041915002', '基础篇 实验二、Linux操作系统简介', 4, NULL, 2, 'BASESF', 'OS', '[\"DZCS\"]', '系统发包管理员', '13657094937', '信创环境下，国产操作系统均基于Linux进行开发，实验群体应当了解Linux操作系统的相关知识。', '', '/var/www/RequirementDoc/基础篇 【实验二、Linux操作系统简介】需求文档_4_1618917139334.doc', NULL, NULL, NULL, 1000.00, 1000.00, NULL, '信创实训教学项目。', NULL, 0, 1, '2023-12-12 00:00:00', NULL, 0, '2021-04-20 19:34:16');
INSERT INTO `crowd_test_project` VALUES (5, 'PROJ-2021041915003', '基础篇 实验三、国产操作系统简介', 4, NULL, 2, 'BASESF', 'OS', '[\"DZCS\"]', '系统发包管理员', '13657094937', '本届实验将讲解为什么国产操作系统不开发一个全新的操作系统，而是基于Linux来开发。', '', '/var/www/RequirementDoc/基础篇 【实验三、国产操作系统简介】需求文档_4_1618917188080.doc', NULL, NULL, NULL, 1000.00, 1000.00, NULL, '信创实训教学项目。', NULL, 0, 1, '2023-12-12 00:00:00', NULL, 0, '2021-04-20 19:33:16');
INSERT INTO `crowd_test_project` VALUES (6, 'PROJ-2021041915004', '进阶篇 实验一、国产操作系统安装实验', 4, NULL, 2, 'BASESF', 'OS', '[\"DZCS\"]', '系统发包管理员', '13657094937', '    实验所使用的是信创产业下的国产操作系统——统信桌面操作系统（UOS）个人版。首先带大家了解一下UOS吧。\nUOS基于Linux5.3内核打造，是专为个人用户推出的一款安全稳定、美观易用的国产桌面操作系统。支持x86架构，兼容主流外设。提供了丰富的应用生态，用户可以通过应用商店下载数百款应用，覆盖日常办公、通讯交流、影音娱乐、设计开发等各种场景需求。\nUOS将用户体验与设计美学完美结合，系统和应用界面均保持了界面的直观性、操作的即时性和便利性、活力的界面风格。拥有时尚模式和高效模式两种桌面风格，提供白色和黑色主题，适应不同用户使用习惯，为您带来舒适、流畅、愉悦的使用体验。\nUOS个人版搭载了国内领先的系统安全技术，包括GRUB权限控制、应用证书签名、安全启动等，从硬件核心到启动机制，从用户隐私信息安全真正做到全方位护航。用户还可下载安装国内主流的安全软件，满足各种特殊场景的安全需求。\n十余载的发展，统信操作系统为党、政、军、能源、金融、教育等各个领域提供了稳定可靠的技术支持和信息化解决方案。在未来，国产操作系统技术将真正走进各行各业，接受广大用户的审验，让更多的用户见证中国智造在科技创新领域取得的巨大进步和卓越成果，让中华大地上更多的计算机亮起“国货之光”。', '', '/var/www/RequirementDoc/进阶篇【实验一、国产操作系统安装实验】需求文档_4_1618918280590.doc', NULL, NULL, NULL, 2000.00, 2000.00, NULL, '信创实训教学项目。', NULL, 0, 1, '2023-12-12 00:00:00', NULL, 0, '2021-04-20 19:32:16');
INSERT INTO `crowd_test_project` VALUES (7, 'PROJ-2021041915005', '进阶篇 实验二、UOS的系统设置实验', 4, NULL, 2, 'BASESF', 'OS', '[\"DZCS\"]', '系统发包管理员', '13657094937', '对于初次使用国产操作系统的用户来说，使用命令管理系统过于复杂，用户可以通过进入UOS的桌面环境进行管理。', '', '/var/www/RequirementDoc/进阶篇【实验二、UOS的系统设置实验】需求文档_4_1618918637781.doc', NULL, NULL, NULL, 2000.00, 2000.00, NULL, '信创实训教学项目。', NULL, 0, 1, '2023-12-12 00:00:00', NULL, 0, '2021-04-20 19:31:16');
INSERT INTO `crowd_test_project` VALUES (8, 'PROJ-2021041915006', '进阶篇 实验三、文本编辑实验', 4, NULL, 2, 'BASESF', 'OS', '[\"DZCS\"]', '系统发包管理员', '13657094937', 'Vi编辑器是国产操作系统的标准编辑器，可用于编辑任何ASCII文本，对于编辑源程序尤其有用，其功能非常强大。通过使用vi编辑器，可以对文本进行创建、查找、替换、删除、复制和粘贴等操作。', '', '/var/www/RequirementDoc/进阶篇【实验三、文本编辑实验】需求文档_4_1618918327552.doc', NULL, NULL, NULL, 2000.00, 2000.00, NULL, '信创实训教学项目。', NULL, 0, 1, '2023-12-12 00:00:00', NULL, 0, '2021-04-20 19:30:16');
INSERT INTO `crowd_test_project` VALUES (9, 'PROJ-2021041915007', '进阶篇 实验四、国产操作系统下开发环境安装实验', 4, NULL, 2, 'BASESF', 'OS', '[\"DZCS\"]', '系统发包管理员', '13657094937', 'Eclipse是著名的跨平台的自由集成开发环境（IDE）。最初主要用来Java语言开发，但是目前亦有人通过插件使其作为其他计算机语言比如C++和Python的开发工具。\nEclipse的本身只是一个框架平台，但是众多插件的支持使得Eclipse拥有其他功能相对固定的IDE软件很难具有的灵活性。许多软件开发商以Eclipse为框架开发自己的IDE。\n本次通过使用国产操作系统终端安装JDK和Eclipse。', '', '/var/www/RequirementDoc/进阶篇【实验四、国产操作系统下开发环境安装实验】需求文档_4_1618918416311.doc', NULL, NULL, NULL, 2000.00, 2000.00, NULL, '信创实训教学项目。', NULL, 0, 1, '2023-12-12 00:00:00', NULL, 0, '2021-04-20 19:29:16');
INSERT INTO `crowd_test_project` VALUES (10, 'PROJ-2021041915008', '进阶篇 实验五、国产操作系统的内核指标评测实验', 4, NULL, 2, 'BASESF', 'OS', '[\"DZCS\"]', '系统发包管理员', '13657094937', 'UOS的内核是Linux，Linux测试项目是由IBM、思科、富士通、SUSE、红帽、甲骨文等公司开发和维护的 SGI、OSDL 和 Bull 共同启动的项目。该项目的目标是向开源社区提供测试，以验证 Linux 的可靠性、健壮性和稳定性。\nLTP 测试服包含用于测试 Linux 内核和相关功能的工具集合。我们的目标是通过将测试自动化引入测试工作来改进 Linux 内核和系统库。', '', '/var/www/RequirementDoc/进阶篇【实验五、国产操作系统的内核指标评测实验】需求文档_4_1618918570110.doc', NULL, NULL, NULL, 2000.00, 2000.00, NULL, '信创实训教学项目。', NULL, 0, 1, '2023-12-12 00:00:00', NULL, 0, '2021-04-20 19:28:16');
INSERT INTO `crowd_test_project` VALUES (11, 'PROJ-2021041915009', '进阶篇 实验六、国产操作系统文件共享实验', 4, NULL, 2, 'BASESF', 'OS', '[\"DZCS\"]', '系统发包管理员', '13657094937', 'NFS服务是国产操作系统之间实现文件共享的方式,NFS对于在同一个网络上的多个用户间共享目录和文件很有用。通过使用NFS,用户和程序可以像访问本地文件一样访问远程系统上的文件。\n一组致力于同一工程项目的用户，可以通过使用NFS文件系统中的一个挂载为/it的共享目录来存取该工程项目的文件。要存取共享的文件，用户只需进入各自计算机上的/it目录即可。这种方法既不用输人密码，又不用记忆特殊命令，就像该目录位于用户的本地主机上一样。\nNFS本身的服务并没有提供文件传递的协议，但是NFS却能让我们进行文件的共享，这其中的原因就是NFS使用RPC协议。所以只要用到NFS的地方都要启动RPC服务，不论是NFS服务器还是NFS客户端。\n可以这么理解RPC和NFS的关系: NFS 是一个文件系统，而RPC是负责信息的传输，这样NFS服务器端与NFS客户端才能由RPC协议来进行端口的对应。NFS主要管理分享出来的目录，而文件的传递则直接交由RPC协议来运作。', '', '/var/www/RequirementDoc/进阶篇【实验六、国产操作系统文件共享实验】需求文档_4_1618918471416.doc', NULL, NULL, NULL, 2000.00, 2000.00, NULL, '信创实训教学项目。', NULL, 0, 1, '2023-12-12 00:00:00', NULL, 0, '2021-04-20 19:27:16');
INSERT INTO `crowd_test_project` VALUES (12, 'PROJ-2021041915010', '进阶篇 实验七、国产操作系统文件传输实验', 4, NULL, 2, 'BASESF', 'OS', '[\"DZCS\"]', '系统发包管理员', '13657094937', '国产操作系统使用的文件传输协议( File Transfer Protocol, FTP )可以在网络中传输文档、图像、音频、视频和应用程序等多种类型的文件。如果用户需要将文件从自己的计算机发送给另一台计算机，可以使用FTP进行上传操作；而在更多的情况下，是用户使用FTP从服务器上下载文件。\n一个完整的FTP文件传输需要建立两种类型的连接: 一种为控制文件传输的命令，称为控制连接；另一种为实现真正的文件传输，称为数据连接。\n客户端希望与FTP服务器建立上传下载的数据传输时，它首先向服务器TCP协议的21端口发起一个建立连接的请求；FTP服务器接受来自客户端的请求，完成连接的建立过程，这样的连接就称为FTP控制连接。\nFTP控制连接建立之后，即可开始传输文件，传输文件的连接称为FTP数据连接。FTP数据连接就是FTP传输数据的过程，它有主动传输和被动传输两种传输模式。', '', '/var/www/RequirementDoc/进阶篇【实验七、国产操作系统文件传输实验】需求文档_4_1618918502280.doc', NULL, NULL, NULL, 2000.00, 2000.00, NULL, '信创实训教学项目。', NULL, 0, 1, '2023-12-12 00:00:00', NULL, 0, '2021-04-20 19:26:16');
INSERT INTO `crowd_test_project` VALUES (13, 'PROJ-2021041915011', '进阶篇 实验八、国产操作系统终端安全访问实验', 4, NULL, 2, 'BASESF', 'OS', '[\"DZCS\"]', '系统发包管理员', '13657094937', '国产操作系统使用的安全Shell ( Secure Shell, SSH)是由IETF的网络工作小组所制定，为建立在应用层和传输层基础上的安全协议。SSH是目前较可靠,专为远程登录会话和其他网络服务提供安全性的协议。利用SSH协议可以有效防止远程管理过程中的信息泄露问题。\nSSH因为受版权和加密算法的限制，现在很多人都转而使用OpenSSH ( Open Secure Shell,开放安全Shell) 。OpenSSH是SSH的替代软件，而且是免费的。它默认使用RSA密钥，采用安全、加密的网络连接工具代替telnet、ftp、rlogin、 rsh 和rcp工具。\n使用OpenSSH工具将增进系统安全性，在使用OpenSSH软件进行通信时，登录验证口令将会被加密。OpenSSH提供了服务端后台程序和客户端工具，用来加密远程控件和文件传输过程中的数据，并由此来代替原来的类似服务。\ntelnet和ftp使用纯文本口令，并以明文发送。这些信息可能会被截取，口令可能会被检索，未经授权的人员可能会使用截取的口令登录用户的系统，从而对系统产生危害，所以应该尽可能使用OpenSSH工具来避免这些安全问题。', '', '/var/www/RequirementDoc/进阶篇【实验八、国产操作系统终端安全访问实验】需求文档_4_1618918525822.doc', NULL, NULL, NULL, 2000.00, 2000.00, NULL, '信创实训教学项目。', NULL, 0, 1, '2023-12-12 00:00:00', NULL, 0, '2021-04-20 19:25:16');
INSERT INTO `crowd_test_project` VALUES (14, 'PROJ-2021041915012', '进阶篇 实验九、国产操作系统远程控制实验', 4, NULL, 2, 'BASESF', 'OS', '[\"DZCS\"]', '系统发包管理员', '13657094937', '国产操作系统使用的VNC是基于Unix/Linux 操作系统的免费开源软件,它远程控制能力强大，高效实用，其性能可以和Windows系统中的任何远程控制软件媲美。\nVNC 基本属于一种显示系统，也就是说它能通过网络将完整的窗口界面传输到另一台计算机的屏幕上。Windows系统上的Terminal Server和PCAnywhere都是属于这种原理的软件，同时这些软件又在VNC的原理基础上各自做了相应的改进，提高了易用性、连通率和可穿透内网的能力。', '', '/var/www/RequirementDoc/进阶篇 【实验九、国产操作系统远程控制实验】需求文档_4_1618918010145.doc', NULL, NULL, NULL, 2000.00, 2000.00, NULL, '信创实训教学项目。', NULL, 0, 1, '2023-12-12 00:00:00', NULL, 0, '2021-04-20 19:24:16');
INSERT INTO `crowd_test_project` VALUES (15, 'PROJ-2021041915013', '进阶篇 实验十、国产操作系统性能测试实验', 4, NULL, 2, 'BASESF', 'OS', '[\"DZCS\"]', '系统发包管理员', '13657094937', '国产操作系统下的UnixBench 是一个性能测试工具，是一个开源工具，被广泛用与测试 Linux 系统主机的性能。UnixBench 的主要测试项目有：系统调用、读写、进程、图形化测试、2D、3D、管道、运算、C库等系统基准性能提供测试数据。\nUnixBench会执行一系列的测试,包括2D和3D图形系统的性能衡量，测试的结果不仅仅只是CPU、内存或者磁盘为基准，还取决于硬件，操作系统版本，编译器等。\n测试系统各个方面一系列的性能,然后将每个测试结果和一个基准值进行比较,得到一个索引值,所有测试项目的索引值结合在一起形成一个测试分数值。根据机器性能,测试执行完大约需要10-30分钟。', '', '/var/www/RequirementDoc/进阶篇 【实验十、国产操作系统性能测试实验】需求文档_4_1618918103140.doc', NULL, NULL, NULL, 2000.00, 2000.00, NULL, '信创实训教学项目。', NULL, 0, 1, '2023-12-12 00:00:00', NULL, 0, '2021-04-20 19:23:16');
INSERT INTO `crowd_test_project` VALUES (16, 'PROJ-2021041915014', '实战篇 实验一、国产操作系统众测', 4, NULL, 2, 'BASESF', 'OS', '[\"DZCS\"]', '系统发包管理员', '13657094937', '目前，信创产业起步阶段，发展的过程中，在保证速度的同时，还要保证产业的质量。本节选取两款国产操作系统为目标进行实验，实验群体需按照要求完成测试。', '', '/var/www/RequirementDoc/实战篇 【实验一、国产操作系统众测】需求文档_4_1618917601442.doc', NULL, NULL, NULL, 3000.00, 3000.00, NULL, '信创实训教学项目。', NULL, 0, 1, '2023-12-12 00:00:00', NULL, 0, '2021-04-20 19:22:16');
INSERT INTO `crowd_test_project` VALUES (17, 'PROJ-2021041915015', '实战篇 实验二、北斗打假众测', 4, NULL, 2, 'BASESF', 'OS', '[\"DZCS\"]', '系统发包管理员', '13657094937', '北斗卫星导航系统（以下简称北斗系统）是我国着眼于国家安全和经济社会发展需要，自主建设运行的全球卫星导航系统，是为全球用户提供全天候、全天时、高精度的定位、导航和授时服务的国家重要时空基础设施。北斗系统是完全自主化的信息技术创新产物。\n目前，在市面上的手机厂商中，除了苹果品牌手机不支持北斗系统外，很多厂商都声称已支持北斗，但实际上，有部分厂商虚假宣传，制造噱头，再加上大部分消费者不会去关心或者不懂得去辨别设备是否真的支持北斗系统，就造成了市场上鱼目混珠的情况。本节实验将进行“北斗打假”，通过空间众包的力量，让大家把那些虚假宣传的手机厂商揪出来，曝光他们。', '', '/var/www/RequirementDoc/实战篇 【实验二、北斗打假众测】需求文档_4_1618917697689.doc', NULL, NULL, NULL, 3000.00, 3000.00, NULL, '信创实训教学项目。', NULL, 0, 1, '2023-12-12 00:00:00', NULL, 0, '2021-04-20 19:21:16');
INSERT INTO `crowd_test_project` VALUES (18, 'PROJ-2021041915016', '实战篇 实验三、信创翻译软件众测', 4, NULL, 2, 'BASESF', 'OS', '[\"DZCS\"]', '系统发包管理员', '13657094937', '信创产业中，应用软件是不可或缺的一环，而在当前阶段，办公软件是推广的重点。本节实验以信创翻译软件为实验对象进行测试。', '', '/var/www/RequirementDoc/实战篇 【实验三、信创翻译软件众测】需求文档_4_1618917768393.doc', NULL, NULL, NULL, 3000.00, 3000.00, NULL, '信创实训教学项目。', NULL, 0, 1, '2023-12-12 00:00:00', NULL, 0, '2021-04-20 19:20:16');
INSERT INTO `crowd_test_project` VALUES (19, 'PROJ-2021041915017', '实战篇 实验四、信创办公套件众测', 4, NULL, 2, 'BASESF', 'OS', '[\"DZCS\"]', '系统发包管理员', '13657094937', '信创办公套件，用来代替微软Office等。在信创办公套件的替代阶段，政企单位是第一批使用者，本节实验根据该类人群的工作特点、使用习惯等进行设计，实验群体应按要求完成测试。', '', '/var/www/RequirementDoc/实战篇 【实验四、信创办公套件众测】需求文档_4_1618917861571.doc', NULL, NULL, NULL, 3000.00, 3000.00, NULL, '信创实训教学项目。', NULL, 0, 1, '2023-12-12 00:00:00', NULL, 0, '2021-04-20 19:19:16');
INSERT INTO `crowd_test_project` VALUES (20, 'PROJ-2021041915018', '实战篇 实验五、信创压缩软件众测', 4, NULL, 2, 'BASESF', 'OS', '[\"DZCS\"]', '系统发包管理员', '13657094937', '压缩工具，同样是办公软件中常用软件。通常将大体积或零散的文件进行压缩，便携存储、传输等。\n本节实验以信创压缩软件为实验对象，实验群体需按要求完成测试。', '', '/var/www/RequirementDoc/实战篇 【实验五、信创压缩软件众测】需求文档_4_1618917914069.doc', NULL, NULL, NULL, 3000.00, 3000.00, NULL, '信创实训教学项目。', NULL, 0, 1, '2023-12-12 00:00:00', NULL, 0, '2021-04-20 19:18:16');
COMMIT;

-- ----------------------------
-- Table structure for crowd_test_report
-- ----------------------------
DROP TABLE IF EXISTS `crowd_test_report`;
CREATE TABLE `crowd_test_report` (
  `CTR_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '众包报告ID',
  `CTR_CODE` varchar(255) NOT NULL COMMENT '众包报告标识',
  `CTR_NAME` varchar(255) DEFAULT NULL COMMENT '众包报告名称',
  `CTR_U_ID` bigint(20) DEFAULT NULL COMMENT '众包报告人员ID',
  `CTR_DEPENDENCY_CODE` varchar(255) DEFAULT NULL COMMENT '众包报告所属项目或者任务的CODE',
  `CTR_TYPE` varchar(10) DEFAULT NULL COMMENT '众包报告类型',
  `CTR_SCOPE` int(10) DEFAULT NULL COMMENT '众包报告范围',
  `CTR_TEST_OBJECT` varchar(255) DEFAULT NULL COMMENT '众包报告测试对象',
  `CTR_CONTENT` longtext COMMENT '众包报告内容',
  `CTR_DESCRIPTION` longtext COMMENT '众包报告描述',
  `CTR_FILE` varchar(255) DEFAULT NULL COMMENT '众包报告文件',
  `CTR_CONCLUSION` varchar(255) DEFAULT NULL COMMENT '众包报告结论',
  `CTR_IS_DELETED` int(10) DEFAULT NULL COMMENT '众包报告是否被删除',
  `CTR_CREATE_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '众包报告创建时间',
  PRIMARY KEY (`CTR_ID`,`CTR_CODE`) USING BTREE,
  KEY `KP_CTR_CTT_ID` (`CTR_DEPENDENCY_CODE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for crowd_test_task
-- ----------------------------
DROP TABLE IF EXISTS `crowd_test_task`;
CREATE TABLE `crowd_test_task` (
  `CTT_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '众包任务ID',
  `CTT_CODE` varchar(255) NOT NULL COMMENT '众包任务标识',
  `CTT_NAME` varchar(255) NOT NULL COMMENT '众包任务名称',
  `CTT_CTP_CODE` varchar(255) NOT NULL COMMENT '所属众包项目标识CODE\r\n所属众包项目ID',
  `CTT_EA_ID` bigint(20) DEFAULT NULL COMMENT '任务所属测评机构ID',
  `CTT_TYPE` varchar(255) DEFAULT 'GNCS' COMMENT '众包任务业务类型',
  `CTT_DISTRIBUTION_TYPE` bigint(20) DEFAULT NULL COMMENT '众包任务分配方式',
  `CTT_DISTRIBUTION_PROVINCE` varchar(255) DEFAULT NULL COMMENT '众包任务分配省份',
  `CTT_DISTRIBUTION_CITY` varchar(255) DEFAULT NULL COMMENT '众包任务分配城市',
  `CTT_REQUIREMENT_FILE` varchar(255) DEFAULT NULL COMMENT '众包任务需求文档',
  `CTT_DESCRIPTION` longtext COMMENT '众包任务描述',
  `CTT_QUOTED_PRICE` double(10,2) DEFAULT NULL COMMENT '众包任务报价',
  `CTT_FIXED_PRICE` double(10,2) DEFAULT NULL COMMENT '众包任务定价',
  `CTT_STATUS` int(10) DEFAULT NULL COMMENT '众包任务状态',
  `CTT_FULL_STATUS` int(10) DEFAULT '1' COMMENT '众包任务满员情况 0-未满员 1-满员',
  `CTT_PARTICIPANT_COUNT` int(10) DEFAULT '1' COMMENT '众包任务参与人数上限',
  `CTT_ACCEPTED_COUNT` int(10) DEFAULT '0' COMMENT '众包任务已参与人数',
  `CTT_PARTICIPANT_HAS_COMMITTED_COUNT` int(10) DEFAULT '0' COMMENT '众包任务中已提交报告的人员数量',
  `CTT_DEAD_LINE` timestamp NULL DEFAULT NULL COMMENT '众包任务截至时间',
  `CTT_CREATE_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '众包任务创建时间',
  `CTT_END_TIME` timestamp NULL DEFAULT NULL COMMENT '众包任务交付时间',
  `CTT_IS_DELETED` int(10) DEFAULT NULL COMMENT '众包任务是否被删除',
  `CTT_EXPORT_URL` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`CTT_ID`,`CTT_CODE`) USING BTREE,
  KEY `KP_CTT_CTP_ID` (`CTT_CTP_CODE`) USING BTREE,
  KEY `KP_CTT_EM_ID` (`CTT_EA_ID`) USING BTREE,
  KEY `CTT_ID` (`CTT_ID`) USING BTREE,
  KEY `CTT_CODE` (`CTT_CODE`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for develop_authentication
-- ----------------------------
DROP TABLE IF EXISTS `develop_authentication`;
CREATE TABLE `develop_authentication` (
  `DA_ID_CARD_BACK_PHOTO` varchar(255) NOT NULL COMMENT '身份证反面照片',
  `DA_ID_CARD_POS_PHOTO` varchar(255) NOT NULL COMMENT '身份证正面照片',
  `DA_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '企业认证ID',
  `DA_USER_ID` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `DA_NAME` varchar(255) DEFAULT NULL COMMENT '企业名称',
  `DA_LEGAL_PERSON_NAME` varchar(255) DEFAULT NULL COMMENT '企业法人姓名',
  `DA_BUSINESS_LICENSE_PHOTO` varchar(255) DEFAULT NULL COMMENT '企业营业执照',
  `DA_UNIFIED_SOCIAL_CREDIT_CODE` varchar(255) DEFAULT NULL COMMENT '企业统一社会信用代码',
  `DA_BANK_ACCOUNT` varchar(255) DEFAULT NULL COMMENT '企业银行账户',
  `DA_ADDRESS` varchar(255) DEFAULT NULL COMMENT '企业地址',
  `DA_IS_AUTHENTICATION` int(10) DEFAULT NULL COMMENT '企业是否实名',
  `DA_NOT_PASS_EXPLAIN` varchar(255) DEFAULT NULL COMMENT '企业认证未通过说明',
  `DA_IS_DELETED` int(10) DEFAULT NULL COMMENT '企业认证是否删除',
  `DA_APPLY_TIME` timestamp NULL DEFAULT NULL COMMENT '企业认证申请时间',
  `DA_CHECK_TIME` timestamp NULL DEFAULT NULL COMMENT '管理员审核时间',
  `DA_TYPE` varchar(255) DEFAULT NULL COMMENT '类型',
  PRIMARY KEY (`DA_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for end_point
-- ----------------------------
DROP TABLE IF EXISTS `end_point`;
CREATE TABLE `end_point` (
  `EP_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '配置项ID',
  `EP_P_CODE` varchar(255) DEFAULT NULL COMMENT '项目CODE',
  `EP_T_CODE` varchar(255) DEFAULT NULL COMMENT '任务CODE',
  `EP_CASEID` varchar(255) DEFAULT NULL COMMENT '案例ID',
  `EP_EXAMID` varchar(255) DEFAULT NULL COMMENT '考试ID',
  `EP_SERVER_CODE` varchar(255) DEFAULT NULL COMMENT '服务序列号',
  `EP_URL` varchar(255) DEFAULT NULL COMMENT '跳转url',
  `EP_TOKEN` varchar(255) DEFAULT NULL COMMENT '跳转至众测的Token',
  `EP_COLLABORATIVE_TYPE` int(4) DEFAULT '0' COMMENT '0-协同 1-非协同',
  `EP_THREE_PAGE_URL` varchar(255) DEFAULT NULL COMMENT '三级菜单url',
  `EP_IS_SHOWED` int(2) DEFAULT '0' COMMENT '是否作为案例展示，0-不展示 1-展示',
  PRIMARY KEY (`EP_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of end_point
-- ----------------------------
COMMIT;

-- ----------------------------
-- Table structure for evaluation_agency
-- ----------------------------
DROP TABLE IF EXISTS `evaluation_agency`;
CREATE TABLE `evaluation_agency` (
  `EA_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '测评机构ID',
  `EA_U_ID` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `EA_NAME` varchar(255) DEFAULT NULL COMMENT '测评机构名称',
  `EA_PHOTO` varchar(255) DEFAULT NULL COMMENT '测评机构认证照片',
  `EA_BANK_ACCOUNT` varchar(255) DEFAULT NULL COMMENT '测评机构银行账号',
  `EA_GENDER` varchar(255) DEFAULT NULL COMMENT '法人性别',
  `EA_ID_CARD_POSITIVE_PHOTO` varchar(255) DEFAULT NULL COMMENT '身份证正面照片',
  `EA_ID_CARD_BACK_PHOTO` varchar(255) DEFAULT NULL COMMENT '身份证反面照片',
  `EA_ID_CARD_DEAD_TIME` date DEFAULT NULL COMMENT '身份证截止日期',
  `EA_ADDRESS` varchar(255) DEFAULT NULL COMMENT '测评机构地址',
  `EA_UPDATE_TIME` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '测评机构更新时间',
  `EA_EXPIRE_TIME` datetime DEFAULT NULL COMMENT '测评机构过期时间',
  `EA_IS_AUTHENTICATION` int(10) DEFAULT NULL COMMENT '是否认证成功',
  `EA_NOT_PASS_EXPLAIN` varchar(225) DEFAULT NULL COMMENT '认证未通过说明',
  `EA_IS_DELETED` int(10) DEFAULT NULL COMMENT '是否删除',
  `EA_APPLY_TIME` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  `EA_ID_CARD_NUM` varchar(255) DEFAULT NULL COMMENT '身份证号',
  `EA_LEGAL_PERSON_NAME` varchar(255) DEFAULT NULL COMMENT '法人姓名',
  `EA_BUSINESS_LICENSE_PHOTO` varchar(255) DEFAULT NULL COMMENT '企业执照',
  `EA_TYPE` varchar(255) DEFAULT NULL COMMENT '企业类型',
  `EA_CHECK_TIME` timestamp NULL DEFAULT NULL COMMENT '管理员审核时间',
  PRIMARY KEY (`EA_ID`) USING BTREE,
  KEY `KP_USERID` (`EA_U_ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of evaluation_agency
-- ----------------------------
BEGIN;
INSERT INTO `evaluation_agency` VALUES (60, 2, '系统默认企业', '/var/www/Image/2_894faf98-2253-4212-b396-d5cdb789481e_1609256222575.png', NULL, '男', '/var/www/Image/2_bd28f401-6fd7-4c47-97b0-2167b50969cd_1609256288393.jpg', '/var/www/Image/2_b4e9dae8-fdef-40fd-9719-86cc1d091621_1609256291493.png', '2029-12-01', '江苏省南京市鼓楼区', NULL, NULL, 1, '', 0, '2020-12-29 23:38:13', '360730198807162223', '系统企业', '/var/www/Image/2_1cf8e8d8-38dd-4ffd-8de7-c495644f639f_1609256242561.png', '[1,0]', '2020-12-29 23:39:02');
COMMIT;

-- ----------------------------
-- Table structure for evaluation_agency_ability
-- ----------------------------
DROP TABLE IF EXISTS `evaluation_agency_ability`;
CREATE TABLE `evaluation_agency_ability` (
  `EAA_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '测评机构能力ID',
  `EAA_EA_ID` bigint(20) DEFAULT NULL COMMENT '测评机构ID',
  `EAA_ABILITY_NAME` varchar(225) CHARACTER SET utf8 DEFAULT NULL COMMENT '测评机构能力名称',
  `EAA_IS_DELETED` int(10) DEFAULT NULL COMMENT '是否删除',
  `EAA_CREATE_TIME` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`EAA_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for evaluation_agency_resource
-- ----------------------------
DROP TABLE IF EXISTS `evaluation_agency_resource`;
CREATE TABLE `evaluation_agency_resource` (
  `EAR_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '测评机构资源ID',
  `EAR_EA_ID` bigint(20) DEFAULT NULL COMMENT '测评机构ID',
  `EAR_TYPE` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '测评机构资源类型',
  `EAR_NAME` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '测评机构资源详细信息',
  `EAR_TOTAL_NUM` int(10) DEFAULT NULL COMMENT '测评机构资源数量',
  `EAR_AVAILABLE_NUM` int(10) DEFAULT NULL COMMENT '测评机构资源可用数量',
  `EAR_IS_DELETED` int(10) DEFAULT NULL COMMENT '是否删除',
  `EAR_CREATE_TIME` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`EAR_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for expert
-- ----------------------------
DROP TABLE IF EXISTS `expert`;
CREATE TABLE `expert` (
  `E_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '专家ID',
  `E_NAME` varchar(255) DEFAULT NULL COMMENT '专家名称',
  `E_PHOTO` varchar(255) DEFAULT NULL COMMENT '专家头像',
  `E_TITLE` varchar(255) DEFAULT NULL COMMENT '专家头衔',
  `E_INTRODUCTION` longtext COMMENT '专家介绍',
  PRIMARY KEY (`E_ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of expert
-- ----------------------------
BEGIN;
INSERT INTO `expert` VALUES (1, '陈振宇', 'http://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/Expert/chenzhengyu.png', '南京大学教授、博士生导师', '慕测科技创始人、IEEE国际软件测试大赛发起人，江苏省计算机学会产业工委执行主任，苏宁易购独立董事。慕测是ASE和ISSTA顶会的赞助商，个人担任ICSE、FSE、ASE各类顶会的程序委员会委员，IEEE Transactions on Reliability 期刊Associate Editor，JSS、SPE、SQJ等期刊Guest Editor。曾主持发明专利转让项目2项、发明专利许可项目1项、海关总署金关工程二期项目1项、国家重点研发计划课题1项和国家自然科学基金（重点项目、面上项目、国际交流项目）8项，参与973计划、国家自然科学基金重大研究计划、重大国际合作项目若干项。开创了MoocTest，并在AITest和BigCode取得了重要研究成果，部分成果已经在百度、阿里、华为等知名软件公司转化，研究成果获2012年度江苏省科学技术奖一等奖、2015年湖北省科技进步奖一等奖、2017年CCF NASAC-东软青年软件创新奖和2018年国家教学成果奖二等奖。');
INSERT INTO `expert` VALUES (2, '房春荣', 'http://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/Expert/fangcunrong.png', '南京大学软件学院教师，CCF容错专委委员', '主要从事智能软件工程研究。主持国家自然科学基金青年项目1项，国家重点研发项目骨干2项，教育部产学合作协同育人项目1项，横向科研项目若干。任AIST等学术会议程序委员会共同主席。在FSE、ICSE、ASE、ISSTA、ISSRE、SCIE等会议期刊发表论文30余篇，申请发明专利10余项，部分成果在华为、百度等知名企业应用。参编多项软件工程和工业APP相关国家、省、团体标准。2018国家精品在线开放课程《软件测试》主要成员。');
INSERT INTO `expert` VALUES (3, '黄勇', 'http://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/Expert/huangyong.jpeg', '慕测科技CTO', '原中国人民解放军95851部队大数据部门负责人，承研军队信息系统项目21项，获全军科技进步一等奖1项。担任国家重点研发专项骨干1项，江苏省重点研发专项骨干1项。南京大学企业讲师，苏州大学企业讲师。资深敏捷教练，南京AgileClub成员，连续5年担任中国（南京）全球软件开发者大会出品人，AgileTour特邀嘉宾。具有丰富的敏捷开发、系统架构和团队管理经验。成功帮助爱立信、西门子、中国移动、中国电信、中国邮政等知名企业实施敏捷转型与DevOps。红帽认证RHSA、RHCE。');
INSERT INTO `expert` VALUES (4, '王青', 'http://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/Expert/wangqing.png', '二级研究员、博士生导师、中国科学软件研究所副总工程师，互联网软件技术实验室主任，基础软件测评实验室主任', '王青，女，博士，二级研究员、博士生导师，毕业于中国科学院研究生院，现任中国科学软件研究所副总工程师，互联网软件技术实验室主任，基础软件测评实验室主任。主要研究方向为软件过程、软件质量保障、众包众测、知识工程、软件工程大数据与人工智能等。主持和承担了十余项国家863、973、自然科学基金等重点/重大项目和国际合作项目。目前主要社会兼职为国际软件与系统过程协会（ISSPA）主任委员会成员，国际期刊IST、JSEP编委，以及多个国际会议的程序委员会委员，并担任IEEE TSE、ACM computing surveys、JSS、JCST、软件学报等国际/国内期刊审稿人。全国信息技术标准化委员会软件质量测试工作组副组长，CMMI认证授权的主任评估师。曾担任中国电子学会云计算专家委员会委员，国防科工委质量专家组软件组副组长，IEEE/ACM国际会议ESEIW/ESEM2015大会主席，ICSP2007、ICSP2008、ICSSP2009等多个国际高水平会议的程序委员会主席，获得国务院政府特殊津贴及国家和省部委科技进步奖10余次。特别是近年研究的软件过程和质量管理相关成果分别获国家科技进步二等奖、北京市科学技术二等奖。相关研究成果近年有5本论/编著、100 余篇论文在国际、国内高水平学术刊物以及国际会议发表。');
INSERT INTO `expert` VALUES (5, '王崇骏', 'http://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/Expert/wangchongjun.png', '南京大学计算机科学与技术系教授，博士生导师。现任南京大学计算机应用研究所副所长、南京大学中德HPI研究院副院长', '王崇骏，男，博士，南京大学计算机科学与技术系教授，博士生导师。现任南京大学计算机应用研究所副所长、南京大学中德HPI研究院副院长。主要研究方向包括：大数据分析及智能系统、复杂网络分析理论及应用、智能Agent及多Agent系统等。近五年发表论文50余篇、出版专著2部。截至2017年底，主持和参与包括国家重点研发项目、973、发改委专项、工信部产业化基金、国家自然科学基金、国家社会科学基金、省自然科学基金及支撑计划在内的国家及省部级基金与企事业资助项目50余项，30余项成果获得产品化和商品化推广。');
INSERT INTO `expert` VALUES (6, '叶东升', 'http://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/Expert/yedongsheng.png', '北京计算机技术及应用研究所副所长、国家高端装备和智能制造软件质量监督检验中心主任、航天软件评测中心主任，中国探月工程软件专家组副组长、中国载人航天工程软件专家组成员，空军重点型号软件专家组成员、中国指挥控制学会常务理事等', '叶东升，男，北京计算机技术及应用研究所副所长、国家高端装备和智能制造软件质量监督检验中心主任、航天软件评测中心主任，中国探月工程软件专家组副组长、中国载人航天工程软件专家组成员，空军重点型号软件专家组成员、中国指挥控制学会常务理事等。作为课题组长承担了2项总装预研课题“软件可靠性测试环境研究”和“嵌入式软件全数字虚拟测试环境技术研究”，1项国防科技工委国防基础科研课题“武器装备嵌入式软件总和测试平台技术研究”，2项载人航天二期工程项目“软件安全性技术研究”和“嵌入式软件中断系统冲突缺陷检测技术研究”，此外还负责组织实施921二期工程和048工程等国家重大科技工程中关键软件的评测工作，主持或参与了多项软件国家军用标准的制定。研究成果获科技进步特等奖及多项国防科技进步奖，荣获“全国五一劳动奖章”，军队科技进步一等奖。');
INSERT INTO `expert` VALUES (7, '黄松', 'http://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/Expert/huangsong.jpeg', '博士生导师，现任陆军工程大学教授、软件工程学科带头人，全军军事训练软件测评中心主任', '黄松，男，博士，博士生导师，现任陆军工程大学教授、软件工程学科带头人，全军军事训练软件测评中心主任，主要研究方向为软件测试与质量保证，目前主要社会兼职为国务院学位办软件工程学科声誉评估专家，国家科技部863项目评审专家，军用软件测评实验室资质认可的专家评审员，装备发展部武器装备承试资格评审专家，中国计算机学会容错计算专委会副主任委员，QRS2018、CTC2018等国际国内高水平会议软件测试论坛主席。获军队专业技术干部一类岗位津贴，江苏省“333高层次人才培养工程”第三层次培养对象。在软件测试和质量评估领域，主持和承担国家和军队重点科研项目多项，承担全军装备软件定型测评项目100余项。获军队教学成果一等奖1项、军队科技进步二、三等奖8项，国家发明专利10余项，发表高水平论文50余篇，指导学生获国家一级学会优博提名奖、江苏省学会优博奖。2016年，作为发起人之一，开创了一年一度的全国大学生软件测试大赛，2018年参赛人数达到近万人。');
INSERT INTO `expert` VALUES (8, '黄万民', 'http://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/Expert/huangwanmin.jpeg', '高级工程师，广东拓思软件科学园有限公司副总经理、总工程师、兼任广东软件评测中心主任，广东工业大学和华南师范大学软件工程硕士企业导师', '黄万民，高级工程师，广东拓思软件科学园有限公司副总经理、总工程师、兼任广东软件评测中心主任，广东工业大学和华南师范大学软件工程硕士企业导师。长期从事计算机应用研究、软件工程研究、行业电子产品研发等方面工作，主要负责孵化器公共技术服务平台的建设、分管技术服务业务，先后带领团队组建了广东省软件共性技术重点实验室、广东省软件共性技术公共实验室、广东软件评测中心、广东软件科学园网络数据中心等技术研发及服务机构，建立了IDC、软件评测、技术资源服务等公共技术服务业务。其主持承担国家八五重点科技攻关项目、国家863计划项目、国家支撑计划项目、科技部创新基金项目、广东省科技项目等十多项，其主持研发的产品曾获广东省科委科技进步一等奖及广东省科技进步三等奖，个人曾获得电子部八五科技攻关突出贡献奖励。');
INSERT INTO `expert` VALUES (9, '王俊杰', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/Expert/zanwu.png', '中国科学院软件研究所副研究员、硕士生导师', '中国科学院青年创新促进会会员、中国科学院软件研究所杰出青年。主要从事软件数据挖掘、软件质量、智能化软件工程等方面的研究，近年来主要关注软件众包测试场景，研究如何提升众测质量、效率和效益，增强众测服务的智能化水平。主持和参与了多项国家自然科学基金项目、科技部重点研发计划等。在国际著名学术期刊/会议（如TSE、ICSE、FSE、ASE等）发表20余篇学术论文，申请发明专利近10项，荣获ICSE 2019、ICSE2020杰出论文奖，QRS2019优秀论文奖等。');
INSERT INTO `expert` VALUES (10, '惠战伟', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/Expert/huizhanwei.png', '军事科学院评估论证研究中心助理研究员，博士后，CCF容错计算专委会副秘书长', '分别于2005年、2009年、2015年在解放军理工大学取得学士、硕士、博士学位。作为第一作者（通信作者）在ASE、ISSRE等CCF A类、B类会议发表论文6篇，在IEEE TR、IET Software、SQJ等SCI期刊发表论文7篇，获得国家发明专利11项，获得中国指控学会优秀博士论文提名奖、、江苏省计算机学会优秀博士学位论文奖、解放军理工大学优秀博士论文奖军队及省部级科技进步二等奖、三等奖各1项。主持国家国家重点研发计划子项目1项、国家自然科学基金青年项目1项、江苏省自然科学基青年项目1项、国家博士后基金面上项目1项、军内科研项目1项、军队横向软件测评项目8项，参与并完成国家“863”计划等基金项目6项。2020年获得CCF-CTC软件测试青年创新奖。');
INSERT INTO `expert` VALUES (11, '王萍', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/Expert/wangping.png', '高级工程师，广东省计算机学会常务理事', '广东拓思软件科学园有限公司评测中心（广东软件评测中心）副主任、技术研发和测评服务带头人。主要从事计算机软件开发、软件测试、项目管理、软件过程改进和质量管理等工作，曾主持承担多项国家、省、市级科技计划项目。');
INSERT INTO `expert` VALUES (12, '田文春', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/Expert/tianwenchun.png', '工学博士，高级工程师、资深CISP、广州市应急专家，现任广东拓思软件科学园有限公司评测中心（广东软件评测中心）副主任', '长期从事信息安全和质量保障方面的研究，对安全架构、密钥管理、数据清洗、区块链等技术等有丰富的研发经验。主持和承担了国家发改委、广东省科技厅重大专项、广东省科技厅自然科学基金、广东省科技厅产学研专项等多个专项项目。');
COMMIT;

-- ----------------------------
-- Table structure for field
-- ----------------------------
DROP TABLE IF EXISTS `field`;
CREATE TABLE `field` (
  `F_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '领域ID',
  `F_CODE` varbinary(255) DEFAULT NULL COMMENT '领域CODE',
  `F_NAME` varchar(255) DEFAULT NULL COMMENT '领域名称',
  `F_INTRODUCTION` longtext COMMENT '领域介绍',
  PRIMARY KEY (`F_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of field
-- ----------------------------
BEGIN;
INSERT INTO `field` VALUES (1, 0x424153455346, '基础软件', '基础软件是指控制和协调计算机及外部设备,支持应用软件开发和运行的系统，是无需用户干预的各种程序的集合，主要功能是调度，监控和维护计算机系统；负责管理计算机系统中各种独立的硬件，使得它们可以协调工作。');
INSERT INTO `field` VALUES (2, 0x4150505346, '应用软件', '应用软件（application software）是用户可以使用的各种程序设计语言，以及用各种程序设计语言编制的应用程序的集合，分为应用软件包和用户程序。');
INSERT INTO `field` VALUES (8, 0x4F54484552, '其他类型', '其他');
COMMIT;

-- ----------------------------
-- Table structure for partner
-- ----------------------------
DROP TABLE IF EXISTS `partner`;
CREATE TABLE `partner` (
  `P_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '合作伙伴ID',
  `P_NAME` varchar(255) DEFAULT NULL COMMENT '合作伙伴名称',
  `P_IMAGE` varchar(255) DEFAULT NULL COMMENT '合作伙伴图标',
  PRIMARY KEY (`P_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for permission
-- ----------------------------
DROP TABLE IF EXISTS `permission`;
CREATE TABLE `permission` (
  `P_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '权限ID',
  `P_NAME` varchar(255) DEFAULT NULL COMMENT '权限名称',
  `P_RESOURCE` varchar(255) DEFAULT NULL COMMENT '资源',
  `P_OPERATION` varchar(255) DEFAULT NULL COMMENT '操作',
  `P_CREATE_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`P_ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of permission
-- ----------------------------
BEGIN;
INSERT INTO `permission` VALUES (1, '主页', NULL, '/', '2019-08-23 17:22:47');
INSERT INTO `permission` VALUES (2, '主页', NULL, '/home', '2019-08-23 17:23:00');
INSERT INTO `permission` VALUES (3, '我的众测', NULL, '/mine', '2019-08-23 17:23:06');
INSERT INTO `permission` VALUES (4, '任务广场', NULL, '/square', '2019-08-23 17:23:10');
INSERT INTO `permission` VALUES (5, '创建项目', NULL, '/project/create', '2019-08-23 17:30:25');
INSERT INTO `permission` VALUES (6, '查看项目', NULL, '/project/:projectId', '2019-08-23 17:30:27');
INSERT INTO `permission` VALUES (7, '创建任务', NULL, '/project/:projectId/task/create', '2019-08-23 17:30:40');
INSERT INTO `permission` VALUES (8, '查看任务', NULL, '/project/:projectId/task/:taskId', '2019-08-23 17:30:46');
INSERT INTO `permission` VALUES (9, '创建项目报告', NULL, '/project/:projectId/report/create', '2019-08-23 17:31:00');
INSERT INTO `permission` VALUES (10, '创建任务报告', NULL, '/project/:projectId/task/:taskId/report/create', '2019-08-23 17:31:06');
INSERT INTO `permission` VALUES (11, '查看项目报告', NULL, '/project/:projectId/report/:reportId', '2019-08-23 17:31:51');
INSERT INTO `permission` VALUES (12, '查看任务报告', NULL, '/project/:projectId/task/:taskId/report/:reportId', '2019-08-23 17:31:44');
INSERT INTO `permission` VALUES (13, '绿色通道添加项目', NULL, '/greenChannel/addProject', '2019-08-23 17:31:33');
INSERT INTO `permission` VALUES (14, '绿色通道添加机构', NULL, '/greenChannel/addAgency', '2019-08-23 17:32:04');
INSERT INTO `permission` VALUES (15, '创建个人认证信息', NULL, '/authentication/individual/create', '2019-08-23 17:32:11');
INSERT INTO `permission` VALUES (16, '创建机构认证信息', NULL, '/authentication/enterprise/create', '2019-08-23 17:32:19');
INSERT INTO `permission` VALUES (17, '创建企业认证信息', NULL, '/authentication/agency/create', '2019-08-23 17:32:25');
INSERT INTO `permission` VALUES (18, '查看个人认证信息', NULL, '/authentication/individual/:userId', '2019-08-23 17:32:31');
INSERT INTO `permission` VALUES (19, '查看企业认证信息', NULL, '/authentication/enterprise/:userId', '2019-08-23 17:32:33');
INSERT INTO `permission` VALUES (20, '查看机构认证信息', NULL, '/authentication/agency/:userId', '2019-08-23 17:34:45');
INSERT INTO `permission` VALUES (21, '认证菜单', NULL, '/authentication/index', '2019-08-23 17:34:51');
INSERT INTO `permission` VALUES (22, '审核认证信息', NULL, '/authentication/manage', '2019-08-23 17:34:53');
COMMIT;

-- ----------------------------
-- Table structure for personal_authentication
-- ----------------------------
DROP TABLE IF EXISTS `personal_authentication`;
CREATE TABLE `personal_authentication` (
  `PA_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '个人认证ID',
  `PA_USER_ID` bigint(20) NOT NULL COMMENT '用户ID',
  `PA_REAL_NAME` varchar(255) DEFAULT NULL COMMENT '个人真实名',
  `PA_ID_CARD` varchar(255) DEFAULT NULL COMMENT '个人身份证号',
  `PA_ID_CARD_PHOTO` varchar(255) DEFAULT NULL COMMENT '（可删除）个人手持身份证照片',
  `PA_ID_CARD_POS_PHOTO` varchar(255) DEFAULT NULL COMMENT '个人认证身份证正面照片',
  `PA_ID_CARD_BACK_PHOTO` varchar(255) DEFAULT NULL COMMENT '个人认证身份证反面照片',
  `PA_GENDER` varchar(20) DEFAULT NULL COMMENT '性别',
  `PA_BANK_ACCOUNT` varchar(255) DEFAULT NULL COMMENT '（可删除）个人银行账户',
  `PA_ADDRESS` varchar(255) DEFAULT NULL COMMENT '个人地址',
  `PA_TYPE` varchar(255) DEFAULT NULL COMMENT '0是发包 1是接包 如果两个都有那么权限都有',
  `PA_IS_AUTHENTICATION` int(10) DEFAULT NULL COMMENT '个人是否实名认证',
  `PA_APPLY_TIME` timestamp NULL DEFAULT NULL COMMENT '个人认证申请时间',
  `PA_NOT_PASS_EXPLAIN` varchar(255) DEFAULT NULL COMMENT '个人认证未通过说明',
  `PA_CHECK_TIME` timestamp NULL DEFAULT NULL COMMENT '管理员审核时间',
  `PA_IS_DELETED` int(10) DEFAULT NULL COMMENT '个人认证是否删除',
  `PA_EXPIRE_TIME` datetime DEFAULT NULL COMMENT '身份证过期时间',
  PRIMARY KEY (`PA_ID`,`PA_USER_ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of personal_authentication
-- ----------------------------
BEGIN;
INSERT INTO `personal_authentication` VALUES (1, 4, '系统发包管理员', '360730199909993939', NULL, '/var/www/Image/4_6a1678d7-78f0-4f55-9b0e-1e1cdf78ff50_1609256611938.jpg', '/var/www/Image/4_ec923a09-5166-44b4-81e8-d25e769616fd_1609256615629.png', '男', NULL, '江苏省南京市', '[1]', 1, '2020-12-29 23:43:44', '', '2020-12-29 23:44:01', 0, '2029-12-01 00:00:00');
COMMIT;

-- ----------------------------
-- Table structure for project_distribution_type
-- ----------------------------
DROP TABLE IF EXISTS `project_distribution_type`;
CREATE TABLE `project_distribution_type` (
  `PDT_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '项目分配方式ID',
  `PDT_NAME` varchar(255) DEFAULT NULL COMMENT '项目分配方式名称',
  `PDT_CREATE_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`PDT_ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of project_distribution_type
-- ----------------------------
BEGIN;
INSERT INTO `project_distribution_type` VALUES (1, '区域', '2019-07-31 13:43:13');
INSERT INTO `project_distribution_type` VALUES (2, '广场', '2019-07-31 13:43:19');
INSERT INTO `project_distribution_type` VALUES (7, '定向', '2019-07-31 13:43:02');
COMMIT;

-- ----------------------------
-- Table structure for province
-- ----------------------------
DROP TABLE IF EXISTS `province`;
CREATE TABLE `province` (
  `P_CODE` bigint(20) NOT NULL COMMENT '省份代码',
  `P_NAME` varchar(255) DEFAULT NULL COMMENT '省份名称',
  PRIMARY KEY (`P_CODE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of province
-- ----------------------------
BEGIN;
INSERT INTO `province` VALUES (11, '北京市');
INSERT INTO `province` VALUES (12, '天津市');
INSERT INTO `province` VALUES (13, '河北省');
INSERT INTO `province` VALUES (14, '山西省');
INSERT INTO `province` VALUES (15, '内蒙古自治区');
INSERT INTO `province` VALUES (21, '辽宁省');
INSERT INTO `province` VALUES (22, '吉林省');
INSERT INTO `province` VALUES (23, '黑龙江省');
INSERT INTO `province` VALUES (31, '上海市');
INSERT INTO `province` VALUES (32, '江苏省');
INSERT INTO `province` VALUES (33, '浙江省');
INSERT INTO `province` VALUES (34, '安徽省');
INSERT INTO `province` VALUES (35, '福建省');
INSERT INTO `province` VALUES (36, '江西省');
INSERT INTO `province` VALUES (37, '山东省');
INSERT INTO `province` VALUES (41, '河南省');
INSERT INTO `province` VALUES (42, '湖北省');
INSERT INTO `province` VALUES (43, '湖南省');
INSERT INTO `province` VALUES (44, '广东省');
INSERT INTO `province` VALUES (45, '广西壮族自治区');
INSERT INTO `province` VALUES (46, '海南省');
INSERT INTO `province` VALUES (50, '重庆市');
INSERT INTO `province` VALUES (51, '四川省');
INSERT INTO `province` VALUES (52, '贵州省');
INSERT INTO `province` VALUES (53, '云南省');
INSERT INTO `province` VALUES (54, '西藏自治区');
INSERT INTO `province` VALUES (61, '陕西省');
INSERT INTO `province` VALUES (62, '甘肃省');
INSERT INTO `province` VALUES (63, '青海省');
INSERT INTO `province` VALUES (64, '宁夏回族自治区');
INSERT INTO `province` VALUES (65, '新疆维吾尔自治区');
INSERT INTO `province` VALUES (71, '台湾省');
INSERT INTO `province` VALUES (81, '香港特别行政区');
INSERT INTO `province` VALUES (82, '澳门特别行政区');
COMMIT;

-- ----------------------------
-- Table structure for publications
-- ----------------------------
DROP TABLE IF EXISTS `publications`;
CREATE TABLE `publications` (
  `P_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '专著ID',
  `P_TITLE` varchar(255) DEFAULT NULL COMMENT '专著标题',
  `P_YEAR` varchar(255) DEFAULT NULL COMMENT '出版年份',
  `P_CONFERENCE_JOURNAL` varchar(255) DEFAULT NULL COMMENT '论文会议或期刊',
  `P_AUTHOR_LIST` varchar(255) DEFAULT NULL COMMENT '作者列表',
  `P_SEC_LANG_TITLE` varchar(255) DEFAULT NULL COMMENT '专著中文名',
  `P_CH_AUTHORS` varchar(255) DEFAULT NULL COMMENT '作者中文名',
  `P_UPLOADED_DATE` timestamp NULL DEFAULT NULL COMMENT '上传日期',
  `P_CHINESE_BRIEF` varchar(255) DEFAULT NULL COMMENT '中文摘要',
  PRIMARY KEY (`P_ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of publications
-- ----------------------------
BEGIN;
INSERT INTO `publications` VALUES (1, 'Research progress of crowdsourced software testing', '2017', 'Journal of Software', 'Xiaofang Zhang, Yang Feng, Di Liu, Zhenyu Chen, Baowen Xu', '众包软件测试研究进展众包软件测试研究进展', '章晓芳，冯洋，刘頔 ，陈振宇，徐宝文', NULL, NULL);
INSERT INTO `publications` VALUES (2, 'An empirical study on user-topic rating based collaborative filtering methods', '2017', 'WWW Journal', 'Tieke He, Zhenyu Chen, Jia Liu, Xiaofang Zhou, Xingzhong Du, Weiqing Wang', '基于用户话题排序的协同过滤方法实证研究', '何铁科，陈振宇，刘嘉，周晓方，都兴中，王维清', NULL, NULL);
INSERT INTO `publications` VALUES (3, 'An empirical study on constraint optimization techniques for test generation', '2017', 'SCIENCE CHINA Information Sciences 60(1): 12105', 'Zhiyi Zhang, Zhenyu Chen, Ruizhi Gao, W. Eric Wong, Baowen Xu', '测试生成的约束优化技术实证研究', '张智轶，陈振宇，高睿智，W. Eric Wong，徐宝文', NULL, NULL);
INSERT INTO `publications` VALUES (4, 'Effective software fault localization using predicted execution results', '2017', 'Software Quality Journal  25(1): 131-169', 'Ruizhi Gao, W. Eric Wong, Zhenyu Chen, Yabin Wang', '利用预测执行结果进行有效的软件故障定位', '高睿智，W. Eric Wong，陈振宇，汪亚斌', NULL, NULL);
INSERT INTO `publications` VALUES (5, 'Software numerical Instability detection and diagnosis by combining stochastic and infinite-precision testing', '2017', 'IEEE Transactions on Software Engineering. 43(10): 975-994', 'Enyi Tang, Xiangyu Zhang, Norbert Th. Müller, Zhenyu Chen, Xuandong Li', '结合随机与无限精度测试的软件数值不稳定性检测与诊断', '汤恩义，张翔宇，Norbert Mueller，陈振宇，李宣东', NULL, 'https://www.toutiao.com/i6623547745892303368/');
INSERT INTO `publications` VALUES (7, 'An industrial study of natural language processing based test case prioritization', '2017', 'ICST 2017, pp. 548-549', 'Yilin Yang, Xinhai Huang, Xuefei Hao, Zicong Liu, Zhenyu Chen', '基于自然语言处理的测试用例优先级工业化研究', '杨乙霖，黄鑫海，郝雪飞，刘子聪，陈振宇', NULL, NULL);
INSERT INTO `publications` VALUES (8, 'Multi-objective test report prioritization using image understanding', '2016', 'ASE 2016, pp. 202-213', 'Yang Feng, James Jone, Zhenyu Chen, Chunrong Fang', '基于图像理解的多目标测试报告优先化', '冯洋，James Jone，陈振宇，房春荣', NULL, 'https://www.toutiao.com/i6621100793405637134/');
INSERT INTO `publications` VALUES (9, 'A spatial-temporal topic model for the semantic annotation of POIs in LBSNs', '2016', 'ACM Transactions on Intelligent Systems and Technology', 'Tieke He, Hongzhi Yin, Zhenyu Chen, Xiaofang Zhou, Shazia Sadiq, Bin Luo', 'LBSN网络中兴趣点语义标注的时空主题模型', '何铁科，阴红志，陈振宇，周晓方，Shazia Sadiq，骆斌', NULL, NULL);
INSERT INTO `publications` VALUES (10, 'An empirical study on constraint optimization techniques for test generation', '2016', 'Science China-Information Science', 'Zhiyi Zhang, Zhenyu Chen, Zicong Liu, Qingkai Shi, Baowen Xu', '测试生成的约束优化技术实证研究', '张智轶，陈振宇，刘子聪，时清凯，徐宝文', NULL, NULL);
INSERT INTO `publications` VALUES (11, 'Guiding the crowds for android testing', '2016', 'ICSE 2016-Poster, pp. 752-753', 'Xin Zhang, Zhenyu Chen, Chunrong Fang, Zicong Liu', '在安卓测试中引导群体', '张欣，陈振宇，房春荣，刘子聪', NULL, 'https://www.toutiao.com/i6622943178989257219/');
INSERT INTO `publications` VALUES (12, 'Revisit of automatic debugging via human focus-tracking analysis', '2016', 'ICSE 2016[Tool][Data], pp. 808-819 ', 'Xiaoyuan Xie, Zicong Liu, Shuo Song, Zhenyu Chen, Jifeng Xuan, Baowen Xu', '通过人工聚焦跟踪分析重新访问自动调试', '谢晓园，刘子聪，宋硕，陈振宇，玄跻峰，徐宝文', NULL, NULL);
INSERT INTO `publications` VALUES (13, 'Mubug:a mobile service for rapid bug tracking', '2016', 'Science China-Information Science, 2016 [Demo]', 'Yang Feng, Qin Liu, Mengyu Dou, Jia Liu, Zhenyu Chen', 'Mubug：一种用于快速漏洞跟踪的移动服务', '冯洋，刘钦，豆梦宇，刘嘉，陈振宇', NULL, NULL);
INSERT INTO `publications` VALUES (14, 'Effective software fault localization using predicted execution results', '2016', 'Software Quality Journal', 'Ruizhi Gao, Eric Wong,Zhenyu Chen, Yabin Wang', '通过预测执行结果进行有效的软件故障定位', '高睿智，Eric Wong，陈振宇，汪亚斌', NULL, NULL);
INSERT INTO `publications` VALUES (15, 'Verifying synchronization for atomicity violation fixing', '2016', 'IEEE Transactions on Software Engineering, 2016 [Tool]', 'Qingkai Shi, Jeff Huang, Zhenyu Chen, Baowen Xu', '原子性破坏修复的同步证明', '时清凯，Jeff Huang，陈振宇，徐宝文', NULL, NULL);
INSERT INTO `publications` VALUES (16, 'SITAR: GUI test script repair.', '2016', 'IEEE Transactions on Software Engineering, 2016 [Data]', 'Zebao Gao,Zhenyu Chen, Atif Memon, Yunxiao Zou', 'SITAR：GUI测试脚本修复', '高则宝，陈振宇，Atif Memon，邹云潇', NULL, 'https://www.toutiao.com/i6618772671591088653/');
INSERT INTO `publications` VALUES (17, 'Test report prioritization to assist crowdsourced testing.', '2015', 'ESEC/FSE 2015, pp. 225-236', 'Yang Feng, Zhenyu Chen, James Jones, Chunrong Fang and Baowen Xu', '辅助众包测试的测试报告优先化', '冯洋，陈振宇，James Jones，房春荣，徐宝文', NULL, 'https://www.toutiao.com/i6619855119078916612/');
INSERT INTO `publications` VALUES (18, 'An empirical study of bug fixing rate.', '2015', 'COMPSAC 2015, pp. 254-263', 'Weiqin Zou, Xin Xia, Weiqiang Zhang, Zhenyu Chen, David Lo', '关于漏洞修复速率的实证研究辅助众包测试的测试报告优先化', '邹卫琴，夏鑫，张伟强，陈振宇，David Lo', NULL, NULL);
INSERT INTO `publications` VALUES (19, 'EFSM-based test case generation: sequence, data, and oracle.', '2015', ' Int\'l Journal of Software Engineering and Knowledge Engineering', 'Rui Yang, Zhenyu Chen, Zhiyi Zhang, Baowen Xu', '基于EFSM的测试用例生成：序列、数据和Oracle', '杨瑞，陈振宇，张智轶，徐宝文', NULL, NULL);
INSERT INTO `publications` VALUES (20, 'Are slice-based cohesion metrics actually useful in effort aware fault-proneness prediction? An empirical study.', '2015', 'IEEE Transactions on Software Engineering', 'Yibiao Yang, Yuming Zhou, Hongmin Lu, Lin Chen, Zhenyu Chen, Baowen Xu, Hareton Leung, Zhengyu Zhang', '关于基于切片的内聚性度量是否在实际的工作感知故障倾向预测中有用的实证研究', '杨已彪，周毓明，卢红敏，陈林，陈振宇，徐宝文，Hareton Leung, 张振宇', NULL, NULL);
INSERT INTO `publications` VALUES (21, 'Developer social networks in software engineering: construction, analysis, and application.', '2014', 'Science China-F', 'Weiqiang Zhang, Liming Nie, He Jiang, Zhenyu Chen, Jia Liu', '软件工程中的开发者社交网络：构建、分析与应用', '张伟强，聂黎明，江贺，陈振宇，刘嘉', NULL, 'https://www.toutiao.com/i6620737785085035021/');
INSERT INTO `publications` VALUES (22, 'WAS: a weighted attribute-based strategy for cluster test selection.', '2014', 'Journal of Systems and Software', 'Yabin Wang, Ruizhi Gao, Zhenyu Chen, Eric Wong, Bin Luo', 'WAS: 一种基于加权属性的聚类选择策略', '汪亚斌，高睿智，陈振宇，Eric Wong，骆斌', NULL, NULL);
INSERT INTO `publications` VALUES (23, 'Bug inducing analysis to prevent fault prone bug fixes.', '2014', 'SEKE 2014, pp. 620-625', 'Haoyu Yang, Chen Wang, Qingkai Shi, Yang Feng, Zhenyu Chen', '防止故障倾向性错误修复的错误诱导分析', '杨浩宇，王辰，时清凯，冯洋，陈振宇', NULL, NULL);
INSERT INTO `publications` VALUES (24, 'Testing as an investment.', '2014', 'SEKE 2014', 'Xiaoran Xu, Chunrong Fang, Qing Wu, Jia Liu, Zhenyu Chen', '作为投资的测试', '许晓然，房春荣，吴清，刘嘉，陈振宇', NULL, NULL);
INSERT INTO `publications` VALUES (25, 'Virtual DOM coverage for effective testing of dynamic web applications.', '2014', 'ISSTA 2014, pp. 60-70', 'Yunxiao Zou, Zhenyu Chen, Yunhui Zheng, Xiangyu Zhang, Zebao Gao', '动态Web应用中有效测试的虚拟DOM覆盖', '邹云潇，陈振宇，郑云辉，张翔宇，高则宝', NULL, NULL);
INSERT INTO `publications` VALUES (26, 'Automatic numerical analysis based on infinite-precision arithmetic.', '2014', 'SERE 2014, pp. 216-224', 'Shuai Wei, Enyi Tang, Tianyu Liu, Norbert Mueller, Zhenyu Chen', '基于无穷精度算法的自动数值分析', '魏帅，汤恩义，刘天宇，Norbert Mueller,陈振宇', NULL, NULL);
INSERT INTO `publications` VALUES (27, 'A novel approach of automated test case generation on extended finite state machine (in Chinese).', '2014', 'Science China-F', 'Rui Yang, Zhenyu Chen, Zhiyi Zhang, Zicong Liu, Baowen Xu', '一种扩展有限状态机的自动化测试用例生成新方法', '杨瑞，陈振宇，张智轶，徐宝文', NULL, NULL);
INSERT INTO `publications` VALUES (28, 'Hybrid test data generation.', '2014', 'ICSE 2014, pp. 630-631', 'Zicong Liu, Zhenyu Chen, Chunrong Fang, Qingkai Shi', '混合测试数据生成', '刘子聪，陈振宇，房春荣，时清凯', NULL, NULL);
INSERT INTO `publications` VALUES (29, 'Quasi-crowdsourcing testing for educational projects.', '2014', 'ICSE 2014, pp. 272-275', 'Zhenyu Chen, Bin Luo', '教育项目的近似众包测试', '陈振宇，骆斌', NULL, 'https://www.toutiao.com/i6642448888374493700/');
INSERT INTO `publications` VALUES (30, 'Towards more accurate multi-label software behavior learning.', '2014', 'CSMR/WCRE 2014, pp. 134-143', 'Xin Xia, Feng Yang, David Lo, Zhenyu Chen and Xinyu Wang', '面向更精确的多标签软件行为学习', '夏鑫，冯洋，David Lo，陈振宇，王新宇', NULL, 'https://www.toutiao.com/i6620739710211850756/');
INSERT INTO `publications` VALUES (31, 'GUI testing assisted by human knowledge: random vs. functional.', '2014', 'Journal of Systems and Software', 'Weiran Yang, Zhenyu Chen, Zebao Gao, Yunxiao Zou, Xiaoran Xu', '人类知识辅助的GUI测试：随机与功能', '杨薇然，陈振宇，高则宝，邹云潇，许晓然', NULL, NULL);
INSERT INTO `publications` VALUES (32, 'Similarity-based test case prioritization using ordered sequences of program entities.', '2014', 'Software Quality Journal', 'Chunrong Fang, Zhenyu Chen, Kun Wu, Zhihong Zhao', '基于相似度的程序实体有序序列测试用例优先级排序', '房春荣，陈振宇，吴堃，赵志宏', NULL, 'https://www.toutiao.com/i6622254170265092612/');
INSERT INTO `publications` VALUES (33, 'A clustering-based strategy to identify coincidental correctness in fault localization.', '2013', 'International Journal of Software Engineering and Knowledge Engineering', 'Yi Miao, Zhenyu Chen, Sihan Li, Zhihong Zhao, Yuming Zhou', '基于聚类分析识别错误定位中偶然性正确的测试用例技术', '缪怡，陈振宇，李思汗，赵志宏，周毓明', NULL, NULL);
INSERT INTO `publications` VALUES (34, 'A hybrid coverage criterion for DynamicWeb testing(s).', '2013', 'SEKE 2013, pp. 210-213', 'Yunxiao Zou, Chunrong Fang, Zhenyu Chen, Xiaofang Zhang, Zhihong Zhao', '关于动态Web测试覆盖准则的研究（S）', '邹云潇，房春荣，陈振宇，章晓芳，赵志宏', NULL, NULL);
INSERT INTO `publications` VALUES (35, 'Research progress on test case evolution (in Chinese).', '2013', 'Chinese Journal of Software', 'Zhiyi Zhang, Zhenyu Chen, Baowen Xu, Rui Yang', '测试用例演化研究进展（中文）', '张智轶，陈振宇，徐宝文，杨瑞', NULL, NULL);
INSERT INTO `publications` VALUES (36, 'A novel user-based collaborative filtering method by inferring tag ratings.', '2012', 'ACM Applied Computing Review', 'Jia Liu, Weiqing Wang, Zhenyu Chen, Xingzhong Du, Qi Qi', '一种新的基于用户的推导标签评分的协同过滤方法', '刘嘉，王维清，陈振宇，都兴中，齐琪', NULL, NULL);
INSERT INTO `publications` VALUES (37, 'Comparing logic coverage criteria on test case prioritization.', '2012', 'Science China Information Science', 'Chunrong Fang, Zhenyu Chen, Baowen Xu', '测试用例优先级的逻辑覆盖准则的比较', '房春荣，陈振宇，徐宝文', NULL, NULL);
INSERT INTO `publications` VALUES (38, 'Using weighted attributes to improve cluster test selection.', '2012', 'SERE 2012, pp. 138-146', 'Yabin Wang, Zhenyu Chen, Yang Feng, Bin Luo, Yijie Yang', '使用加权属性改进集群测试选择的研究', '汪亚斌，陈振宇，冯洋，骆斌，杨依洁', NULL, NULL);
INSERT INTO `publications` VALUES (39, 'Multi-label software behavior learning.', '2012', 'ICSE 2012, pp. 1305-1308', 'Yang Feng, Zhenyu Chen', '多标签软件行为学习', '冯洋，陈振宇', NULL, NULL);
INSERT INTO `publications` VALUES (40, 'Improve the effectiveness of test case generation on EFSM via automatic path feasibility analysis.', '2011', 'HASE 2011, pp. 17-24', 'Rui Yang, Zhenyu Chen, Baowen Xu, Eric Wong, Jie Zhang', '通过自动路径可行性分析提高EFSM测试用例生成的有效性', '杨瑞，陈振宇，徐宝文，Eric Wong，张洁', NULL, NULL);
INSERT INTO `publications` VALUES (41, 'Using program slicing to improve the efficiency and effectiveness of cluster test selection.', '2011', 'International Journal of Software Engineering and Knowledge Engineering', 'Zhenyu Chen, Yongwei Duan, Zhihong Zhao, Baowen Xu, Ju Qian', '使用程序切片提高集群测试选择的效率', '陈振宇，段勇伟，赵志宏，徐宝文，钱菊', NULL, 'https://www.toutiao.com/i6622941884039823875/');
INSERT INTO `publications` VALUES (42, 'Mutation selection: some could be better than all.', '2011', 'EAST Workshop', 'Zhiyi Zhang, Dongjiang You, Zhenyu Chen, Yuming Zhou, Baowen Xu', '突变选择：部分可能优于所有', '张智轶，尤东江，陈振宇，周毓明，徐宝文', NULL, NULL);
INSERT INTO `publications` VALUES (43, 'Teaching software testing methods based on diversity principles.', '2011', 'CSEE&T 2011, pp.391-395', 'Zhenyu Chen, Jinyu Zhang, Bin Luo', '基于多样性原理的教学软件测试方法', '陈振宇，张瑾玉，骆斌', NULL, NULL);
INSERT INTO `publications` VALUES (44, 'Using semi-supervised clustering to improve regression test selection techniques.', '2011', 'ICST 2011, pp.1-10', 'Songyu Chen, Zhenyu Chen, Zhihong Zhao, Baowen Xu, Yang Feng', '使用半监督聚类对回归测试选择技术的改进', '陈松宇，陈振宇，赵志宏，徐宝文，冯洋', NULL, 'https://www.toutiao.com/i6621849593753649668/');
INSERT INTO `publications` VALUES (45, 'A revisit of fault class hierarchies in general boolean specifications.', '2011', 'ACM Transactions on Software Engineering and Methodology, 20(3)', 'Zhenyu Chen, T.Y. Chen, Baowen Xu', '一般布尔规范中异常类层次的再探讨', '陈振宇，T.Y. Chen，骆斌', NULL, NULL);
INSERT INTO `publications` VALUES (46, 'An improved regression test selection technique by clustering execution profiles.', '2010', 'QSIC 2010, pp.171-179', 'Chen Zhang, Zhenyu Chen, Zhihong Zhao, Shali Yan, Jinyu Zhang, Baowen Xu', '一种改进的聚类执行配置文件的回归测试选择技术', '张晨，陈振宇，赵志宏，闫莎莉，张瑾玉，徐宝文', NULL, NULL);
INSERT INTO `publications` VALUES (47, 'The complexity results of variable minimal formulas.', '2010', 'Chinese Science Bulletin, 55(18):1957-1960', 'Zhenyu Chen, Baowen Xu, Decheng Ding', '变量极小公式的复杂性结果', '陈振宇，徐宝文，丁德成', NULL, NULL);
INSERT INTO `publications` VALUES (48, 'A dynamic test cluster sampling strategy by leveraging execution spectra information.', '2010', 'ICST 2010, pp.147-154', 'Shali Yan, Zhenyu Chen, Zhihong Zhao, Chen Zhang, Yuming Zhou', '利用执行光谱信息的动态测试集群抽样策略', '闫莎莉，陈振宇，赵志宏，张晨，周毓明', NULL, 'https://www.toutiao.com/i6621471022988132867/');
INSERT INTO `publications` VALUES (49, 'A novel method of mutation clustering based on domain analysis.', '2009', 'SEKE 2009, pp. 422-425', 'Changbin Ji, Zhenyu Chen, Baowen Xu, Zhihong Zhao', '一种新的基于域分析的变异聚类方法', '季长斌，陈振宇，徐宝文，赵志宏', NULL, NULL);
INSERT INTO `publications` VALUES (50, 'A degraded ILP approach for test suite reduction.', '2008', 'SEKE 2008, pp. 494-499', 'Zhenyu Chen, Xiaofang Zhang, Baowen Xu', '一种测试用例集约简的退化ILP方法', '陈振宇，章晓芳，徐宝文', NULL, NULL);
INSERT INTO `publications` VALUES (51, 'A detectability analysis of fault classes for boolean specifications.', '2008', 'ACM SAC 2008, pp. 390-394', 'Zhenyu Chen, Baowen Xu, Changhai Nie', '布尔规范中错误类的可检测性分析', '陈振宇，徐宝文，聂长海', NULL, NULL);
INSERT INTO `publications` VALUES (52, 'A novel approach for test suite reduction based on requirement relation contraction.', '2008', 'ACM SAC 2008, pp. 826-830', 'Zhenyu Chen, Baowen Xu, Xiaofang Zhang, Changhai Nie', '一种新的基于需求关系收缩的测试用例集约简方法', '陈振宇，徐宝文，章晓芳，聂长海', NULL, NULL);
INSERT INTO `publications` VALUES (53, 'Applying variable minimal unsatisfiability in model checking.', '2008', 'Chinese Journal of Software, 19(1): 39-47', 'Zhenyu Chen, Zhihong Tao, Hans Kleine Büning, Lifu Wang', '变量极小不可满足在模型检测中的应用', '陈振宇，陶志红，KLEINE BüNING Hans，王立福', NULL, NULL);
INSERT INTO `publications` VALUES (54, 'Comparing fault-based testing strategies of general boolean specifications.', '2007', 'IEEE COMPSAC 2007, pp. 621-622', 'Zhenyu Chen, Baowen Xu, Changhai Nie', '一般布尔规范中故障测试策略的比较', '陈振宇，徐宝文，聂长海', NULL, NULL);
INSERT INTO `publications` VALUES (55, 'Implication-based approximating bounded model checking.', '2007', 'SEN, LNCS 2007, pp. 350-363', 'Zhenyu Chen, Zhihong Tao, Baowen Xu, Lifu Wang', '基于蕴涵的近似有界模型检验', '陈振宇，陶志红，徐宝文，王立福', NULL, NULL);
INSERT INTO `publications` VALUES (56, 'Variable minimal unsatisfiability.', '2006', 'TAMC, LNCS 2006, pp. 262-273', 'Zhenyu Chen, Decheng Ding', '变量极小不可满足', '陈振宇，丁德成', NULL, NULL);
INSERT INTO `publications` VALUES (57, 'Automatic abstraction refinement for petri nets verification.', '2005', 'HLDVT 2005, pp. 168-174', 'Zhenyu Chen, Conghua Zhou, and Decheng Ding', 'HLDVT, pp. 168-174', '陈振宇，周从华，丁德成', NULL, NULL);
INSERT INTO `publications` VALUES (62, 'PTM: A topic model for the inferring of the penalty.', '2018', 'Journal of Computer Science and Technology', 'Tieke He, Hao Lian, Zemin Qin, Zhenyu Chen, Bin Luo', 'PTM：一种用于罚金推断的主题模型', '何铁科，廉昊，秦泽民，陈振宇，骆斌', NULL, NULL);
INSERT INTO `publications` VALUES (63, 'Fuzzy clustering of crowdsourced test reports for apps.', '2018', 'ACM Transactions on Internet Technology. 18(2): 18:1-18:28', 'He Jiang, Xin Chen, Tieke He, Zhenyu Chen, Xiaochen Li', '应用程序众包测试报告中的模糊聚类', '江贺，陈信，何铁科，陈振宇，李晓晨', NULL, 'https://www.toutiao.com/i6619150611034145284/');
INSERT INTO `publications` VALUES (64, 'An empirical study on software failure classification with multi-label and problem-transformation techniques.', '2018', 'ICST 2018, pp. 320-330', 'Yang Feng, James A. Jones, Zhenyu Chen, Chunrong Fang', '基于多标签和问题转化技术的软件故障分类实证研究', '冯洋，James A. Jones，陈振宇，房春荣', NULL, NULL);
INSERT INTO `publications` VALUES (65, 'Automated quality assessment for crowdsourced test reports of mobile applications.', '2018', 'SANER 2018, pp. 368-379', 'Xin Chen, He Jiang, Xiaochen Li, Tieke He, Zhenyu Chen', '针对移动应用程序众包测试报告的自动质量评估', '陈信，江贺，李晓晨，何铁科，陈振宇', NULL, 'https://www.toutiao.com/i6619460351068996110/');
INSERT INTO `publications` VALUES (66, 'How practitioners perceive automated bug report management techniques.', '2018', 'IEEE Transactions on Software Engineering ( Early Access )', 'Weiqin Zou, David Lo,  Zhenyu Chen,  Xin Xia,  Yang Feng,  Baowen Xu', 'How Practitioners Perceive Automated Bug Report Management Techniques', '邹卫琴，David Lo，陈振宇，夏鑫，冯洋，徐宝文', '2018-09-18 19:45:39', NULL);
INSERT INTO `publications` VALUES (67, 'Successes, challenges, and rethinking ? an industrial investigation on crowdsourced mobile application testing.', '2018', 'Empirical Software Engineering', 'Ruizhi Gao,Yabin Wang,Yang Feng, Zhenyu Chen, W. Eric Wong', 'Successes, challenges, and rethinking ? an industrial investigation on crowdsourced mobile application testing', 'Ruizhi Gao,Yabin Wang,Yang Feng, Zhenyu Chen, W. Eric Wong', '2018-09-18 19:42:19', NULL);
INSERT INTO `publications` VALUES (68, 'Improving software testing education via industry sponsored contest.', '2018', 'FIE 2018', 'W. Eric Wong, Linghuan Hu, Haoliang Wang, and Zhenyu Chen', 'Improving software testing education via industry sponsored contest, W. Eric Wong, Linghuan Hu and Haoliang Wang, FIE 2018', 'W. Eric Wong, Linghuan Hu, Haoliang Wang, and Zhenyu Chen', '2018-09-27 12:26:00', NULL);
INSERT INTO `publications` VALUES (69, 'A unified framework for bug report assignment.', '2018', 'International Journal of Software Engineering and Knowledge Engineering', 'Yuan Zhao, Tieke He, Zhenyu Chen', 'Yuan Zhao, Tieke He, Zhenyu Chen: A Unified Framework for Bug Report Assignment. IJSEKE (2018)', 'Yuan Zhao, Tieke He, Zhenyu Chen: A Unified Framework for Bug Report Assignment. IJSEKE (2018)', '2018-09-30 09:17:00', NULL);
INSERT INTO `publications` VALUES (70, 'Global optimization of numerical programs via prioritized stochastic algebraic transformations.', '2019', 'ICSE 2019', 'Xie Wang, Huaijin Wang, Zhendong Su, Enyi Tang, Xin Chen, Weijun Shen, Zhenyu Chen, Linzhang Wang, Xianpei Zhang, Xuandong Li', 'Xie Wang, Huaijin Wang, Zhendong Su, Enyi Tang, Xin Chen, Weijun Shen, Zhenyu Chen, Linzhang Wang, Xianpei Zhang, Xuandong Li', 'Global optimization of numerical programs via prioritized stochastic algebraic transformations', '2018-12-13 17:30:44', NULL);
INSERT INTO `publications` VALUES (71, 'CTRAS: Crowdsourced test report aggregation and summarization.', '2019', 'ICSE 2019', 'Rui Hao, Yang Feng, James Jones, Yuying Li, Zhenyu Chen', 'CTRAS: Crowdsourced test report aggregation and summarization', 'Hao rui, Yang Feng, James Jones, Yuying Li, Zhenyu Chen', '2018-12-13 17:32:13', NULL);
INSERT INTO `publications` VALUES (72, 'MAF: Method-anchored test fragmentation for test code plagiarism detection.', '2019', 'ICSE 2019-SEET', 'Weisong Sun, Xingya Wang, Haoran Wu, Ding Duan, Zesong Sun, Zhenyu Chen', 'MAF: Method-anchored test fragmentation for test code plagiarism detection', 'Weisong Sun, Xingya Wang, Haoran Wu, Ding Duan, Zesong Sun and Zhenyu Chen', '2018-12-17 10:43:00', NULL);
INSERT INTO `publications` VALUES (73, 'MuNN: Mutation analysis of neural networks.', '2018', 'QRS-C 2018', 'Weijun Shen, Jun Wan, Zhenyu Chen', 'MuNN: Mutation analysis of neural networks', 'Weijun Shen, Jun Wan, Zhenyu Chen', '2018-12-30 14:08:56', NULL);
INSERT INTO `publications` VALUES (74, 'Automatic test report augmentation to assist crowdsourced testing.', '2019', 'Frontiers of Computer Science', 'Xin Chen, He Jiang, Zhenyu Chen, Tieke He, Liming Nie', 'Automatic test report augmentation to assist crowdsourced testing.', 'Xin Chen, He Jiang, Zhenyu Chen, Tieke He, Liming Nie', '2019-02-01 00:13:07', NULL);
INSERT INTO `publications` VALUES (75, 'Towards generating cost-effective Test-Suite for ethereum smart contract.', '2019', 'SANER 2019', 'Xingya Wang, Haoran Wu, Weisong Sun and Yuan Zhao', 'Towards Generating Cost-Effective Test-Suite for Ethereum Smart Contract.', 'Xingya Wang, Haoran Wu, Weisong Sun and Yuan Zhao.', '2019-02-01 00:14:32', NULL);
INSERT INTO `publications` VALUES (76, 'Software testing contest-observations and lessons learned.', '2019', 'IEEE Computer', 'Xingya Wang, Weisong Sun, Yuan Zhao, Linghuan Hu, Eric Wong, Zhenyu Chen', 'Software Testing Contest-Observations and Lessons Learned', 'Xingya Wang, Weisong Sun, Yuan Zhao, Linghuan Hu, Eric Wong, Zhenyu Chen', '2019-03-06 12:03:09', NULL);
INSERT INTO `publications` VALUES (77, 'How does code style inconsistency affect pull request integration? An exploratory study on 117 GitHub projects.', '2019', 'Empirical Software Engineering.', 'Weiqin Zou, Jifeng Xuan, Xiaoyuan Xie, Zhenyu Chen, Baowen Xu', 'How does code style inconsistency affect pull request integration? An exploratory study on 117 GitHub projects.', 'Weiqin Zou, Jifeng Xuan, Xiaoyuan Xie, Zhenyu Chen, Baowen Xu', '2019-04-23 10:47:56', NULL);
INSERT INTO `publications` VALUES (78, 'File-level socio-technical congruence and its relationship with bug proneness in OSS projects.', '2019', 'Journal of Systems and Software', 'Weiqiang Zhang, Shing-Chi Cheung, Zhenyu Chen, Yuming Zhou, Bin Luo', 'File-level socio-technical congruence and its relationship with bug proneness in OSS projects.', 'Weiqiang Zhang, Shing-Chi Cheung, Zhenyu Chen, Yuming Zhou, Bin Luo', '2019-05-17 11:46:22', NULL);
INSERT INTO `publications` VALUES (79, ' CoCoTest: Collaborative crowdsourced testing for Android applications.', '2019', 'ISSTA 2019 Demo', 'Haoyu Li, Chunrong Fang, Zhibin Wei, Zhenyu Chen', ' CoCoTest: Collaborative crowdsourced testing for Android applications', 'Haoyu Li, Chunrong Fang, Zhibin Wei, Zhenyu Chen', '2019-05-25 10:31:30', NULL);
INSERT INTO `publications` VALUES (80, 'CTRAS: A tool for aggregating and summarizing crowdsourced test reports.', '2019', 'ISSTA 2019 Demo', 'Yuying Li, Rui Hao, Yang Feng, James Jone, Xiaofang Zhang, Zhenyu Chen', 'CTRAS: A tool for aggregating and summarizing crowdsourced test reports', 'Yuying Li, Rui Hao, Yang Feng, James Jone, Xiangfang Zhang, Zhenyu Chen', '2019-05-27 10:32:46', NULL);
INSERT INTO `publications` VALUES (81, 'Branch use in practice--a large-scale empirical study  of 2,923 projects on GitHub.', '2019', 'QRS 2019', 'Weiqin Zou, Weiqiang Zhang, Xin Xia, Reid Holmes, Zhenyu Chen', 'Branch use in practice--A large-scale empirical study  of 2,923 projects on GitHub', 'Weiqin Zou, Weiqiang Zhang, Xin Xia, Reid Holmes and Zhenyu Chen', '2019-05-27 19:28:30', NULL);
INSERT INTO `publications` VALUES (82, 'Judicial image quality assessment based on deep learning: an  exploratory study.', '2019', ' QRS 2019', 'Qiqi Gu, Weilin Cai, Shengcheng Yu, Zhenyu Chen', 'Judicial Image Quality Assessment Based on Deep Learning: An  Exploratory Study', 'Qiqi Gu, Weilin Cai, Shengcheng Yu and Zhenyu Chen', '2019-05-27 19:31:04', NULL);
INSERT INTO `publications` VALUES (83, 'DeepGini: prioritizing massive tests to reduce labeling cost.', '2019', 'arXiv 1903.00661', 'Qingkai Shi, Jun Wan, Yang Feng, Chunrong Fang, Zhenyu Chen', 'DeepGini: Prioritizing Massive Tests to Reduce Labeling Cost', 'Qingkai Shi, Jun Wan, Yang Feng, Chunrong Fang, Zhenyu Chen', '2019-06-06 13:13:28', NULL);
INSERT INTO `publications` VALUES (84, 'NeuralVis: visualizing and interpreting deep learning models.', '2019', 'ASE 2019-Demo', 'Xufan Zhang, Ziyue Yin, Yang Feng, Qingkai Shi, Jia Liu, Zhenyu Chen', 'NeuralVis: Visualizing and Interpreting Deep Learning Models', 'Xufan Zhang, Ziyue Yin, Yang Feng, Qingkai Shi, Jia Liu, Zhenyu Chen', '2019-06-06 13:14:50', NULL);
INSERT INTO `publications` VALUES (87, 'Measuring the diversity of a test set with distance entropy', '2015', 'IEEE Transactions on Reliability', 'Qingkai Shi, Zhenyu Chen, Chunrong Fang, Yang Feng, Baowen Xu', 'Measuring the diversity of a test set with distance entropy', 'Qingkai Shi, Zhenyu Chen, Chunrong Fang, Yang Feng, Baowen Xu', '2019-07-04 23:30:58', NULL);
INSERT INTO `publications` VALUES (88, 'Quality assessment of crowdsourced test scripts. ', '2019', 'NASAC 2019', 'Yuan Zhao, Yang Feng, Yi Wang, Rui Hao, Zhenyu Chen', 'Quality assessment of crowdsourced test Scripts. ', 'Yuan Zhao, Yang Feng, Yi Wang, Rui Hao, Zhenyu Chen', '2019-08-10 10:13:00', NULL);
INSERT INTO `publications` VALUES (89, 'MuSC: A tool for mutation testing of ethereum smart contract.', '2019', 'ASE 2019-Demo', 'Zixin Li, Haoran Wu, Jiehui Xu, Xingya Wang , Lingming Zhang, Zhenyu Chen', 'MuSC: A Tool for Mutation Testing of Ethereum Smart Contract. ', 'Zixin Li，Haoran Wu，Jiehui Xu，Xingya Wang', '2019-08-13 11:10:18', NULL);
INSERT INTO `publications` VALUES (90, 'LIRAT: Layout and image recognition driving automated mobile testing of cross-platform.', '2019', 'ASE 2019-Demo', 'Shengcheng Yu, Chunrong Fang, Yang Feng, Wenyuan Zhao, Zhenyu Chen', 'LIRAT: Layout and Image Recognition Driving Automated Mobile Testing of Cross-Platform.', 'Shengcheng Yu, Chunrong Fang, Yang Feng, Wenyuan Zhao, Zhenyu Chen.', '2019-08-13 11:12:18', NULL);
INSERT INTO `publications` VALUES (91, 'Mutation testing for ethereum smart contract.', '2019', 'arXiv.1908.03707', 'Haoran Wu, Xingya Wang, Jiehui Xu, Weiqin Zou, Lingming Zhang, Zhenyu Chen', 'Mutation Testing for Ethereum Smart Contract. ', 'Haoran Wu, Xingya Wang, Jiehui Xu, Weiqin Zou, Lingming Zhang, Zhenyu Chen.', '2019-08-13 11:13:18', NULL);
INSERT INTO `publications` VALUES (92, 'DeepPath: Path-driven testing criteria for Deep Neural Networks.', '2019', 'AITest 2019', 'Dong Wang, Ziyuan Wang, Chunrong Fang, Yanshan Chen, Zhenyu Chen', 'DeepPath: Path-Driven Testing Criteria for Deep Neural Networks.', 'ong Wang, Ziyuan Wang, Chunrong Fang, Yanshan Chen, Zhenyu Chen', '2019-05-26 12:18:07', NULL);
INSERT INTO `publications` VALUES (93, 'The evolution of open-source blockchain systems: an empirical study.', '2019', 'Internetware 2019', 'Jiawei Cao, Xingya Wang, Zixin Li, Qiqi Gu and Zhenyu Chen', 'The Evolution of Open-Source Blockchain Systems:An Empirical Study', 'Jiawei Cao, Xingya Wang, Zixin Li, Qiqi Gu and Zhenyu Chen', '2019-09-02 17:47:02', NULL);
INSERT INTO `publications` VALUES (94, 'A preliminary study on data augmentation of Deep Learning for image classification.', '2019', 'Internetware 2019', 'Cheng Lei, Benlin Hu, Dong Wang, Shu Zhang and Zhenyu Chen', 'A Preliminary Study on Data Augmentation of Deep Learning for Image Classification', 'Cheng Lei, Benlin Hu, Dong Wang, Shu Zhang and Zhenyu Chen', '2019-09-02 17:47:55', NULL);
INSERT INTO `publications` VALUES (95, 'From data quality to model quality: an exploratory study on Deep Learning.', '2019', 'Internetware 2019', 'Tianxing He, Shengcheng Yu, Ziyuan Wang, Jieqiong Li and Zhenyu Chen', 'From Data Quality to Model Quality: an Exploratory Study on Deep Learning', 'Tianxing He, Shengcheng Yu, Ziyuan Wang, Jieqiong Li and Zhenyu Chen', '2019-09-02 17:48:47', NULL);
INSERT INTO `publications` VALUES (96, 'Smart contract development: challenges and opportunities.', '2019', 'IEEE Transactions on Software Engineering', 'Weiqin Zou, David Lo, Pavneet Singh Kochhar, Xuan-Bach Dinh Le, Xin Xia, Yang Feng, Zhenyu Chen and Baowen Xu', 'How practitioners perceive automated bug report management techniques.', 'Weiqin Zou, David Lo, Zhenyu Chen, Xin Xia, Yang Feng, Baowen Xu', '2019-09-11 13:29:50', NULL);
INSERT INTO `publications` VALUES (97, 'An approach of developing highly trustworthy crowd workforce (in Chinese)', '2019', 'SCIENTIA SINICA Informationis', 'Yang Feng, Yi Wang, Chunrong Fang, Nannan Guo and Zhenyu Chen', 'An Approach of Developing Highly Trustworthy Crowd Workforce (in Chinese)', 'Yang Feng, Yi Wang, Chunrong Fang, Nannan Guo and Zhenyu Chen', '2019-09-18 11:05:59', NULL);
INSERT INTO `publications` VALUES (98, 'DeepGini: Prioritizing Massive Tests to Enhance the Robustness of Deep Neuron Networks', '2020', 'ISSTA 2020', 'Yang Feng, Qingkai Shi, Xinyu Gao, Jun Wan, Chunrong Fang and Zhenyu Chen', 'DeepGini: Prioritizing Massive Tests to Enhance the Robustness of Deep Neuron Networks', '冯洋，时清凯，高新宇，万俊，房春荣，陈振宇', '2020-04-29 16:48:00', NULL);
INSERT INTO `publications` VALUES (99, 'Functional Code Clone Detection with Syntax and Semantics Fusion Learning', '2020', 'ISSTA 2020', 'Chunrong Fang, Zixi Liu, Yangyang Shi, Jeff Huang and Qingkai Shi', 'Functional Code Clone Detection with Syntax and SemanticsFusion Learning', '房春荣，刘子夕，史洋洋，时清凯', '2020-04-29 16:48:00', NULL);
INSERT INTO `publications` VALUES (100, 'FuRong: Fusing Report of Automated Android Testing on Multi-Devices', '2020', 'ICSE 2020 Demo', 'Yuanhan Tian, Shengcheng Yu, Chunrong Fang, Peiyuan Li', 'FuRong: Fusing Report of Automated Android Testing on Multi-Devices', 'Yuanhan Tian, Shengcheng Yu, Chunrong Fang, Peiyuan Li', '2020-04-29 16:50:00', NULL);
COMMIT;

-- ----------------------------
-- Table structure for qualification
-- ----------------------------
DROP TABLE IF EXISTS `qualification`;
CREATE TABLE `qualification` (
  `Q_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户证书ID',
  `Q_NAME` varchar(255) DEFAULT NULL COMMENT '证书名称',
  `Q_NUMBER` varchar(255) DEFAULT NULL COMMENT '证书编号',
  `Q_LICENSING_AUTHORITY` varchar(255) DEFAULT NULL COMMENT '证书方法单位',
  `Q_TIME` date DEFAULT NULL COMMENT '发证时间',
  `Q_U_ID` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `Q_DELETED` int(4) NOT NULL COMMENT '是否被删除',
  `Q_PUBLIC` int(4) NOT NULL COMMENT '是否公开',
  PRIMARY KEY (`Q_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for regional
-- ----------------------------
DROP TABLE IF EXISTS `regional`;
CREATE TABLE `regional` (
  `R_CODE` bigint(20) NOT NULL COMMENT '城市代码',
  `R_P_CODE` bigint(20) DEFAULT NULL COMMENT '省份代码',
  `R_NAME` varchar(255) DEFAULT NULL COMMENT '城市名称',
  PRIMARY KEY (`R_CODE`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of regional
-- ----------------------------
BEGIN;
INSERT INTO `regional` VALUES (1101, 11, '北京市');
INSERT INTO `regional` VALUES (1201, 12, '天津市');
INSERT INTO `regional` VALUES (1301, 13, '石家庄市');
INSERT INTO `regional` VALUES (1302, 13, '唐山市');
INSERT INTO `regional` VALUES (1303, 13, '秦皇岛市');
INSERT INTO `regional` VALUES (1304, 13, '邯郸市');
INSERT INTO `regional` VALUES (1305, 13, '邢台市');
INSERT INTO `regional` VALUES (1306, 13, '保定市');
INSERT INTO `regional` VALUES (1307, 13, '张家口市');
INSERT INTO `regional` VALUES (1308, 13, '承德市');
INSERT INTO `regional` VALUES (1309, 13, '沧州市');
INSERT INTO `regional` VALUES (1310, 13, '廊坊市');
INSERT INTO `regional` VALUES (1311, 13, '衡水市');
INSERT INTO `regional` VALUES (1390, 13, '省直辖县级行政区划');
INSERT INTO `regional` VALUES (1401, 14, '太原市');
INSERT INTO `regional` VALUES (1402, 14, '大同市');
INSERT INTO `regional` VALUES (1403, 14, '阳泉市');
INSERT INTO `regional` VALUES (1404, 14, '长治市');
INSERT INTO `regional` VALUES (1405, 14, '晋城市');
INSERT INTO `regional` VALUES (1406, 14, '朔州市');
INSERT INTO `regional` VALUES (1407, 14, '晋中市');
INSERT INTO `regional` VALUES (1408, 14, '运城市');
INSERT INTO `regional` VALUES (1409, 14, '忻州市');
INSERT INTO `regional` VALUES (1410, 14, '临汾市');
INSERT INTO `regional` VALUES (1411, 14, '吕梁市');
INSERT INTO `regional` VALUES (1501, 15, '呼和浩特市');
INSERT INTO `regional` VALUES (1502, 15, '包头市');
INSERT INTO `regional` VALUES (1503, 15, '乌海市');
INSERT INTO `regional` VALUES (1504, 15, '赤峰市');
INSERT INTO `regional` VALUES (1505, 15, '通辽市');
INSERT INTO `regional` VALUES (1506, 15, '鄂尔多斯市');
INSERT INTO `regional` VALUES (1507, 15, '呼伦贝尔市');
INSERT INTO `regional` VALUES (1508, 15, '巴彦淖尔市');
INSERT INTO `regional` VALUES (1509, 15, '乌兰察布市');
INSERT INTO `regional` VALUES (1522, 15, '兴安盟');
INSERT INTO `regional` VALUES (1525, 15, '锡林郭勒盟');
INSERT INTO `regional` VALUES (1529, 15, '阿拉善盟');
INSERT INTO `regional` VALUES (2101, 21, '沈阳市');
INSERT INTO `regional` VALUES (2102, 21, '大连市');
INSERT INTO `regional` VALUES (2103, 21, '鞍山市');
INSERT INTO `regional` VALUES (2104, 21, '抚顺市');
INSERT INTO `regional` VALUES (2105, 21, '本溪市');
INSERT INTO `regional` VALUES (2106, 21, '丹东市');
INSERT INTO `regional` VALUES (2107, 21, '锦州市');
INSERT INTO `regional` VALUES (2108, 21, '营口市');
INSERT INTO `regional` VALUES (2109, 21, '阜新市');
INSERT INTO `regional` VALUES (2110, 21, '辽阳市');
INSERT INTO `regional` VALUES (2111, 21, '盘锦市');
INSERT INTO `regional` VALUES (2112, 21, '铁岭市');
INSERT INTO `regional` VALUES (2113, 21, '朝阳市');
INSERT INTO `regional` VALUES (2114, 21, '葫芦岛市');
INSERT INTO `regional` VALUES (2201, 22, '长春市');
INSERT INTO `regional` VALUES (2202, 22, '吉林市');
INSERT INTO `regional` VALUES (2203, 22, '四平市');
INSERT INTO `regional` VALUES (2204, 22, '辽源市');
INSERT INTO `regional` VALUES (2205, 22, '通化市');
INSERT INTO `regional` VALUES (2206, 22, '白山市');
INSERT INTO `regional` VALUES (2207, 22, '松原市');
INSERT INTO `regional` VALUES (2208, 22, '白城市');
INSERT INTO `regional` VALUES (2224, 22, '延边朝鲜族自治州');
INSERT INTO `regional` VALUES (2301, 23, '哈尔滨市');
INSERT INTO `regional` VALUES (2302, 23, '齐齐哈尔市');
INSERT INTO `regional` VALUES (2303, 23, '鸡西市');
INSERT INTO `regional` VALUES (2304, 23, '鹤岗市');
INSERT INTO `regional` VALUES (2305, 23, '双鸭山市');
INSERT INTO `regional` VALUES (2306, 23, '大庆市');
INSERT INTO `regional` VALUES (2307, 23, '伊春市');
INSERT INTO `regional` VALUES (2308, 23, '佳木斯市');
INSERT INTO `regional` VALUES (2309, 23, '七台河市');
INSERT INTO `regional` VALUES (2310, 23, '牡丹江市');
INSERT INTO `regional` VALUES (2311, 23, '黑河市');
INSERT INTO `regional` VALUES (2312, 23, '绥化市');
INSERT INTO `regional` VALUES (2327, 23, '大兴安岭地区');
INSERT INTO `regional` VALUES (3101, 31, '上海市');
INSERT INTO `regional` VALUES (3201, 32, '南京市');
INSERT INTO `regional` VALUES (3202, 32, '无锡市');
INSERT INTO `regional` VALUES (3203, 32, '徐州市');
INSERT INTO `regional` VALUES (3204, 32, '常州市');
INSERT INTO `regional` VALUES (3205, 32, '苏州市');
INSERT INTO `regional` VALUES (3206, 32, '南通市');
INSERT INTO `regional` VALUES (3207, 32, '连云港市');
INSERT INTO `regional` VALUES (3208, 32, '淮安市');
INSERT INTO `regional` VALUES (3209, 32, '盐城市');
INSERT INTO `regional` VALUES (3210, 32, '扬州市');
INSERT INTO `regional` VALUES (3211, 32, '镇江市');
INSERT INTO `regional` VALUES (3212, 32, '泰州市');
INSERT INTO `regional` VALUES (3213, 32, '宿迁市');
INSERT INTO `regional` VALUES (3301, 33, '杭州市');
INSERT INTO `regional` VALUES (3302, 33, '宁波市');
INSERT INTO `regional` VALUES (3303, 33, '温州市');
INSERT INTO `regional` VALUES (3304, 33, '嘉兴市');
INSERT INTO `regional` VALUES (3305, 33, '湖州市');
INSERT INTO `regional` VALUES (3306, 33, '绍兴市');
INSERT INTO `regional` VALUES (3307, 33, '金华市');
INSERT INTO `regional` VALUES (3308, 33, '衢州市');
INSERT INTO `regional` VALUES (3309, 33, '舟山市');
INSERT INTO `regional` VALUES (3310, 33, '台州市');
INSERT INTO `regional` VALUES (3311, 33, '丽水市');
INSERT INTO `regional` VALUES (3401, 34, '合肥市');
INSERT INTO `regional` VALUES (3402, 34, '芜湖市');
INSERT INTO `regional` VALUES (3403, 34, '蚌埠市');
INSERT INTO `regional` VALUES (3404, 34, '淮南市');
INSERT INTO `regional` VALUES (3405, 34, '马鞍山市');
INSERT INTO `regional` VALUES (3406, 34, '淮北市');
INSERT INTO `regional` VALUES (3407, 34, '铜陵市');
INSERT INTO `regional` VALUES (3408, 34, '安庆市');
INSERT INTO `regional` VALUES (3410, 34, '黄山市');
INSERT INTO `regional` VALUES (3411, 34, '滁州市');
INSERT INTO `regional` VALUES (3412, 34, '阜阳市');
INSERT INTO `regional` VALUES (3413, 34, '宿州市');
INSERT INTO `regional` VALUES (3415, 34, '六安市');
INSERT INTO `regional` VALUES (3416, 34, '亳州市');
INSERT INTO `regional` VALUES (3417, 34, '池州市');
INSERT INTO `regional` VALUES (3418, 34, '宣城市');
INSERT INTO `regional` VALUES (3501, 35, '福州市');
INSERT INTO `regional` VALUES (3502, 35, '厦门市');
INSERT INTO `regional` VALUES (3503, 35, '莆田市');
INSERT INTO `regional` VALUES (3504, 35, '三明市');
INSERT INTO `regional` VALUES (3505, 35, '泉州市');
INSERT INTO `regional` VALUES (3506, 35, '漳州市');
INSERT INTO `regional` VALUES (3507, 35, '南平市');
INSERT INTO `regional` VALUES (3508, 35, '龙岩市');
INSERT INTO `regional` VALUES (3509, 35, '宁德市');
INSERT INTO `regional` VALUES (3601, 36, '南昌市');
INSERT INTO `regional` VALUES (3602, 36, '景德镇市');
INSERT INTO `regional` VALUES (3603, 36, '萍乡市');
INSERT INTO `regional` VALUES (3604, 36, '九江市');
INSERT INTO `regional` VALUES (3605, 36, '新余市');
INSERT INTO `regional` VALUES (3606, 36, '鹰潭市');
INSERT INTO `regional` VALUES (3607, 36, '赣州市');
INSERT INTO `regional` VALUES (3608, 36, '吉安市');
INSERT INTO `regional` VALUES (3609, 36, '宜春市');
INSERT INTO `regional` VALUES (3610, 36, '抚州市');
INSERT INTO `regional` VALUES (3611, 36, '上饶市');
INSERT INTO `regional` VALUES (3701, 37, '济南市');
INSERT INTO `regional` VALUES (3702, 37, '青岛市');
INSERT INTO `regional` VALUES (3703, 37, '淄博市');
INSERT INTO `regional` VALUES (3704, 37, '枣庄市');
INSERT INTO `regional` VALUES (3705, 37, '东营市');
INSERT INTO `regional` VALUES (3706, 37, '烟台市');
INSERT INTO `regional` VALUES (3707, 37, '潍坊市');
INSERT INTO `regional` VALUES (3708, 37, '济宁市');
INSERT INTO `regional` VALUES (3709, 37, '泰安市');
INSERT INTO `regional` VALUES (3710, 37, '威海市');
INSERT INTO `regional` VALUES (3711, 37, '日照市');
INSERT INTO `regional` VALUES (3712, 37, '莱芜市');
INSERT INTO `regional` VALUES (3713, 37, '临沂市');
INSERT INTO `regional` VALUES (3714, 37, '德州市');
INSERT INTO `regional` VALUES (3715, 37, '聊城市');
INSERT INTO `regional` VALUES (3716, 37, '滨州市');
INSERT INTO `regional` VALUES (3717, 37, '菏泽市');
INSERT INTO `regional` VALUES (4101, 41, '郑州市');
INSERT INTO `regional` VALUES (4102, 41, '开封市');
INSERT INTO `regional` VALUES (4103, 41, '洛阳市');
INSERT INTO `regional` VALUES (4104, 41, '平顶山市');
INSERT INTO `regional` VALUES (4105, 41, '安阳市');
INSERT INTO `regional` VALUES (4106, 41, '鹤壁市');
INSERT INTO `regional` VALUES (4107, 41, '新乡市');
INSERT INTO `regional` VALUES (4108, 41, '焦作市');
INSERT INTO `regional` VALUES (4109, 41, '濮阳市');
INSERT INTO `regional` VALUES (4110, 41, '许昌市');
INSERT INTO `regional` VALUES (4111, 41, '漯河市');
INSERT INTO `regional` VALUES (4112, 41, '三门峡市');
INSERT INTO `regional` VALUES (4113, 41, '南阳市');
INSERT INTO `regional` VALUES (4114, 41, '商丘市');
INSERT INTO `regional` VALUES (4115, 41, '信阳市');
INSERT INTO `regional` VALUES (4116, 41, '周口市');
INSERT INTO `regional` VALUES (4117, 41, '驻马店市');
INSERT INTO `regional` VALUES (4190, 41, '省直辖县级行政区划');
INSERT INTO `regional` VALUES (4201, 42, '武汉市');
INSERT INTO `regional` VALUES (4202, 42, '黄石市');
INSERT INTO `regional` VALUES (4203, 42, '十堰市');
INSERT INTO `regional` VALUES (4205, 42, '宜昌市');
INSERT INTO `regional` VALUES (4206, 42, '襄阳市');
INSERT INTO `regional` VALUES (4207, 42, '鄂州市');
INSERT INTO `regional` VALUES (4208, 42, '荆门市');
INSERT INTO `regional` VALUES (4209, 42, '孝感市');
INSERT INTO `regional` VALUES (4210, 42, '荆州市');
INSERT INTO `regional` VALUES (4211, 42, '黄冈市');
INSERT INTO `regional` VALUES (4212, 42, '咸宁市');
INSERT INTO `regional` VALUES (4213, 42, '随州市');
INSERT INTO `regional` VALUES (4228, 42, '恩施土家族苗族自治州');
INSERT INTO `regional` VALUES (4290, 42, '省直辖县级行政区划');
INSERT INTO `regional` VALUES (4301, 43, '长沙市');
INSERT INTO `regional` VALUES (4302, 43, '株洲市');
INSERT INTO `regional` VALUES (4303, 43, '湘潭市');
INSERT INTO `regional` VALUES (4304, 43, '衡阳市');
INSERT INTO `regional` VALUES (4305, 43, '邵阳市');
INSERT INTO `regional` VALUES (4306, 43, '岳阳市');
INSERT INTO `regional` VALUES (4307, 43, '常德市');
INSERT INTO `regional` VALUES (4308, 43, '张家界市');
INSERT INTO `regional` VALUES (4309, 43, '益阳市');
INSERT INTO `regional` VALUES (4310, 43, '郴州市');
INSERT INTO `regional` VALUES (4311, 43, '永州市');
INSERT INTO `regional` VALUES (4312, 43, '怀化市');
INSERT INTO `regional` VALUES (4313, 43, '娄底市');
INSERT INTO `regional` VALUES (4331, 43, '湘西土家族苗族自治州');
INSERT INTO `regional` VALUES (4401, 44, '广州市');
INSERT INTO `regional` VALUES (4402, 44, '韶关市');
INSERT INTO `regional` VALUES (4403, 44, '深圳市');
INSERT INTO `regional` VALUES (4404, 44, '珠海市');
INSERT INTO `regional` VALUES (4405, 44, '汕头市');
INSERT INTO `regional` VALUES (4406, 44, '佛山市');
INSERT INTO `regional` VALUES (4407, 44, '江门市');
INSERT INTO `regional` VALUES (4408, 44, '湛江市');
INSERT INTO `regional` VALUES (4409, 44, '茂名市');
INSERT INTO `regional` VALUES (4412, 44, '肇庆市');
INSERT INTO `regional` VALUES (4413, 44, '惠州市');
INSERT INTO `regional` VALUES (4414, 44, '梅州市');
INSERT INTO `regional` VALUES (4415, 44, '汕尾市');
INSERT INTO `regional` VALUES (4416, 44, '河源市');
INSERT INTO `regional` VALUES (4417, 44, '阳江市');
INSERT INTO `regional` VALUES (4418, 44, '清远市');
INSERT INTO `regional` VALUES (4419, 44, '东莞市');
INSERT INTO `regional` VALUES (4420, 44, '中山市');
INSERT INTO `regional` VALUES (4451, 44, '潮州市');
INSERT INTO `regional` VALUES (4452, 44, '揭阳市');
INSERT INTO `regional` VALUES (4453, 44, '云浮市');
INSERT INTO `regional` VALUES (4501, 45, '南宁市');
INSERT INTO `regional` VALUES (4502, 45, '柳州市');
INSERT INTO `regional` VALUES (4503, 45, '桂林市');
INSERT INTO `regional` VALUES (4504, 45, '梧州市');
INSERT INTO `regional` VALUES (4505, 45, '北海市');
INSERT INTO `regional` VALUES (4506, 45, '防城港市');
INSERT INTO `regional` VALUES (4507, 45, '钦州市');
INSERT INTO `regional` VALUES (4508, 45, '贵港市');
INSERT INTO `regional` VALUES (4509, 45, '玉林市');
INSERT INTO `regional` VALUES (4510, 45, '百色市');
INSERT INTO `regional` VALUES (4511, 45, '贺州市');
INSERT INTO `regional` VALUES (4512, 45, '河池市');
INSERT INTO `regional` VALUES (4513, 45, '来宾市');
INSERT INTO `regional` VALUES (4514, 45, '崇左市');
INSERT INTO `regional` VALUES (4601, 46, '海口市');
INSERT INTO `regional` VALUES (4602, 46, '三亚市');
INSERT INTO `regional` VALUES (4603, 46, '三沙市');
INSERT INTO `regional` VALUES (4604, 46, '儋州市');
INSERT INTO `regional` VALUES (4690, 46, '省直辖县级行政区划');
INSERT INTO `regional` VALUES (5001, 50, '重庆市');
INSERT INTO `regional` VALUES (5101, 51, '成都市');
INSERT INTO `regional` VALUES (5103, 51, '自贡市');
INSERT INTO `regional` VALUES (5104, 51, '攀枝花市');
INSERT INTO `regional` VALUES (5105, 51, '泸州市');
INSERT INTO `regional` VALUES (5106, 51, '德阳市');
INSERT INTO `regional` VALUES (5107, 51, '绵阳市');
INSERT INTO `regional` VALUES (5108, 51, '广元市');
INSERT INTO `regional` VALUES (5109, 51, '遂宁市');
INSERT INTO `regional` VALUES (5110, 51, '内江市');
INSERT INTO `regional` VALUES (5111, 51, '乐山市');
INSERT INTO `regional` VALUES (5113, 51, '南充市');
INSERT INTO `regional` VALUES (5114, 51, '眉山市');
INSERT INTO `regional` VALUES (5115, 51, '宜宾市');
INSERT INTO `regional` VALUES (5116, 51, '广安市');
INSERT INTO `regional` VALUES (5117, 51, '达州市');
INSERT INTO `regional` VALUES (5118, 51, '雅安市');
INSERT INTO `regional` VALUES (5119, 51, '巴中市');
INSERT INTO `regional` VALUES (5120, 51, '资阳市');
INSERT INTO `regional` VALUES (5132, 51, '阿坝藏族羌族自治州');
INSERT INTO `regional` VALUES (5133, 51, '甘孜藏族自治州');
INSERT INTO `regional` VALUES (5134, 51, '凉山彝族自治州');
INSERT INTO `regional` VALUES (5201, 52, '贵阳市');
INSERT INTO `regional` VALUES (5202, 52, '六盘水市');
INSERT INTO `regional` VALUES (5203, 52, '遵义市');
INSERT INTO `regional` VALUES (5204, 52, '安顺市');
INSERT INTO `regional` VALUES (5205, 52, '毕节市');
INSERT INTO `regional` VALUES (5206, 52, '铜仁市');
INSERT INTO `regional` VALUES (5223, 52, '黔西南布依族苗族自治州');
INSERT INTO `regional` VALUES (5226, 52, '黔东南苗族侗族自治州');
INSERT INTO `regional` VALUES (5227, 52, '黔南布依族苗族自治州');
INSERT INTO `regional` VALUES (5301, 53, '昆明市');
INSERT INTO `regional` VALUES (5303, 53, '曲靖市');
INSERT INTO `regional` VALUES (5304, 53, '玉溪市');
INSERT INTO `regional` VALUES (5305, 53, '保山市');
INSERT INTO `regional` VALUES (5306, 53, '昭通市');
INSERT INTO `regional` VALUES (5307, 53, '丽江市');
INSERT INTO `regional` VALUES (5308, 53, '普洱市');
INSERT INTO `regional` VALUES (5309, 53, '临沧市');
INSERT INTO `regional` VALUES (5323, 53, '楚雄彝族自治州');
INSERT INTO `regional` VALUES (5325, 53, '红河哈尼族彝族自治州');
INSERT INTO `regional` VALUES (5326, 53, '文山壮族苗族自治州');
INSERT INTO `regional` VALUES (5328, 53, '西双版纳傣族自治州');
INSERT INTO `regional` VALUES (5329, 53, '大理白族自治州');
INSERT INTO `regional` VALUES (5331, 53, '德宏傣族景颇族自治州');
INSERT INTO `regional` VALUES (5333, 53, '怒江傈僳族自治州');
INSERT INTO `regional` VALUES (5334, 53, '迪庆藏族自治州');
INSERT INTO `regional` VALUES (5401, 54, '拉萨市');
INSERT INTO `regional` VALUES (5402, 54, '日喀则市');
INSERT INTO `regional` VALUES (5403, 54, '昌都市');
INSERT INTO `regional` VALUES (5404, 54, '林芝市');
INSERT INTO `regional` VALUES (5405, 54, '山南市');
INSERT INTO `regional` VALUES (5424, 54, '那曲地区');
INSERT INTO `regional` VALUES (5425, 54, '阿里地区');
INSERT INTO `regional` VALUES (6101, 61, '西安市');
INSERT INTO `regional` VALUES (6102, 61, '铜川市');
INSERT INTO `regional` VALUES (6103, 61, '宝鸡市');
INSERT INTO `regional` VALUES (6104, 61, '咸阳市');
INSERT INTO `regional` VALUES (6105, 61, '渭南市');
INSERT INTO `regional` VALUES (6106, 61, '延安市');
INSERT INTO `regional` VALUES (6107, 61, '汉中市');
INSERT INTO `regional` VALUES (6108, 61, '榆林市');
INSERT INTO `regional` VALUES (6109, 61, '安康市');
INSERT INTO `regional` VALUES (6110, 61, '商洛市');
INSERT INTO `regional` VALUES (6201, 62, '兰州市');
INSERT INTO `regional` VALUES (6202, 62, '嘉峪关市');
INSERT INTO `regional` VALUES (6203, 62, '金昌市');
INSERT INTO `regional` VALUES (6204, 62, '白银市');
INSERT INTO `regional` VALUES (6205, 62, '天水市');
INSERT INTO `regional` VALUES (6206, 62, '武威市');
INSERT INTO `regional` VALUES (6207, 62, '张掖市');
INSERT INTO `regional` VALUES (6208, 62, '平凉市');
INSERT INTO `regional` VALUES (6209, 62, '酒泉市');
INSERT INTO `regional` VALUES (6210, 62, '庆阳市');
INSERT INTO `regional` VALUES (6211, 62, '定西市');
INSERT INTO `regional` VALUES (6212, 62, '陇南市');
INSERT INTO `regional` VALUES (6229, 62, '临夏回族自治州');
INSERT INTO `regional` VALUES (6230, 62, '甘南藏族自治州');
INSERT INTO `regional` VALUES (6301, 63, '西宁市');
INSERT INTO `regional` VALUES (6302, 63, '海东市');
INSERT INTO `regional` VALUES (6322, 63, '海北藏族自治州');
INSERT INTO `regional` VALUES (6323, 63, '黄南藏族自治州');
INSERT INTO `regional` VALUES (6325, 63, '海南藏族自治州');
INSERT INTO `regional` VALUES (6326, 63, '果洛藏族自治州');
INSERT INTO `regional` VALUES (6327, 63, '玉树藏族自治州');
INSERT INTO `regional` VALUES (6328, 63, '海西蒙古族藏族自治州');
INSERT INTO `regional` VALUES (6401, 64, '银川市');
INSERT INTO `regional` VALUES (6402, 64, '石嘴山市');
INSERT INTO `regional` VALUES (6403, 64, '吴忠市');
INSERT INTO `regional` VALUES (6404, 64, '固原市');
INSERT INTO `regional` VALUES (6405, 64, '中卫市');
INSERT INTO `regional` VALUES (6501, 65, '乌鲁木齐市');
INSERT INTO `regional` VALUES (6502, 65, '克拉玛依市');
INSERT INTO `regional` VALUES (6504, 65, '吐鲁番市');
INSERT INTO `regional` VALUES (6505, 65, '哈密市');
INSERT INTO `regional` VALUES (6523, 65, '昌吉回族自治州');
INSERT INTO `regional` VALUES (6527, 65, '博尔塔拉蒙古自治州');
INSERT INTO `regional` VALUES (6528, 65, '巴音郭楞蒙古自治州');
INSERT INTO `regional` VALUES (6529, 65, '阿克苏地区');
INSERT INTO `regional` VALUES (6530, 65, '克孜勒苏柯尔克孜自治州');
INSERT INTO `regional` VALUES (6531, 65, '喀什地区');
INSERT INTO `regional` VALUES (6532, 65, '和田地区');
INSERT INTO `regional` VALUES (6540, 65, '伊犁哈萨克自治州');
INSERT INTO `regional` VALUES (6542, 65, '塔城地区');
INSERT INTO `regional` VALUES (6543, 65, '阿勒泰地区');
INSERT INTO `regional` VALUES (6590, 65, '自治区直辖县级行政区划');
COMMIT;

-- ----------------------------
-- Table structure for regional_manager_to_regional
-- ----------------------------
DROP TABLE IF EXISTS `regional_manager_to_regional`;
CREATE TABLE `regional_manager_to_regional` (
  `RMTP_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '标识ID',
  `RMTP_U_ID` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `RMTP_R_CODE` bigint(20) DEFAULT NULL COMMENT '管辖区域代码',
  `RMTP_PROVINCE` varchar(255) DEFAULT NULL COMMENT '省份名称',
  `RMTP_CITY` varchar(255) DEFAULT NULL COMMENT '城市名称',
  `RMTP_IS_DELETED` int(10) DEFAULT NULL COMMENT '是否删除',
  `RMTP_CREATED_TIME` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`RMTP_ID`) USING BTREE,
  KEY `KP_RegionalManager_User` (`RMTP_U_ID`) USING BTREE,
  KEY `KP_RM_RL_ID` (`RMTP_R_CODE`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of regional_manager_to_regional
-- ----------------------------
BEGIN;
INSERT INTO `regional_manager_to_regional` VALUES (1, 3, 3201, '上海市', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (2, 3, NULL, '浙江省', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (3, 3, NULL, '福建省', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (4, 3, NULL, '安徽省', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (5, 3, NULL, '江西省', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (6, 3, NULL, '山东省', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (7, 3, NULL, '台湾省', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (8, 3, NULL, '香港特别行政区', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (9, 3, NULL, '澳门特别行政区', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (10, 3, 3607, '江苏省', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (11, 3, NULL, '湖北省', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (12, 3, NULL, '湖南省', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (13, 3, NULL, '河南省', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (14, 3, NULL, '宁夏回族自治区', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (15, 3, NULL, '新疆维吾尔自治区', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (16, 3, NULL, '青海省', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (17, 3, NULL, '陕西省', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (18, 3, NULL, '甘肃省', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (19, 3, NULL, '广东省', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (20, 3, NULL, '广西壮族自治区', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (21, 3, NULL, '海南省', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (22, 3, NULL, '四川省', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (23, 3, NULL, '云南省', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (24, 3, NULL, '贵州省', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (25, 3, NULL, '西藏自治区', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (26, 3, NULL, '重庆市', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (27, 3, NULL, '北京市', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (28, 3, NULL, '天津市', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (29, 3, NULL, '山西省', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (30, 3, NULL, '内蒙古自治区', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (31, 3, NULL, '辽宁省', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (32, 3, NULL, '吉林省', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (33, 3, NULL, '黑龙江省', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (34, 3, NULL, '河北省', '*', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (35, 3, NULL, '江苏省', '南京市', 0, '2019-08-28 19:27:54');
INSERT INTO `regional_manager_to_regional` VALUES (46, 3, NULL, '江苏省', '*', 0, '2020-07-10 20:41:19');
COMMIT;

-- ----------------------------
-- Table structure for resident_agency
-- ----------------------------
DROP TABLE IF EXISTS `resident_agency`;
CREATE TABLE `resident_agency` (
  `RA_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '入驻机构ID',
  `RA_EA_ID` bigint(20) DEFAULT NULL COMMENT '入驻的机构ID',
  `RA_EA_U_ID` bigint(20) DEFAULT NULL COMMENT '入驻机构的用户ID',
  PRIMARY KEY (`RA_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for resource
-- ----------------------------
DROP TABLE IF EXISTS `resource`;
CREATE TABLE `resource` (
  `R_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '众测资源和工具ID',
  `R_CODE` varchar(255) NOT NULL COMMENT '众测资源和工具CODE',
  `R_NAME` varchar(255) DEFAULT NULL COMMENT '众测资源和工具名称',
  `R_RT_CODE` varchar(255) DEFAULT NULL COMMENT '资源类型CODE',
  `R_QUANTITY` int(20) DEFAULT NULL COMMENT '资源数量',
  `R_PHOTO_URL` varchar(255) DEFAULT NULL COMMENT '资源图片',
  `R_DESCRIPTION` varchar(255) DEFAULT NULL COMMENT '资源描述',
  `R_SCENE` varchar(255) DEFAULT NULL COMMENT '使用场景',
  `R_UNIT_WORK` varchar(255) DEFAULT NULL COMMENT '所属单位',
  `R_STANDARD` varchar(255) DEFAULT NULL COMMENT '收费标准',
  `R_UNIT` varchar(255) DEFAULT NULL COMMENT '收费单位',
  `R_STATE` int(4) DEFAULT NULL COMMENT '资源状态',
  `R_DATE` timestamp NULL DEFAULT NULL COMMENT '注册日期',
  `R_PERSONNEL` varchar(255) DEFAULT NULL COMMENT '注册人员',
  `R_REMARKS` varchar(255) DEFAULT NULL COMMENT '其他说明',
  PRIMARY KEY (`R_ID`,`R_CODE`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of resource
-- ----------------------------
BEGIN;
INSERT INTO `resource` VALUES (5, 'CLOUDSERVERS', '云服务器', 'BASE', 10, 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/ApplicationType/%E4%BA%91%E6%9C%8D%E5%8A%A1%E5%99%A8.png', '云服务器', '一站式建站', '上海计算机软件技术开发中心', '100', '元/天', 2, '2020-06-03 10:59:50', NULL, '无');
INSERT INTO `resource` VALUES (6, 'CLOUDDESKTOP', '云桌面', 'BASE', 10, 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/ApplicationType/%E4%BA%91%E6%A1%8C%E9%9D%A2.png', '云桌面', '电子阅览室', '上海计算机软件技术开发中心', '100', '元/天', 2, '2020-06-04 10:59:57', NULL, '无');
INSERT INTO `resource` VALUES (7, 'WEBINSPECT', 'WebInspect', 'TOOL', 10, 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/ApplicationType/%E6%B5%8B%E8%AF%95%E5%B7%A5%E5%85%B7.png', '利用创新的评估技术检查Web服务', 'Web应用程序', '航天中认', '100', '元/天', 2, '2020-07-23 11:00:03', NULL, '无');
INSERT INTO `resource` VALUES (8, 'UNIFIED', 'Unified', 'TOOL', 10, 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/ApplicationType/%E6%B5%8B%E8%AF%95%E5%B7%A5%E5%85%B7.png', '自动化测试工具', '自动化测试', '航天中认', '100', '元/天', 2, '2020-06-25 11:00:07', NULL, '无');
INSERT INTO `resource` VALUES (9, 'FUNCTIONALTESTING', 'Functional Testing', 'TOOL', 10, 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/ApplicationType/%E6%B5%8B%E8%AF%95%E5%B7%A5%E5%85%B7.png', '功能测试工具', '功能测试', '航天中认', '100', '元/天', 2, '2020-07-07 11:00:10', NULL, '无');
INSERT INTO `resource` VALUES (10, 'LOADRUNNER', 'LoadRunner', 'TOOL', 10, 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/ApplicationType/%E6%B5%8B%E8%AF%95%E5%B7%A5%E5%85%B7.png', '性能测试工具', '性能测试', '航天中认', '100', '元/天', 2, '2020-07-09 11:00:23', NULL, '无');
INSERT INTO `resource` VALUES (11, 'APPSCAN', 'AppScan', 'TOOL', 10, 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/ApplicationType/%E6%B5%8B%E8%AF%95%E5%B7%A5%E5%85%B7.png', 'web安全扫描工具', '网站安全渗透测试', '航天中认', '100', '元/天', 2, '2020-07-07 11:00:27', NULL, '无');
INSERT INTO `resource` VALUES (12, 'ACUNETIX', 'Acunetix', 'TOOL', 10, 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/ApplicationType/%E6%B5%8B%E8%AF%95%E5%B7%A5%E5%85%B7.png', '网络漏洞扫描工具', 'web安全漏洞扫描', '航天中认', '100', '元/天', 2, '2020-07-08 11:00:31', NULL, '无');
INSERT INTO `resource` VALUES (13, 'TESTBED', 'TestBed', 'TOOL', 10, 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/ApplicationType/%E6%B5%8B%E8%AF%95%E5%B7%A5%E5%85%B7.png', '主机平台软件测试', '软件度量分析', '航天中认', '100', '元/天', 2, '2020-07-02 11:00:35', NULL, '无');
INSERT INTO `resource` VALUES (14, 'CPPTEST', 'CppTest', 'TOOL', 10, 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/ApplicationType/%E6%B5%8B%E8%AF%95%E5%B7%A5%E5%85%B7.png', 'C++ 单元测试框架', '单元测试', '航天中认', '100', '元/天', 2, '2020-07-03 11:00:39', NULL, '无');
INSERT INTO `resource` VALUES (15, 'TELECOMMUNICATION', 'Telecommunication', 'TOOL', 10, 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/ApplicationType/%E6%B5%8B%E8%AF%95%E5%B7%A5%E5%85%B7.png', '电信', '5G', '航天中认', '100', '元/天', 2, '2020-07-04 11:00:42', NULL, '无');
INSERT INTO `resource` VALUES (16, 'POWERAGREEMENT', 'PowerAgreement', 'TOOL', 10, 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/ApplicationType/%E6%B5%8B%E8%AF%95%E5%B7%A5%E5%85%B7.png', '协议', '协议', '航天中认', '100', '元/天', 2, '2020-07-15 11:00:48', NULL, '无');
COMMIT;

-- ----------------------------
-- Table structure for resource_type
-- ----------------------------
DROP TABLE IF EXISTS `resource_type`;
CREATE TABLE `resource_type` (
  `RT_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '资源类型ID',
  `RT_CODE` varchar(255) DEFAULT NULL COMMENT '资源类型CODE',
  `RT_NAME` varchar(255) DEFAULT NULL COMMENT '资源类型',
  PRIMARY KEY (`RT_ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of resource_type
-- ----------------------------
BEGIN;
INSERT INTO `resource_type` VALUES (1, 'TOOL', '工具资源');
INSERT INTO `resource_type` VALUES (2, 'EQUIPMENT', '设备资源');
INSERT INTO `resource_type` VALUES (3, 'ENVIRONMENT', '环境资源');
INSERT INTO `resource_type` VALUES (4, 'INFORMATION', '信息资源');
INSERT INTO `resource_type` VALUES (5, 'SERVICE', '服务资源');
INSERT INTO `resource_type` VALUES (6, 'OTHER', '其他资源');
INSERT INTO `resource_type` VALUES (7, 'BASE', '基础资源');
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `R_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色ID',
  `R_NAME` varchar(255) DEFAULT NULL COMMENT '角色名称',
  `R_CREATE_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`R_ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` VALUES (1, 'generalUser', '2019-07-26 14:30:21');
INSERT INTO `role` VALUES (2, 'evaluationAgency', '2019-07-26 14:30:51');
INSERT INTO `role` VALUES (3, 'RegionalManager', '2019-07-26 14:31:21');
INSERT INTO `role` VALUES (4, 'SystemAdministrator', '2019-07-26 14:31:32');
INSERT INTO `role` VALUES (5, 'enterpriseUser', '2019-08-20 15:37:35');
INSERT INTO `role` VALUES (6, 'evaluationUser', '2020-07-24 14:49:00');
INSERT INTO `role` VALUES (7, 'partyUser', '2020-07-24 14:49:01');
INSERT INTO `role` VALUES (8, 'partyAgency', '2020-07-24 14:49:02');
COMMIT;

-- ----------------------------
-- Table structure for role_to_permission
-- ----------------------------
DROP TABLE IF EXISTS `role_to_permission`;
CREATE TABLE `role_to_permission` (
  `RTP_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色权限编号',
  `RTP_R_ID` bigint(20) DEFAULT NULL COMMENT '角色ID',
  `RTP_P_ID` bigint(20) DEFAULT NULL COMMENT '权限ID',
  `RTP_CREATE_TIME` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`RTP_ID`) USING BTREE,
  KEY `KP_RTP_R_ID` (`RTP_R_ID`) USING BTREE,
  KEY `KP_RTP_P_ID` (`RTP_P_ID`) USING BTREE,
  CONSTRAINT `KP_RTP_P_ID` FOREIGN KEY (`RTP_P_ID`) REFERENCES `permission` (`P_ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `KP_RTP_R_ID` FOREIGN KEY (`RTP_R_ID`) REFERENCES `role` (`R_ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of role_to_permission
-- ----------------------------
BEGIN;
INSERT INTO `role_to_permission` VALUES (1, 1, 1, NULL);
INSERT INTO `role_to_permission` VALUES (3, 1, 2, NULL);
INSERT INTO `role_to_permission` VALUES (12, 1, 3, NULL);
INSERT INTO `role_to_permission` VALUES (13, 1, 4, NULL);
INSERT INTO `role_to_permission` VALUES (14, 1, 5, NULL);
INSERT INTO `role_to_permission` VALUES (15, 1, 6, NULL);
INSERT INTO `role_to_permission` VALUES (16, 1, 8, NULL);
INSERT INTO `role_to_permission` VALUES (17, 1, 11, NULL);
INSERT INTO `role_to_permission` VALUES (18, 1, 12, NULL);
INSERT INTO `role_to_permission` VALUES (19, 1, 15, NULL);
INSERT INTO `role_to_permission` VALUES (20, 1, 16, NULL);
INSERT INTO `role_to_permission` VALUES (21, 1, 17, NULL);
INSERT INTO `role_to_permission` VALUES (22, 1, 18, NULL);
INSERT INTO `role_to_permission` VALUES (23, 1, 19, NULL);
INSERT INTO `role_to_permission` VALUES (24, 1, 20, NULL);
INSERT INTO `role_to_permission` VALUES (25, 1, 21, NULL);
INSERT INTO `role_to_permission` VALUES (26, 2, 1, NULL);
INSERT INTO `role_to_permission` VALUES (27, 2, 2, NULL);
INSERT INTO `role_to_permission` VALUES (28, 2, 3, NULL);
INSERT INTO `role_to_permission` VALUES (29, 2, 4, NULL);
INSERT INTO `role_to_permission` VALUES (30, 2, 5, NULL);
INSERT INTO `role_to_permission` VALUES (31, 2, 6, NULL);
INSERT INTO `role_to_permission` VALUES (32, 2, 7, '2019-08-23 18:45:36');
INSERT INTO `role_to_permission` VALUES (33, 2, 8, NULL);
INSERT INTO `role_to_permission` VALUES (34, 2, 9, '2019-08-23 18:45:46');
INSERT INTO `role_to_permission` VALUES (35, 2, 10, '2019-08-23 18:45:51');
INSERT INTO `role_to_permission` VALUES (36, 2, 11, NULL);
INSERT INTO `role_to_permission` VALUES (37, 2, 12, NULL);
INSERT INTO `role_to_permission` VALUES (38, 2, 13, '2019-08-23 18:46:04');
INSERT INTO `role_to_permission` VALUES (39, 2, 14, '2019-08-23 18:46:06');
INSERT INTO `role_to_permission` VALUES (40, 2, 15, NULL);
INSERT INTO `role_to_permission` VALUES (41, 2, 16, NULL);
INSERT INTO `role_to_permission` VALUES (42, 2, 17, NULL);
INSERT INTO `role_to_permission` VALUES (43, 2, 18, NULL);
INSERT INTO `role_to_permission` VALUES (44, 2, 19, NULL);
INSERT INTO `role_to_permission` VALUES (45, 2, 20, NULL);
INSERT INTO `role_to_permission` VALUES (46, 2, 21, NULL);
INSERT INTO `role_to_permission` VALUES (47, 2, 22, '2019-08-23 18:46:21');
INSERT INTO `role_to_permission` VALUES (48, 3, 1, NULL);
INSERT INTO `role_to_permission` VALUES (49, 3, 2, NULL);
INSERT INTO `role_to_permission` VALUES (50, 3, 3, NULL);
INSERT INTO `role_to_permission` VALUES (51, 3, 4, NULL);
INSERT INTO `role_to_permission` VALUES (52, 3, 5, NULL);
INSERT INTO `role_to_permission` VALUES (53, 3, 6, NULL);
INSERT INTO `role_to_permission` VALUES (54, 3, 7, NULL);
INSERT INTO `role_to_permission` VALUES (55, 3, 8, NULL);
INSERT INTO `role_to_permission` VALUES (56, 3, 9, NULL);
INSERT INTO `role_to_permission` VALUES (57, 3, 10, '2019-08-23 18:46:59');
INSERT INTO `role_to_permission` VALUES (58, 3, 11, NULL);
INSERT INTO `role_to_permission` VALUES (59, 3, 12, NULL);
INSERT INTO `role_to_permission` VALUES (60, 3, 13, NULL);
INSERT INTO `role_to_permission` VALUES (61, 3, 14, NULL);
INSERT INTO `role_to_permission` VALUES (62, 3, 15, NULL);
INSERT INTO `role_to_permission` VALUES (63, 3, 16, NULL);
INSERT INTO `role_to_permission` VALUES (64, 3, 17, NULL);
INSERT INTO `role_to_permission` VALUES (65, 3, 18, NULL);
INSERT INTO `role_to_permission` VALUES (66, 3, 19, NULL);
INSERT INTO `role_to_permission` VALUES (67, 3, 20, NULL);
INSERT INTO `role_to_permission` VALUES (68, 3, 21, NULL);
INSERT INTO `role_to_permission` VALUES (69, 3, 22, '2019-08-23 18:47:21');
INSERT INTO `role_to_permission` VALUES (70, 4, 1, NULL);
INSERT INTO `role_to_permission` VALUES (71, 4, 2, NULL);
INSERT INTO `role_to_permission` VALUES (72, 4, 3, NULL);
INSERT INTO `role_to_permission` VALUES (73, 4, 4, NULL);
INSERT INTO `role_to_permission` VALUES (74, 4, 5, NULL);
INSERT INTO `role_to_permission` VALUES (75, 4, 6, NULL);
INSERT INTO `role_to_permission` VALUES (76, 4, 7, '2019-08-23 18:48:57');
INSERT INTO `role_to_permission` VALUES (77, 4, 8, NULL);
INSERT INTO `role_to_permission` VALUES (78, 4, 9, '2019-08-23 18:49:07');
INSERT INTO `role_to_permission` VALUES (79, 4, 10, NULL);
INSERT INTO `role_to_permission` VALUES (80, 4, 11, NULL);
INSERT INTO `role_to_permission` VALUES (81, 4, 12, NULL);
INSERT INTO `role_to_permission` VALUES (82, 4, 13, '2019-08-23 18:49:19');
INSERT INTO `role_to_permission` VALUES (83, 4, 14, '2019-08-23 18:49:23');
INSERT INTO `role_to_permission` VALUES (84, 4, 15, NULL);
INSERT INTO `role_to_permission` VALUES (85, 4, 16, NULL);
INSERT INTO `role_to_permission` VALUES (86, 4, 17, NULL);
INSERT INTO `role_to_permission` VALUES (87, 4, 18, NULL);
INSERT INTO `role_to_permission` VALUES (88, 4, 19, NULL);
INSERT INTO `role_to_permission` VALUES (89, 4, 20, NULL);
INSERT INTO `role_to_permission` VALUES (90, 4, 21, NULL);
INSERT INTO `role_to_permission` VALUES (91, 4, 22, '2019-08-23 18:49:32');
INSERT INTO `role_to_permission` VALUES (92, 5, 1, NULL);
INSERT INTO `role_to_permission` VALUES (93, 5, 2, NULL);
INSERT INTO `role_to_permission` VALUES (94, 5, 3, NULL);
INSERT INTO `role_to_permission` VALUES (95, 5, 4, NULL);
INSERT INTO `role_to_permission` VALUES (96, 5, 5, NULL);
INSERT INTO `role_to_permission` VALUES (97, 5, 6, NULL);
INSERT INTO `role_to_permission` VALUES (98, 5, 7, NULL);
INSERT INTO `role_to_permission` VALUES (99, 5, 8, NULL);
INSERT INTO `role_to_permission` VALUES (100, 5, 9, NULL);
INSERT INTO `role_to_permission` VALUES (101, 5, 10, NULL);
INSERT INTO `role_to_permission` VALUES (102, 5, 11, NULL);
INSERT INTO `role_to_permission` VALUES (103, 5, 12, NULL);
INSERT INTO `role_to_permission` VALUES (104, 5, 13, NULL);
INSERT INTO `role_to_permission` VALUES (105, 5, 14, NULL);
INSERT INTO `role_to_permission` VALUES (106, 5, 15, NULL);
INSERT INTO `role_to_permission` VALUES (107, 5, 16, NULL);
INSERT INTO `role_to_permission` VALUES (108, 5, 17, NULL);
INSERT INTO `role_to_permission` VALUES (109, 5, 18, NULL);
INSERT INTO `role_to_permission` VALUES (110, 5, 19, NULL);
INSERT INTO `role_to_permission` VALUES (111, 5, 20, NULL);
INSERT INTO `role_to_permission` VALUES (112, 5, 21, NULL);
INSERT INTO `role_to_permission` VALUES (113, 5, 22, NULL);
COMMIT;

-- ----------------------------
-- Table structure for system_administrator_to_user
-- ----------------------------
DROP TABLE IF EXISTS `system_administrator_to_user`;
CREATE TABLE `system_administrator_to_user` (
  `SATU_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '系统管理员ID',
  `SATU_U_ID` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `SATU_IS_DELETED` int(10) DEFAULT NULL COMMENT '是否删除',
  `SATU_CREATE_TIME` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`SATU_ID`) USING BTREE,
  KEY `KP_SystemAdministrator_User` (`SATU_U_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for task_to_user
-- ----------------------------
DROP TABLE IF EXISTS `task_to_user`;
CREATE TABLE `task_to_user` (
  `TTU_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '任务人员对应ID',
  `TTU_CTT_CODE` varchar(255) DEFAULT NULL COMMENT '众包任务标识',
  `TTU_U_ID` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `TTU_QUOTED_PRICE` double(10,2) DEFAULT NULL COMMENT '任务报价',
  `TTU_HAS_REPORT` int(10) DEFAULT '0' COMMENT '用户是否提交报告 0-未提交 1-已提交',
  `TTU_COMMIT_REPORT_TIME` timestamp NULL DEFAULT NULL COMMENT '提交报告时间',
  `TTU_DISTRIBUTION_TYPE` bigint(20) DEFAULT '2' COMMENT '任务分配方式 0-定向 2-广场',
  `TTU_IS_ACCEPTED` int(10) DEFAULT '1' COMMENT '是否接收 0-未接收 1-接收',
  `TTU_ACCEPT_TIME` timestamp NULL DEFAULT NULL COMMENT '用户接收任务时的时间',
  `TTU_IS_COMMITTED` int(10) DEFAULT NULL COMMENT '是否提交任务',
  `TTU_COMMIT_TASK_TIME` timestamp NULL DEFAULT NULL COMMENT '提交任务时间',
  PRIMARY KEY (`TTU_ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for technical_articles
-- ----------------------------
DROP TABLE IF EXISTS `technical_articles`;
CREATE TABLE `technical_articles` (
  `TA_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '文章ID',
  `TA_TITLE` varchar(255) DEFAULT NULL COMMENT '文章标题',
  `TA_PHOTO_URL` varchar(255) DEFAULT NULL COMMENT '文章图片',
  `TA_ARTICLES_URL` varchar(255) DEFAULT NULL COMMENT '文章',
  `TA_AUTHOR` varchar(255) DEFAULT NULL COMMENT '作者',
  `TA_SOURCE` varchar(255) DEFAULT NULL COMMENT '来源',
  `TA_READING` int(20) DEFAULT NULL COMMENT '阅读量',
  `TA_CREATE_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`TA_ID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of technical_articles
-- ----------------------------
BEGIN;
INSERT INTO `technical_articles` VALUES (1, '基于警方的报告生成自动驾驶汽车的有效测试用例', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/TechnicalArticles/a1d95c351f9542cbb620950f63b5169a.jpg', 'https://www.toutiao.com/i6838597387783504388/', '慕测科技', '今日头条', 208, '2020-06-01 17:25:46');
INSERT INTO `technical_articles` VALUES (2, '机器学习模型的黑盒公平性测试', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/TechnicalArticles/69b35a16fb5a475b92d6afb864fc2ec9.jpg', 'https://www.toutiao.com/i6838916607381602828/', '慕测科技', '今日头条', 306, '2020-06-28 17:26:19');
INSERT INTO `technical_articles` VALUES (3, '通过条件化（降低方差）来提高 DNN 的测试效率', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/TechnicalArticles/03f4efae7fd3496ebdacb2787c80df41.jpg', 'https://www.toutiao.com/i6838612069097406990/', '慕测科技', '今日头条', 402, '2020-06-02 17:26:21');
INSERT INTO `technical_articles` VALUES (4, 'DeepStellar: 深度学习系统基于模型的定量分析', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/TechnicalArticles/20da7dc35dcc4e019e1b071e67b30c78.jpg', 'https://www.toutiao.com/i6838604991809192451/', '慕测科技', '今日头条', 201, '2020-06-28 17:26:23');
INSERT INTO `technical_articles` VALUES (5, 'DeepRoad：基于GAN的自主驾驶系统变形测试与输入验证框架', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/TechnicalArticles/ebaca9f9f80b44c59fcd9e8eb6753fec.jpg', 'https://www.toutiao.com/i6837106395981021709/', '慕测科技', '今日头条', 502, '2020-06-28 17:26:26');
INSERT INTO `technical_articles` VALUES (6, '深度神经网络的concolic测试', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/TechnicalArticles/ca5481ff6844425c98bfd592c5093c85.jpg', 'https://www.toutiao.com/i6837103641858408974/', '慕测科技', '今日头条', 610, '2020-06-28 17:26:28');
INSERT INTO `technical_articles` VALUES (7, 'MODE：基于状态差分分析和输入选择的自动化神经网络模型调试', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/TechnicalArticles/cf54af333c6543e8ad7be4622d735cea.jpg', 'https://www.toutiao.com/i6837093424429007363/', '慕测科技', '今日头条', 709, '2020-06-28 17:26:30');
INSERT INTO `technical_articles` VALUES (8, '自动化定向公平性测试', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/TechnicalArticles/9d2fbd37e08b462aa6d7335efc41a18f.jpg', 'https://www.toutiao.com/i6837092291136455171/', '慕测科技', '今日头条', 524, '2020-06-28 17:26:32');
INSERT INTO `technical_articles` VALUES (9, '跨平台描述深度学习开发和部署的实证研究', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/TechnicalArticles/f09b5db8a113490e8885f932df6208db.jpg', 'https://www.toutiao.com/i6837090967011459596/', '慕测科技', '今日头条', 904, '2020-06-28 17:26:34');
INSERT INTO `technical_articles` VALUES (10, 'Apricot:一个修复深度学习模型的权重自调整方法', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/TechnicalArticles/850aa202c7754163afd757356ed76454.jpg', 'https://www.toutiao.com/i6837089781470462476/', '慕测科技', '今日头条', 574, '2020-06-28 17:26:36');
INSERT INTO `technical_articles` VALUES (11, '经验论文：自动驾驶控制应用中基于搜索的测试', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/TechnicalArticles/077e0cd470c7453a8adbf3728c286ace.jpg', 'https://www.toutiao.com/i6837087181383664142/', '慕测科技', '今日头条', 325, '2020-06-28 17:26:39');
INSERT INTO `technical_articles` VALUES (12, '深度学习类型推断', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/TechnicalArticles/e18fdce1ba254cb29c64432ac12f88b7.jpg', 'https://www.toutiao.com/i6835989932821971468/', '慕测科技', '今日头条', 92, '2020-06-03 13:45:13');
INSERT INTO `technical_articles` VALUES (13, '测试深度学习库中的Oracle近似研究', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/TechnicalArticles/406f5db9f34e4be6930ff7b22f0b989e.jpg', 'https://www.toutiao.com/i6835989235791561229/', '慕测科技', '今日头条', 108, '2020-06-18 13:49:39');
INSERT INTO `technical_articles` VALUES (14, '使用多对象搜索测试自动驾驶汽车的特征交互故障', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/TechnicalArticles/e1c2f664de6a43f5a1a5ee8889d3223e.jpg', 'https://www.toutiao.com/i6835636822777790983/', '慕测科技', '今日头条', 106, '2020-06-17 13:50:38');
INSERT INTO `technical_articles` VALUES (15, '利用蜕变测试识别机器学习图像分类器实现上的错误', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/TechnicalArticles/3f308809241e42a78cc8e6f812eaf00f.jpg', 'https://www.toutiao.com/i6841207552961675779/', '慕测科技', '今日头条', 236, '2020-06-10 13:52:30');
INSERT INTO `technical_articles` VALUES (16, '基于搜索的测试和基于机器学习的异常检测系统的改进', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/TechnicalArticles/053cf619bf8242f3aa61ef64b799fb87.jpg', 'https://www.toutiao.com/i6841206279134773772/', '慕测科技', '今日头条', 323, '2020-06-18 13:53:55');
INSERT INTO `technical_articles` VALUES (17, 'LAMP：通过导数计算的基于图的机器学习算法的数据来源', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/TechnicalArticles/4560633674d34b06b1c28b42d96fffa0.jpg', 'https://www.toutiao.com/i6841205197113393668/', '慕测科技', '今日头条', 104, '2020-06-25 13:55:30');
INSERT INTO `technical_articles` VALUES (18, '深度学习网络是对源代码进行建模的最好方法吗？', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/TechnicalArticles/fe7d96003dcd4ecea9dd87547e25a7ad.jpg', 'https://www.toutiao.com/i6841203086229242375/', '慕测科技', '今日头条', 109, '2020-06-25 13:57:02');
INSERT INTO `technical_articles` VALUES (19, 'ARTINALI：网络物理系统安全的动态不变检测', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/TechnicalArticles/8e04b377fa8541438e0334be8aee00c0.jpg', 'https://www.toutiao.com/i6841202086114230788/', '慕测科技', '今日头条', 108, '2020-06-03 13:58:06');
INSERT INTO `technical_articles` VALUES (20, '易如反掌：深度学习的个案研究', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/TechnicalArticles/e9c67a47bb06469b88ac7c8cdecd0c3a.jpg', 'https://www.toutiao.com/i6841200295473578500/', '慕测科技', '今日头条', 58, '2020-06-17 13:58:47');
INSERT INTO `technical_articles` VALUES (21, '学习指导的用于网络物理系统防御的网络模糊测试', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/TechnicalArticles/c5cede90c94d4e6d8546b1be0bf0cbde.jpg', 'https://www.toutiao.com/i6841198277258379788/', '慕测科技', '今日头条', 246, '2020-06-26 14:00:37');
INSERT INTO `technical_articles` VALUES (22, 'Code Vectors:通过嵌入式抽象符号迹线理解程序', 'https://mooctest-crowd-service.oss-cn-hangzhou.aliyuncs.com/TechnicalArticles/5ab6770544964feeab3f35194ebf2fce.jpg', 'https://www.toutiao.com/i6838918620521693709/', '慕测科技', '今日头条', 265, '2020-07-02 16:25:57');
INSERT INTO `technical_articles` VALUES (23, '统信软件产品手册', 'http://third-part-tool.oss-cn-shanghai.aliyuncs.com/%E4%BC%97%E6%B5%8B/knowledge/image/%E7%BB%9F%E4%BF%A1%E8%BD%AF%E4%BB%B6%E4%BA%A7%E5%93%81%E6%89%8B%E5%86%8C.png', 'http://third-part-tool.oss-cn-shanghai.aliyuncs.com/%E4%BC%97%E6%B5%8B/knowledge/%E7%BB%9F%E4%BF%A1%E8%BD%AF%E4%BB%B6%E4%BA%A7%E5%93%81%E6%89%8B%E5%86%8C.pdf', '统信软件', '统信软件', 10, '2021-04-20 12:27:24');
INSERT INTO `technical_articles` VALUES (24, '2020信创产业独角兽100强', 'http://third-part-tool.oss-cn-shanghai.aliyuncs.com/%E4%BC%97%E6%B5%8B/knowledge/image/2020%E4%BF%A1%E5%88%9B%E4%BA%A7%E4%B8%9A%E7%8B%AC%E8%A7%92%E5%85%BD100%E5%BC%BA.png', 'http://third-part-tool.oss-cn-shanghai.aliyuncs.com/%E4%BC%97%E6%B5%8B/knowledge/2020%E4%BF%A1%E5%88%9B%E4%BA%A7%E4%B8%9A%E7%8B%AC%E8%A7%92%E5%85%BD100%E5%BC%BA.pdf', '中国科学院', '互联网周刊', 10, '2021-04-20 12:28:24');
INSERT INTO `technical_articles` VALUES (25, '“信创”研究框架', 'http://third-part-tool.oss-cn-shanghai.aliyuncs.com/%E4%BC%97%E6%B5%8B/knowledge/image/%E2%80%9C%E4%BF%A1%E5%88%9B%E2%80%9D%E7%A0%94%E7%A9%B6%E6%A1%86%E6%9E%B6.png', 'http://third-part-tool.oss-cn-shanghai.aliyuncs.com/%E4%BC%97%E6%B5%8B/knowledge/%E2%80%9C%E4%BF%A1%E5%88%9B%E2%80%9D%E7%A0%94%E7%A9%B6%E6%A1%86%E6%9E%B6.pdf', '华泰证券', '华泰证券', 11, '2021-04-20 12:29:21');
INSERT INTO `technical_articles` VALUES (26, '中国信创产业发展白皮书（2021）', 'http://third-part-tool.oss-cn-shanghai.aliyuncs.com/%E4%BC%97%E6%B5%8B/knowledge/image/%E4%B8%AD%E5%9B%BD%E4%BF%A1%E5%88%9B%E4%BA%A7%E4%B8%9A%E5%8F%91%E5%B1%95%E7%99%BD%E7%9A%AE%E4%B9%A6%EF%BC%882021%EF%BC%89.png', 'http://third-part-tool.oss-cn-shanghai.aliyuncs.com/%E4%BC%97%E6%B5%8B/knowledge/%E4%B8%AD%E5%9B%BD%E4%BF%A1%E5%88%9B%E4%BA%A7%E4%B8%9A%E5%8F%91%E5%B1%95%E7%99%BD%E7%9A%AE%E4%B9%A6%EF%BC%882021%EF%BC%89.pdf', '中国电子学会', '中国电子学会', 10, '2021-04-20 12:30:24');
INSERT INTO `technical_articles` VALUES (27, '聚焦信创发展，解析行业应用', 'http://third-part-tool.oss-cn-shanghai.aliyuncs.com/%E4%BC%97%E6%B5%8B/knowledge/image/%E8%81%9A%E7%84%A6%E4%BF%A1%E5%88%9B%E5%8F%91%E5%B1%95%EF%BC%8C%E8%A7%A3%E6%9E%90%E8%A1%8C%E4%B8%9A%E5%BA%94%E7%94%A8.png', 'http://third-part-tool.oss-cn-shanghai.aliyuncs.com/%E4%BC%97%E6%B5%8B/knowledge/%E8%81%9A%E7%84%A6%E4%BF%A1%E5%88%9B%E5%8F%91%E5%B1%95%EF%BC%8C%E8%A7%A3%E6%9E%90%E8%A1%8C%E4%B8%9A%E5%BA%94%E7%94%A8.pdf', '亿欧', '亿欧智库', 10, '2021-04-20 12:14:08');
COMMIT;

-- ----------------------------
-- Table structure for test_type
-- ----------------------------
DROP TABLE IF EXISTS `test_type`;
CREATE TABLE `test_type` (
  `TT_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '测试类型ID',
  `TT_CODE` varchar(255) NOT NULL COMMENT '测试类型CODE',
  `TT_NAME` varchar(255) DEFAULT NULL COMMENT '测试类型名称',
  `TT_INTRODUCTION` longtext COMMENT '测试类型说明',
  `TT_TYPE` int(2) DEFAULT NULL COMMENT '测试类型的跳转类型 0-无跳转 1-有跳转',
  `TT_URL` varchar(255) DEFAULT NULL COMMENT '跳转的url',
  PRIMARY KEY (`TT_ID`,`TT_CODE`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of test_type
-- ----------------------------
BEGIN;
INSERT INTO `test_type` VALUES (1, 'JKCS', '接口测试', '针对被测对象的内外部接口进行测试和联调，以验证接口的调用、数据的流转、数据处理效率等方面是否满足要求。', 0, NULL);
INSERT INTO `test_type` VALUES (2, 'JRXCE', '兼容性测试', '在共享相同的软硬件环境条件下，测试和验证被测对象是否能够与其他产品、系统、软件或组件正确交换信息和数据，是否会对其他产品正常运行造成影响或受到其他产品运行影响。', 0, NULL);
INSERT INTO `test_type` VALUES (3, 'KKXCS', '可靠性测试', '在指定条件下，测试和验证被测对象是否满足所要求的成熟性、可用性、容错性和易恢复性等方面的要求。', 0, NULL);
INSERT INTO `test_type` VALUES (5, 'GNCS', '功能测试', '在给定条件下，按照产品或系统需求规格说明书等相关技术文档的要求，从功能完备性、功能正确性和功能适合性等方面对被测对象进行测试，以验证和确认被测对象所实现的功能是否满足需求中的明确和隐含要求。', 0, NULL);
INSERT INTO `test_type` VALUES (6, 'XNCS', '性能测试', '在给定条件下，通过执行性能测试场景来验证和评估被测对象是否满足需求中的性能指标要求（如时间特性、资源利用性和容量等方面的技术指标要求）。', 0, NULL);
INSERT INTO `test_type` VALUES (8, 'YYXCS', '易用性测试', '在指定的使用周境中，测试和验证被测对象在可辨识性、易学性、易操作性、差错防御性和界面合适性等方面是否满足目标用户的需求和要求。', 0, NULL);
INSERT INTO `test_type` VALUES (15, 'DZCS', '定制测试', '结合客户的个性化测试需求，定制测试服务。', 0, NULL);
INSERT INTO `test_type` VALUES (16, 'WHX', '维护性', '安装卸载、软件升级等。', 0, NULL);
INSERT INTO `test_type` VALUES (17, 'MCZC', '慕测信创众测', '慕测信创众测', 1, NULL);
COMMIT;

-- ----------------------------
-- Table structure for tool
-- ----------------------------
DROP TABLE IF EXISTS `tool`;
CREATE TABLE `tool` (
  `T_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '工具ID',
  `T_CODE` varchar(255) NOT NULL COMMENT '工具CODE',
  `T_NAME` varchar(255) DEFAULT NULL COMMENT '工具名称',
  `T_DESCRIPTION` varchar(255) DEFAULT NULL COMMENT '工具简介',
  `T_PHOTO_URL` varchar(255) DEFAULT NULL COMMENT '工具图片',
  `T_OWNER` varchar(255) DEFAULT NULL COMMENT '工具承办方',
  `T_LINK_URL` varchar(255) DEFAULT NULL COMMENT '工具链接',
  `T_IS_DELETED` int(2) DEFAULT '0' COMMENT '工具是否删除 0-未删除 1-已删除',
  PRIMARY KEY (`T_ID`,`T_CODE`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tool
-- ----------------------------
BEGIN;
INSERT INTO `tool` VALUES (1, 'TOOL-0008', 'JMeter压力测试工具', 'pache JMeter是Apache组织开发的基于Java的压力测试工具。它可以用于测试静态和动态资源。JMeter 可以用于对服务器、网络或对象模拟巨大的负载，来自不同压力类别下测试它们的强度和分析整体性能。另外，JMeter能够对应用程序做功能/回归测试，通过创建带有断言的脚本来验证你的程序返回了你期望的结果。', '/var/www/Tool/JMeter.png', 'Apache', 'https://jmeter.apache.org/', 0);
INSERT INTO `tool` VALUES (2, 'TOOL-0007', 'Stress-ng测试工具', 'stress-ng会以各种可选的方式对计算机系统进行压力测试。它旨在执行计算机的各种物理子系统以及各种操作系统内核接口。还可以测量测试吞吐率;这对于观察不同操作系统版本或硬件类型的性能变化非常有用。', '/var/www/Tool/Stress-ng.png', 'ColinIanKing', 'https://github.com/ColinIanKing/stress-ng', 0);
INSERT INTO `tool` VALUES (3, 'TOOL-0005', 'Selenium WEB应用程序测试工具', 'Selenium是一个用于Web应用程序测试的工具。Selenium测试直接运行在浏览器中，就像真正的用户在操作一样。主要功能包括：测试与浏览器的兼容性，创建回归测试检验软件功能和用户需求。', '/var/www/Tool/Selenium.png', 'Apache', 'http://www.selenium.org.cn/', 0);
INSERT INTO `tool` VALUES (4, 'TOOL-0006', 'Sikuli测试工具', 'MIT的研究人员设计了一种新颖的图形脚本语言Sikuli，计算机用户只须有最基本的编程技能（比如会写print\"hello world\"），他不需要去写出一行行代码，而是用屏幕截图的方式，用截出来的图形元素组合出神奇的程序。', '/var/www/Tool/Sikuli.png', 'MIT', 'https://launchpad.net/sikuli/+download', 0);
INSERT INTO `tool` VALUES (5, 'TOOL-0003', 'LDTP GUI应用程序测试工具', 'GNU LDTP 是一个 GNU/Linux / Unix GUI 应用程序测试工具。它运行在GNU/Linux，Windows，Mac，Solaris，FreeBSD，NetBSD和嵌入式环境。', '/var/www/Tool/LDTP.png', 'LDTP', 'https://github.com/ldtp/ldtp2', 0);
INSERT INTO `tool` VALUES (6, 'TOOL-0004', 'LoadRunner性能测试工具', 'LoadRunner，是HP推出的一种预测系统行为和性能的负载测试工具，通过以模拟上千万用户实施并发负载及实时性能监测的方式来确认和查找问题，能够对整个企业架构进行测试。', '/var/www/Tool/LoadRunner.png', 'HewlettPackard', 'https://github.com/danwrong/loadrunner', 0);
INSERT INTO `tool` VALUES (7, 'TOOL-0002', 'HammerDB压力测试工具', 'HammerDB是一个开源的数据库压力测试的基准工具HammerDB模拟了标准的TPC-C和TPC-H两种测试模型，相比于标准的TPC-C和TPC-H，HammerDB运行成本低，操作简单， 是服务器数据库压力测试的很好选择。', '/var/www/Tool/HammerDB.png', 'TPC', 'https://www.hammerdb.com/download.html', 0);
INSERT INTO `tool` VALUES (8, 'TOOL-0001', 'UnixBench性能测试工具', 'UnixBench 是一个类 Unix 系（Unix，BSD，Linux）统下的性能测试工具，一个开源工具，被广泛用与测试 Linux 系统主机的性能。UnixBench 的主要测试项目有：系统调用、读写、进程、图形化测试、2D、3D、管道、运算、C库等系统基准性能提供测试数据。', '/var/www/Tool/UnixBench.png', 'BYTE UNIX', 'https://github.com/kdlucas/byte-unixbench', 0);
INSERT INTO `tool` VALUES (9, 'T00L-0009', '北斗助手V2.6', '北斗助手V2.6', '/var/www/Platform/logo-transparent.png', 'V2.6', 'http://third-part-tool.oss-cn-shanghai.aliyuncs.com/%E4%BC%97%E6%B5%8B/beidouzhushouv2.6.apk', 0);
INSERT INTO `tool` VALUES (10, 'TOOL-0010', 'LTP工具包', 'LTP工具包', '/var/www/Platform/logo-transparent.png', NULL, 'http://third-part-tool.oss-cn-shanghai.aliyuncs.com/%E4%BC%97%E6%B5%8B/ltp-master.zip', 0);
INSERT INTO `tool` VALUES (11, 'TOOL-0011', 'Eclipse安装包', 'Eclipse安装包', '/var/www/Platform/logo-transparent.png', NULL, 'http://third-part-tool.oss-cn-shanghai.aliyuncs.com/%E4%BC%97%E6%B5%8B/eclipse-java-2020-12-R-linux-gtk-x86_64.tar.gz', 0);
INSERT INTO `tool` VALUES (12, 'TOOL-0012', 'JDK8安装包', 'JDK8安装包', '/var/www/Platform/logo-transparent.png', 'JDK8', 'http://third-part-tool.oss-cn-shanghai.aliyuncs.com/%E4%BC%97%E6%B5%8B/jdk-8u271-linux-x64.tar.gz', 0);
INSERT INTO `tool` VALUES (13, 'TOOL-0013', '中科红旗linux桌面操作系统V11镜像', '中科红旗linux桌面操作系统V11镜像', '/var/www/Platform/logo-transparent.png', 'V11', 'http://third-part-tool.oss-cn-shanghai.aliyuncs.com/%E4%BC%97%E6%B5%8B/%E7%BA%A2%E6%97%97linux%E6%A1%8C%E9%9D%A2%E6%93%8D%E4%BD%9C%E7%B3%BB%E7%BB%9FV11RedFlag-Desktop-11.0-alpha-liveCD-0122.iso', 0);
INSERT INTO `tool` VALUES (14, 'TOOL-0014', '统信UOS桌面个人版（1010）镜像', '统信UOS桌面个人版（1010）镜像', '/var/www/Platform/logo-transparent.png', '1010', 'http://third-part-tool.oss-cn-shanghai.aliyuncs.com/%E4%BC%97%E6%B5%8B/%E7%BB%9F%E4%BF%A1uniontechos-desktop-home-1010-amd64.iso', 0);
INSERT INTO `tool` VALUES (15, 'TOOL-0015', 'VMWare虚拟机V16.1.0', 'VMWare虚拟机V16.1.0', '/var/www/Platform/logo-transparent.png', 'V16.1.0', 'http://third-part-tool.oss-cn-shanghai.aliyuncs.com/%E4%BC%97%E6%B5%8B/VMware%E8%99%9A%E6%8B%9F%E6%9C%BA.zip', 0);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `U_ID` bigint(20) NOT NULL COMMENT '用户ID',
  `U_NAME` varchar(255) DEFAULT NULL COMMENT '真实名',
  `U_USERNAME` varchar(255) DEFAULT NULL COMMENT '用户名',
  `U_MOBILE` varchar(255) DEFAULT NULL COMMENT '手机号',
  `U_PASSWORD` varchar(32) DEFAULT NULL COMMENT '密码',
  `U_EMAIL` varchar(255) DEFAULT NULL COMMENT '用户昵称',
  `U_GENDER` varchar(10) DEFAULT NULL COMMENT '性别',
  `U_PHOTO_URL` varchar(255) DEFAULT NULL COMMENT '头像',
  `U_PROVINCE` varchar(255) DEFAULT NULL COMMENT '省份',
  `U_CITY` varchar(255) DEFAULT NULL COMMENT '城市',
  `U_IS_DELETED` int(4) NOT NULL DEFAULT '1' COMMENT '是否被删除',
  `U_IS_AVAILABLE` int(4) NOT NULL DEFAULT '1' COMMENT '是否被冻结',
  `U_CREATE_TIME` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `U_BIRTHDAY` date DEFAULT NULL COMMENT '生日',
  `U_PERSONAL_COMPETENCE` varchar(255) DEFAULT NULL COMMENT '个人能力',
  `U_UNIT` varchar(255) DEFAULT NULL COMMENT '单位',
  `U_COUNTY` varchar(255) DEFAULT NULL COMMENT '县区',
  `U_DETAILED_ADDRESS` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`U_ID`) USING BTREE,
  KEY `mobile_idx` (`U_MOBILE`) USING BTREE,
  KEY `email_idx` (`U_EMAIL`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, '系统管理员', '系统管理员', '13657094938', '4QrcOUm6Wau+VuBX8g+IPg==', 'admin@xc.edu.cn', '女', '/var/www/Image/admin.png', NULL, NULL, 0, 1, '2021-01-01 00:00:00', '2021-01-01', '', '', NULL, NULL);
INSERT INTO `user` VALUES (2, '李同学', '李同学', NULL, '4QrcOUm6Wau+VuBX8g+IPg==', 'student@xc.edu.cn', '男', '/var/www/Image/student.png', '江苏省', '南京市', 0, 1, '2021-01-01 00:00:00', '2021-01-01', NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (3, '杨老师', '杨老师', NULL, '4QrcOUm6Wau+VuBX8g+IPg==', 'teacher@xc.edu.cn', '男', '/var/www/Image/teacher.png', '江苏省', '南京市', 1, 1, '2021-01-01 00:00:00', '2021-01-01', NULL, NULL, NULL, NULL);
INSERT INTO `user` VALUES (4, '系统发包管理员', '系统发包管理员', '13657094938', '4QrcOUm6Wau+VuBX8g+IPg==', 'adminPublish@xc.edu.cn', '男', '/var/www/Image/adminPublish.png', NULL, NULL, 1, 1, '2021-01-01 00:00:00', '2021-01-01', '', '', NULL, NULL);
INSERT INTO `user` VALUES (5, '注册测试', '注册测试', '13657094938', '4QrcOUm6Wau+VuBX8g+IPg==', 'student1@xc.edu.cn', '女', '/var/www/Image/5_9f88600d-6142-46fb-a97c-97d0006171a9_1610180358470.png', '', '', 0, 1, '2021-01-01 00:00:00', '2021-01-01', '', '', NULL, NULL);
INSERT INTO `user` VALUES (7, '南京慕测', '南京慕测', '13657094938', '4QrcOUm6Wau+VuBX8g+IPg==', 'mooctest@xc.edu.cn', NULL, NULL, NULL, NULL, 0, 1, '2021-01-01 00:00:00', '2021-01-01', NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for user_task_count
-- ----------------------------
DROP TABLE IF EXISTS `user_task_count`;
CREATE TABLE `user_task_count` (
  `UTC_ID` bigint(10) NOT NULL AUTO_INCREMENT COMMENT '标识',
  `UTC_USER_ID` bigint(20) DEFAULT NULL COMMENT '用户id',
  `UTC_COUNT` bigint(255) DEFAULT NULL COMMENT '接包数量',
  `UTC_TYPE` bigint(255) DEFAULT NULL COMMENT '用户类型 测评机构为2 测试人员为6',
  PRIMARY KEY (`UTC_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Table structure for user_to_role
-- ----------------------------
DROP TABLE IF EXISTS `user_to_role`;
CREATE TABLE `user_to_role` (
  `UTR_ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户角色ID',
  `UTR_U_ID` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `UTR_R_ID` bigint(20) DEFAULT NULL COMMENT '角色ID',
  `UTR_CREATE_TIME` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`UTR_ID`) USING BTREE,
  KEY `KP_UTR_R_ID` (`UTR_R_ID`) USING BTREE,
  KEY `KP_UTR_U_ID` (`UTR_U_ID`) USING BTREE,
  CONSTRAINT `KP_UTR_R_ID` FOREIGN KEY (`UTR_R_ID`) REFERENCES `role` (`R_ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of user_to_role
-- ----------------------------
BEGIN;
INSERT INTO `user_to_role` VALUES (1, 1, 1, NULL);
INSERT INTO `user_to_role` VALUES (2, 1, 4, NULL);
INSERT INTO `user_to_role` VALUES (3, 2, 5, NULL);
INSERT INTO `user_to_role` VALUES (4, 2, 1, NULL);
INSERT INTO `user_to_role` VALUES (5, 3, 1, NULL);
INSERT INTO `user_to_role` VALUES (6, 3, 3, NULL);
INSERT INTO `user_to_role` VALUES (7, 2, 8, NULL);
INSERT INTO `user_to_role` VALUES (8, 2, 2, NULL);
INSERT INTO `user_to_role` VALUES (9, 4, 1, NULL);
INSERT INTO `user_to_role` VALUES (10, 4, 7, NULL);
INSERT INTO `user_to_role` VALUES (11, 5, 1, NULL);
INSERT INTO `user_to_role` VALUES (12, 7, 1, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
