fuzz-scene-sim-test/mysql/init.sql

/*
 Navicat Premium Data Transfer

 Source Server         : music-website
 Source Server Type    : MySQL
 Source Server Version : 80027
 Source Host           : localhost:3306
 Source Schema         : springboot

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

 Date: 09/11/2023 22:48:19


create database test;

create user 'test'@'%' identified by 'test';

grant all privileges on test.* to 'test'@'%';


*/


use test;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for config2model
-- ----------------------------
DROP TABLE IF EXISTS `config2model`;
CREATE TABLE `config2model`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `config_id` int NOT NULL,
  `model_id` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 44 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of config2model
-- ----------------------------
INSERT INTO `config2model` VALUES (37, 22, 39);
INSERT INTO `config2model` VALUES (38, 23, 34);
INSERT INTO `config2model` VALUES (39, 24, 35);
INSERT INTO `config2model` VALUES (40, 25, 38);
INSERT INTO `config2model` VALUES (41, 26, 34);
INSERT INTO `config2model` VALUES (42, 26, 35);
INSERT INTO `config2model` VALUES (43, 26, 38);
INSERT INTO `config2model` VALUES (44, 26, 39);

-- ----------------------------
-- Table structure for config2operator
-- ----------------------------
DROP TABLE IF EXISTS `config2operator`;
CREATE TABLE `config2operator`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `config_id` int NOT NULL,
  `operator_id` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 71 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of config2operator
-- ----------------------------
INSERT INTO `config2operator` VALUES (52, 22, 1);
INSERT INTO `config2operator` VALUES (53, 22, 2);
INSERT INTO `config2operator` VALUES (54, 22, 4);
INSERT INTO `config2operator` VALUES (55, 23, 3);
INSERT INTO `config2operator` VALUES (56, 23, 5);
INSERT INTO `config2operator` VALUES (57, 24, 3);
INSERT INTO `config2operator` VALUES (58, 24, 5);
INSERT INTO `config2operator` VALUES (59, 24, 1);
INSERT INTO `config2operator` VALUES (60, 24, 2);
INSERT INTO `config2operator` VALUES (61, 24, 4);
INSERT INTO `config2operator` VALUES (62, 25, 3);
INSERT INTO `config2operator` VALUES (63, 25, 5);
INSERT INTO `config2operator` VALUES (64, 25, 1);
INSERT INTO `config2operator` VALUES (65, 25, 2);
INSERT INTO `config2operator` VALUES (66, 25, 4);
INSERT INTO `config2operator` VALUES (67, 26, 1);
INSERT INTO `config2operator` VALUES (68, 26, 2);
INSERT INTO `config2operator` VALUES (69, 26, 3);
INSERT INTO `config2operator` VALUES (70, 26, 4);
INSERT INTO `config2operator` VALUES (71, 26, 5);

-- ----------------------------
-- Table structure for config2seed
-- ----------------------------
DROP TABLE IF EXISTS `config2seed`;
CREATE TABLE `config2seed`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `config_id` int NOT NULL,
  `seed_id` int NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 91 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of config2seed
