LimsBackend/mysql-init/TestLaboratory.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80029
 Source Host           : localhost:3306
 Source Schema         : TestLaboratory

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

 Date: 12/10/2022 22:29:41
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for auth_group
-- ----------------------------
DROP TABLE IF EXISTS `auth_group`;
CREATE TABLE `auth_group` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of auth_group
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for auth_group_permissions
-- ----------------------------
DROP TABLE IF EXISTS `auth_group_permissions`;
CREATE TABLE `auth_group_permissions` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `group_id` int NOT NULL,
  `permission_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
  KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`),
  CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of auth_group_permissions
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for auth_permission
-- ----------------------------
DROP TABLE IF EXISTS `auth_permission`;
CREATE TABLE `auth_permission` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `content_type_id` int NOT NULL,
  `codename` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
  CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of auth_permission
-- ----------------------------
BEGIN;
INSERT INTO `auth_permission` VALUES (1, 'Can add log entry', 1, 'add_logentry');
INSERT INTO `auth_permission` VALUES (2, 'Can change log entry', 1, 'change_logentry');
INSERT INTO `auth_permission` VALUES (3, 'Can delete log entry', 1, 'delete_logentry');
INSERT INTO `auth_permission` VALUES (4, 'Can view log entry', 1, 'view_logentry');
INSERT INTO `auth_permission` VALUES (5, 'Can add permission', 2, 'add_permission');
INSERT INTO `auth_permission` VALUES (6, 'Can change permission', 2, 'change_permission');
INSERT INTO `auth_permission` VALUES (7, 'Can delete permission', 2, 'delete_permission');
INSERT INTO `auth_permission` VALUES (8, 'Can view permission', 2, 'view_permission');
INSERT INTO `auth_permission` VALUES (9, 'Can add group', 3, 'add_group');
INSERT INTO `auth_permission` VALUES (10, 'Can change group', 3, 'change_group');
INSERT INTO `auth_permission` VALUES (11, 'Can delete group', 3, 'delete_group');
INSERT INTO `auth_permission` VALUES (12, 'Can view group', 3, 'view_group');
INSERT INTO `auth_permission` VALUES (13, 'Can add user', 4, 'add_user');
INSERT INTO `auth_permission` VALUES (14, 'Can change user', 4, 'change_user');
INSERT INTO `auth_permission` VALUES (15, 'Can delete user', 4, 'delete_user');
INSERT INTO `auth_permission` VALUES (16, 'Can view user', 4, 'view_user');
INSERT INTO `auth_permission` VALUES (17, 'Can add content type', 5, 'add_contenttype');
INSERT INTO `auth_permission` VALUES (18, 'Can change content type', 5, 'change_contenttype');
INSERT INTO `auth_permission` VALUES (19, 'Can delete content type', 5, 'delete_contenttype');
INSERT INTO `auth_permission` VALUES (20, 'Can view content type', 5, 'view_contenttype');
INSERT INTO `auth_permission` VALUES (21, 'Can add session', 6, 'add_session');
INSERT INTO `auth_permission` VALUES (22, 'Can change session', 6, 'change_session');
INSERT INTO `auth_permission` VALUES (23, 'Can delete session', 6, 'delete_session');
INSERT INTO `auth_permission` VALUES (24, 'Can view session', 6, 'view_session');
INSERT INTO `auth_permission` VALUES (25, 'Can add 权限', 7, 'add_permission');
INSERT INTO `auth_permission` VALUES (26, 'Can change 权限', 7, 'change_permission');
INSERT INTO `auth_permission` VALUES (27, 'Can delete 权限', 7, 'delete_permission');
INSERT INTO `auth_permission` VALUES (28, 'Can view 权限', 7, 'view_permission');
INSERT INTO `auth_permission` VALUES (29, 'Can add 角色', 8, 'add_role');
INSERT INTO `auth_permission` VALUES (30, 'Can change 角色', 8, 'change_role');
INSERT INTO `auth_permission` VALUES (31, 'Can delete 角色', 8, 'delete_role');
INSERT INTO `auth_permission` VALUES (32, 'Can view 角色', 8, 'view_role');
INSERT INTO `auth_permission` VALUES (33, 'Can add 用户', 9, 'add_user');
INSERT INTO `auth_permission` VALUES (34, 'Can change 用户', 9, 'change_user');
INSERT INTO `auth_permission` VALUES (35, 'Can delete 用户', 9, 'delete_user');
INSERT INTO `auth_permission` VALUES (36, 'Can view 用户', 9, 'view_user');
INSERT INTO `auth_permission` VALUES (37, 'Can add 被测试软件', 10, 'add_software');
INSERT INTO `auth_permission` VALUES (38, 'Can change 被测试软件', 10, 'change_software');
INSERT INTO `auth_permission` VALUES (39, 'Can delete 被测试软件', 10, 'delete_software');
INSERT INTO `auth_permission` VALUES (40, 'Can view 被测试软件', 10, 'view_software');
INSERT INTO `auth_permission` VALUES (41, 'Can add 软件版本', 11, 'add_version');
INSERT INTO `auth_permission` VALUES (42, 'Can change 软件版本', 11, 'change_version');
INSERT INTO `auth_permission` VALUES (43, 'Can delete 软件版本', 11, 'delete_version');
INSERT INTO `auth_permission` VALUES (44, 'Can view 软件版本', 11, 'view_version');
INSERT INTO `auth_permission` VALUES (45, 'Can add 测试计划', 12, 'add_testplan');
INSERT INTO `auth_permission` VALUES (46, 'Can change 测试计划', 12, 'change_testplan');
INSERT INTO `auth_permission` VALUES (47, 'Can delete 测试计划', 12, 'delete_testplan');
INSERT INTO `auth_permission` VALUES (48, 'Can view 测试计划', 12, 'view_testplan');
INSERT INTO `auth_permission` VALUES (49, 'Can add 测试任务', 13, 'add_testtask');
INSERT INTO `auth_permission` VALUES (50, 'Can change 测试任务', 13, 'change_testtask');
INSERT INTO `auth_permission` VALUES (51, 'Can delete 测试任务', 13, 'delete_testtask');
INSERT INTO `auth_permission` VALUES (52, 'Can view 测试任务', 13, 'view_testtask');
INSERT INTO `auth_permission` VALUES (53, 'Can add 测试用例', 14, 'add_testcase');
INSERT INTO `auth_permission` VALUES (54, 'Can change 测试用例', 14, 'change_testcase');
INSERT INTO `auth_permission` VALUES (55, 'Can delete 测试用例', 14, 'delete_testcase');
INSERT INTO `auth_permission` VALUES (56, 'Can view 测试用例', 14, 'view_testcase');
INSERT INTO `auth_permission` VALUES (57, 'Can add 文件管理', 15, 'add_filemanager');
INSERT INTO `auth_permission` VALUES (58, 'Can change 文件管理', 15, 'change_filemanager');
INSERT INTO `auth_permission` VALUES (59, 'Can delete 文件管理', 15, 'delete_filemanager');
INSERT INTO `auth_permission` VALUES (60, 'Can view 文件管理', 15, 'view_filemanager');
INSERT INTO `auth_permission` VALUES (61, 'Can add 日志', 16, 'add_log');
INSERT INTO `auth_permission` VALUES (62, 'Can change 日志', 16, 'change_log');
INSERT INTO `auth_permission` VALUES (63, 'Can delete 日志', 16, 'delete_log');
INSERT INTO `auth_permission` VALUES (64, 'Can view 日志', 16, 'view_log');
INSERT INTO `auth_permission` VALUES (65, 'Can add 被测试软件', 17, 'add_group');
INSERT INTO `auth_permission` VALUES (66, 'Can change 被测试软件', 17, 'change_group');
INSERT INTO `auth_permission` VALUES (67, 'Can delete 被测试软件', 17, 'delete_group');
INSERT INTO `auth_permission` VALUES (68, 'Can view 被测试软件', 17, 'view_group');
COMMIT;

