Home Esplora Aiuto
Registrati Accedi
sanoh
/
G01_0350
2
0
Forka 0
File Problemi 0 Pull Requests 0 Wiki
Albero (Tree): 86cc1b8a84
Rami (Branch) Tag
G01_0350
/
sql
/
G01_0350.sql

G01_0350.sql 11 KB
Cronologia Originale

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187 
  1. -- MySQL dump 10.13  Distrib 8.0.26, for Win64 (x86_64)
    2. 

  2. --
    3. 

  3. -- Host: localhost    Database: G01_0350
    4. 

  4. -- ------------------------------------------------------
    5. 

  5. -- Server version	8.0.26
    6. 

  6. 

  7. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
    8. 

  8. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
    9. 

  9. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
    10. 

  10. /*!50503 SET NAMES utf8mb4 */;
    11. 

  11. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
    12. 

  12. /*!40103 SET TIME_ZONE='+00:00' */;
    13. 

  13. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
    14. 

  14. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
    15. 

  15. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
    16. 

  16. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
    17. 

  17. 

  18. --
    19. 

  19. -- Table structure for table `order_tbl`
    20. 

  20. --
    21. 

  21. 

  22. DROP TABLE IF EXISTS `order_tbl`;
    23. 

  23. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    24. 

  24. /*!50503 SET character_set_client = utf8mb4 */;
    25. 

  25. CREATE TABLE `order_tbl` (
    26. 

  26.   `id` int unsigned NOT NULL AUTO_INCREMENT,
    27. 

  27.   `order_num` varchar(30) NOT NULL,
    28. 

  28.   `product_idx` int NOT NULL,
    29. 

  29.   `product_name` varchar(30) NOT NULL,
    30. 

  30.   `batch` varchar(10) NOT NULL,
    31. 

  31.   `team` varchar(2) NOT NULL,
    32. 

  32.   `ok` int NOT NULL,
    33. 

  33.   `ng` int NOT NULL,
    34. 

  34.   `targe` int NOT NULL,
    35. 

  35.   `snp` int NOT NULL,
    36. 

  36.   `begin_time` bigint NOT NULL,
    37. 

  37.   `end_time` bigint DEFAULT NULL,
    38. 

  38.   `stat` tinyint(1) NOT NULL,
    39. 

  39.   PRIMARY KEY (`id`)
    40. 

  40. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;
    41. 

  41. /*!40101 SET character_set_client = @saved_cs_client */;
    42. 

  42. 

  43. --
    44. 

  44. -- Dumping data for table `order_tbl`
    45. 

  45. --
    46. 

  46. 

  47. LOCK TABLES `order_tbl` WRITE;
    48. 

  48. /*!40000 ALTER TABLE `order_tbl` DISABLE KEYS */;
    49. 

  49. INSERT INTO `order_tbl` VALUES (1,'2GN20211008095506A01',0,'17700 20-31PA-H020-M','LX08','A',13,1,14,0,1633658109,1633747618,1),(2,'2GN20211009104653A01',0,'17700-TLA-X010','LX09','A',8,0,8,0,1633747618,1633920025,1),(3,'2GN20211011104019A01',0,'17700-TLA-X010','LX11','A',2,0,2,0,1633920025,NULL,0);
    50. 

  50. /*!40000 ALTER TABLE `order_tbl` ENABLE KEYS */;
    51. 

  51. UNLOCK TABLES;
    52. 

  52. 

  53. --
    54. 

  54. -- Table structure for table `product_data_tbl`
    55. 

  55. --
    56. 

  56. 

  57. DROP TABLE IF EXISTS `product_data_tbl`;
    58. 

  58. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    59. 

  59. /*!50503 SET character_set_client = utf8mb4 */;
    60. 

  60. CREATE TABLE `product_data_tbl` (
    61. 

  61.   `id` int unsigned NOT NULL AUTO_INCREMENT,
    62. 

  62.   `batch` varchar(20) NOT NULL,
    63. 

  63.   `serial` varchar(20) NOT NULL,
    64. 

  64.   `product_name` varchar(30) NOT NULL,
    65. 

  65.   `testok` tinyint(1) NOT NULL,
    66. 

  66.   `data_17700` varchar(50) NOT NULL,
    67. 

  67.   `data_17720` varchar(50) NOT NULL,
    68. 

  68.   `team` varchar(2) NOT NULL,
    69. 

  69.   `tester` varchar(10) NOT NULL,
    70. 

  70.   `begin_time` bigint NOT NULL,
    71. 

  71.   `end_time` bigint NOT NULL,
    72. 

  72.   `stat` tinyint(1) NOT NULL,
    73. 

  73.   PRIMARY KEY (`id`),
    74. 

  74.   KEY `batch_index` (`batch`(12))
    75. 

  75. ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb3;
    76. 

  76. /*!40101 SET character_set_client = @saved_cs_client */;
    77. 

  77. 

  78. --
    79. 

  79. -- Dumping data for table `product_data_tbl`
    80. 

  80. --
    81. 

  81. 

  82. LOCK TABLES `product_data_tbl` WRITE;
    83. 

  83. /*!40000 ALTER TABLE `product_data_tbl` DISABLE KEYS */;
    84. 

  84. INSERT INTO `product_data_tbl` VALUES (1,'2GNLX080001A','2021100800001','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):0.084 ml/min','<02>:0.500 MPa:(OK):0.259 ml/min','A','tester',1633659014,1633659086,1),(2,'2GNLX080002A','2021100800002','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):-0.060 ml/min','<02>:0.500 MPa:(OK):0.053 ml/min','A','tester',1633659430,1633659536,1),(3,'2GNLX080003A','2021100800003','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):-0.060 ml/min','<02>:0.500 MPa:(OK):0.107 ml/min','A','tester',1633659843,1633659863,1),(4,'NULL','2021100800004','17700 20-31PA-H020-M',0,'NULL','NULL','A','tester',1633660051,1633660051,1),(5,'2GNLX080004A','2021100800005','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):0.084 ml/min','<02>:0.500 MPa:(OK):0.097 ml/min','A','tester',1633660139,1633660165,1),(6,'2GNLX080005A','2021100800006','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):0.109 ml/min','<02>:0.500 MPa:(OK):0.215 ml/min','A','tester',1633660595,1633660602,1),(7,'2GNLX080006A','2021100800007','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):-0.085 ml/min','<02>:0.500 MPa:(OK):0.039 ml/min','A','tester',1633660719,1633660728,1),(8,'2GNLX080007A','2021100800008','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):0.016 ml/min','<02>:0.499 MPa:(OK):0.141 ml/min','A','tester',1633660814,1633660822,1),(9,'2GNLX080008A','2021100800009','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):0.042 ml/min','<02>:0.499 MPa:(OK):0.195 ml/min','A','tester',1633661056,1633661063,1),(10,'2GNLX080009A','2021100800010','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):-0.068 ml/min','<02>:0.500 MPa:(OK):0.122 ml/min','A','tester',1633661224,1633661231,1),(11,'2GNLX080010A','2021100800011','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):0.016 ml/min','<02>:0.500 MPa:(OK):0.171 ml/min','A','tester',1633662707,1633662716,1),(12,'2GNLX080011A','2021100800012','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):0.008 ml/min','<02>:0.499 MPa:(OK):0.156 ml/min','A','tester',1633663308,1633663317,1),(13,'2GNLX080012A','2021100800013','17700 20-31PA-H020-M',1,'<02>:0.200 MPa:(OK):-0.043 ml/min','<02>:0.500 MPa:(OK):0.068 ml/min','A','tester',1633663731,1633663783,1),(14,'2GNLX080013A','2021100800014','17700 20-31PA-H020-M',1,'<02>:0.211 MPa:(OK):0.015 ml/min','<02>:0.520 MPa:(OK):0.210 ml/min','A','tester',1633678504,1633678512,1),(15,'NULL','2021100800015','17700 20-31PA-H020-M',0,'NULL','NULL','A','tester',1633678552,1633678552,0),(16,'2GNLX090001A','2021100900001','17750-31PA-H020-M1',1,'<02>:0.210 MPa:(OK):0.190 ml/min','<02>:0.520 MPa:(OK):0.371 ml/min','A','tester',1633748095,1633748103,1),(17,'2GNLX090002A','2021100900002','17750-31PA-H020-M1',1,'<02>:0.210 MPa:(OK):-0.016 ml/min','<02>:0.520 MPa:(OK):0.127 ml/min','A','tester',1633759064,1633759072,1),(18,'2GNLX090003A','2021100900003','17750-31PA-H020-M1',1,'<02>:0.210 MPa:(OK):-0.069 ml/min','<02>:0.520 MPa:(OK):-0.005 ml/min','A','tester',1633759109,1633759230,1),(19,'2GNLX090004A','2021100900004','17750-31PA-H020-M1',1,'<02>:0.210 MPa:(OK):-0.069 ml/min','<02>:0.520 MPa:(OK):-0.005 ml/min','A','tester',1633759230,1633759231,1),(20,'2GNLX090005A','2021100900005','17750-31PA-H020-M1',1,'<02>:0.210 MPa:(OK):-0.069 ml/min','<02>:0.520 MPa:(OK):-0.005 ml/min','A','tester',1633759231,1633759232,1),(21,'2GNLX090006A','2021100900006','17750-31PA-H020-M1',1,'<02>:0.210 MPa:(OK):-0.069 ml/min','<02>:0.520 MPa:(OK):-0.005 ml/min','A','tester',1633759232,1633759234,1),(22,'2GNLX090007A','2021100900007','17750-31PA-H020-M1',1,'<02>:0.210 MPa:(OK):-0.069 ml/min','<02>:0.520 MPa:(OK):-0.005 ml/min','A','tester',1633759234,1633759235,1),(23,'2GNLX090008A','2021100900008','17750-31PA-H020-M1',1,'<02>:0.210 MPa:(OK):-0.069 ml/min','<02>:0.520 MPa:(OK):-0.005 ml/min','A','tester',1633759235,1633759236,1),(24,'NULL','2021100900009','17750-31PA-H020-M1',0,'NULL','NULL','A','tester',1633759237,1633759237,0),(25,'2GNLX110001A','2021101100001','17750-31PA-H020-M1',1,'<02>:0.209 MPa:(OK):0.045 ml/min','<02>:0.521 MPa:(OK):0.229 ml/min','A','tester',1633931879,1633931887,1),(26,'2GNLX110002A','2021101100002','17750-31PA-H020-M1',1,'<02>:0.209 MPa:(OK):-0.008 ml/min','<02>:0.520 MPa:(OK):0.087 ml/min','A','tester',1633931985,1633931995,1);
    85. 

  85. /*!40000 ALTER TABLE `product_data_tbl` ENABLE KEYS */;
    86. 

  86. UNLOCK TABLES;
    87. 

  87. 

  88. --
    89. 

  89. -- Table structure for table `product_param_tbl`
    90. 

  90. --
    91. 

  91. 

  92. DROP TABLE IF EXISTS `product_param_tbl`;
    93. 

  93. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    94. 

  94. /*!50503 SET character_set_client = utf8mb4 */;
    95. 

  95. CREATE TABLE `product_param_tbl` (
    96. 

  96.   `id` int unsigned NOT NULL AUTO_INCREMENT,
    97. 

  97.   `product_idx` int NOT NULL,
    98. 

  98.   `product_name` varchar(30) NOT NULL,
    99. 

  99.   `param_type` int NOT NULL,
    100. 

  100.   `startuptime` varchar(10) DEFAULT NULL,
    101. 

  101.   `airtime` varchar(10) DEFAULT NULL,
    102. 

  102.   `presstime` varchar(10) DEFAULT NULL,
    103. 

  103.   `testtime` varchar(10) DEFAULT NULL,
    104. 

  104.   `exhaust` varchar(10) DEFAULT NULL,
    105. 

  105.   `maxpress` varchar(10) DEFAULT NULL,
    106. 

  106.   `minpress` varchar(10) DEFAULT NULL,
    107. 

  107.   `setpress` varchar(10) DEFAULT NULL,
    108. 

  108.   `capacity` varchar(10) DEFAULT NULL,
    109. 

  109.   `posthreshold` varchar(10) DEFAULT NULL,
    110. 

  110.   `pnegthreshold` varchar(10) DEFAULT NULL,
    111. 

  111.   PRIMARY KEY (`id`)
    112. 

  112. ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3;
    113. 

  113. /*!40101 SET character_set_client = @saved_cs_client */;
    114. 

  114. 

  115. --
    116. 

  116. -- Dumping data for table `product_param_tbl`
    117. 

  117. --
    118. 

  118. 

  119. LOCK TABLES `product_param_tbl` WRITE;
    120. 

  120. /*!40000 ALTER TABLE `product_param_tbl` DISABLE KEYS */;
    121. 

  121. INSERT INTO `product_param_tbl` VALUES (1,1,'17700 20-31PA-H020-M',17700,'0','0','0','0','0','0','0','0','0','0','0'),(2,1,'17700 20-31PA-H020-M',17720,'0','0','0','0','0','0','0','0','0','0','0'),(3,1,'17700-TLA-X010',17700,'0','0','0','0','0','0','0','0','0','0','0'),(4,1,'17700-TLA-X010',17720,'0','0','0','0','0','0','0','0','0','0','0'),(5,0,'17750-31PA-H020-M1',17700,'0','8','20','10','1','600','0','500','105','0.5','-0.5'),(6,0,'17750-31PA-H020-M1',17720,'0','8','20','10','1','250','0','200','105','0.1','-0.1');
    122. 

  122. /*!40000 ALTER TABLE `product_param_tbl` ENABLE KEYS */;
    123. 

  123. UNLOCK TABLES;
    124. 

  124. 

  125. --
    126. 

  126. -- Table structure for table `product_tbl`
    127. 

  127. --
    128. 

  128. 

  129. DROP TABLE IF EXISTS `product_tbl`;
    130. 

  130. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    131. 

  131. /*!50503 SET character_set_client = utf8mb4 */;
    132. 

  132. CREATE TABLE `product_tbl` (
    133. 

  133.   `id` int unsigned NOT NULL AUTO_INCREMENT,
    134. 

  134.   `product_idx` int NOT NULL,
    135. 

  135.   `product_name` varchar(30) NOT NULL,
    136. 

  136.   `17700_name` varchar(30) NOT NULL,
    137. 

  137.   `17720_name` varchar(30) NOT NULL,
    138. 

  138.   `stat` tinyint(1) NOT NULL,
    139. 

  139.   PRIMARY KEY (`id`)
    140. 

  140. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;
    141. 

  141. /*!40101 SET character_set_client = @saved_cs_client */;
    142. 

  142. 

  143. --
    144. 

  144. -- Dumping data for table `product_tbl`
    145. 

  145. --
    146. 

  146. 

  147. LOCK TABLES `product_tbl` WRITE;
    148. 

  148. /*!40000 ALTER TABLE `product_tbl` DISABLE KEYS */;
    149. 

  149. INSERT INTO `product_tbl` VALUES (1,0,'17750-31PA-H020-M1','17700-31PA','17720-31PA',1);
    150. 

  150. /*!40000 ALTER TABLE `product_tbl` ENABLE KEYS */;
    151. 

  151. UNLOCK TABLES;
    152. 

  152. 

  153. --
    154. 

  154. -- Table structure for table `user_tbl`
    155. 

  155. --
    156. 

  156. 

  157. DROP TABLE IF EXISTS `user_tbl`;
    158. 

  158. /*!40101 SET @saved_cs_client     = @@character_set_client */;
    159. 

  159. /*!50503 SET character_set_client = utf8mb4 */;
    160. 

  160. CREATE TABLE `user_tbl` (
    161. 

  161.   `id` int unsigned NOT NULL AUTO_INCREMENT,
    162. 

  162.   `name` varchar(20) NOT NULL,
    163. 

  163.   `password` varchar(100) DEFAULT NULL,
    164. 

  164.   PRIMARY KEY (`id`)
    165. 

  165. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;
    166. 

  166. /*!40101 SET character_set_client = @saved_cs_client */;
    167. 

  167. 

  168. --
    169. 

  169. -- Dumping data for table `user_tbl`
    170. 

  170. --
    171. 

  171. 

  172. LOCK TABLES `user_tbl` WRITE;
    173. 

  173. /*!40000 ALTER TABLE `user_tbl` DISABLE KEYS */;
    174. 

  174. INSERT INTO `user_tbl` VALUES (1,'admin','123456');
    175. 

  175. /*!40000 ALTER TABLE `user_tbl` ENABLE KEYS */;
    176. 

  176. UNLOCK TABLES;
    177. 

  177. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
    178. 

  178. 

  179. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
    180. 

  180. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
    181. 

  181. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
    182. 

  182. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
    183. 

  183. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
    184. 

  184. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    185. 

  185. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
    186. 

  186. 

  187. -- Dump completed on 2021-10-11 17:55:34
    188.