-- ----------------------------
INSERT INTO `config2seed` VALUES (62, 22, 4);
INSERT INTO `config2seed` VALUES (63, 22, 5);
INSERT INTO `config2seed` VALUES (64, 22, 6);
INSERT INTO `config2seed` VALUES (65, 22, 7);
INSERT INTO `config2seed` VALUES (66, 22, 8);
INSERT INTO `config2seed` VALUES (67, 22, 9);
INSERT INTO `config2seed` VALUES (68, 23, 4);
INSERT INTO `config2seed` VALUES (69, 23, 5);
INSERT INTO `config2seed` VALUES (70, 23, 6);
INSERT INTO `config2seed` VALUES (71, 23, 7);
INSERT INTO `config2seed` VALUES (72, 23, 8);
INSERT INTO `config2seed` VALUES (73, 23, 9);
INSERT INTO `config2seed` VALUES (74, 24, 4);
INSERT INTO `config2seed` VALUES (75, 24, 5);
INSERT INTO `config2seed` VALUES (76, 24, 6);
INSERT INTO `config2seed` VALUES (77, 24, 7);
INSERT INTO `config2seed` VALUES (78, 24, 8);
INSERT INTO `config2seed` VALUES (79, 24, 9);
INSERT INTO `config2seed` VALUES (80, 25, 4);
INSERT INTO `config2seed` VALUES (81, 25, 5);
INSERT INTO `config2seed` VALUES (82, 25, 6);
INSERT INTO `config2seed` VALUES (83, 25, 7);
INSERT INTO `config2seed` VALUES (84, 25, 8);
INSERT INTO `config2seed` VALUES (85, 25, 9);
INSERT INTO `config2seed` VALUES (86, 26, 4);
INSERT INTO `config2seed` VALUES (87, 26, 5);
INSERT INTO `config2seed` VALUES (88, 26, 6);
INSERT INTO `config2seed` VALUES (89, 26, 7);
INSERT INTO `config2seed` VALUES (90, 26, 8);
INSERT INTO `config2seed` VALUES (91, 26, 9);

-- ----------------------------
-- Table structure for configuration
-- ----------------------------
DROP TABLE IF EXISTS `configuration`;
CREATE TABLE `configuration`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `pri_queue_size` int NOT NULL,
  `init_pop_size` int NOT NULL,
  `sampling` int NOT NULL,
  `radar_loop` int NOT NULL,
  `loop` int NOT NULL,
  `fit_function` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of configuration
-- ----------------------------
INSERT INTO `configuration` VALUES (22, 50, 72, 1, 20,20, 'Error+Diversity');
INSERT INTO `configuration` VALUES (23, 50, 72, 1, 20,20, 'Error');
INSERT INTO `configuration` VALUES (24, 50, 72, 1, 20,20, 'Diversity');
INSERT INTO `configuration` VALUES (25, 50, 72, 1, 20,20, 'Error+Diversity');
INSERT INTO `configuration` VALUES (26, 50, 24, 1, 20,20, 'Error+Diversity');

-- ----------------------------
-- Table structure for model
-- ----------------------------
DROP TABLE IF EXISTS `model`;
CREATE TABLE `model`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `file_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `size` double NOT NULL,
  `create_date` datetime NOT NULL,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 39 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of model
-- ----------------------------
INSERT INTO `model` VALUES (34, 'Model2', 'Model2.h5', 8305, '2023-04-06 19:54:14', '.h5', 'Dave_v2 转向角预测模型 准确率83.7%');
INSERT INTO `model` VALUES (35, 'Model3', 'Model3.h5', 12831, '2023-04-06 19:54:38', '.h5', 'Dave_v3 转向角预测模型 准确率 88.2%');
INSERT INTO `model` VALUES (38, 'Model4', 'Model4.h5', 131472, '2023-04-07 02:47:41', '.h5', 'Epoch 转向角预测模型 准确率 85.4%');
INSERT INTO `model` VALUES (39, 'Model1', 'Model1.h5', 8305, '2023-04-07 02:48:11', '.h5', 'Dave_v1 转向角预测模型 准确率88.2%');

-- ----------------------------
-- Table structure for operator
-- ----------------------------
DROP TABLE IF EXISTS `operator`;
CREATE TABLE `operator`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of operator
-- ----------------------------
INSERT INTO `operator` VALUES (1, 'vehicleColor', '车辆颜色');
INSERT INTO `operator` VALUES (2, 'time', '时间');
INSERT INTO `operator` VALUES (3, 'sunIntensity', '光照强度');
INSERT INTO `operator` VALUES (4, 'fog', '雾天');
INSERT INTO `operator` VALUES (5, 'rain', '雨天');

-- ----------------------------
-- Table structure for seed
-- ----------------------------
DROP TABLE IF EXISTS `seed`;
CREATE TABLE `seed`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `carla_map` int NOT NULL,
  `create_date` datetime NOT NULL,
  `type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of seed