-- ----------------------------
-- Table structure for auth_user
-- ----------------------------
DROP TABLE IF EXISTS `auth_user`;
CREATE TABLE `auth_user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `password` varchar(128) NOT NULL,
  `last_login` datetime(6) DEFAULT NULL,
  `is_superuser` tinyint(1) NOT NULL,
  `username` varchar(150) NOT NULL,
  `first_name` varchar(150) NOT NULL,
  `last_name` varchar(150) NOT NULL,
  `email` varchar(254) NOT NULL,
  `is_staff` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `date_joined` datetime(6) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of auth_user
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for auth_user_groups
-- ----------------------------
DROP TABLE IF EXISTS `auth_user_groups`;
CREATE TABLE `auth_user_groups` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `group_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_user_groups_user_id_group_id_94350c0c_uniq` (`user_id`,`group_id`),
  KEY `auth_user_groups_group_id_97559544_fk_auth_group_id` (`group_id`),
  CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
  CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of auth_user_groups
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for auth_user_user_permissions
-- ----------------------------
DROP TABLE IF EXISTS `auth_user_user_permissions`;
CREATE TABLE `auth_user_user_permissions` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `permission_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq` (`user_id`,`permission_id`),
  KEY `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` (`permission_id`),
  CONSTRAINT `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of auth_user_user_permissions
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for django_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `django_admin_log`;
CREATE TABLE `django_admin_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `action_time` datetime(6) NOT NULL,
  `object_id` longtext,
  `object_repr` varchar(200) NOT NULL,
  `action_flag` smallint unsigned NOT NULL,
  `change_message` longtext NOT NULL,
  `content_type_id` int DEFAULT NULL,
  `user_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
  KEY `django_admin_log_user_id_c564eba6_fk_auth_user_id` (`user_id`),
  CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
  CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`),
  CONSTRAINT `django_admin_log_chk_1` CHECK ((`action_flag` >= 0))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of django_admin_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for django_content_type
-- ----------------------------
DROP TABLE IF EXISTS `django_content_type`;
CREATE TABLE `django_content_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `app_label` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of django_content_type
-- ----------------------------
BEGIN;
INSERT INTO `django_content_type` VALUES (1, 'admin', 'logentry');
INSERT INTO `django_content_type` VALUES (3, 'auth', 'group');
INSERT INTO `django_content_type` VALUES (2, 'auth', 'permission');
INSERT INTO `django_content_type` VALUES (4, 'auth', 'user');
INSERT INTO `django_content_type` VALUES (5, 'contenttypes', 'contenttype');
INSERT INTO `django_content_type` VALUES (15, 'file', 'filemanager');
INSERT INTO `django_content_type` VALUES (17, 'group', 'group');
INSERT INTO `django_content_type` VALUES (16, 'log', 'log');
INSERT INTO `django_content_type` VALUES (12, 'plan', 'testplan');
INSERT INTO `django_content_type` VALUES (6, 'sessions', 'session');
INSERT INTO `django_content_type` VALUES (10, 'software', 'software');
INSERT INTO `django_content_type` VALUES (11, 'software', 'version');
INSERT INTO `django_content_type` VALUES (14, 'task', 'testcase');
INSERT INTO `django_content_type` VALUES (13, 'task', 'testtask');
INSERT INTO `django_content_type` VALUES (7, 'user', 'permission');
INSERT INTO `django_content_type` VALUES (8, 'user', 'role');
INSERT INTO `django_content_type` VALUES (9, 'user', 'user');
COMMIT;

