· 8 years ago · Jul 03, 2018, 07:58 PM
1-- Converted by db_converterSTART TRANSACTION;
2SET standard_conforming_strings=off;
3SET escape_string_warning=off;
4SET CONSTRAINTS ALL DEFERRED;
5DROP table countries;
6CREATE TYPE countries_manual_payout_type AS ENUM ('payoneer','bank','dwolla','paypal','transferwise','epayments','payoneer2');
7CREATE TABLE "countries" ( "id" integer NOT NULL, "name" varchar(128) NOT NULL, "active" int4 NOT NULL DEFAULT '1', "stripe_code" varchar(4) DEFAULT NULL, "is_stripe_managed" int4 NOT NULL DEFAULT '0', "stripe_sort" integer NOT NULL DEFAULT '0', "stripe_data" text , "has_states" int4 NOT NULL DEFAULT '0', "last_changed" timestamp NULL DEFAULT NULL, "is_stripe_payout_bank" int4 NOT NULL DEFAULT '0', "is_stripe_payout_card" int4 NOT NULL DEFAULT '0', "code2" char(2) DEFAULT NULL, "manual_payout_type" countries_manual_payout_type NOT NULL DEFAULT 'bank', "min_payout_summ" integer DEFAULT NULL, PRIMARY KEY ("id"));
8INSERT INTO "countries" VALUES (1,'Afghanistan',0,NULL,0,0,NULL,0,'2017-05-13 15:47:29',0,0,'AF','epayments',100),(2,'Albania',0,NULL,0,0,NULL,0,'2017-05-13 15:47:28',0,0,'AL','epayments',100),(3,'Algeria',0,NULL,0,0,NULL,0,'2017-05-13 15:47:27',0,0,'DZ','epayments',100),(4,'American Samoa',0,NULL,0,0,NULL,0,'2018-01-18 14:55:51',0,0,'AS','epayments',100),(5,'Andorra',0,NULL,0,0,NULL,0,'2017-05-13 15:52:51',0,0,'AD','epayments',100),(6,'Angola',0,NULL,0,0,NULL,0,'2017-05-13 15:47:23',0,0,'AO','epayments',100),(7,'Anguilla',0,NULL,0,0,NULL,0,'2017-05-13 15:47:22',0,0,'AI','epayments',100),(8,'Antigua and Barbuda',0,NULL,0,0,NULL,0,'2017-05-13 15:52:52',0,0,'AG','epayments',100),(9,'Argentina',1,'',0,0,NULL,0,'2018-06-15 10:51:39',0,0,'AR','epayments',100),(10,'Armenia',0,NULL,0,0,NULL,0,'2017-05-13 15:52:56',0,0,'AM','epayments',100),(11,'Aruba',0,NULL,0,0,NULL,0,'2018-01-18 14:55:50',0,0,'AW','epayments',100),(12,'Australia',1,'AU',1,0,'{\"id\":\"AU\",\"object\":\"country_spec\",\"default_currency\":\"aud\",\"supported_bank_account_currencies\":{\"aud\":[\"AU\"]},\"supported_payment_currencies\":[\"usd\",\"aed\",\"all\",\"ang\",\"ars\",\"aud\",\"awg\",\"bbd\",\"bdt\",\"bif\",\"bmd\",\"bnd\",\"bob\",\"brl\",\"bsd\",\"bwp\",\"bzd\",\"cad\",\"chf\",\"clp\",\"cny\",\"cop\",\"crc\",\"cve\",\"czk\",\"djf\",\"dkk\",\"dop\",\"dzd\",\"egp\",\"etb\",\"eur\",\"fjd\",\"fkp\",\"gbp\",\"gip\",\"gmd\",\"gnf\",\"gtq\",\"gyd\",\"hkd\",\"hnl\",\"hrk\",\"htg\",\"huf\",\"idr\",\"ils\",\"inr\",\"isk\",\"jmd\",\"jpy\",\"kes\",\"khr\",\"kmf\",\"krw\",\"kyd\",\"kzt\",\"lak\",\"lbp\",\"lkr\",\"lrd\",\"ltl\",\"mad\",\"mdl\",\"mnt\",\"mop\",\"mro\",\"mur\",\"mvr\",\"mwk\",\"mxn\",\"myr\",\"nad\",\"ngn\",\"nio\",\"nok\",\"npr\",\"nzd\",\"pab\",\"pen\",\"pgk\",\"php\",\"pkr\",\"pln\",\"pyg\",\"qar\",\"rub\",\"sar\",\"sbd\",\"scr\",\"sek\",\"sgd\",\"shp\",\"sll\",\"sos\",\"std\",\"svc\",\"szl\",\"thb\",\"top\",\"ttd\",\"twd\",\"tzs\",\"uah\",\"ugx\",\"uyu\",\"uzs\",\"vnd\",\"vuv\",\"wst\",\"xaf\",\"xof\",\"xpf\",\"yer\",\"zar\"],\"supported_payment_methods\":[\"card\",\"stripe\"],\"verification_fields\":{\"individual\":{\"minimum\":[\"external_account\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.address.state\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]},\"company\":{\"minimum\":[\"external_account\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.address.state\",\"legal_entity.business_name\",\"legal_entity.business_tax_id\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]}}}',1,'2018-05-29 20:36:13',1,0,'AU','transferwise',100),(13,'Austria',1,'AT',1,0,'{\"id\":\"AT\",\"object\":\"country_spec\",\"default_currency\":\"eur\",\"supported_bank_account_currencies\":{\"eur\":[\"AT\",\"BE\",\"CH\",\"DE\",\"DK\",\"ES\",\"FI\",\"FR\",\"GB\",\"IE\",\"IT\",\"LU\",\"NL\",\"NO\",\"PT\",\"SE\"],\"dkk\":[\"DK\"],\"gbp\":[\"GB\"],\"nok\":[\"NO\"],\"sek\":[\"SE\"],\"usd\":[\"US\"]},\"supported_payment_currencies\":[\"usd\",\"aed\",\"afn\",\"all\",\"amd\",\"ang\",\"aoa\",\"ars\",\"aud\",\"awg\",\"azn\",\"bam\",\"bbd\",\"bdt\",\"bgn\",\"bif\",\"bmd\",\"bnd\",\"bob\",\"brl\",\"bsd\",\"bwp\",\"bzd\",\"cad\",\"cdf\",\"chf\",\"clp\",\"cny\",\"cop\",\"crc\",\"cve\",\"czk\",\"djf\",\"dkk\",\"dop\",\"dzd\",\"egp\",\"etb\",\"eur\",\"fjd\",\"fkp\",\"gbp\",\"gel\",\"gip\",\"gmd\",\"gnf\",\"gtq\",\"gyd\",\"hkd\",\"hnl\",\"hrk\",\"htg\",\"huf\",\"idr\",\"ils\",\"inr\",\"isk\",\"jmd\",\"jpy\",\"kes\",\"kgs\",\"khr\",\"kmf\",\"krw\",\"kyd\",\"kzt\",\"lak\",\"lbp\",\"lkr\",\"lrd\",\"lsl\",\"ltl\",\"mad\",\"mdl\",\"mga\",\"mkd\",\"mnt\",\"mop\",\"mro\",\"mur\",\"mvr\",\"mwk\",\"mxn\",\"myr\",\"mzn\",\"nad\",\"ngn\",\"nio\",\"nok\",\"npr\",\"nzd\",\"pab\",\"pen\",\"pgk\",\"php\",\"pkr\",\"pln\",\"pyg\",\"qar\",\"ron\",\"rsd\",\"rub\",\"rwf\",\"sar\",\"sbd\",\"scr\",\"sek\",\"sgd\",\"shp\",\"sll\",\"sos\",\"srd\",\"std\",\"svc\",\"szl\",\"thb\",\"tjs\",\"top\",\"try\",\"ttd\",\"twd\",\"tzs\",\"uah\",\"ugx\",\"uyu\",\"uzs\",\"vnd\",\"vuv\",\"wst\",\"xaf\",\"xcd\",\"xof\",\"xpf\",\"yer\",\"zar\",\"zmw\"],\"supported_payment_methods\":[\"alipay\",\"card\",\"stripe\"],\"verification_fields\":{\"individual\":{\"minimum\":[\"external_account\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]},\"company\":{\"minimum\":[\"external_account\",\"legal_entity.additional_owners\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.business_name\",\"legal_entity.business_tax_id\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]}}}',0,'2017-04-07 20:03:32',1,0,'AT','epayments',100),(14,'Azerbaijan',0,NULL,0,0,NULL,0,'2017-05-13 15:47:15',0,0,'AZ','epayments',100),(15,'Bahamas',0,NULL,0,0,NULL,0,'2017-05-13 15:47:14',0,0,'BS','epayments',100),(16,'Bahrain',0,NULL,0,0,NULL,0,'2018-01-18 14:55:46',0,0,'BH','epayments',100),(17,'Bangladesh',0,NULL,0,0,NULL,0,'2017-05-13 15:47:09',0,0,'BD','epayments',100),(18,'Barbados',0,NULL,0,0,NULL,0,'2017-05-13 15:47:08',0,0,'BB','epayments',100),(19,'Belarus',1,NULL,0,0,NULL,0,'2017-04-07 20:03:32',0,0,'BY','epayments',100),(20,'Belgium',1,'BE',1,0,'{\"id\":\"BE\",\"object\":\"country_spec\",\"default_currency\":\"eur\",\"supported_bank_account_currencies\":{\"eur\":[\"AT\",\"BE\",\"CH\",\"DE\",\"DK\",\"ES\",\"FI\",\"FR\",\"GB\",\"IE\",\"IT\",\"LU\",\"NL\",\"NO\",\"PT\",\"SE\"],\"dkk\":[\"DK\"],\"gbp\":[\"GB\"],\"nok\":[\"NO\"],\"sek\":[\"SE\"],\"usd\":[\"US\"]},\"supported_payment_currencies\":[\"usd\",\"aed\",\"afn\",\"all\",\"amd\",\"ang\",\"aoa\",\"ars\",\"aud\",\"awg\",\"azn\",\"bam\",\"bbd\",\"bdt\",\"bgn\",\"bif\",\"bmd\",\"bnd\",\"bob\",\"brl\",\"bsd\",\"bwp\",\"bzd\",\"cad\",\"cdf\",\"chf\",\"clp\",\"cny\",\"cop\",\"crc\",\"cve\",\"czk\",\"djf\",\"dkk\",\"dop\",\"dzd\",\"egp\",\"etb\",\"eur\",\"fjd\",\"fkp\",\"gbp\",\"gel\",\"gip\",\"gmd\",\"gnf\",\"gtq\",\"gyd\",\"hkd\",\"hnl\",\"hrk\",\"htg\",\"huf\",\"idr\",\"ils\",\"inr\",\"isk\",\"jmd\",\"jpy\",\"kes\",\"kgs\",\"khr\",\"kmf\",\"krw\",\"kyd\",\"kzt\",\"lak\",\"lbp\",\"lkr\",\"lrd\",\"lsl\",\"ltl\",\"mad\",\"mdl\",\"mga\",\"mkd\",\"mnt\",\"mop\",\"mro\",\"mur\",\"mvr\",\"mwk\",\"mxn\",\"myr\",\"mzn\",\"nad\",\"ngn\",\"nio\",\"nok\",\"npr\",\"nzd\",\"pab\",\"pen\",\"pgk\",\"php\",\"pkr\",\"pln\",\"pyg\",\"qar\",\"ron\",\"rsd\",\"rub\",\"rwf\",\"sar\",\"sbd\",\"scr\",\"sek\",\"sgd\",\"shp\",\"sll\",\"sos\",\"srd\",\"std\",\"svc\",\"szl\",\"thb\",\"tjs\",\"top\",\"try\",\"ttd\",\"twd\",\"tzs\",\"uah\",\"ugx\",\"uyu\",\"uzs\",\"vnd\",\"vuv\",\"wst\",\"xaf\",\"xcd\",\"xof\",\"xpf\",\"yer\",\"zar\",\"zmw\"],\"supported_payment_methods\":[\"alipay\",\"card\",\"stripe\"],\"verification_fields\":{\"individual\":{\"minimum\":[\"external_account\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]},\"company\":{\"minimum\":[\"external_account\",\"legal_entity.additional_owners\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.business_name\",\"legal_entity.business_tax_id\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]}}}',0,'2017-04-07 20:03:32',1,0,'BE','epayments',100),(21,'Belize',0,NULL,0,0,NULL,0,'2017-05-13 15:52:38',0,0,'BZ','epayments',100),(22,'Benin',0,NULL,0,0,NULL,0,'2017-05-13 15:52:35',0,0,'BJ','epayments',100),(23,'Bermuda',0,NULL,0,0,NULL,0,'2017-05-13 15:52:34',0,0,'BM','epayments',100),(24,'Bhutan',0,NULL,0,0,NULL,0,'2017-05-13 15:52:32',0,0,'BT','epayments',100),(25,'Bolivia',0,NULL,0,0,NULL,0,'2017-05-13 15:52:39',0,0,'BO','epayments',100),(26,'Bosnia',0,'',0,0,NULL,0,'2017-05-13 15:52:40',0,0,'BA','epayments',100),(27,'Botswana',0,NULL,0,0,NULL,0,'2017-05-13 15:47:01',0,0,'BW','epayments',100),(28,'Brazil',1,'',0,0,NULL,0,'2018-06-15 09:27:32',0,0,'BR','epayments',100),(29,'British Virgin Islands',0,'',0,0,NULL,0,'2018-01-18 14:55:42',0,0,'VG','epayments',100),(30,'Brunei',0,'',0,0,NULL,0,'2017-05-13 15:52:44',0,0,'BN','epayments',100),(31,'Bulgaria',1,NULL,0,0,NULL,0,'2017-04-07 20:03:32',0,0,'BG','epayments',100),(32,'Burkina Faso',0,NULL,0,0,NULL,0,'2017-05-13 15:46:56',0,0,'BF','epayments',100),(33,'Burundi',0,NULL,0,0,NULL,0,'2017-05-13 15:46:55',0,0,'BI','epayments',100),(34,'Cambodia',0,NULL,0,0,NULL,0,'2017-05-13 15:46:54',0,0,'KH','epayments',100),(35,'Cameroon',0,NULL,0,0,NULL,0,'2017-05-13 15:46:52',0,0,'CM','epayments',100),(36,'Canada',1,'CA',1,0,'{\"id\":\"CA\",\"object\":\"country_spec\",\"default_currency\":\"cad\",\"supported_bank_account_currencies\":{\"cad\":[\"CA\"],\"usd\":[\"US\",\"CA\"]},\"supported_payment_currencies\":[\"cad\",\"usd\"],\"supported_payment_methods\":[\"alipay\",\"card\",\"stripe\"],\"verification_fields\":{\"individual\":{\"minimum\":[\"external_account\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.address.state\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_id_number\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]},\"company\":{\"minimum\":[\"external_account\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.address.state\",\"legal_entity.business_name\",\"legal_entity.business_tax_id\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_id_number\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]}}}',1,'2018-05-29 20:36:18',1,0,'CA','transferwise',100),(37,'Cape Verde',0,NULL,0,0,NULL,0,'2017-05-13 15:52:06',0,0,'CV','epayments',100),(38,'Cayman Islands',0,NULL,0,0,NULL,0,'2017-05-13 15:52:05',0,0,'KY','epayments',100),(39,'Central African Republic',0,NULL,0,0,NULL,0,'2017-05-13 15:52:08',0,0,'CF','epayments',100),(40,'Chad',0,NULL,0,0,NULL,0,'2017-05-13 15:52:09',0,0,'TD','epayments',100),(41,'Chile',1,'',0,0,NULL,0,'2018-06-15 10:51:56',0,0,'CL','epayments',100),(42,'China',0,NULL,0,0,NULL,0,'2017-06-10 12:55:57',0,0,'CN','epayments',100),(43,'Christmas Island',0,NULL,0,0,NULL,0,'2017-05-13 15:46:35',0,0,'CX','epayments',100),(44,'Colombia',1,'',0,0,NULL,0,'2018-06-04 08:29:47',0,0,'CO','paypal',100),(45,'Comoros',0,NULL,0,0,NULL,0,'2017-05-13 15:46:28',0,0,'KM','epayments',100),(46,'Cook Islands',0,NULL,0,0,NULL,0,'2017-05-13 15:46:26',0,0,'CK','epayments',100),(47,'Costa Rica',1,'',0,0,NULL,0,'2018-06-15 10:51:27',0,0,'CR','epayments',100),(48,'Côte d''Ivoire',0,NULL,0,0,NULL,0,'2017-05-13 15:46:24',0,0,'CI','epayments',100),(49,'Croatia',1,NULL,0,0,NULL,0,'2017-04-07 20:03:32',0,0,'HR','epayments',100),(50,'Cuba',0,NULL,0,0,NULL,0,'2018-06-04 08:29:07',0,0,'CU','epayments',100),(51,'Cyprus',1,NULL,0,0,NULL,0,'2017-04-07 20:03:32',0,0,'CY','epayments',100),(52,'Czech Republic',1,NULL,0,0,NULL,0,'2017-04-07 20:03:32',0,0,'CZ','epayments',100),(53,'Democratic Republic of the Congo',0,'',0,0,NULL,0,'2017-05-13 15:50:55',0,0,'CD','epayments',100),(54,'Denmark',1,'DK',1,0,'{\"id\":\"DK\",\"object\":\"country_spec\",\"default_currency\":\"dkk\",\"supported_bank_account_currencies\":{\"eur\":[\"AT\",\"BE\",\"CH\",\"DE\",\"DK\",\"ES\",\"FI\",\"FR\",\"GB\",\"IE\",\"IT\",\"LU\",\"NL\",\"NO\",\"PT\",\"SE\"],\"dkk\":[\"DK\"],\"gbp\":[\"GB\"],\"nok\":[\"NO\"],\"sek\":[\"SE\"],\"usd\":[\"US\"]},\"supported_payment_currencies\":[\"usd\",\"aed\",\"afn\",\"all\",\"amd\",\"ang\",\"aoa\",\"ars\",\"aud\",\"awg\",\"azn\",\"bam\",\"bbd\",\"bdt\",\"bgn\",\"bif\",\"bmd\",\"bnd\",\"bob\",\"brl\",\"bsd\",\"bwp\",\"bzd\",\"cad\",\"cdf\",\"chf\",\"clp\",\"cny\",\"cop\",\"crc\",\"cve\",\"czk\",\"djf\",\"dkk\",\"dop\",\"dzd\",\"egp\",\"etb\",\"eur\",\"fjd\",\"fkp\",\"gbp\",\"gel\",\"gip\",\"gmd\",\"gnf\",\"gtq\",\"gyd\",\"hkd\",\"hnl\",\"hrk\",\"htg\",\"huf\",\"idr\",\"ils\",\"inr\",\"isk\",\"jmd\",\"jpy\",\"kes\",\"kgs\",\"khr\",\"kmf\",\"krw\",\"kyd\",\"kzt\",\"lak\",\"lbp\",\"lkr\",\"lrd\",\"lsl\",\"ltl\",\"mad\",\"mdl\",\"mga\",\"mkd\",\"mnt\",\"mop\",\"mro\",\"mur\",\"mvr\",\"mwk\",\"mxn\",\"myr\",\"mzn\",\"nad\",\"ngn\",\"nio\",\"nok\",\"npr\",\"nzd\",\"pab\",\"pen\",\"pgk\",\"php\",\"pkr\",\"pln\",\"pyg\",\"qar\",\"ron\",\"rsd\",\"rub\",\"rwf\",\"sar\",\"sbd\",\"scr\",\"sek\",\"sgd\",\"shp\",\"sll\",\"sos\",\"srd\",\"std\",\"svc\",\"szl\",\"thb\",\"tjs\",\"top\",\"try\",\"ttd\",\"twd\",\"tzs\",\"uah\",\"ugx\",\"uyu\",\"uzs\",\"vnd\",\"vuv\",\"wst\",\"xaf\",\"xcd\",\"xof\",\"xpf\",\"yer\",\"zar\",\"zmw\"],\"supported_payment_methods\":[\"alipay\",\"card\",\"stripe\"],\"verification_fields\":{\"individual\":{\"minimum\":[\"external_account\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]},\"company\":{\"minimum\":[\"external_account\",\"legal_entity.additional_owners\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.business_name\",\"legal_entity.business_tax_id\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]}}}',0,'2017-04-07 20:03:32',1,0,'DK','epayments',100),(55,'Djibouti',0,NULL,0,0,NULL,0,'2017-05-13 15:51:51',0,0,'DJ','epayments',100),(56,'Dominican Republic',1,'',0,0,NULL,0,'2018-06-15 10:51:03',0,0,'DO','epayments',100),(57,'Dominica',0,NULL,0,0,NULL,0,'2017-05-13 15:46:15',0,0,'DM','epayments',100),(58,'Ecuador',0,NULL,0,0,NULL,0,'2017-05-13 15:51:58',0,0,'EC','epayments',100),(59,'Egypt',0,NULL,0,0,NULL,0,'2017-05-13 15:51:58',0,0,'EG','epayments',100),(60,'El Salvador',1,'',0,0,NULL,0,'2018-06-25 11:00:40',0,0,'SV','epayments',100),(61,'Equatorial Guinea',0,NULL,0,0,NULL,0,'2017-05-13 15:46:03',0,0,'GQ','epayments',100),(62,'Eritrea',0,NULL,0,0,NULL,0,'2017-05-13 15:46:00',0,0,'ER','epayments',100),(63,'Estonia',1,NULL,0,0,NULL,0,'2017-04-07 20:03:32',0,0,'EE','epayments',100),(64,'Ethiopia',0,NULL,0,0,NULL,0,'2017-05-13 15:45:58',0,0,'ET','epayments',100),(65,'Falkland Islands',0,'',0,0,NULL,0,'2017-05-13 15:54:41',0,0,'FK','epayments',100),(66,'Faroe Islands',0,NULL,0,0,NULL,0,'2018-01-18 14:55:29',0,0,'FO','epayments',100),(67,'Fiji',0,NULL,0,0,NULL,0,'2017-05-13 15:50:46',0,0,'FJ','epayments',100),(68,'Finland',1,'FI',1,0,'{\"id\":\"FI\",\"object\":\"country_spec\",\"default_currency\":\"eur\",\"supported_bank_account_currencies\":{\"eur\":[\"AT\",\"BE\",\"CH\",\"DE\",\"DK\",\"ES\",\"FI\",\"FR\",\"GB\",\"IE\",\"IT\",\"LU\",\"NL\",\"NO\",\"PT\",\"SE\"],\"dkk\":[\"DK\"],\"gbp\":[\"GB\"],\"nok\":[\"NO\"],\"sek\":[\"SE\"],\"usd\":[\"US\"]},\"supported_payment_currencies\":[\"usd\",\"aed\",\"afn\",\"all\",\"amd\",\"ang\",\"aoa\",\"ars\",\"aud\",\"awg\",\"azn\",\"bam\",\"bbd\",\"bdt\",\"bgn\",\"bif\",\"bmd\",\"bnd\",\"bob\",\"brl\",\"bsd\",\"bwp\",\"bzd\",\"cad\",\"cdf\",\"chf\",\"clp\",\"cny\",\"cop\",\"crc\",\"cve\",\"czk\",\"djf\",\"dkk\",\"dop\",\"dzd\",\"egp\",\"etb\",\"eur\",\"fjd\",\"fkp\",\"gbp\",\"gel\",\"gip\",\"gmd\",\"gnf\",\"gtq\",\"gyd\",\"hkd\",\"hnl\",\"hrk\",\"htg\",\"huf\",\"idr\",\"ils\",\"inr\",\"isk\",\"jmd\",\"jpy\",\"kes\",\"kgs\",\"khr\",\"kmf\",\"krw\",\"kyd\",\"kzt\",\"lak\",\"lbp\",\"lkr\",\"lrd\",\"lsl\",\"ltl\",\"mad\",\"mdl\",\"mga\",\"mkd\",\"mnt\",\"mop\",\"mro\",\"mur\",\"mvr\",\"mwk\",\"mxn\",\"myr\",\"mzn\",\"nad\",\"ngn\",\"nio\",\"nok\",\"npr\",\"nzd\",\"pab\",\"pen\",\"pgk\",\"php\",\"pkr\",\"pln\",\"pyg\",\"qar\",\"ron\",\"rsd\",\"rub\",\"rwf\",\"sar\",\"sbd\",\"scr\",\"sek\",\"sgd\",\"shp\",\"sll\",\"sos\",\"srd\",\"std\",\"svc\",\"szl\",\"thb\",\"tjs\",\"top\",\"try\",\"ttd\",\"twd\",\"tzs\",\"uah\",\"ugx\",\"uyu\",\"uzs\",\"vnd\",\"vuv\",\"wst\",\"xaf\",\"xcd\",\"xof\",\"xpf\",\"yer\",\"zar\",\"zmw\"],\"supported_payment_methods\":[\"alipay\",\"card\",\"stripe\"],\"verification_fields\":{\"individual\":{\"minimum\":[\"external_account\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]},\"company\":{\"minimum\":[\"external_account\",\"legal_entity.additional_owners\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.business_name\",\"legal_entity.business_tax_id\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]}}}',0,'2017-04-07 20:03:32',1,0,'FI','epayments',100),(69,'France',1,'FR',1,0,'{\"id\":\"FR\",\"object\":\"country_spec\",\"default_currency\":\"eur\",\"supported_bank_account_currencies\":{\"eur\":[\"AT\",\"BE\",\"CH\",\"DE\",\"DK\",\"ES\",\"FI\",\"FR\",\"GB\",\"IE\",\"IT\",\"LU\",\"NL\",\"NO\",\"PT\",\"SE\"],\"dkk\":[\"DK\"],\"gbp\":[\"GB\"],\"nok\":[\"NO\"],\"sek\":[\"SE\"],\"usd\":[\"US\"]},\"supported_payment_currencies\":[\"usd\",\"aed\",\"afn\",\"all\",\"amd\",\"ang\",\"aoa\",\"ars\",\"aud\",\"awg\",\"azn\",\"bam\",\"bbd\",\"bdt\",\"bgn\",\"bif\",\"bmd\",\"bnd\",\"bob\",\"brl\",\"bsd\",\"bwp\",\"bzd\",\"cad\",\"cdf\",\"chf\",\"clp\",\"cny\",\"cop\",\"crc\",\"cve\",\"czk\",\"djf\",\"dkk\",\"dop\",\"dzd\",\"egp\",\"etb\",\"eur\",\"fjd\",\"fkp\",\"gbp\",\"gel\",\"gip\",\"gmd\",\"gnf\",\"gtq\",\"gyd\",\"hkd\",\"hnl\",\"hrk\",\"htg\",\"huf\",\"idr\",\"ils\",\"inr\",\"isk\",\"jmd\",\"jpy\",\"kes\",\"kgs\",\"khr\",\"kmf\",\"krw\",\"kyd\",\"kzt\",\"lak\",\"lbp\",\"lkr\",\"lrd\",\"lsl\",\"ltl\",\"mad\",\"mdl\",\"mga\",\"mkd\",\"mnt\",\"mop\",\"mro\",\"mur\",\"mvr\",\"mwk\",\"mxn\",\"myr\",\"mzn\",\"nad\",\"ngn\",\"nio\",\"nok\",\"npr\",\"nzd\",\"pab\",\"pen\",\"pgk\",\"php\",\"pkr\",\"pln\",\"pyg\",\"qar\",\"ron\",\"rsd\",\"rub\",\"rwf\",\"sar\",\"sbd\",\"scr\",\"sek\",\"sgd\",\"shp\",\"sll\",\"sos\",\"srd\",\"std\",\"svc\",\"szl\",\"thb\",\"tjs\",\"top\",\"try\",\"ttd\",\"twd\",\"tzs\",\"uah\",\"ugx\",\"uyu\",\"uzs\",\"vnd\",\"vuv\",\"wst\",\"xaf\",\"xcd\",\"xof\",\"xpf\",\"yer\",\"zar\",\"zmw\"],\"supported_payment_methods\":[\"alipay\",\"card\",\"stripe\"],\"verification_fields\":{\"individual\":{\"minimum\":[\"external_account\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]},\"company\":{\"minimum\":[\"external_account\",\"legal_entity.additional_owners\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.business_name\",\"legal_entity.business_tax_id\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]}}}',0,'2017-04-07 20:03:32',1,0,'FR','epayments',100),(70,'French Polynesia',0,NULL,0,0,NULL,0,'2018-01-18 14:55:26',0,0,'PF','epayments',100),(71,'Gabon',0,NULL,0,0,NULL,0,'2017-05-13 15:45:52',0,0,'GA','epayments',100),(72,'Gambia',0,NULL,0,0,NULL,0,'2017-05-13 15:45:51',0,0,'GM','epayments',100),(73,'Georgia',1,NULL,0,0,NULL,0,'2017-04-07 20:03:32',0,0,'GE','epayments',100),(74,'Germany',1,'DE',1,0,'{\"id\":\"DE\",\"object\":\"country_spec\",\"default_currency\":\"eur\",\"supported_bank_account_currencies\":{\"eur\":[\"AT\",\"BE\",\"CH\",\"DE\",\"DK\",\"ES\",\"FI\",\"FR\",\"GB\",\"IE\",\"IT\",\"LU\",\"NL\",\"NO\",\"PT\",\"SE\"],\"dkk\":[\"DK\"],\"gbp\":[\"GB\"],\"nok\":[\"NO\"],\"sek\":[\"SE\"],\"usd\":[\"US\"]},\"supported_payment_currencies\":[\"usd\",\"aed\",\"afn\",\"all\",\"amd\",\"ang\",\"aoa\",\"ars\",\"aud\",\"awg\",\"azn\",\"bam\",\"bbd\",\"bdt\",\"bgn\",\"bif\",\"bmd\",\"bnd\",\"bob\",\"brl\",\"bsd\",\"bwp\",\"bzd\",\"cad\",\"cdf\",\"chf\",\"clp\",\"cny\",\"cop\",\"crc\",\"cve\",\"czk\",\"djf\",\"dkk\",\"dop\",\"dzd\",\"egp\",\"etb\",\"eur\",\"fjd\",\"fkp\",\"gbp\",\"gel\",\"gip\",\"gmd\",\"gnf\",\"gtq\",\"gyd\",\"hkd\",\"hnl\",\"hrk\",\"htg\",\"huf\",\"idr\",\"ils\",\"inr\",\"isk\",\"jmd\",\"jpy\",\"kes\",\"kgs\",\"khr\",\"kmf\",\"krw\",\"kyd\",\"kzt\",\"lak\",\"lbp\",\"lkr\",\"lrd\",\"lsl\",\"ltl\",\"mad\",\"mdl\",\"mga\",\"mkd\",\"mnt\",\"mop\",\"mro\",\"mur\",\"mvr\",\"mwk\",\"mxn\",\"myr\",\"mzn\",\"nad\",\"ngn\",\"nio\",\"nok\",\"npr\",\"nzd\",\"pab\",\"pen\",\"pgk\",\"php\",\"pkr\",\"pln\",\"pyg\",\"qar\",\"ron\",\"rsd\",\"rub\",\"rwf\",\"sar\",\"sbd\",\"scr\",\"sek\",\"sgd\",\"shp\",\"sll\",\"sos\",\"srd\",\"std\",\"svc\",\"szl\",\"thb\",\"tjs\",\"top\",\"try\",\"ttd\",\"twd\",\"tzs\",\"uah\",\"ugx\",\"uyu\",\"uzs\",\"vnd\",\"vuv\",\"wst\",\"xaf\",\"xcd\",\"xof\",\"xpf\",\"yer\",\"zar\",\"zmw\"],\"supported_payment_methods\":[\"alipay\",\"card\",\"stripe\"],\"verification_fields\":{\"individual\":{\"minimum\":[\"external_account\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]},\"company\":{\"minimum\":[\"external_account\",\"legal_entity.additional_owners\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.business_name\",\"legal_entity.business_tax_id\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]}}}',0,'2017-04-07 20:03:32',1,0,'DE','epayments',100),(75,'Ghana',0,NULL,0,0,NULL,0,'2017-05-13 15:45:48',0,0,'GH','epayments',100),(76,'Gibraltar',1,'GI',0,0,NULL,0,'2017-04-07 20:03:32',0,0,'GI','epayments',100),(77,'Greece',1,NULL,0,0,NULL,0,'2017-04-07 20:03:32',0,0,'GR','epayments',100),(78,'Greenland',0,NULL,0,0,NULL,0,'2018-01-18 14:55:20',0,0,'GL','epayments',100),(79,'Grenada',0,NULL,0,0,NULL,0,'2017-05-13 15:45:38',0,0,'GD','epayments',100),(80,'Guam',0,NULL,0,0,NULL,0,'2017-05-13 15:50:30',0,0,'GU','epayments',100),(81,'Guatemala',0,NULL,0,0,NULL,0,'2018-01-18 14:55:19',0,0,'GT','epayments',100),(82,'Guinea Bissau',0,'',0,0,NULL,0,'2017-05-13 15:54:31',0,0,'GW','epayments',100),(83,'Guinea',0,NULL,0,0,NULL,0,'2017-05-13 15:50:33',0,0,'GN','epayments',100),(84,'Guyana',0,NULL,0,0,NULL,0,'2017-05-13 15:50:35',0,0,'GY','epayments',100),(85,'Haiti',0,NULL,0,0,NULL,0,'2017-05-13 15:45:28',0,0,'HT','epayments',100),(86,'Honduras',0,NULL,0,0,NULL,0,'2017-05-13 15:45:24',0,0,'HN','epayments',100),(87,'Hong Kong',1,'HK',1,0,NULL,0,'2018-06-15 10:50:37',1,0,'HK','epayments',100),(88,'Hungary',1,NULL,0,0,NULL,0,'2017-04-07 20:03:32',0,0,'HU','epayments',100),(89,'Iceland',1,NULL,0,0,NULL,0,'2017-04-07 20:03:32',0,0,'IS','epayments',100),(90,'India',0,NULL,0,0,NULL,0,'2017-05-13 15:45:18',0,0,'IN','epayments',100),(91,'Indonesia',0,NULL,0,0,NULL,0,'2018-06-04 08:27:55',0,0,'ID','epayments',100),(92,'Iran',0,'',0,0,NULL,0,'2017-05-13 15:45:03',0,0,'IR','epayments',100),(93,'Iraq',0,NULL,0,0,NULL,0,'2017-05-13 15:45:03',0,0,'IQ','epayments',100),(94,'Ireland',1,'IE',1,0,'{\"id\":\"IE\",\"object\":\"country_spec\",\"default_currency\":\"eur\",\"supported_bank_account_currencies\":{\"eur\":[\"AT\",\"BE\",\"CH\",\"DE\",\"DK\",\"ES\",\"FI\",\"FR\",\"GB\",\"IE\",\"IT\",\"LU\",\"NL\",\"NO\",\"PT\",\"SE\"],\"dkk\":[\"DK\"],\"gbp\":[\"GB\"],\"nok\":[\"NO\"],\"sek\":[\"SE\"],\"usd\":[\"US\"]},\"supported_payment_currencies\":[\"usd\",\"aed\",\"afn\",\"all\",\"amd\",\"ang\",\"aoa\",\"ars\",\"aud\",\"awg\",\"azn\",\"bam\",\"bbd\",\"bdt\",\"bgn\",\"bif\",\"bmd\",\"bnd\",\"bob\",\"brl\",\"bsd\",\"bwp\",\"bzd\",\"cad\",\"cdf\",\"chf\",\"clp\",\"cny\",\"cop\",\"crc\",\"cve\",\"czk\",\"djf\",\"dkk\",\"dop\",\"dzd\",\"egp\",\"etb\",\"eur\",\"fjd\",\"fkp\",\"gbp\",\"gel\",\"gip\",\"gmd\",\"gnf\",\"gtq\",\"gyd\",\"hkd\",\"hnl\",\"hrk\",\"htg\",\"huf\",\"idr\",\"ils\",\"inr\",\"isk\",\"jmd\",\"jpy\",\"kes\",\"kgs\",\"khr\",\"kmf\",\"krw\",\"kyd\",\"kzt\",\"lak\",\"lbp\",\"lkr\",\"lrd\",\"lsl\",\"ltl\",\"mad\",\"mdl\",\"mga\",\"mkd\",\"mnt\",\"mop\",\"mro\",\"mur\",\"mvr\",\"mwk\",\"mxn\",\"myr\",\"mzn\",\"nad\",\"ngn\",\"nio\",\"nok\",\"npr\",\"nzd\",\"pab\",\"pen\",\"pgk\",\"php\",\"pkr\",\"pln\",\"pyg\",\"qar\",\"ron\",\"rsd\",\"rub\",\"rwf\",\"sar\",\"sbd\",\"scr\",\"sek\",\"sgd\",\"shp\",\"sll\",\"sos\",\"srd\",\"std\",\"svc\",\"szl\",\"thb\",\"tjs\",\"top\",\"try\",\"ttd\",\"twd\",\"tzs\",\"uah\",\"ugx\",\"uyu\",\"uzs\",\"vnd\",\"vuv\",\"wst\",\"xaf\",\"xcd\",\"xof\",\"xpf\",\"yer\",\"zar\",\"zmw\"],\"supported_payment_methods\":[\"alipay\",\"card\",\"stripe\"],\"verification_fields\":{\"individual\":{\"minimum\":[\"external_account\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.state\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.state\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]},\"company\":{\"minimum\":[\"external_account\",\"legal_entity.additional_owners\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.state\",\"legal_entity.business_name\",\"legal_entity.business_tax_id\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.state\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]}}}',1,'2017-04-07 20:03:32',1,0,'IE','epayments',100),(95,'Israel',0,NULL,0,0,NULL,0,'2018-06-04 08:27:45',0,0,'IL','epayments',100),(96,'Italy',1,'IT',1,0,'{\"id\":\"IT\",\"object\":\"country_spec\",\"default_currency\":\"eur\",\"supported_bank_account_currencies\":{\"eur\":[\"AT\",\"BE\",\"CH\",\"DE\",\"DK\",\"ES\",\"FI\",\"FR\",\"GB\",\"IE\",\"IT\",\"LU\",\"NL\",\"NO\",\"PT\",\"SE\"],\"dkk\":[\"DK\"],\"gbp\":[\"GB\"],\"nok\":[\"NO\"],\"sek\":[\"SE\"],\"usd\":[\"US\"]},\"supported_payment_currencies\":[\"usd\",\"aed\",\"afn\",\"all\",\"amd\",\"ang\",\"aoa\",\"ars\",\"aud\",\"awg\",\"azn\",\"bam\",\"bbd\",\"bdt\",\"bgn\",\"bif\",\"bmd\",\"bnd\",\"bob\",\"brl\",\"bsd\",\"bwp\",\"bzd\",\"cad\",\"cdf\",\"chf\",\"clp\",\"cny\",\"cop\",\"crc\",\"cve\",\"czk\",\"djf\",\"dkk\",\"dop\",\"dzd\",\"egp\",\"etb\",\"eur\",\"fjd\",\"fkp\",\"gbp\",\"gel\",\"gip\",\"gmd\",\"gnf\",\"gtq\",\"gyd\",\"hkd\",\"hnl\",\"hrk\",\"htg\",\"huf\",\"idr\",\"ils\",\"inr\",\"isk\",\"jmd\",\"jpy\",\"kes\",\"kgs\",\"khr\",\"kmf\",\"krw\",\"kyd\",\"kzt\",\"lak\",\"lbp\",\"lkr\",\"lrd\",\"lsl\",\"ltl\",\"mad\",\"mdl\",\"mga\",\"mkd\",\"mnt\",\"mop\",\"mro\",\"mur\",\"mvr\",\"mwk\",\"mxn\",\"myr\",\"mzn\",\"nad\",\"ngn\",\"nio\",\"nok\",\"npr\",\"nzd\",\"pab\",\"pen\",\"pgk\",\"php\",\"pkr\",\"pln\",\"pyg\",\"qar\",\"ron\",\"rsd\",\"rub\",\"rwf\",\"sar\",\"sbd\",\"scr\",\"sek\",\"sgd\",\"shp\",\"sll\",\"sos\",\"srd\",\"std\",\"svc\",\"szl\",\"thb\",\"tjs\",\"top\",\"try\",\"ttd\",\"twd\",\"tzs\",\"uah\",\"ugx\",\"uyu\",\"uzs\",\"vnd\",\"vuv\",\"wst\",\"xaf\",\"xcd\",\"xof\",\"xpf\",\"yer\",\"zar\",\"zmw\"],\"supported_payment_methods\":[\"alipay\",\"card\",\"stripe\"],\"verification_fields\":{\"individual\":{\"minimum\":[\"external_account\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]},\"company\":{\"minimum\":[\"external_account\",\"legal_entity.additional_owners\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.business_name\",\"legal_entity.business_tax_id\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]}}}',0,'2017-04-07 20:03:32',1,0,'IT','epayments',100),(97,'Jamaica',0,NULL,0,0,NULL,0,'2018-01-18 14:55:14',0,0,'JM','epayments',100),(98,'Japan',1,'',0,0,NULL,0,'2018-06-15 10:50:22',0,0,'JP','epayments',100),(99,'Jordan',0,NULL,0,0,NULL,0,'2017-05-13 15:50:14',0,0,'JO','epayments',100),(100,'Kazakhstan',0,NULL,0,0,NULL,0,'2018-06-04 08:36:52',0,0,'KZ','epayments',100),(101,'Kenya',0,NULL,0,0,NULL,0,'2017-05-13 15:50:16',0,0,'KE','epayments',100),(102,'Kiribati',0,NULL,0,0,NULL,0,'2017-05-13 15:44:59',0,0,'KI','epayments',100),(103,'Kuwait',0,NULL,0,0,NULL,0,'2017-05-13 15:50:17',0,0,'KW','epayments',100),(104,'Kyrgyzstan',0,NULL,0,0,NULL,0,'2017-05-13 15:44:58',0,0,'KG','epayments',100),(105,'Laos',0,'',0,0,NULL,0,'2017-05-13 15:44:56',0,0,'LA','epayments',100),(106,'Latvia',1,NULL,0,0,NULL,0,'2017-04-07 20:03:32',0,0,'LV','epayments',100),(107,'Lebanon',0,NULL,0,0,NULL,0,'2017-05-13 15:44:54',0,0,'LB','epayments',100),(108,'Lesotho',0,NULL,0,0,NULL,0,'2017-05-13 15:44:53',0,0,'LS','epayments',100),(109,'Liberia',0,NULL,0,0,NULL,0,'2017-05-13 15:44:52',0,0,'LR','epayments',100),(110,'Libya',0,'',0,0,NULL,0,'2017-05-13 15:44:51',0,0,'LY','epayments',100),(111,'Liechtenstein',1,NULL,0,0,NULL,0,'2017-04-07 20:03:32',0,0,'LI','epayments',100),(112,'Lithuania',1,NULL,0,0,NULL,0,'2017-04-07 20:03:32',0,0,'LT','epayments',100),(113,'Luxembourg',1,'LU',1,0,'{\"id\":\"LU\",\"object\":\"country_spec\",\"default_currency\":\"eur\",\"supported_bank_account_currencies\":{\"eur\":[\"AT\",\"BE\",\"CH\",\"DE\",\"DK\",\"ES\",\"FI\",\"FR\",\"GB\",\"IE\",\"IT\",\"LU\",\"NL\",\"NO\",\"PT\",\"SE\"],\"dkk\":[\"DK\"],\"gbp\":[\"GB\"],\"nok\":[\"NO\"],\"sek\":[\"SE\"],\"usd\":[\"US\"]},\"supported_payment_currencies\":[\"usd\",\"aed\",\"afn\",\"all\",\"amd\",\"ang\",\"aoa\",\"ars\",\"aud\",\"awg\",\"azn\",\"bam\",\"bbd\",\"bdt\",\"bgn\",\"bif\",\"bmd\",\"bnd\",\"bob\",\"brl\",\"bsd\",\"bwp\",\"bzd\",\"cad\",\"cdf\",\"chf\",\"clp\",\"cny\",\"cop\",\"crc\",\"cve\",\"czk\",\"djf\",\"dkk\",\"dop\",\"dzd\",\"egp\",\"etb\",\"eur\",\"fjd\",\"fkp\",\"gbp\",\"gel\",\"gip\",\"gmd\",\"gnf\",\"gtq\",\"gyd\",\"hkd\",\"hnl\",\"hrk\",\"htg\",\"huf\",\"idr\",\"ils\",\"inr\",\"isk\",\"jmd\",\"jpy\",\"kes\",\"kgs\",\"khr\",\"kmf\",\"krw\",\"kyd\",\"kzt\",\"lak\",\"lbp\",\"lkr\",\"lrd\",\"lsl\",\"ltl\",\"mad\",\"mdl\",\"mga\",\"mkd\",\"mnt\",\"mop\",\"mro\",\"mur\",\"mvr\",\"mwk\",\"mxn\",\"myr\",\"mzn\",\"nad\",\"ngn\",\"nio\",\"nok\",\"npr\",\"nzd\",\"pab\",\"pen\",\"pgk\",\"php\",\"pkr\",\"pln\",\"pyg\",\"qar\",\"ron\",\"rsd\",\"rub\",\"rwf\",\"sar\",\"sbd\",\"scr\",\"sek\",\"sgd\",\"shp\",\"sll\",\"sos\",\"srd\",\"std\",\"svc\",\"szl\",\"thb\",\"tjs\",\"top\",\"try\",\"ttd\",\"twd\",\"tzs\",\"uah\",\"ugx\",\"uyu\",\"uzs\",\"vnd\",\"vuv\",\"wst\",\"xaf\",\"xcd\",\"xof\",\"xpf\",\"yer\",\"zar\",\"zmw\"],\"supported_payment_methods\":[\"alipay\",\"card\",\"stripe\"],\"verification_fields\":{\"individual\":{\"minimum\":[\"external_account\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]},\"company\":{\"minimum\":[\"external_account\",\"legal_entity.additional_owners\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.business_name\",\"legal_entity.business_tax_id\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]}}}',0,'2017-04-07 20:03:32',1,0,'LU','epayments',100),(114,'Macao',0,NULL,0,0,NULL,0,'2017-05-13 15:49:41',0,0,'MO','epayments',100),(115,'Macedonia',1,NULL,0,0,NULL,0,'2017-04-07 20:03:32',0,0,'MK','epayments',100),(116,'Madagascar',0,NULL,0,0,NULL,0,'2017-05-13 15:49:38',0,0,'MG','epayments',100),(117,'Malawi',0,NULL,0,0,NULL,0,'2017-05-13 15:44:42',0,0,'MW','epayments',100),(118,'Malaysia',1,'',0,0,NULL,0,'2018-06-21 18:47:19',0,0,'MY','epayments',100),(119,'Maldives',0,NULL,0,0,NULL,0,'2018-01-18 14:55:04',0,0,'MV','epayments',100),(120,'Mali',0,NULL,0,0,NULL,0,'2017-05-13 15:44:40',0,0,'ML','epayments',100),(121,'Malta',1,NULL,0,0,NULL,0,'2017-04-07 20:03:32',0,0,'MT','epayments',100),(122,'Marshall Islands',0,NULL,0,0,NULL,0,'2017-05-13 15:44:38',0,0,'MH','epayments',100),(123,'Martinique',0,NULL,0,0,NULL,0,'2017-05-13 15:44:36',0,0,'MQ','epayments',100),(124,'Mauritania',0,NULL,0,0,NULL,0,'2017-05-13 15:44:35',0,0,'MR','epayments',100),(125,'Mauritius',0,NULL,0,0,NULL,0,'2018-01-18 14:55:01',0,0,'MU','epayments',100),(126,'Mexico',1,'',0,0,NULL,0,'2018-06-15 10:44:57',0,0,'MX','epayments',100),(127,'Micronesia',0,'',0,0,NULL,0,'2018-06-04 08:26:46',0,0,'FM','epayments',100),(128,'Moldova',1,'',0,0,NULL,0,'2017-04-07 20:17:49',0,0,'MD','epayments',100),(129,'Monaco',0,NULL,0,0,NULL,0,'2018-01-18 14:54:52',0,0,'MC','epayments',100),(130,'Mongolia',0,NULL,0,0,NULL,0,'2017-05-13 15:49:19',0,0,'MN','epayments',100),(131,'Montserrat',0,NULL,0,0,NULL,0,'2017-05-13 15:54:13',0,0,'MS','epayments',100),(132,'Morocco',0,NULL,0,0,NULL,0,'2017-05-13 15:49:25',0,0,'MA','epayments',100),(133,'Mozambique',0,NULL,0,0,NULL,0,'2017-05-13 15:44:28',0,0,'MZ','epayments',100),(134,'Myanmar',0,NULL,0,0,NULL,0,'2017-05-13 15:44:26',0,0,'MM','epayments',100),(135,'Namibia',0,NULL,0,0,NULL,0,'2017-05-13 15:44:25',0,0,'NA','epayments',100),(136,'Nauru',0,NULL,0,0,NULL,0,'2017-05-13 15:44:24',0,0,'NR','epayments',100),(137,'Nepal',0,NULL,0,0,NULL,0,'2018-01-18 14:54:51',0,0,'NP','epayments',100),(138,'Netherlands Antilles',0,'',0,0,NULL,0,'2017-05-13 15:53:49',0,0,'AN','epayments',100),(139,'Netherlands',1,'NL',1,0,'{\"id\":\"NL\",\"object\":\"country_spec\",\"default_currency\":\"eur\",\"supported_bank_account_currencies\":{\"eur\":[\"AT\",\"BE\",\"CH\",\"DE\",\"DK\",\"ES\",\"FI\",\"FR\",\"GB\",\"IE\",\"IT\",\"LU\",\"NL\",\"NO\",\"PT\",\"SE\"],\"dkk\":[\"DK\"],\"gbp\":[\"GB\"],\"nok\":[\"NO\"],\"sek\":[\"SE\"],\"usd\":[\"US\"]},\"supported_payment_currencies\":[\"usd\",\"aed\",\"afn\",\"all\",\"amd\",\"ang\",\"aoa\",\"ars\",\"aud\",\"awg\",\"azn\",\"bam\",\"bbd\",\"bdt\",\"bgn\",\"bif\",\"bmd\",\"bnd\",\"bob\",\"brl\",\"bsd\",\"bwp\",\"bzd\",\"cad\",\"cdf\",\"chf\",\"clp\",\"cny\",\"cop\",\"crc\",\"cve\",\"czk\",\"djf\",\"dkk\",\"dop\",\"dzd\",\"egp\",\"etb\",\"eur\",\"fjd\",\"fkp\",\"gbp\",\"gel\",\"gip\",\"gmd\",\"gnf\",\"gtq\",\"gyd\",\"hkd\",\"hnl\",\"hrk\",\"htg\",\"huf\",\"idr\",\"ils\",\"inr\",\"isk\",\"jmd\",\"jpy\",\"kes\",\"kgs\",\"khr\",\"kmf\",\"krw\",\"kyd\",\"kzt\",\"lak\",\"lbp\",\"lkr\",\"lrd\",\"lsl\",\"ltl\",\"mad\",\"mdl\",\"mga\",\"mkd\",\"mnt\",\"mop\",\"mro\",\"mur\",\"mvr\",\"mwk\",\"mxn\",\"myr\",\"mzn\",\"nad\",\"ngn\",\"nio\",\"nok\",\"npr\",\"nzd\",\"pab\",\"pen\",\"pgk\",\"php\",\"pkr\",\"pln\",\"pyg\",\"qar\",\"ron\",\"rsd\",\"rub\",\"rwf\",\"sar\",\"sbd\",\"scr\",\"sek\",\"sgd\",\"shp\",\"sll\",\"sos\",\"srd\",\"std\",\"svc\",\"szl\",\"thb\",\"tjs\",\"top\",\"try\",\"ttd\",\"twd\",\"tzs\",\"uah\",\"ugx\",\"uyu\",\"uzs\",\"vnd\",\"vuv\",\"wst\",\"xaf\",\"xcd\",\"xof\",\"xpf\",\"yer\",\"zar\",\"zmw\"],\"supported_payment_methods\":[\"alipay\",\"card\",\"stripe\"],\"verification_fields\":{\"individual\":{\"minimum\":[\"external_account\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]},\"company\":{\"minimum\":[\"external_account\",\"legal_entity.additional_owners\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.business_name\",\"legal_entity.business_tax_id\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]}}}',0,'2017-04-07 20:03:32',1,0,'NL','epayments',100),(140,'New Zealand',1,'NZ',1,0,NULL,0,'2018-06-04 08:31:52',1,0,'NZ','transferwise',100),(141,'Nicaragua',0,NULL,0,0,NULL,0,'2017-05-13 15:44:15',0,0,'NI','epayments',100),(142,'Nigeria',0,NULL,0,0,NULL,0,'2017-05-13 15:44:14',0,0,'NG','epayments',100),(143,'Niger',0,NULL,0,0,NULL,0,'2017-05-13 15:48:58',0,0,'NE','epayments',100),(144,'Niue',0,NULL,0,0,NULL,0,'2017-05-13 15:48:59',0,0,'NU','epayments',100),(145,'Norfolk Island',0,NULL,0,0,NULL,0,'2017-05-13 15:49:02',0,0,'NF','epayments',100),(146,'North Korea',0,'',0,0,NULL,0,'2017-05-13 15:49:04',0,0,'KP','epayments',100),(147,'Norway',1,'NO',1,0,'{\"id\":\"NO\",\"object\":\"country_spec\",\"default_currency\":\"nok\",\"supported_bank_account_currencies\":{\"eur\":[\"AT\",\"BE\",\"CH\",\"DE\",\"DK\",\"ES\",\"FI\",\"FR\",\"GB\",\"IE\",\"IT\",\"LU\",\"NL\",\"NO\",\"PT\",\"SE\"],\"dkk\":[\"DK\"],\"gbp\":[\"GB\"],\"nok\":[\"NO\"],\"sek\":[\"SE\"],\"usd\":[\"US\"]},\"supported_payment_currencies\":[\"usd\",\"aed\",\"afn\",\"all\",\"amd\",\"ang\",\"aoa\",\"ars\",\"aud\",\"awg\",\"azn\",\"bam\",\"bbd\",\"bdt\",\"bgn\",\"bif\",\"bmd\",\"bnd\",\"bob\",\"brl\",\"bsd\",\"bwp\",\"bzd\",\"cad\",\"cdf\",\"chf\",\"clp\",\"cny\",\"cop\",\"crc\",\"cve\",\"czk\",\"djf\",\"dkk\",\"dop\",\"dzd\",\"egp\",\"etb\",\"eur\",\"fjd\",\"fkp\",\"gbp\",\"gel\",\"gip\",\"gmd\",\"gnf\",\"gtq\",\"gyd\",\"hkd\",\"hnl\",\"hrk\",\"htg\",\"huf\",\"idr\",\"ils\",\"inr\",\"isk\",\"jmd\",\"jpy\",\"kes\",\"kgs\",\"khr\",\"kmf\",\"krw\",\"kyd\",\"kzt\",\"lak\",\"lbp\",\"lkr\",\"lrd\",\"lsl\",\"ltl\",\"mad\",\"mdl\",\"mga\",\"mkd\",\"mnt\",\"mop\",\"mro\",\"mur\",\"mvr\",\"mwk\",\"mxn\",\"myr\",\"mzn\",\"nad\",\"ngn\",\"nio\",\"nok\",\"npr\",\"nzd\",\"pab\",\"pen\",\"pgk\",\"php\",\"pkr\",\"pln\",\"pyg\",\"qar\",\"ron\",\"rsd\",\"rub\",\"rwf\",\"sar\",\"sbd\",\"scr\",\"sek\",\"sgd\",\"shp\",\"sll\",\"sos\",\"srd\",\"std\",\"svc\",\"szl\",\"thb\",\"tjs\",\"top\",\"try\",\"ttd\",\"twd\",\"tzs\",\"uah\",\"ugx\",\"uyu\",\"uzs\",\"vnd\",\"vuv\",\"wst\",\"xaf\",\"xcd\",\"xof\",\"xpf\",\"yer\",\"zar\",\"zmw\"],\"supported_payment_methods\":[\"alipay\",\"card\",\"stripe\"],\"verification_fields\":{\"individual\":{\"minimum\":[\"external_account\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]},\"company\":{\"minimum\":[\"external_account\",\"legal_entity.additional_owners\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.business_name\",\"legal_entity.business_tax_id\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]}}}',0,'2017-04-07 20:03:32',1,0,'NO','epayments',100),(148,'Oman',0,NULL,0,0,NULL,0,'2017-05-13 15:44:08',0,0,'OM','epayments',100),(149,'Pakistan',0,NULL,0,0,NULL,0,'2017-05-13 15:44:06',0,0,'PK','epayments',100),(150,'Palau',0,NULL,0,0,NULL,0,'2017-05-13 15:44:04',0,0,'PW','epayments',100),(151,'Panama',0,NULL,0,0,NULL,0,'2017-05-13 15:49:11',0,0,'PA','epayments',100),(152,'Papua New Guinea',0,NULL,0,0,NULL,0,'2017-05-13 15:49:09',0,0,'PG','epayments',100),(153,'Paraguay',0,NULL,0,0,NULL,0,'2017-05-13 15:49:10',0,0,'PY','epayments',100),(154,'Peru',0,NULL,0,0,NULL,0,'2017-05-13 15:53:56',0,0,'PE','epayments',100),(155,'Philippines',1,'',0,0,NULL,0,'2018-06-15 10:50:08',0,0,'PH','epayments',100),(156,'Pitcairn Islands',0,'',0,0,NULL,0,'2017-05-13 15:43:54',0,0,'PN','epayments',100),(157,'Poland',1,NULL,0,0,NULL,0,'2017-04-07 20:03:32',0,0,'PL','epayments',100),(158,'Portugal',1,'PT',1,0,NULL,0,'2017-04-07 20:03:32',1,0,'PT','epayments',100),(159,'Puerto Rico',0,NULL,0,0,NULL,0,'2018-06-04 08:25:57',0,0,'PR','epayments',100),(160,'Qatar',0,NULL,0,0,NULL,0,'2018-06-04 08:25:56',0,0,'QA','epayments',100),(161,'Republic of the Congo',0,'',0,0,NULL,0,'2017-05-13 15:48:48',0,0,'CG','epayments',100),(162,'Romania',1,NULL,0,0,NULL,0,'2017-04-07 20:03:32',0,0,'RO','epayments',100),(163,'Russian Federation',1,NULL,0,0,NULL,0,'2017-04-07 20:03:32',0,0,'RU','epayments',100),(164,'Rwanda',0,NULL,0,0,NULL,0,'2017-05-13 15:43:49',0,0,'RW','epayments',100),(165,'Saint Kitts and Nevis',0,NULL,0,0,NULL,0,'2017-05-13 15:43:48',0,0,'KN','epayments',100),(166,'Saint Lucia',0,NULL,0,0,NULL,0,'2017-05-13 15:43:48',0,0,'LC','epayments',100),(167,'Saint Pierre',0,'',0,0,NULL,0,'2017-05-13 15:43:47',0,0,'PM','epayments',100),(168,'Saint Vicent and the Grenadines',0,'',0,0,NULL,0,'2017-05-13 15:43:45',0,0,'VC','epayments',100),(169,'Samoa',0,NULL,0,0,NULL,0,'2017-05-13 15:48:50',0,0,'WS','epayments',100),(170,'San Marino',0,NULL,0,0,NULL,0,'2018-06-04 08:25:48',0,0,'SM','epayments',100),(171,'Sao Tomé and PrÃncipe',0,NULL,0,0,NULL,0,'2017-05-13 15:43:40',0,0,'ST','epayments',100),(172,'Saudi Arabia',0,NULL,0,0,NULL,0,'2018-06-04 08:24:59',0,0,'SA','epayments',100),(173,'Senegal',0,NULL,0,0,NULL,0,'2017-05-13 15:48:32',0,0,'SN','epayments',100),(174,'Serbia and Montenegro',1,'',0,0,NULL,0,'2017-04-07 20:13:47',0,0,'RS','epayments',100),(175,'Seychelles',0,NULL,0,0,NULL,0,'2017-05-13 15:53:38',0,0,'SC','epayments',100),(176,'Sierra Leone',0,NULL,0,0,NULL,0,'2017-05-13 15:48:38',0,0,'SL','epayments',100),(177,'Singapore',1,'SG',1,0,NULL,0,'2018-06-15 10:49:34',1,0,'SG','epayments',100),(178,'Slovakia',1,NULL,0,0,NULL,0,'2017-04-07 20:03:32',0,0,'SK','epayments',100),(179,'Slovenia',1,NULL,0,0,NULL,0,'2017-04-07 20:03:32',0,0,'SI','epayments',100),(180,'Solomon Islands',0,'',0,0,NULL,0,'2017-05-13 15:43:33',0,0,'SB','epayments',100),(181,'Somalia',0,NULL,0,0,NULL,0,'2017-05-13 15:43:30',0,0,'SO','epayments',100),(182,'South Africa',1,'',0,0,NULL,0,'2018-06-15 10:49:10',0,0,'ZA','epayments',100),(183,'South Georgia',0,'',0,0,NULL,0,'2017-05-13 15:43:27',0,0,'GS','epayments',100),(184,'South Korea',1,'',0,0,NULL,0,'2018-06-04 08:36:13',0,0,'KR','paypal',100),(186,'Spain',1,'ES',1,0,'{\"id\":\"ES\",\"object\":\"country_spec\",\"default_currency\":\"eur\",\"supported_bank_account_currencies\":{\"eur\":[\"AT\",\"BE\",\"CH\",\"DE\",\"DK\",\"ES\",\"FI\",\"FR\",\"GB\",\"IE\",\"IT\",\"LU\",\"NL\",\"NO\",\"PT\",\"SE\"],\"dkk\":[\"DK\"],\"gbp\":[\"GB\"],\"nok\":[\"NO\"],\"sek\":[\"SE\"],\"usd\":[\"US\"]},\"supported_payment_currencies\":[\"usd\",\"aed\",\"afn\",\"all\",\"amd\",\"ang\",\"aoa\",\"ars\",\"aud\",\"awg\",\"azn\",\"bam\",\"bbd\",\"bdt\",\"bgn\",\"bif\",\"bmd\",\"bnd\",\"bob\",\"brl\",\"bsd\",\"bwp\",\"bzd\",\"cad\",\"cdf\",\"chf\",\"clp\",\"cny\",\"cop\",\"crc\",\"cve\",\"czk\",\"djf\",\"dkk\",\"dop\",\"dzd\",\"egp\",\"etb\",\"eur\",\"fjd\",\"fkp\",\"gbp\",\"gel\",\"gip\",\"gmd\",\"gnf\",\"gtq\",\"gyd\",\"hkd\",\"hnl\",\"hrk\",\"htg\",\"huf\",\"idr\",\"ils\",\"inr\",\"isk\",\"jmd\",\"jpy\",\"kes\",\"kgs\",\"khr\",\"kmf\",\"krw\",\"kyd\",\"kzt\",\"lak\",\"lbp\",\"lkr\",\"lrd\",\"lsl\",\"ltl\",\"mad\",\"mdl\",\"mga\",\"mkd\",\"mnt\",\"mop\",\"mro\",\"mur\",\"mvr\",\"mwk\",\"mxn\",\"myr\",\"mzn\",\"nad\",\"ngn\",\"nio\",\"nok\",\"npr\",\"nzd\",\"pab\",\"pen\",\"pgk\",\"php\",\"pkr\",\"pln\",\"pyg\",\"qar\",\"ron\",\"rsd\",\"rub\",\"rwf\",\"sar\",\"sbd\",\"scr\",\"sek\",\"sgd\",\"shp\",\"sll\",\"sos\",\"srd\",\"std\",\"svc\",\"szl\",\"thb\",\"tjs\",\"top\",\"try\",\"ttd\",\"twd\",\"tzs\",\"uah\",\"ugx\",\"uyu\",\"uzs\",\"vnd\",\"vuv\",\"wst\",\"xaf\",\"xcd\",\"xof\",\"xpf\",\"yer\",\"zar\",\"zmw\"],\"supported_payment_methods\":[\"alipay\",\"card\",\"stripe\"],\"verification_fields\":{\"individual\":{\"minimum\":[\"external_account\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]},\"company\":{\"minimum\":[\"external_account\",\"legal_entity.additional_owners\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.business_name\",\"legal_entity.business_tax_id\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]}}}',0,'2017-04-07 20:03:32',1,0,'ES','epayments',100),(187,'Sri Lanka',0,NULL,0,0,NULL,0,'2018-06-04 08:24:42',0,0,'LK','epayments',100),(188,'Sudan',0,NULL,0,0,NULL,0,'2017-05-13 15:43:18',0,0,'SD','epayments',100),(189,'Suriname',0,NULL,0,0,NULL,0,'2017-05-13 15:43:17',0,0,'SR','epayments',100),(190,'Swaziland',0,NULL,0,0,NULL,0,'2017-05-13 15:43:15',0,0,'SZ','epayments',100),(191,'Sweden',1,'SE',1,0,'{\"id\":\"SE\",\"object\":\"country_spec\",\"default_currency\":\"sek\",\"supported_bank_account_currencies\":{\"eur\":[\"AT\",\"BE\",\"CH\",\"DE\",\"DK\",\"ES\",\"FI\",\"FR\",\"GB\",\"IE\",\"IT\",\"LU\",\"NL\",\"NO\",\"PT\",\"SE\"],\"dkk\":[\"DK\"],\"gbp\":[\"GB\"],\"nok\":[\"NO\"],\"sek\":[\"SE\"],\"usd\":[\"US\"]},\"supported_payment_currencies\":[\"usd\",\"aed\",\"afn\",\"all\",\"amd\",\"ang\",\"aoa\",\"ars\",\"aud\",\"awg\",\"azn\",\"bam\",\"bbd\",\"bdt\",\"bgn\",\"bif\",\"bmd\",\"bnd\",\"bob\",\"brl\",\"bsd\",\"bwp\",\"bzd\",\"cad\",\"cdf\",\"chf\",\"clp\",\"cny\",\"cop\",\"crc\",\"cve\",\"czk\",\"djf\",\"dkk\",\"dop\",\"dzd\",\"egp\",\"etb\",\"eur\",\"fjd\",\"fkp\",\"gbp\",\"gel\",\"gip\",\"gmd\",\"gnf\",\"gtq\",\"gyd\",\"hkd\",\"hnl\",\"hrk\",\"htg\",\"huf\",\"idr\",\"ils\",\"inr\",\"isk\",\"jmd\",\"jpy\",\"kes\",\"kgs\",\"khr\",\"kmf\",\"krw\",\"kyd\",\"kzt\",\"lak\",\"lbp\",\"lkr\",\"lrd\",\"lsl\",\"ltl\",\"mad\",\"mdl\",\"mga\",\"mkd\",\"mnt\",\"mop\",\"mro\",\"mur\",\"mvr\",\"mwk\",\"mxn\",\"myr\",\"mzn\",\"nad\",\"ngn\",\"nio\",\"nok\",\"npr\",\"nzd\",\"pab\",\"pen\",\"pgk\",\"php\",\"pkr\",\"pln\",\"pyg\",\"qar\",\"ron\",\"rsd\",\"rub\",\"rwf\",\"sar\",\"sbd\",\"scr\",\"sek\",\"sgd\",\"shp\",\"sll\",\"sos\",\"srd\",\"std\",\"svc\",\"szl\",\"thb\",\"tjs\",\"top\",\"try\",\"ttd\",\"twd\",\"tzs\",\"uah\",\"ugx\",\"uyu\",\"uzs\",\"vnd\",\"vuv\",\"wst\",\"xaf\",\"xcd\",\"xof\",\"xpf\",\"yer\",\"zar\",\"zmw\"],\"supported_payment_methods\":[\"alipay\",\"card\",\"stripe\"],\"verification_fields\":{\"individual\":{\"minimum\":[\"external_account\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]},\"company\":{\"minimum\":[\"external_account\",\"legal_entity.additional_owners\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.business_name\",\"legal_entity.business_tax_id\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]}}}',0,'2017-04-07 20:03:32',1,0,'SE','epayments',100),(192,'Switzerland',1,'CH',1,0,NULL,0,'2017-04-07 20:03:32',1,0,'CH','epayments',100),(193,'Syria',0,'',0,0,NULL,0,'2017-05-13 15:48:18',0,0,'SY','epayments',100),(194,'Taiwan',0,NULL,0,0,NULL,0,'2018-06-04 08:24:17',0,0,'TW','epayments',100),(195,'Tajikistan',0,NULL,0,0,NULL,0,'2017-05-13 15:48:21',0,0,'TJ','epayments',100),(196,'Tanzania',0,'',0,0,NULL,0,'2017-05-13 15:48:23',0,0,'TZ','epayments',100),(197,'Thailand',1,'',0,0,NULL,0,'2018-06-15 10:48:01',0,0,'TH','epayments',100),(198,'Tibet',0,'',0,0,NULL,0,'2017-05-13 15:43:10',0,0,'TB','epayments',100),(199,'Timor-Leste',0,NULL,0,0,NULL,0,'2017-05-13 15:43:08',0,0,'TL','epayments',100),(200,'Togo',0,NULL,0,0,NULL,0,'2017-05-13 15:43:08',0,0,'TG','epayments',100),(201,'Tonga',0,NULL,0,0,NULL,0,'2017-05-13 15:43:06',0,0,'TO','epayments',100),(202,'Trinidad and Tobago',0,NULL,0,0,NULL,0,'2017-05-13 15:48:25',0,0,'TT','epayments',100),(203,'Tunisia',0,NULL,0,0,NULL,0,'2017-06-10 12:55:26',0,0,'TN','epayments',100),(204,'Turkey',1,NULL,0,0,NULL,0,'2017-04-07 20:03:32',0,0,'TR','epayments',100),(205,'Turkmenistan',0,NULL,0,0,NULL,0,'2017-05-13 15:42:55',0,0,'TM','epayments',100),(206,'Turks and Caicos Islands',0,NULL,0,0,NULL,0,'2017-05-13 15:42:58',0,0,'TC','epayments',100),(207,'Tuvalu',0,NULL,0,0,NULL,0,'2017-05-13 15:48:05',0,0,'TV','epayments',100),(208,'UAE',1,'',0,0,NULL,0,'2018-06-15 10:52:13',0,0,'AE','epayments',100),(209,'Uganda',0,NULL,0,0,NULL,0,'2017-05-13 15:48:11',0,0,'UG','epayments',100),(210,'Ukraine',1,NULL,0,0,NULL,0,'2017-04-07 20:03:32',0,0,'UA','epayments',100),(211,'United Kingdom',1,'GB',1,0,'{\"id\":\"GB\",\"object\":\"country_spec\",\"default_currency\":\"gbp\",\"supported_bank_account_currencies\":{\"eur\":[\"AT\",\"BE\",\"CH\",\"DE\",\"DK\",\"ES\",\"FI\",\"FR\",\"GB\",\"IE\",\"IT\",\"LU\",\"NL\",\"NO\",\"PT\",\"SE\"],\"dkk\":[\"DK\"],\"gbp\":[\"GB\"],\"nok\":[\"NO\"],\"sek\":[\"SE\"],\"usd\":[\"US\"]},\"supported_payment_currencies\":[\"usd\",\"aed\",\"afn\",\"all\",\"amd\",\"ang\",\"aoa\",\"ars\",\"aud\",\"awg\",\"azn\",\"bam\",\"bbd\",\"bdt\",\"bgn\",\"bif\",\"bmd\",\"bnd\",\"bob\",\"brl\",\"bsd\",\"bwp\",\"bzd\",\"cad\",\"cdf\",\"chf\",\"clp\",\"cny\",\"cop\",\"crc\",\"cve\",\"czk\",\"djf\",\"dkk\",\"dop\",\"dzd\",\"egp\",\"etb\",\"eur\",\"fjd\",\"fkp\",\"gbp\",\"gel\",\"gip\",\"gmd\",\"gnf\",\"gtq\",\"gyd\",\"hkd\",\"hnl\",\"hrk\",\"htg\",\"huf\",\"idr\",\"ils\",\"inr\",\"isk\",\"jmd\",\"jpy\",\"kes\",\"kgs\",\"khr\",\"kmf\",\"krw\",\"kyd\",\"kzt\",\"lak\",\"lbp\",\"lkr\",\"lrd\",\"lsl\",\"ltl\",\"mad\",\"mdl\",\"mga\",\"mkd\",\"mnt\",\"mop\",\"mro\",\"mur\",\"mvr\",\"mwk\",\"mxn\",\"myr\",\"mzn\",\"nad\",\"ngn\",\"nio\",\"nok\",\"npr\",\"nzd\",\"pab\",\"pen\",\"pgk\",\"php\",\"pkr\",\"pln\",\"pyg\",\"qar\",\"ron\",\"rsd\",\"rub\",\"rwf\",\"sar\",\"sbd\",\"scr\",\"sek\",\"sgd\",\"shp\",\"sll\",\"sos\",\"srd\",\"std\",\"svc\",\"szl\",\"thb\",\"tjs\",\"top\",\"try\",\"ttd\",\"twd\",\"tzs\",\"uah\",\"ugx\",\"uyu\",\"uzs\",\"vnd\",\"vuv\",\"wst\",\"xaf\",\"xcd\",\"xof\",\"xpf\",\"yer\",\"zar\",\"zmw\"],\"supported_payment_methods\":[\"alipay\",\"card\",\"stripe\"],\"verification_fields\":{\"individual\":{\"minimum\":[\"external_account\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]},\"company\":{\"minimum\":[\"external_account\",\"legal_entity.additional_owners\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.business_name\",\"legal_entity.business_tax_id\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_address.city\",\"legal_entity.personal_address.line1\",\"legal_entity.personal_address.postal_code\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.verification.document\"]}}}',0,'2017-04-07 20:03:32',1,0,'GB','bank',100),(212,' United States of America',1,'US',1,0,'{\"id\":\"US\",\"object\":\"country_spec\",\"default_currency\":\"usd\",\"supported_bank_account_currencies\":{\"usd\":[\"US\"]},\"supported_payment_currencies\":[\"usd\",\"aed\",\"afn\",\"all\",\"amd\",\"ang\",\"aoa\",\"ars\",\"aud\",\"awg\",\"azn\",\"bam\",\"bbd\",\"bdt\",\"bgn\",\"bif\",\"bmd\",\"bnd\",\"bob\",\"brl\",\"bsd\",\"bwp\",\"bzd\",\"cad\",\"cdf\",\"chf\",\"clp\",\"cny\",\"cop\",\"crc\",\"cve\",\"czk\",\"djf\",\"dkk\",\"dop\",\"dzd\",\"egp\",\"etb\",\"eur\",\"fjd\",\"fkp\",\"gbp\",\"gel\",\"gip\",\"gmd\",\"gnf\",\"gtq\",\"gyd\",\"hkd\",\"hnl\",\"hrk\",\"htg\",\"huf\",\"idr\",\"ils\",\"inr\",\"isk\",\"jmd\",\"jpy\",\"kes\",\"kgs\",\"khr\",\"kmf\",\"krw\",\"kyd\",\"kzt\",\"lak\",\"lbp\",\"lkr\",\"lrd\",\"lsl\",\"ltl\",\"mad\",\"mdl\",\"mga\",\"mkd\",\"mnt\",\"mop\",\"mro\",\"mur\",\"mvr\",\"mwk\",\"mxn\",\"myr\",\"mzn\",\"nad\",\"ngn\",\"nio\",\"nok\",\"npr\",\"nzd\",\"pab\",\"pen\",\"pgk\",\"php\",\"pkr\",\"pln\",\"pyg\",\"qar\",\"ron\",\"rsd\",\"rub\",\"rwf\",\"sar\",\"sbd\",\"scr\",\"sek\",\"sgd\",\"shp\",\"sll\",\"sos\",\"srd\",\"std\",\"svc\",\"szl\",\"thb\",\"tjs\",\"top\",\"try\",\"ttd\",\"twd\",\"tzs\",\"uah\",\"ugx\",\"uyu\",\"uzs\",\"vnd\",\"vuv\",\"wst\",\"xaf\",\"xcd\",\"xof\",\"xpf\",\"yer\",\"zar\",\"zmw\"],\"supported_payment_methods\":[\"alipay\",\"card\",\"stripe\"],\"verification_fields\":{\"individual\":{\"minimum\":[\"external_account\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.address.state\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.personal_id_number\",\"legal_entity.ssn_last_4\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.personal_id_number\",\"legal_entity.verification.document\"]},\"company\":{\"minimum\":[\"external_account\",\"legal_entity.address.city\",\"legal_entity.address.line1\",\"legal_entity.address.postal_code\",\"legal_entity.address.state\",\"legal_entity.business_name\",\"legal_entity.business_tax_id\",\"legal_entity.dob.day\",\"legal_entity.dob.month\",\"legal_entity.dob.year\",\"legal_entity.first_name\",\"legal_entity.last_name\",\"legal_entity.ssn_last_4\",\"legal_entity.type\",\"tos_acceptance.date\",\"tos_acceptance.ip\"],\"additional\":[\"legal_entity.personal_id_number\",\"legal_entity.verification.document\"]}}}',1,'2017-05-04 22:11:28',1,0,'US','dwolla',50),(213,'Uruguay',0,NULL,0,0,NULL,0,'2018-01-18 14:54:26',0,0,'UY','epayments',100),(214,'US Virgin Islands',0,'',0,0,NULL,0,'2018-01-18 14:54:25',0,0,'VI','epayments',100),(215,'Uzbekistan',0,NULL,0,0,NULL,0,'2017-05-13 15:42:49',0,0,'UZ','epayments',100),(216,'Vanuatu',0,NULL,0,0,NULL,0,'2017-05-13 15:53:14',0,0,'VU','epayments',100),(217,'Vatican City',0,'',0,0,NULL,0,'2017-05-13 15:53:17',0,0,'VA','epayments',100),(218,'Venezuela',0,NULL,0,0,NULL,0,'2017-05-13 15:42:36',0,0,'VE','epayments',100),(219,'Vietnam',0,NULL,0,0,NULL,0,'2017-05-13 15:42:35',0,0,'VN','epayments',100),(220,'Wallis and Futuna',0,NULL,0,0,NULL,0,'2017-05-13 15:42:33',0,0,'WF','epayments',100),(221,'Yemen',0,NULL,0,0,NULL,0,'2017-05-13 15:42:32',0,0,'YE','epayments',100),(222,'Zambia',0,NULL,0,0,NULL,0,'2017-05-13 15:42:31',0,0,'ZM','epayments',100),(223,'Zimbabwe',0,NULL,0,0,NULL,0,'2017-05-13 15:42:30',0,0,'ZW','epayments',100);
9-- Post-data save --COMMIT;
10START TRANSACTION;
11-- Typecasts --ALTER TABLE "countries" ALTER COLUMN "active" DROP DEFAULT, ALTER COLUMN "active" TYPE boolean USING CAST("active" as boolean);
12ALTER TABLE "countries" ALTER COLUMN "is_stripe_managed" DROP DEFAULT, ALTER COLUMN "is_stripe_managed" TYPE boolean USING CAST("is_stripe_managed" as boolean);
13ALTER TABLE "countries" ALTER COLUMN "has_states" DROP DEFAULT, ALTER COLUMN "has_states" TYPE boolean USING CAST("has_states" as boolean);
14ALTER TABLE "countries" ALTER COLUMN "is_stripe_payout_bank" DROP DEFAULT, ALTER COLUMN "is_stripe_payout_bank" TYPE boolean USING CAST("is_stripe_payout_bank" as boolean);
15ALTER TABLE "countries" ALTER COLUMN "is_stripe_payout_card" DROP DEFAULT, ALTER COLUMN "is_stripe_payout_card" TYPE boolean USING CAST("is_stripe_payout_card" as boolean);
16-- Foreign keys ---- Sequences --CREATE SEQUENCE countries_id_seq;
17SELECT setval('countries_id_seq', max(id)) FROM countries;
18ALTER TABLE "countries" ALTER COLUMN "id" SET DEFAULT nextval('countries_id_seq');
19-- Full Text keys --COMMIT;
20update countries set manual_payout_type='payoneer2';
21update countries set manual_payout_type='payoneer';
22-- Converted by db_converterSTART TRANSACTION;
23SET standard_conforming_strings=off;
24SET escape_string_warning=off;
25SET CONSTRAINTS ALL DEFERRED;
26DROP TABLE IF EXISTS "users_payouts";
27CREATE TABLE "users_payouts" ( "id" integer NOT NULL, "date" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, "last_changed" timestamp NULL DEFAULT NULL, "user_id" integer NOT NULL, "creator" integer NOT NULL, "amount" float NOT NULL, "payoneer_email" varchar(200) DEFAULT NULL, "payoneer_name" varchar(200) DEFAULT NULL, "request_id" integer DEFAULT NULL, PRIMARY KEY ("id"));
28DROP TABLE IF EXISTS users_payouts_requests;
29DROP TYPE IF EXISTS users_payouts_requests_state;
30DROP TYPE IF EXISTS users_payouts_requests_approved_payout_type;
31CREATE TYPE users_payouts_requests_state AS ENUM ('new','approved','rejected','pending');
32CREATE TYPE users_payouts_requests_approved_payout_type AS ENUM ('payoneer','bank','dwolla','paypal','transferwise','epayments');
33CREATE TABLE "users_payouts_requests" ( "id" integer NOT NULL, "date" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, "user_id" integer NOT NULL, "amount" float NOT NULL, "state" users_payouts_requests_state NOT NULL DEFAULT 'new', "reject_reason" text , "accounter" integer DEFAULT NULL, "last_changed" timestamp NULL DEFAULT NULL, "is_payed" int4 NOT NULL DEFAULT '0', "ps" text , "approved_payout_type" users_payouts_requests_approved_payout_type DEFAULT NULL, "approved_payout_data" text , PRIMARY KEY ("id"));
34DROP TABLE IF EXISTS users_payouts_data;
35CREATE TABLE "users_payouts_data" ( "id" integer NOT NULL, "user_id" integer NOT NULL, "last_changed" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, "bank" text , "payoneer" text , "dwolla" text , "epayments" text , "transferwise" text , "paypal" text , PRIMARY KEY ("id"), UNIQUE ("user_id"));
36-- Post-data save --COMMIT;
37START TRANSACTION;
38-- Typecasts --ALTER TABLE "users_payouts_requests" ALTER COLUMN "is_payed" DROP DEFAULT, ALTER COLUMN "is_payed" TYPE boolean USING CAST("is_payed" as boolean);
39-- Foreign keys ---- Sequences --DROP SEQUENCE IF EXISTS users_payouts_id_seq;
40DROP SEQUENCE IF EXISTS users_payouts_requests_id_seq;
41DROP SEQUENCE IF EXISTS users_payouts_data_id_seq;
42CREATE SEQUENCE users_payouts_id_seq;
43SELECT setval('users_payouts_id_seq', max(id)) FROM users_payouts;
44ALTER TABLE "users_payouts" ALTER COLUMN "id" SET DEFAULT nextval('users_payouts_id_seq');
45CREATE SEQUENCE users_payouts_requests_id_seq;
46SELECT setval('users_payouts_requests_id_seq', max(id)) FROM users_payouts_requests;
47ALTER TABLE "users_payouts_requests" ALTER COLUMN "id" SET DEFAULT nextval('users_payouts_requests_id_seq');
48CREATE SEQUENCE users_payouts_data_id_seq;
49SELECT setval('users_payouts_data_id_seq', max(id)) FROM users_payouts_data;
50ALTER TABLE "users_payouts_data" ALTER COLUMN "id" SET DEFAULT nextval('users_payouts_data_id_seq');
51-- Full Text keys --COMMIT;