You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
72 lines
5.5 KiB
72 lines
5.5 KiB
-- MySQL dump 10.13 Distrib 8.0.28, for Win64 (x86_64)
|
|
--
|
|
-- Host: localhost Database: zsjy
|
|
-- ------------------------------------------------------
|
|
-- Server version 8.0.28
|
|
|
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
|
/*!50503 SET NAMES utf8 */;
|
|
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
|
/*!40103 SET TIME_ZONE='+00:00' */;
|
|
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
|
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
|
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
|
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
|
|
|
--
|
|
-- Table structure for table `testresult`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `testresult`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!50503 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `testresult` (
|
|
`id` int NOT NULL AUTO_INCREMENT,
|
|
`user_id` varchar(45) DEFAULT NULL,
|
|
`test_date` varchar(45) NOT NULL,
|
|
`image_file_name` varchar(100) DEFAULT NULL,
|
|
`image_file_path` varchar(200) DEFAULT NULL,
|
|
`c1` varchar(45) DEFAULT NULL,
|
|
`c2` varchar(45) DEFAULT NULL,
|
|
`c3` varchar(45) DEFAULT NULL,
|
|
`c4` varchar(45) DEFAULT NULL,
|
|
`c5` varchar(45) DEFAULT NULL,
|
|
`c6` varchar(45) DEFAULT NULL,
|
|
`c1_rgb` varchar(45) DEFAULT NULL,
|
|
`c2_rgb` varchar(45) DEFAULT NULL,
|
|
`c3_rgb` varchar(45) DEFAULT NULL,
|
|
`c4_rgb` varchar(45) DEFAULT NULL,
|
|
`c5_rgb` varchar(45) DEFAULT NULL,
|
|
`c6_rgb` varchar(45) DEFAULT NULL,
|
|
`c1_color` varchar(45) DEFAULT NULL,
|
|
`c2_color` varchar(45) DEFAULT NULL,
|
|
`c3_color` varchar(45) DEFAULT NULL,
|
|
`c4_color` varchar(45) DEFAULT NULL,
|
|
`c5_color` varchar(45) DEFAULT NULL,
|
|
`c6_color` varchar(45) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping data for table `testresult`
|
|
--
|
|
|
|
LOCK TABLES `testresult` WRITE;
|
|
/*!40000 ALTER TABLE `testresult` DISABLE KEYS */;
|
|
INSERT INTO `testresult` VALUES (5,'123456','2022-11-24','123456_2022-11-24','D:/apache-tomcat-8.5.81/webapps/test_result_image/','31.657646091796707','13.665322544722514','41.21116463345935','68.08945547471761','2.5918857551005643','31.754715086577406','115_117_117','133_138_140','106_110_111','97_102_75','118_121_120','116_117_116','#737575','#858a8c','#6a6e6f','#61664b','#767978','#747574'),(6,'123456','2022-11-24','123456_2022-11-24','D:/apache-tomcat-8.5.81/webapps/test_result_image/','0.0','0.0','0.0','0.0','0.0','0.0','152_144_155','111_126_134','97_99_106','104_60_72','108_54_66','135_102_122','#98909b','#6f7e86','#61636a','#683c48','#6c3642','#87667a'),(7,'123456','2022-11-24','123456_2022-11-24','D:/apache-tomcat-8.5.81/webapps/test_result_image/','0.0','0.0','0.0','0.0','0.0','0.0','150_143_155','110_126_134','96_99_105','104_60_72','108_53_66','135_101_121','#968f9b','#6e7e86','#606369','#683c48','#6c3542','#876579'),(8,'123456','2022-11-24','123456_2022-11-24','D:/apache-tomcat-8.5.81/webapps/test_result_image/','0.0','0.0','0.0','0.0','0.0','0.0','150_143_155','111_126_134','96_99_106','104_60_72','108_54_67','134_102_122','#968f9b','#6f7e86','#60636a','#683c48','#6c3643','#86667a'),(9,'123456','2022-11-24','123456_2022-11-24','D:/apache-tomcat-8.5.81/webapps/test_result_image/','0.0','0.0','0.0','0.0','0.0','0.0','128_84_92','111_79_82','99_53_59','121_63_69','109_59_67','106_74_79','#80545c','#6f4f52','#63353b','#793f45','#6d3b43','#6a4a4f'),(10,'123456','2022-11-24','123456_2022-11-24','D:/apache-tomcat-8.5.81/webapps/test_result_image/','0.0','0.0','0.0','0.0','0.0','0.0','155_104_116','137_98_103','127_61_70','155_75_84','142_67_80','133_87_99','#9b6874','#896267','#7f3d46','#9b4b54','#8e4350','#855763'),(11,'123456','2022-11-24','123456_2022-11-24','D:/apache-tomcat-8.5.81/webapps/test_result_image/','0.0','0.0','0.0','0.0','0.0','0.0','114_78_84','98_74_76','86_53_57','106_61_64','95_57_62','95_69_72','#724e54','#624a4c','#563539','#6a3d40','#5f393e','#5f4548'),(12,'123456','2022-11-25','123456_2022-11-25','D:/apache-tomcat-8.5.81/webapps/test_result_image/','0.0','0.0','0.0','0.0','0.0','0.0','127_91_91','121_98_98','112_69_70','124_83_83','113_79_81','108_80_84','#7f5b5b','#796262','#704546','#7c5353','#714f51','#6c5054'),(13,'123456','2022-11-25','123456_2022-11-25','D:/apache-tomcat-8.5.81/webapps/test_result_image/','0.0','0.0','0.0','0.0','0.0','0.0','191_185_185','188_189_187','184_187_183','189_188_183','186_187_184','183_184_184','#bfb9b9','#bcbdbb','#b8bbb7','#bdbcb7','#babbb8','#b7b8b8'),(14,'123456','2022-11-25','123456_2022-11-25','D:/apache-tomcat-8.5.81/webapps/test_result_image/','0.0','0.0','0.0','0.0','0.0','0.0','141_143_136','148_156_154','130_117_121','137_131_131','128_119_117','131_120_120','#8d8f88','#949c9a','#827579','#898383','#807775','#837878');
|
|
/*!40000 ALTER TABLE `testresult` ENABLE KEYS */;
|
|
UNLOCK TABLES;
|
|
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
|
|
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
|
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
|
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
|
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
|
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
|
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
|
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|
|
|
-- Dump completed on 2022-11-30 13:23:04
|