-- ----------------------------
-- Table structure for django_migrations
-- ----------------------------
DROP TABLE IF EXISTS `django_migrations`;
CREATE TABLE `django_migrations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `app` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `applied` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of django_migrations
-- ----------------------------
BEGIN;
INSERT INTO `django_migrations` VALUES (1, 'contenttypes', '0001_initial', '2022-06-19 10:44:32.394371');
INSERT INTO `django_migrations` VALUES (2, 'auth', '0001_initial', '2022-06-19 10:44:32.487851');
INSERT INTO `django_migrations` VALUES (3, 'admin', '0001_initial', '2022-06-19 10:44:32.512785');
INSERT INTO `django_migrations` VALUES (4, 'admin', '0002_logentry_remove_auto_add', '2022-06-19 10:44:32.517001');
INSERT INTO `django_migrations` VALUES (5, 'admin', '0003_logentry_add_action_flag_choices', '2022-06-19 10:44:32.521252');
INSERT INTO `django_migrations` VALUES (6, 'contenttypes', '0002_remove_content_type_name', '2022-06-19 10:44:32.537446');
INSERT INTO `django_migrations` VALUES (7, 'auth', '0002_alter_permission_name_max_length', '2022-06-19 10:44:32.549952');
INSERT INTO `django_migrations` VALUES (8, 'auth', '0003_alter_user_email_max_length', '2022-06-19 10:44:32.559319');
INSERT INTO `django_migrations` VALUES (9, 'auth', '0004_alter_user_username_opts', '2022-06-19 10:44:32.564573');
INSERT INTO `django_migrations` VALUES (10, 'auth', '0005_alter_user_last_login_null', '2022-06-19 10:44:32.575576');
INSERT INTO `django_migrations` VALUES (11, 'auth', '0006_require_contenttypes_0002', '2022-06-19 10:44:32.576488');
INSERT INTO `django_migrations` VALUES (12, 'auth', '0007_alter_validators_add_error_messages', '2022-06-19 10:44:32.581006');
INSERT INTO `django_migrations` VALUES (13, 'auth', '0008_alter_user_username_max_length', '2022-06-19 10:44:32.596255');
INSERT INTO `django_migrations` VALUES (14, 'auth', '0009_alter_user_last_name_max_length', '2022-06-19 10:44:32.609861');
INSERT INTO `django_migrations` VALUES (15, 'auth', '0010_alter_group_name_max_length', '2022-06-19 10:44:32.617614');
INSERT INTO `django_migrations` VALUES (16, 'auth', '0011_update_proxy_permissions', '2022-06-19 10:44:32.621214');
INSERT INTO `django_migrations` VALUES (17, 'auth', '0012_alter_user_first_name_max_length', '2022-06-19 10:44:32.633468');
INSERT INTO `django_migrations` VALUES (18, 'file', '0001_initial', '2022-06-19 10:44:32.640435');
INSERT INTO `django_migrations` VALUES (19, 'file', '0002_alter_filemanager_id', '2022-06-19 10:44:32.647955');
INSERT INTO `django_migrations` VALUES (20, 'log', '0001_initial', '2022-06-19 10:44:32.657577');
INSERT INTO `django_migrations` VALUES (21, 'log', '0002_alter_log_id', '2022-06-19 10:44:32.665621');
INSERT INTO `django_migrations` VALUES (22, 'user', '0001_initial', '2022-06-19 10:44:32.726788');
INSERT INTO `django_migrations` VALUES (23, 'software', '0001_initial', '2022-06-19 10:44:32.751318');
INSERT INTO `django_migrations` VALUES (24, 'plan', '0001_initial', '2022-06-19 10:44:32.795555');
INSERT INTO `django_migrations` VALUES (25, 'plan', '0002_alter_testplan_id', '2022-06-19 10:44:32.806378');
INSERT INTO `django_migrations` VALUES (26, 'sessions', '0001_initial', '2022-06-19 10:44:32.814163');
INSERT INTO `django_migrations` VALUES (27, 'software', '0002_alter_software_name', '2022-06-19 10:44:32.825552');
INSERT INTO `django_migrations` VALUES (28, 'task', '0001_initial', '2022-06-19 10:44:32.893446');
INSERT INTO `django_migrations` VALUES (29, 'task', '0002_alter_testtask_id', '2022-06-19 10:44:32.938279');
INSERT INTO `django_migrations` VALUES (30, 'user', '0002_auto_20220619_1043', '2022-06-19 10:44:33.059425');
INSERT INTO `django_migrations` VALUES (31, 'task', '0003_auto_20220626_1630', '2022-06-26 16:31:02.458212');
INSERT INTO `django_migrations` VALUES (32, 'group', '0001_initial', '2022-10-04 20:49:38.358109');
INSERT INTO `django_migrations` VALUES (33, 'software', '0003_auto_20221004_2044', '2022-10-04 20:49:38.476140');
INSERT INTO `django_migrations` VALUES (34, 'task', '0004_alter_testcase_id', '2022-10-04 20:49:38.493060');
INSERT INTO `django_migrations` VALUES (35, 'user', '0003_remove_user_group', '2022-10-05 17:30:42.091655');
INSERT INTO `django_migrations` VALUES (36, 'group', '0002_group_users', '2022-10-05 17:30:42.127830');
INSERT INTO `django_migrations` VALUES (37, 'group', '0003_alter_group_code', '2022-10-05 19:27:19.485913');
COMMIT;

-- ----------------------------
-- Table structure for django_session
-- ----------------------------
DROP TABLE IF EXISTS `django_session`;
CREATE TABLE `django_session` (
  `session_key` varchar(40) NOT NULL,
  `session_data` longtext NOT NULL,
  `expire_date` datetime(6) NOT NULL,
  PRIMARY KEY (`session_key`),
  KEY `django_session_expire_date_a5c62663` (`expire_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of django_session
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for file_manager
-- ----------------------------
DROP TABLE IF EXISTS `file_manager`;
CREATE TABLE `file_manager` (
  `id` varchar(128) NOT NULL,
  `path` varchar(200) NOT NULL,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `delete` tinyint(1) NOT NULL,
  `category` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of file_manager
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for group
-- ----------------------------
DROP TABLE IF EXISTS `group`;
CREATE TABLE `group` (
  `name` varchar(128) NOT NULL,
  `id` varchar(128) NOT NULL,
  `code` varchar(12) NOT NULL,
  `manager` varchar(60) NOT NULL,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `delete` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of group
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for group_users
-- ----------------------------
DROP TABLE IF EXISTS `group_users`;
CREATE TABLE `group_users` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `group_id` varchar(128) NOT NULL,
  `user_id` varchar(128) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `group_users_group_id_user_id_c7ab77af_uniq` (`group_id`,`user_id`),
  KEY `group_users_user_id_3c44daf2_fk_user_id` (`user_id`),
  CONSTRAINT `group_users_group_id_3ffe8048_fk_group_id` FOREIGN KEY (`group_id`) REFERENCES `group` (`id`),
  CONSTRAINT `group_users_user_id_3c44daf2_fk_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of group_users
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for log
-- ----------------------------
DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
  `id` varchar(128) NOT NULL,
  `action` varchar(100) NOT NULL,
  `entity_class` varchar(50) NOT NULL,
  `entity_name` varchar(50) DEFAULT NULL,
  `method` varchar(30) NOT NULL,
  `executor_id` varchar(50) NOT NULL,
  `executor_username` varchar(50) NOT NULL,
  `executor_identify` int NOT NULL,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `delete` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for permission
-- ----------------------------
DROP TABLE IF EXISTS `permission`;
CREATE TABLE `permission` (
  `id` varchar(128) NOT NULL,
  `name` varchar(25) NOT NULL,
  `url` varchar(125) DEFAULT NULL,
  `method` varchar(20) DEFAULT NULL,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `delete` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of permission
-- ----------------------------
BEGIN;
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_1', '新建测试目标', '/api/v1/software', 'POST', '2021-07-14 10:20:49.000000', '2021-07-14 10:20:51.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_10', '导出测试用例', '/api/v1/software/.*/versions', 'GET', '2021-07-14 10:31:00.000000', '2021-07-14 10:31:03.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_11', '创建测试计划', '/api/v1/test-plans', 'POST', '2021-07-14 10:32:39.000000', '2021-07-14 10:32:41.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_12', '查看测试计划列表', '/api/v1/test-plans', 'GET', '2021-07-14 10:33:34.000000', '2021-07-14 10:33:39.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_13', '编辑测试计划', '/api/v1/test-plans/.*/edit', 'POST', '2021-07-14 10:34:37.000000', '2021-07-14 10:34:41.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_14', '查看测试计划', '/api/v1/test-plans/.*', 'GET', '2021-07-14 10:35:27.000000', '2021-07-14 10:35:30.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_15', '删除测试计划', '/api/v1/test-plans/.*', 'DELETE', '2021-07-14 10:35:53.000000', '2021-07-14 10:35:56.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_16', '创建测试任务', '/api/v1/test-tasks', 'POST', '2021-07-14 10:37:00.000000', '2021-07-14 10:37:04.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_17', '查看测试任务列表', '/api/v1/test-tasks', 'GET', '2021-07-14 10:37:43.000000', '2021-07-14 10:37:47.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_18', '查看测试任务', '/api/v1/test-tasks/.*', 'GET', '2021-07-14 10:38:34.000000', '2021-07-14 10:38:37.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_19', '编辑测试任务', '/api/v1/test-tasks/.*/edit', 'POST', '2021-07-14 10:39:01.000000', '2021-07-14 10:39:05.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_2', '查看测试目标列表', '/api/v1/software', 'GET', '2021-07-14 10:23:46.000000', '2021-07-14 10:23:49.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_20', '删除测试任务', '/api/v1/test-tasks/.*', 'DELETE', '2021-07-14 10:39:54.000000', '2021-07-14 10:39:58.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_21', '执行测试任务', '/api/v1/test-tasks/.*/case-file/execute', 'POST', '2021-07-14 10:40:58.000000', '2021-07-14 10:41:01.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_22', '导出测试用例', '/api/v1/test-tasks/.*/case-file', 'GET', '2021-07-14 10:42:06.000000', '2021-07-14 10:42:12.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_23', '查看用户列表', '/api/v1/users', 'GET', '2021-07-15 11:22:54.000000', '2021-07-15 11:22:57.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_24', '上传文件', '/api/v1/file', 'POST', '2021-07-17 11:08:14.000000', '2021-07-17 11:08:18.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_25', '删除文件', '/api/v1/file', 'DELETE', '2021-07-17 11:08:14.000000', '2021-07-17 11:08:18.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_26', '查看用户', '/api/v1/users/.*', 'GET', '2021-07-17 17:18:35.000000', '2021-07-17 17:18:38.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_27', '编辑用户信息', '/api/v1/users/.*/edit', 'POST', '2021-07-15 11:22:54.000000', '2021-07-15 11:22:57.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_28', '查看版本列表', '/api/v1/software/versions', 'GET', '2021-07-20 17:32:29.000000', '2021-07-20 17:32:33.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_29', '创建分组', '/api/v1/group', 'POST', '2021-07-20 17:32:29.000000', '2021-07-20 17:32:33.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_3', '查看测试目标', '/api/v1/software/.*', 'GET', '2021-07-14 10:25:16.000000', '2021-07-14 10:25:19.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_30', '编辑分组信息', '/api/v1/group/.*/edit', 'POST', '2022-10-06 08:59:33.000000', '2022-10-06 08:59:38.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_31', '分组列表', '/api/v1/group', 'GET', '2022-10-06 09:00:25.000000', '2022-10-06 09:00:29.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_32', '查看分组信息', '/api/v1/group/.*', 'GET', '2022-10-06 09:01:18.000000', '2022-10-06 09:01:22.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_33', '删除分组', '/api/v1/group/.*', 'DELETE', '2022-10-06 09:01:59.000000', '2022-10-06 09:02:03.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_34', '加入班级', '/api/v1/users/.*/join', 'POST', '2022-10-06 09:02:48.000000', '2022-10-06 09:02:53.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_35', '退出班级', '/api/v1/users/.*/quit', 'POST', '2022-10-06 09:03:27.000000', '2022-10-06 09:03:30.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_36', '分组用户', '/api/v1/group/user', 'GET', '2022-10-10 22:02:45.000000', '2022-10-10 22:02:47.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_37', '导出用户', '/api/v1/users/group', 'GET', '2022-10-12 11:35:48.000000', '2022-10-12 11:35:50.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_4', '编辑测试目标', '/api/v1/software/.*/edit', 'POST', '2021-07-14 10:25:48.000000', '2021-07-14 10:25:50.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_5', '删除测试目标', '/api/v1/software/.*', 'DELETE', '2021-07-14 10:26:40.000000', '2021-07-14 10:26:42.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_6', '生成测试报告', '/api/v1/software/.*/report', 'GET', '2021-07-14 10:27:43.000000', '2021-07-14 10:27:46.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_7', '新建版本', '/api/v1/software/.*/versions', 'POST', '2021-07-14 10:29:22.000000', '2021-07-14 10:29:25.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_8', '编辑版本', '/api/v1/software/.*/versions/edit', 'POST', '2021-07-14 10:29:51.000000', '2021-07-14 10:29:59.000000', 0);
INSERT INTO `permission` VALUES ('TestLaboratory_V1_Permission_9', '删除版本', '/api/v1/software/.*/versions', 'DELETE', '2021-07-14 10:30:31.000000', '2021-07-14 10:30:33.000000', 0);
COMMIT;

-- ----------------------------
-- Table structure for plan
-- ----------------------------
DROP TABLE IF EXISTS `plan`;
CREATE TABLE `plan` (
  `id` varchar(128) NOT NULL,
  `title` varchar(30) NOT NULL,
  `version` varchar(20) NOT NULL,
  `state` int NOT NULL,
  `description` longtext NOT NULL,
  `statement_file` longtext NOT NULL,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `delete` tinyint(1) NOT NULL,
  `creator_id` varchar(128) DEFAULT NULL,
  `software_id` varchar(128) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `plan_creator_id_c94ecd21_fk` (`creator_id`),
  KEY `plan_software_id_4b28cc2e_fk` (`software_id`),
  CONSTRAINT `plan_creator_id_c94ecd21_fk` FOREIGN KEY (`creator_id`) REFERENCES `user` (`id`),
  CONSTRAINT `plan_software_id_4b28cc2e_fk` FOREIGN KEY (`software_id`) REFERENCES `software` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of plan
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` varchar(128) NOT NULL,
  `name` varchar(25) NOT NULL,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `delete` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of role
-- ----------------------------
BEGIN;
INSERT INTO `role` VALUES ('TestLaboratory_V1_Role_1', '系统管理员', '2021-07-14 10:44:26.000000', '2021-07-14 10:44:34.000000', 0);
INSERT INTO `role` VALUES ('TestLaboratory_V1_Role_2', '测试管理员', '2021-07-14 10:44:53.000000', '2021-07-14 10:44:56.000000', 0);
INSERT INTO `role` VALUES ('TestLaboratory_V1_Role_3', '测试工程师', '2021-07-14 10:45:12.000000', '2021-07-14 10:45:15.000000', 0);
COMMIT;

-- ----------------------------
-- Table structure for role_permissions
-- ----------------------------
DROP TABLE IF EXISTS `role_permissions`;
CREATE TABLE `role_permissions` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `role_id` varchar(128) NOT NULL,
  `permission_id` varchar(128) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `role_permissions_role_id_permission_id_04f77df0_uniq` (`role_id`,`permission_id`),
  KEY `role_permissions_permission_id_ad343843_fk_permission_id` (`permission_id`)
) ENGINE=InnoDB AUTO_INCREMENT=88 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of role_permissions
-- ----------------------------
BEGIN;
INSERT INTO `role_permissions` VALUES (1, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_1');
INSERT INTO `role_permissions` VALUES (10, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_10');
INSERT INTO `role_permissions` VALUES (11, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_11');
INSERT INTO `role_permissions` VALUES (12, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_12');
INSERT INTO `role_permissions` VALUES (13, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_13');
INSERT INTO `role_permissions` VALUES (14, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_14');
INSERT INTO `role_permissions` VALUES (15, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_15');
INSERT INTO `role_permissions` VALUES (16, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_16');
INSERT INTO `role_permissions` VALUES (17, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_17');
INSERT INTO `role_permissions` VALUES (18, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_18');
INSERT INTO `role_permissions` VALUES (19, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_19');
INSERT INTO `role_permissions` VALUES (2, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_2');
INSERT INTO `role_permissions` VALUES (20, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_20');
INSERT INTO `role_permissions` VALUES (21, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_21');
INSERT INTO `role_permissions` VALUES (51, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_23');
INSERT INTO `role_permissions` VALUES (54, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_24');
INSERT INTO `role_permissions` VALUES (56, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_25');
INSERT INTO `role_permissions` VALUES (58, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_26');
INSERT INTO `role_permissions` VALUES (61, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_27');
INSERT INTO `role_permissions` VALUES (65, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_28');
INSERT INTO `role_permissions` VALUES (67, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_29');
INSERT INTO `role_permissions` VALUES (3, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_3');
INSERT INTO `role_permissions` VALUES (69, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_30');
INSERT INTO `role_permissions` VALUES (71, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_31');
INSERT INTO `role_permissions` VALUES (73, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_32');
INSERT INTO `role_permissions` VALUES (75, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_33');
INSERT INTO `role_permissions` VALUES (77, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_34');
INSERT INTO `role_permissions` VALUES (80, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_35');
INSERT INTO `role_permissions` VALUES (84, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_36');
INSERT INTO `role_permissions` VALUES (86, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_37');
INSERT INTO `role_permissions` VALUES (4, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_4');
INSERT INTO `role_permissions` VALUES (5, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_5');
INSERT INTO `role_permissions` VALUES (6, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_6');
INSERT INTO `role_permissions` VALUES (7, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_7');
INSERT INTO `role_permissions` VALUES (8, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_8');
INSERT INTO `role_permissions` VALUES (9, 'TestLaboratory_V1_Role_1', 'TestLaboratory_V1_Permission_9');
INSERT INTO `role_permissions` VALUES (22, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_1');
INSERT INTO `role_permissions` VALUES (31, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_10');
INSERT INTO `role_permissions` VALUES (32, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_11');
INSERT INTO `role_permissions` VALUES (33, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_12');
INSERT INTO `role_permissions` VALUES (34, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_13');
INSERT INTO `role_permissions` VALUES (35, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_14');
INSERT INTO `role_permissions` VALUES (36, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_15');
INSERT INTO `role_permissions` VALUES (37, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_16');
INSERT INTO `role_permissions` VALUES (38, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_17');
INSERT INTO `role_permissions` VALUES (39, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_18');
INSERT INTO `role_permissions` VALUES (40, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_19');
INSERT INTO `role_permissions` VALUES (23, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_2');
INSERT INTO `role_permissions` VALUES (41, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_20');
INSERT INTO `role_permissions` VALUES (42, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_21');
INSERT INTO `role_permissions` VALUES (52, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_23');
INSERT INTO `role_permissions` VALUES (55, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_24');
INSERT INTO `role_permissions` VALUES (57, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_25');
INSERT INTO `role_permissions` VALUES (59, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_26');
INSERT INTO `role_permissions` VALUES (62, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_27');
INSERT INTO `role_permissions` VALUES (66, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_28');
INSERT INTO `role_permissions` VALUES (68, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_29');
INSERT INTO `role_permissions` VALUES (24, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_3');
INSERT INTO `role_permissions` VALUES (70, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_30');
INSERT INTO `role_permissions` VALUES (72, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_31');
INSERT INTO `role_permissions` VALUES (74, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_32');
INSERT INTO `role_permissions` VALUES (76, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_33');
INSERT INTO `role_permissions` VALUES (78, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_34');
INSERT INTO `role_permissions` VALUES (81, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_35');
INSERT INTO `role_permissions` VALUES (85, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_36');
INSERT INTO `role_permissions` VALUES (87, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_37');
INSERT INTO `role_permissions` VALUES (25, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_4');
INSERT INTO `role_permissions` VALUES (26, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_5');
INSERT INTO `role_permissions` VALUES (27, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_6');
INSERT INTO `role_permissions` VALUES (28, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_7');
INSERT INTO `role_permissions` VALUES (29, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_8');
INSERT INTO `role_permissions` VALUES (30, 'TestLaboratory_V1_Role_2', 'TestLaboratory_V1_Permission_9');
INSERT INTO `role_permissions` VALUES (45, 'TestLaboratory_V1_Role_3', 'TestLaboratory_V1_Permission_12');
INSERT INTO `role_permissions` VALUES (46, 'TestLaboratory_V1_Role_3', 'TestLaboratory_V1_Permission_14');
INSERT INTO `role_permissions` VALUES (47, 'TestLaboratory_V1_Role_3', 'TestLaboratory_V1_Permission_17');
INSERT INTO `role_permissions` VALUES (48, 'TestLaboratory_V1_Role_3', 'TestLaboratory_V1_Permission_18');
INSERT INTO `role_permissions` VALUES (64, 'TestLaboratory_V1_Role_3', 'TestLaboratory_V1_Permission_19');
INSERT INTO `role_permissions` VALUES (43, 'TestLaboratory_V1_Role_3', 'TestLaboratory_V1_Permission_2');
INSERT INTO `role_permissions` VALUES (49, 'TestLaboratory_V1_Role_3', 'TestLaboratory_V1_Permission_21');
INSERT INTO `role_permissions` VALUES (50, 'TestLaboratory_V1_Role_3', 'TestLaboratory_V1_Permission_22');
INSERT INTO `role_permissions` VALUES (53, 'TestLaboratory_V1_Role_3', 'TestLaboratory_V1_Permission_23');
INSERT INTO `role_permissions` VALUES (60, 'TestLaboratory_V1_Role_3', 'TestLaboratory_V1_Permission_26');
INSERT INTO `role_permissions` VALUES (63, 'TestLaboratory_V1_Role_3', 'TestLaboratory_V1_Permission_27');
INSERT INTO `role_permissions` VALUES (44, 'TestLaboratory_V1_Role_3', 'TestLaboratory_V1_Permission_3');
INSERT INTO `role_permissions` VALUES (83, 'TestLaboratory_V1_Role_3', 'TestLaboratory_V1_Permission_31');
INSERT INTO `role_permissions` VALUES (79, 'TestLaboratory_V1_Role_3', 'TestLaboratory_V1_Permission_34');
INSERT INTO `role_permissions` VALUES (82, 'TestLaboratory_V1_Role_3', 'TestLaboratory_V1_Permission_35');
COMMIT;

-- ----------------------------
-- Table structure for software
-- ----------------------------
DROP TABLE IF EXISTS `software`;
CREATE TABLE `software` (
  `name` varchar(128) NOT NULL,
  `id` varchar(128) NOT NULL,
  `type` varchar(20) NOT NULL,
  `report_file` longtext,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `delete` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of software
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for task
-- ----------------------------
DROP TABLE IF EXISTS `task`;
CREATE TABLE `task` (
  `id` varchar(128) NOT NULL,
  `title` varchar(50) NOT NULL,
  `state` int NOT NULL,
  `description` longtext NOT NULL,
  `statement_file` longtext NOT NULL,
  `case_file` longtext,
  `case_all` int DEFAULT NULL,
  `case_not_execute` int DEFAULT NULL,
  `case_success` int DEFAULT NULL,
  `case_fail` int DEFAULT NULL,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `delete` tinyint(1) NOT NULL,
  `plan_id` varchar(128) NOT NULL,
  `executor_id` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `task_plan_id_77395325_fk_plan_id` (`plan_id`),
  KEY `task_executor_id_24a67329_fk_user_id` (`executor_id`),
  CONSTRAINT `task_executor_id_24a67329_fk_user_id` FOREIGN KEY (`executor_id`) REFERENCES `user` (`id`),
  CONSTRAINT `task_plan_id_77395325_fk_plan_id` FOREIGN KEY (`plan_id`) REFERENCES `plan` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of task
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for test_case
-- ----------------------------
DROP TABLE IF EXISTS `test_case`;
CREATE TABLE `test_case` (
  `id` varchar(128) NOT NULL,
  `id_in_task` varchar(30) NOT NULL,
  `version` varchar(30) DEFAULT NULL,
  `name` varchar(50) NOT NULL,
  `state` int NOT NULL,
  `writer` varchar(30) DEFAULT NULL,
  `executor` varchar(30) DEFAULT NULL,
  `assessor` varchar(30) DEFAULT NULL,
  `requisite` longtext,
  `priority` varchar(10) DEFAULT NULL,
  `environment` longtext,
  `type` varchar(30) DEFAULT NULL,
  `process` longtext NOT NULL,
  `expected_result` longtext NOT NULL,
  `actual_result` longtext,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `delete` tinyint(1) NOT NULL,
  `remark` longtext,
  `software_id` varchar(128) DEFAULT NULL,
  `task_id` varchar(128) NOT NULL,
  `executor_id_id` varchar(128) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `test_case_task_id_6c501356_fk` (`task_id`),
  KEY `test_case_executor_id_id_4afa1b6e_fk_user_id` (`executor_id_id`),
  KEY `test_case_software_id_b7e9af75_fk` (`software_id`),
  CONSTRAINT `test_case_executor_id_id_4afa1b6e_fk_user_id` FOREIGN KEY (`executor_id_id`) REFERENCES `user` (`id`),
  CONSTRAINT `test_case_software_id_b7e9af75_fk` FOREIGN KEY (`software_id`) REFERENCES `software` (`id`),
  CONSTRAINT `test_case_task_id_6c501356_fk` FOREIGN KEY (`task_id`) REFERENCES `task` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of test_case
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` varchar(128) NOT NULL,
  `username` varchar(30) NOT NULL,
  `name` varchar(20) NOT NULL,
  `password` varchar(60) NOT NULL,
  `tel` varchar(20) NOT NULL,
  `identify` int NOT NULL,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `is_login` tinyint(1) NOT NULL,
  `delete` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES ('TestLaboratory_V1_User_1', 'honghong', '小红', '123456', '18851111391', 1, '2021-07-13 14:23:25.000000', '2022-10-10 22:09:59.520843', 1, 0);
INSERT INTO `user` VALUES ('TestLaboratory_V1_User_2', 'zxc', '小蓝', '123456', '11223344556', 2, '2021-09-26 15:41:37.000000', '1900-01-20 17:33:18.000000', 0, 0);
INSERT INTO `user` VALUES ('TestLaboratory_V1_User_3', 'bcd', '小黄', '123456', '138138138138', 2, '2021-09-26 15:44:39.000000', '2021-09-26 15:44:43.000000', 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for user_roles
-- ----------------------------
DROP TABLE IF EXISTS `user_roles`;
CREATE TABLE `user_roles` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` varchar(128) NOT NULL,
  `role_id` varchar(128) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_roles_user_id_role_id_69bfd9a0_uniq` (`user_id`,`role_id`),
  KEY `user_roles_role_id_816a4486_fk_role_id` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of user_roles
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for version
-- ----------------------------
DROP TABLE IF EXISTS `version`;
CREATE TABLE `version` (
  `id` varchar(128) NOT NULL,
  `number` varchar(20) NOT NULL,
  `version_file` longtext NOT NULL,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `delete` tinyint(1) NOT NULL,
  `software_id` varchar(128) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `version_software_id_d30b116d` (`software_id`),
  CONSTRAINT `version_software_id_d30b116d_fk` FOREIGN KEY (`software_id`) REFERENCES `software` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of version
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;