fetch sql data

fetch.sql

INSERT INTO `fetch_matchdomain` (`id`, `currency_symbol`, `domain_name`, `priority`, `region`, `description`, `notes`, `provider_id`, `exact_match`)
VALUES
	(1, X'24', X'616D617A6F6E2E636F6D', 1, X'5553', X'416D617A6F6E2E636F6D205553', X'', 2, NULL),
	(5, X'24', X'616D617A6F6E2E6361', 1, X'4341', X'416D617A6F6E2043616E616461', X'', 2, NULL),
	(6, X'C2A3', X'616D617A6F6E2E636F2E756B', 1, X'554B', X'416D617A6F6E20556E69746564204B696E67646F6D', X'', 2, NULL),
	(7, X'E282AC', X'616D617A6F6E2E6465', 1, X'4445', X'416D617A6F6E204765726D616E79', X'', 2, NULL),
	(8, X'24', X'7777772E746F79737275732E636F6D', 1, X'', X'546F79732052205573', X'546F7973205220557320697320626C6F636B696E672064696666626F742C20736F20747279696E67207769746820456D6265642E6C7920666F722061207768696C65202031312F3230206261636B20746F2064696666626F742063616E20676574207072696365', 3, NULL),
	(11, X'24', X'666F6F746C6F636B65722E636F2E756B', 1, X'', X'', X'', 3, NULL),
	(12, X'24', X'7777772E6C65626F7264656C646567656F7267657474652E636F6D', 1, X'', X'', X'', 3, NULL),
	(15, X'E282AC', X'616D617A6F6E2E6974', 1, X'4954', X'416D617A6F6E204974616C79', X'', 2, NULL),
	(16, X'E282AC', X'616D617A6F6E2E6672', 1, X'4652', X'416D617A6F6E204672616E6365', X'', 2, NULL),
	(19, X'24', X'6164696461732E636F6D', 1, X'', X'', X'73706F7474656420696E206C6F672C206661696C732064696666626F742C20737563636565647320656D6265646C792C20202074657374206C696E6B3A202068747470733A2F2F7777772E6164696461732E636F6D2F75732F6164697A65726F2D352D737461722D362E302D6D69642D636C656174732F4257313039322E68746D6C', 3, NULL),
	(20, X'24', X'66616D6F7573666F6F74776561722E636F6D', 1, X'', X'', X'66726F6D20637573746F6D65722063616C6C2E20206661696C65732064696666626F742C20737563636565647320696D6265646C79202074657374206C696E6B3A2068747470733A2F2F7777772E66616D6F7573666F6F74776561722E636F6D2F656E2D55532F50726F647563742F37333139302D313034323337312F536175636F6E792F426C61636B5F57686974652B54776973742F576F6D656E732B332B5061636B2B52656D69782B4C6F772B4375742B5461622B536F636B732E61737078', 3, NULL),
	(21, X'24', X'6261737370726F2E636F6D', 1, X'', X'', X'6661696C732064696666626F7420696E7374616E746C792C206F6B206F6E20656D6265646C79202074657374206C696E6B3A20687474703A2F2F7777772E6261737370726F2E636F6D2F73686F702F656E2F626173732D70726F2D73686F70732D33302D71756172742D70726F70616E652D7475726B65792D6672796572', 3, NULL),
	(22, X'24', X'67726F75706F6E2E636F6D', 1, X'', X'', X'74696D6573206F7574206F6E2064696666626F742C206F6B206F6E20656D6265646C79202074657374206C696E6B3A2068747470733A2F2F7777772E67726F75706F6E2E636F6D2F6465616C732F77756F6C6C65742D62616B6572792D6D696E6E6561706F6C69732D63616B65732D70617374726965732D70696573', 3, NULL),
	(25, X'24', X'67726F75706F6E2E636F2E756B', 1, X'', X'', X'746573742075726C3A2068747470733A2F2F7777772E67726F75706F6E2E636F2E756B2F6465616C732F746967692D7368616D706F6F2D616E642D636F6E646974696F6E65722D7365742D31383F75746D5F63616D706169676E3D55736572526566657272616C5F6D69682675746D5F736F757263653D756E646566696E65642675746D5F6D656469756D3D736D73', 3, NULL),
	(26, X'24', X'6D2E746F79737275732E636F6D', 1, X'', X'', X'', 4, NULL),
	(28, X'24', X'7261792D62616E2E636F6D', 1, X'', X'6F6B206F6E20656D6265646C79', X'68747470733A2F2F7777772E7261792D62616E2E636F6D2F7573612F73756E676C61737365732F52423330323520554E49534558203034332D61766961746F7220636C61737369632D676F6C642F3830353238393630323035373F63617465676F72795F49643D333332363037', 3, NULL),
	(29, X'24', X'737765657477617465722E636F6D', 1, X'', X'7265706F72746564206279206D656D626572', X'68747470733A2F2F7777772E737765657477617465722E636F6D2F73746F72652F64657461696C2F53432D3139415C', 3, NULL),
	(32, X'24', X'626C6F6F6D696E6764616C65732E636F6D', 1, X'', X'', X'68747470733A2F2F7777772E626C6F6F6D696E6764616C65732E636F6D2F73686F702F70726F647563742F6E65772D62616C616E63652D776F6D656E732D3432302D6C6163652D75702D736E65616B6572733F49443D3235343031303926706C615F636F756E7472793D555326636D5F6D6D633D476F6F676C652D504C412D4144432D5F2D576F6D656E2532377325323053686F65732D4E412D5F2D4E657725323042616C616E63652D5F2D31393132363431313131323755534126434157454C4149443D313230', 3, NULL),
	(33, X'24', X'66616E61746963732E636F6D', 1, NULL, NULL, X'68747470733A2F2F7777772E66616E61746963732E636F6D2F6E62612D7068696C6164656C706869612D37366572732D6A6F656C2D656D626969642D7068696C6164656C706869612D37366572732D6E696B652D7377696E676D616E2D6A65727365792D626C75652D69636F6E2D65646974696F6E2F6F2D323430332B742D33363336343235362B702D39313936303136373336332B7A2D392D363236323034393135', 7, NULL),
	(34, X'24', X'6861796E6565646C652E636F6D', 1, X'', X'6661696C696E67206F6E2064696666626F74', X'68747470733A2F2F7777772E6861796E6565646C652E636F6D2F70726F647563742F7261696E77697A617264343067616C6C6F6E7261696E62617272656C6F616B2E63666D3F736F757263653D706C61266B7769643D5261696E42617272656C7325323069707265666572267469643D4749443033362D31266164747970653D706C61266B773D266C7366743D6164747970653A706C612667636C69643D4541496149516F6243684D49365979635F6362533177495654626A414368315935774244454151594279', 3, NULL),
	(35, X'24', X'6361726C6F7373686F65732E636F6D', 1, X'', X'64696666626F742074696D6573206F75742C20656D6265646C7920676F6F64', X'687474703A2F2F7777772E6361726C6F7373686F65732E636F6D2F656E2D55532F50726F647563742F37393832362D353235343130302F4341524C4F532B42592B4341524C4F532B53414E54414E412F426C61636B2F576F6D656E732B457474612B426F6F7469652E61737078', 3, NULL),
	(36, X'24', X'6D2E746F79737275732E636F6D2E6175', 1, X'', X'', X'2068747470733A2F2F6D2E746F79737275732E636F6D2E61752F626F6F6E2D70756C702D73696C69636F6E652D6665656465722D626C75652F6F72616E67655F343238363031382F', 3, NULL),
	(38, X'24', X'6C616E646F666E6F642E636F6D', 1, X'', X'626C6F636B696E672064696666626F74', X'68747470733A2F2F7777772E6C616E646F666E6F642E636F6D2F6368657762656164732D626162792D73696C69636F6E652D6C696E6B732F73343434353434', 3, NULL),
	(40, X'24', X'6D2E6D616379732E636F6D', 1, X'', X'64696666626F742074696D6573206F75742C20656D6265646C7920736C696768746C7920626574746572', X'68747470733A2F2F6D2E6D616379732E636F6D2F73686F702F70726F647563742F636C696E697175652D70617274792D657965732D70616C657474653F49443D353231303037382643617465676F727949443D3330303737', 3, NULL),
	(41, X'24', X'7461726765742E636F6D2E6175', 1, X'', X'696D61676520646973617070656172732061667465722064696666626F742066657463682C20616E6420656D6265646C7920646F6573207468652073616D65207468696E672120206D616B6573206D65207468696E6B206F757220696D6167652072657472696576616C20697320686176696E672074726F75626C652068657265', X'68747470733A2F2F7777772E7461726765742E636F6D2E61752F702F6E61766D616E2D6D6F766537352D6770732D6E617669676174696F6E2D73797374656D2F3630343235303538', 3, NULL),
	(43, X'24', X'626573746275792E636F6D', 1, NULL, X'426573742042757920626574746572206F6E2064696666626F742031312F3230207272', X'68747470733A2F2F7777772E626573746275792E636F6D2F736974652F6D6963726F736F66742D737572666163652D626F6F6B2D322D322D696E2D312D31332D352D746F7563682D73637265656E2D6C6170746F702D696E74656C2D636F72652D69352D3867622D6D656D6F72792D31323867622D736F6C69642D73746174652D64726976652D73696C7665722F363138313730352E703F736B7549643D363138313730352E2020526F6E206368616E676564207468697320746F20656D6265646C792061742031706D206F6E204F63742032', 7, NULL),
	(47, X'24', X'626573746275792E6361', 1, NULL, X'68747470733A2F2F7777772E626573746275792E63612F656E2D63612F70726F647563742F6C6F6769746563682D673932302D64726976696E672D666F7263652D726163652D776865656C2D666F7263652D666565646261636B2D7374656572696E672D776865656C2D3934312D3030303132312D72656675726269736865642F31323339373731382E617370783F', X'68747470733A2F2F7777772E626573746275792E63612F656E2D63612F70726F647563742F6C6F6769746563682D673932302D64726976696E672D666F7263652D726163652D776865656C2D666F7263652D666565646261636B2D7374656572696E672D776865656C2D3934312D3030303132312D72656675726269736865642F31323339373731382E617370783F', 3, NULL),
	(50, X'24', X'77616C6D6172742E636F6D', 1, NULL, NULL, X'', 9, NULL),
	(51, X'24', X'6D69636861656C732E636F6D', 1, NULL, X'67657474696E67206D6978656420726573756C7473206F6E2064696666626F7420736F2070757474696E6720656D6265646C79206669727374', X'68747470733A2F2F7777772E6D69636861656C732E636F6D2F637275736865642D61707269636F742D73656564732D62792D6172746D696E64732F31303036313739312E68746D6C', 3, NULL),
	(52, X'24', X'6D616379732E636F6D', 1, NULL, X'6661696C696E67206F6E2064696666626F742031312F32312F3138202064696666626F74206F6B20392F3139202031312F35206261636B20746F20656D6265646C79', X'68747470733A2F2F7777772E6D616379732E636F6D2F73686F702F70726F647563742F72616C70682D6C617572656E2D626162792D6769726C732D636F726475726F792D6F766572616C6C733F49443D36353232353931', 3, NULL),
	(54, X'E282AC', X'616D617A6F6E2E6573', 1, X'4553', X'416D617A6F6E20537061696E', X'', 2, NULL),
	(55, X'24', X'616D617A6F6E2E636F6D2E6175', 1, X'4155', X'416D617A6F6E204175737472616C6961', X'', 2, NULL),
	(56, X'24', X'636172746572732E636F6D', 1, NULL, X'68747470733A2F2F7777772E636172746572732E636F6D2F636172746572732D626162792D6769726C2D6E65772D6172726976616C732F565F31383836383031302E68746D6C', X'636172746572732072657475726E73206120626F74207761726E696E67207573696E672064696666626F742062757420776F726B73207769746820656D6265646C792E2E2E637573746F6D65722070726F76696465642070726F626C656D20646F6D61696E2E20207272', 3, NULL),
	(57, X'24', X'776179666169722E636F6D', 1, NULL, X'746F7020313020736974652C', X'656D6265646C79206265737420666F72207761796661697220382F32322F323220666C65786F666665727320697320616666696C6961746520706172746E6572', 3, NULL),
	(58, X'24', X'766F6E6D6175722E636F6D', 1, NULL, X'6E6F742067657474696E6720696D6167657320776974682064696666626F7420392F3139', X'', 3, NULL),
	(59, X'24', X'6E6F72647374726F6D2E636F6D', 1, NULL, X'676976696E6720626F74206D65737361676520746F2064696666626F74', X'656D6265646C79207374696C6C20626573742031312F3230207272202031312F31372F323220656D6265646C792067657474696E6720626C6F636B6564', 12, NULL),
	(60, X'24', X'6E666C73686F702E636F6D', 1, NULL, X'6661696C696E67206F6E2064696666626F742031312F3139', X'', 3, NULL),
	(61, X'24', X'6B69746368656E6169642E636F6D', 1, NULL, NULL, X'', 3, NULL),
	(62, X'24', X'6368696C6472656E73706C6163652E636F6D', 1, NULL, X'68747470733A2F2F7777772E6368696C6472656E73706C6163652E636F6D2F75732F702F426162792D416E642D546F64646C65722D4769726C732D4C6F6E672D536C656576652D466C656563652D4C696E65642D466175782D4675722D486F6F6465642D5075666665722D4A61636B65742D333030363237312D33324356', X'', 3, NULL),
	(63, X'24', X'706F74746572796261726E6B6964732E636F6D', 1, NULL, NULL, X'', 3, NULL),
	(64, X'24', X'616D617A6F6E2E7367', 1, X'5347', X'416D617A6F6E2053696E6761706F7265', X'546869732063757272656E746C79206661696C73207768656E206665746368696E6720616E20616D617A6F6E2E7367206C696E6B2077697468206572726F723A20206C6F63616C207661726961626C652027686F737427207265666572656E636564206265666F72652061737369676E6D656E74', 2, NULL),
	(68, X'24', X'6E696B652E636F6D', 1, NULL, X'68747470733A2F2F7777772E6E696B652E636F6D2F742F6169722D6D61782D312D6E372D73686F652D785146436A352F4441313334362D323030', X'', 3, NULL),
	(69, X'24', X'62617468616E64626F6479776F726B732E636F6D', 1, NULL, NULL, X'', 3, NULL),
	(70, X'24', X'67696674737465722E636F6D', 1, NULL, X'656D6265646C792072657475726E732062657474657220726573756C74207468616E2064696666626F7420666F72206769667473746572207075626C69632055524C206C69737473', X'', 3, NULL),
	(72, X'24', X'7777772E74686577617265686F7573652E636F2E6E7A', 1, NULL, NULL, X'', 3, NULL),
	(73, X'24', X'61652E636F6D', 1, NULL, X'7265706F7274656420627920637573746F6D6572', X'68747470733A2F2F7777772E61652E636F6D2F75732F656E2F702F776F6D656E2F647265737365732F6D696E692D647265737365732F61652D7469657265642D62616279646F6C6C2D64726573732F303339355F363031375F363030', 3, NULL),
	(74, X'24', X'7461726765742E636F6D', 1, NULL, X'31302F323120656D6265646C79206D75636820666173746572', X'', 7, NULL),
	(78, X'24', X'736D79746873746F79732E636F6D', 1, NULL, NULL, X'', 11, NULL),
	(79, X'24', X'766963746F726961737365637265742E636F6D', 1, NULL, NULL, X'68747470733A2F2F7777772E766963746F726961737365637265742E636F6D2F75732F70696E6B2F6170706172656C2D636174616C6F672F70696E6B2D65766572796461792D6C6F756E67652D6A6F676765722D353030303030373935333F67656E6572696349643D31313137343330362663686F6963653D34384E552673697A65313D584C26636D5F6D6D633D504C412D5F2D474F4F474C452D5F2D5653445F50494E4B5F426F74746F6D735F5353432D5F2D41642B67726F75702667636C69643D436A304B435169417771434F42684364415249734145507957396E50476D7664683653385972424C645A63304B45666B773170446C656769663542696352726E674F4F427A6B7463356D7572307851614170663445414C775F7763422667636C7372633D61772E6473', 3, NULL),
	(80, X'24', X'612E636F', 1, NULL, NULL, X'74657374696E67207573696E6720656D6265646C7920666F7220612E636F20616D617A6F6E2066657463686573', 10, 1),
	(84, X'24', X'626870686F746F766964656F2E636F6D', 1, NULL, X'6661696C696E67206F6E2064696666626F742F656D6265646C7920747279696E672070726F7879', X'', 11, 0),
	(85, X'24', X'6E6F7465626F6F6B746865726170792E636F6D', 1, NULL, X'696D616765206661696C7320776974682064696666626F7420636175736573206572726F72', X'', 3, 0),
	(86, X'24', X'7777772E7461746368612E636F6D', 1, NULL, NULL, X'68747470733A2F2F7777772E7461746368612E636F6D2F70726F647563742F77617465722D637265616D2F43413035313130542E68746D6C', 11, 0),
	(89, X'24', X'74726163746F72737570706C792E636F6D', 1, NULL, NULL, X'', 11, 0),
	(91, X'24', X'686572756E6976657273652E636F6D', 1, NULL, NULL, X'', 3, 0),
	(92, X'24', X'616D617A6F6E2E636F6D2E6265', 1, NULL, X'416D617A6F6E2042656C6769756D206E6F20415049', X'616464656420352F31352F32332020736F6D657768617420636F6E6365726E65642061626F7574207468652022616D617A6F6E2E636F6D2220696E2068657265', 3, 0),
	(95, X'24', X'627579617461622E636F6D', 1, NULL, NULL, X'', 3, 0),
	(96, X'24', X'796F756E676578706C6F726572732E636F6D', 1, NULL, NULL, X'68747470733A2F2F7777772E796F756E676578706C6F726572732E636F6D2F6974656D647930302E617370783F54313D593631303232342669643D3231392C323436', 11, 0),
	(97, X'E282AC', X'616D7A6E2E6575', 1, NULL, NULL, X'', 10, 0),
	(99, X'24', X'6E6F72647374726F6D2E636F6D', 2, NULL, NULL, X'', 1, 0),
	(100, X'24', X'612E636F', 2, NULL, NULL, X'', 3, 0),
	(101, X'24', X'66616E61746963732E636F2E756B', 1, NULL, NULL, X'', 7, 0),
	(102, X'24', X'66616E61746963732E636F2E756B', 2, NULL, NULL, X'', 3, 0),
	(103, X'24', X'6B6F686C73', 1, NULL, NULL, X'', 6, 0),
	(104, X'24', X'616D617A6F6E2E636F6D', 2, NULL, X'416D617A6F6E2E636F6D205553206661696C206F76657220746F20456D6265646C79', X'', 3, 0),
	(105, X'24', X'66616E61746963732E636F6D', 2, NULL, NULL, X'', 3, 0),
	(106, X'24', X'6162657263726F6D6269652E636F6D', 1, NULL, NULL, X'', 11, 0),
	(107, X'24', X'6162657263726F6D6269652E636F6D', 2, NULL, NULL, X'', 3, 0),
	(108, X'24', X'666F6F746C6F636B65722E636F6D', 1, NULL, NULL, X'', 11, 0),
	(110, X'24', X'616D7A6E2E746F', 1, NULL, NULL, X'', 10, 0),
	(111, X'24', X'616D7A6E2E6575', 2, NULL, X'6D757374206661696C206F76657220746F20656D6265646C79', X'', 3, 0),
	(112, X'24', X'736570686F72612E636F6D', 1, NULL, NULL, X'74686973206C696E6B3A2068747470733A2F2F7777772E736570686F72612E636F6D2F70726F647563742F73756D6D65722D667269646179732D6C69702D6275747465722D62616C6D2D5034353539333620676F657320746F20656D6265646C792077697468206E6F206D617070696E672C206275742069662049207075742064696666626F74206669727374206974207468656E20676574732062657474657220726573756C7420776974682064696666626F742E202054686973206578706F73657320736F6D6520736F7274206F662069737375652C207768792069736E27742064696666626F74207472696564206669727374206966206E6F206D617070696E67206973206C69737465643F', 1, 0),
	(113, X'24', X'74656D752E636F6D', 1, NULL, X'6372756D6D792064696666626F7420726573756C7473', X'', 3, 0),
	(114, X'24', X'63726F63732E636F6D', 1, NULL, X'746F756768206F6E65', X'', 3, 0),
	(115, X'24', X'616D7A6E2E746F', 2, NULL, X'6261636B207570', X'', 3, 0),
	(116, X'24', X'77616C6D6172742E6361', 1, NULL, X'74657374696E67206361', X'', 3, 0),
	(117, X'24', X'7777772E6A69677361772D6F6E6C696E652E636F6D', 1, NULL, NULL, X'', 3, 0),
	(119, X'24', X'68747470733A2F2F626F6F6B73686F702E6F72672F', 1, NULL, X'626C6F636B6564206F6E20757375616C', X'', 11, 0),
	(120, X'24', X'657473792E636F6D', 1, NULL, X'64696666626F7420626C6F636B6564', X'', 3, 0),
	(123, X'24', X'686F6D656465706F742E636F6D', 1, NULL, X'64696666626F74206661696C73', X'', 3, 0),
	(126, X'24', X'6D6963726F63656E7465722E636F6D', 1, NULL, X'6661696C696E67206F6E206469666620616E6420656D626564', X'', 11, 0);


INSERT INTO `fetch_provider` (`id`, `is_active`, `is_default`, `name`, `is_failover`)
VALUES
	(1, 1, 1, X'64696666626F74', 0),
	(2, 1, 0, X'616D617A6F6E', 0),
	(3, 1, 0, X'656D6265646C79', 1),
	(4, 1, 1, X'7472755F656D6265646C79', 0),
	(5, 1, 0, X'7461726765745F64696666626F74', 0),
	(6, 1, 1, X'666C65786F6666657273', 0),
	(7, 1, 0, X'696D706163745F726164697573', 0),
	(8, 1, 0, X'626C756563617274', 0),
	(9, 1, 0, X'77616C6D617274', 0),
	(10, 1, 0, X'616D617A6F6E5F73686F72745F75726C', 0),
	(11, 1, 0, X'64696666626F745F70726F7879', 0),
	(12, 1, 0, X'72616B7574656E', 0),
	(13, 1, 0, X'65626179', 0);