-- -- Table structure for table `T1` -- DROP TABLE IF EXISTS `T1`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `T1` ( `C01` bigint DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `T1` -- LOCK TABLES `T1` WRITE; /*!40000 ALTER TABLE `T1` DISABLE KEYS */; INSERT INTO `T1` VALUES (5000001),(5000002),(5000003),(5000004),(5000005),(5000006),(5000007),(5000008),(5000009),(5000010),(5000011),(5000012),(5000013),(5000014),(5000015),(5000016),(5000017),(5000018),(5000019),(5000020),(5000021),(5000022),(5000023),(5000024),(5000025),(5000026),(5000027),(5000028),(5000029),(5000030),(5000031),(5000032),(5000033),(5000034),(5000035),(5000036),(5000037),(5000038),(5000039),(5000040),(5000041),(5000042),(5000043),(5000044),(5000045),(5000046),(5000047),(5000048),(5000049),(5000050),(5000051),(5000052),(5000053),(5000054),(5000055),(5000056),(5000057),(5000058),(5000059),(5000060),(5000061),(5000062),(5000063),(5000064),(5000065),(5000066),(5000067),(5000068),(5000069),(5000070),(5000071),(5000072),(5000073),(5000074),(5000075),(5000076),(5000077),(5000078),(5000079),(5000080),(5000081),(5000082),(5000083),(5000084),(5000085),(5000086),(5000087),(5000088),(5000089),(5000090),(5000091),(5000092),(5000093),(5000094),(5000095),(5000096),(5000097),(5000098),(5000099),(5000100),(5000101),(5000102),(5000103),(5000104),(5000105),(5000106),(5000107),(5000108),(5000109),(5000110),(5000111),(5000112),(5000113),(5000114),(5000115),(5000116),(5000117),(5000118),(5000119),(5000120),(5000121),(5000122),(5000123),(5000124),(5000125),(5000126),(5000127),(5000128),(5000129),(5000130),(5000131),(5000132),(5000133),(5000134),(5000135),(5000136); /*!40000 ALTER TABLE `T1` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `T2` -- DROP TABLE IF EXISTS `T2`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `T2` ( `C02` date DEFAULT NULL, `C03` date DEFAULT NULL, `C01` bigint DEFAULT NULL, `C04` bigint DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `T2` -- LOCK TABLES `T2` WRITE; /*!40000 ALTER TABLE `T2` DISABLE KEYS */; INSERT INTO `T2` VALUES ('2013-04-01',NULL,5000001,600001),('2019-08-12',NULL,5000001,600031),('2019-08-12',NULL,5000001,600032),('2019-08-06',NULL,5000001,600003),('2020-08-01','2021-11-01',5000002,600025),('2020-08-01','2021-11-01',5000003,600026),('2020-08-01',NULL,5000002,600005),('2020-08-01',NULL,5000003,600007),('2020-12-11',NULL,5000002,600031),('2020-12-11',NULL,5000003,600031),('2020-12-11',NULL,5000002,600032),('2020-12-11',NULL,5000003,600032),('2021-01-14',NULL,5000002,600002),('2021-03-01','2021-03-01',5000002,600061),('2021-03-01','2021-03-01',5000002,600034),('2021-03-01','2021-03-17',5000003,600062),('2021-03-01','2021-03-17',5000003,600035),('2021-03-01',NULL,5000002,600016),('2021-03-01',NULL,5000002,600040),('2021-03-01',NULL,5000002,600028),('2021-03-17',NULL,5000003,600041),('2021-03-17',NULL,5000003,600029),('2021-03-17',NULL,5000003,600017),('2019-01-01',NULL,5000002,600003),('2019-01-01',NULL,5000003,600003),('2021-11-12',NULL,5000004,600003),('2021-11-12',NULL,5000004,600031),('2021-11-12',NULL,5000004,600032),('2021-11-12',NULL,5000005,600003),('2021-11-12',NULL,5000005,600031),('2021-11-12',NULL,5000005,600032),('2021-11-12',NULL,5000006,600003),('2021-11-12',NULL,5000006,600031),('2021-11-12',NULL,5000006,600032),('2021-11-12',NULL,5000007,600003),('2021-11-12',NULL,5000007,600031),('2021-11-12',NULL,5000007,600032),('2021-11-12',NULL,5000008,600003),('2021-11-12',NULL,5000008,600031),('2021-11-12',NULL,5000008,600032),('2021-11-12',NULL,5000009,600003),('2021-11-12',NULL,5000009,600031),('2021-11-12',NULL,5000009,600032),('2021-11-12',NULL,5000010,600003),('2021-11-12',NULL,5000010,600031),('2021-11-12',NULL,5000010,600032),('2021-11-12',NULL,5000011,600003),('2021-11-12',NULL,5000011,600031),('2021-11-12',NULL,5000011,600032),('2021-11-12',NULL,5000012,600003),('2021-11-12',NULL,5000012,600031),('2021-11-12',NULL,5000012,600032),('2021-11-12',NULL,5000013,600003),('2021-11-12',NULL,5000013,600031),('2021-11-12',NULL,5000013,600032),('2021-11-12',NULL,5000014,600003),('2021-11-12',NULL,5000014,600031),('2021-11-12',NULL,5000014,600032),('2021-11-12',NULL,5000015,600003),('2021-11-12',NULL,5000015,600031),('2021-11-12',NULL,5000015,600032),('2021-11-12',NULL,5000016,600003),('2021-11-12',NULL,5000016,600031),('2021-11-12',NULL,5000016,600032),('2021-11-12',NULL,5000017,600003),('2021-11-12',NULL,5000017,600031),('2021-11-12',NULL,5000017,600032),('2021-11-12',NULL,5000018,600003),('2021-11-12',NULL,5000018,600031),('2021-11-12',NULL,5000018,600032),('2021-11-12',NULL,5000019,600003),('2021-11-12',NULL,5000019,600031),('2021-11-12',NULL,5000019,600032),('2021-11-12',NULL,5000020,600003),('2021-11-12',NULL,5000020,600031),('2021-11-12',NULL,5000020,600032),('2021-11-12',NULL,5000021,600003),('2021-11-12',NULL,5000021,600031),('2021-11-12',NULL,5000021,600032),('2021-11-12',NULL,5000022,600003),('2021-11-12',NULL,5000022,600031),('2021-11-12',NULL,5000022,600032),('1970-01-01',NULL,5000023,600003),('1970-01-01',NULL,5000023,600031),('1970-01-01',NULL,5000023,600032),('1970-01-01',NULL,5000012,600076),('1970-01-01',NULL,5000023,600076),('2021-11-15',NULL,5000024,600003),('2021-11-15',NULL,5000024,600031),('2021-11-15',NULL,5000024,600032),('2021-11-15',NULL,5000025,600003),('2021-11-15',NULL,5000025,600031),('2021-11-15',NULL,5000025,600032),('2021-11-15',NULL,5000026,600003),('2021-11-15',NULL,5000026,600031),('2021-11-15',NULL,5000026,600032),('2021-11-15',NULL,5000027,600003),('2021-11-15',NULL,5000027,600031),('2021-11-15',NULL,5000027,600032),('2021-11-15',NULL,5000028,600003),('2021-11-15',NULL,5000028,600031),('2021-11-15',NULL,5000028,600032),('2021-11-15',NULL,5000029,600003),('2021-11-15',NULL,5000029,600031),('2021-11-15',NULL,5000029,600032),('2021-11-15',NULL,5000030,600003),('2021-11-15',NULL,5000030,600031),('2021-11-15',NULL,5000030,600032),('2021-11-15',NULL,5000031,600003),('2021-11-15',NULL,5000031,600031),('2021-11-15',NULL,5000031,600032),('2021-11-15',NULL,5000032,600003),('2021-11-15',NULL,5000032,600031),('2021-11-15',NULL,5000032,600032),('2021-11-15',NULL,5000033,600003),('2021-11-15',NULL,5000033,600031),('2021-11-15',NULL,5000033,600032),('2021-11-15',NULL,5000034,600003),('2021-11-15',NULL,5000034,600031),('2021-11-15',NULL,5000034,600032),('2021-11-15',NULL,5000035,600003),('2021-11-15',NULL,5000035,600031),('2021-11-15',NULL,5000035,600032),('2021-11-15',NULL,5000036,600003),('2021-11-15',NULL,5000036,600031),('2021-11-15',NULL,5000036,600032),('2021-11-15',NULL,5000037,600003),('2021-11-15',NULL,5000037,600031),('2021-11-15',NULL,5000037,600032),('2021-11-15',NULL,5000038,600003),('2021-11-15',NULL,5000038,600031),('2021-11-15',NULL,5000038,600032),('2021-11-15',NULL,5000039,600003),('2021-11-15',NULL,5000039,600031),('2021-11-15',NULL,5000039,600032),('2021-11-15',NULL,5000040,600003),('2021-11-15',NULL,5000040,600031),('2021-11-15',NULL,5000040,600032),('2021-11-15',NULL,5000041,600003),('2021-11-15',NULL,5000041,600031),('2021-11-15',NULL,5000041,600032),('2021-11-15',NULL,5000042,600003),('2021-11-15',NULL,5000042,600031),('2021-11-15',NULL,5000042,600032),('2021-11-15',NULL,5000043,600003),('2021-11-15',NULL,5000043,600031),('2021-11-15',NULL,5000043,600032),('2021-11-15',NULL,5000044,600003),('2021-11-15',NULL,5000044,600031),('2021-11-15',NULL,5000044,600032),('2021-11-15',NULL,5000045,600003),('2021-11-15',NULL,5000045,600031),('2021-11-15',NULL,5000045,600032),('2021-11-15',NULL,5000046,600003),('2021-11-15',NULL,5000046,600031),('2021-11-15',NULL,5000046,600032),('2021-11-15',NULL,5000047,600003),('2021-11-15',NULL,5000047,600031),('2021-11-15',NULL,5000047,600032),('2021-11-15',NULL,5000048,600003),('2021-11-15',NULL,5000048,600031),('2021-11-15',NULL,5000048,600032),('2021-11-15',NULL,5000049,600003),('2021-11-15',NULL,5000049,600031),('2021-11-15',NULL,5000049,600032),('2021-11-15',NULL,5000050,600003),('2021-11-15',NULL,5000050,600031),('2021-11-15',NULL,5000050,600032),('2021-11-15',NULL,5000051,600003),('2021-11-15',NULL,5000051,600031),('2021-11-15',NULL,5000051,600032),('2021-11-15',NULL,5000052,600003),('2021-11-15',NULL,5000052,600031),('2021-11-15',NULL,5000052,600032),('2021-11-15',NULL,5000053,600003),('2021-11-15',NULL,5000053,600031),('2021-11-15',NULL,5000053,600032),('2021-11-15',NULL,5000054,600003),('2021-11-15',NULL,5000054,600031),('2021-11-15',NULL,5000054,600032),('2021-11-15',NULL,5000055,600003),('2021-11-15',NULL,5000055,600031),('2021-11-15',NULL,5000055,600032),('2021-11-15',NULL,5000056,600003),('2021-11-15',NULL,5000056,600031),('2021-11-15',NULL,5000056,600032),('2021-11-15',NULL,5000057,600003),('2021-11-15',NULL,5000057,600031),('2021-11-15',NULL,5000057,600032),('2021-11-15',NULL,5000058,600003),('2021-11-15',NULL,5000058,600031),('2021-11-15',NULL,5000058,600032),('2021-11-15',NULL,5000059,600003),('2021-11-15',NULL,5000059,600031),('2021-11-15',NULL,5000059,600032),('2021-11-15',NULL,5000060,600003),('2021-11-15',NULL,5000060,600031),('2021-11-15',NULL,5000060,600032),('2021-11-15',NULL,5000061,600003),('2021-11-15',NULL,5000061,600031),('2021-11-15',NULL,5000061,600032),('2021-11-15',NULL,5000062,600003),('2021-11-15',NULL,5000062,600031),('2021-11-15',NULL,5000062,600032),('2021-11-15',NULL,5000063,600003),('2021-11-15',NULL,5000063,600031),('2021-11-15',NULL,5000063,600032),('2021-11-15',NULL,5000064,600003),('2021-11-15',NULL,5000064,600031),('2021-11-15',NULL,5000064,600032),('2021-11-15',NULL,5000065,600003),('2021-11-15',NULL,5000065,600031),('2021-11-15',NULL,5000065,600032),('2021-11-15',NULL,5000066,600003),('2021-11-15',NULL,5000066,600031),('2021-11-15',NULL,5000066,600032),('2021-11-15',NULL,5000067,600003),('2021-11-15',NULL,5000067,600031),('2021-11-15',NULL,5000067,600032),('2021-11-15',NULL,5000068,600003),('2021-11-15',NULL,5000068,600031),('2021-11-15',NULL,5000068,600032),('2021-11-15',NULL,5000069,600003),('2021-11-15',NULL,5000069,600031),('2021-11-15',NULL,5000069,600032),('2021-11-15',NULL,5000070,600003),('2021-11-15',NULL,5000070,600031),('2021-11-15',NULL,5000070,600032),('2021-11-15',NULL,5000071,600003),('2021-11-15',NULL,5000071,600031),('2021-11-15',NULL,5000071,600032),('2021-11-15',NULL,5000072,600003),('2021-11-15',NULL,5000072,600031),('2021-11-15',NULL,5000072,600032),('2021-11-15',NULL,5000073,600003),('2021-11-15',NULL,5000073,600031),('2021-11-15',NULL,5000073,600032),('2021-11-15',NULL,5000074,600003),('2021-11-15',NULL,5000074,600031),('2021-11-15',NULL,5000074,600032),('2021-11-15',NULL,5000075,600003),('2021-11-15',NULL,5000075,600031),('2021-11-15',NULL,5000075,600032),('2021-11-15',NULL,5000076,600003),('2021-11-15',NULL,5000076,600031),('2021-11-15',NULL,5000076,600032),('2021-11-15',NULL,5000077,600003),('2021-11-15',NULL,5000077,600031),('2021-11-15',NULL,5000077,600032),('2021-11-15',NULL,5000078,600003),('2021-11-15',NULL,5000078,600031),('2021-11-15',NULL,5000078,600032),('2021-11-15',NULL,5000079,600003),('2021-11-15',NULL,5000079,600031),('2021-11-15',NULL,5000079,600032),('2021-11-15',NULL,5000080,600003),('2021-11-15',NULL,5000080,600031),('2021-11-15',NULL,5000080,600032),('2021-11-15',NULL,5000081,600003),('2021-11-15',NULL,5000081,600031),('2021-11-15',NULL,5000081,600032),('2021-11-15',NULL,5000082,600003),('2021-11-15',NULL,5000082,600031),('2021-11-15',NULL,5000082,600032),('2021-11-15',NULL,5000083,600003),('2021-11-15',NULL,5000083,600031),('2021-11-15',NULL,5000083,600032),('2021-11-15',NULL,5000084,600003),('2021-11-15',NULL,5000084,600031),('2021-11-15',NULL,5000084,600032),('2021-11-15',NULL,5000085,600003),('2021-11-15',NULL,5000085,600031),('2021-11-15',NULL,5000085,600032),('2021-11-15',NULL,5000086,600003),('2021-11-15',NULL,5000086,600031),('2021-11-15',NULL,5000086,600032),('2021-11-15',NULL,5000087,600003),('2021-11-15',NULL,5000087,600031),('2021-11-15',NULL,5000087,600032),('2021-11-15',NULL,5000088,600003),('2021-11-15',NULL,5000088,600031),('2021-11-15',NULL,5000088,600032),('2021-11-15',NULL,5000089,600003),('2021-11-15',NULL,5000089,600031),('2021-11-15',NULL,5000089,600032),('2021-11-15',NULL,5000090,600003),('2021-11-15',NULL,5000090,600031),('2021-11-15',NULL,5000090,600032),('2021-11-15',NULL,5000091,600003),('2021-11-15',NULL,5000091,600031),('2021-11-15',NULL,5000091,600032),('2021-11-15',NULL,5000092,600003),('2021-11-15',NULL,5000092,600031),('2021-11-15',NULL,5000092,600032),('2021-11-15',NULL,5000093,600003),('2021-11-15',NULL,5000093,600031),('2021-11-15',NULL,5000093,600032),('2021-11-15',NULL,5000094,600003),('2021-11-15',NULL,5000094,600031),('2021-11-15',NULL,5000094,600032),('2021-11-15',NULL,5000095,600003),('2021-11-15',NULL,5000095,600031),('2021-11-15',NULL,5000095,600032),('2021-11-15',NULL,5000096,600003),('2021-11-15',NULL,5000096,600031),('2021-11-15',NULL,5000096,600032),('2021-11-15',NULL,5000097,600003),('2021-11-15',NULL,5000097,600031),('2021-11-15',NULL,5000097,600032),('2021-11-15',NULL,5000098,600003),('2021-11-15',NULL,5000098,600031),('2021-11-15',NULL,5000098,600032),('2020-08-01',NULL,5000051,600005),('2021-01-14',NULL,5000051,600002),('2021-03-01',NULL,5000051,600016),('2021-03-01',NULL,5000051,600040),('2021-03-01',NULL,5000051,600028),('2020-08-01',NULL,5000049,600005),('2021-01-14',NULL,5000049,600002),('2021-03-01',NULL,5000049,600016),('2021-03-01',NULL,5000049,600040),('2021-03-01',NULL,5000049,600028),('2020-08-01',NULL,5000005,600005),('2021-01-14',NULL,5000005,600002),('2021-03-01',NULL,5000005,600016),('2021-03-01',NULL,5000005,600040),('2021-03-01',NULL,5000005,600028),('2020-08-01',NULL,5000006,600005),('2021-01-14',NULL,5000006,600002),('2021-03-01',NULL,5000006,600016),('2021-03-01',NULL,5000006,600040),('2021-03-01',NULL,5000006,600028),('2020-08-01',NULL,5000093,600005),('2021-01-14',NULL,5000093,600002),('2021-03-01',NULL,5000093,600016),('2021-03-01',NULL,5000093,600040),('2021-03-01',NULL,5000093,600028),('2020-08-01',NULL,5000042,600005),('2021-01-14',NULL,5000042,600002),('2021-03-01',NULL,5000042,600016),('2021-03-01',NULL,5000042,600040),('2021-03-01',NULL,5000042,600028),('2020-08-01',NULL,5000081,600007),('2021-03-17',NULL,5000081,600041),('2021-03-17',NULL,5000081,600029),('2021-03-17',NULL,5000081,600017),('2020-08-01',NULL,5000004,600007),('2021-03-17',NULL,5000004,600041),('2021-03-17',NULL,5000004,600029),('2021-03-17',NULL,5000004,600017),('2020-08-01',NULL,5000043,600007),('2021-03-17',NULL,5000043,600041),('2021-03-17',NULL,5000043,600029),('2021-03-17',NULL,5000043,600017),('2020-08-01',NULL,5000057,600007),('2021-03-17',NULL,5000057,600041),('2021-03-17',NULL,5000057,600029),('2021-03-17',NULL,5000057,600017),('2020-08-01',NULL,5000037,600007),('2021-03-17',NULL,5000037,600041),('2021-03-17',NULL,5000037,600029),('2021-03-17',NULL,5000037,600017),('2020-08-01',NULL,5000071,600007),('2021-03-17',NULL,5000071,600041),('2021-03-17',NULL,5000071,600029),('2021-03-17',NULL,5000071,600017),('2021-11-16',NULL,5000099,600003),('2021-11-16',NULL,5000099,600031),('2021-11-16',NULL,5000099,600032),('2021-11-16',NULL,5000100,600003),('2021-11-16',NULL,5000100,600031),('2021-11-16',NULL,5000100,600032),('2021-11-16',NULL,5000101,600003),('2021-11-16',NULL,5000101,600031),('2021-11-16',NULL,5000101,600032),('2021-11-16',NULL,5000102,600003),('2021-11-16',NULL,5000102,600031),('2021-11-16',NULL,5000102,600032),('2021-11-16',NULL,5000103,600003),('2021-11-16',NULL,5000103,600031),('2021-11-16',NULL,5000103,600032),('2021-11-22',NULL,5000104,600003),('2021-11-22',NULL,5000104,600031),('2021-11-22',NULL,5000104,600032),('1970-01-01',NULL,5000023,600023),('2022-02-28',NULL,5000105,600003),('2022-02-28',NULL,5000105,600031),('2022-02-28',NULL,5000105,600032),('2022-03-30',NULL,5000106,600003),('2022-03-30',NULL,5000106,600031),('2022-03-30',NULL,5000106,600032),('2013-04-01',NULL,5000064,600001),('2022-05-02',NULL,5000107,600003),('2022-05-02',NULL,5000107,600031),('2022-05-02',NULL,5000107,600032),('2020-08-01',NULL,5000107,600005),('2021-01-14',NULL,5000107,600002),('2021-03-01',NULL,5000107,600016),('2021-03-01',NULL,5000107,600040),('2021-03-01',NULL,5000107,600028),('2022-05-02',NULL,5000108,600003),('2022-05-02',NULL,5000108,600031),('2022-05-02',NULL,5000108,600032),('2013-04-01',NULL,5000108,600001),('2022-05-02',NULL,5000109,600003),('2022-05-02',NULL,5000109,600031),('2022-05-02',NULL,5000109,600032),('2013-04-01',NULL,5000109,600001),('2022-05-02',NULL,5000110,600003),('2022-05-02',NULL,5000110,600031),('2022-05-02',NULL,5000110,600032),('2013-04-01',NULL,5000110,600001),('2022-05-02',NULL,5000111,600003),('2022-05-02',NULL,5000111,600031),('2022-05-02',NULL,5000111,600032),('2013-04-01',NULL,5000111,600001),('2022-05-02',NULL,5000112,600003),('2022-05-02',NULL,5000112,600031),('2022-05-02',NULL,5000112,600032),('2013-04-01',NULL,5000112,600001),('2022-05-02',NULL,5000113,600003),('2022-05-02',NULL,5000113,600031),('2022-05-02',NULL,5000113,600032),('2022-05-02',NULL,5000114,600003),('2022-05-02',NULL,5000114,600031),('2022-05-02',NULL,5000114,600032),('2022-05-13',NULL,5000115,600003),('2022-05-13',NULL,5000115,600031),('2022-05-13',NULL,5000115,600032),('2013-04-01',NULL,5000113,600001),('2013-04-01',NULL,5000114,600001),('2022-05-12',NULL,5000116,600003),('2022-05-12',NULL,5000116,600031),('2022-05-12',NULL,5000116,600032),('2022-05-12','2022-05-14',5000117,600003),('2022-05-12','2022-05-14',5000117,600031),('2022-05-12','2022-05-14',5000117,600032),('2022-05-13',NULL,5000118,600003),('2022-05-13',NULL,5000118,600031),('2022-05-13',NULL,5000118,600032),('2022-05-02',NULL,5000116,600001),('2022-05-17',NULL,5000119,600003),('2022-05-17',NULL,5000119,600031),('2022-05-17',NULL,5000119,600032),('2022-05-02',NULL,5000050,600080),('2022-05-02',NULL,5000032,600081),('2022-05-02',NULL,5000099,600082),('2022-05-02',NULL,5000013,600018),('2022-05-17',NULL,5000120,600003),('2022-05-17',NULL,5000120,600031),('2022-05-17',NULL,5000120,600032),('2022-05-17',NULL,5000121,600003),('2022-05-17',NULL,5000121,600031),('2022-05-17',NULL,5000121,600032),('2022-05-02',NULL,5000104,600017),('2022-05-18',NULL,5000122,600003),('2022-05-18',NULL,5000122,600031),('2022-05-18',NULL,5000122,600032),('2022-05-18',NULL,5000123,600003),('2022-05-18',NULL,5000123,600031),('2022-05-18',NULL,5000123,600032),('2022-05-18',NULL,5000124,600003),('2022-05-18',NULL,5000124,600031),('2022-05-18',NULL,5000124,600032),('2022-05-18',NULL,5000125,600003),('2022-05-18',NULL,5000125,600031),('2022-05-18',NULL,5000125,600032),('2022-05-18',NULL,5000126,600003),('2022-05-18',NULL,5000126,600031),('2022-05-18',NULL,5000126,600032),('2022-05-18',NULL,5000127,600003),('2022-05-18',NULL,5000127,600031),('2022-05-18',NULL,5000127,600032),('2022-05-18',NULL,5000128,600003),('2022-05-18',NULL,5000128,600031),('2022-05-18',NULL,5000128,600032),('2022-05-18',NULL,5000129,600003),('2022-05-18',NULL,5000129,600031),('2022-05-18',NULL,5000129,600032),('2022-05-18',NULL,5000130,600003),('2022-05-18',NULL,5000130,600031),('2022-05-18',NULL,5000130,600032),('2022-05-18',NULL,5000131,600003),('2022-05-18',NULL,5000131,600031),('2022-05-18',NULL,5000131,600032),('2022-05-18',NULL,5000132,600003),('2022-05-18',NULL,5000132,600031),('2022-05-18',NULL,5000132,600032),('2022-05-18',NULL,5000133,600003),('2022-05-18',NULL,5000133,600031),('2022-05-18',NULL,5000133,600032),('2022-05-18',NULL,5000134,600003),('2022-05-18',NULL,5000134,600031),('2022-05-18',NULL,5000134,600032),('2022-05-02',NULL,5000096,600137),('2022-05-02',NULL,5000061,600138),('2022-05-02',NULL,5000044,600139),('2022-06-08',NULL,5000135,600003),('2022-06-08',NULL,5000135,600031),('2022-06-08',NULL,5000135,600032),('2022-06-01',NULL,5000118,600104),('2022-06-01',NULL,5000118,600105),('2022-07-11',NULL,5000136,600003),('2022-07-11',NULL,5000136,600031),('2022-07-11',NULL,5000136,600032); /*!40000 ALTER TABLE `T2` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `T3` -- DROP TABLE IF EXISTS `T3`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `T3` ( `C05` int DEFAULT NULL, `C04` bigint DEFAULT NULL, `C06` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL, `C07` varchar(1) COLLATE utf8mb4_general_ci DEFAULT NULL, `C08` int DEFAULT NULL, `C09` int DEFAULT NULL, `C10` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `T3` -- LOCK TABLES `T3` WRITE; /*!40000 ALTER TABLE `T3` DISABLE KEYS */; INSERT INTO `T3` VALUES (NULL,600002,'M01','Y',NULL,NULL,NULL),(NULL,600005,'M02','1',NULL,NULL,NULL),(NULL,600006,'M02','1',NULL,NULL,NULL),(NULL,600008,'M02','1',NULL,NULL,NULL),(NULL,600004,'M01','1',NULL,NULL,NULL),(NULL,600009,'M03','1',NULL,NULL,NULL),(NULL,600011,'M04','1',NULL,NULL,NULL),(NULL,600014,'M05','1',NULL,NULL,NULL),(NULL,600015,'M06','1',NULL,NULL,NULL),(NULL,600013,'M07','1',NULL,NULL,NULL),(NULL,600012,'M08','1',NULL,NULL,NULL),(NULL,600010,'M09','1',NULL,NULL,NULL),(NULL,600019,'M01','1',NULL,NULL,NULL),(NULL,600020,'M01','1',NULL,NULL,NULL),(NULL,600021,'M01','1',NULL,NULL,NULL),(NULL,600022,'M01','1',NULL,NULL,NULL),(NULL,600021,'M02','1',NULL,NULL,NULL),(NULL,600022,'M02','1',NULL,NULL,NULL),(NULL,600024,'M10','1',NULL,NULL,NULL),(NULL,600025,'M01','1',NULL,NULL,NULL),(NULL,600026,'M01','1',NULL,NULL,NULL),(NULL,600027,'M01','1',NULL,NULL,NULL),(NULL,600033,'M01','1',8013,NULL,NULL),(NULL,600034,'M01','Y',NULL,NULL,NULL),(NULL,600035,'M01','1',NULL,NULL,NULL),(NULL,600036,'M01','Y',NULL,NULL,NULL),(12,600037,'M01','1',NULL,NULL,NULL),(12,600038,'M01','1',NULL,NULL,NULL),(NULL,600039,'M01','Y',NULL,NULL,'7086'),(NULL,600043,'M01','Y',NULL,NULL,NULL),(NULL,600044,'M01','1',NULL,NULL,NULL),(NULL,600045,'M01','Y',NULL,NULL,NULL),(NULL,600046,'M01','Y',NULL,NULL,NULL),(NULL,600047,'M01','Y',NULL,NULL,NULL),(NULL,600048,'M01','Y',NULL,NULL,NULL),(NULL,600049,'M01','Y',NULL,NULL,NULL),(NULL,600050,'M01','Y',8005,NULL,NULL),(NULL,600050,'M01','Y',8032,NULL,NULL),(NULL,600050,'M01','Y',8033,NULL,NULL),(NULL,600050,'M01','Y',8034,NULL,NULL),(NULL,600050,'M01','Y',8045,NULL,NULL),(NULL,600051,'M01','Y',8005,NULL,NULL),(NULL,600051,'M01','Y',8032,NULL,NULL),(NULL,600051,'M01','Y',8033,NULL,NULL),(NULL,600051,'M01','Y',8034,NULL,NULL),(NULL,600051,'M01','Y',8045,NULL,NULL),(NULL,600052,'M01','Y',8041,NULL,NULL),(NULL,600052,'M01','Y',8052,NULL,NULL),(NULL,600053,'M01','Y',8041,NULL,NULL),(NULL,600053,'M01','Y',8052,NULL,NULL),(NULL,600054,'M01','Y',8028,NULL,NULL),(NULL,600054,'M01','Y',8040,NULL,NULL),(NULL,600055,'M01','Y',8028,NULL,NULL),(NULL,600055,'M01','Y',8040,NULL,NULL),(NULL,600056,'M01','Y',8012,NULL,NULL),(NULL,600056,'M01','Y',8013,NULL,NULL),(NULL,600056,'M01','Y',8037,NULL,NULL),(NULL,600056,'M01','Y',8038,NULL,NULL),(NULL,600056,'M01','Y',8058,NULL,NULL),(NULL,600056,'M01','Y',8061,NULL,NULL),(NULL,600056,'M01','Y',8062,NULL,NULL),(NULL,600057,'M01','Y',8012,NULL,NULL),(NULL,600057,'M01','Y',8013,NULL,NULL),(NULL,600057,'M01','Y',8037,NULL,NULL),(NULL,600057,'M01','Y',8038,NULL,NULL),(NULL,600057,'M01','Y',8058,NULL,NULL),(NULL,600057,'M01','Y',8061,NULL,NULL),(NULL,600057,'M01','Y',8062,NULL,NULL),(NULL,600060,'M01','1',8030,9001,NULL),(NULL,600058,'M01','1',NULL,NULL,NULL),(NULL,600059,'M01','1',NULL,NULL,NULL),(NULL,600061,'M01','Y',NULL,NULL,NULL),(NULL,600062,'M01','Y',NULL,NULL,NULL),(NULL,600063,'M01','Y',NULL,NULL,NULL),(NULL,600064,'M01','Y',NULL,NULL,NULL),(NULL,600065,'M01','Y',NULL,NULL,'7086'),(NULL,600057,'M01','1',8016,NULL,NULL),(NULL,600056,'M01','1',8016,NULL,NULL),(NULL,600025,'M02','1',NULL,NULL,NULL),(NULL,600016,'M01','1',NULL,NULL,NULL),(NULL,600018,'M01','1',NULL,NULL,NULL),(NULL,600028,'M01','1',NULL,NULL,NULL),(NULL,600029,'M01','1',NULL,NULL,NULL),(NULL,600030,'M01','1',NULL,NULL,NULL),(NULL,600040,'M01','1',NULL,NULL,NULL),(NULL,600041,'M01','1',NULL,NULL,NULL),(NULL,600042,'M01','1',NULL,NULL,NULL),(NULL,600066,'M01','1',NULL,NULL,'7090'),(NULL,600067,'M01','1',NULL,NULL,'7096'),(NULL,600068,'M01','1',NULL,NULL,'7095'),(NULL,600069,'M01','1',NULL,NULL,'7097'),(NULL,600070,'M01','1',NULL,NULL,'7091'),(NULL,600071,'M01','1',NULL,NULL,'7092'),(NULL,600072,'M01','1',NULL,NULL,'7093'),(NULL,600073,'M01','1',NULL,NULL,'7094'),(NULL,600074,'M01','0',NULL,NULL,NULL),(NULL,600024,'M01','1',NULL,NULL,NULL),(NULL,600028,'M02','1',NULL,NULL,NULL),(NULL,600029,'M02','1',NULL,NULL,NULL),(NULL,600030,'M02','1',NULL,NULL,NULL),(NULL,600075,'M01','1',8053,NULL,NULL),(NULL,600066,'M01','1',8004,NULL,NULL),(NULL,600066,'M01','1',8027,NULL,NULL),(NULL,600066,'M01','1',8053,NULL,NULL),(NULL,600067,'M01','1',8039,NULL,NULL),(NULL,600067,'M01','1',8051,NULL,NULL),(NULL,600069,'M01','1',8044,NULL,NULL),(NULL,600069,'M01','1',8023,NULL,NULL),(NULL,600069,'M01','1',8053,NULL,NULL),(NULL,600069,'M01','1',8053,NULL,NULL),(NULL,600069,'M01','1',8014,NULL,NULL),(NULL,600069,'M01','1',8063,NULL,NULL),(NULL,600017,'M01','1',NULL,NULL,NULL),(NULL,600068,'M01','1',8031,NULL,NULL),(NULL,600068,'M01','1',8022,NULL,NULL),(NULL,600070,'M01','1',8006,NULL,NULL),(NULL,600070,'M01','1',8017,NULL,NULL),(NULL,600070,'M01','1',8053,NULL,NULL),(NULL,600070,'M01','1',8053,NULL,NULL),(NULL,600070,'M01','1',8007,NULL,NULL),(NULL,600070,'M01','1',8063,NULL,NULL),(NULL,600070,'M01','1',8018,NULL,NULL),(NULL,600070,'M01','1',8035,NULL,NULL),(NULL,600080,'M01','1',8002,NULL,NULL),(NULL,600081,'M01','1',8002,NULL,NULL),(NULL,600082,'M01','1',8002,NULL,NULL),(NULL,600080,'M01','1',8020,NULL,NULL),(NULL,600081,'M01','1',8020,NULL,NULL),(NULL,600082,'M01','1',8020,NULL,NULL),(NULL,600083,'M01','1',8010,NULL,NULL),(NULL,600084,'M01','1',8010,NULL,NULL),(NULL,600085,'M01','1',8010,NULL,NULL),(NULL,600083,'M01','1',8012,NULL,NULL),(NULL,600084,'M01','1',8012,NULL,NULL),(NULL,600085,'M01','1',8012,NULL,NULL),(NULL,600083,'M01','1',8016,NULL,NULL),(NULL,600084,'M01','1',8016,NULL,NULL),(NULL,600085,'M01','1',8016,NULL,NULL),(NULL,600083,'M01','1',8037,NULL,NULL),(NULL,600084,'M01','1',8037,NULL,NULL),(NULL,600085,'M01','1',8037,NULL,NULL),(NULL,600083,'M01','1',8038,NULL,NULL),(NULL,600084,'M01','1',8038,NULL,NULL),(NULL,600085,'M01','1',8038,NULL,NULL),(NULL,600083,'M01','1',8046,NULL,NULL),(NULL,600084,'M01','1',8046,NULL,NULL),(NULL,600085,'M01','1',8046,NULL,NULL),(NULL,600083,'M01','1',8047,NULL,NULL),(NULL,600084,'M01','1',8047,NULL,NULL),(NULL,600085,'M01','1',8047,NULL,NULL),(NULL,600083,'M01','1',8048,NULL,NULL),(NULL,600084,'M01','1',8048,NULL,NULL),(NULL,600085,'M01','1',8048,NULL,NULL),(NULL,600083,'M01','1',8049,NULL,NULL),(NULL,600084,'M01','1',8049,NULL,NULL),(NULL,600085,'M01','1',8049,NULL,NULL),(NULL,600083,'M01','1',8051,NULL,NULL),(NULL,600084,'M01','1',8051,NULL,NULL),(NULL,600085,'M01','1',8051,NULL,NULL),(NULL,600083,'M01','1',8050,NULL,NULL),(NULL,600084,'M01','1',8050,NULL,NULL),(NULL,600085,'M01','1',8050,NULL,NULL),(NULL,600083,'M01','1',8054,NULL,NULL),(NULL,600084,'M01','1',8054,NULL,NULL),(NULL,600085,'M01','1',8054,NULL,NULL),(NULL,600083,'M01','1',8055,NULL,NULL),(NULL,600084,'M01','1',8055,NULL,NULL),(NULL,600085,'M01','1',8055,NULL,NULL),(NULL,600083,'M01','1',8059,NULL,NULL),(NULL,600084,'M01','1',8059,NULL,NULL),(NULL,600085,'M01','1',8059,NULL,NULL),(NULL,600083,'M01','1',8058,NULL,NULL),(NULL,600084,'M01','1',8058,NULL,NULL),(NULL,600085,'M01','1',8058,NULL,NULL),(NULL,600086,'M01','1',8013,NULL,NULL),(NULL,600087,'M01','1',8013,NULL,NULL),(NULL,600088,'M01','1',8013,NULL,NULL),(NULL,600092,'M01','1',8001,NULL,NULL),(NULL,600093,'M01','1',8001,NULL,NULL),(NULL,600094,'M01','1',8001,NULL,NULL),(NULL,600092,'M01','1',8003,NULL,NULL),(NULL,600093,'M01','1',8003,NULL,NULL),(NULL,600094,'M01','1',8003,NULL,NULL),(NULL,600092,'M01','1',8004,NULL,NULL),(NULL,600093,'M01','1',8004,NULL,NULL),(NULL,600094,'M01','1',8004,NULL,NULL),(NULL,600092,'M01','1',8006,NULL,NULL),(NULL,600093,'M01','1',8006,NULL,NULL),(NULL,600094,'M01','1',8006,NULL,NULL),(NULL,600092,'M01','1',8009,NULL,NULL),(NULL,600093,'M01','1',8009,NULL,NULL),(NULL,600094,'M01','1',8009,NULL,NULL),(NULL,600092,'M01','1',8015,NULL,NULL),(NULL,600093,'M01','1',8015,NULL,NULL),(NULL,600094,'M01','1',8015,NULL,NULL),(NULL,600092,'M01','1',8019,NULL,NULL),(NULL,600093,'M01','1',8019,NULL,NULL),(NULL,600094,'M01','1',8019,NULL,NULL),(NULL,600092,'M01','1',8021,NULL,NULL),(NULL,600093,'M01','1',8021,NULL,NULL),(NULL,600094,'M01','1',8021,NULL,NULL),(NULL,600092,'M01','1',8025,NULL,NULL),(NULL,600093,'M01','1',8025,NULL,NULL),(NULL,600094,'M01','1',8025,NULL,NULL),(NULL,600092,'M01','1',8026,NULL,NULL),(NULL,600093,'M01','1',8026,NULL,NULL),(NULL,600094,'M01','1',8026,NULL,NULL),(NULL,600092,'M01','1',8039,NULL,NULL),(NULL,600093,'M01','1',8039,NULL,NULL),(NULL,600094,'M01','1',8039,NULL,NULL),(NULL,600092,'M01','1',8042,NULL,NULL),(NULL,600093,'M01','1',8042,NULL,NULL),(NULL,600094,'M01','1',8042,NULL,NULL),(NULL,600092,'M01','1',8043,NULL,NULL),(NULL,600093,'M01','1',8043,NULL,NULL),(NULL,600094,'M01','1',8043,NULL,NULL),(NULL,600092,'M01','1',8044,NULL,NULL),(NULL,600093,'M01','1',8044,NULL,NULL),(NULL,600094,'M01','1',8044,NULL,NULL),(NULL,600092,'M01','1',8049,NULL,NULL),(NULL,600093,'M01','1',8049,NULL,NULL),(NULL,600094,'M01','1',8049,NULL,NULL),(NULL,600092,'M01','1',8051,NULL,NULL),(NULL,600093,'M01','1',8051,NULL,NULL),(NULL,600094,'M01','1',8051,NULL,NULL),(NULL,600092,'M01','1',8053,NULL,NULL),(NULL,600093,'M01','1',8053,NULL,NULL),(NULL,600094,'M01','1',8053,NULL,NULL),(NULL,600092,'M01','1',8056,NULL,NULL),(NULL,600093,'M01','1',8056,NULL,NULL),(NULL,600094,'M01','1',8056,NULL,NULL),(NULL,600092,'M01','1',8057,NULL,NULL),(NULL,600093,'M01','1',8057,NULL,NULL),(NULL,600094,'M01','1',8057,NULL,NULL),(NULL,600092,'M01','1',8063,NULL,NULL),(NULL,600093,'M01','1',8063,NULL,NULL),(NULL,600094,'M01','1',8063,NULL,NULL),(NULL,600095,'M01','1',8060,NULL,NULL),(NULL,600096,'M01','1',8060,NULL,NULL),(NULL,600097,'M01','1',8060,NULL,NULL),(NULL,600095,'M01','1',8062,NULL,NULL),(NULL,600096,'M01','1',8062,NULL,NULL),(NULL,600097,'M01','1',8062,NULL,NULL),(NULL,600101,'M01','1',8001,NULL,NULL),(NULL,600102,'M01','1',8001,NULL,NULL),(NULL,600103,'M01','1',8001,NULL,NULL),(NULL,600101,'M01','1',8003,NULL,NULL),(NULL,600102,'M01','1',8003,NULL,NULL),(NULL,600103,'M01','1',8003,NULL,NULL),(NULL,600101,'M01','1',8004,NULL,NULL),(NULL,600102,'M01','1',8004,NULL,NULL),(NULL,600103,'M01','1',8004,NULL,NULL),(NULL,600101,'M01','1',8006,NULL,NULL),(NULL,600102,'M01','1',8006,NULL,NULL),(NULL,600103,'M01','1',8006,NULL,NULL),(NULL,600101,'M01','1',8009,NULL,NULL),(NULL,600102,'M01','1',8009,NULL,NULL),(NULL,600103,'M01','1',8009,NULL,NULL),(NULL,600101,'M01','1',8012,NULL,NULL),(NULL,600102,'M01','1',8012,NULL,NULL),(NULL,600103,'M01','1',8012,NULL,NULL),(NULL,600101,'M01','1',8015,NULL,NULL),(NULL,600102,'M01','1',8015,NULL,NULL),(NULL,600103,'M01','1',8015,NULL,NULL),(NULL,600101,'M01','1',8019,NULL,NULL),(NULL,600102,'M01','1',8019,NULL,NULL),(NULL,600103,'M01','1',8019,NULL,NULL),(NULL,600101,'M01','1',8020,NULL,NULL),(NULL,600102,'M01','1',8020,NULL,NULL),(NULL,600103,'M01','1',8020,NULL,NULL),(NULL,600101,'M01','1',8021,NULL,NULL),(NULL,600102,'M01','1',8021,NULL,NULL),(NULL,600103,'M01','1',8021,NULL,NULL),(NULL,600101,'M01','1',8025,NULL,NULL),(NULL,600102,'M01','1',8025,NULL,NULL),(NULL,600103,'M01','1',8025,NULL,NULL),(NULL,600101,'M01','1',8026,NULL,NULL),(NULL,600102,'M01','1',8026,NULL,NULL),(NULL,600103,'M01','1',8026,NULL,NULL),(NULL,600101,'M01','1',8029,NULL,NULL),(NULL,600102,'M01','1',8029,NULL,NULL),(NULL,600103,'M01','1',8029,NULL,NULL),(NULL,600101,'M01','1',8036,NULL,NULL),(NULL,600102,'M01','1',8036,NULL,NULL),(NULL,600103,'M01','1',8036,NULL,NULL),(NULL,600101,'M01','1',8039,NULL,NULL),(NULL,600102,'M01','1',8039,NULL,NULL),(NULL,600103,'M01','1',8039,NULL,NULL),(NULL,600101,'M01','1',8042,NULL,NULL),(NULL,600102,'M01','1',8042,NULL,NULL),(NULL,600103,'M01','1',8042,NULL,NULL),(NULL,600101,'M01','1',8043,NULL,NULL),(NULL,600102,'M01','1',8043,NULL,NULL),(NULL,600103,'M01','1',8043,NULL,NULL),(NULL,600101,'M01','1',8044,NULL,NULL),(NULL,600102,'M01','1',8044,NULL,NULL),(NULL,600103,'M01','1',8044,NULL,NULL),(NULL,600101,'M01','1',8049,NULL,NULL),(NULL,600102,'M01','1',8049,NULL,NULL),(NULL,600103,'M01','1',8049,NULL,NULL),(NULL,600101,'M01','1',8051,NULL,NULL),(NULL,600102,'M01','1',8051,NULL,NULL),(NULL,600103,'M01','1',8051,NULL,NULL),(NULL,600101,'M01','1',8053,NULL,NULL),(NULL,600102,'M01','1',8053,NULL,NULL),(NULL,600103,'M01','1',8053,NULL,NULL),(NULL,600101,'M01','1',8056,NULL,NULL),(NULL,600102,'M01','1',8056,NULL,NULL),(NULL,600103,'M01','1',8056,NULL,NULL),(NULL,600101,'M01','1',8057,NULL,NULL),(NULL,600102,'M01','1',8057,NULL,NULL),(NULL,600103,'M01','1',8057,NULL,NULL),(NULL,600101,'M01','1',8063,NULL,NULL),(NULL,600102,'M01','1',8063,NULL,NULL),(NULL,600103,'M01','1',8063,NULL,NULL),(NULL,600101,'M01','1',8060,NULL,NULL),(NULL,600102,'M01','1',8060,NULL,NULL),(NULL,600103,'M01','1',8060,NULL,NULL),(NULL,600101,'M01','1',8062,NULL,NULL),(NULL,600102,'M01','1',8062,NULL,NULL),(NULL,600103,'M01','1',8062,NULL,NULL),(NULL,600098,'M01','1',8002,NULL,NULL),(NULL,600099,'M01','1',8002,NULL,NULL),(NULL,600100,'M01','1',8002,NULL,NULL),(NULL,600098,'M01','1',8010,NULL,NULL),(NULL,600099,'M01','1',8010,NULL,NULL),(NULL,600100,'M01','1',8010,NULL,NULL),(NULL,600098,'M01','1',8011,NULL,NULL),(NULL,600099,'M01','1',8011,NULL,NULL),(NULL,600100,'M01','1',8011,NULL,NULL),(NULL,600098,'M01','1',8013,NULL,NULL),(NULL,600099,'M01','1',8013,NULL,NULL),(NULL,600100,'M01','1',8013,NULL,NULL),(NULL,600098,'M01','1',8016,NULL,NULL),(NULL,600099,'M01','1',8016,NULL,NULL),(NULL,600100,'M01','1',8016,NULL,NULL),(NULL,600098,'M01','1',8037,NULL,NULL),(NULL,600099,'M01','1',8037,NULL,NULL),(NULL,600100,'M01','1',8037,NULL,NULL),(NULL,600098,'M01','1',8038,NULL,NULL),(NULL,600099,'M01','1',8038,NULL,NULL),(NULL,600100,'M01','1',8038,NULL,NULL),(NULL,600098,'M01','1',8046,NULL,NULL),(NULL,600099,'M01','1',8046,NULL,NULL),(NULL,600100,'M01','1',8046,NULL,NULL),(NULL,600098,'M01','1',8047,NULL,NULL),(NULL,600099,'M01','1',8047,NULL,NULL),(NULL,600100,'M01','1',8047,NULL,NULL),(NULL,600098,'M01','1',8048,NULL,NULL),(NULL,600099,'M01','1',8048,NULL,NULL),(NULL,600100,'M01','1',8048,NULL,NULL),(NULL,600098,'M01','1',8049,NULL,NULL),(NULL,600099,'M01','1',8049,NULL,NULL),(NULL,600100,'M01','1',8049,NULL,NULL),(NULL,600098,'M01','1',8051,NULL,NULL),(NULL,600099,'M01','1',8051,NULL,NULL),(NULL,600100,'M01','1',8051,NULL,NULL),(NULL,600098,'M01','1',8050,NULL,NULL),(NULL,600099,'M01','1',8050,NULL,NULL),(NULL,600100,'M01','1',8050,NULL,NULL),(NULL,600098,'M01','1',8054,NULL,NULL),(NULL,600099,'M01','1',8054,NULL,NULL),(NULL,600100,'M01','1',8054,NULL,NULL),(NULL,600098,'M01','1',8055,NULL,NULL),(NULL,600099,'M01','1',8055,NULL,NULL),(NULL,600100,'M01','1',8055,NULL,NULL),(NULL,600098,'M01','1',8059,NULL,NULL),(NULL,600099,'M01','1',8059,NULL,NULL),(NULL,600100,'M01','1',8059,NULL,NULL),(NULL,600098,'M01','1',8058,NULL,NULL),(NULL,600099,'M01','1',8058,NULL,NULL),(NULL,600100,'M01','1',8058,NULL,NULL),(NULL,600107,'M01','1',NULL,NULL,'7121'),(NULL,600108,'M01','1',NULL,NULL,'7121'),(NULL,600109,'M01','1',NULL,NULL,'7121'),(NULL,600110,'M01','1',NULL,NULL,'7122'),(NULL,600111,'M01','1',NULL,NULL,'7122'),(NULL,600112,'M01','1',NULL,NULL,'7122'),(NULL,600113,'M01','1',NULL,NULL,'7123'),(NULL,600114,'M01','1',NULL,NULL,'7123'),(NULL,600115,'M01','1',NULL,NULL,'7123'),(NULL,600116,'M01','1',NULL,NULL,'7124'),(NULL,600117,'M01','1',NULL,NULL,'7124'),(NULL,600118,'M01','1',NULL,NULL,'7124'),(NULL,600119,'M01','1',NULL,NULL,'7125'),(NULL,600120,'M01','1',NULL,NULL,'7125'),(NULL,600121,'M01','1',NULL,NULL,'7125'),(NULL,600122,'M01','1',NULL,NULL,'7126'),(NULL,600123,'M01','1',NULL,NULL,'7126'),(NULL,600124,'M01','1',NULL,NULL,'7126'),(NULL,600125,'M01','1',NULL,NULL,'7127'),(NULL,600126,'M01','1',NULL,NULL,'7127'),(NULL,600127,'M01','1',NULL,NULL,'7127'),(NULL,600128,'M01','1',NULL,NULL,'7128'),(NULL,600129,'M01','1',NULL,NULL,'7128'),(NULL,600130,'M01','1',NULL,NULL,'7128'),(NULL,600131,'M01','1',NULL,NULL,'7129'),(NULL,600132,'M01','1',NULL,NULL,'7129'),(NULL,600133,'M01','1',NULL,NULL,'7129'),(NULL,600134,'M01','1',NULL,NULL,'7134'),(NULL,600135,'M01','1',NULL,NULL,'7134'),(NULL,600136,'M01','1',NULL,NULL,'7134'),(NULL,600137,'M01','1',NULL,NULL,'7135'),(NULL,600138,'M01','1',NULL,NULL,'7135'),(NULL,600139,'M01','1',NULL,NULL,'7135'),(NULL,600140,'M01','1',NULL,NULL,'7136'),(NULL,600141,'M01','1',NULL,NULL,'7136'),(NULL,600142,'M01','1',NULL,NULL,'7136'),(NULL,600143,'M01','1',NULL,NULL,'7137'),(NULL,600144,'M01','1',NULL,NULL,'7137'),(NULL,600145,'M01','1',NULL,NULL,'7137'),(NULL,600146,'M01','1',NULL,NULL,'7138'),(NULL,600147,'M01','1',NULL,NULL,'7138'),(NULL,600148,'M01','1',NULL,NULL,'7138'),(NULL,600149,'M01','1',NULL,NULL,'7139'),(NULL,600150,'M01','1',NULL,NULL,'7139'),(NULL,600151,'M01','1',NULL,NULL,'7139'),(NULL,600152,'M01','1',NULL,NULL,'7140'),(NULL,600153,'M01','1',NULL,NULL,'7140'),(NULL,600154,'M01','1',NULL,NULL,'7140'),(NULL,600155,'M01','1',NULL,NULL,'7141'),(NULL,600156,'M01','1',NULL,NULL,'7141'),(NULL,600157,'M01','1',NULL,NULL,'7141'),(NULL,600158,'M01','1',NULL,NULL,'7142'),(NULL,600159,'M01','1',NULL,NULL,'7142'),(NULL,600150,'M01','1',NULL,NULL,'7142'),(NULL,600077,'M01','1',NULL,NULL,NULL),(NULL,600078,'M01','1',NULL,NULL,NULL),(NULL,600079,'M01','1',NULL,NULL,NULL),(NULL,600104,'M01','1',NULL,NULL,NULL),(NULL,600105,'M01','1',NULL,NULL,NULL),(NULL,600106,'M01','1',NULL,NULL,NULL),(3,600164,'M01','1',NULL,NULL,NULL),(3,600165,'M01','1',NULL,NULL,NULL),(3,600166,'M01','1',NULL,NULL,NULL),(NULL,600161,'M01','1',8036,NULL,NULL),(NULL,600162,'M01','1',8036,NULL,NULL),(NULL,600163,'M01','1',8036,NULL,NULL),(NULL,600089,'M01','1',8029,NULL,NULL),(NULL,600090,'M01','1',8029,NULL,NULL),(NULL,600091,'M01','1',8029,NULL,NULL); /*!40000 ALTER TABLE `T3` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `T4` -- DROP TABLE IF EXISTS `T4`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `T4` ( `C08` int DEFAULT NULL, `C09` int DEFAULT NULL, `C10` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL, `C11` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `T4` -- LOCK TABLES `T4` WRITE; /*!40000 ALTER TABLE `T4` DISABLE KEYS */; INSERT INTO `T4` VALUES (8003,9007,'7202',1),(8003,9007,'7202',1),(8026,9015,'7118',1),(8002,9003,'7119',1),(8002,9003,'7130',1),(8002,9003,'7131',1),(8064,9026,'7119',3),(8024,9012,'7127',1),(8024,9012,'7126',1),(8024,9012,'7140',1),(8024,9010,'7142',1),(8024,9012,'7137',1),(8024,9012,'7127',1),(8064,9027,'7126',3),(8001,9002,'7151',1),(8002,9004,'7135',1),(8029,9019,'7141',1),(8029,9019,'7129',1),(8063,9024,'7155',1),(8029,9019,'7128',1),(8029,9019,'7137',1),(8029,9018,'7133',1),(8063,9024,'7155',1),(8063,9024,'7155',1),(8063,9024,'7155',1),(8063,9024,'7155',1),(8053,9023,'7130',1),(8029,9020,'7145',1),(8053,9023,'7130',1),(8029,9018,'7141',1),(8029,9010,'7142',1),(8029,9018,'7141',1),(8029,9018,'7176',1),(8029,9019,'7123',1),(8064,9030,'7159',3),(8029,9018,'7135',1),(8064,9030,'7126',3),(8029,9019,'7144',1),(8029,9019,'7126',1),(8029,9019,'7202',1),(8025,9014,'7123',1),(8029,9019,'7129',1),(8064,9028,'7120',3),(8025,9014,'7155',1),(8029,9018,'7175',1),(8002,9005,'7116',1),(8002,9005,'7116',1),(8029,9019,'7123',1),(8029,9019,'7139',1),(8029,9018,'7122',1),(8029,9018,'7129',1),(8029,9018,'7139',1),(8029,9018,'7126',1),(8029,9018,'7145',1),(8029,9018,'7134',1),(8029,9019,'7139',1),(8029,9019,'7144',1),(8064,9030,'7122',3),(8002,9004,'7131',1),(8029,9018,'7134',1),(8029,9019,'7122',1),(8064,9029,'7166',3),(8025,9010,'7142',1),(8008,9008,'7127',1),(8064,9026,'7119',3),(8029,9018,'7129',1),(8029,9018,'7126',1),(8024,9012,'7140',1),(8024,9012,'7125',1),(8029,9018,'7122',1),(8029,9018,'7126',1),(8029,9018,'7134',1),(8029,9018,'7122',1),(8009,9009,'7146',1),(8064,9030,'7159',3),(8064,9027,'7136',3),(8029,9019,'7126',1),(8029,9019,'7137',1),(8029,9019,'7135',1),(8025,9013,'7123',1),(8064,9030,'7135',3),(8009,9009,'7146',1),(8029,9019,'7128',1),(8029,9019,'7120',1),(8029,9019,'7138',1),(8025,9014,'7123',1),(8025,9014,'7155',1),(8064,9031,'7121',3),(8043,9022,'7118',1),(8029,9019,'7176',1),(8024,9011,'7127',1),(8002,9004,'7202',1),(8029,9018,'7124',1),(8029,9019,'7137',1),(8002,9003,'7131',1),(8024,9012,'7127',1),(8063,9024,'7155',1),(8029,9019,'7144',1),(8001,9002,'7151',1),(8065,9025,'7202',1),(8026,9015,'7118',1),(8024,9012,'7126',1),(8029,9018,'7141',1),(8026,9015,'7118',1),(8064,9027,'7136',3),(8065,9025,'7202',1),(8024,9012,'7127',1),(8029,9018,'7141',1),(8063,9024,'7155',1),(8024,9012,'7125',1),(8064,9026,'7119',3),(8029,9018,'7202',1),(8024,9012,'7126',1),(8029,9019,'7144',1),(8029,9019,'7175',1),(8029,9019,'7175',1),(8029,9018,'7175',1),(8029,9021,'7175',1),(8029,9018,'7175',1),(8029,9021,'7142',1),(8002,9003,'7130',1),(8024,9012,'7126',1),(8024,9012,'7137',1),(8029,9019,'7126',1),(8001,9002,'7152',1),(8026,9017,'7118',1),(8026,9016,'7118',1),(8026,9015,'7118',1),(8026,9017,'7118',1),(8003,9007,'7126',1),(8003,9007,'7118',1),(8002,9004,'7202',1),(8001,9002,'7152',1),(8001,9002,'7152',1),(8001,9002,'7152',1),(8002,9003,'7119',1),(8029,9018,'7133',1),(8026,9015,'7118',1),(8029,9019,'7144',1),(8002,9003,'7119',1),(8029,9019,'7141',1),(8029,9019,'7124',1),(8024,9012,'7125',1),(8029,9018,'7122',1),(8029,9018,'7142',1),(8029,9019,'7124',1),(8029,9018,'7124',1),(8029,9018,'7176',1),(8029,9019,'7176',1),(8029,9019,'7143',1),(8029,9018,'7176',1),(8029,9020,'7176',1),(8029,9021,'7176',1),(8001,9002,'7202',3),(8029,9019,'7143',3),(8029,9019,'7176',1),(8029,9018,'7135',1),(8029,9018,'7141',1),(8026,9015,'7118',1),(8029,9018,'7144',1),(8029,9021,'7176',1),(8029,9019,'7143',1),(8029,9018,'7143',1),(8029,9018,'7141',1),(8029,9020,'7176',1),(8063,9024,'7156',1),(8029,9018,'7176',1),(8029,9018,'7144',1),(8029,9019,'7129',1),(8029,9018,'7128',1),(8029,9019,'7176',1),(8029,9021,'7176',1),(8003,9006,'7119',1); /*!40000 ALTER TABLE `T4` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `T5` -- DROP TABLE IF EXISTS `T5`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `T5` ( `C10` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL, `C12` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL, `C13` int DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `T5` -- LOCK TABLES `T5` WRITE; /*!40000 ALTER TABLE `T5` DISABLE KEYS */; INSERT INTO `T5` VALUES ('7001','7001',1),('7076','7076',1),('7088','7088',1),('7107','7107',1),('7194','7194',1),('7206','7206',1),('7217','7217',1),('7228','7228',1),('7239','7239',1),('7002','7002',1),('7020','7020',1),('7031','7031',1),('7042','7042',1),('7053','7053',1),('7064','7064',1),('7072','7072',1),('7073','7073',1),('7074','7074',1),('7075','7075',1),('7077','7077',1),('7078','7078',1),('7079','7079',1),('7080','7080',1),('7081','7081',1),('7082','7082',1),('7083','7083',1),('7084','7084',1),('7085','7085',1),('7087','7087',1),('7089','7089',1),('7098','7098',1),('7099','7099',1),('7100','7100',1),('7101','7101',1),('7102','7102',1),('7103','7103',1),('7104','7104',1),('7105','7105',1),('7106','7106',1),('7108','7108',1),('7109','7109',1),('7110','7110',1),('7111','7111',1),('7112','7112',1),('7113','7113',1),('7114','7114',1),('7115','7115',1),('7192','7192',1),('7193','7193',1),('7195','7195',1),('7197','7197',1),('7198','7198',1),('7199','7199',1),('7200','7200',1),('7201','7201',1),('7202','7202',1),('7203','7203',1),('7204','7204',1),('7205','7205',1),('7207','7207',1),('7208','7208',1),('7209','7209',1),('7210','7210',1),('7211','7211',1),('7212','7212',1),('7213','7213',1),('7214','7214',1),('7215','7215',1),('7216','7216',1),('7218','7218',1),('7219','7219',1),('7220','7220',1),('7221','7221',1),('7222','7222',1),('7223','7223',1),('7224','7224',1),('7225','7225',1),('7226','7226',1),('7227','7227',1),('7229','7229',1),('7230','7230',1),('7231','7231',1),('7232','7232',1),('7233','7233',1),('7234','7234',1),('7235','7235',1),('7236','7236',1),('7237','7237',1),('7238','7238',1),('7240','7240',1),('7241','7241',1),('7242','7242',1),('7243','7243',1),('7244','7244',1),('7245','7245',1),('7246','7246',1),('7247','7247',1),('7248','7248',1),('7249','7249',1),('7003','7003',1),('7010','7010',1),('7012','7012',1),('7013','7013',1),('7014','7014',1),('7015','7015',1),('7016','7016',1),('7017','7017',1),('7018','7018',1),('7019','7019',1),('7021','7021',1),('7022','7022',1),('7023','7023',1),('7024','7024',1),('7025','7025',1),('7026','7026',1),('7027','7027',1),('7028','7028',1),('7029','7029',1),('7030','7030',1),('7032','7032',1),('7033','7033',1),('7034','7034',1),('7035','7035',1),('7036','7036',1),('7037','7037',1),('7038','7038',1),('7039','7039',1),('7040','7040',1),('7041','7041',1),('7043','7043',1),('7044','7044',1),('7045','7045',1),('-1','-1',1),('7006','7006',1),('7007','7007',1),('7008','7008',1),('7009','7009',1),('7011','7011',1),('7046','7046',1),('7047','7047',1),('7048','7048',1),('7049','7049',1),('7050','7050',1),('7051','7051',1),('7052','7052',1),('7054','7054',1),('7055','7055',1),('7056','7056',1),('7057','7057',1),('7058','7058',1),('7059','7059',1),('7060','7060',1),('7061','7061',1),('7062','7062',1),('7063','7063',1),('7065','7065',1),('7066','7066',1),('7067','7067',1),('7068','7068',1),('7069','7069',1),('7070','7070',1),('7004','7004',1),('7005','7005',1),('7071','7071',1),('7116','7202',1),('7117','7202',1),('7175','7202',1),('7176','7202',1),('7118','7202',1),('7119','7202',1),('7120','7202',1),('7121','7202',1),('7122','7202',1),('7123','7202',1),('7124','7202',1),('7125','7202',1),('7126','7202',1),('7127','7202',1),('7128','7202',1),('7129','7202',1),('7130','7202',1),('7131','7202',1),('7132','7202',1),('7133','7202',1),('7134','7202',1),('7135','7202',1),('7136','7202',1),('7137','7202',1),('7138','7202',1),('7139','7202',1),('7140','7202',1),('7141','7202',1),('7142','7202',1),('7153','7202',1),('7143','7202',1),('7144','7202',1),('7145','7202',1),('7146','7202',1),('7147','7202',1),('7148','7202',1),('7149','7202',1),('7150','7202',1),('7151','7202',1),('7152','7202',1),('7154','7202',1),('7155','7202',1),('7156','7202',1),('7157','7202',1),('7158','7202',1),('7159','7202',1),('7196','7202',1),('7160','7202',1),('7161','7202',1),('7162','7202',1),('7163','7202',1),('7164','7202',1),('7165','7202',1),('7166','7202',1),('7167','7202',1),('7168','7202',1),('7169','7202',1),('7170','7202',1),('7171','7202',1),('7172','7202',1),('7173','7202',1),('7174','7202',1),('7177','7202',1),('7178','7202',1),('7179','7202',1),('7180','7202',1),('7181','7202',1),('7182','7202',1),('7183','7202',1),('7184','7202',1),('7185','7202',1),('7186','7202',1),('7187','7202',1),('7188','7202',1),('7189','7202',1),('7190','7202',1),('7191','7202',1),('7116','7116',2),('7117','7117',2),('7175','7175',2),('7176','7176',2),('7118','7116',2),('7119','7116',2),('7120','7116',2),('7121','7116',2),('7122','7116',2),('7123','7116',2),('7124','7116',2),('7125','7116',2),('7126','7116',2),('7127','7116',2),('7128','7116',2),('7129','7116',2),('7130','7117',2),('7131','7117',2),('7132','7117',2),('7133','7117',2),('7134','7117',2),('7135','7117',2),('7136','7117',2),('7137','7117',2),('7138','7117',2),('7139','7117',2),('7140','7117',2),('7141','7117',2),('7142','7117',2),('7153','7117',2),('7143','7116',2),('7144','7116',2),('7145','7116',2),('7146','7116',2),('7147','7117',2),('7148','7117',2),('7149','7117',2),('7150','7117',2),('7151','7117',2),('7152','7117',2),('7154','7116',2),('7155','7116',2),('7156','7116',2),('7157','7116',2),('7158','7116',2),('7159','7117',2),('7196','7117',2),('7160','7117',2),('7161','7117',2),('7162','7117',2),('7163','7117',2),('7164','7117',2),('7165','7117',2),('7166','7117',2),('7167','7117',2),('7168','7117',2),('7169','7117',2),('7170','7117',2),('7171','7117',2),('7172','7117',2),('7173','7117',2),('7174','7117',2),('7177','7116',2),('7178','7116',2),('7179','7116',2),('7180','7116',2),('7181','7117',2),('7182','7117',2),('7183','7117',2),('7184','7117',2),('7185','7117',2),('7186','7117',2),('7187','7117',2),('7188','7117',2),('7189','7117',2),('7190','7117',2),('7191','7117',2),('7118','7118',3),('7119','7119',3),('7120','7120',3),('7121','7121',3),('7122','7122',3),('7123','7123',3),('7124','7124',3),('7125','7125',3),('7126','7126',3),('7127','7127',3),('7128','7128',3),('7129','7129',3),('7130','7130',3),('7131','7131',3),('7132','7132',3),('7133','7133',3),('7134','7134',3),('7135','7135',3),('7136','7136',3),('7137','7137',3),('7138','7138',3),('7139','7139',3),('7140','7140',3),('7141','7141',3),('7142','7142',3),('7153','7153',3),('7143','7118',3),('7144','7118',3),('7145','7118',3),('7146','7118',3),('7147','7131',3),('7148','7133',3),('7149','7133',3),('7150','7133',3),('7151','7133',3),('7152','7133',3),('7154','7118',3),('7155','7118',3),('7156','7119',3),('7157','7119',3),('7158','7119',3),('7159','7130',3),('7196','7131',3),('7160','7133',3),('7161','7133',3),('7162','7133',3),('7163','7133',3),('7164','7133',3),('7165','7133',3),('7166','7133',3),('7167','7133',3),('7168','7133',3),('7169','7133',3),('7170','7133',3),('7171','7131',3),('7172','7131',3),('7173','7131',3),('7174','7131',3),('7177','7119',3),('7178','7119',3),('7179','7119',3),('7180','7119',3),('7181','7131',3),('7182','7131',3),('7183','7131',3),('7184','7131',3),('7185','7131',3),('7186','7131',3),('7187','7133',3),('7188','7133',3),('7189','7133',3),('7190','7131',3),('7191','7131',3),('7143','7143',4),('7144','7144',4),('7145','7145',4),('7146','7146',4),('7147','7147',4),('7148','7148',4),('7149','7149',4),('7150','7150',4),('7151','7151',4),('7152','7152',4),('7154','7154',4),('7155','7155',4),('7156','7156',4),('7157','7157',4),('7158','7158',4),('7159','7159',4),('7196','7196',4),('7160','7148',4),('7161','7148',4),('7162','7149',4),('7163','7149',4),('7164','7149',4),('7165','7149',4),('7166','7150',4),('7167','7150',4),('7168','7150',4),('7169','7150',4),('7170','7152',4),('7171','7147',4),('7172','7147',4),('7173','7147',4),('7174','7147',4),('7177','7156',4),('7178','7156',4),('7179','7156',4),('7180','7156',4),('7181','7147',4),('7182','7147',4),('7183','7147',4),('7184','7147',4),('7185','7147',4),('7186','7147',4),('7187','7150',4),('7188','7150',4),('7189','7150',4),('7190','7147',4),('7191','7147',4),('7160','7160',5),('7161','7161',5),('7162','7162',5),('7163','7163',5),('7164','7164',5),('7165','7165',5),('7166','7166',5),('7167','7167',5),('7168','7168',5),('7169','7169',5),('7170','7170',5),('7171','7171',5),('7172','7172',5),('7173','7173',5),('7174','7174',5),('7177','7177',5),('7178','7178',5),('7179','7179',5),('7180','7180',5),('7181','7181',5),('7182','7182',5),('7183','7183',5),('7184','7184',5),('7185','7185',5),('7186','7186',5),('7187','7168',5),('7188','7168',5),('7189','7168',5),('7190','7174',5),('7191','7174',5),('7187','7187',6),('7188','7188',6),('7189','7189',6),('7190','7190',6),('7191','7191',6); /*!40000 ALTER TABLE `T5` ENABLE KEYS */; UNLOCK TABLES;