sUwZbbkE

1-- MySQL dump 10.13  Distrib 5.7.17, for macos10.12 (x86_64)
2--
3-- Host: 127.0.0.1    Database: source
4-- ------------------------------------------------------
5-- Server version	5.7.20
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `BATCH_JOB_EXECUTION`
20--
21
22DROP TABLE IF EXISTS `BATCH_JOB_EXECUTION`;
23/*!40101 SET @saved_cs_client     = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `BATCH_JOB_EXECUTION` (
26  `JOB_EXECUTION_ID` bigint(20) NOT NULL,
27  `VERSION` bigint(20) DEFAULT NULL,
28  `JOB_INSTANCE_ID` bigint(20) NOT NULL,
29  `CREATE_TIME` datetime NOT NULL,
30  `START_TIME` datetime DEFAULT NULL,
31  `END_TIME` datetime DEFAULT NULL,
32  `STATUS` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
33  `EXIT_CODE` varchar(2500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
34  `EXIT_MESSAGE` varchar(2500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
35  `LAST_UPDATED` datetime DEFAULT NULL,
36  `JOB_CONFIGURATION_LOCATION` varchar(2500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
37  PRIMARY KEY (`JOB_EXECUTION_ID`),
38  KEY `JOB_INST_EXEC_FK` (`JOB_INSTANCE_ID`),
39  CONSTRAINT `JOB_INST_EXEC_FK` FOREIGN KEY (`JOB_INSTANCE_ID`) REFERENCES `BATCH_JOB_INSTANCE` (`JOB_INSTANCE_ID`)
40) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
41/*!40101 SET character_set_client = @saved_cs_client */;
42
43--
44-- Dumping data for table `BATCH_JOB_EXECUTION`
45--
46
47LOCK TABLES `BATCH_JOB_EXECUTION` WRITE;
48/*!40000 ALTER TABLE `BATCH_JOB_EXECUTION` DISABLE KEYS */;
49/*!40000 ALTER TABLE `BATCH_JOB_EXECUTION` ENABLE KEYS */;
50UNLOCK TABLES;
51
52--
53-- Table structure for table `BATCH_JOB_EXECUTION_CONTEXT`
54--
55
56DROP TABLE IF EXISTS `BATCH_JOB_EXECUTION_CONTEXT`;
57/*!40101 SET @saved_cs_client     = @@character_set_client */;
58/*!40101 SET character_set_client = utf8 */;
59CREATE TABLE `BATCH_JOB_EXECUTION_CONTEXT` (
60  `JOB_EXECUTION_ID` bigint(20) NOT NULL,
61  `SHORT_CONTEXT` varchar(2500) COLLATE utf8mb4_unicode_ci NOT NULL,
62  `SERIALIZED_CONTEXT` text COLLATE utf8mb4_unicode_ci,
63  PRIMARY KEY (`JOB_EXECUTION_ID`),
64  CONSTRAINT `JOB_EXEC_CTX_FK` FOREIGN KEY (`JOB_EXECUTION_ID`) REFERENCES `BATCH_JOB_EXECUTION` (`JOB_EXECUTION_ID`)
65) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
66/*!40101 SET character_set_client = @saved_cs_client */;
67
68--
69-- Dumping data for table `BATCH_JOB_EXECUTION_CONTEXT`
70--
71
72LOCK TABLES `BATCH_JOB_EXECUTION_CONTEXT` WRITE;
73/*!40000 ALTER TABLE `BATCH_JOB_EXECUTION_CONTEXT` DISABLE KEYS */;
74/*!40000 ALTER TABLE `BATCH_JOB_EXECUTION_CONTEXT` ENABLE KEYS */;
75UNLOCK TABLES;
76
77--
78-- Table structure for table `BATCH_JOB_EXECUTION_PARAMS`
79--
80
81DROP TABLE IF EXISTS `BATCH_JOB_EXECUTION_PARAMS`;
82/*!40101 SET @saved_cs_client     = @@character_set_client */;
83/*!40101 SET character_set_client = utf8 */;
84CREATE TABLE `BATCH_JOB_EXECUTION_PARAMS` (
85  `JOB_EXECUTION_ID` bigint(20) NOT NULL,
86  `TYPE_CD` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
87  `KEY_NAME` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
88  `STRING_VAL` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
89  `DATE_VAL` datetime DEFAULT NULL,
90  `LONG_VAL` bigint(20) DEFAULT NULL,
91  `DOUBLE_VAL` double DEFAULT NULL,
92  `IDENTIFYING` char(1) COLLATE utf8mb4_unicode_ci NOT NULL,
93  KEY `JOB_EXEC_PARAMS_FK` (`JOB_EXECUTION_ID`),
94  CONSTRAINT `JOB_EXEC_PARAMS_FK` FOREIGN KEY (`JOB_EXECUTION_ID`) REFERENCES `BATCH_JOB_EXECUTION` (`JOB_EXECUTION_ID`)
95) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
96/*!40101 SET character_set_client = @saved_cs_client */;
97
98--
99-- Dumping data for table `BATCH_JOB_EXECUTION_PARAMS`
100--
101
102LOCK TABLES `BATCH_JOB_EXECUTION_PARAMS` WRITE;
103/*!40000 ALTER TABLE `BATCH_JOB_EXECUTION_PARAMS` DISABLE KEYS */;
104/*!40000 ALTER TABLE `BATCH_JOB_EXECUTION_PARAMS` ENABLE KEYS */;
105UNLOCK TABLES;
106
107--
108-- Table structure for table `BATCH_JOB_EXECUTION_SEQ`
109--
110
111DROP TABLE IF EXISTS `BATCH_JOB_EXECUTION_SEQ`;
112/*!40101 SET @saved_cs_client     = @@character_set_client */;
113/*!40101 SET character_set_client = utf8 */;
114CREATE TABLE `BATCH_JOB_EXECUTION_SEQ` (
115  `ID` bigint(20) NOT NULL,
116  `UNIQUE_KEY` char(1) COLLATE utf8mb4_unicode_ci NOT NULL,
117  UNIQUE KEY `UNIQUE_KEY_UN` (`UNIQUE_KEY`)
118) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
119/*!40101 SET character_set_client = @saved_cs_client */;
120
121--
122-- Dumping data for table `BATCH_JOB_EXECUTION_SEQ`
123--
124
125LOCK TABLES `BATCH_JOB_EXECUTION_SEQ` WRITE;
126/*!40000 ALTER TABLE `BATCH_JOB_EXECUTION_SEQ` DISABLE KEYS */;
127INSERT INTO `BATCH_JOB_EXECUTION_SEQ` VALUES (0,'0');
128/*!40000 ALTER TABLE `BATCH_JOB_EXECUTION_SEQ` ENABLE KEYS */;
129UNLOCK TABLES;
130
131--
132-- Table structure for table `BATCH_JOB_INSTANCE`
133--
134
135DROP TABLE IF EXISTS `BATCH_JOB_INSTANCE`;
136/*!40101 SET @saved_cs_client     = @@character_set_client */;
137/*!40101 SET character_set_client = utf8 */;
138CREATE TABLE `BATCH_JOB_INSTANCE` (
139  `JOB_INSTANCE_ID` bigint(20) NOT NULL,
140  `VERSION` bigint(20) DEFAULT NULL,
141  `JOB_NAME` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
142  `JOB_KEY` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
143  PRIMARY KEY (`JOB_INSTANCE_ID`),
144  UNIQUE KEY `JOB_INST_UN` (`JOB_NAME`,`JOB_KEY`)
145) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
146/*!40101 SET character_set_client = @saved_cs_client */;
147
148--
149-- Dumping data for table `BATCH_JOB_INSTANCE`
150--
151
152LOCK TABLES `BATCH_JOB_INSTANCE` WRITE;
153/*!40000 ALTER TABLE `BATCH_JOB_INSTANCE` DISABLE KEYS */;
154/*!40000 ALTER TABLE `BATCH_JOB_INSTANCE` ENABLE KEYS */;
155UNLOCK TABLES;
156
157--
158-- Table structure for table `BATCH_JOB_SEQ`
159--
160
161DROP TABLE IF EXISTS `BATCH_JOB_SEQ`;
162/*!40101 SET @saved_cs_client     = @@character_set_client */;
163/*!40101 SET character_set_client = utf8 */;
164CREATE TABLE `BATCH_JOB_SEQ` (
165  `ID` bigint(20) NOT NULL,
166  `UNIQUE_KEY` char(1) COLLATE utf8mb4_unicode_ci NOT NULL,
167  UNIQUE KEY `UNIQUE_KEY_UN` (`UNIQUE_KEY`)
168) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
169/*!40101 SET character_set_client = @saved_cs_client */;
170
171--
172-- Dumping data for table `BATCH_JOB_SEQ`
173--
174
175LOCK TABLES `BATCH_JOB_SEQ` WRITE;
176/*!40000 ALTER TABLE `BATCH_JOB_SEQ` DISABLE KEYS */;
177INSERT INTO `BATCH_JOB_SEQ` VALUES (0,'0');
178/*!40000 ALTER TABLE `BATCH_JOB_SEQ` ENABLE KEYS */;
179UNLOCK TABLES;
180
181--
182-- Table structure for table `BATCH_STEP_EXECUTION`
183--
184
185DROP TABLE IF EXISTS `BATCH_STEP_EXECUTION`;
186/*!40101 SET @saved_cs_client     = @@character_set_client */;
187/*!40101 SET character_set_client = utf8 */;
188CREATE TABLE `BATCH_STEP_EXECUTION` (
189  `STEP_EXECUTION_ID` bigint(20) NOT NULL,
190  `VERSION` bigint(20) NOT NULL,
191  `STEP_NAME` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
192  `JOB_EXECUTION_ID` bigint(20) NOT NULL,
193  `START_TIME` datetime NOT NULL,
194  `END_TIME` datetime DEFAULT NULL,
195  `STATUS` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
196  `COMMIT_COUNT` bigint(20) DEFAULT NULL,
197  `READ_COUNT` bigint(20) DEFAULT NULL,
198  `FILTER_COUNT` bigint(20) DEFAULT NULL,
199  `WRITE_COUNT` bigint(20) DEFAULT NULL,
200  `READ_SKIP_COUNT` bigint(20) DEFAULT NULL,
201  `WRITE_SKIP_COUNT` bigint(20) DEFAULT NULL,
202  `PROCESS_SKIP_COUNT` bigint(20) DEFAULT NULL,
203  `ROLLBACK_COUNT` bigint(20) DEFAULT NULL,
204  `EXIT_CODE` varchar(2500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
205  `EXIT_MESSAGE` varchar(2500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
206  `LAST_UPDATED` datetime DEFAULT NULL,
207  PRIMARY KEY (`STEP_EXECUTION_ID`),
208  KEY `JOB_EXEC_STEP_FK` (`JOB_EXECUTION_ID`),
209  CONSTRAINT `JOB_EXEC_STEP_FK` FOREIGN KEY (`JOB_EXECUTION_ID`) REFERENCES `BATCH_JOB_EXECUTION` (`JOB_EXECUTION_ID`)
210) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
211/*!40101 SET character_set_client = @saved_cs_client */;
212
213--
214-- Dumping data for table `BATCH_STEP_EXECUTION`
215--
216
217LOCK TABLES `BATCH_STEP_EXECUTION` WRITE;
218/*!40000 ALTER TABLE `BATCH_STEP_EXECUTION` DISABLE KEYS */;
219/*!40000 ALTER TABLE `BATCH_STEP_EXECUTION` ENABLE KEYS */;
220UNLOCK TABLES;
221
222--
223-- Table structure for table `BATCH_STEP_EXECUTION_CONTEXT`
224--
225
226DROP TABLE IF EXISTS `BATCH_STEP_EXECUTION_CONTEXT`;
227/*!40101 SET @saved_cs_client     = @@character_set_client */;
228/*!40101 SET character_set_client = utf8 */;
229CREATE TABLE `BATCH_STEP_EXECUTION_CONTEXT` (
230  `STEP_EXECUTION_ID` bigint(20) NOT NULL,
231  `SHORT_CONTEXT` varchar(2500) COLLATE utf8mb4_unicode_ci NOT NULL,
232  `SERIALIZED_CONTEXT` text COLLATE utf8mb4_unicode_ci,
233  PRIMARY KEY (`STEP_EXECUTION_ID`),
234  CONSTRAINT `STEP_EXEC_CTX_FK` FOREIGN KEY (`STEP_EXECUTION_ID`) REFERENCES `BATCH_STEP_EXECUTION` (`STEP_EXECUTION_ID`)
235) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
236/*!40101 SET character_set_client = @saved_cs_client */;
237
238--
239-- Dumping data for table `BATCH_STEP_EXECUTION_CONTEXT`
240--
241
242LOCK TABLES `BATCH_STEP_EXECUTION_CONTEXT` WRITE;
243/*!40000 ALTER TABLE `BATCH_STEP_EXECUTION_CONTEXT` DISABLE KEYS */;
244/*!40000 ALTER TABLE `BATCH_STEP_EXECUTION_CONTEXT` ENABLE KEYS */;
245UNLOCK TABLES;
246
247--
248-- Table structure for table `BATCH_STEP_EXECUTION_SEQ`
249--
250
251DROP TABLE IF EXISTS `BATCH_STEP_EXECUTION_SEQ`;
252/*!40101 SET @saved_cs_client     = @@character_set_client */;
253/*!40101 SET character_set_client = utf8 */;
254CREATE TABLE `BATCH_STEP_EXECUTION_SEQ` (
255  `ID` bigint(20) NOT NULL,
256  `UNIQUE_KEY` char(1) COLLATE utf8mb4_unicode_ci NOT NULL,
257  UNIQUE KEY `UNIQUE_KEY_UN` (`UNIQUE_KEY`)
258) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
259/*!40101 SET character_set_client = @saved_cs_client */;
260
261--
262-- Dumping data for table `BATCH_STEP_EXECUTION_SEQ`
263--
264
265LOCK TABLES `BATCH_STEP_EXECUTION_SEQ` WRITE;
266/*!40000 ALTER TABLE `BATCH_STEP_EXECUTION_SEQ` DISABLE KEYS */;
267INSERT INTO `BATCH_STEP_EXECUTION_SEQ` VALUES (0,'0');
268/*!40000 ALTER TABLE `BATCH_STEP_EXECUTION_SEQ` ENABLE KEYS */;
269UNLOCK TABLES;
270
271--
272-- Table structure for table `s1_journal`
273--
274
275DROP TABLE IF EXISTS `s1_journal`;
276/*!40101 SET @saved_cs_client     = @@character_set_client */;
277/*!40101 SET character_set_client = utf8 */;
278CREATE TABLE `s1_journal` (
279  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
280  `type` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
281  `status` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
282  PRIMARY KEY (`id`)
283) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
284/*!40101 SET character_set_client = @saved_cs_client */;
285
286--
287-- Dumping data for table `s1_journal`
288--
289
290LOCK TABLES `s1_journal` WRITE;
291/*!40000 ALTER TABLE `s1_journal` DISABLE KEYS */;
292/*!40000 ALTER TABLE `s1_journal` ENABLE KEYS */;
293UNLOCK TABLES;
294
295--
296-- Table structure for table `s2_journal`
297--
298
299DROP TABLE IF EXISTS `s2_journal`;
300/*!40101 SET @saved_cs_client     = @@character_set_client */;
301/*!40101 SET character_set_client = utf8 */;
302CREATE TABLE `s2_journal` (
303  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
304  `type` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
305  `status` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
306  PRIMARY KEY (`id`)
307) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
308/*!40101 SET character_set_client = @saved_cs_client */;
309
310--
311-- Dumping data for table `s2_journal`
312--
313
314LOCK TABLES `s2_journal` WRITE;
315/*!40000 ALTER TABLE `s2_journal` DISABLE KEYS */;
316/*!40000 ALTER TABLE `s2_journal` ENABLE KEYS */;
317UNLOCK TABLES;
318
319--
320-- Table structure for table `s3_journal`
321--
322
323DROP TABLE IF EXISTS `s3_journal`;
324/*!40101 SET @saved_cs_client     = @@character_set_client */;
325/*!40101 SET character_set_client = utf8 */;
326CREATE TABLE `s3_journal` (
327  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
328  `type` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
329  `status` varchar(15) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
330  PRIMARY KEY (`id`)
331) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
332/*!40101 SET character_set_client = @saved_cs_client */;
333
334--
335-- Dumping data for table `s3_journal`
336--
337
338LOCK TABLES `s3_journal` WRITE;
339/*!40000 ALTER TABLE `s3_journal` DISABLE KEYS */;
340/*!40000 ALTER TABLE `s3_journal` ENABLE KEYS */;
341UNLOCK TABLES;
342
343--
344-- Table structure for table `source1`
345--
346
347DROP TABLE IF EXISTS `source1`;
348/*!40101 SET @saved_cs_client     = @@character_set_client */;
349/*!40101 SET character_set_client = utf8 */;
350CREATE TABLE `source1` (
351  `column_1` int(11) NOT NULL,
352  `column_2` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
353  `column_3` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
354  PRIMARY KEY (`column_1`,`column_2`)
355) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
356/*!40101 SET character_set_client = @saved_cs_client */;
357
358--
359-- Dumping data for table `source1`
360--
361
362LOCK TABLES `source1` WRITE;
363/*!40000 ALTER TABLE `source1` DISABLE KEYS */;
364/*!40000 ALTER TABLE `source1` ENABLE KEYS */;
365UNLOCK TABLES;
366
367--
368-- Table structure for table `source2`
369--
370
371DROP TABLE IF EXISTS `source2`;
372/*!40101 SET @saved_cs_client     = @@character_set_client */;
373/*!40101 SET character_set_client = utf8 */;
374CREATE TABLE `source2` (
375  `column_1` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
376  `column_2` int(11) DEFAULT NULL,
377  PRIMARY KEY (`column_1`)
378) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
379/*!40101 SET character_set_client = @saved_cs_client */;
380
381--
382-- Dumping data for table `source2`
383--
384
385LOCK TABLES `source2` WRITE;
386/*!40000 ALTER TABLE `source2` DISABLE KEYS */;
387/*!40000 ALTER TABLE `source2` ENABLE KEYS */;
388UNLOCK TABLES;
389
390--
391-- Table structure for table `source3`
392--
393
394DROP TABLE IF EXISTS `source3`;
395/*!40101 SET @saved_cs_client     = @@character_set_client */;
396/*!40101 SET character_set_client = utf8 */;
397CREATE TABLE `source3` (
398  `column_31` varchar(2) COLLATE utf8mb4_unicode_ci NOT NULL,
399  `column_32` int(11) DEFAULT NULL,
400  PRIMARY KEY (`column_31`),
401  UNIQUE KEY `column_32_UNIQUE` (`column_32`)
402) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
403/*!40101 SET character_set_client = @saved_cs_client */;
404
405--
406-- Dumping data for table `source3`
407--
408
409LOCK TABLES `source3` WRITE;
410/*!40000 ALTER TABLE `source3` DISABLE KEYS */;
411/*!40000 ALTER TABLE `source3` ENABLE KEYS */;
412UNLOCK TABLES;
413/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
414
415/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
416/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
417/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
418/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
419/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
420/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
421/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
422
423-- Dump completed on 2018-07-25  1:53:39