--source include/have_innodb.inc --disable_query_log set global innodb_file_per_table=1; CREATE TABLE `mad_partner` ( `OID` varchar(40) COLLATE utf8mb4_bin NOT NULL, `changeTime` datetime NOT NULL, `changer` varchar(128) COLLATE utf8mb4_bin NOT NULL, `creationTime` datetime NOT NULL, `creator` varchar(128) COLLATE utf8mb4_bin NOT NULL, `code` varchar(128) COLLATE utf8mb4_bin NOT NULL, `name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `deactivated` bit(1) NOT NULL, `labels` mediumtext COLLATE utf8mb4_bin, `urn` varchar(128) COLLATE utf8mb4_bin NOT NULL, `organizationOID` varchar(40) COLLATE utf8mb4_bin NOT NULL, `phoneNumber` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL, `faxNumber` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL, `eMailAddress` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL, `webAddress` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `taxIDNumber` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `taxIDType` varchar(32) COLLATE utf8mb4_bin NOT NULL, `profileLabels` varchar(2000) COLLATE utf8mb4_bin DEFAULT NULL, `linked_crm` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL, `chamberOfCommerceNumber` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `dunsNumber` varchar(9) COLLATE utf8mb4_bin DEFAULT NULL, `lwi_addresstool_id` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL, `cinType` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL, `CIN` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `locked` tinyint(1) NOT NULL DEFAULT '0', `eoriNumber` varchar(17) COLLATE utf8mb4_bin DEFAULT NULL, `dunsAddress` varchar(512) COLLATE utf8mb4_bin DEFAULT NULL, `lastLookupUser` varchar(512) COLLATE utf8mb4_bin DEFAULT NULL, `lastLookupDate` date DEFAULT NULL, `lastQuickCheckUser` varchar(512) COLLATE utf8mb4_bin DEFAULT NULL, `lastQuickCheckDate` date DEFAULT NULL, `businessType` varchar(32) COLLATE utf8mb4_bin NOT NULL, `vatGroup_OID` varchar(40) COLLATE utf8mb4_bin DEFAULT NULL, PRIMARY KEY (`OID`), UNIQUE KEY `organizationOID` (`organizationOID`,`code`), UNIQUE KEY `idx_urn` (`urn`,`organizationOID`), KEY `FK_PARTNER_VAT_GROUP` (`vatGroup_OID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC; lock table mad_partner write; ALTER TABLE `mad_partner` DISABLE KEYS; INSERT INTO `mad_partner` (`OID`, `changeTime`, `changer`, `creationTime`, `creator`, `code`, `name`, `deactivated`, `labels`, `urn`, `organizationOID`, `phoneNumber`, `faxNumber`, `eMailAddress`, `webAddress`, `taxIDNumber`, `taxIDType`, `profileLabels`, `linked_crm`, `chamberOfCommerceNumber`, `dunsNumber`, `lwi_addresstool_id`, `cinType`, `CIN`, `locked`, `eoriNumber`, `dunsAddress`, `lastLookupUser`, `lastLookupDate`, `lastQuickCheckUser`, `lastQuickCheckDate`, `businessType`, `vatGroup_OID`) VALUES (X'31333832383039642D653234652D343830312D383265342D316165386537623061663030','2017-05-23 13:45:39',X'64756D6D794075736572','2017-04-24 09:47:41',X'64756D6D794075736572',X'4C4252414E44574853',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A31333832383039642D653234652D343830312D383265342D3161653865376230616630304043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'55535F45494E',X'353030313020',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'31623639663263392D653438632D346234622D623164352D373264643239653235343034','2017-05-29 09:39:05',X'64756D6D794075736572','2017-04-24 16:47:28',X'64756D6D794075736572',X'464544455850414D53',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A31623639663263392D653438632D346234622D623164352D3732646432396532353430344043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'35303031312020',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'31636263383432322D323435342D343437352D396538302D643161656461623364366465','2017-07-24 09:06:13',X'64756D6D794075736572','2017-07-24 09:06:13',X'64756D6D794075736572',X'454C424553425558',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A31636263383432322D323435342D343437352D396538302D6431616564616233643664654043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'31656234373265372D353730622D343231322D616463312D303363376639356335336639','2017-09-25 13:10:29',X'64756D6D794075736572','2017-09-25 13:10:28',X'64756D6D794075736572',X'53454B4C4F47484B',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A31656234373265372D353730622D343231322D616463312D3033633766393563353366394043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'4F54484552',X'353030333020',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'32353533373663612D636632362D346531312D613561322D306263393033613838623236','2017-08-29 10:00:58',X'64756D6D794075736572','2017-04-03 13:31:41',X'64756D6D794075736572',X'5343484C4F47454552',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A32353533373663612D636632362D346531312D613561322D3062633930336138386232364043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'20353030323220',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'32646137396634612D623863662D346434322D383737612D336662306430353433633133','2017-05-11 13:47:11',X'64756D6D794075736572','2017-04-26 09:52:20',X'64756D6D794075736572',X'414753',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A32646137396634612D623863662D346434322D383737612D3366623064303534336331334043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'33353737633134642D396437382D343533362D623836362D623263393037346136636230','2017-05-11 13:47:06',X'64756D6D794075736572','2017-04-03 13:54:56',X'64756D6D794075736572',X'504947494E545A4F54',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A33353737633134642D396437382D343533362D623836362D6232633930373461366362304043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'34306664353034642D633130312D346538322D626564312D373133366365316636313932','2017-07-13 14:00:03',X'64756D6D794075736572','2017-07-13 13:38:29',X'64756D6D794075736572',X'534C45444745435241',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A34306664353034642D633130312D346538322D626564312D3731333663653166363139324043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'55535F45494E',X'353030303620',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'34333832363361622D393936382D343930642D623866312D303037623366363365343331','2017-05-29 13:54:46',X'64756D6D794075736572','2017-05-29 09:13:40',X'64756D6D794075736572',X'414D52455354',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A34333832363361622D393936382D343930642D623866312D3030376233663633653433314043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'353030313720',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'34363066633561362D613639312D343831662D616665342D323334353731383839613233','2017-09-18 13:41:33',X'64756D6D794075736572','2017-09-18 13:41:33',X'64756D6D794075736572',X'42494B45564552544953494E47',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A34363066633561362D613639312D343831662D616665342D3233343537313838396132334043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'353030323820',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'34373865396238642D386632612D346437642D393864302D326361386639393839326435','2017-06-08 15:14:04',X'64756D6D794075736572','2017-06-08 15:14:03',X'64756D6D794075736572',X'4150524F504F53',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A34373865396238642D386632612D346437642D393864302D3263613866393938393264354043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'55535F45494E',X'353030303520',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'34376237616236312D663233312D343431322D623134632D633464333963386133373333','2017-05-29 10:35:33',X'64756D6D794075736572','2017-05-29 09:16:01',X'64756D6D794075736572',X'444F524D415236',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A34376237616236312D663233312D343431322D623134632D6334643339633861333733334043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'34653366353963632D643036392D346132642D383362642D383065633065383138353434','2017-05-29 09:30:30',X'64756D6D794075736572','2017-05-29 09:30:30',X'64756D6D794075736572',X'50454E534B4520574853',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A34653366353963632D643036392D346132642D383362642D3830656330653831383534344043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'35323462623939352D323030622D346163612D393437642D373265343362343534366130','2017-09-18 13:33:19',X'64756D6D794075736572','2017-09-18 13:33:19',X'64756D6D794075736572',X'5448454241524E',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A35323462623939352D323030622D346163612D393437642D3732653433623435343661304043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'353030323720',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'35363432316530662D623461392D343766372D613130362D306331666237373035323739','2017-05-29 10:36:39',X'64756D6D794075736572','2017-05-29 09:15:06',X'64756D6D794075736572',X'57554D4C4144454E',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A35363432316530662D623461392D343766372D613130362D3063316662373730353237394043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'35616533356437372D646537312D343835332D613736312D393965373266363435623831','2017-07-25 13:15:38',X'64756D6D794075736572','2017-04-04 15:54:58',X'64756D6D794075736572',X'53454B42454E414D53',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A35616533356437372D646537312D343835332D613736312D3939653732663634356238314043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'353030303420353030313020',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'35666630363763322D663864382D346263332D623266652D643462613562633432633831','2017-05-19 13:32:53',X'64756D6D794075736572','2017-05-19 13:32:53',X'64756D6D794075736572',X'5745534C4F4E313637303031',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A35666630363763322D663864382D346263332D623266652D6434626135626334326338314043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'36363838373633302D666133322D343432382D393862612D343861336333366166373037','2017-05-11 13:39:24',X'64756D6D794075736572','2017-03-30 10:50:36',X'64756D6D794075736572',X'4C4252414E4453',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A36363838373633302D666133322D343432382D393862612D3438613363333661663730374043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'55535F45494E',X'353030303520353030303320',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'36376336306435392D313038332D343234642D383566642D323936383330663437623431','2017-09-21 15:26:28',X'64756D6D794075736572','2017-09-04 14:13:00',X'64756D6D794075736572',X'464153464F52414D53',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A36376336306435392D313038332D343234642D383566642D3239363833306634376234314043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'353030323520',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'36643365343833372D366431372D343533622D623136372D616334393336626666646163','2017-06-08 15:17:18',X'64756D6D794075736572','2017-06-08 15:17:18',X'64756D6D794075736572',X'524F59534F4E53',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A36643365343833372D366431372D343533622D623136372D6163343933366266666461634043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'55535F45494E',X'',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'36663136303263312D613266322D343739612D613965322D366664343661326366393332','2017-06-26 11:19:27',X'64756D6D794075736572','2017-06-26 11:18:36',X'64756D6D794075736572',X'414F4E524953524F54',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A36663136303263312D613266322D343739612D613965322D3666643436613263663933324043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'353030313820',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'37313434613063642D653333652D343366632D386231632D326161633536636631613634','2017-05-11 13:46:49',X'64756D6D794075736572','2017-05-01 14:42:37',X'64756D6D794075736572',X'53454B4C4F474C4F4E',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A37313434613063642D653333652D343366632D386231632D3261616335366366316136344043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'353030313220',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'37353765613431652D336165642D346637612D383133382D653863363438363335313562','2017-07-20 13:51:50',X'64756D6D794075736572','2017-04-18 15:46:21',X'64756D6D794075736572',X'424C4F42524154414D',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A37353765613431652D336165642D346637612D383133382D6538633634383633353135624043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'55535F45494E',X'353030303920353030303020',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'37613039306139382D303865632D343932342D616331612D643462343563373439636163','2017-04-06 11:53:41',X'64756D6D794075736572','2017-03-29 12:48:28',X'64756D6D794075736572',X'43414C4D4944445542',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A37613039306139382D303865632D343932342D616331612D6434623435633734396361634043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'4F54484552',X'',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'37616665343334372D613333632D343866342D396232332D333138393964666636343731','2017-05-30 11:59:44',X'64756D6D794075736572','2017-04-06 13:38:05',X'64756D6D794075736572',X'53454B42454E52544D',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A37616665343334372D613333632D343866342D396232332D3331383939646666363437314043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'353030303620',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'37633630323835372D323534662D343666392D623836372D663866623233656664316236','2017-05-11 13:39:03',X'64756D6D794075736572','2017-03-30 10:59:02',X'64756D6D794075736572',X'485549494E54434F52',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A37633630323835372D323534662D343666392D623836372D6638666232336566643162364043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'20',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'38333033316163622D343363642D346339372D393633652D383639326130303761626135','2017-04-06 11:53:31',X'64756D6D794075736572','2017-03-29 12:53:03',X'64756D6D794075736572',X'43414C414D45434F4C',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A38333033316163622D343363642D346339372D393633652D3836393261303037616261354043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'55535F45494E',X'',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'38363033343939632D636538612D343733622D393365342D653564646239373334656433','2017-05-11 13:33:36',X'64756D6D794075736572','2017-04-18 14:15:48',X'64756D6D794075736572',X'43414E4E4F4E504C414345',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A38363033343939632D636538612D343733622D393365342D6535646462393733346564334043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'38376263393332332D626364392D346432312D616265312D313265363536393663343336','2017-08-29 10:10:39',X'64756D6D794075736572','2017-07-24 09:01:54',X'64756D6D794075736572',X'5554532048414D',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A38376263393332332D626364392D346432312D616265312D3132653635363936633433364043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'20353030323420',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'38383931323033312D306665322D346332372D626463642D633034613764336134306530','2017-08-01 13:10:14',X'64756D6D794075736572','2017-07-13 14:07:10',X'64756D6D794075736572',X'44494749434F425241',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A38383931323033312D306665322D346332372D626463642D6330346137643361343065304043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'55535F45494E',X'353030303720',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'38393539336137302D316637342D343436362D396164662D633861333662343665643632','2017-05-11 13:39:32',X'64756D6D794075736572','2017-04-04 14:26:49',X'64756D6D794075736572',X'4D4153474C4F434257',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A38393539336137302D316637342D343436362D396164662D6338613336623436656436324043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'55535F45494E',X'353030303320',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'38616362376134612D386634342D346462662D393234312D333461353937346134656266','2017-06-07 13:26:19',X'64756D6D794075736572','2017-06-07 13:26:18',X'64756D6D794075736572',X'57484153484F50',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A38616362376134612D386634342D346462662D393234312D3334613539373461346562664043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'38623830643837652D653634322D343365352D383130362D386238333431313162326538','2017-05-11 13:37:19',X'64756D6D794075736572','2017-04-18 12:08:01',X'64756D6D794075736572',X'48524341495244414D',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A38623830643837652D653634322D343365352D383130362D3862383334313131623265384043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'353030303820',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'38633166623161652D323565322D343966382D626236612D363562353731366430643262','2017-09-14 09:35:46',X'64756D6D794075736572','2017-03-29 12:54:38',X'64756D6D794075736572',X'43414C415349484F4E',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A38633166623161652D323565322D343966382D626236612D3635623537313664306432624043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'4F54484552',X'',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'38666162336436652D323635382D343364612D383836362D376162373563313461626531','2017-10-05 11:48:47',X'64756D6D794075736572','2017-08-29 10:54:04',X'64756D6D794075736572',X'485950534F53',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A38666162336436652D323635382D343364612D383836362D3761623735633134616265314043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'353030313120',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'39313534396465302D663030312D343131622D396665392D316361366632363336623966','2017-05-11 13:37:11',X'64756D6D794075736572','2017-04-03 13:34:24',X'64756D6D794075736572',X'49495454414C4F4F53',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A39313534396465302D663030312D343131622D396665392D3163613666323633366239664043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'353030303120',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'39343036303761632D383237612D346433382D396466312D626563646135303335343238','2017-07-20 11:55:20',X'64756D6D794075736572','2017-07-20 11:55:20',X'64756D6D794075736572',X'53414C4F4E4C4F465453',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A39343036303761632D383237612D346433382D396466312D6265636461353033353432384043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'55535F45494E',X'353030303920',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'39346134343239322D663437312D343131632D383664302D386132643965623462323361','2017-05-18 14:28:04',X'64756D6D794075736572','2017-05-18 13:30:28',X'64756D6D794075736572',X'504C55464143434F4C',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A39346134343239322D663437312D343131632D383664302D3861326439656234623233614043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'55535F45494E',X'353030313520353030303420',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'39373464613462662D636132352D343231642D396261612D336631323462623137343130','2017-10-02 14:10:00',X'64756D6D794075736572','2017-10-02 14:10:00',X'64756D6D794075736572',X'43414C534945455850',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A39373464613462662D636132352D343231642D396261612D3366313234626231373431304043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'55535F45494E',X'353030313320',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'39373937636666612D393261372D343463642D386339652D643464653737613236383835','2017-05-11 14:13:53',X'64756D6D794075736572','2017-05-11 14:13:53',X'64756D6D794075736572',X'485549494E54574348',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A39373937636666612D393261372D343463642D386339652D6434646537376132363838354043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'353030313420',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'39383564663234302D613231362D343332322D623130652D666464626464356330353566','2017-05-11 13:46:54',X'64756D6D794075736572','2017-03-30 10:55:23',X'64756D6D794075736572',X'434855425249313737303031',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A39383564663234302D613231362D343332322D623130652D6664646264643563303535664043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'39626533656632372D666136642D346234322D396339352D373735666630666530663633','2017-09-18 13:28:34',X'64756D6D794075736572','2017-09-18 13:25:18',X'64756D6D794075736572',X'445554434844455349474E',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A39626533656632372D666136642D346234322D396339352D3737356666306665306636334043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'353030323620',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'61373830323462382D353961342D343039362D623932662D663365383037653434383831','2017-07-18 14:29:59',X'64756D6D794075736572','2017-07-17 16:29:21',X'64756D6D794075736572',X'4156494154',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A61373830323462382D353961342D343039362D623932662D6633653830376534343838314043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'55535F45494E',X'353030323120353030303820',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'61656438323732382D373730612D343635652D623033612D636664373136356432383337','2017-05-11 13:39:17',X'64756D6D794075736572','2017-04-03 13:37:28',X'64756D6D794075736572',X'4D4149465245534845',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A61656438323732382D373730612D343635652D623033612D6366643731363564323833374043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'20353030303220',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'62356665363139382D313765662D343138312D396466342D383463633132396436636232','2017-09-21 15:29:27',X'64756D6D794075736572','2017-09-21 15:29:26',X'64756D6D794075736572',X'464153464F52474C41',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A62356665363139382D313765662D343138312D396466342D3834636331323964366362324043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'353030323920',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'62396330656664372D323266372D346636352D393135322D363534343536316132646532','2017-06-08 15:25:57',X'64756D6D794075736572','2017-04-06 13:59:01',X'64756D6D794075736572',X'53454B474C4F434849',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A62396330656664372D323266372D346636352D393135322D3635343435363161326465324043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'55535F45494E',X'35303030372035303030322020',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'62643466333861632D393730382D343738612D623235352D343835633838316133316636','2017-08-29 10:04:22',X'64756D6D794075736572','2017-08-29 10:04:21',X'64756D6D794075736572',X'51435343415252544D',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A62643466333861632D393730382D343738612D623235352D3438356338383161333166364043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'20353030323320',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'62646561613937332D376663662D343263662D393861642D393538306235356138303939','2017-08-29 11:12:15',X'64756D6D794075736572','2017-08-29 11:12:14',X'64756D6D794075736572',X'41525241592043414E414441',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A62646561613937332D376663662D343263662D393861642D3935383062353561383039394043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'4F54484552',X'353030313220',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'62653036376361352D366364332D343264632D386136382D613038653938303062313935','2017-04-06 11:53:04',X'64756D6D794075736572','2017-03-24 17:22:57',X'64756D6D794075736572',X'43414C474C4F41524E',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A62653036376361352D366364332D343264632D386136382D6130386539383030623139354043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'63356664336436612D663565392D346636382D613161642D346431316362343133333938','2017-05-11 13:46:19',X'64756D6D794075736572','2017-04-03 13:35:39',X'64756D6D794075736572',X'4D41534D4555545552',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A63356664336436612D663565392D346636382D613161642D3464313163623431333339384043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'63646665643466652D343539382D346234632D393561342D623534616433353064663035','2017-07-18 16:06:23',X'64756D6D794075736572','2017-06-29 13:40:00',X'64756D6D794075736572',X'50455253544545495341',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A63646665643466652D343539382D346234632D393561342D6235346164333530646630354043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'353030323020',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'64636166356339352D616539342D343034662D623635662D333365303238666663373531','2017-09-11 12:48:35',X'64756D6D794075736572','2017-09-07 15:26:40',X'64756D6D794075736572',X'574F524C4457494445',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A64636166356339352D616539342D343034662D623635662D3333653032386666633735314043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'4F54484552',X'353030303120',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'64666631666661372D353863322D343666332D393838302D396130326538653963386162','2017-04-06 11:54:11',X'64756D6D794075736572','2017-03-29 12:49:20',X'64756D6D794075736572',X'43414C474C4F434849',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A64666631666661372D353863322D343666332D393838302D3961303265386539633861624043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'4F54484552',X'',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'65303933663139362D643934342D343331342D393861362D666564333233626164323535','2017-06-08 15:25:43',X'64756D6D794075736572','2017-03-30 10:52:34',X'64756D6D794075736572',X'53454B4C4F474D494C',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A65303933663139362D643934342D343331342D393861362D6665643332336261643235354043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'20353030313320',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'65313534646334622D666361362D343363642D626463622D373330323464656330353063','2017-08-10 13:48:24',X'64756D6D794075736572','2017-08-10 13:47:59',X'64756D6D794075736572',X'43414C474C4F415248',X'44756D6D79204E616D65',b'1',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A65313534646334622D666361362D343363642D626463622D3733303234646563303530634043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'65346666663265622D383265372D343231322D386663312D306266623431616631613730','2017-07-24 10:13:16',X'64756D6D794075736572','2017-07-24 10:13:15',X'64756D6D794075736572',X'49474D41',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A65346666663265622D383265372D343231322D386663312D3062666234316166316137304043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'65393232363237642D396639352D346631352D616463362D306263316363666131336330','2017-05-11 13:47:00',X'64756D6D794075736572','2017-04-03 14:27:58',X'64756D6D794075736572',X'5A45494C49434C4943',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A65393232363237642D396639352D346631352D616463362D3062633163636661313363304043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'65633738663934342D366663342D343262662D613730622D366632343961393534633030','2017-07-11 14:13:37',X'64756D6D794075736572','2017-06-27 10:54:30',X'64756D6D794075736572',X'414C5348415941504C',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A65633738663934342D366663342D343262662D613730622D3666323439613935346330304043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'353030313920',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'66356663336666312D643566612D343030362D393336622D313232663038303163366662','2017-09-11 11:18:17',X'64756D6D794075736572','2017-09-07 13:57:27',X'64756D6D794075736572',X'53454B4C4F47534841',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A66356663336666312D643566612D343030362D393336622D3132326630383031633666624043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'4F54484552',X'353030303020',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL), (X'66633831306662662D386634392D343935302D623437302D616663633534396635366636','2017-05-23 13:50:11',X'64756D6D794075736572','2017-05-23 13:50:11',X'64756D6D794075736572',X'53454B4C4F47445542',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A66633831306662662D386634392D343935302D623437302D6166636335343966353666364043414C5F4C697665',X'65306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'45555F5641545F4944',X'353030313620',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL); ALTER TABLE `mad_partner` ENABLE KEYS; unlock tables; --enable_query_log SELECT DISTINCT partner0_.organizationOID as col FROM mad_partner partner0_ WHERE partner0_.OID IN ( 'be067ca5-6cd3-42dc-8a68-a08e9800b195', 'dff1ffa7-58c2-46f3-9880-9a02e8e9c8ab', '8c1fb1ae-25e2-49f8-bb6a-65b5716d0d2b', '7a090a98-08ec-4924-ac1a-d4b45c749cac', '83031acb-43cd-4c97-963e-8692a007aba5'); SELECT DISTINCT partner0_.organizationOID as col1 FROM mad_partner partner0_ WHERE partner0_.OID IN ( 'dff1ffa7-58c2-46f3-9880-9a02e8e9c8ab', '7a090a98-08ec-4924-ac1a-d4b45c749cac', 'be067ca5-6cd3-42dc-8a68-a08e9800b195'); SELECT DISTINCT partner0_.organizationOID as col2 FROM mad_partner partner0_ WHERE partner0_.OID IN ( '8c1fb1ae-25e2-49f8-bb6a-65b5716d0d2b', '83031acb-43cd-4c97-963e-8692a007aba5'); SELECT DISTINCT partner0_.organizationOID as col FROM mad_partner partner0_ ignore index(organizationOID) WHERE partner0_.OID IN ( 'be067ca5-6cd3-42dc-8a68-a08e9800b195', 'dff1ffa7-58c2-46f3-9880-9a02e8e9c8ab', '8c1fb1ae-25e2-49f8-bb6a-65b5716d0d2b', '7a090a98-08ec-4924-ac1a-d4b45c749cac', '83031acb-43cd-4c97-963e-8692a007aba5'); optimize table mad_partner; #INSERT INTO `mad_partner` (`OID`, `changeTime`, `changer`, `creationTime`, `creator`, `code`, `name`, `deactivated`, `labels`, `urn`, `organizationOID`, `phoneNumber`, `faxNumber`, `eMailAddress`, `webAddress`, `taxIDNumber`, `taxIDType`, `profileLabels`, `linked_crm`, `chamberOfCommerceNumber`, `dunsNumber`, `lwi_addresstool_id`, `cinType`, `CIN`, `locked`, `eoriNumber`, `dunsAddress`, `lastLookupUser`, `lastLookupDate`, `lastQuickCheckUser`, `lastQuickCheckDate`, `businessType`, `vatGroup_OID`) #VALUES # (X'01333832383039642D653234652D343830312D383265342D316165386537623061663030','2017-05-23 13:45:39',X'64756D6D794075736572','2017-04-24 09:47:41',X'64756D6D794075736572',X'4C4252414E44574853',X'44756D6D79204E616D65',b'0',NULL,X'75726E3A782D7273693A73636F70653A706172746E65723A31333832383039642D653234652D343830312D383265342D3161653865376230616630304043414C5F4C697669',X'05306635323134312D393431622D343337632D383761352D646666336634663734393939',X'4E554C4C',NULL,X'4E554C4C',X'4E554C4C',X'4E554C4C',X'55535F45494E',X'353030313020',NULL,X'4E554C4C',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,X'425553494E455353',NULL); SELECT DISTINCT partner0_.organizationOID as col FROM mad_partner partner0_ WHERE partner0_.OID IN ( 'be067ca5-6cd3-42dc-8a68-a08e9800b195', 'dff1ffa7-58c2-46f3-9880-9a02e8e9c8ab', '8c1fb1ae-25e2-49f8-bb6a-65b5716d0d2b', '7a090a98-08ec-4924-ac1a-d4b45c749cac', '83031acb-43cd-4c97-963e-8692a007aba5'); SELECT DISTINCT partner0_.organizationOID as col1 FROM mad_partner partner0_ WHERE partner0_.OID IN ( 'dff1ffa7-58c2-46f3-9880-9a02e8e9c8ab', '7a090a98-08ec-4924-ac1a-d4b45c749cac', 'be067ca5-6cd3-42dc-8a68-a08e9800b195'); SELECT DISTINCT partner0_.organizationOID as col2 FROM mad_partner partner0_ WHERE partner0_.OID IN ( '8c1fb1ae-25e2-49f8-bb6a-65b5716d0d2b', '83031acb-43cd-4c97-963e-8692a007aba5'); create table t1 like mad_partner; insert into t1 select * from mad_partner; drop table mad_partner; create table mad_partner like t1; insert into mad_partner select * from t1; SELECT DISTINCT partner0_.organizationOID as col FROM mad_partner partner0_ WHERE partner0_.OID IN ( 'be067ca5-6cd3-42dc-8a68-a08e9800b195', 'dff1ffa7-58c2-46f3-9880-9a02e8e9c8ab', '8c1fb1ae-25e2-49f8-bb6a-65b5716d0d2b', '7a090a98-08ec-4924-ac1a-d4b45c749cac', '83031acb-43cd-4c97-963e-8692a007aba5'); SELECT DISTINCT partner0_.organizationOID as col1 FROM mad_partner partner0_ WHERE partner0_.OID IN ( 'dff1ffa7-58c2-46f3-9880-9a02e8e9c8ab', '7a090a98-08ec-4924-ac1a-d4b45c749cac', 'be067ca5-6cd3-42dc-8a68-a08e9800b195'); SELECT DISTINCT partner0_.organizationOID as col2 FROM mad_partner partner0_ WHERE partner0_.OID IN ( '8c1fb1ae-25e2-49f8-bb6a-65b5716d0d2b', '83031acb-43cd-4c97-963e-8692a007aba5'); drop table mad_partner;