-- ----------------------------
INSERT INTO `seed` VALUES (4, 'seed_0_0_1.xosc', 4, '2023-04-05 22:26:19', '0', '晴天、右转弯、车道跟随、前方树木');
INSERT INTO `seed` VALUES (5, 'seed_0_0_2.xosc', 4, '2023-04-05 22:26:52', '0', '晴天、右转弯、车道跟随、前方石头');
INSERT INTO `seed` VALUES (6, 'seed_0_0_3.xosc', 4, '2023-04-05 22:27:29', '0', '晴天、左转弯、车道跟随、狭窄道路');
INSERT INTO `seed` VALUES (7, 'seed_0_0_4.xosc', 7, '2023-04-05 22:27:51', '0', '晴天、右转弯、下坡、车道跟随、郊区道路');
INSERT INTO `seed` VALUES (8, 'seed_0_0_5.xosc', 7, '2023-04-05 22:28:03', '0', '晴天、左转弯、车道跟随、较多阴影');
INSERT INTO `seed` VALUES (9, 'seed_0_0_6.xosc', 7, '2023-04-05 22:28:15', '0', '晴天、直行+左转、车道跟随、前方山坡+较多阴影');

-- ----------------------------
-- Table structure for sim_result
-- ----------------------------
DROP TABLE IF EXISTS `sim_result`;
CREATE TABLE `sim_result`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `seed_id` int NOT NULL,
  `author` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `create_date` datetime NOT NULL,
  `task_status` int NOT NULL,
  `task_desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sim_result
-- ----------------------------
INSERT INTO `sim_result` VALUES (2, 'Simulation_1', 4, 'admin', '2023-04-06 00:00:00', 2, '晴天、右转弯、车道跟随、前方树木');
INSERT INTO `sim_result` VALUES (3, 'Simulation_2', 9, 'admin', '2023-04-06 22:39:51', 2, '晴天、直行 左转、车道跟随、前方山坡 较多阴影.');
INSERT INTO `sim_result` VALUES (7, 'seed_0_0_5.xosc Simulation', 8, 'admin', '2023-04-07 00:32:15', 2, '晴天、左转弯、车道跟随、较多阴影');
INSERT INTO `sim_result` VALUES (9, 'seed_0_0_1.xosc Simulation', 4, 'admin', '2023-04-07 02:49:14', 1, '晴天、右转弯、车道跟随、前方树木');

-- ----------------------------
-- Table structure for test_task
-- ----------------------------
DROP TABLE IF EXISTS `test_task`;
CREATE TABLE `test_task`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `config_id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `model_cnt` int NOT NULL,
  `seed_cnt` int NOT NULL,
  `operator_cnt` int NOT NULL,
  `creator` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `create_date` datetime NOT NULL,
  `task_status` int NOT NULL,
  `task_progress` int NOT NULL,
  `desc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of test_task
-- ----------------------------
INSERT INTO `test_task` VALUES (18, 22, 'DaveV1Test', 1, 6, 3, 'admin', '2023-04-07 03:20:45', 2, 0, 'Dave_v1、原始种子、车辆颜色+时间+雾天算子、错误数+错误种类测试');
INSERT INTO `test_task` VALUES (19, 23, 'Dave_v2', 1, 6, 2, 'admin', '2023-04-07 03:21:15', 2, 0, 'Dave_v2、原始种子、光照强度+雨天算子、错误数测试');
INSERT INTO `test_task` VALUES (20, 24, 'Dave_v3', 1, 6, 5, 'admin', '2023-04-07 03:21:34', 2, 0, 'Dave_v3、原始种子、全算子、错误种类测试');
INSERT INTO `test_task` VALUES (21, 25, 'Epoch', 1, 6, 5, 'admin', '2023-04-07 03:21:54', 2, 0, 'Epoch、原始种子、全算子、错误数+错误种类测试');
INSERT INTO `test_task` VALUES (22, 26, 'FullTest', 4, 6, 5, 'admin', '2023-04-07 03:23:12', 2, 0, '全模型、原始种子、全算子、错误数+错误种类 测试');

SET FOREIGN_KEY_CHECKS = 1;