
---------------------------------------------------------------------------------------------------------------------------------------------------------------

-- registry categories CLI, SUP;

INSERT INTO public.code_list_registry_categories (code,description,ord,icon,misc,properties) VALUES
	 ('CLI','Clients',NULL,NULL,NULL,NULL),
	 ('SUP','Suppliers',NULL,NULL,NULL,NULL);

	 -- code_list;

---------------------------------------------------------------------------------------------------------------------------------------------------------------


-- registry_entities as needed


--------------------------------------------------------------------------------------------------------------------------------------------------------------

-- registry forms LEG, PER;

INSERT INTO public.code_list_registry_forms (code,description,ord,icon,misc,properties) VALUES
	 ('LEG','Legal',NULL,NULL,NULL,NULL),
	 ('PER','Person',NULL,NULL,NULL,NULL);

---------------------------------------------------------------------------------------------------------------------------------------------------------------

-- 13 Registry permissions

INSERT INTO public.core_permissions (code,permission_name,parent,permission_function,default_child,permission_namespace,"module",permission_description,permission_type,icon,ord,hidden,guest,meta) VALUES
	 ('PREGLST','registry_list','MREG','getObjects','','registry/list','registry','Access page registry list','PAG','fas fa-list',1,false,false,NULL),
	 ('SREGLE','registry_list_edit','PREGLST',NULL,NULL,'registry/list','registry','Section edit registry list','SEC',NULL,1,false,false,NULL),
	 ('SREGLW','registry_list_view','PREGLST',NULL,NULL,'registry/list','registry','Section view registry list','SEC',NULL,1,false,false,NULL),
	 ('BREGADD','registry_list_view_add','SREGLW',NULL,NULL,'registry/list','registry','Add entity button','BUT','fas fa-plus',1,false,false,NULL),
	 ('BREGBAC','registry_list_edit_back','SREGLE',NULL,NULL,'registry/list','registry','Back registry list button','BUT','fas fa-arrow-left',1,false,false,NULL),
	 ('XREGUPD','registry_list_update','SREGLE','updRegistryEntries',NULL,'registry/list','registry','Update registry entity','EXE',NULL,1,false,false,NULL),
	 ('MREG','registry',NULL,'','','registry','registry','Access module registry','MOD','fas fa-address-book',800,false,false,NULL),
	 ('BREGEDT','registry_list_view_edit','SREGLW','','','registry/list','registry','Edit entity button','BUT','fas fa-edit',1,false,false,NULL),
	 ('XREGLST','registry_list_get','SREGLW','getRegistryEntries',NULL,'registry/list','registry','Get registry entities','EXE',NULL,1,false,false,NULL),
	 ('BREGSAV','registry_list_edit_save','SREGLE',NULL,NULL,'registry/list','registry','Save entity button','BUT','fas fa-save',1,false,false,NULL);
INSERT INTO public.core_permissions (code,permission_name,parent,permission_function,default_child,permission_namespace,"module",permission_description,permission_type,icon,ord,hidden,guest,meta) VALUES
	 ('BREGDEL','registry_list_view_del','SREGLW','','','registry/list','registry','Delete entity button','BUT','fas fa-trash',1,false,false,NULL),
	 ('XREGSRC','registry_entity_search','SREGLE','searchRegistryEntries',NULL,'registry/list','registry','Search registry entity','EXE',NULL,1,false,false,NULL),
	 ('XREGADD','registry_list_add','SREGLE','addRegistryEntries',NULL,'registry/list','registry','Add registry entity','EXE',NULL,1,false,false,NULL),
	 ('XREGDEL','registry_list_delete','SREGLE','delRegistryEntries',NULL,'registry/list','registry','Delete registry entity','EXE',NULL,1,false,false,NULL);
	 INSERT INTO public.core_permissions (code,permission_name,parent,permission_function,default_child,permission_namespace,"module",permission_description,permission_type,icon,ord,hidden,guest,meta) VALUES
	 ('SRBKEND','registry_backend','PREGLST','','','registry/list','registry','Permission to access registry backend only','SEC','',1,false,false,NULL),
	 ('XRDBTRS','registry_database_transfer','SRBKEND','dbRegistryTransfer','','registry/list','registry','Permission to user dbRegistryTransfer backend function','EXE','',1,false,false,NULL);


INSERT INTO public.core_user_roles (id, role_name,hidden) VALUES
	(15, 'Registry',0); 

INSERT INTO public.core_user_role_has_permission (role_id,permission_code) VALUES
	 (15,'PREGLST'),
	 (15,'SREGLE'),
	 (15,'SREGLW'),
	 (15,'BREGADD'),
	 (15,'BREGBAC'),
	 (15,'XREGUPD'),
	 (15,'MREG');
INSERT INTO public.core_user_role_has_permission (role_id,permission_code) VALUES
	 (15,'BREGEDT'),
	 (15,'XREGLST'),
	 (15,'BREGSAV'),
	 (15,'BREGDEL'),
     (15,'XREGSRC'),
	 (15,'XREGADD'),
	 (15,'XREGDEL');
---------------------------------------------------------------------------------------------------------------------------------------------------------------

-- Registry_list_form

INSERT INTO public.core_assets (asset_type,asset_name,description,custom,asset_innerhtml,asset_parameters,asset_code,before_trigger,after_trigger,failure_rollback,exec_order,meta) VALUES
	 ('form','registry_list_form','Form to edit entities in registry list',false,'<form id="registry_list_form">
     <div class="row">
        <div class="form-group col-md-6">
            <label for="entity_name">{registry_entity_name}</label>
            <input type="text" class="form-control" id="entity_name" name="main[entity_name]" required>
            <input type="hidden" class="form-control" id="id" name="id" required>
        </div>	
        <div class="form-group col-md-2">
            <label for="entity_category">{registry_entity_category}</label>
	    	<select class="form-control" id="entity_category" name="main[entity_category]" data-list="/api/v1/misc/codelists/registry_categories">
	    </select>
        </div>	
        <div class="form-group col-md-2">
            <label for="entity_test">test</label>
            <input type="text" class="form-control" id="entity_test" name="meta[entity_test]" required>
        </div>	
    </div>
     <div class="row">
        <div class="form-group col-md-12">
            <label for="entity_config">Config</label>
            <textarea class="form-control" id="entity_config" name="meta[entity_config]"></textarea>
        </div>	
    </div>
</form>',NULL,NULL,NULL,NULL,NULL,NULL,NULL);


---------------------------------------------------------------------------------------------------------------------------------------------------------------


-- 246 country entries;

INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('AD','Andorra',NULL,NULL,NULL,NULL),
	 ('AE','United Arab Emirates',NULL,NULL,NULL,NULL),
	 ('AF','Afghanistan',NULL,NULL,NULL,NULL),
	 ('AG','Antigua and Barbuda',NULL,NULL,NULL,NULL),
	 ('AI','Anguilla',NULL,NULL,NULL,NULL),
	 ('AL','Albania',NULL,NULL,NULL,NULL),
	 ('AM','Armenia',NULL,NULL,NULL,NULL),
	 ('AN','Netherlands Antilles',NULL,NULL,NULL,NULL),
	 ('AO','Angola',NULL,NULL,NULL,NULL),
	 ('AQ','Antarctica',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('AR','Argentina',NULL,NULL,NULL,NULL),
	 ('AS','American Samoa',NULL,NULL,NULL,NULL),
	 ('AT','Austria',NULL,NULL,NULL,NULL),
	 ('AU','Australia',NULL,NULL,NULL,NULL),
	 ('AW','Aruba',NULL,NULL,NULL,NULL),
	 ('AX','Åland Islands',NULL,NULL,NULL,NULL),
	 ('AZ','Azerbaijan',NULL,NULL,NULL,NULL),
	 ('BA','Bosnia and Herzegovina',NULL,NULL,NULL,NULL),
	 ('BB','Barbados',NULL,NULL,NULL,NULL),
	 ('BD','Bangladesh',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('BE','Belgium',NULL,NULL,NULL,NULL),
	 ('BF','Burkina Faso',NULL,NULL,NULL,NULL),
	 ('BG','Bulgaria',NULL,NULL,NULL,NULL),
	 ('BH','Bahrain',NULL,NULL,NULL,NULL),
	 ('BI','Burundi',NULL,NULL,NULL,NULL),
	 ('BJ','Benin',NULL,NULL,NULL,NULL),
	 ('BM','Bermuda',NULL,NULL,NULL,NULL),
	 ('BN','Brunei Darussalam',NULL,NULL,NULL,NULL),
	 ('BO','Bolivia',NULL,NULL,NULL,NULL),
	 ('BR','Brazil',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('BS','Bahamas',NULL,NULL,NULL,NULL),
	 ('BT','Bhutan',NULL,NULL,NULL,NULL),
	 ('BV','Bouvet Island',NULL,NULL,NULL,NULL),
	 ('BW','Botswana',NULL,NULL,NULL,NULL),
	 ('BY','Belarus',NULL,NULL,NULL,NULL),
	 ('BZ','Belize',NULL,NULL,NULL,NULL),
	 ('CA','Canada',NULL,NULL,NULL,NULL),
	 ('CC','Cocos (Keeling) Islands',NULL,NULL,NULL,NULL),
	 ('CD','Congo, The Democratic Republic of the',NULL,NULL,NULL,NULL),
	 ('CF','Central African Republic',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('CG','Congo',NULL,NULL,NULL,NULL),
	 ('CH','Switzerland',NULL,NULL,NULL,NULL),
	 ('CI','Côte d''Ivoire',NULL,NULL,NULL,NULL),
	 ('CK','Cook Islands',NULL,NULL,NULL,NULL),
	 ('CL','Chile',NULL,NULL,NULL,NULL),
	 ('CM','Cameroon',NULL,NULL,NULL,NULL),
	 ('CN','China',NULL,NULL,NULL,NULL),
	 ('CO','Colombia',NULL,NULL,NULL,NULL),
	 ('CR','Costa Rica',NULL,NULL,NULL,NULL),
	 ('CS','Serbia and Montenegro',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('CU','Cuba',NULL,NULL,NULL,NULL),
	 ('CV','Cape Verde',NULL,NULL,NULL,NULL),
	 ('CX','Christmas Island',NULL,NULL,NULL,NULL),
	 ('CY','Cyprus',NULL,NULL,NULL,NULL),
	 ('CZ','Czech Republic',NULL,NULL,NULL,NULL),
	 ('DE','Germany',NULL,NULL,NULL,NULL),
	 ('DJ','Djibouti',NULL,NULL,NULL,NULL),
	 ('DK','Denmark',NULL,NULL,NULL,NULL),
	 ('DM','Dominica',NULL,NULL,NULL,NULL),
	 ('DO','Dominican Republic',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('DZ','Algeria',NULL,NULL,NULL,NULL),
	 ('EC','Ecuador',NULL,NULL,NULL,NULL),
	 ('EE','Estonia',NULL,NULL,NULL,NULL),
	 ('EG','Egypt',NULL,NULL,NULL,NULL),
	 ('EH','Western Sahara',NULL,NULL,NULL,NULL),
	 ('ER','Eritrea',NULL,NULL,NULL,NULL),
	 ('ES','Spain',NULL,NULL,NULL,NULL),
	 ('ET','Ethiopia',NULL,NULL,NULL,NULL),
	 ('FI','Finland',NULL,NULL,NULL,NULL),
	 ('FJ','Fiji',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('FK','Falkland Islands (Malvinas)',NULL,NULL,NULL,NULL),
	 ('FM','Micronesia, Federated States of',NULL,NULL,NULL,NULL),
	 ('FO','Faroe Islands',NULL,NULL,NULL,NULL),
	 ('FR','France',NULL,NULL,NULL,NULL),
	 ('GA','Gabon',NULL,NULL,NULL,NULL),
	 ('GB','United Kingdom',NULL,NULL,NULL,NULL),
	 ('GD','Grenada',NULL,NULL,NULL,NULL),
	 ('GE','Georgia',NULL,NULL,NULL,NULL),
	 ('GF','French Guiana',NULL,NULL,NULL,NULL),
	 ('GG','Guernsey',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('GH','Ghana',NULL,NULL,NULL,NULL),
	 ('GI','Gibraltar',NULL,NULL,NULL,NULL),
	 ('GL','Greenland',NULL,NULL,NULL,NULL),
	 ('GM','Gambia',NULL,NULL,NULL,NULL),
	 ('GN','Guinea',NULL,NULL,NULL,NULL),
	 ('GP','Guadeloupe',NULL,NULL,NULL,NULL),
	 ('GQ','Equatorial Guinea',NULL,NULL,NULL,NULL),
	 ('GR','Greece',NULL,NULL,NULL,NULL),
	 ('GS','South Georgia and the South Sandwich Islands',NULL,NULL,NULL,NULL),
	 ('GT','Guatemala',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('GU','Guam',NULL,NULL,NULL,NULL),
	 ('GW','Guinea-Bissau',NULL,NULL,NULL,NULL),
	 ('GY','Guyana',NULL,NULL,NULL,NULL),
	 ('HK','Hong Kong',NULL,NULL,NULL,NULL),
	 ('HM','Heard Island and McDonald Islands',NULL,NULL,NULL,NULL),
	 ('HN','Honduras',NULL,NULL,NULL,NULL),
	 ('HR','Croatia',NULL,NULL,NULL,NULL),
	 ('HT','Haiti',NULL,NULL,NULL,NULL),
	 ('HU','Hungary',NULL,NULL,NULL,NULL),
	 ('ID','Indonesia',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('IE','Ireland',NULL,NULL,NULL,NULL),
	 ('IL','Israel',NULL,NULL,NULL,NULL),
	 ('IM','Isle of Man',NULL,NULL,NULL,NULL),
	 ('IN','India',NULL,NULL,NULL,NULL),
	 ('IO','British Indian Ocean Territory',NULL,NULL,NULL,NULL),
	 ('IQ','Iraq',NULL,NULL,NULL,NULL),
	 ('IR','Iran, Islamic Republic of',NULL,NULL,NULL,NULL),
	 ('IS','Iceland',NULL,NULL,NULL,NULL),
	 ('IT','Italy',NULL,NULL,NULL,NULL),
	 ('JE','Jersey',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('JM','Jamaica',NULL,NULL,NULL,NULL),
	 ('JO','Jordan',NULL,NULL,NULL,NULL),
	 ('JP','Japan',NULL,NULL,NULL,NULL),
	 ('KE','Kenya',NULL,NULL,NULL,NULL),
	 ('KG','Kyrgyzstan',NULL,NULL,NULL,NULL),
	 ('KH','Cambodia',NULL,NULL,NULL,NULL),
	 ('KI','Kiribati',NULL,NULL,NULL,NULL),
	 ('KM','Comoros',NULL,NULL,NULL,NULL),
	 ('KN','Saint Kitts and Nevis',NULL,NULL,NULL,NULL),
	 ('KP','Korea, Democratic People''s Republic of',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('KR','Korea, Republic of',NULL,NULL,NULL,NULL),
	 ('KW','Kuwait',NULL,NULL,NULL,NULL),
	 ('KY','Cayman Islands',NULL,NULL,NULL,NULL),
	 ('KZ','Kazakhstan',NULL,NULL,NULL,NULL),
	 ('LA','Lao People''s Democratic Republic',NULL,NULL,NULL,NULL),
	 ('LB','Lebanon',NULL,NULL,NULL,NULL),
	 ('LC','Saint Lucia',NULL,NULL,NULL,NULL),
	 ('LI','Liechtenstein',NULL,NULL,NULL,NULL),
	 ('LK','Sri Lanka',NULL,NULL,NULL,NULL),
	 ('LR','Liberia',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('LS','Lesotho',NULL,NULL,NULL,NULL),
	 ('LT','Lithuania',NULL,NULL,NULL,NULL),
	 ('LU','Luxembourg',NULL,NULL,NULL,NULL),
	 ('LV','Latvia',NULL,NULL,NULL,NULL),
	 ('LY','Libyan Arab Jamahiriya',NULL,NULL,NULL,NULL),
	 ('MA','Morocco',NULL,NULL,NULL,NULL),
	 ('MC','Monaco',NULL,NULL,NULL,NULL),
	 ('MD','Moldova',NULL,NULL,NULL,NULL),
	 ('ME','Montenegro',NULL,NULL,NULL,NULL),
	 ('MG','Madagascar',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('MH','Marshall Islands',NULL,NULL,NULL,NULL),
	 ('MK','Macedonia, Republic of',NULL,NULL,NULL,NULL),
	 ('ML','Mali',NULL,NULL,NULL,NULL),
	 ('MM','Myanmar',NULL,NULL,NULL,NULL),
	 ('MN','Mongolia',NULL,NULL,NULL,NULL),
	 ('MO','Macao',NULL,NULL,NULL,NULL),
	 ('MP','Northern Mariana Islands',NULL,NULL,NULL,NULL),
	 ('MQ','Martinique',NULL,NULL,NULL,NULL),
	 ('MR','Mauritania',NULL,NULL,NULL,NULL),
	 ('MS','Montserrat',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('MT','Malta',NULL,NULL,NULL,NULL),
	 ('MU','Mauritius',NULL,NULL,NULL,NULL),
	 ('MV','Maldives',NULL,NULL,NULL,NULL),
	 ('MW','Malawi',NULL,NULL,NULL,NULL),
	 ('MX','Mexico',NULL,NULL,NULL,NULL),
	 ('MY','Malaysia',NULL,NULL,NULL,NULL),
	 ('MZ','Mozambique',NULL,NULL,NULL,NULL),
	 ('NA','Namibia',NULL,NULL,NULL,NULL),
	 ('NC','New Caledonia',NULL,NULL,NULL,NULL),
	 ('NE','Niger',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('NF','Norfolk Island',NULL,NULL,NULL,NULL),
	 ('NG','Nigeria',NULL,NULL,NULL,NULL),
	 ('NI','Nicaragua',NULL,NULL,NULL,NULL),
	 ('NL','Netherlands',NULL,NULL,NULL,NULL),
	 ('NO','Norway',NULL,NULL,NULL,NULL),
	 ('NP','Nepal',NULL,NULL,NULL,NULL),
	 ('NR','Nauru',NULL,NULL,NULL,NULL),
	 ('NU','Niue',NULL,NULL,NULL,NULL),
	 ('NZ','New Zealand',NULL,NULL,NULL,NULL),
	 ('OM','Oman',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('PA','Panama',NULL,NULL,NULL,NULL),
	 ('PE','Peru',NULL,NULL,NULL,NULL),
	 ('PF','French Polynesia',NULL,NULL,NULL,NULL),
	 ('PG','Papua New Guinea',NULL,NULL,NULL,NULL),
	 ('PH','Philippines',NULL,NULL,NULL,NULL),
	 ('PK','Pakistan',NULL,NULL,NULL,NULL),
	 ('PL','Poland',NULL,NULL,NULL,NULL),
	 ('PM','Saint Pierre and Miquelon',NULL,NULL,NULL,NULL),
	 ('PN','Pitcairn',NULL,NULL,NULL,NULL),
	 ('PR','Puerto Rico',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('PS','Palestinian Territory, Occupied',NULL,NULL,NULL,NULL),
	 ('PT','Portugal',NULL,NULL,NULL,NULL),
	 ('PW','Palau',NULL,NULL,NULL,NULL),
	 ('PY','Paraguay',NULL,NULL,NULL,NULL),
	 ('QA','Qatar',NULL,NULL,NULL,NULL),
	 ('RE','Reunion',NULL,NULL,NULL,NULL),
	 ('RO','Romania',NULL,NULL,NULL,NULL),
	 ('RS','Serbia',NULL,NULL,NULL,NULL),
	 ('RU','Russian Federation',NULL,NULL,NULL,NULL),
	 ('RW','Rwanda',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('SA','Saudi Arabia',NULL,NULL,NULL,NULL),
	 ('SB','Solomon Islands',NULL,NULL,NULL,NULL),
	 ('SC','Seychelles',NULL,NULL,NULL,NULL),
	 ('SD','Sudan',NULL,NULL,NULL,NULL),
	 ('SE','Sweden',NULL,NULL,NULL,NULL),
	 ('SG','Singapore',NULL,NULL,NULL,NULL),
	 ('SH','Saint Helena',NULL,NULL,NULL,NULL),
	 ('SI','Slovenia',NULL,NULL,NULL,NULL),
	 ('SJ','Svalbard and Jan Mayen',NULL,NULL,NULL,NULL),
	 ('SK','Slovakia',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('SL','Sierra Leone',NULL,NULL,NULL,NULL),
	 ('SM','San Marino',NULL,NULL,NULL,NULL),
	 ('SN','Senegal',NULL,NULL,NULL,NULL),
	 ('SO','Somalia',NULL,NULL,NULL,NULL),
	 ('SR','Suriname',NULL,NULL,NULL,NULL),
	 ('ST','Sao Tome and Principe',NULL,NULL,NULL,NULL),
	 ('SV','El Salvador',NULL,NULL,NULL,NULL),
	 ('SY','Syrian Arab Republic',NULL,NULL,NULL,NULL),
	 ('SZ','Swaziland',NULL,NULL,NULL,NULL),
	 ('TC','Turks and Caicos Islands',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('TD','Chad',NULL,NULL,NULL,NULL),
	 ('TF','French Southern Territories',NULL,NULL,NULL,NULL),
	 ('TG','Togo',NULL,NULL,NULL,NULL),
	 ('TH','Thailand',NULL,NULL,NULL,NULL),
	 ('TJ','Tajikistan',NULL,NULL,NULL,NULL),
	 ('TK','Tokelau',NULL,NULL,NULL,NULL),
	 ('TL','Timor-Leste',NULL,NULL,NULL,NULL),
	 ('TM','Turkmenistan',NULL,NULL,NULL,NULL),
	 ('TN','Tunisia',NULL,NULL,NULL,NULL),
	 ('TO','Tonga',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('TR','Turkey',NULL,NULL,NULL,NULL),
	 ('TT','Trinidad and Tobago',NULL,NULL,NULL,NULL),
	 ('TV','Tuvalu',NULL,NULL,NULL,NULL),
	 ('TW','Taiwan',NULL,NULL,NULL,NULL),
	 ('TZ','Tanzania, United Republic of',NULL,NULL,NULL,NULL),
	 ('UA','Ukraine',NULL,NULL,NULL,NULL),
	 ('UG','Uganda',NULL,NULL,NULL,NULL),
	 ('UM','United States Minor Outlying Islands',NULL,NULL,NULL,NULL),
	 ('US','United States',NULL,NULL,NULL,NULL),
	 ('UY','Uruguay',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('UZ','Uzbekistan',NULL,NULL,NULL,NULL),
	 ('VA','Holy See (Vatican City State)',NULL,NULL,NULL,NULL),
	 ('VC','Saint Vincent and the Grenadines',NULL,NULL,NULL,NULL),
	 ('VE','Venezuela',NULL,NULL,NULL,NULL),
	 ('VG','Virgin Islands, British',NULL,NULL,NULL,NULL),
	 ('VI','Virgin Islands, U.S.',NULL,NULL,NULL,NULL),
	 ('VN','Viet Nam',NULL,NULL,NULL,NULL),
	 ('VU','Vanuatu',NULL,NULL,NULL,NULL),
	 ('WF','Wallis and Futuna',NULL,NULL,NULL,NULL),
	 ('WS','Samoa',NULL,NULL,NULL,NULL);
INSERT INTO public.code_list_countries (code,description,ord,icon,misc,properties) VALUES
	 ('XX','Unknown',NULL,NULL,NULL,NULL),
	 ('YE','Yemen',NULL,NULL,NULL,NULL),
	 ('YT','Mayotte',NULL,NULL,NULL,NULL),
	 ('ZA','South Africa',NULL,NULL,NULL,NULL),
	 ('ZM','Zambia',NULL,NULL,NULL,NULL),
	 ('ZW','Zimbabwe',NULL,NULL,NULL,NULL);




---------------------------------------------------------------------------------------------------------------------------------------------------------------

-- 3711 states entries;

INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('AJ','AE','''Ajman',NULL),
	 ('AZ','AE','Abu Zaby',NULL),
	 ('DU','AE','Dubayy',NULL),
	 ('FU','AE','Al Fujayrah',NULL),
	 ('RK','AE','Ra''s al Khaymah',NULL),
	 ('SH','AE','Ash Shariqah',NULL),
	 ('UQ','AE','Umm al Qaywayn',NULL),
	 ('BAL','AF','Balkh',NULL),
	 ('BAM','AF','Bamian',NULL),
	 ('BDG','AF','Badghis',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('BDS','AF','Badakhshan',NULL),
	 ('BGL','AF','Baghlan',NULL),
	 ('FRA','AF','Farah',NULL),
	 ('FYB','AF','Faryab',NULL),
	 ('GHA','AF','Ghazni',NULL),
	 ('GHO','AF','Ghowr',NULL),
	 ('HEL','AF','Helmand',NULL),
	 ('HER','AF','Herat',NULL),
	 ('JOW','AF','Jowzjan',NULL),
	 ('KAB','AF','Kabul',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('KAN','AF','Kandahar',NULL),
	 ('KAP','AF','Kapisa',NULL),
	 ('KDZ','AF','Kondoz',NULL),
	 ('KHO','AF','Khowst',NULL),
	 ('KNR','AF','Konar',NULL),
	 ('LAG','AF','Laghman',NULL),
	 ('LOW','AF','Lowgar',NULL),
	 ('NAN','AF','Nangrahar',NULL),
	 ('NIM','AF','Nimruz',NULL),
	 ('NUR','AF','Nurestan',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('ORU','AF','Oruzgan',NULL),
	 ('PAR','AF','Parwan',NULL),
	 ('PIA','AF','Paktia',NULL),
	 ('PKA','AF','Paktika',NULL),
	 ('SAM','AF','Samangan',NULL),
	 ('SAR','AF','Sar-e Pol',NULL),
	 ('TAK','AF','Takhar',NULL),
	 ('WAR','AF','Wardak',NULL),
	 ('ZAB','AF','Zabol',NULL),
	 ('BR','AL','Berat',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('BU','AL','Bulqizë',NULL),
	 ('DI','AL','Dibër',NULL),
	 ('DL','AL','Delvinë',NULL),
	 ('DR','AL','Durrsës',NULL),
	 ('DV','AL','Devoll',NULL),
	 ('EL','AL','Elbasan',NULL),
	 ('ER','AL','Kolonjë',NULL),
	 ('FR','AL','Fier',NULL),
	 ('GJ','AL','Gjirokastër',NULL),
	 ('GR','AL','Gramsh',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('HA','AL','Has',NULL),
	 ('KA','AL','Kavajë',NULL),
	 ('KB','AL','Kurbin',NULL),
	 ('KC','AL','Kuçovë',NULL),
	 ('KO','AL','Korcë',NULL),
	 ('KR','AL','Krujë',NULL),
	 ('KU','AL','Kukës',NULL),
	 ('LB','AL','Librazhd',NULL),
	 ('LE','AL','Lezhë',NULL),
	 ('LU','AL','Lushnjë',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('MK','AL','Mallakastër',NULL),
	 ('MM','AL','Malësi e Madhe',NULL),
	 ('MR','AL','Mirditë',NULL),
	 ('MT','AL','Mat',NULL),
	 ('PG','AL','Pogradec',NULL),
	 ('PQ','AL','Peqin',NULL),
	 ('PR','AL','Përmet',NULL),
	 ('PU','AL','Pukë',NULL),
	 ('SH','AL','Shkodër',NULL),
	 ('SK','AL','Skrapar',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('SR','AL','Sarandë',NULL),
	 ('TE','AL','Tepelenë',NULL),
	 ('TP','AL','Tropojë',NULL),
	 ('TR','AL','Tiranë',NULL),
	 ('VL','AL','Vlorë',NULL),
	 ('AG','AM','Aragacotn',NULL),
	 ('AR','AM','Ararat',NULL),
	 ('AV','AM','Armavir',NULL),
	 ('ER','AM','Erevan',NULL),
	 ('GR','AM','Gegarkunik''',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('KT','AM','Kotayk''',NULL),
	 ('LO','AM','Lory',NULL),
	 ('SH','AM','Sirak',NULL),
	 ('SU','AM','Syunik''',NULL),
	 ('TV','AM','Tavus',NULL),
	 ('VD','AM','Vayoc Jor',NULL),
	 ('BON','AN','Bonaire',NULL),
	 ('CUR','AN','Curaçao',NULL),
	 ('EUA','AN','St. Eustatius',NULL),
	 ('SAB','AN','Saba',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('SXM','AN','St. Maarten',NULL),
	 ('BGO','AO','Bengo',NULL),
	 ('BGU','AO','Benguela',NULL),
	 ('BIE','AO','Bie',NULL),
	 ('CAB','AO','Cabinda',NULL),
	 ('CCU','AO','Cuando-Cubango',NULL),
	 ('CNN','AO','Cunene',NULL),
	 ('CNO','AO','Cuanza Norte',NULL),
	 ('CUS','AO','Cuanza Sul',NULL),
	 ('HUA','AO','Huambo',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('HUI','AO','Huila',NULL),
	 ('LNO','AO','Lunda Norte',NULL),
	 ('LSU','AO','Lunda Sul',NULL),
	 ('LUA','AO','Luanda',NULL),
	 ('MAL','AO','Malange',NULL),
	 ('MOX','AO','Moxico',NULL),
	 ('NAM','AO','Namibe',NULL),
	 ('UIG','AO','Uige',NULL),
	 ('ZAI','AO','Zaire',NULL),
	 ('AAT','AQ','Australian Antarctic Territory',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('A','AR','Salta',NULL),
	 ('B','AR','Buenos Aires',NULL),
	 ('C','AR','Capital federal',NULL),
	 ('D','AR','San Luis',NULL),
	 ('E','AR','Entre Rios',NULL),
	 ('G','AR','Santiago del Estero',NULL),
	 ('H','AR','Chaco',NULL),
	 ('J','AR','San Juan',NULL),
	 ('K','AR','Catamarca',NULL),
	 ('L','AR','La Pampa',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('M','AR','Mendoza',NULL),
	 ('N','AR','Misiones',NULL),
	 ('P','AR','Formosa',NULL),
	 ('Q','AR','Neuquen',NULL),
	 ('R','AR','Rio Negro',NULL),
	 ('S','AR','Santa Fe',NULL),
	 ('T','AR','Tucuman',NULL),
	 ('U','AR','Chubut',NULL),
	 ('V','AR','Tierra del Fuego',NULL),
	 ('W','AR','Corrientes',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('X','AR','Cordoba',NULL),
	 ('Y','AR','Jujuy',NULL),
	 ('Z','AR','Santa Cruz',NULL),
	 ('1','AT','Burgenland',NULL),
	 ('2','AT','Kärnten',NULL),
	 ('3','AT','Niederosterreich',NULL),
	 ('4','AT','Oberosterreich',NULL),
	 ('5','AT','Salzburg',NULL),
	 ('6','AT','Steiermark',NULL),
	 ('7','AT','Tirol',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('8','AT','Vorarlberg',NULL),
	 ('9','AT','Wien',NULL),
	 ('ACT','AU','Australian Capital Territory',NULL),
	 ('NSW','AU','New South Wales',NULL),
	 ('NT','AU','Northern Territory',NULL),
	 ('QLD','AU','Queensland',NULL),
	 ('SA','AU','South Australia',NULL),
	 ('TAS','AU','Tasmania',NULL),
	 ('VIC','AU','Victoria',NULL),
	 ('WA','AU','Western Australia',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('AB','AZ','Ali Bayramli',NULL),
	 ('ABS','AZ','Abseron',NULL),
	 ('AGA','AZ','Agstafa',NULL),
	 ('AGC','AZ','Agcabadi',NULL),
	 ('AGM','AZ','Agdam',NULL),
	 ('AGS','AZ','Agdas',NULL),
	 ('AGU','AZ','Agsu',NULL),
	 ('AST','AZ','Astara',NULL),
	 ('BA','AZ','Baki',NULL),
	 ('BAB','AZ','Babak',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('BAL','AZ','Balakan',NULL),
	 ('BAR','AZ','Barda',NULL),
	 ('BEY','AZ','Beylagan',NULL),
	 ('BIL','AZ','Bilasuvar',NULL),
	 ('CAB','AZ','Cabrayll',NULL),
	 ('CAL','AZ','Calilabad',NULL),
	 ('CUL','AZ','Culfa',NULL),
	 ('DAS','AZ','Daskasan',NULL),
	 ('DAV','AZ','Davaci',NULL),
	 ('FUZ','AZ','Fuzuli',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('GA','AZ','Ganca',NULL),
	 ('GAD','AZ','Gadabay',NULL),
	 ('GOR','AZ','Goranboy',NULL),
	 ('GOY','AZ','Goycay',NULL),
	 ('HAC','AZ','Haciqabul',NULL),
	 ('IMI','AZ','Imisli',NULL),
	 ('ISM','AZ','Ismayilli',NULL),
	 ('KAL','AZ','Kalbacar',NULL),
	 ('KUR','AZ','Kurdamir',NULL),
	 ('LA','AZ','Lankaran',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('LAC','AZ','Lacin',NULL),
	 ('LER','AZ','Lerik',NULL),
	 ('MAS','AZ','Masalli',NULL),
	 ('MI','AZ','Mingacevir',NULL),
	 ('NA','AZ','Naftalan',NULL),
	 ('NEF','AZ','Neftcala',NULL),
	 ('NX','AZ','Naxcivan',NULL),
	 ('OGU','AZ','Oguz',NULL),
	 ('ORD','AZ','Ordubad',NULL),
	 ('QAB','AZ','Qabala',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('QAX','AZ','Qax',NULL),
	 ('QAZ','AZ','Qazax',NULL),
	 ('QBA','AZ','Quba',NULL),
	 ('QBI','AZ','Qubadli',NULL),
	 ('QOB','AZ','Qobustan',NULL),
	 ('QUS','AZ','Qusar',NULL),
	 ('SA','AZ','Saki',NULL),
	 ('SAB','AZ','Sabirabad',NULL),
	 ('SAD','AZ','Sadarak',NULL),
	 ('SAH','AZ','Sahbuz',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('SAL','AZ','Salyan',NULL),
	 ('SAR','AZ','Sarur',NULL),
	 ('SAT','AZ','Saatli',NULL),
	 ('SIY','AZ','Siyazan',NULL),
	 ('SKR','AZ','Samkir',NULL),
	 ('SM','AZ','Sumqayit',NULL),
	 ('SMI','AZ','Samaxi',NULL),
	 ('SMX','AZ','Samux',NULL),
	 ('SS','AZ','Susa',NULL),
	 ('TAR','AZ','Tartar',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('TOV','AZ','Tovuz',NULL),
	 ('UCA','AZ','Ucar',NULL),
	 ('XA','AZ','Xankandi',NULL),
	 ('XAC','AZ','Xacmaz',NULL),
	 ('XAN','AZ','Xanlar',NULL),
	 ('XCI','AZ','Xocali',NULL),
	 ('XIZ','AZ','Xizi',NULL),
	 ('XVD','AZ','Xocavand',NULL),
	 ('YAR','AZ','Yardimli',NULL),
	 ('YE','AZ','Yevlax',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('ZAN','AZ','Zangilan',NULL),
	 ('ZAQ','AZ','Zaqatala',NULL),
	 ('ZAR','AZ','Zardab',NULL),
	 ('BIH','BA','Federacija Bosna i Hercegovina',NULL),
	 ('SRP','BA','Republika Srpska',NULL),
	 ('1','BD','Bandarban zila',NULL),
	 ('10','BD','Chittagong zila',NULL),
	 ('11','BD','Cox''s Bazar zila',NULL),
	 ('12','BD','Chuadanga zila',NULL),
	 ('13','BD','Dhaka zila',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('14','BD','Dinajpur zila',NULL),
	 ('15','BD','Faridpur zila',NULL),
	 ('16','BD','Feni zila',NULL),
	 ('17','BD','Gopalganj zila',NULL),
	 ('18','BD','Gazipur zila',NULL),
	 ('19','BD','Gaibandha zila',NULL),
	 ('2','BD','Barguna zila',NULL),
	 ('20','BD','Habiganj zila',NULL),
	 ('21','BD','Jamalpur zila',NULL),
	 ('22','BD','Jessore zila',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('23','BD','Jhenaidah zila',NULL),
	 ('24','BD','Jaipurhat zila',NULL),
	 ('25','BD','Jhalakati zila',NULL),
	 ('26','BD','Kishorganj zila',NULL),
	 ('27','BD','Khulna zila',NULL),
	 ('28','BD','Kurigram zila',NULL),
	 ('29','BD','Khagrachari zila',NULL),
	 ('3','BD','Bogra zila',NULL),
	 ('30','BD','Kushtia zila',NULL),
	 ('31','BD','Lakshmipur zila',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('32','BD','Lalmonirhat zila',NULL),
	 ('33','BD','Manikganj zila',NULL),
	 ('34','BD','Mymensingh zila',NULL),
	 ('35','BD','Munshiganj zila',NULL),
	 ('36','BD','Madaripur zila',NULL),
	 ('37','BD','Magura zila',NULL),
	 ('38','BD','Moulvibazar zila',NULL),
	 ('39','BD','Meherpur zila',NULL),
	 ('4','BD','Brahmanbaria zila',NULL),
	 ('40','BD','Narayanganj zila',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('41','BD','Netrakona zila',NULL),
	 ('42','BD','Narsingdi zila',NULL),
	 ('43','BD','Narail zila',NULL),
	 ('44','BD','Natore zila',NULL),
	 ('45','BD','Nawabganj zila',NULL),
	 ('46','BD','Nilphamari zila',NULL),
	 ('47','BD','Noakhali zila',NULL),
	 ('48','BD','Naogaon zila',NULL),
	 ('49','BD','Pabna zila',NULL),
	 ('5','BD','Bagerhat zila',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('50','BD','Pirojpur zila',NULL),
	 ('51','BD','Patuakhali zila',NULL),
	 ('52','BD','Panchagarh zila',NULL),
	 ('53','BD','Rajbari zila',NULL),
	 ('54','BD','Rajshahi zila',NULL),
	 ('55','BD','Rangpur zila',NULL),
	 ('56','BD','Rangamati zila',NULL),
	 ('57','BD','Sherpur zila',NULL),
	 ('58','BD','Satkhira zila',NULL),
	 ('59','BD','Sirajganj zila',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('6','BD','Barisal zila',NULL),
	 ('60','BD','Sylhet zila',NULL),
	 ('61','BD','Sunamganj zila',NULL),
	 ('62','BD','Shariatpur zila',NULL),
	 ('63','BD','Tangail zila',NULL),
	 ('64','BD','Thakurgaon zila',NULL),
	 ('7','BD','Bhola zila',NULL),
	 ('8','BD','Comilla zila',NULL),
	 ('9','BD','Chandpur zila',NULL),
	 ('BRU','BE','Brussels',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('VAN','BE','Antwerpen',NULL),
	 ('VBR','BE','Vlaams-Brabant',NULL),
	 ('VLI','BE','Limburg',NULL),
	 ('VOV','BE','Oost-Vlaanderen',NULL),
	 ('VWV','BE','West-Vlaanderen',NULL),
	 ('WBR','BE','Brabant Wallon',NULL),
	 ('WHT','BE','Hainaut',NULL),
	 ('WLG','BE','Liege',NULL),
	 ('WLX','BE','Luxembourg',NULL),
	 ('WNA','BE','Namur',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('BAL','BF','Bale',NULL),
	 ('BAM','BF','Bam',NULL),
	 ('BAN','BF','Banwa',NULL),
	 ('BAZ','BF','Bazega',NULL),
	 ('BGR','BF','Bougouriba',NULL),
	 ('BLG','BF','Boulgou',NULL),
	 ('BLK','BF','Boulkiemde',NULL),
	 ('COM','BF','Comoe',NULL),
	 ('GAN','BF','Ganzourgou',NULL),
	 ('GNA','BF','Gnagna',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('GOU','BF','Gourma',NULL),
	 ('HOU','BF','Houet',NULL),
	 ('IOB','BF','Ioba',NULL),
	 ('KAD','BF','Kadiogo',NULL),
	 ('KEN','BF','Kenedougou',NULL),
	 ('KMD','BF','Komondjari',NULL),
	 ('KMP','BF','Kompienga',NULL),
	 ('KOP','BF','Koulpulogo',NULL),
	 ('KOS','BF','Kossi',NULL),
	 ('KOT','BF','Kouritenga',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('KOW','BF','Kourweogo',NULL),
	 ('LER','BF','Leraba',NULL),
	 ('LOR','BF','Loroum',NULL),
	 ('MOU','BF','Mouhoun',NULL),
	 ('NAM','BF','Namentenga',NULL),
	 ('NAO','BF','Nahouri',NULL),
	 ('NAY','BF','Nayala',NULL),
	 ('NOU','BF','Noumbiel',NULL),
	 ('OUB','BF','Oubritenga',NULL),
	 ('OUD','BF','Oudalan',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('PAS','BF','Passore',NULL),
	 ('PON','BF','Poni',NULL),
	 ('SEN','BF','Seno',NULL),
	 ('SIS','BF','Siasili',NULL),
	 ('SMT','BF','Sanmatenga',NULL),
	 ('SNG','BF','Sanguie',NULL),
	 ('SOM','BF','Soum',NULL),
	 ('SOR','BF','Sourou',NULL),
	 ('TAP','BF','Tapoa',NULL),
	 ('TUI','BF','Tui',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('YAG','BF','Yagha',NULL),
	 ('YAT','BF','Yatenga',NULL),
	 ('ZIR','BF','Ziro',NULL),
	 ('ZON','BF','Zondoma',NULL),
	 ('ZOU','BF','Zoundweogo',NULL),
	 ('1','BG','Blagoevgrad',NULL),
	 ('10','BG','Kjstendil',NULL),
	 ('11','BG','Lovec',NULL),
	 ('12','BG','Montana',NULL),
	 ('13','BG','Pazardzik',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('14','BG','Pernik',NULL),
	 ('15','BG','Pleven',NULL),
	 ('16','BG','Plovdiv',NULL),
	 ('17','BG','Razgrad',NULL),
	 ('18','BG','Ruse',NULL),
	 ('19','BG','Silistra',NULL),
	 ('2','BG','Burgas',NULL),
	 ('20','BG','Sliven',NULL),
	 ('21','BG','Smoljan',NULL),
	 ('23','BG','Sofia',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('24','BG','Stara Zagora',NULL),
	 ('25','BG','Targoviste',NULL),
	 ('26','BG','Haskovo',NULL),
	 ('27','BG','Sumen',NULL),
	 ('28','BG','Jambol',NULL),
	 ('3','BG','Varna',NULL),
	 ('4','BG','Veliko Tarnovo',NULL),
	 ('5','BG','Vidin',NULL),
	 ('6','BG','Vraca',NULL),
	 ('7','BG','Gabrovo',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('8','BG','Dobric',NULL),
	 ('9','BG','Kardzali',NULL),
	 ('1','BH','Al Hadd',NULL),
	 ('10','BH','Al Mintaqah al Gharbiyah',NULL),
	 ('11','BH','Mintaqat Juzur tawar',NULL),
	 ('12','BH','Madluat Jamad',NULL),
	 ('13','BH','Al Man?mah (Al ?ºimah)',NULL),
	 ('14','BH','Al Jan?b?yah',NULL),
	 ('16','BH','Al Wusþá',NULL),
	 ('17','BH','Ash Sham?l?yah',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('2','BH','Al Muharraq',NULL),
	 ('3','BH','Al Manamah',NULL),
	 ('4','BH','Jidd Hafs',NULL),
	 ('5','BH','Al Mintaqah ash Shamaliyah',NULL),
	 ('6','BH','Sitrah',NULL),
	 ('7','BH','Al Mintagah al Wusta',NULL),
	 ('8','BH','Madluat Isa',NULL),
	 ('9','BH','Ar Rifa',NULL),
	 ('BB','BI','Bubanza',NULL),
	 ('BJ','BI','Bujumbura',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('BR','BI','Bururi',NULL),
	 ('CA','BI','Cankuzo',NULL),
	 ('CI','BI','Cibitoke',NULL),
	 ('GI','BI','Gitega',NULL),
	 ('KR','BI','Karuzi',NULL),
	 ('KY','BI','Kayanza',NULL),
	 ('MA','BI','Makamba',NULL),
	 ('MU','BI','Muramvya',NULL),
	 ('MW','BI','Mwaro',NULL),
	 ('NG','BI','Ngozi',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('RT','BI','Rutana',NULL),
	 ('RY','BI','Ruyigi',NULL),
	 ('AK','BJ','Atakora',NULL),
	 ('AL','BJ','Alibori',NULL),
	 ('AQ','BJ','Atlantique',NULL),
	 ('BO','BJ','Borgou',NULL),
	 ('CO','BJ','Collines',NULL),
	 ('DO','BJ','Donga',NULL),
	 ('KO','BJ','Kouffo',NULL),
	 ('LI','BJ','Littoral',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('MO','BJ','Mono',NULL),
	 ('OU','BJ','Oueme',NULL),
	 ('PL','BJ','Plateau',NULL),
	 ('ZO','BJ','Zou',NULL),
	 ('BE','BN','Belait',NULL),
	 ('BM','BN','Brunei-Muara',NULL),
	 ('TE','BN','Temburong',NULL),
	 ('TU','BN','Tutong',NULL),
	 ('B','BO','El Beni',NULL),
	 ('C','BO','Cochabamba',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('H','BO','Chuquisaca',NULL),
	 ('L','BO','La Paz',NULL),
	 ('N','BO','Pando',NULL),
	 ('O','BO','Oruro',NULL),
	 ('P','BO','Potosi',NULL),
	 ('T','BO','Tarija',NULL),
	 ('AC','BR','Acre',NULL),
	 ('AL','BR','Alagoas',NULL),
	 ('AM','BR','Amazonas',NULL),
	 ('AP','BR','Amapa',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('BA','BR','Baia',NULL),
	 ('CE','BR','Ceara',NULL),
	 ('DF','BR','Distrito Federal',NULL),
	 ('ES','BR','Espirito Santo',NULL),
	 ('FN','BR','Fernando de Noronha',NULL),
	 ('GO','BR','Goias',NULL),
	 ('MA','BR','Maranhao',NULL),
	 ('MG','BR','Minas Gerais',NULL),
	 ('MS','BR','Mato Grosso do Sul',NULL),
	 ('MT','BR','Mato Grosso',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('PA','BR','Para',NULL),
	 ('PB','BR','Paraiba',NULL),
	 ('PE','BR','Pernambuco',NULL),
	 ('PI','BR','Piaui',NULL),
	 ('PR','BR','Parana',NULL),
	 ('RJ','BR','Rio de Janeiro',NULL),
	 ('RN','BR','Rio Grande do Norte',NULL),
	 ('RO','BR','Rondonia',NULL),
	 ('RR','BR','Roraima',NULL),
	 ('RS','BR','Rio Grande do Sul',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('SC','BR','Santa Catarina',NULL),
	 ('SE','BR','Sergipe',NULL),
	 ('SP','BR','Sao Paulo',NULL),
	 ('TO','BR','Tocatins',NULL),
	 ('AC','BS','Acklins and Crooked Islands',NULL),
	 ('BI','BS','Bimini',NULL),
	 ('CI','BS','Cat Island',NULL),
	 ('EX','BS','Exuma',NULL),
	 ('FC','BS','Fresh Creek',NULL),
	 ('FP','BS','Freeport',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('GH','BS','Governor''s Harbour',NULL),
	 ('GT','BS','Green Turtle Cay',NULL),
	 ('HI','BS','Harbour Island',NULL),
	 ('HR','BS','High Rock',NULL),
	 ('IN','BS','Inagua',NULL),
	 ('KB','BS','Kemps Bay',NULL),
	 ('LI','BS','Long Island',NULL),
	 ('MG','BS','Mayaguana',NULL),
	 ('MH','BS','Marsh Harbour',NULL),
	 ('NB','BS','Nicholls Town and Berry Islands',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('NP','BS','New Providence',NULL),
	 ('RI','BS','Ragged Island',NULL),
	 ('RS','BS','Rock Sound',NULL),
	 ('SP','BS','Sandy Point',NULL),
	 ('SR','BS','San Salvador and Rum Cay',NULL),
	 ('11','BT','Paro',NULL),
	 ('12','BT','Chhukha',NULL),
	 ('13','BT','Ha',NULL),
	 ('14','BT','Samtee',NULL),
	 ('15','BT','Thimphu',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('21','BT','Tsirang',NULL),
	 ('22','BT','Dagana',NULL),
	 ('23','BT','Punakha',NULL),
	 ('24','BT','Wangdue Phodrang',NULL),
	 ('31','BT','Sarpang',NULL),
	 ('32','BT','Trongsa',NULL),
	 ('33','BT','Bumthang',NULL),
	 ('34','BT','Zhemgang',NULL),
	 ('41','BT','Trashigang',NULL),
	 ('42','BT','Monggar',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('43','BT','Pemagatshel',NULL),
	 ('44','BT','Lhuentse',NULL),
	 ('45','BT','Samdrup Jongkha',NULL),
	 ('GA','BT','Gasa',NULL),
	 ('TY','BT','Trashi Yangtse',NULL),
	 ('CE','BW','Central',NULL),
	 ('GH','BW','Ghanzi',NULL),
	 ('KG','BW','Kgalagadi',NULL),
	 ('KL','BW','Kgatleng',NULL),
	 ('KW','BW','Kweneng',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('NE','BW','North-East',NULL),
	 ('NG','BW','Ngamiland',NULL),
	 ('NW','BW','North-West',NULL),
	 ('SE','BW','South-East',NULL),
	 ('SO','BW','Southern',NULL),
	 ('BR','BY','Br?sckaja voblasc''',NULL),
	 ('HO','BY','Homel''skaja voblasc''',NULL),
	 ('HR','BY','Hrodzenskaja voblasc''',NULL),
	 ('MA','BY','Mahilëuskaja voblasc''',NULL),
	 ('MI','BY','Minskaja voblasc''',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('VI','BY','Vicebskaja voblasc''',NULL),
	 ('BZ','BZ','Belize',NULL),
	 ('CY','BZ','Cayo',NULL),
	 ('CZL','BZ','Corozal',NULL),
	 ('OW','BZ','Orange Walk',NULL),
	 ('SC','BZ','Stann Creek',NULL),
	 ('TOL','BZ','Toledo',NULL),
	 ('AB','CA','Alberta',NULL),
	 ('BC','CA','British Columbia',NULL),
	 ('MB','CA','Manitoba',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('NB','CA','New Brunswick',NULL),
	 ('NL','CA','Newfoundland and Labrador',NULL),
	 ('NS','CA','Nova Scotia',NULL),
	 ('NT','CA','Northwest Territories',NULL),
	 ('NU','CA','Nunavut',NULL),
	 ('ON','CA','Ontario',NULL),
	 ('PE','CA','Prince Edward Island',NULL),
	 ('QC','CA','Quebec',NULL),
	 ('SK','CA','Saskatchewan',NULL),
	 ('YT','CA','Yukon Territory',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('BC','CD','Bas-Congo',NULL),
	 ('BN','CD','Bandundu',NULL),
	 ('EQ','CD','Equateur',NULL),
	 ('HC','CD','Haut-Congo',NULL),
	 ('KA','CD','Katanga',NULL),
	 ('KE','CD','Kasai-Oriental',NULL),
	 ('KN','CD','Kinshasa',NULL),
	 ('KW','CD','Kasai-Occidental',NULL),
	 ('MA','CD','Maniema',NULL),
	 ('NK','CD','Nord-Kivu',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('OR','CD','Orientale',NULL),
	 ('SK','CD','Sud-Kivu',NULL),
	 ('AC','CF','Ouham',NULL),
	 ('BB','CF','Bamingui-Bangoran',NULL),
	 ('BGF','CF','Bangui',NULL),
	 ('BK','CF','Basse-Kotto',NULL),
	 ('HK','CF','Haute-Kotto',NULL),
	 ('HM','CF','Haut-Mbomou',NULL),
	 ('HS','CF','Mambere-Kadei',NULL),
	 ('KB','CF','Nana-Grebizi',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('KG','CF','Kemo',NULL),
	 ('LB','CF','Lobaye',NULL),
	 ('MB','CF','Mbomou',NULL),
	 ('MP','CF','Ombella-Mpoko',NULL),
	 ('NM','CF','Nana-Mambere',NULL),
	 ('OP','CF','Ouham-Pende',NULL),
	 ('SE','CF','Sangha-Mbaere',NULL),
	 ('UK','CF','Ouaka',NULL),
	 ('VR','CF','Vakaga',NULL),
	 ('11','CG','Bouenza',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('12','CG','Pool',NULL),
	 ('13','CG','Sangha',NULL),
	 ('14','CG','Plateaux',NULL),
	 ('15','CG','Cuvette-Ouest',NULL),
	 ('2','CG','Lekoumou',NULL),
	 ('5','CG','Kouilou',NULL),
	 ('7','CG','Likouala',NULL),
	 ('8','CG','Cuvette',NULL),
	 ('9','CG','Niari',NULL),
	 ('BZV','CG','Brazzaville',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('AG','CH','Aargau',NULL),
	 ('AI','CH','Appenzell Innerrhoden',NULL),
	 ('AR','CH','Appenzell Ausserrhoden',NULL),
	 ('BE','CH','Bern',NULL),
	 ('BL','CH','Basel-Landschaft',NULL),
	 ('BS','CH','Basel-Stadt',NULL),
	 ('FR','CH','Fribourg',NULL),
	 ('GE','CH','Geneva',NULL),
	 ('GL','CH','Glarus',NULL),
	 ('GR','CH','Graubunden',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('JU','CH','Jura',NULL),
	 ('LU','CH','Luzern',NULL),
	 ('NE','CH','Neuchatel',NULL),
	 ('NW','CH','Nidwalden',NULL),
	 ('OW','CH','Obwalden',NULL),
	 ('SG','CH','Sankt Gallen',NULL),
	 ('SH','CH','Schaffhausen',NULL),
	 ('SO','CH','Solothurn',NULL),
	 ('SZ','CH','Schwyz',NULL),
	 ('TG','CH','Thurgau',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('TI','CH','Ticino',NULL),
	 ('UR','CH','Uri',NULL),
	 ('VD','CH','Vaud',NULL),
	 ('VS','CH','Valais',NULL),
	 ('ZG','CH','Zug',NULL),
	 ('ZH','CH','Zurich',NULL),
	 ('1','CI','Lagunes',NULL),
	 ('10','CI','Denguele',NULL),
	 ('11','CI','Nzi-Comoe',NULL),
	 ('12','CI','Marahoue',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('13','CI','Sud-Comoe',NULL),
	 ('14','CI','Worodouqou',NULL),
	 ('15','CI','Sud-Bandama',NULL),
	 ('16','CI','Agnebi',NULL),
	 ('2','CI','Haut-Sassandra',NULL),
	 ('3','CI','Savanes',NULL),
	 ('4','CI','Vallee du Bandama',NULL),
	 ('5','CI','Moyen-Comoe',NULL),
	 ('6','CI','18 Montagnes',NULL),
	 ('7','CI','Lacs',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('8','CI','Zanzan',NULL),
	 ('9','CI','Bas-Sassandra',NULL),
	 ('AI','CL','Aisen del General Carlos Ibanez del Campo',NULL),
	 ('AN','CL','Antofagasta',NULL),
	 ('AR','CL','Araucania',NULL),
	 ('AT','CL','Atacama',NULL),
	 ('BI','CL','Bio-Bio',NULL),
	 ('CO','CL','Coquimbo',NULL),
	 ('LI','CL','Libertador General Bernardo O''Higgins',NULL),
	 ('LL','CL','Los Lagos',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('MA','CL','Magallanes',NULL),
	 ('ML','CL','Maule',NULL),
	 ('RM','CL','Region Metropolitana de Santiago',NULL),
	 ('TA','CL','Tarapaca',NULL),
	 ('VS','CL','Valparaiso',NULL),
	 ('AD','CM','Adamaoua',NULL),
	 ('CE','CM','Centre',NULL),
	 ('EN','CM','Far North',NULL),
	 ('ES','CM','East',NULL),
	 ('NO','CM','North',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('OU','CM','West',NULL),
	 ('SW','CM','South',NULL),
	 ('11','CN','Beijing',NULL),
	 ('12','CN','Tianjin',NULL),
	 ('13','CN','Hebei',NULL),
	 ('14','CN','Shanxi',NULL),
	 ('15','CN','Neia Mongol (mn)',NULL),
	 ('21','CN','Liaoning',NULL),
	 ('22','CN','Jilin',NULL),
	 ('23','CN','Heilongjiang',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('31','CN','Shanghai',NULL),
	 ('32','CN','Jiangsu',NULL),
	 ('33','CN','Zhejiang',NULL),
	 ('34','CN','Anhui',NULL),
	 ('35','CN','Fujian',NULL),
	 ('36','CN','Jiangxi',NULL),
	 ('37','CN','Shandong',NULL),
	 ('41','CN','Henan',NULL),
	 ('42','CN','Hubei',NULL),
	 ('43','CN','Hunan',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('44','CN','Guangdong',NULL),
	 ('45','CN','Guangxi',NULL),
	 ('46','CN','Hainan',NULL),
	 ('50','CN','Chongqing',NULL),
	 ('51','CN','Sichuan',NULL),
	 ('52','CN','Guizhou',NULL),
	 ('53','CN','Yunnan',NULL),
	 ('54','CN','Xizang',NULL),
	 ('61','CN','Shaanxi',NULL),
	 ('62','CN','Gansu',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('63','CN','Qinghai',NULL),
	 ('65','CN','Xinjiang',NULL),
	 ('71','CN','Taiwan',NULL),
	 ('91','CN','Hong Kong',NULL),
	 ('92','CN','Macau',NULL),
	 ('AMA','CO','Amazonea',NULL),
	 ('ANT','CO','Antioquia',NULL),
	 ('ARA','CO','Arauca',NULL),
	 ('ATL','CO','Atlántico',NULL),
	 ('BOL','CO','Bolívar',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('BOY','CO','Boyacá',NULL),
	 ('CAL','CO','Caldea',NULL),
	 ('CAQ','CO','Caquetá',NULL),
	 ('CAS','CO','Casanare',NULL),
	 ('CAU','CO','Cauca',NULL),
	 ('CES','CO','Cesar',NULL),
	 ('CHO','CO','Chocó',NULL),
	 ('COR','CO','Córdoba',NULL),
	 ('CUN','CO','Cundinamarca',NULL),
	 ('DC','CO','Distrito Capital de Bogotá',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('GUA','CO','Guainía',NULL),
	 ('GUV','CO','Guaviare',NULL),
	 ('LAG','CO','La Guajira',NULL),
	 ('MAG','CO','Magdalena',NULL),
	 ('MET','CO','Meta',NULL),
	 ('NAR','CO','Nari?o',NULL),
	 ('NSA','CO','Norte de Santander',NULL),
	 ('PUT','CO','Putumayo',NULL),
	 ('QUI','CO','Quindio',NULL),
	 ('RIS','CO','Risaralda',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('SAN','CO','Santander',NULL),
	 ('SAP','CO','San Andrés, Providencia y Santa Catalina',NULL),
	 ('SUC','CO','Sucre',NULL),
	 ('TOL','CO','Tolima',NULL),
	 ('VAC','CO','Valle del Cauca',NULL),
	 ('VAU','CO','Vaupés',NULL),
	 ('VID','CO','Vichada',NULL),
	 ('A','CR','Alajuela',NULL),
	 ('C','CR','Cartago',NULL),
	 ('G','CR','Guanacaste',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('H','CR','Heredia',NULL),
	 ('L','CR','Limon',NULL),
	 ('P','CR','Puntarenas',NULL),
	 ('SJ','CR','San Jose',NULL),
	 ('CG','CS','Crna Gora',NULL),
	 ('KM','CS','Kosovo-Metohija',NULL),
	 ('SR','CS','Srbija',NULL),
	 ('VO','CS','Vojvodina',NULL),
	 ('1','CU','Pinar del Rio',NULL),
	 ('10','CU','Las Tunas',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('11','CU','Holquin',NULL),
	 ('12','CU','Granma',NULL),
	 ('13','CU','Santiago de Cuba',NULL),
	 ('14','CU','Guantanamo',NULL),
	 ('2','CU','La Habana',NULL),
	 ('3','CU','Ciudad de La Habana',NULL),
	 ('4','CU','Matanzas',NULL),
	 ('5','CU','Villa Clara',NULL),
	 ('6','CU','Cienfuegos',NULL),
	 ('7','CU','Sancti Spiritus',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('8','CU','Ciego de `vila',NULL),
	 ('9','CU','Camagey',NULL),
	 ('99','CU','Isla de la Juventud',NULL),
	 ('CA','CU','Ciego de Avila',NULL),
	 ('CG','CU','Camagoey',NULL),
	 ('HO','CU','Holgun',NULL),
	 ('IJ','CU','Municipio Especial Isla de la Juventud',NULL),
	 ('PR','CU','Pinar del Roo',NULL),
	 ('SS','CU','Sancti Spritus',NULL),
	 ('BR','CV','Brava',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('BV','CV','Boa Vista',NULL),
	 ('CS','CV','Calheta de Sao Miguel',NULL),
	 ('FO','CV','Fogo',NULL),
	 ('MA','CV','Maio',NULL),
	 ('MO','CV','Mosteiros',NULL),
	 ('PA','CV','Paul',NULL),
	 ('PN','CV','Porto Novo',NULL),
	 ('PR','CV','Praia',NULL),
	 ('RG','CV','Ribeira Grande',NULL),
	 ('SD','CV','Sao Domingos',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('SF','CV','Sao Filipe',NULL),
	 ('SL','CV','Sal',NULL),
	 ('SN','CV','Sao Nicolau',NULL),
	 ('SV','CV','Sao Vicente',NULL),
	 ('TA','CV','Tarrafal',NULL),
	 ('1','CY','Lefkosia',NULL),
	 ('2','CY','Lemesos',NULL),
	 ('3','CY','Larnaka',NULL),
	 ('4','CY','Ammochostos Magusa',NULL),
	 ('5','CY','Pafos',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('6','CY','Keryneia',NULL),
	 ('JC','CZ','Jihoèeský kraj',NULL),
	 ('JM','CZ','Jihomoravský kraj',NULL),
	 ('KA','CZ','Karlovarský kraj',NULL),
	 ('KR','CZ','Královéhradecký kraj',NULL),
	 ('LI','CZ','Liberecký kraj',NULL),
	 ('MO','CZ','Moravskoslezský kraj',NULL),
	 ('OL','CZ','Olomoucký kraj',NULL),
	 ('PA','CZ','Pardubický kraj',NULL),
	 ('PL','CZ','Plzeòský kraj',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('PR','CZ','Praha, hlavní mìsto',NULL),
	 ('ST','CZ','Støedoèeský kraj',NULL),
	 ('US','CZ','Ústecký kraj',NULL),
	 ('VY','CZ','Vysoèina',NULL),
	 ('ZL','CZ','Zlínský kraj',NULL),
	 ('BB','DE','Brandenburg',NULL),
	 ('BR','DE','Berlin',NULL),
	 ('BW','DE','Baden-Wuerttemberg',NULL),
	 ('BY','DE','Bayern',NULL),
	 ('HB','DE','Bremen',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('HE','DE','Hessen',NULL),
	 ('HH','DE','Hamburg',NULL),
	 ('MV','DE','Mecklenburg-Vorpommern',NULL),
	 ('NI','DE','Niedersachsen',NULL),
	 ('NW','DE','Nordrhein-Westfalen',NULL),
	 ('RP','DE','Rheinland-Pfalz',NULL),
	 ('SH','DE','Schleswig-Holstein',NULL),
	 ('SL','DE','Saarland',NULL),
	 ('SN','DE','Sachsen',NULL),
	 ('ST','DE','Sachsen-Anhalt',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('TH','DE','Thueringen',NULL),
	 ('AS','DJ','Ali Sabiah',NULL),
	 ('DI','DJ','Dikhil',NULL),
	 ('DJ','DJ','Djibouti',NULL),
	 ('OB','DJ','Obock',NULL),
	 ('TA','DJ','Tadjoura',NULL),
	 ('101','DK','Copenhagen City',NULL),
	 ('147','DK','Frederiksberg',NULL),
	 ('15','DK','Copenhagen',NULL),
	 ('20','DK','Frederiksborg',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('25','DK','Roskilde',NULL),
	 ('30','DK','Vestsj?lland',NULL),
	 ('35','DK','Storstr?m',NULL),
	 ('40','DK','Bornholm',NULL),
	 ('42','DK','Fyn',NULL),
	 ('50','DK','South Jutland',NULL),
	 ('55','DK','Ribe',NULL),
	 ('60','DK','Vejle',NULL),
	 ('65','DK','Ringkj?bing',NULL),
	 ('70','DK','?rhus',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('76','DK','Viborg',NULL),
	 ('80','DK','North Jutland',NULL),
	 ('1','DO','Distrito Nacional (Santo Domingo)',NULL),
	 ('10','DO','Independencia',NULL),
	 ('11','DO','La Altagracia',NULL),
	 ('12','DO','La Romana',NULL),
	 ('13','DO','La Vega',NULL),
	 ('14','DO','Maroia Trinidad Sánchez',NULL),
	 ('15','DO','Monte Cristi',NULL),
	 ('16','DO','Pedernales',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('17','DO','Peravia',NULL),
	 ('18','DO','Puerto Plata',NULL),
	 ('19','DO','Salcedo',NULL),
	 ('2','DO','Azua',NULL),
	 ('20','DO','Samaná',NULL),
	 ('21','DO','San Cristóbal',NULL),
	 ('23','DO','San Pedro de Macorís',NULL),
	 ('24','DO','Sánchez Ramírez',NULL),
	 ('25','DO','Santiago',NULL),
	 ('26','DO','Santiago Rodríguez',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('27','DO','Valverde',NULL),
	 ('28','DO','Monse?or Nouel',NULL),
	 ('29','DO','Monte Plata',NULL),
	 ('3','DO','Bahoruco',NULL),
	 ('30','DO','Hato Mayor',NULL),
	 ('4','DO','Barahona',NULL),
	 ('5','DO','Dajabón',NULL),
	 ('6','DO','Duarte',NULL),
	 ('7','DO','La Estrelleta [Elias Pina]',NULL),
	 ('8','DO','El Seybo [El Seibo]',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('9','DO','Espaillat',NULL),
	 ('1','DZ','Adrar',NULL),
	 ('10','DZ','Bouira',NULL),
	 ('11','DZ','Tamanghasset',NULL),
	 ('12','DZ','Tebessa',NULL),
	 ('13','DZ','Tlemcen',NULL),
	 ('14','DZ','Tiaret',NULL),
	 ('15','DZ','Tizi Ouzou',NULL),
	 ('16','DZ','Alger',NULL),
	 ('17','DZ','Djelfa',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('18','DZ','Jijel',NULL),
	 ('19','DZ','Setif',NULL),
	 ('2','DZ','Chlef',NULL),
	 ('20','DZ','Saida',NULL),
	 ('21','DZ','Skikda',NULL),
	 ('22','DZ','Sidi Bel Abbes',NULL),
	 ('23','DZ','Annaba',NULL),
	 ('24','DZ','Guelma',NULL),
	 ('25','DZ','Constantine',NULL),
	 ('26','DZ','Medea',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('27','DZ','Mostaganem',NULL),
	 ('28','DZ','Msila',NULL),
	 ('29','DZ','Mascara',NULL),
	 ('3','DZ','Laghouat',NULL),
	 ('30','DZ','Ouargla',NULL),
	 ('31','DZ','Oran',NULL),
	 ('32','DZ','El Bayadh',NULL),
	 ('33','DZ','Illizi',NULL),
	 ('34','DZ','Bordj Bou Arreridj',NULL),
	 ('35','DZ','Boumerdes',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('36','DZ','El Tarf',NULL),
	 ('37','DZ','Tindouf',NULL),
	 ('38','DZ','Tissemsilt',NULL),
	 ('39','DZ','El Oued',NULL),
	 ('4','DZ','Oum el Bouaghi',NULL),
	 ('40','DZ','Khenchela',NULL),
	 ('41','DZ','Souk Ahras',NULL),
	 ('42','DZ','Tipaza',NULL),
	 ('43','DZ','Mila',NULL),
	 ('44','DZ','Ain Defla',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('45','DZ','Naama',NULL),
	 ('46','DZ','Ain Tmouchent',NULL),
	 ('47','DZ','Ghardaia',NULL),
	 ('48','DZ','Relizane',NULL),
	 ('5','DZ','Batna',NULL),
	 ('6','DZ','Bejaia',NULL),
	 ('7','DZ','Biskra',NULL),
	 ('8','DZ','Bechar',NULL),
	 ('9','DZ','Blida',NULL),
	 ('A','EC','Azuay',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('B','EC','Bolivar',NULL),
	 ('C','EC','Carchi',NULL),
	 ('D','EC','Orellana',NULL),
	 ('E','EC','Esmeraldas',NULL),
	 ('F','EC','Canar',NULL),
	 ('G','EC','Guayas',NULL),
	 ('H','EC','Chimborazo',NULL),
	 ('I','EC','Imbabura',NULL),
	 ('L','EC','Loja',NULL),
	 ('M','EC','Manabi',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('N','EC','Napo',NULL),
	 ('O','EC','El Oro',NULL),
	 ('P','EC','Pichincha',NULL),
	 ('R','EC','Los Rios',NULL),
	 ('S','EC','Morona-Santiago',NULL),
	 ('T','EC','Tungurahua',NULL),
	 ('U','EC','Sucumbios',NULL),
	 ('W','EC','Galapagos',NULL),
	 ('X','EC','Cotopaxi',NULL),
	 ('Y','EC','Pastaza',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('Z','EC','Zamora-Chinchipe',NULL),
	 ('37','EE','Harjumsa',NULL),
	 ('39','EE','Hitumea',NULL),
	 ('44','EE','Ida-Virumsa',NULL),
	 ('49','EE','Jogevamsa',NULL),
	 ('51','EE','Jarvamsa',NULL),
	 ('57','EE','Lasnemsa',NULL),
	 ('59','EE','Laane-Virumaa',NULL),
	 ('65','EE','Polvamea',NULL),
	 ('67','EE','Parnumsa',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('70','EE','Raplamsa',NULL),
	 ('74','EE','Saaremsa',NULL),
	 ('7B','EE','Tartumsa',NULL),
	 ('82','EE','Valgamaa',NULL),
	 ('84','EE','Viljandimsa',NULL),
	 ('86','EE','Vorumaa',NULL),
	 ('ALX','EG','Al Iskandarlyah',NULL),
	 ('ASN','EG','Aswan',NULL),
	 ('AST','EG','Asyut',NULL),
	 ('BA','EG','Al Bahr al Ahmar',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('BH','EG','Al Buhayrah',NULL),
	 ('BNS','EG','Bani Suwayf',NULL),
	 ('C','EG','Al Qahirah',NULL),
	 ('DK','EG','Ad Daqahllyah',NULL),
	 ('DT','EG','Dumyat',NULL),
	 ('FYM','EG','Al Fayym',NULL),
	 ('GH','EG','Al Gharbiyah',NULL),
	 ('GZ','EG','Al Jizah',NULL),
	 ('IS','EG','Al Isma illyah',NULL),
	 ('JS','EG','Janub Sina''',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('KB','EG','Al Qalyublyah',NULL),
	 ('KFS','EG','Kafr ash Shaykh',NULL),
	 ('KN','EG','Qina',NULL),
	 ('MN','EG','Al Minya',NULL),
	 ('MNF','EG','Al Minuflyah',NULL),
	 ('MT','EG','Matruh',NULL),
	 ('PTS','EG','Bur Sa''id',NULL),
	 ('SHG','EG','Suhaj',NULL),
	 ('SHR','EG','Ash Sharqiyah',NULL),
	 ('SIN','EG','Shamal Sina''',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('SUZ','EG','As Suways',NULL),
	 ('WAD','EG','Al Wadi al Jadid',NULL),
	 ('AN','ER','Anseba',NULL),
	 ('DK','ER','Debubawi Keyih Bahri [Debub-Keih-Bahri]',NULL),
	 ('DU','ER','Debub',NULL),
	 ('GB','ER','Gash-Barka',NULL),
	 ('MA','ER','Maakel [Maekel]',NULL),
	 ('SK','ER','Semenawi Keyih Bahri [Semien-Keih-Bahri]',NULL),
	 ('A','ES','Alicante',NULL),
	 ('AB','ES','Albacete',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('AL','ES','Almería',NULL),
	 ('AV','ES','Ávila',NULL),
	 ('B','ES','Barcelona',NULL),
	 ('BA','ES','Badajoz',NULL),
	 ('BI','ES','Vizcaya',NULL),
	 ('BU','ES','Burgos',NULL),
	 ('C','ES','La Coru?a',NULL),
	 ('CA','ES','Cádiz',NULL),
	 ('CC','ES','Cáceres',NULL),
	 ('CE','ES','Ceuta',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('CR','ES','Ciudad Real',NULL),
	 ('CS','ES','Castellón',NULL),
	 ('CU','ES','Cuenca',NULL),
	 ('GC','ES','Las Palmas',NULL),
	 ('GE','ES','Girona [Gerona]',NULL),
	 ('GR','ES','Granada',NULL),
	 ('GU','ES','Guadalajara',NULL),
	 ('H','ES','Huelva',NULL),
	 ('HU','ES','Huesca',NULL),
	 ('J','ES','Jaén',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('L','ES','Lleida [Lérida]',NULL),
	 ('LE','ES','León',NULL),
	 ('LO','ES','La Rioja',NULL),
	 ('LU','ES','Lugo',NULL),
	 ('M','ES','Madrid',NULL),
	 ('MA','ES','Málaga',NULL),
	 ('ML','ES','Melilla',NULL),
	 ('MU','ES','Murcia',NULL),
	 ('NA','ES','Navarra',NULL),
	 ('O','ES','Asturias',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('OR','ES','Ourense',NULL),
	 ('P','ES','Palencia',NULL),
	 ('PM','ES','Baleares',NULL),
	 ('PO','ES','Pontevedra',NULL),
	 ('S','ES','Cantabria',NULL),
	 ('SA','ES','Salamanca',NULL),
	 ('SE','ES','Sevilla',NULL),
	 ('SG','ES','Segovia',NULL),
	 ('SO','ES','Soria',NULL),
	 ('SS','ES','Guipúzcoa',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('T','ES','Tarragona',NULL),
	 ('TE','ES','Teruel',NULL),
	 ('TF','ES','Santa Cruz de Tenerife',NULL),
	 ('V','ES','Valencia',NULL),
	 ('VA','ES','Valladolid',NULL),
	 ('VI','ES','Álava',NULL),
	 ('Z','ES','Zaragoza',NULL),
	 ('ZA','ES','Zamora',NULL),
	 ('AA','ET','Addis Ababa',NULL),
	 ('AF','ET','Afar',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('AM','ET','Amara',NULL),
	 ('BE','ET','Benshangul-Gumaz',NULL),
	 ('DD','ET','Dire Dawa',NULL),
	 ('GA','ET','Gambela Peoples',NULL),
	 ('HA','ET','Harari People',NULL),
	 ('OR','ET','Oromia',NULL),
	 ('SN','ET','Southern Nations, Nationalities and Peoples',NULL),
	 ('SO','ET','Somali',NULL),
	 ('TI','ET','Tigrai',NULL),
	 ('AL','FI','?land',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('CF','FI','Central Finland',NULL),
	 ('CO','FI','Central Ostrobothnia',NULL),
	 ('ES','FI','Etelä-Savo',NULL),
	 ('HH','FI','Häme',NULL),
	 ('IU','FI','Itä-Uusimaa',NULL),
	 ('KA','FI','Kainuu',NULL),
	 ('KY','FI','Kymenlaakso',NULL),
	 ('LA','FI','Lapland',NULL),
	 ('NK','FI','North Karelia',NULL),
	 ('NO','FI','Nothern Ostrobothnia',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('NS','FI','Northern Savo',NULL),
	 ('OB','FI','Ostrobothnia',NULL),
	 ('PH','FI','Päijät-Häme',NULL),
	 ('SK','FI','Satakunta',NULL),
	 ('SO','FI','South Ostrobothnia',NULL),
	 ('SW','FI','South-West Finland',NULL),
	 ('TR','FI','Tampere Region',NULL),
	 ('UM','FI','Uusimaa',NULL),
	 ('E','FJ','Eastern',NULL),
	 ('N','FJ','Northern',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('R','FJ','Rotuma',NULL),
	 ('W','FJ','Western',NULL),
	 ('KSA','FM','Kosrae',NULL),
	 ('PNI','FM','Pohnpei',NULL),
	 ('TRK','FM','Chuuk',NULL),
	 ('YAP','FM','Yap',NULL),
	 ('1','FR','Ain',NULL),
	 ('10','FR','Aube',NULL),
	 ('11','FR','Aude',NULL),
	 ('12','FR','Aveyron',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('13','FR','Bouches-du-Rhône',NULL),
	 ('14','FR','Calvados',NULL),
	 ('15','FR','Cantal',NULL),
	 ('16','FR','Charente',NULL),
	 ('17','FR','Charente-Maritime',NULL),
	 ('18','FR','Cher',NULL),
	 ('19','FR','Corr?ze',NULL),
	 ('2','FR','Aisne',NULL),
	 ('20A','FR','Corse-du-Sud',NULL),
	 ('20B','FR','Haute-Corse',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('21','FR','Côte-d''Or',NULL),
	 ('22','FR','Côtes-d''Armor',NULL),
	 ('23','FR','Creuse',NULL),
	 ('24','FR','Dordogne',NULL),
	 ('25','FR','Doubs',NULL),
	 ('26','FR','Drôme',NULL),
	 ('27','FR','Eure',NULL),
	 ('28','FR','Eure-et-Loir',NULL),
	 ('29','FR','Finist?re',NULL),
	 ('3','FR','Allier',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('30','FR','Gard',NULL),
	 ('31','FR','Haute-Garonne',NULL),
	 ('32','FR','Gers',NULL),
	 ('33','FR','Gironde',NULL),
	 ('34','FR','Hérault',NULL),
	 ('35','FR','Ille-et-Vilaine',NULL),
	 ('36','FR','Indre',NULL),
	 ('37','FR','Indre-et-Loire',NULL),
	 ('38','FR','Is?re',NULL),
	 ('39','FR','Jura',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('4','FR','Alpes-de-Haute-Provence',NULL),
	 ('40','FR','Landes',NULL),
	 ('41','FR','Loir-et-Cher',NULL),
	 ('42','FR','Loire',NULL),
	 ('43','FR','Haute-Loire',NULL),
	 ('44','FR','Loire-Atlantique',NULL),
	 ('45','FR','Loiret',NULL),
	 ('46','FR','Lot',NULL),
	 ('47','FR','Lot-et-Garonne',NULL),
	 ('48','FR','Loz?re',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('49','FR','Maine-et-Loire',NULL),
	 ('5','FR','Hautes-Alpes',NULL),
	 ('50','FR','Manche',NULL),
	 ('51','FR','Marne',NULL),
	 ('53','FR','Mayenne',NULL),
	 ('54','FR','Meurthe-et-Moselle',NULL),
	 ('55','FR','Meuse',NULL),
	 ('56','FR','Morbihan',NULL),
	 ('57','FR','Moselle',NULL),
	 ('58','FR','Ni?vre',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('59','FR','Nord',NULL),
	 ('6','FR','Alpes-Maritimes',NULL),
	 ('60','FR','Oise',NULL),
	 ('61','FR','Orne',NULL),
	 ('62','FR','Pas-de-Calais',NULL),
	 ('63','FR','Puy-de-Dôme',NULL),
	 ('64','FR','Pyrénées-Atlantiques',NULL),
	 ('65','FR','Hautes-Pyrénées',NULL),
	 ('66','FR','Pyrénées-Orientales',NULL),
	 ('67','FR','Bas-Rhin',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('68','FR','Haut-Rhin',NULL),
	 ('69','FR','Rhône',NULL),
	 ('7','FR','Ard?che',NULL),
	 ('70','FR','Haute-Saône',NULL),
	 ('71','FR','Saône-et-Loire',NULL),
	 ('72','FR','Sarthe',NULL),
	 ('73','FR','Savoie',NULL),
	 ('74','FR','Haute-Savoie',NULL),
	 ('75','FR','Paris',NULL),
	 ('76','FR','Seine-Maritime',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('77','FR','Seine-et-Marne',NULL),
	 ('78','FR','Yvelines',NULL),
	 ('79','FR','Deux-S?vres',NULL),
	 ('8','FR','Ardennes',NULL),
	 ('80','FR','Somme',NULL),
	 ('81','FR','Tarn',NULL),
	 ('82','FR','Tarn-et-Garonne',NULL),
	 ('83','FR','Var',NULL),
	 ('84','FR','Vaucluse',NULL),
	 ('85','FR','Vendée',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('86','FR','Vienne',NULL),
	 ('87','FR','Haute-Vienne',NULL),
	 ('88','FR','Vosges',NULL),
	 ('89','FR','Yonne',NULL),
	 ('9','FR','Ari?ge',NULL),
	 ('90','FR','Territoire de Belfort',NULL),
	 ('91','FR','Essonne',NULL),
	 ('92','FR','Hauts-de-Seine',NULL),
	 ('93','FR','Seine-Saint-Denis',NULL),
	 ('94','FR','Val-de-Marne',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('95','FR','Val d''Oise',NULL),
	 ('ABD','GB','Aberdeenshire',NULL),
	 ('ABE','GB','Aberdeen City',NULL),
	 ('AGB','GB','Argyll and Bute',NULL),
	 ('ANS','GB','Angus',NULL),
	 ('ANT','GB','Co Antrim',NULL),
	 ('ARM','GB','Co Armagh',NULL),
	 ('BDF','GB','Bedfordshire',NULL),
	 ('BGW','GB','Gwent',NULL),
	 ('BKM','GB','Buckinghamshire',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('BRK','GB','Berkshire',NULL),
	 ('BST','GB','Bristol, City of',NULL),
	 ('CAM','GB','Cambridgeshire',NULL),
	 ('CHS','GB','Cheshire',NULL),
	 ('CLK','GB','Clackmannanshire',NULL),
	 ('CMA','GB','Cumbria',NULL),
	 ('CON','GB','Cornwall',NULL),
	 ('CWD','GB','Clwyd',NULL),
	 ('DBY','GB','Derbyshire',NULL),
	 ('DEV','GB','Devon',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('DFD','GB','Dyfed',NULL),
	 ('DGY','GB','Dumfries and Galloway',NULL),
	 ('DND','GB','Dundee City',NULL),
	 ('DOR','GB','Dorset',NULL),
	 ('DOW','GB','Co Down',NULL),
	 ('DRY','GB','Co Londonderry',NULL),
	 ('DUR','GB','County Durham',NULL),
	 ('EAY','GB','East Ayrshire',NULL),
	 ('EDH','GB','Edinburgh, City of',NULL),
	 ('EDU','GB','East Dunbartonshire',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('ELN','GB','East Lothian',NULL),
	 ('ELS','GB','Na h-Eileanan Siar',NULL),
	 ('ERW','GB','East Renfrewshire',NULL),
	 ('ERY','GB','East Riding of Yorkshire',NULL),
	 ('ESS','GB','Essex',NULL),
	 ('ESX','GB','East Sussex',NULL),
	 ('FAL','GB','Falkirk',NULL),
	 ('FER','GB','Co Fermanagh',NULL),
	 ('FIF','GB','Fife',NULL),
	 ('GLG','GB','Glasgow City',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('GLS','GB','Gloucestershire',NULL),
	 ('GTM','GB','Greater Manchester',NULL),
	 ('GWN','GB','Gwynedd',NULL),
	 ('HAM','GB','Hampshire',NULL),
	 ('HED','GB','Highland',NULL),
	 ('HEF','GB','Herefordshire',NULL),
	 ('HRT','GB','Hertfordshire',NULL),
	 ('IOW','GB','Isle of Wight',NULL),
	 ('IVC','GB','Inverclyde',NULL),
	 ('KEN','GB','Kent',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('LAN','GB','Lancashire',NULL),
	 ('LEC','GB','Leicestershire',NULL),
	 ('LON','GB','Greater London',NULL),
	 ('MLN','GB','Midlothian',NULL),
	 ('MRY','GB','Moray',NULL),
	 ('MSY','GB','Merseyside',NULL),
	 ('NAY','GB','North Ayrshire',NULL),
	 ('NBL','GB','Northumberland',NULL),
	 ('NFK','GB','Norfolk',NULL),
	 ('NLK','GB','North Lanarkshire',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('NTH','GB','Northamptonshire',NULL),
	 ('NTT','GB','Nottinghamshire',NULL),
	 ('NYK','GB','North Yorkshire',NULL),
	 ('OLD','GB','Oldham',NULL),
	 ('OMH','GB','Omagh',NULL),
	 ('ORR','GB','Orkney Islands',NULL),
	 ('OXF','GB','Oxfordshire',NULL),
	 ('PKN','GB','Perth and Kinross',NULL),
	 ('POW','GB','Powys',NULL),
	 ('RFW','GB','Renfrewshire',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('RUT','GB','Rutland',NULL),
	 ('SAY','GB','South Ayrshire',NULL),
	 ('SCB','GB','Scottish Borders',NULL),
	 ('SFK','GB','Suffolk',NULL),
	 ('SGC','GB','South Gloucestershire',NULL),
	 ('SGM','GB','South Glamorgan',NULL),
	 ('SHR','GB','Shropshire',NULL),
	 ('SLK','GB','South Lanarkshire',NULL),
	 ('SOM','GB','Somerset',NULL),
	 ('SRY','GB','Surrey',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('STG','GB','Stirling',NULL),
	 ('STS','GB','Staffordshire',NULL),
	 ('SYK','GB','South Yorkshire',NULL),
	 ('TWR','GB','Tyne and Wear',NULL),
	 ('TYR','GB','Co Tyrone',NULL),
	 ('VGL','GB','Mid Glamorgan',NULL),
	 ('WAR','GB','Warwickshire',NULL),
	 ('WDU','GB','West Dunbartonshire',NULL),
	 ('WGM','GB','West Glamorgan',NULL),
	 ('WIL','GB','Wiltshire',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('WLN','GB','West Lothian',NULL),
	 ('WMD','GB','West Midlands',NULL),
	 ('WOR','GB','Worcestershire',NULL),
	 ('WSX','GB','West Sussex',NULL),
	 ('WYK','GB','West Yorkshire',NULL),
	 ('ZET','GB','Shetland Islands',NULL),
	 ('AA','GH','Greater Accra',NULL),
	 ('AH','GH','Ashanti',NULL),
	 ('BA','GH','Brong-Ahafo',NULL),
	 ('TV','GH','Volta',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('UE','GH','Upper East',NULL),
	 ('UW','GH','Upper West',NULL),
	 ('B','GM','Banjul',NULL),
	 ('L','GM','Lower River',NULL),
	 ('M','GM','MacCarthy Island',NULL),
	 ('N','GM','North Bank',NULL),
	 ('U','GM','Upper River',NULL),
	 ('BE','GN','Beyla',NULL),
	 ('BF','GN','Boffa',NULL),
	 ('BK','GN','Boke',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('CO','GN','Coyah',NULL),
	 ('DB','GN','Dabola',NULL),
	 ('DI','GN','Dinguiraye',NULL),
	 ('DL','GN','Dalaba',NULL),
	 ('DU','GN','Dubreka',NULL),
	 ('FA','GN','Faranah',NULL),
	 ('FO','GN','Forecariah',NULL),
	 ('FR','GN','Fria',NULL),
	 ('GA','GN','Gaoual',NULL),
	 ('GU','GN','Guekedou',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('KA','GN','Kankan',NULL),
	 ('KB','GN','Koubia',NULL),
	 ('KD','GN','Kindia',NULL),
	 ('KE','GN','Kerouane',NULL),
	 ('KN','GN','Koundara',NULL),
	 ('KO','GN','Kouroussa',NULL),
	 ('KS','GN','Kissidougou',NULL),
	 ('LA','GN','Labe',NULL),
	 ('LE','GN','Lelouma',NULL),
	 ('LO','GN','Lola',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('MC','GN','Macenta',NULL),
	 ('MD','GN','Mandiana',NULL),
	 ('ML','GN','Mali',NULL),
	 ('MM','GN','Mamou',NULL),
	 ('NZ','GN','Nzerekore',NULL),
	 ('PI','GN','Pita',NULL),
	 ('SI','GN','Siguiri',NULL),
	 ('TE','GN','Telimele',NULL),
	 ('TO','GN','Tougue',NULL),
	 ('YO','GN','Yomou',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('AN','GQ','Annobon',NULL),
	 ('BN','GQ','Bioko Norte',NULL),
	 ('BS','GQ','Bioko Sur',NULL),
	 ('C','GQ','Region Continental',NULL),
	 ('CS','GQ','Centro Sur',NULL),
	 ('I','GQ','Region Insular',NULL),
	 ('KN','GQ','Kie-Ntem',NULL),
	 ('LI','GQ','Litoral',NULL),
	 ('WN','GQ','Wele-Nzas',NULL),
	 ('1','GR','Aitolia-Akarnania',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('11','GR','Argolis',NULL),
	 ('12','GR','Arkadia',NULL),
	 ('13','GR','Acha?a',NULL),
	 ('14','GR','Ileia',NULL),
	 ('15','GR','Korinthia',NULL),
	 ('16','GR','Lakonia',NULL),
	 ('17','GR','Messinia',NULL),
	 ('21','GR','Zakynthos',NULL),
	 ('22','GR','Kerkyra',NULL),
	 ('23','GR','Kefallinia',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('24','GR','Lefkas',NULL),
	 ('3','GR','Voiotia',NULL),
	 ('31','GR','Arta',NULL),
	 ('32','GR','Thesprotia',NULL),
	 ('33','GR','Ioannina',NULL),
	 ('34','GR','Preveza',NULL),
	 ('4','GR','Evvoia',NULL),
	 ('41','GR','Karditsa',NULL),
	 ('42','GR','Larisa',NULL),
	 ('43','GR','Magnisia',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('44','GR','Trikala',NULL),
	 ('5','GR','Evrytania',NULL),
	 ('51','GR','Grevena',NULL),
	 ('52','GR','Drama',NULL),
	 ('53','GR','Imathia',NULL),
	 ('54','GR','Thessaloniki',NULL),
	 ('55','GR','Kavalla',NULL),
	 ('56','GR','Kastoria',NULL),
	 ('57','GR','Kilkis',NULL),
	 ('58','GR','Kozani',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('59','GR','Pella',NULL),
	 ('6','GR','Fthiotis',NULL),
	 ('62','GR','Serrai',NULL),
	 ('63','GR','Florina',NULL),
	 ('64','GR','Chalkidiki',NULL),
	 ('69','GR','Agio Oros',NULL),
	 ('7','GR','Fokis',NULL),
	 ('71','GR','Evros',NULL),
	 ('72','GR','Xanthi',NULL),
	 ('73','GR','Rodopi',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('81','GR','Dodekanisos',NULL),
	 ('82','GR','Kyklades',NULL),
	 ('83','GR','Lesvos',NULL),
	 ('84','GR','Samos',NULL),
	 ('85','GR','Chios',NULL),
	 ('91','GR','Irakleion',NULL),
	 ('92','GR','Lasithion',NULL),
	 ('93','GR','Rethymnon',NULL),
	 ('94','GR','Chania',NULL),
	 ('A1','GR','Attiki',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('AV','GT','Alta Verapez',NULL),
	 ('BV','GT','Baja Verapez',NULL),
	 ('CM','GT','Chimaltenango',NULL),
	 ('CQ','GT','Chiquimula',NULL),
	 ('ES','GT','Escuintla',NULL),
	 ('GU','GT','Guatemala',NULL),
	 ('HU','GT','Huehuetenango',NULL),
	 ('IZ','GT','Izabal',NULL),
	 ('JA','GT','Jalapa',NULL),
	 ('JU','GT','Jutiapa',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('PE','GT','Peten',NULL),
	 ('PR','GT','El Progreso',NULL),
	 ('QC','GT','Quiche',NULL),
	 ('QZ','GT','Quetzaltenango',NULL),
	 ('RE','GT','Reta.thuleu',NULL),
	 ('SA','GT','Sacatepequez',NULL),
	 ('SM','GT','San Marcos',NULL),
	 ('SO','GT','Solol6',NULL),
	 ('SR','GT','Santa Rosa',NULL),
	 ('SU','GT','Suchitepequez',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('TO','GT','Totonicapan',NULL),
	 ('ZA','GT','Zacapa',NULL),
	 ('BA','GW','Bafata',NULL),
	 ('BL','GW','Bolama',NULL),
	 ('BM','GW','Biombo',NULL),
	 ('BS','GW','Bissau',NULL),
	 ('CA','GW','Cacheu',NULL),
	 ('GA','GW','Gabu',NULL),
	 ('OI','GW','Oio',NULL),
	 ('QU','GW','Quloara',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('TO','GW','Tombali S',NULL),
	 ('BA','GY','Barima-Waini',NULL),
	 ('CU','GY','Cuyuni-Mazaruni',NULL),
	 ('DE','GY','Demerara-Mahaica',NULL),
	 ('EB','GY','East Berbice-Corentyne',NULL),
	 ('ES','GY','Essequibo Islands-West Demerara',NULL),
	 ('MA','GY','Mahaica-Berbice',NULL),
	 ('PM','GY','Pomeroon-Supenaam',NULL),
	 ('PT','GY','Potaro-Siparuni',NULL),
	 ('UD','GY','Upper Demerara-Berbice',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('UT','GY','Upper Takutu-Upper Essequibo',NULL),
	 ('CW','HK','Central and Western',NULL),
	 ('EA','HK','Eastern',NULL),
	 ('IS','HK','Islands',NULL),
	 ('KC','HK','Kowloon City',NULL),
	 ('KI','HK','Kwai Tsing',NULL),
	 ('KU','HK','Kwun Tong',NULL),
	 ('NO','HK','North',NULL),
	 ('SK','HK','Sai Kung',NULL),
	 ('SO','HK','Southern',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('SS','HK','Sham Shui Po',NULL),
	 ('ST','HK','Sha Tin',NULL),
	 ('TM','HK','Tuen Mun',NULL),
	 ('TP','HK','Tai Po',NULL),
	 ('TW','HK','Tsuen Wan',NULL),
	 ('WC','HK','Wan Chai',NULL),
	 ('WT','HK','Wong Tai Sin',NULL),
	 ('YL','HK','Yuen Long',NULL),
	 ('YT','HK','Yau Tsim Mong',NULL),
	 ('AT','HN','Atlantida',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('CH','HN','Choluteca',NULL),
	 ('CL','HN','Colon',NULL),
	 ('CM','HN','Comayagua',NULL),
	 ('CP','HN','Copan',NULL),
	 ('CR','HN','Cortes',NULL),
	 ('EP','HN','El Paraiso',NULL),
	 ('FM','HN','Francisco Morazan',NULL),
	 ('GD','HN','Gracias a Dios',NULL),
	 ('IB','HN','Islas de la Bahia',NULL),
	 ('IN','HN','Intibuca',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('LE','HN','Lempira',NULL),
	 ('OC','HN','Ocotepeque',NULL),
	 ('OL','HN','Olancho',NULL),
	 ('SB','HN','Santa Barbara',NULL),
	 ('VA','HN','Valle',NULL),
	 ('YO','HN','Yoro',NULL),
	 ('1','HR','Zagrebacka zupanija',NULL),
	 ('10','HR','VirovitiEko-podravska zupanija',NULL),
	 ('11','HR','Pozesko-slavonska zupanija',NULL),
	 ('12','HR','Brodsko-posavska zupanija',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('13','HR','Zadaraka',NULL),
	 ('14','HR','Osjecko-baranjska zupanija',NULL),
	 ('15','HR','Sibenako-kninska zupanija',NULL),
	 ('16','HR','VuRovarako-srijemska zupanija',NULL),
	 ('17','HR','Splitako-dalmatinska zupanija',NULL),
	 ('18','HR','Istarska zupanija',NULL),
	 ('19','HR','Dubrovacko-neretvanska zupanija',NULL),
	 ('2','HR','Krapinako-zagorska zupanija',NULL),
	 ('20','HR','Medimurska zupanija',NULL),
	 ('3','HR','Sisacko-moelavacka Iupanija',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('4','HR','Karlovacka zupanija',NULL),
	 ('5','HR','Varaidinska zupanija',NULL),
	 ('6','HR','Koprivnickco-krizevacka zupanija',NULL),
	 ('7','HR','Bjelovarsko-bilogorska zupanija',NULL),
	 ('8','HR','Primorsko-goranska zupanija',NULL),
	 ('9','HR','Licko-senjska zupanija',NULL),
	 ('AR','HT','Artibonite',NULL),
	 ('CE','HT','Centre',NULL),
	 ('GA','HT','Grande-Anse',NULL),
	 ('ND','HT','Nord',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('NE','HT','Nord-Est',NULL),
	 ('NI','HT','Nippes',NULL),
	 ('NO','HT','Nord-Ouest',NULL),
	 ('OU','HT','Ouest',NULL),
	 ('SD','HT','Sud',NULL),
	 ('SE','HT','Sud-Est',NULL),
	 ('BA','HU','Baranya',NULL),
	 ('BC','HU','Békéscsaba',NULL),
	 ('BE','HU','Békés',NULL),
	 ('BK','HU','Bács-Kiskun',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('BU','HU','Budapest',NULL),
	 ('BZ','HU','Borsod-Abaúj-Zemplén',NULL),
	 ('CS','HU','Csongrád',NULL),
	 ('DE','HU','Debrecen',NULL),
	 ('DU','HU','Dunaújváros',NULL),
	 ('EG','HU','Eger',NULL),
	 ('FE','HU','Fejér',NULL),
	 ('GS','HU','Gyõr-Moson-Sopron',NULL),
	 ('GY','HU','Gyõr',NULL),
	 ('HB','HU','Hajdu-Bihar',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('HE','HU','Heves',NULL),
	 ('HV','HU','Hódmezõvásárhely',NULL),
	 ('JN','HU','Jász-Nagykun-Szolnok',NULL),
	 ('KE','HU','Komárom-Esztergom',NULL),
	 ('KM','HU','Kecskemét',NULL),
	 ('KV','HU','Kaposvár',NULL),
	 ('MI','HU','Miskolc',NULL),
	 ('NK','HU','Nagykanizsa',NULL),
	 ('NO','HU','Nográd',NULL),
	 ('NY','HU','Nyiregyháza',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('PE','HU','Pest',NULL),
	 ('PS','HU','Pécs',NULL),
	 ('SD','HU','Szeged',NULL),
	 ('SF','HU','Székesfehérvár',NULL),
	 ('SH','HU','Szombathely',NULL),
	 ('SK','HU','Szolnok',NULL),
	 ('SN','HU','Sopron',NULL),
	 ('SO','HU','Somogy',NULL),
	 ('SS','HU','Szekszárd',NULL),
	 ('ST','HU','Salgótarján',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('SZ','HU','Szabolcs-Szatmár-Bereg',NULL),
	 ('TB','HU','Tatabánya',NULL),
	 ('TO','HU','Tolna',NULL),
	 ('VA','HU','Vas',NULL),
	 ('VE','HU','Veszprém',NULL),
	 ('ZA','HU','Zala',NULL),
	 ('ZE','HU','Zalaegerszeg',NULL),
	 ('AC','ID','Aceh',NULL),
	 ('BA','ID','Bali',NULL),
	 ('BB','ID','Bangka Belitung',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('BE','ID','Bengkulu',NULL),
	 ('BT','ID','Banten',NULL),
	 ('GO','ID','Gorontalo',NULL),
	 ('IJ','ID','Irian Jaya',NULL),
	 ('JA','ID','Jambi',NULL),
	 ('JB','ID','Jawa Barat',NULL),
	 ('JI','ID','Jawa Timur',NULL),
	 ('JK','ID','Jakarta Raya',NULL),
	 ('JT','ID','Jawa Tengah',NULL),
	 ('KB','ID','Kalimantan Barat',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('KR','ID','Kepulauan Riau',NULL),
	 ('KS','ID','Kalimantan Selatan',NULL),
	 ('KT','ID','Kalimantan Timur',NULL),
	 ('LA','ID','Lampung',NULL),
	 ('MA','ID','Maluku',NULL),
	 ('MU','ID','Maluku Utara',NULL),
	 ('NB','ID','Nusa Tenggara Barat',NULL),
	 ('NT','ID','Nusa Tenggara Timur',NULL),
	 ('PA','ID','Papua',NULL),
	 ('RI','ID','Riau',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('SA','ID','Sulawesi Utara',NULL),
	 ('SB','ID','Sumatra Barat',NULL),
	 ('SG','ID','Sulawesi Tenggara',NULL),
	 ('SN','ID','Sulawesi Selatan',NULL),
	 ('SS','ID','Sumatra Selatan',NULL),
	 ('ST','ID','Sulawesi Tengah',NULL),
	 ('SU','ID','Sumatera Utara',NULL),
	 ('YO','ID','Yogyakarta',NULL),
	 ('C','IE','Cork',NULL),
	 ('CE','IE','Clare',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('CN','IE','Cavan',NULL),
	 ('CW','IE','Carlow',NULL),
	 ('D','IE','Dublin',NULL),
	 ('DL','IE','Donegal',NULL),
	 ('G','IE','Galway',NULL),
	 ('KE','IE','Kildare',NULL),
	 ('KK','IE','Kilkenny',NULL),
	 ('KY','IE','Kerry',NULL),
	 ('LD','IE','Longford',NULL),
	 ('LH','IE','Louth',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('LK','IE','Limerick',NULL),
	 ('LM','IE','Leitrim',NULL),
	 ('LS','IE','Laois',NULL),
	 ('MH','IE','Meath',NULL),
	 ('MN','IE','Monaghan',NULL),
	 ('MO','IE','Mayo',NULL),
	 ('OY','IE','Offaly',NULL),
	 ('RN','IE','Roscommon',NULL),
	 ('SO','IE','Sligo',NULL),
	 ('TA','IE','Tipperary',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('WD','IE','Waterford',NULL),
	 ('WH','IE','Westmeath',NULL),
	 ('WW','IE','Wicklow',NULL),
	 ('WX','IE','Wexford',NULL),
	 ('D','IL','HaDarom',NULL),
	 ('HA','IL','Haifa',NULL),
	 ('JM','IL','Jerusalem',NULL),
	 ('M','IL','HaMerkaz',NULL),
	 ('TA','IL','Tel-Aviv',NULL),
	 ('Z','IL','HaZafon',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('AN','IN','Andaman and Nicobar Islands',NULL),
	 ('AP','IN','Andhra Pradesh',NULL),
	 ('AR','IN','Arunachal Pradesh',NULL),
	 ('AS','IN','Assam',NULL),
	 ('BR','IN','Bihar',NULL),
	 ('CH','IN','Chhattisgarh',NULL),
	 ('DD','IN','Daman and Diu',NULL),
	 ('DL','IN','Delhi',NULL),
	 ('DN','IN','Dadra and Nagar Haveli',NULL),
	 ('GA','IN','Goa',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('GJ','IN','Gujarat',NULL),
	 ('HP','IN','Himachal Pradesh',NULL),
	 ('HR','IN','Haryana',NULL),
	 ('JH','IN','Jharkhand',NULL),
	 ('JK','IN','Jammu and Kashmir',NULL),
	 ('KA','IN','Karnataka',NULL),
	 ('KL','IN','Kerala',NULL),
	 ('LD','IN','Lakshadweep',NULL),
	 ('ML','IN','Meghalaya',NULL),
	 ('MM','IN','Maharashtra',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('MN','IN','Manipur',NULL),
	 ('MP','IN','Madhya Pradesh',NULL),
	 ('MZ','IN','Mizoram',NULL),
	 ('NL','IN','Nagaland',NULL),
	 ('OR','IN','Orissa',NULL),
	 ('PB','IN','Punjab',NULL),
	 ('PY','IN','Pondicherry',NULL),
	 ('RJ','IN','Rajasthan',NULL),
	 ('SK','IN','Sikkim',NULL),
	 ('TN','IN','Tamil Nadu',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('TR','IN','Tripura',NULL),
	 ('UL','IN','Uttaranchal',NULL),
	 ('UP','IN','Uttar Pradesh',NULL),
	 ('WB','IN','West Bengal',NULL),
	 ('AN','IQ','Al Anbar',NULL),
	 ('AR','IQ','Arbil',NULL),
	 ('BA','IQ','Al Ba,rah',NULL),
	 ('BB','IQ','Babil',NULL),
	 ('BG','IQ','Baghdad',NULL),
	 ('DA','IQ','Dahuk',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('DI','IQ','Diyala',NULL),
	 ('DQ','IQ','Dhi Qar',NULL),
	 ('KA','IQ','Karbala''',NULL),
	 ('MA','IQ','Maysan',NULL),
	 ('MU','IQ','Al Muthanna',NULL),
	 ('NA','IQ','An Najef',NULL),
	 ('NI','IQ','Ninawa',NULL),
	 ('QA','IQ','Al Qadisiyah',NULL),
	 ('SD','IQ','Salah ad Din',NULL),
	 ('SW','IQ','As Sulaymaniyah',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('TS','IQ','At Ta''mim',NULL),
	 ('WA','IQ','Wasit',NULL),
	 ('1','IR','Azarbayjan-e Sharqi',NULL),
	 ('10','IR','Khuzestan',NULL),
	 ('11','IR','Zanjan',NULL),
	 ('12','IR','Semnan',NULL),
	 ('13','IR','Sistan va Baluchestan',NULL),
	 ('14','IR','Fars',NULL),
	 ('15','IR','Kerman',NULL),
	 ('16','IR','Kordestan',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('17','IR','Kermanshah',NULL),
	 ('18','IR','Kohjiluyeh va Buyer Ahmad',NULL),
	 ('19','IR','Gilan',NULL),
	 ('2','IR','Azarbayjan-e Gharbi',NULL),
	 ('20','IR','Lorestan',NULL),
	 ('21','IR','Mazandaran',NULL),
	 ('22','IR','Markazi',NULL),
	 ('23','IR','Hormozgan',NULL),
	 ('24','IR','Hamadan',NULL),
	 ('25','IR','Yazd',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('26','IR','Qom',NULL),
	 ('27','IR','Golestan',NULL),
	 ('28','IR','Qazvin',NULL),
	 ('3','IR','Ardabil',NULL),
	 ('4','IR','Esfahan',NULL),
	 ('5','IR','Iiam',NULL),
	 ('6','IR','Bushehr',NULL),
	 ('7','IR','Tehran',NULL),
	 ('8','IR','Chahar Mahall va Bakhtiari',NULL),
	 ('9','IR','Khorasan',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('0','IS','Reykjavik',NULL),
	 ('1','IS','Hofuoborgarsvaeoi utan Reykjavikur',NULL),
	 ('2','IS','Suournes',NULL),
	 ('3','IS','Vesturland',NULL),
	 ('4','IS','Vestfirolr',NULL),
	 ('5','IS','Norourland vestra',NULL),
	 ('6','IS','Norourland eystra',NULL),
	 ('7','IS','Austurland',NULL),
	 ('8','IS','Suourland',NULL),
	 ('AG','IT','Agrigento',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('AL','IT','Alessandria',NULL),
	 ('AN','IT','Ancona',NULL),
	 ('AO','IT','Aosta',NULL),
	 ('AP','IT','Ascoli Piceno',NULL),
	 ('AQ','IT','L''Aquila',NULL),
	 ('AR','IT','Arezzo',NULL),
	 ('AT','IT','Asti',NULL),
	 ('AV','IT','Avellino',NULL),
	 ('BA','IT','Bari',NULL),
	 ('Bar','IT','Barletta-Andria-Trani',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('BG','IT','Bergamo',NULL),
	 ('BI','IT','Biella',NULL),
	 ('BL','IT','Belluno',NULL),
	 ('BN','IT','Benevento',NULL),
	 ('BO','IT','Bologna',NULL),
	 ('BR','IT','Brindisi',NULL),
	 ('BS','IT','Brescia',NULL),
	 ('BZ','IT','Bolzano',NULL),
	 ('CA','IT','Cagliari',NULL),
	 ('CB','IT','Campobasso',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('CE','IT','Caserta',NULL),
	 ('CH','IT','Chieti',NULL),
	 ('CI','IT','Carbonia-Iglesias',NULL),
	 ('CL','IT','Caltanissetta',NULL),
	 ('CN','IT','Cuneo',NULL),
	 ('CO','IT','Como',NULL),
	 ('CR','IT','Cremona',NULL),
	 ('CS','IT','Cosenza',NULL),
	 ('CT','IT','Catania',NULL),
	 ('CZ','IT','Catanzaro',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('EN','IT','Enna',NULL),
	 ('FC','IT','Forl?-Cesena',NULL),
	 ('FE','IT','Ferrara',NULL),
	 ('Fer','IT','Fermo',NULL),
	 ('FG','IT','Foggia',NULL),
	 ('FI','IT','Firenze',NULL),
	 ('FR','IT','Frosinone',NULL),
	 ('GE','IT','Genova',NULL),
	 ('GO','IT','Gorizia',NULL),
	 ('GR','IT','Grosseto',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('IM','IT','Imperia',NULL),
	 ('IS','IT','Isernia',NULL),
	 ('KR','IT','Crotone',NULL),
	 ('LC','IT','Lecco',NULL),
	 ('LE','IT','Lecce',NULL),
	 ('LI','IT','Livorno',NULL),
	 ('LO','IT','Lodi',NULL),
	 ('LT','IT','Latina',NULL),
	 ('LU','IT','Lucca',NULL),
	 ('MC','IT','Macerata',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('ME','IT','Messina',NULL),
	 ('MI','IT','Milano',NULL),
	 ('MN','IT','Mantova',NULL),
	 ('MO','IT','Modena',NULL),
	 ('Mon','IT','Monza e Brianza',NULL),
	 ('MS','IT','Massa-Carrara',NULL),
	 ('MT','IT','Matera',NULL),
	 ('NA','IT','Napoli',NULL),
	 ('NO','IT','Novara',NULL),
	 ('NU','IT','Nuoro',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('OG','IT','Ogliastra',NULL),
	 ('OR','IT','Oristano',NULL),
	 ('OT','IT','Olbia-Tempio',NULL),
	 ('PA','IT','Palermo',NULL),
	 ('PC','IT','Piacenza',NULL),
	 ('PD','IT','Padova',NULL),
	 ('PE','IT','Pescara',NULL),
	 ('PG','IT','Perugia',NULL),
	 ('PI','IT','Pisa',NULL),
	 ('PN','IT','Pordenone',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('PO','IT','Prato',NULL),
	 ('PR','IT','Parma',NULL),
	 ('PT','IT','Pistoia',NULL),
	 ('PU','IT','Pesaro e Urbino',NULL),
	 ('PV','IT','Pavia',NULL),
	 ('PZ','IT','Potenza',NULL),
	 ('RA','IT','Ravenna',NULL),
	 ('RC','IT','Reggio Calabria',NULL),
	 ('RE','IT','Reggio Emilia',NULL),
	 ('RG','IT','Ragusa',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('RI','IT','Rieti',NULL),
	 ('RM','IT','Roma',NULL),
	 ('RN','IT','Rimini',NULL),
	 ('RO','IT','Rovigo',NULL),
	 ('SA','IT','Salerno',NULL),
	 ('SI','IT','Siena',NULL),
	 ('SO','IT','Sondrio',NULL),
	 ('SP','IT','La Spezia',NULL),
	 ('SR','IT','Siracusa',NULL),
	 ('SS','IT','Sassari',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('SV','IT','Savona',NULL),
	 ('TA','IT','Taranto',NULL),
	 ('TE','IT','Teramo',NULL),
	 ('TN','IT','Trento',NULL),
	 ('TO','IT','Torino',NULL),
	 ('TP','IT','Trapani',NULL),
	 ('TR','IT','Terni',NULL),
	 ('TS','IT','Trieste',NULL),
	 ('TV','IT','Treviso',NULL),
	 ('UD','IT','Udine',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('VA','IT','Varese',NULL),
	 ('VB','IT','Verbano-Cusio-Ossola',NULL),
	 ('VC','IT','Vercelli',NULL),
	 ('VE','IT','Venezia',NULL),
	 ('VI','IT','Vicenza',NULL),
	 ('VR','IT','Verona',NULL),
	 ('VS','IT','Medio Campidano',NULL),
	 ('VT','IT','Viterbo',NULL),
	 ('VV','IT','Vibo Valentia',NULL),
	 ('AN','JM','Saint Ann',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('AW','JM','Saint Andrew',NULL),
	 ('CE','JM','Saint Catherine',NULL),
	 ('CN','JM','Clarendon',NULL),
	 ('EH','JM','Saint Elizabeth',NULL),
	 ('HR','JM','Hanover',NULL),
	 ('JS','JM','Saint James',NULL),
	 ('KN','JM','Kingston',NULL),
	 ('MR','JM','Manchester',NULL),
	 ('MY','JM','Saint Mary',NULL),
	 ('PD','JM','Portland',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('TS','JM','Saint Thomas',NULL),
	 ('TY','JM','Trelawny',NULL),
	 ('WD','JM','Westmoreland',NULL),
	 ('AJ','JO','Ajln',NULL),
	 ('AM','JO','Amman',NULL),
	 ('AQ','JO','Al ''Aqaba',NULL),
	 ('AT','JO','At Tafilah',NULL),
	 ('AZ','JO','Az Zarga',NULL),
	 ('BA','JO','Al Balqa''',NULL),
	 ('JA','JO','Jarash',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('JR','JO','Irbid',NULL),
	 ('KA','JO','Al Karak',NULL),
	 ('MA','JO','Al Mafraq',NULL),
	 ('MD','JO','Madaba',NULL),
	 ('MN','JO','Ma''an',NULL),
	 ('1','JP','Hokkaido',NULL),
	 ('10','JP','Gunma',NULL),
	 ('11','JP','Saitama',NULL),
	 ('12','JP','Chiba',NULL),
	 ('13','JP','Tokyo',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('14','JP','Kanagawa',NULL),
	 ('15','JP','Niigata',NULL),
	 ('16','JP','Toyama',NULL),
	 ('17','JP','Ishikawa',NULL),
	 ('18','JP','Fukui',NULL),
	 ('19','JP','Yamanashi',NULL),
	 ('2','JP','Aomori',NULL),
	 ('20','JP','Nagano',NULL),
	 ('21','JP','Gifu',NULL),
	 ('22','JP','Shizuoka',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('23','JP','Aichi',NULL),
	 ('24','JP','Mie',NULL),
	 ('25','JP','Shiga',NULL),
	 ('26','JP','Kyoto',NULL),
	 ('27','JP','Osaka',NULL),
	 ('28','JP','Hyogo',NULL),
	 ('29','JP','Nara',NULL),
	 ('3','JP','Iwate',NULL),
	 ('30','JP','Wakayama',NULL),
	 ('31','JP','Tottori',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('32','JP','Shimane',NULL),
	 ('33','JP','Okayama',NULL),
	 ('34','JP','Hiroshima',NULL),
	 ('35','JP','Yamaguchi',NULL),
	 ('36','JP','Tokushima',NULL),
	 ('37','JP','Kagawa',NULL),
	 ('38','JP','Ehime',NULL),
	 ('39','JP','Kochi',NULL),
	 ('4','JP','Miyagi',NULL),
	 ('40','JP','Fukuoka',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('41','JP','Saga',NULL),
	 ('42','JP','Nagasaki',NULL),
	 ('43','JP','Kumamoto',NULL),
	 ('44','JP','Oita',NULL),
	 ('45','JP','Miyazaki',NULL),
	 ('46','JP','Kagoshima',NULL),
	 ('47','JP','Okinawa',NULL),
	 ('5','JP','Akita',NULL),
	 ('6','JP','Yamagata',NULL),
	 ('7','JP','Fukusima',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('8','JP','Ibaraki',NULL),
	 ('9','JP','Tochigi',NULL),
	 ('110','KE','Nairobi Municipality',NULL),
	 ('300','KE','Coast',NULL),
	 ('500','KE','North-Eastern Kaskazini Mashariki',NULL),
	 ('700','KE','Rift Valley',NULL),
	 ('900','KE','Western Magharibi',NULL),
	 ('B','KG','Batken',NULL),
	 ('C','KG','Chu',NULL),
	 ('GB','KG','Bishkek',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('J','KG','Jalal-Abad',NULL),
	 ('N','KG','Naryn',NULL),
	 ('O','KG','Osh',NULL),
	 ('T','KG','Talas',NULL),
	 ('Y','KG','Ysyk-Kol',NULL),
	 ('1','KH','Banteay Mean Chey',NULL),
	 ('10','KH','Krachoh',NULL),
	 ('11','KH','Mondol Kiri',NULL),
	 ('12','KH','Phnom Penh',NULL),
	 ('13','KH','Preah Vihear',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('14','KH','Prey Veaeng',NULL),
	 ('15','KH','Pousaat',NULL),
	 ('16','KH','Rotanak Kiri',NULL),
	 ('17','KH','Siem Reab',NULL),
	 ('18','KH','Xrong Preah Sihanouk',NULL),
	 ('19','KH','Stueng Traeng',NULL),
	 ('2','KH','Baat Dambang',NULL),
	 ('20','KH','Svaay Rieng',NULL),
	 ('21','KH','Taakaev',NULL),
	 ('22','KH','Otdar Mean Chey',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('23','KH','Krong Kaeb',NULL),
	 ('24','KH','Krong Pailin',NULL),
	 ('3','KH','Rampong Chaam',NULL),
	 ('4','KH','Kampong Chhnang',NULL),
	 ('5','KH','Kampong Spueu',NULL),
	 ('6','KH','Kampong Thum',NULL),
	 ('7','KH','Kampot',NULL),
	 ('8','KH','Kandaal',NULL),
	 ('9','KH','Kach Kong',NULL),
	 ('G','KI','Gilbert Islands',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('L','KI','Line Islands',NULL),
	 ('P','KI','Phoenix Islands',NULL),
	 ('A','KM','Anjouan Ndzouani',NULL),
	 ('G','KM','Grande Comore Ngazidja',NULL),
	 ('M','KM','Moheli Moili',NULL),
	 ('CHA','KP','Chagang-do',NULL),
	 ('HAB','KP','Hamgyongbuk-do',NULL),
	 ('HAN','KP','Hamgyongnam-do',NULL),
	 ('HWB','KP','Hwanghaebuk-do',NULL),
	 ('HWN','KP','Hwanghaenam-do',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('KAE','KP','Kaesong-si',NULL),
	 ('KAN','KP','Kangwon-do',NULL),
	 ('NAJ','KP','Najin Sonbong-si',NULL),
	 ('NAM','KP','Nampo-si',NULL),
	 ('PYB','KP','Pyonganbuk-do',NULL),
	 ('PYN','KP','Pyongannam-do',NULL),
	 ('PYO','KP','Pyongyang-ai',NULL),
	 ('YAN','KP','Yanggang-do',NULL),
	 ('11','KR','Seoul Teugbyeolsi',NULL),
	 ('26','KR','Busan Gwang''yeogsi',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('27','KR','Daegu Gwang''yeogsi',NULL),
	 ('28','KR','Incheon Gwang''yeogsi',NULL),
	 ('29','KR','Gwangju Gwang''yeogsi',NULL),
	 ('30','KR','Daejeon Gwang''yeogsi',NULL),
	 ('31','KR','Ulsan Gwang''yeogsi',NULL),
	 ('41','KR','Gyeonggido',NULL),
	 ('42','KR','Gang''weondo',NULL),
	 ('43','KR','Chungcheongbugdo',NULL),
	 ('44','KR','Chungcheongnamdo',NULL),
	 ('45','KR','Jeonrabugdo',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('46','KR','Jeonranamdo',NULL),
	 ('47','KR','Gyeongsangbugdo',NULL),
	 ('48','KR','Gyeongsangnamdo',NULL),
	 ('49','KR','Jejudo',NULL),
	 ('AH','KW','Al Ahmadi',NULL),
	 ('FA','KW','Al Farwanlyah',NULL),
	 ('HA','KW','Hawalli',NULL),
	 ('JA','KW','Al Jahrah',NULL),
	 ('KU','KW','Al Kuwayt',NULL),
	 ('AKM','KZ','Aqmola oblysy',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('AKT','KZ','Aqtobe oblysy',NULL),
	 ('ALA','KZ','Almaty',NULL),
	 ('ALM','KZ','Almaty oblysy',NULL),
	 ('AST','KZ','Astana',NULL),
	 ('ATY','KZ','Atyrau oblyfiy',NULL),
	 ('KAR','KZ','Qaraghandy oblysy',NULL),
	 ('KUS','KZ','Qostanay oblysy',NULL),
	 ('KZY','KZ','Qyzylorda oblysy',NULL),
	 ('MAN','KZ','Mangghystau oblysy',NULL),
	 ('PAV','KZ','Pavlodar oblysy',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('SEV','KZ','Soltustik Quzaqstan oblysy',NULL),
	 ('VOS','KZ','Shyghys Quzaqstan oblysy',NULL),
	 ('YUZ','KZ','Ongtustik Quzaqstan oblysy',NULL),
	 ('ZAP','KZ','Batys Quzaqstan oblysy',NULL),
	 ('ZHA','KZ','Zhambyl oblysy Zhambylskaya oblast''',NULL),
	 ('AT','LA','Attapu',NULL),
	 ('BK','LA','Bokeo',NULL),
	 ('BL','LA','Bolikhamxai',NULL),
	 ('CH','LA','Champasak',NULL),
	 ('HO','LA','Houaphan',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('KH','LA','Khammouan',NULL),
	 ('LM','LA','Louang Namtha',NULL),
	 ('LP','LA','Louangphabang',NULL),
	 ('OU','LA','Oudomxai',NULL),
	 ('PH','LA','Phongsali',NULL),
	 ('SL','LA','Salavan',NULL),
	 ('SV','LA','Savannakhet',NULL),
	 ('VT','LA','Vientiane',NULL),
	 ('XA','LA','Xaignabouli',NULL),
	 ('XE','LA','Xekong',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('XI','LA','Xiangkhoang',NULL),
	 ('XN','LA','Xiasomboun',NULL),
	 ('AS','LB','Loubnane ech Chemali',NULL),
	 ('BA','LB','Beirout',NULL),
	 ('BI','LB','El Begsa',NULL),
	 ('JA','LB','Loubnane ej Jnoubi',NULL),
	 ('JL','LB','Jabal Loubnane',NULL),
	 ('NA','LB','Nabatiye',NULL),
	 ('11','LK','Colombo',NULL),
	 ('12','LK','Gampaha',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('13','LK','Kalutara',NULL),
	 ('21','LK','Kandy',NULL),
	 ('22','LK','Matale',NULL),
	 ('23','LK','Nuwara Eliya',NULL),
	 ('31','LK','Galle',NULL),
	 ('32','LK','Matara',NULL),
	 ('33','LK','Hambantota',NULL),
	 ('41','LK','Jaffna',NULL),
	 ('42','LK','Kilinochchi',NULL),
	 ('43','LK','Mannar',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('44','LK','VavunLya',NULL),
	 ('45','LK','Mullaittivu',NULL),
	 ('51','LK','Batticaloa',NULL),
	 ('52','LK','Ampara',NULL),
	 ('53','LK','Trincomalee',NULL),
	 ('61','LK','Kurunegala',NULL),
	 ('62','LK','Puttalum',NULL),
	 ('71','LK','Anuradhapura',NULL),
	 ('72','LK','Polonnaruwa',NULL),
	 ('81','LK','Badulla',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('82','LK','Monaragala',NULL),
	 ('91','LK','Ratnapura',NULL),
	 ('92','LK','Kegalla',NULL),
	 ('BG','LR','Bong',NULL),
	 ('BM','LR','Bomi',NULL),
	 ('CM','LR','Grand Cape Mount',NULL),
	 ('GB','LR','Grand Basaa',NULL),
	 ('GG','LR','Grand Gedeh',NULL),
	 ('GK','LR','Grand Kru',NULL),
	 ('LO','LR','Lofa',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('MG','LR','Margibi',NULL),
	 ('MO','LR','Montserrado',NULL),
	 ('MY','LR','Maryland',NULL),
	 ('NI','LR','Nimba',NULL),
	 ('RI','LR','Rivercess',NULL),
	 ('SI','LR','Sinoe',NULL),
	 ('A','LS','Maseru',NULL),
	 ('B','LS','Butha-Buthe',NULL),
	 ('C','LS','Leribe',NULL),
	 ('D','LS','Berea',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('E','LS','Mafeteng',NULL),
	 ('F','LS','Mohale''s Hoek',NULL),
	 ('G','LS','Quthing',NULL),
	 ('H','LS','Qacha''s Nek',NULL),
	 ('J','LS','Mokhotlong',NULL),
	 ('K','LS','Thaba-Tseka',NULL),
	 ('AL','LT','Alytaus Apskritis',NULL),
	 ('KL','LT','Klaipedos Apskritis',NULL),
	 ('KU','LT','Kauno Apskritis',NULL),
	 ('MR','LT','Marijampoles Apskritis',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('PN','LT','Panevezio Apskritis',NULL),
	 ('SA','LT','Sisuliu Apskritis',NULL),
	 ('TA','LT','Taurages Apskritis',NULL),
	 ('TE','LT','Telsiu Apskritis',NULL),
	 ('UT','LT','Utenos Apskritis',NULL),
	 ('VL','LT','Vilniaus Apskritis',NULL),
	 ('D','LU','Diekirch',NULL),
	 ('G','LU','GreveNmacher',NULL),
	 ('AI','LV','Aizkraukles Apripkis',NULL),
	 ('AL','LV','Alkanes Apripkis',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('BL','LV','Balvu Apripkis',NULL),
	 ('BU','LV','Bauskas Apripkis',NULL),
	 ('CE','LV','Cesu Aprikis',NULL),
	 ('DA','LV','Daugavpile Apripkis',NULL),
	 ('DGV','LV','Daugavpils',NULL),
	 ('DO','LV','Dobeles Apripkis',NULL),
	 ('GU','LV','Gulbenes Aprlpkis',NULL),
	 ('JEL','LV','Jelgava',NULL),
	 ('JK','LV','Jekabpils Apripkis',NULL),
	 ('JL','LV','Jelgavas Apripkis',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('JUR','LV','Jurmala',NULL),
	 ('KR','LV','Kraslavas Apripkis',NULL),
	 ('KU','LV','Kuldlgas Apripkis',NULL),
	 ('LE','LV','Liepajas Apripkis',NULL),
	 ('LM','LV','Limbazu Apripkis',NULL),
	 ('LPX','LV','Liepaja',NULL),
	 ('LU','LV','Ludzas Apripkis',NULL),
	 ('MA','LV','Madonas Apripkis',NULL),
	 ('OG','LV','Ogres Apripkis',NULL),
	 ('PR','LV','Preilu Apripkis',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('RE','LV','Rezaknes Apripkis',NULL),
	 ('REZ','LV','Rezekne',NULL),
	 ('RI','LV','Rigas Apripkis',NULL),
	 ('RIX','LV','Riga',NULL),
	 ('SA','LV','Saldus Apripkis',NULL),
	 ('TA','LV','Talsu Apripkis',NULL),
	 ('TU','LV','Tukuma Apriplcis',NULL),
	 ('VE','LV','Ventspils Apripkis',NULL),
	 ('VEN','LV','Ventspils',NULL),
	 ('VK','LV','Valkas Apripkis',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('VM','LV','Valmieras Apripkis',NULL),
	 ('AJ','LY','Ajd?biy?',NULL),
	 ('BA','LY','Bangh?z?',NULL),
	 ('BU','LY','Al Buþn?n',NULL),
	 ('BW','LY','Ban? Wal?d',NULL),
	 ('DR','LY','Darnah',NULL),
	 ('GD','LY','Ghad?mis',NULL),
	 ('GR','LY','Ghary?n',NULL),
	 ('GT','LY','Gh?t',NULL),
	 ('HZ','LY','Al Hiz?m al Akhdar',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('JA','LY','Al Jabal al Akhdar',NULL),
	 ('JB','LY','Jaghb?b',NULL),
	 ('JI','LY','Al Jif?rah',NULL),
	 ('JU','LY','Al Jufrah',NULL),
	 ('KF','LY','Al Kufrah',NULL),
	 ('MB','LY','Al Marqab',NULL),
	 ('MI','LY','Miºr?tah',NULL),
	 ('MJ','LY','Al Marj',NULL),
	 ('MQ','LY','Murzuq',NULL),
	 ('MZ','LY','Mizdah',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('NL','LY','N?l?t',NULL),
	 ('NQ','LY','An Nuqaþ al Khams',NULL),
	 ('QB','LY','Al Qubbah',NULL),
	 ('QT','LY','Al Qaþr?n',NULL),
	 ('SB','LY','Sabh?',NULL),
	 ('SH','LY','Ash Sh?þi''',NULL),
	 ('SR','LY','Surt',NULL),
	 ('SS','LY','ªabr?tah ªurm?n',NULL),
	 ('TB','LY','Þar?bulus',NULL),
	 ('TM','LY','Tarh?nah-Masall?tah',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('TN','LY','T?j?r?'' wa an Naw?h? al Arb?h',NULL),
	 ('WA','LY','Al W?hah',NULL),
	 ('WD','LY','W?d? al hay?t',NULL),
	 ('YJ','LY','Yafran-J?d?',NULL),
	 ('ZA','LY','Az Z?wiyah',NULL),
	 ('AGD','MA','Agadir',NULL),
	 ('ASZ','MA','Assa-Zag',NULL),
	 ('AZI','MA','Azilal',NULL),
	 ('BAH','MA','A?t Baha',NULL),
	 ('BEM','MA','Beni Mellal',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('BER','MA','Berkane',NULL),
	 ('BES','MA','Ben Sllmane',NULL),
	 ('BOD','MA','Boujdour',NULL),
	 ('BOM','MA','Boulemane',NULL),
	 ('CAS','MA','Casablanca  [Dar el Be?da]',NULL),
	 ('CHE','MA','Chefchaouene',NULL),
	 ('CHI','MA','Chichaoua',NULL),
	 ('ERR','MA','Errachidia',NULL),
	 ('ESI','MA','Essaouira',NULL),
	 ('ESM','MA','Es Smara',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('FES','MA','F?s',NULL),
	 ('FIG','MA','Figuig',NULL),
	 ('GUE','MA','Guelmim',NULL),
	 ('HAJ','MA','El Hajeb',NULL),
	 ('HAO','MA','Al Haouz',NULL),
	 ('HOC','MA','Al Hoce?ma',NULL),
	 ('IFR','MA','Ifrane',NULL),
	 ('JDI','MA','El Jadida',NULL),
	 ('JRA','MA','Jerada',NULL),
	 ('KEN','MA','Kénitra',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('KES','MA','Kelaat Sraghna',NULL),
	 ('KHE','MA','Khemisaet',NULL),
	 ('KHN','MA','Khenifra',NULL),
	 ('KHO','MA','Khouribga',NULL),
	 ('LAA','MA','Laâyoune (EH)',NULL),
	 ('LAP','MA','Larache',NULL),
	 ('MAR','MA','Marrakech',NULL),
	 ('MEK','MA','Mekns?s',NULL),
	 ('MEL','MA','A?t Melloul',NULL),
	 ('NAD','MA','Nador',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('OUA','MA','Ouarzazate',NULL),
	 ('OUD','MA','Oued ed Dahab (EH)',NULL),
	 ('OUJ','MA','Oujda',NULL),
	 ('RBA','MA','Rabat-Salé',NULL),
	 ('SAF','MA','Safi',NULL),
	 ('SEF','MA','Sefrou',NULL),
	 ('SET','MA','Settat',NULL),
	 ('SIK','MA','Sidl Kacem',NULL),
	 ('TAO','MA','Taounate',NULL),
	 ('TAR','MA','Taroudannt',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('TAT','MA','Tata',NULL),
	 ('TAZ','MA','Taza',NULL),
	 ('TET','MA','Tétouan',NULL),
	 ('TIZ','MA','Tiznit',NULL),
	 ('TNG','MA','Tanger',NULL),
	 ('TNT','MA','Tan-Tan',NULL),
	 ('BA','MD','Balti',NULL),
	 ('CA','MD','Cahul',NULL),
	 ('CU','MD','Chisinau',NULL),
	 ('ED','MD','Edinet',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('GA','MD','Gagauzia, Unitate Teritoriala Autonoma',NULL),
	 ('LA','MD','Lapusna',NULL),
	 ('OR','MD','Orhei',NULL),
	 ('SN','MD','Stinga Nistrului, unitatea teritoriala din',NULL),
	 ('SO','MD','Soroca',NULL),
	 ('TA','MD','Taraclia',NULL),
	 ('TI','MD','Tighina [Bender]',NULL),
	 ('UN','MD','Ungheni',NULL),
	 ('A','MG','Toamasina',NULL),
	 ('D','MG','Antsiranana',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('F','MG','Fianarantsoa',NULL),
	 ('M','MG','Mahajanga',NULL),
	 ('T','MG','Antananarivo',NULL),
	 ('U','MG','Toliara',NULL),
	 ('ALK','MH','Ailuk',NULL),
	 ('ALL','MH','Ailinglapalap',NULL),
	 ('ARN','MH','Arno',NULL),
	 ('AUR','MH','Aur',NULL),
	 ('EBO','MH','Ebon',NULL),
	 ('ENI','MH','Eniwetok',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('JAL','MH','Jaluit',NULL),
	 ('KIL','MH','Kili',NULL),
	 ('KWA','MH','Kwajalein',NULL),
	 ('LAE','MH','Lae',NULL),
	 ('LIB','MH','Lib',NULL),
	 ('LIK','MH','Likiep',NULL),
	 ('MAJ','MH','Majuro',NULL),
	 ('MAL','MH','Maloelap',NULL),
	 ('MEJ','MH','Mejit',NULL),
	 ('MIL','MH','Mili',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('NMK','MH','Namorik',NULL),
	 ('NMU','MH','Namu',NULL),
	 ('RON','MH','Rongelap',NULL),
	 ('UJA','MH','Ujae',NULL),
	 ('UJL','MH','Ujelang',NULL),
	 ('UTI','MH','Utirik',NULL),
	 ('WTJ','MH','Wotje',NULL),
	 ('WTN','MH','Wotho',NULL),
	 ('1','ML','Kayes',NULL),
	 ('2','ML','Xoulikoro',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('3','ML','Sikasso',NULL),
	 ('4','ML','S69ou',NULL),
	 ('5','ML','Mopti',NULL),
	 ('6','ML','Tombouctou',NULL),
	 ('7','ML','Gao',NULL),
	 ('8','ML','Kidal',NULL),
	 ('BK0','ML','Bamako',NULL),
	 ('1','MM','Sagaing',NULL),
	 ('11','MM','Kachin',NULL),
	 ('12','MM','Kayah',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('13','MM','Kayin',NULL),
	 ('14','MM','Chin',NULL),
	 ('15','MM','Mon',NULL),
	 ('16','MM','Rakhine',NULL),
	 ('17','MM','Shan',NULL),
	 ('2','MM','Bago',NULL),
	 ('3','MM','Magway',NULL),
	 ('4','MM','Mandalay',NULL),
	 ('5','MM','Tanintharyi',NULL),
	 ('6','MM','Yangon',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('7','MM','Ayeyarwady',NULL),
	 ('1','MN','Ulaanbaatar',NULL),
	 ('35','MN','Orhon',NULL),
	 ('37','MN','Darhan uul',NULL),
	 ('39','MN','Hentiy',NULL),
	 ('41','MN','Hovsgol',NULL),
	 ('43','MN','Hovd',NULL),
	 ('46','MN','Uvs',NULL),
	 ('47','MN','Tov',NULL),
	 ('49','MN','Selenge',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('51','MN','Shbaatar',NULL),
	 ('53','MN','Omnogovi',NULL),
	 ('55','MN','Ovorhangay',NULL),
	 ('57','MN','Dzavhan',NULL),
	 ('59','MN','DundgovL',NULL),
	 ('61','MN','Dornod',NULL),
	 ('63','MN','Dornogov,',NULL),
	 ('64','MN','Govi-Smber',NULL),
	 ('65','MN','Govi-Altay',NULL),
	 ('67','MN','Bulgan',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('69','MN','Bayanhongor',NULL),
	 ('71','MN','Bayan-Olgiy',NULL),
	 ('73','MN','Arhangay',NULL),
	 ('1','MR','Hodh ech Chargui',NULL),
	 ('10','MR','Guidimaka',NULL),
	 ('11','MR','Tiris Zemmour',NULL),
	 ('12','MR','Inchiri',NULL),
	 ('2','MR','Hodh el Charbi',NULL),
	 ('3','MR','Assaba',NULL),
	 ('4','MR','Gorgol',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('5','MR','Brakna',NULL),
	 ('6','MR','Trarza',NULL),
	 ('8','MR','Dakhlet Nouadhibou',NULL),
	 ('9','MR','Tagant',NULL),
	 ('NKC','MR','Nouakchott',NULL),
	 ('AG','MU','Agalega Islands',NULL),
	 ('BL','MU','Black River',NULL),
	 ('BR','MU','Beau Bassin-Rose Hill',NULL),
	 ('CC','MU','Cargados Carajos Shoals',NULL),
	 ('CU','MU','Curepipe',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('FL','MU','Flacq',NULL),
	 ('GP','MU','Grand Port',NULL),
	 ('MO','MU','Moka',NULL),
	 ('PA','MU','Pamplemousses',NULL),
	 ('PU','MU','Port Louis',NULL),
	 ('PW','MU','Plaines Wilhems',NULL),
	 ('QB','MU','Quatre Bornes',NULL),
	 ('RO','MU','Rodrigues Island',NULL),
	 ('RP','MU','Riviere du Rempart',NULL),
	 ('SA','MU','Savanne',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('VP','MU','Vacosa-Phoenix',NULL),
	 ('1','MV','Seenu',NULL),
	 ('12','MV','Meemu',NULL),
	 ('13','MV','Raa',NULL),
	 ('14','MV','Faafu',NULL),
	 ('17','MV','Dhaalu',NULL),
	 ('2','MV','Alif',NULL),
	 ('20','MV','Baa',NULL),
	 ('23','MV','Haa Dhaalu',NULL),
	 ('24','MV','Shaviyani',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('25','MV','Noonu',NULL),
	 ('26','MV','Kaafu',NULL),
	 ('27','MV','Gaaf Alif',NULL),
	 ('28','MV','Gaefu Dhaalu',NULL),
	 ('29','MV','Gnaviyani',NULL),
	 ('3','MV','Lhaviyani',NULL),
	 ('4','MV','Vaavu',NULL),
	 ('5','MV','Laamu',NULL),
	 ('7','MV','Haa Alif',NULL),
	 ('8','MV','Thaa',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('MLE','MV','Male',NULL),
	 ('BA','MW','Balaka',NULL),
	 ('BL','MW','Blantyre',NULL),
	 ('CK','MW','Chikwawa',NULL),
	 ('CR','MW','Chiradzulu',NULL),
	 ('CT','MW','Chitipa',NULL),
	 ('DE','MW','Dedza',NULL),
	 ('DO','MW','Dowa',NULL),
	 ('KR','MW','Karonga',NULL),
	 ('KS','MW','Kasungu',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('LI','MW','Lilongwe',NULL),
	 ('LK','MW','Likoma Island',NULL),
	 ('MC','MW','Mchinji',NULL),
	 ('MG','MW','Mangochi',NULL),
	 ('MH','MW','Machinga',NULL),
	 ('MU','MW','Mulanje',NULL),
	 ('MW','MW','Mwanza',NULL),
	 ('MZ','MW','Mzimba',NULL),
	 ('NB','MW','Nkhata Bay',NULL),
	 ('NI','MW','Ntchisi',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('NK','MW','Nkhotakota',NULL),
	 ('NS','MW','Nsanje',NULL),
	 ('NU','MW','Ntcheu',NULL),
	 ('PH','MW','Phalomba',NULL),
	 ('RU','MW','Rumphi',NULL),
	 ('SA','MW','Salima',NULL),
	 ('TH','MW','Thyolo',NULL),
	 ('ZO','MW','Zomba',NULL),
	 ('AGU','MX','Aguascalientes',NULL),
	 ('BCN','MX','Baja California',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('BCS','MX','Baja California Sur',NULL),
	 ('CAM','MX','Campeche',NULL),
	 ('CHH','MX','Chihuahua',NULL),
	 ('CHP','MX','Chiapas',NULL),
	 ('COA','MX','Coahuila',NULL),
	 ('COL','MX','Colima',NULL),
	 ('DIF','MX','Distrito Federal',NULL),
	 ('DUR','MX','Durango',NULL),
	 ('GRO','MX','Guerrero',NULL),
	 ('GUA','MX','Guanajuato',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('HID','MX','Hidalgo',NULL),
	 ('JAL','MX','Jalisco',NULL),
	 ('MEX','MX','Mexico',NULL),
	 ('MIC','MX','Michoacin',NULL),
	 ('MOR','MX','Morelos',NULL),
	 ('NAY','MX','Nayarit',NULL),
	 ('NLE','MX','Nuevo Leon',NULL),
	 ('OAX','MX','Oaxaca',NULL),
	 ('PUE','MX','Puebla',NULL),
	 ('QUE','MX','Queretaro',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('ROO','MX','Quintana Roo',NULL),
	 ('SIN','MX','Sinaloa',NULL),
	 ('SLP','MX','San Luis Potosi',NULL),
	 ('SON','MX','Sonora',NULL),
	 ('TAB','MX','Tabasco',NULL),
	 ('TAM','MX','Tamaulipas',NULL),
	 ('TLA','MX','Tlaxcala',NULL),
	 ('VER','MX','Veracruz',NULL),
	 ('YUC','MX','Yucatan',NULL),
	 ('ZAC','MX','Zacatecas',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('1','MY','Johor',NULL),
	 ('10','MY','Selangor',NULL),
	 ('11','MY','Terengganu',NULL),
	 ('12','MY','Sabah',NULL),
	 ('13','MY','Sarawak',NULL),
	 ('14','MY','Wilayah Persekutuan Kuala Lumpur',NULL),
	 ('15','MY','Wilayah Persekutuan Labuan',NULL),
	 ('16','MY','Wilayah Persekutuan Putrajaya',NULL),
	 ('2','MY','Kedah',NULL),
	 ('3','MY','Kelantan',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('4','MY','Melaka',NULL),
	 ('5','MY','Negeri Sembilan',NULL),
	 ('6','MY','Pahang',NULL),
	 ('7','MY','Pulau Pinang',NULL),
	 ('8','MY','Perak',NULL),
	 ('9','MY','Perlis',NULL),
	 ('A','MZ','Niaaea',NULL),
	 ('B','MZ','Manica',NULL),
	 ('G','MZ','Gaza',NULL),
	 ('I','MZ','Inhambane',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('MPM','MZ','Maputo',NULL),
	 ('N','MZ','Numpula',NULL),
	 ('P','MZ','Cabo Delgado',NULL),
	 ('Q','MZ','Zambezia',NULL),
	 ('S','MZ','Sofala',NULL),
	 ('T','MZ','Tete',NULL),
	 ('CA','NA','Caprivi',NULL),
	 ('ER','NA','Erongo',NULL),
	 ('HA','NA','Hardap',NULL),
	 ('KA','NA','Karas',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('KH','NA','Khomae',NULL),
	 ('KU','NA','Kunene',NULL),
	 ('OD','NA','Otjozondjupa',NULL),
	 ('OH','NA','Omaheke',NULL),
	 ('OK','NA','Okavango',NULL),
	 ('ON','NA','Oshana',NULL),
	 ('OS','NA','Omusati',NULL),
	 ('OT','NA','Oshikoto',NULL),
	 ('OW','NA','Ohangwena',NULL),
	 ('1','NE','Agadez',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('2','NE','Diffa',NULL),
	 ('3','NE','Dosso',NULL),
	 ('4','NE','Maradi',NULL),
	 ('6','NE','Tillaberi',NULL),
	 ('7','NE','Zinder',NULL),
	 ('8','NE','Niamey',NULL),
	 ('S','NE','Tahoua',NULL),
	 ('AB','NG','Abia',NULL),
	 ('AD','NG','Adamawa',NULL),
	 ('AK','NG','Akwa Ibom',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('AN','NG','Anambra',NULL),
	 ('BA','NG','Bauchi',NULL),
	 ('BE','NG','Benue',NULL),
	 ('BO','NG','Borno',NULL),
	 ('BY','NG','Bayelsa',NULL),
	 ('CR','NG','Cross River',NULL),
	 ('DE','NG','Delta',NULL),
	 ('EB','NG','Ebonyi',NULL),
	 ('ED','NG','Edo',NULL),
	 ('EK','NG','Ekiti',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('EN','NG','Enugu',NULL),
	 ('FC','NG','Abuja Capital Territory',NULL),
	 ('GO','NG','Gombe',NULL),
	 ('IM','NG','Imo',NULL),
	 ('JI','NG','Jigawa',NULL),
	 ('KD','NG','Kaduna',NULL),
	 ('KE','NG','Kebbi',NULL),
	 ('KN','NG','Kano',NULL),
	 ('KO','NG','Kogi',NULL),
	 ('KT','NG','Katsina',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('KW','NG','Kwara',NULL),
	 ('LA','NG','Lagos',NULL),
	 ('NA','NG','Nassarawa',NULL),
	 ('NI','NG','Niger',NULL),
	 ('OG','NG','Ogun',NULL),
	 ('ON','NG','Ondo',NULL),
	 ('OS','NG','Osun',NULL),
	 ('OY','NG','Oyo',NULL),
	 ('RI','NG','Rivers',NULL),
	 ('SO','NG','Sokoto',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('TA','NG','Taraba',NULL),
	 ('YO','NG','Yobe',NULL),
	 ('ZA','NG','Zamfara',NULL),
	 ('AN','NI','Atlantico Norte',NULL),
	 ('AS','NI','Atlantico Sur',NULL),
	 ('BO','NI','Boaco',NULL),
	 ('CA','NI','Carazo',NULL),
	 ('CI','NI','Chinandega',NULL),
	 ('CO','NI','Chontales',NULL),
	 ('ES','NI','Esteli',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('JI','NI','Jinotega',NULL),
	 ('LE','NI','Leon',NULL),
	 ('MD','NI','Madriz',NULL),
	 ('MN','NI','Managua',NULL),
	 ('MS','NI','Masaya',NULL),
	 ('MT','NI','Matagalpa',NULL),
	 ('NS','NI','Nueva Segovia',NULL),
	 ('RI','NI','Rivas',NULL),
	 ('SJ','NI','Rio San Juan',NULL),
	 ('DR','NL','Drente',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('FL','NL','Flevoland',NULL),
	 ('FR','NL','Friesland',NULL),
	 ('GL','NL','Gelderland',NULL),
	 ('GR','NL','Groningen',NULL),
	 ('LI','NL','Limburg',NULL),
	 ('NB','NL','Noord-Brabant',NULL),
	 ('NH','NL','Noord-Holland',NULL),
	 ('OV','NL','Overijssel',NULL),
	 ('UT','NL','Utrecht',NULL),
	 ('ZH','NL','Zuid-Holland',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('ZL','NL','Zeeland',NULL),
	 ('1','NO','Ostfold',NULL),
	 ('10','NO','Vest-Agder',NULL),
	 ('11','NO','Rogaland',NULL),
	 ('12','NO','Hordaland',NULL),
	 ('14','NO','Sogn og Fjordane',NULL),
	 ('15','NO','Mire og Romsdal',NULL),
	 ('16','NO','Sir-Trindelag',NULL),
	 ('17','NO','Nord-Trindelag',NULL),
	 ('18','NO','Nordland',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('19','NO','Troms',NULL),
	 ('2','NO','Akershus',NULL),
	 ('20','NO','Finumark',NULL),
	 ('21','NO','Svalbard',NULL),
	 ('22','NO','Jan Mayen',NULL),
	 ('3','NO','Oslo',NULL),
	 ('4','NO','Hedmark',NULL),
	 ('5','NO','Oppland',NULL),
	 ('6','NO','Telemark',NULL),
	 ('7','NO','Vestfold',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('9','NO','Aust-Agder',NULL),
	 ('AUK','NZ','Auckland',NULL),
	 ('BOP','NZ','Bay of Plenty',NULL),
	 ('CAN','NZ','Canterbury',NULL),
	 ('GIS','NZ','Gisborne',NULL),
	 ('HKB','NZ','Hawkes Bay',NULL),
	 ('MBH','NZ','Marlborough',NULL),
	 ('MWT','NZ','Manawatu-Wanganui',NULL),
	 ('NSN','NZ','Nelson',NULL),
	 ('NTL','NZ','Northland',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('OTA','NZ','Otago',NULL),
	 ('STL','NZ','Southland',NULL),
	 ('TAS','NZ','Tasman',NULL),
	 ('TKI','NZ','Taranaki',NULL),
	 ('WGN','NZ','Wellington',NULL),
	 ('WKO','NZ','waikato',NULL),
	 ('WTC','NZ','West Coast',NULL),
	 ('BA','OM','Al Batinah',NULL),
	 ('DA','OM','Ad Dakhillyah',NULL),
	 ('JA','OM','Al Janblyah',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('MA','OM','Masqat',NULL),
	 ('MU','OM','Musandam',NULL),
	 ('SH','OM','Ash Sharqlyah',NULL),
	 ('WU','OM','Al Wusta',NULL),
	 ('ZA','OM','Az Zahirah',NULL),
	 ('1','PA','Bocas del Toro',NULL),
	 ('2','PA','Cocle',NULL),
	 ('4','PA','Chiriqui',NULL),
	 ('5','PA','Darien',NULL),
	 ('6','PA','Herrera',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('7','PA','Loa Santoa',NULL),
	 ('8','PA','Panama',NULL),
	 ('9','PA','Veraguas',NULL),
	 ('Q','PA','Comarca de San Blas',NULL),
	 ('ANC','PE','Ancash',NULL),
	 ('APU','PE','Apurimac',NULL),
	 ('ARE','PE','Arequipa',NULL),
	 ('AYA','PE','Ayacucho',NULL),
	 ('CAJ','PE','Cajamarca',NULL),
	 ('CAL','PE','El Callao',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('CUS','PE','Cuzco',NULL),
	 ('HUC','PE','Huanuco',NULL),
	 ('HUV','PE','Huancavelica',NULL),
	 ('ICA','PE','Ica',NULL),
	 ('JUN','PE','Junin',NULL),
	 ('LAL','PE','La Libertad',NULL),
	 ('LAM','PE','Lambayeque',NULL),
	 ('LIM','PE','Lima',NULL),
	 ('LOR','PE','Loreto',NULL),
	 ('MDD','PE','Madre de Dios',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('MOQ','PE','Moquegua',NULL),
	 ('PAS','PE','Pasco',NULL),
	 ('PIU','PE','Piura',NULL),
	 ('PUN','PE','Puno',NULL),
	 ('SAM','PE','San Martin',NULL),
	 ('TAC','PE','Tacna',NULL),
	 ('TUM','PE','Tumbes',NULL),
	 ('UCA','PE','Ucayali',NULL),
	 ('CPK','PG','Chimbu',NULL),
	 ('EBR','PG','East New Britain',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('EHG','PG','Eastern Highlands',NULL),
	 ('EPW','PG','Enga',NULL),
	 ('ESW','PG','East Sepik',NULL),
	 ('GPK','PG','Gulf',NULL),
	 ('MBA','PG','Milne Bay',NULL),
	 ('MPL','PG','Morobe',NULL),
	 ('MPM','PG','Madang',NULL),
	 ('MRL','PG','Manus',NULL),
	 ('NCD','PG','National Capital District (Port Moresby)',NULL),
	 ('NIK','PG','New Ireland',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('NSA','PG','North Solomons',NULL),
	 ('SAN','PG','Santaun',NULL),
	 ('SHM','PG','Southern Highlands',NULL),
	 ('WBK','PG','West New Britain',NULL),
	 ('WHM','PG','Western Highlands',NULL),
	 ('ABR','PH','Abra',NULL),
	 ('AGN','PH','Agusan del Norte',NULL),
	 ('AGS','PH','Agusan del Sur',NULL),
	 ('AKL','PH','Aklan',NULL),
	 ('ALB','PH','Albay',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('ANT','PH','Antique',NULL),
	 ('APA','PH','Apayao',NULL),
	 ('AUR','PH','Aurora',NULL),
	 ('BAN','PH','Batasn',NULL),
	 ('BAS','PH','Basilan',NULL),
	 ('BEN','PH','Benguet',NULL),
	 ('BIL','PH','Biliran',NULL),
	 ('BOH','PH','Bohol',NULL),
	 ('BTG','PH','Batangas',NULL),
	 ('BTN','PH','Batanes',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('BUK','PH','Bukidnon',NULL),
	 ('BUL','PH','Bulacan',NULL),
	 ('CAG','PH','Cagayan',NULL),
	 ('CAM','PH','Camiguin',NULL),
	 ('CAN','PH','Camarines Norte',NULL),
	 ('CAP','PH','Capiz',NULL),
	 ('CAS','PH','Camarines Sur',NULL),
	 ('CAT','PH','Catanduanes',NULL),
	 ('CAV','PH','Cavite',NULL),
	 ('CEB','PH','Cebu',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('COM','PH','Compostela Valley',NULL),
	 ('DAO','PH','Davao Oriental',NULL),
	 ('DAS','PH','Davao del Sur',NULL),
	 ('DAV','PH','Davao',NULL),
	 ('EAS','PH','Eastern Samar',NULL),
	 ('GUI','PH','Guimaras',NULL),
	 ('IFU','PH','Ifugao',NULL),
	 ('ILI','PH','Iloilo',NULL),
	 ('ILN','PH','Ilocos Norte',NULL),
	 ('ILS','PH','Ilocos Sur',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('ISA','PH','Isabela',NULL),
	 ('KAL','PH','Kalinga-Apayso',NULL),
	 ('LAG','PH','Laguna',NULL),
	 ('LAN','PH','Lanao del Norte',NULL),
	 ('LAS','PH','Lanao del Sur',NULL),
	 ('LEY','PH','Leyte',NULL),
	 ('LUN','PH','La Union',NULL),
	 ('MAD','PH','Marinduque',NULL),
	 ('MAG','PH','Maguindanao',NULL),
	 ('MAS','PH','Masbate',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('MDC','PH','Mindoro Occidental',NULL),
	 ('MDR','PH','Mindoro Oriental',NULL),
	 ('MOU','PH','Mountain Province',NULL),
	 ('MSC','PH','Misamis Occidental',NULL),
	 ('MSR','PH','Misamis Oriental',NULL),
	 ('NCO','PH','North Cotabato',NULL),
	 ('NEC','PH','Negroe Occidental',NULL),
	 ('NER','PH','Negros Oriental',NULL),
	 ('NSA','PH','Northern Samar',NULL),
	 ('NUE','PH','Nueva Ecija',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('NUV','PH','Nueva Vizcaya',NULL),
	 ('PAM','PH','Pampanga',NULL),
	 ('PAN','PH','Pangasinan',NULL),
	 ('PLW','PH','Palawan',NULL),
	 ('QUE','PH','Quezon',NULL),
	 ('QUI','PH','Quirino',NULL),
	 ('RIZ','PH','Rizal',NULL),
	 ('ROM','PH','Romblon',NULL),
	 ('SAR','PH','Sarangani',NULL),
	 ('SCO','PH','South Cotabato',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('SIG','PH','Siquijor',NULL),
	 ('SLE','PH','Southern Leyte',NULL),
	 ('SLU','PH','Sulu',NULL),
	 ('SOR','PH','Sorsogon',NULL),
	 ('SUK','PH','Sultan Kudarat',NULL),
	 ('SUN','PH','Surigao del Norte',NULL),
	 ('SUR','PH','Surigao del Sur',NULL),
	 ('TAR','PH','Tarlac',NULL),
	 ('TAW','PH','Tawi-Tawi',NULL),
	 ('WSA','PH','Western Samar',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('ZAN','PH','Zamboanga del Norte',NULL),
	 ('ZAS','PH','Zamboanga del Sur',NULL),
	 ('ZMB','PH','Zambales',NULL),
	 ('ZSI','PH','Zamboanga Sibiguey',NULL),
	 ('BA','PK','Baluchistan (en)',NULL),
	 ('IS','PK','Islamabad',NULL),
	 ('JK','PK','Azad Rashmir',NULL),
	 ('NA','PK','Northern Areas',NULL),
	 ('NW','PK','North-West Frontier',NULL),
	 ('SD','PK','Sind (en)',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('TA','PK','Federally Administered Tribal Aresa',NULL),
	 ('DS','PL','dolnol¹skie',NULL),
	 ('KP','PL','kujawsko-pomorskie',NULL),
	 ('LB','PL','lubuskie',NULL),
	 ('LD','PL','³ódzkie',NULL),
	 ('LU','PL','lubelskie',NULL),
	 ('MA','PL','ma³opolskie',NULL),
	 ('MZ','PL','mazowieckie',NULL),
	 ('OP','PL','opolskie',NULL),
	 ('PD','PL','podlaskie',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('PK','PL','podkarpackie',NULL),
	 ('PM','PL','pomorskie',NULL),
	 ('SK','PL','wiêtokrzyskie',NULL),
	 ('SL','PL','l¹skie',NULL),
	 ('WN','PL','warmiñsko-mazurskie',NULL),
	 ('WP','PL','wielkopolskie',NULL),
	 ('ZP','PL','zachodniopomorskie',NULL),
	 ('_A','PS','Jenin',NULL),
	 ('_B','PS','Tubas',NULL),
	 ('_C','PS','Tulkarm',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('_D','PS','Nablus',NULL),
	 ('_E','PS','Qalqilya',NULL),
	 ('_F','PS','Salfit',NULL),
	 ('_G','PS','Ramallah and Al-Bireh',NULL),
	 ('_H','PS','Jericho',NULL),
	 ('_I','PS','Jerusalem',NULL),
	 ('_J','PS','Bethlehem',NULL),
	 ('_K','PS','Hebron',NULL),
	 ('_L','PS','North Gaza',NULL),
	 ('_M','PS','Gaza',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('_N','PS','Deir el-Balah',NULL),
	 ('_O','PS','Khan Yunis',NULL),
	 ('_P','PS','Rafah',NULL),
	 ('1','PT','Aveiro',NULL),
	 ('10','PT','Leiria',NULL),
	 ('11','PT','Lisboa',NULL),
	 ('12','PT','Portalegre',NULL),
	 ('13','PT','Porto',NULL),
	 ('14','PT','Santarem',NULL),
	 ('15','PT','Setubal',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('16','PT','Viana do Castelo',NULL),
	 ('17','PT','Vila Real',NULL),
	 ('18','PT','Viseu',NULL),
	 ('2','PT','Beja',NULL),
	 ('20','PT','Regiao Autonoma dos Acores',NULL),
	 ('3','PT','Braga',NULL),
	 ('30','PT','Regiao Autonoma da Madeira',NULL),
	 ('4','PT','Braganca',NULL),
	 ('5','PT','Castelo Branco',NULL),
	 ('6','PT','Colmbra',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('7','PT','Ovora',NULL),
	 ('8','PT','Faro',NULL),
	 ('9','PT','Guarda',NULL),
	 ('1','PY','Concepcion',NULL),
	 ('10','PY','Alto Parana',NULL),
	 ('12','PY','Neembucu',NULL),
	 ('13','PY','Amambay',NULL),
	 ('14','PY','Canindeyu',NULL),
	 ('15','PY','Presidente Hayes',NULL),
	 ('16','PY','Alto Paraguay',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('19','PY','Boqueron',NULL),
	 ('2','PY','San Pedro',NULL),
	 ('3','PY','Cordillera',NULL),
	 ('4','PY','Guaira',NULL),
	 ('5','PY','Caeguazu',NULL),
	 ('6','PY','Caazapl',NULL),
	 ('7','PY','Itapua',NULL),
	 ('8','PY','Miaiones',NULL),
	 ('9','PY','Paraguari',NULL),
	 ('ASU','PY','Asuncion',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('DA','QA','Ad Dawhah',NULL),
	 ('GH','QA','Al Ghuwayriyah',NULL),
	 ('JB','QA','Jariyan al Batnah',NULL),
	 ('JU','QA','Al Jumayliyah',NULL),
	 ('KH','QA','Al Khawr',NULL),
	 ('MS','QA','Madinat ash Shamal',NULL),
	 ('RA','QA','Ar Rayyan',NULL),
	 ('US','QA','Umm Salal',NULL),
	 ('WA','QA','Al Wakrah',NULL),
	 ('AB','RO','Alba',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('AG','RO','Arges',NULL),
	 ('AR','RO','Arad',NULL),
	 ('B','RO','Bucuresti',NULL),
	 ('BC','RO','Bacau',NULL),
	 ('BH','RO','Bihor',NULL),
	 ('BN','RO','Bistrita-Nasaud',NULL),
	 ('BR','RO','Braila',NULL),
	 ('BT','RO','Boto''ani',NULL),
	 ('BV','RO','Bra''ov',NULL),
	 ('BZ','RO','Buzau',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('CJ','RO','Cluj',NULL),
	 ('CL','RO','Ca la ras''i',NULL),
	 ('CS','RO','Caras-Severin',NULL),
	 ('CT','RO','Constant''a',NULL),
	 ('CV','RO','Covasna',NULL),
	 ('DB','RO','Dambovit''a',NULL),
	 ('DJ','RO','Dolj',NULL),
	 ('GJ','RO','Gorj',NULL),
	 ('GL','RO','Galat''i',NULL),
	 ('GR','RO','Giurgiu',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('HD','RO','Hunedoara',NULL),
	 ('HR','RO','Harghita',NULL),
	 ('IF','RO','Ilfov',NULL),
	 ('IL','RO','Ialomit''a',NULL),
	 ('IS','RO','Ias''i',NULL),
	 ('MH','RO','Mehedint''i',NULL),
	 ('MM','RO','Maramures',NULL),
	 ('MS','RO','Mures',NULL),
	 ('NT','RO','Neamt',NULL),
	 ('OT','RO','Olt',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('PH','RO','Prahova',NULL),
	 ('SB','RO','Sibiu',NULL),
	 ('SJ','RO','Sa laj',NULL),
	 ('SM','RO','Satu Mare',NULL),
	 ('SV','RO','Suceava',NULL),
	 ('TL','RO','Tulcea',NULL),
	 ('TM','RO','Timis',NULL),
	 ('TR','RO','Teleorman',NULL),
	 ('VL','RO','Valcea',NULL),
	 ('VN','RO','Vrancea',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('VS','RO','Vaslui',NULL),
	 ('AD','RU','Adygeya, Respublika',NULL),
	 ('AGB','RU','Aginskiy Buryatskiy avtonomnyy',NULL),
	 ('AL','RU','Altay, Respublika',NULL),
	 ('ALT','RU','Altayskiy kray',NULL),
	 ('AMU','RU','Amurskaya oblast''',NULL),
	 ('ARK','RU','Arkhangel''skaya oblast''',NULL),
	 ('AST','RU','Astrakhanskaya oblast''',NULL),
	 ('BA','RU','Bashkortostan, Respublika',NULL),
	 ('BEL','RU','Belgorodskaya oblast''',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('BRY','RU','Bryanskaya oblast''',NULL),
	 ('BU','RU','Buryatiya, Respublika',NULL),
	 ('CE','RU','Chechenskaya Respublika',NULL),
	 ('CHE','RU','Chelyabinskaya oblast''',NULL),
	 ('CHI','RU','Chitinskaya oblast''',NULL),
	 ('CHU','RU','Chukotskiy avtonomnyy okrug',NULL),
	 ('CU','RU','Chuvashskaya Respublika',NULL),
	 ('DA','RU','Dagestan, Respublika',NULL),
	 ('EVE','RU','Evenkiyskiy avtonomnyy okrug',NULL),
	 ('IN','RU','Ingushskaya Respublika',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('IRK','RU','Irkutskaya oblast''',NULL),
	 ('IVA','RU','Ivanovskaya oblast''',NULL),
	 ('KAM','RU','Kamchatskaya oblast''',NULL),
	 ('KB','RU','Kabardino-Balkarskaya',NULL),
	 ('KC','RU','Karachayevo-Cherkesskaya Respublika',NULL),
	 ('KDA','RU','Krasnodarskiy kray',NULL),
	 ('KEM','RU','Kemerovskaya oblast''',NULL),
	 ('KGD','RU','Kaliningradskaya oblast''',NULL),
	 ('KGN','RU','Kurganskaya oblast''',NULL),
	 ('KHA','RU','Khabarovskiy kray',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('KHM','RU','Khanty-Mansiyskiy avtonomnyy okrug',NULL),
	 ('KIR','RU','Kirovskaya oblast''',NULL),
	 ('KK','RU','Khakasiya, Respublika',NULL),
	 ('KL','RU','Kalmykiya, Respublika',NULL),
	 ('KLU','RU','Kaluzhskaya oblast''',NULL),
	 ('KO','RU','Komi, Respublika',NULL),
	 ('KOP','RU','Komi-Permyatskiy avtonomnyy okrug',NULL),
	 ('KOR','RU','Koryakskiy avtonomnyy okrug',NULL),
	 ('KOS','RU','Kostromskaya oblast''',NULL),
	 ('KR','RU','Kareliya, Respublika',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('KRS','RU','Kurskaya oblast''',NULL),
	 ('KYA','RU','Krasnoyarskiy kray',NULL),
	 ('LEN','RU','Leningradskaya oblast''',NULL),
	 ('LIP','RU','Lipetskaya oblast''',NULL),
	 ('MAG','RU','Magadanskaya oblast''',NULL),
	 ('ME','RU','Mariy El, Respublika',NULL),
	 ('MO','RU','Mordoviya, Respublika',NULL),
	 ('MOS','RU','Moskovskaya oblast''',NULL),
	 ('MOW','RU','Moskva',NULL),
	 ('MUR','RU','Murmanskaya oblast''',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('NEN','RU','Nenetskiy avtonomnyy okrug',NULL),
	 ('NGR','RU','Novgorodskaya oblast''',NULL),
	 ('NIZ','RU','Nizhegorodskaya oblast''',NULL),
	 ('NVS','RU','Novosibirskaya oblast''',NULL),
	 ('OMS','RU','Omskaya oblast''',NULL),
	 ('ORE','RU','Orenburgskaya oblast''',NULL),
	 ('ORL','RU','Orlovskaya oblast''',NULL),
	 ('PER','RU','Permskaya oblast''',NULL),
	 ('PNZ','RU','Penzenskaya oblast''',NULL),
	 ('PRI','RU','Primorskiy kray',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('PSK','RU','Pskovskaya oblast''',NULL),
	 ('ROS','RU','Rostovskaya oblast''',NULL),
	 ('RYA','RU','Ryazanskaya oblast''',NULL),
	 ('SA','RU','Sakha, Respublika [Yakutiya]',NULL),
	 ('SAK','RU','Sakhalinskaya oblast''',NULL),
	 ('SAM','RU','Samarskaya oblast''',NULL),
	 ('SAR','RU','Saratovskaya oblast''',NULL),
	 ('SE','RU','Severnaya Osetiya, Respublika',NULL),
	 ('SMO','RU','Smolenskaya oblast''',NULL),
	 ('SPE','RU','Sankt-Peterburg',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('STA','RU','Stavropol''skiy kray',NULL),
	 ('SVE','RU','Sverdlovskaya oblast''',NULL),
	 ('TA','RU','Tatarstan, Respublika',NULL),
	 ('TAM','RU','Tambovskaya oblast''',NULL),
	 ('TAY','RU','Taymyrskiy (Dolgano-Nenetskiy)',NULL),
	 ('TOM','RU','Tomskaya oblast''',NULL),
	 ('TUL','RU','Tul''skaya oblast''',NULL),
	 ('TVE','RU','Tverskaya oblast''',NULL),
	 ('TY','RU','Tyva, Respublika [Tuva]',NULL),
	 ('TYU','RU','Tyumenskaya oblast''',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('UD','RU','Udmurtskaya Respublika',NULL),
	 ('ULY','RU','Ul''yanovskaya oblast''',NULL),
	 ('UOB','RU','Ust''-Ordynskiy Buryatskiy',NULL),
	 ('VGG','RU','Volgogradskaya oblast''',NULL),
	 ('VLA','RU','Vladimirskaya oblast''',NULL),
	 ('VLG','RU','Vologodskaya oblast''',NULL),
	 ('VOR','RU','Voronezhskaya oblast''',NULL),
	 ('YAN','RU','Yamalo-Nenetskiy avtonomnyy okrug',NULL),
	 ('YAR','RU','Yaroslavskaya oblast''',NULL),
	 ('YEV','RU','Yevreyskaya avtonomnaya oblast''',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('B','RW','Gitarama',NULL),
	 ('C','RW','Butare',NULL),
	 ('D','RW','Gikongoro',NULL),
	 ('E','RW','Cyangugu',NULL),
	 ('F','RW','Kibuye',NULL),
	 ('G','RW','Gisenyi',NULL),
	 ('H','RW','Ruhengeri',NULL),
	 ('I','RW','Byumba',NULL),
	 ('J','RW','Kibungo',NULL),
	 ('K','RW','Kigali-Rural Kigali y'' Icyaro',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('L','RW','Kigali-Ville Kigali Ngari',NULL),
	 ('M','RW','Mutara',NULL),
	 ('1','SA','Ar Riyad',NULL),
	 ('10','SA','Najran',NULL),
	 ('11','SA','Al Batah',NULL),
	 ('12','SA','Al Jawf',NULL),
	 ('14','SA','Asir',NULL),
	 ('2','SA','Makkah',NULL),
	 ('3','SA','Al Madinah',NULL),
	 ('5','SA','Al Qasim',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('6','SA','Ha''il',NULL),
	 ('7','SA','Tabuk',NULL),
	 ('8','SA','Al H,udd ash Shamallyah',NULL),
	 ('9','SA','Jlzan',NULL),
	 ('CT','SB','Capital Territory (Honiara)',NULL),
	 ('GU','SB','Guadalcanal',NULL),
	 ('IS','SB','Isabel',NULL),
	 ('MK','SB','Makira',NULL),
	 ('ML','SB','Malaita',NULL),
	 ('TE','SB','Temotu',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('1','SD','Ash Shamallyah',NULL),
	 ('10','SD','Gharb Kurdufan',NULL),
	 ('11','SD','Janub Darfur',NULL),
	 ('12','SD','Gharb Darfur',NULL),
	 ('13','SD','Janub Rurdufan',NULL),
	 ('14','SD','Gharb Ba~r al Ghazal',NULL),
	 ('15','SD','Shamal Batr al Ghazal',NULL),
	 ('16','SD','Gharb al Istiwa''iyah',NULL),
	 ('17','SD','Bahr al Jabal',NULL),
	 ('18','SD','Al Buhayrat',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('19','SD','Sharq al Istiwa''iyah',NULL),
	 ('2','SD','Shamal Darfur',NULL),
	 ('20','SD','Jnqall',NULL),
	 ('21','SD','Warab',NULL),
	 ('22','SD','Al Wahdah',NULL),
	 ('23','SD','A''ali an Nil',NULL),
	 ('24','SD','An Nil al Azraq',NULL),
	 ('25','SD','Sinnar',NULL),
	 ('26','SD','Al Bah al Ahmar',NULL),
	 ('3','SD','Al Khartum',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('4','SD','An Nil',NULL),
	 ('5','SD','Kassala',NULL),
	 ('6','SD','Al Qadarif',NULL),
	 ('7','SD','Al Jazirah',NULL),
	 ('8','SD','An Nil al Abyaq',NULL),
	 ('9','SD','Shamal Kurdufan',NULL),
	 ('AB','SE','Stockholms lan',NULL),
	 ('AC','SE','Vasterbottens lan',NULL),
	 ('BD','SE','Norrbottena lan',NULL),
	 ('C','SE','Uppsala lan',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('D','SE','Sodermanlands lan',NULL),
	 ('E','SE','Ostergotlands lan',NULL),
	 ('F','SE','Jonkopings lan',NULL),
	 ('G','SE','Kronoberge lan',NULL),
	 ('H','SE','Kalmar lan',NULL),
	 ('I','SE','Gotlands lan',NULL),
	 ('K','SE','Blekinge lan',NULL),
	 ('M','SE','Skane lan',NULL),
	 ('N','SE','Hallands lan',NULL),
	 ('Q','SE','Vastra Gotalands lan',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('S','SE','Varmlanda lan',NULL),
	 ('T','SE','Orebro lan',NULL),
	 ('U','SE','Vastmanlanda lan',NULL),
	 ('W','SE','Dalarnas lan',NULL),
	 ('X','SE','Gavleborge lan',NULL),
	 ('Y','SE','Vasternorrlands lan',NULL),
	 ('Z','SE','Jamtlande lan',NULL),
	 ('AC','SH','Ascension',NULL),
	 ('SH','SH','Saint Helena',NULL),
	 ('TA','SH','Tristan da Cunha',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('1','SI','Ajdovscina',NULL),
	 ('10','SI','Tisina',NULL),
	 ('11','SI','Celje',NULL),
	 ('116','SI','Sveti Jurij',NULL),
	 ('117','SI','Sencur',NULL),
	 ('118','SI','Sentilj',NULL),
	 ('119','SI','Sentjernej',NULL),
	 ('12','SI','Cerklje na Gorenjskem',NULL),
	 ('120','SI','Sentjur pri Celju',NULL),
	 ('121','SI','Skocjan',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('122','SI','Skofja Loka',NULL),
	 ('123','SI','Skoftjica',NULL),
	 ('124','SI','Smarje pri Jelsah',NULL),
	 ('125','SI','Smartno ob Paki',NULL),
	 ('126','SI','Sostanj',NULL),
	 ('127','SI','Store',NULL),
	 ('128','SI','Tolmin',NULL),
	 ('129','SI','Trbovje',NULL),
	 ('13','SI','Cerknica',NULL),
	 ('130','SI','Trebnje',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('131','SI','Trzic',NULL),
	 ('132','SI','Turnisce',NULL),
	 ('133','SI','Velenje',NULL),
	 ('134','SI','Velika Lasce',NULL),
	 ('135','SI','Videm',NULL),
	 ('136','SI','Vipava',NULL),
	 ('137','SI','Vitanje',NULL),
	 ('138','SI','Vojnik',NULL),
	 ('14','SI','Cerkno',NULL),
	 ('140','SI','Vrhnika',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('141','SI','Vuzenica',NULL),
	 ('142','SI','Zagorje ob Savi',NULL),
	 ('143','SI','Zavrc',NULL),
	 ('144','SI','Zrece',NULL),
	 ('146','SI','Zelezniki',NULL),
	 ('147','SI','Ziri',NULL),
	 ('148','SI','Benedikt',NULL),
	 ('149','SI','Bistrica ob Sotli',NULL),
	 ('15','SI','Crensovci',NULL),
	 ('150','SI','Bloke',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('151','SI','Braslovce',NULL),
	 ('152','SI','Cankova',NULL),
	 ('153','SI','Cerkvenjak',NULL),
	 ('154','SI','Dobje',NULL),
	 ('155','SI','Dobrna',NULL),
	 ('156','SI','Dobrovnik',NULL),
	 ('157','SI','Dolenjske Toplice',NULL),
	 ('158','SI','Grad',NULL),
	 ('159','SI','Hajdina',NULL),
	 ('16','SI','Crna na Koroskem',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('160','SI','Hoce-Slivnica',NULL),
	 ('161','SI','Hodos',NULL),
	 ('162','SI','Jorjul',NULL),
	 ('163','SI','Jezersko',NULL),
	 ('164','SI','Komenda',NULL),
	 ('165','SI','Kostel',NULL),
	 ('166','SI','Krizevci',NULL),
	 ('167','SI','Lovrenc na Pohorju',NULL),
	 ('168','SI','Markovci',NULL),
	 ('169','SI','Miklavz na Dravskern polju',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('17','SI','Crnomelj',NULL),
	 ('170','SI','Mirna Pec',NULL),
	 ('18','SI','Destrnik',NULL),
	 ('181','SI','Sveta Ana',NULL),
	 ('182','SI','Sveti Andraz v Slovenskih goricah',NULL),
	 ('183','SI','Sempeter-Vrtojba',NULL),
	 ('184','SI','Tabor',NULL),
	 ('185','SI','Trnovska vas',NULL),
	 ('186','SI','Trzin',NULL),
	 ('187','SI','Velika Polana',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('188','SI','Verzej',NULL),
	 ('189','SI','Vransko',NULL),
	 ('19','SI','Divaca',NULL),
	 ('190','SI','Zalec',NULL),
	 ('191','SI','Zetale',NULL),
	 ('192','SI','Zirovnica',NULL),
	 ('193','SI','Zuzemberk',NULL),
	 ('194','SI','Smartno pri Litiji',NULL),
	 ('2','SI','Beltinci',NULL),
	 ('20','SI','Dobrepolje',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('21','SI','Dobrova-Polhov Gradec',NULL),
	 ('22','SI','Dol pri Ljubljani',NULL),
	 ('23','SI','Domzale',NULL),
	 ('24','SI','Dornava',NULL),
	 ('25','SI','Dravograd',NULL),
	 ('26','SI','Duplek',NULL),
	 ('27','SI','Gorenja vas-Poljane',NULL),
	 ('28','SI','Gorsnica',NULL),
	 ('29','SI','Gornja Radgona',NULL),
	 ('3','SI','Bled',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('30','SI','Gornji Grad',NULL),
	 ('31','SI','Gornji Petrovci',NULL),
	 ('32','SI','Grosuplje',NULL),
	 ('33','SI','Salovci',NULL),
	 ('34','SI','Hrastnik',NULL),
	 ('35','SI','Hrpelje-Kozina',NULL),
	 ('36','SI','Idrija',NULL),
	 ('37','SI','Ig',NULL),
	 ('38','SI','IIrska Bistrica',NULL),
	 ('39','SI','Ivancna Gorica',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('4','SI','Bohinj',NULL),
	 ('40','SI','Izola',NULL),
	 ('41','SI','Jesenice',NULL),
	 ('42','SI','Jursinci',NULL),
	 ('43','SI','Kamnik',NULL),
	 ('44','SI','Kanal',NULL),
	 ('45','SI','Kidricevo',NULL),
	 ('46','SI','Kobarid',NULL),
	 ('47','SI','Kobilje',NULL),
	 ('48','SI','Jovevje',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('49','SI','Komen',NULL),
	 ('5','SI','Borovnica',NULL),
	 ('50','SI','Koper',NULL),
	 ('51','SI','Kozje',NULL),
	 ('52','SI','Kranj',NULL),
	 ('53','SI','Kranjska Gora',NULL),
	 ('54','SI','Krsko',NULL),
	 ('55','SI','Kungota',NULL),
	 ('56','SI','Kuzma',NULL),
	 ('57','SI','Lasko',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('58','SI','Lenart',NULL),
	 ('59','SI','Lendava',NULL),
	 ('6','SI','Bovec',NULL),
	 ('60','SI','Litija',NULL),
	 ('61','SI','Ljubljana',NULL),
	 ('62','SI','Ljubno',NULL),
	 ('63','SI','Ljutomer',NULL),
	 ('64','SI','Logatec',NULL),
	 ('65','SI','Loska dolina',NULL),
	 ('66','SI','Loski Potok',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('67','SI','Luce',NULL),
	 ('68','SI','Lukovica',NULL),
	 ('69','SI','Majsperk',NULL),
	 ('7','SI','Brda',NULL),
	 ('70','SI','Maribor',NULL),
	 ('71','SI','Medvode',NULL),
	 ('72','SI','Menges',NULL),
	 ('73','SI','Metlika',NULL),
	 ('74','SI','Mezica',NULL),
	 ('75','SI','Miren-Kostanjevica',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('76','SI','Mislinja',NULL),
	 ('77','SI','Moravce',NULL),
	 ('78','SI','Moravske Toplice',NULL),
	 ('79','SI','Mozirje',NULL),
	 ('8','SI','Brezovica',NULL),
	 ('80','SI','Murska Sobota',NULL),
	 ('81','SI','Muta',NULL),
	 ('82','SI','Naklo',NULL),
	 ('83','SI','Nazarje',NULL),
	 ('84','SI','Nova Gorica',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('85','SI','Nova mesto',NULL),
	 ('9','SI','Brezica',NULL),
	 ('BC','SK','Banskobystrický kraj',NULL),
	 ('BL','SK','Bratislavský kraj',NULL),
	 ('KI','SK','Koický kraj',NULL),
	 ('NJ','SK','Nitriansky kraj',NULL),
	 ('PV','SK','Preovský kraj',NULL),
	 ('TA','SK','Trnavský kraj',NULL),
	 ('TC','SK','Trenèiansky kraj',NULL),
	 ('ZI','SK','ilinský kraj',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('W','SL','Western Area (Freetown)',NULL),
	 ('DB','SN','Diourbel',NULL),
	 ('DK','SN','Dakar',NULL),
	 ('FK','SN','Fatick',NULL),
	 ('KD','SN','Kolda',NULL),
	 ('KL','SN','Kaolack',NULL),
	 ('LG','SN','Louga',NULL),
	 ('MT','SN','Matam',NULL),
	 ('SL','SN','Saint-Louis',NULL),
	 ('TC','SN','Tambacounda',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('TH','SN','Thies',NULL),
	 ('ZG','SN','Ziguinchor',NULL),
	 ('AW','SO','Awdal',NULL),
	 ('BK','SO','Bakool',NULL),
	 ('BN','SO','Banaadir',NULL),
	 ('BY','SO','Bay',NULL),
	 ('GA','SO','Galguduud',NULL),
	 ('GE','SO','Gedo',NULL),
	 ('HI','SO','Hiirsan',NULL),
	 ('JD','SO','Jubbada Dhexe',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('JH','SO','Jubbada Hoose',NULL),
	 ('MU','SO','Mudug',NULL),
	 ('NU','SO','Nugaal',NULL),
	 ('SA','SO','Saneag',NULL),
	 ('SD','SO','Shabeellaha Dhexe',NULL),
	 ('SH','SO','Shabeellaha Hoose',NULL),
	 ('SO','SO','Sool',NULL),
	 ('TO','SO','Togdheer',NULL),
	 ('WO','SO','Woqooyi Galbeed',NULL),
	 ('BR','SR','Brokopondo',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('CM','SR','Commewijne',NULL),
	 ('CR','SR','Coronie',NULL),
	 ('MA','SR','Marowijne',NULL),
	 ('NI','SR','Nickerie',NULL),
	 ('PM','SR','Paramaribo',NULL),
	 ('SA','SR','Saramacca',NULL),
	 ('SI','SR','Sipaliwini',NULL),
	 ('WA','SR','Wanica',NULL),
	 ('P','ST','Principe',NULL),
	 ('S','ST','Sao Tome',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('AH','SV','Ahuachapan',NULL),
	 ('CA','SV','Cabanas',NULL),
	 ('CH','SV','Chalatenango',NULL),
	 ('CU','SV','Cuscatlan',NULL),
	 ('MO','SV','Morazan',NULL),
	 ('SA','SV','Santa Ana',NULL),
	 ('SM','SV','San Miguel',NULL),
	 ('SO','SV','Sonsonate',NULL),
	 ('SS','SV','San Salvador',NULL),
	 ('SV','SV','San Vicente',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('US','SV','Usulutan',NULL),
	 ('DI','SY','Dimashq',NULL),
	 ('DR','SY','Dar''a',NULL),
	 ('DY','SY','Dayr az Zawr',NULL),
	 ('HA','SY','Al Hasakah',NULL),
	 ('HI','SY','Jim''',NULL),
	 ('HL','SY','Halab',NULL),
	 ('HM','SY','Hamah',NULL),
	 ('ID','SY','Idlib',NULL),
	 ('LA','SY','Al Ladhiqiyah',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('QU','SY','Al Qunaytirah',NULL),
	 ('RA','SY','Ar Raqqah',NULL),
	 ('RD','SY','Rif Dimashq',NULL),
	 ('SU','SY','As Suwayda''',NULL),
	 ('TA','SY','Tarts',NULL),
	 ('HH','SZ','Hhohho',NULL),
	 ('LU','SZ','Lubombo',NULL),
	 ('MA','SZ','Manzini',NULL),
	 ('SH','SZ','Shiselweni',NULL),
	 ('BA','TD','Batha',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('BET','TD','Borkou-Ennedi-Tibesti',NULL),
	 ('BI','TD','Biltine',NULL),
	 ('CB','TD','Chari-Baguirmi',NULL),
	 ('GR','TD','Guera',NULL),
	 ('KA','TD','Kanem',NULL),
	 ('LC','TD','Lac',NULL),
	 ('LO','TD','Logone-Occidental',NULL),
	 ('LR','TD','Logone-Oriental',NULL),
	 ('MC','TD','Moyen-Chari',NULL),
	 ('MK','TD','Mayo-Kebbi',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('OD','TD','Ouaddai',NULL),
	 ('SA','TD','Salamat',NULL),
	 ('TA','TD','Tandjile',NULL),
	 ('K','TG','Kara',NULL),
	 ('M','TG','Maritime (Region)',NULL),
	 ('S','TG','Savannes',NULL),
	 ('10','TH','Krung Thep Maha Nakhon Bangkok',NULL),
	 ('11','TH','Samut Prakan',NULL),
	 ('12','TH','Nonthaburi',NULL),
	 ('13','TH','Pathum Thani',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('14','TH','Phra Nakhon Si Ayutthaya',NULL),
	 ('15','TH','Ang Thong',NULL),
	 ('16','TH','Lop Buri',NULL),
	 ('17','TH','Sing Buri',NULL),
	 ('18','TH','Chai Nat',NULL),
	 ('19','TH','Saraburi',NULL),
	 ('20','TH','Chon Buri',NULL),
	 ('21','TH','Rayong',NULL),
	 ('22','TH','Chanthaburi',NULL),
	 ('23','TH','Trat',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('24','TH','Chachoengsao',NULL),
	 ('25','TH','Prachin Buri',NULL),
	 ('26','TH','Nakhon Nayok',NULL),
	 ('27','TH','Sa Kaeo',NULL),
	 ('30','TH','Nakhon Ratchasima',NULL),
	 ('31','TH','Buri Ram',NULL),
	 ('32','TH','Surin',NULL),
	 ('33','TH','Si Sa Ket',NULL),
	 ('34','TH','Ubon Ratchathani',NULL),
	 ('35','TH','Yasothon',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('36','TH','Chaiyaphum',NULL),
	 ('37','TH','Amnat Charoen',NULL),
	 ('39','TH','Nong Bua Lam Phu',NULL),
	 ('40','TH','Khon Kaen',NULL),
	 ('41','TH','Udon Thani',NULL),
	 ('42','TH','Loei',NULL),
	 ('43','TH','Nong Khai',NULL),
	 ('44','TH','Maha Sarakham',NULL),
	 ('45','TH','Roi Et',NULL),
	 ('46','TH','Kalasin',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('47','TH','Sakon Nakhon',NULL),
	 ('48','TH','Nakhon Phanom',NULL),
	 ('49','TH','Mukdahan',NULL),
	 ('50','TH','Chiang Mai',NULL),
	 ('51','TH','Lamphun',NULL),
	 ('52','TH','Lampang',NULL),
	 ('53','TH','Uttaradit',NULL),
	 ('54','TH','Phrae',NULL),
	 ('55','TH','Nan',NULL),
	 ('56','TH','Phayao',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('57','TH','Chiang Rai',NULL),
	 ('58','TH','Mae Hong Son',NULL),
	 ('60','TH','Nakhon Sawan',NULL),
	 ('61','TH','Uthai Thani',NULL),
	 ('62','TH','Kamphasng Phet',NULL),
	 ('63','TH','Tak',NULL),
	 ('64','TH','Sukhothai',NULL),
	 ('65','TH','Phitsanulok',NULL),
	 ('66','TH','Phichit',NULL),
	 ('67','TH','Phetchabun',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('70','TH','Ratchaburi',NULL),
	 ('71','TH','Kanchanaburi',NULL),
	 ('72','TH','Suphan Buri',NULL),
	 ('73','TH','Nakhon Pathom',NULL),
	 ('74','TH','Samut Sakhon',NULL),
	 ('75','TH','Samut Songkhram',NULL),
	 ('76','TH','Phetchaburi',NULL),
	 ('77','TH','Prachuap Khiri Khan',NULL),
	 ('80','TH','Nakhon Si Thammarat',NULL),
	 ('81','TH','Krabi',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('82','TH','Phangnga',NULL),
	 ('83','TH','Phaket',NULL),
	 ('84','TH','Surat Thani',NULL),
	 ('85','TH','Ranong',NULL),
	 ('86','TH','Chumphon',NULL),
	 ('90','TH','Songkhla',NULL),
	 ('91','TH','Satun',NULL),
	 ('92','TH','Trang',NULL),
	 ('93','TH','Phatthalung',NULL),
	 ('94','TH','Pattani',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('95','TH','Yala',NULL),
	 ('96','TH','Narathiwat',NULL),
	 ('S','TH','Phatthaya',NULL),
	 ('GB','TJ','Gorno-Badakhshan',NULL),
	 ('KT','TJ','Khatlon',NULL),
	 ('SU','TJ','Sughd',NULL),
	 ('AL','TL','Aileu',NULL),
	 ('AN','TL','Ainaro',NULL),
	 ('BA','TL','Bacucau',NULL),
	 ('BO','TL','Bobonaro',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('CO','TL','Cova Lima',NULL),
	 ('DI','TL','Dili',NULL),
	 ('ER','TL','Ermera',NULL),
	 ('LA','TL','Laulem',NULL),
	 ('LI','TL','Liquica',NULL),
	 ('MF','TL','Manafahi',NULL),
	 ('MT','TL','Manatuto',NULL),
	 ('OE','TL','Oecussi',NULL),
	 ('VI','TL','Viqueque',NULL),
	 ('A','TM','Ahal',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('B','TM','Balkan',NULL),
	 ('D','TM','Dasoguz',NULL),
	 ('L','TM','Lebap',NULL),
	 ('M','TM','Mary',NULL),
	 ('11','TN','Tunis',NULL),
	 ('12','TN','L''Ariana',NULL),
	 ('13','TN','Ben Arous',NULL),
	 ('14','TN','La Manouba',NULL),
	 ('21','TN','Naboul',NULL),
	 ('22','TN','Zaghouan',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('23','TN','Bizerte',NULL),
	 ('31','TN','Béja',NULL),
	 ('32','TN','Jendouba',NULL),
	 ('33','TN','Le Ref',NULL),
	 ('34','TN','Siliana',NULL),
	 ('41','TN','Kairouan',NULL),
	 ('42','TN','Rasserine',NULL),
	 ('43','TN','Sidi Bouxid',NULL),
	 ('51','TN','Sousse',NULL),
	 ('52','TN','Moneatir',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('53','TN','Mahdia',NULL),
	 ('61','TN','Sfax',NULL),
	 ('71','TN','Gafsa',NULL),
	 ('72','TN','Tozeur',NULL),
	 ('73','TN','Kebili',NULL),
	 ('81','TN','Gab?s',NULL),
	 ('82','TN','Medenine',NULL),
	 ('83','TN','Tataouine',NULL),
	 ('1','TR','Adana',NULL),
	 ('10','TR','Bal kesir',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('11','TR','Bilecik',NULL),
	 ('12','TR','Bingol',NULL),
	 ('13','TR','Bitlis',NULL),
	 ('14','TR','Bolu',NULL),
	 ('15','TR','Burdur',NULL),
	 ('16','TR','Bursa',NULL),
	 ('17','TR','Canakkale',NULL),
	 ('18','TR','Cankir',NULL),
	 ('19','TR','Corum',NULL),
	 ('2','TR','Ad yaman',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('20','TR','Denizli',NULL),
	 ('21','TR','Diyarbakir',NULL),
	 ('22','TR','Edirne',NULL),
	 ('23','TR','Elazig',NULL),
	 ('24','TR','Erzincan',NULL),
	 ('25','TR','Erzurum',NULL),
	 ('26','TR','Eskis''ehir',NULL),
	 ('27','TR','Gaziantep',NULL),
	 ('28','TR','Giresun',NULL),
	 ('29','TR','Gms''hane',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('3','TR','Afyon',NULL),
	 ('30','TR','Hakkari',NULL),
	 ('31','TR','Hatay',NULL),
	 ('32','TR','Isparta',NULL),
	 ('33','TR','Icel',NULL),
	 ('34','TR','Istanbul',NULL),
	 ('35','TR','Izmir',NULL),
	 ('36','TR','Kars',NULL),
	 ('37','TR','Kastamonu',NULL),
	 ('38','TR','Kayseri',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('39','TR','Kirklareli',NULL),
	 ('4','TR','Ag r',NULL),
	 ('40','TR','Kirs''ehir',NULL),
	 ('41','TR','Kocaeli',NULL),
	 ('42','TR','Konya',NULL),
	 ('43','TR','Ktahya',NULL),
	 ('44','TR','Malatya',NULL),
	 ('45','TR','Manisa',NULL),
	 ('46','TR','Kahramanmaras',NULL),
	 ('47','TR','Mardin',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('48','TR','Mugila',NULL),
	 ('49','TR','Mus',NULL),
	 ('5','TR','Amasya',NULL),
	 ('50','TR','Nevs''ehir',NULL),
	 ('51','TR','Nigide',NULL),
	 ('52','TR','Ordu',NULL),
	 ('53','TR','Rize',NULL),
	 ('54','TR','Sakarya',NULL),
	 ('55','TR','Samsun',NULL),
	 ('56','TR','Siirt',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('57','TR','Sinop',NULL),
	 ('58','TR','Sivas',NULL),
	 ('59','TR','Tekirdag',NULL),
	 ('6','TR','Ankara',NULL),
	 ('60','TR','Tokat',NULL),
	 ('61','TR','Trabzon',NULL),
	 ('62','TR','Tunceli',NULL),
	 ('63','TR','S''anliurfa',NULL),
	 ('64','TR','Us''ak',NULL),
	 ('65','TR','Van',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('66','TR','Yozgat',NULL),
	 ('67','TR','Zonguldak',NULL),
	 ('68','TR','Aksaray',NULL),
	 ('69','TR','Bayburt',NULL),
	 ('7','TR','Antalya',NULL),
	 ('70','TR','Karaman',NULL),
	 ('71','TR','Kirikkale',NULL),
	 ('72','TR','Batman',NULL),
	 ('73','TR','S''rnak',NULL),
	 ('74','TR','Bartin',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('75','TR','Ardahan',NULL),
	 ('76','TR','Igidir',NULL),
	 ('77','TR','Yalova',NULL),
	 ('78','TR','Karabk',NULL),
	 ('79','TR','Kilis',NULL),
	 ('8','TR','Artvin',NULL),
	 ('80','TR','Osmaniye',NULL),
	 ('81','TR','Duzce',NULL),
	 ('9','TR','Aydin',NULL),
	 ('ARI','TT','Arima',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('CHA','TT','Chaguanas',NULL),
	 ('CTT','TT','Couva-Tabaquite-Talparo',NULL),
	 ('DMN','TT','Diego Martin',NULL),
	 ('ETO','TT','Eastern Tobago',NULL),
	 ('PED','TT','Penal-Debe',NULL),
	 ('POS','TT','Port of Spain',NULL),
	 ('PRT','TT','Princes Town',NULL),
	 ('PTF','TT','Point Fortin',NULL),
	 ('RCM','TT','Rio Claro-Mayaro',NULL),
	 ('SFO','TT','San Fernando',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('SGE','TT','Sangre Grande',NULL),
	 ('SIP','TT','Siparia',NULL),
	 ('SJL','TT','San Juan-Laventille',NULL),
	 ('TUP','TT','Tunapuna-Piarco',NULL),
	 ('WTO','TT','Western Tobago',NULL),
	 ('CHA','TW','Changhua',NULL),
	 ('CYQ','TW','Chiayi',NULL),
	 ('HSQ','TW','Hsinchu',NULL),
	 ('HUA','TW','Hualien',NULL),
	 ('ILA','TW','Ilan',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('KEE','TW','Keelung',NULL),
	 ('KHQ','TW','Kaohsiung',NULL),
	 ('MIA','TW','Miaoli',NULL),
	 ('NAN','TW','Nantou',NULL),
	 ('PEN','TW','Penghu',NULL),
	 ('PIF','TW','Pingtung',NULL),
	 ('TAO','TW','Taoyuan',NULL),
	 ('TNQ','TW','Tainan',NULL),
	 ('TPQ','TW','Taipei',NULL),
	 ('TTT','TW','Taitung',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('TXQ','TW','Taichung',NULL),
	 ('YUN','TW','Yunlin',NULL),
	 ('1','TZ','Arusha',NULL),
	 ('10','TZ','Rusini Pemba',NULL),
	 ('11','TZ','Kusini Unguja',NULL),
	 ('12','TZ','Lindi',NULL),
	 ('13','TZ','Mara',NULL),
	 ('14','TZ','Mbeya',NULL),
	 ('15','TZ','Mjini Magharibi',NULL),
	 ('16','TZ','Morogoro',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('17','TZ','Mtwara',NULL),
	 ('19','TZ','Pwani',NULL),
	 ('2','TZ','Dar-es-Salaam',NULL),
	 ('20','TZ','Rukwa',NULL),
	 ('21','TZ','Ruvuma',NULL),
	 ('22','TZ','Shinyanga',NULL),
	 ('23','TZ','Singida',NULL),
	 ('24','TZ','Tabora',NULL),
	 ('25','TZ','Tanga',NULL),
	 ('26','TZ','Manyara',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('3','TZ','Dodoma',NULL),
	 ('4','TZ','Iringa',NULL),
	 ('5','TZ','Kagera',NULL),
	 ('6','TZ','Kaskazini Pemba',NULL),
	 ('7','TZ','Kaskazini Unguja',NULL),
	 ('8','TZ','Xigoma',NULL),
	 ('9','TZ','Kilimanjaro',NULL),
	 ('12','UA','Dnipropetrovs''ka Oblast''',NULL),
	 ('14','UA','Donets''ka Oblast''',NULL),
	 ('18','UA','Zhytomyrs''ka Oblast''',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('21','UA','Zakarpats''ka Oblast''',NULL),
	 ('23','UA','Zaporiz''ka Oblast''',NULL),
	 ('26','UA','Ivano-Frankivs''ka Oblast''',NULL),
	 ('30','UA','Kyiv',NULL),
	 ('32','UA','Kyivs''ka Oblast''',NULL),
	 ('35','UA','Kirovohrads''ka Oblast''',NULL),
	 ('40','UA','Sevastopol',NULL),
	 ('43','UA','Respublika Krym',NULL),
	 ('46','UA','L''vivs''ka Oblast''',NULL),
	 ('48','UA','Mykolaivs''ka Oblast''',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('5','UA','Vinnyts''ka Oblast''',NULL),
	 ('51','UA','Odes ''ka Oblast''',NULL),
	 ('53','UA','Poltavs''ka Oblast''',NULL),
	 ('56','UA','Rivnens''ka Oblast''',NULL),
	 ('59','UA','Sums ''ka Oblast''',NULL),
	 ('61','UA','Ternopil''s''ka Oblast''',NULL),
	 ('63','UA','Kharkivs''ka Oblast''',NULL),
	 ('65','UA','Khersons''ka Oblast''',NULL),
	 ('68','UA','Khmel''nyts''ka Oblast''',NULL),
	 ('7','UA','Volyos''ka Oblast''',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('71','UA','Cherkas''ka Oblast''',NULL),
	 ('74','UA','Chernihivs''ka Oblast''',NULL),
	 ('77','UA','Chernivets''ka Oblast''',NULL),
	 ('9','UA','Luhans''ka Oblast''',NULL),
	 ('101','UG','Kalangala',NULL),
	 ('102','UG','Kampala',NULL),
	 ('103','UG','Kiboga',NULL),
	 ('104','UG','Luwero',NULL),
	 ('105','UG','Masaka',NULL),
	 ('106','UG','Mpigi',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('107','UG','Mubende',NULL),
	 ('108','UG','Mukono',NULL),
	 ('109','UG','Nakasongola',NULL),
	 ('110','UG','Rakai',NULL),
	 ('111','UG','Sembabule',NULL),
	 ('112','UG','Kayunga',NULL),
	 ('113','UG','Wakiso',NULL),
	 ('201','UG','Bugiri',NULL),
	 ('202','UG','Busia',NULL),
	 ('203','UG','Iganga',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('204','UG','Jinja',NULL),
	 ('205','UG','Kamuli',NULL),
	 ('206','UG','Kapchorwa',NULL),
	 ('207','UG','Katakwi',NULL),
	 ('208','UG','Kumi',NULL),
	 ('209','UG','Mbale',NULL),
	 ('210','UG','Pallisa',NULL),
	 ('211','UG','Soroti',NULL),
	 ('212','UG','Tororo',NULL),
	 ('213','UG','Kaberamaido',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('214','UG','Mayuge',NULL),
	 ('215','UG','Sironko',NULL),
	 ('301','UG','Adjumani',NULL),
	 ('302','UG','Apac',NULL),
	 ('303','UG','Arua',NULL),
	 ('304','UG','Gulu',NULL),
	 ('305','UG','Kitgum',NULL),
	 ('306','UG','Kotido',NULL),
	 ('307','UG','Lira',NULL),
	 ('308','UG','Moroto',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('309','UG','Moyo',NULL),
	 ('310','UG','Nebbi',NULL),
	 ('311','UG','Nakapiripirit',NULL),
	 ('312','UG','Pader',NULL),
	 ('313','UG','Yumbe',NULL),
	 ('401','UG','Bundibugyo',NULL),
	 ('402','UG','Bushenyi',NULL),
	 ('403','UG','Hoima',NULL),
	 ('404','UG','Kabale',NULL),
	 ('405','UG','Kabarole',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('406','UG','Kasese',NULL),
	 ('407','UG','Kibaale',NULL),
	 ('408','UG','Kisoro',NULL),
	 ('409','UG','Masindi',NULL),
	 ('410','UG','Mbarara',NULL),
	 ('411','UG','Ntungamo',NULL),
	 ('412','UG','Rukungiri',NULL),
	 ('413','UG','Kamwenge',NULL),
	 ('414','UG','Kanungu',NULL),
	 ('415','UG','Kyenjojo',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('67','UM','Johnston Atoll',NULL),
	 ('71','UM','Midway Islands',NULL),
	 ('76','UM','Navassa Island',NULL),
	 ('79','UM','Wake Ialand',NULL),
	 ('81','UM','Baker Island',NULL),
	 ('84','UM','Howland Island',NULL),
	 ('86','UM','Jarvis Island',NULL),
	 ('89','UM','Kingman Reef',NULL),
	 ('95','UM','Palmyra Atoll',NULL),
	 ('AA','US','Armed Forces Americas',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('AE','US','Armed Forces Europe',NULL),
	 ('AK','US','Alaska',NULL),
	 ('AL','US','Alabama',NULL),
	 ('AP','US','Armed Forces Pacific',NULL),
	 ('AR','US','Arkansas',NULL),
	 ('AS','US','American Samoa',NULL),
	 ('AZ','US','Arizona',NULL),
	 ('CA','US','California',NULL),
	 ('CO','US','Colorado',NULL),
	 ('CT','US','Connecticut',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('DC','US','District of Columbia',NULL),
	 ('DE','US','Delaware',NULL),
	 ('FL','US','Florida',NULL),
	 ('GA','US','Georgia',NULL),
	 ('GU','US','Guam',NULL),
	 ('HI','US','Hawaii',NULL),
	 ('IA','US','Iowa',NULL),
	 ('ID','US','Idaho',NULL),
	 ('IL','US','Illinois',NULL),
	 ('IN','US','Indiana',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('KS','US','Kansas',NULL),
	 ('KY','US','Kentucky',NULL),
	 ('LA','US','Louisiana',NULL),
	 ('MA','US','Massachusetts',NULL),
	 ('MD','US','Maryland',NULL),
	 ('ME','US','Maine',NULL),
	 ('MI','US','Michigan',NULL),
	 ('MN','US','Minnesota',NULL),
	 ('MO','US','Missouri',NULL),
	 ('MP','US','Northern Mariana Islands',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('MS','US','Mississippi',NULL),
	 ('MT','US','Montana',NULL),
	 ('NC','US','North Carolina',NULL),
	 ('ND','US','North Dakota',NULL),
	 ('NE','US','Nebraska',NULL),
	 ('NH','US','New Hampshire',NULL),
	 ('NJ','US','New Jersey',NULL),
	 ('NM','US','New Mexico',NULL),
	 ('NV','US','Nevada',NULL),
	 ('NY','US','New York',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('OH','US','Ohio',NULL),
	 ('OK','US','Oklahoma',NULL),
	 ('OR','US','Oregon',NULL),
	 ('PA','US','Pennsylvania',NULL),
	 ('PR','US','Puerto Rico',NULL),
	 ('RI','US','Rhode Island',NULL),
	 ('SC','US','South Carolina',NULL),
	 ('SD','US','South Dakota',NULL),
	 ('TN','US','Tennessee',NULL),
	 ('TX','US','Texas',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('UM','US','United States Minor Outlying Islands',NULL),
	 ('UT','US','Utah',NULL),
	 ('VA','US','Virginia',NULL),
	 ('VI','US','Virgin Islands',NULL),
	 ('VT','US','Vermont',NULL),
	 ('WA','US','Washington',NULL),
	 ('WI','US','Wisconsin',NULL),
	 ('WV','US','West Virginia',NULL),
	 ('WY','US','Wyoming',NULL),
	 ('AR','UY','Artigsa',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('CA','UY','Canelones',NULL),
	 ('CL','UY','Cerro Largo',NULL),
	 ('CO','UY','Colonia',NULL),
	 ('DU','UY','Durazno',NULL),
	 ('FS','UY','Flores',NULL),
	 ('LA','UY','Lavalleja',NULL),
	 ('MA','UY','Maldonado',NULL),
	 ('MO','UY','Montevideo',NULL),
	 ('PA','UY','Paysandu',NULL),
	 ('RO','UY','Rocha',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('RV','UY','Rivera',NULL),
	 ('SA','UY','Salto',NULL),
	 ('SO','UY','Soriano',NULL),
	 ('TA','UY','Tacuarembo',NULL),
	 ('TT','UY','Treinta y Tres',NULL),
	 ('AN','UZ','Andijon',NULL),
	 ('BU','UZ','Buxoro',NULL),
	 ('FA','UZ','Farg''ona',NULL),
	 ('JI','UZ','Jizzax',NULL),
	 ('KH','UZ','Khorazm',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('NG','UZ','Namangan',NULL),
	 ('NW','UZ','Navoiy',NULL),
	 ('QA','UZ','Qashqadaryo',NULL),
	 ('QR','UZ','Qoraqalpogiston Respublikasi',NULL),
	 ('SA','UZ','Samarqand',NULL),
	 ('SI','UZ','Sirdaryo',NULL),
	 ('SU','UZ','Surxondaryo',NULL),
	 ('TK','UZ','Toshkent (city)',NULL),
	 ('TO','UZ','Toshkent',NULL),
	 ('XO','UZ','Xorazm',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('A','VE','Diatrito Federal',NULL),
	 ('B','VE','Anzoategui',NULL),
	 ('C','VE','Apure',NULL),
	 ('D','VE','Aragua',NULL),
	 ('E','VE','Barinas',NULL),
	 ('G','VE','Carabobo',NULL),
	 ('H','VE','Cojedes',NULL),
	 ('I','VE','Falcon',NULL),
	 ('J','VE','Guarico',NULL),
	 ('K','VE','Lara',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('L','VE','Merida',NULL),
	 ('M','VE','Miranda',NULL),
	 ('N','VE','Monagas',NULL),
	 ('O','VE','Nueva Esparta',NULL),
	 ('P','VE','Portuguesa',NULL),
	 ('S','VE','Tachira',NULL),
	 ('T','VE','Trujillo',NULL),
	 ('U','VE','Yaracuy',NULL),
	 ('V','VE','Zulia',NULL),
	 ('W','VE','Dependencias Federales',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('X','VE','Vargas',NULL),
	 ('Y','VE','Delta Amacuro',NULL),
	 ('1','VN','Lai Chau',NULL),
	 ('13','VN','Quang Ninh',NULL),
	 ('14','VN','Hoa Binh',NULL),
	 ('15','VN','Ha Tay',NULL),
	 ('18','VN','Ninh Binh',NULL),
	 ('2','VN','Lao Cai',NULL),
	 ('20','VN','Thai Binh',NULL),
	 ('21','VN','Thanh Hoa',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('22','VN','Nghe An',NULL),
	 ('23','VN','Ha Tinh',NULL),
	 ('24','VN','Quang Binh',NULL),
	 ('25','VN','Quang Tri',NULL),
	 ('26','VN','Thua Thien-Hue',NULL),
	 ('27','VN','Quang Nam',NULL),
	 ('28','VN','Kon Tum',NULL),
	 ('29','VN','Quang Ngai',NULL),
	 ('3','VN','Ha Giang',NULL),
	 ('30','VN','Gia Lai',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('31','VN','Binh Dinh',NULL),
	 ('32','VN','Phu Yen',NULL),
	 ('33','VN','Dac Lac',NULL),
	 ('34','VN','Khanh Hoa',NULL),
	 ('35','VN','Lam Dong',NULL),
	 ('36','VN','Ninh Thuan',NULL),
	 ('37','VN','Tay Ninh',NULL),
	 ('39','VN','Dong Nai',NULL),
	 ('4','VN','Cao Bang',NULL),
	 ('40','VN','Binh Thuan',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('41','VN','Long An',NULL),
	 ('43','VN','Ba Ria - Vung Tau',NULL),
	 ('44','VN','An Giang',NULL),
	 ('45','VN','Dong Thap',NULL),
	 ('46','VN','Tien Giang',NULL),
	 ('47','VN','Kien Giang',NULL),
	 ('48','VN','Can Tho',NULL),
	 ('49','VN','Vinh Long',NULL),
	 ('5','VN','Son La',NULL),
	 ('50','VN','Ben Tre',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('51','VN','Tra Vinh',NULL),
	 ('52','VN','Soc Trang',NULL),
	 ('53','VN','Bac Can',NULL),
	 ('54','VN','Bac Giang',NULL),
	 ('55','VN','Bac Lieu',NULL),
	 ('56','VN','Bac Ninh',NULL),
	 ('57','VN','Binh Duong',NULL),
	 ('58','VN','Binh Phuoc',NULL),
	 ('59','VN','Ca Mau',NULL),
	 ('6','VN','Yen Bai',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('60','VN','Da Nang, thanh pho',NULL),
	 ('61','VN','Hai Duong',NULL),
	 ('62','VN','Hai Phong, thanh pho',NULL),
	 ('63','VN','Ha Nam',NULL),
	 ('64','VN','Ha Noi, thu do',NULL),
	 ('65','VN','Ho Chi Minh, thanh pho [Sai Gon]',NULL),
	 ('66','VN','Hung Yen',NULL),
	 ('67','VN','Nam Dinh',NULL),
	 ('68','VN','Phu Tho',NULL),
	 ('69','VN','Thai Nguyen',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('7','VN','Tuyen Quang',NULL),
	 ('70','VN','Vinh Phuc',NULL),
	 ('9','VN','Lang Son',NULL),
	 ('MAP','VU','Malampa',NULL),
	 ('PAM','VU','Penama',NULL),
	 ('SAM','VU','Sanma',NULL),
	 ('SEE','VU','Shefa',NULL),
	 ('TAE','VU','Tafea',NULL),
	 ('TOB','VU','Torba',NULL),
	 ('AA','WS','A''ana',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('AL','WS','Aiga-i-le-Tai',NULL),
	 ('AT','WS','Atua',NULL),
	 ('FA','WS','Fa''aaaleleaga',NULL),
	 ('GE','WS','Gaga''emauga',NULL),
	 ('GI','WS','Gagaifomauga',NULL),
	 ('PA','WS','Palauli',NULL),
	 ('SA','WS','Satupa''itea',NULL),
	 ('TU','WS','Tuamasaga',NULL),
	 ('VF','WS','Va''a-o-Fonoti',NULL),
	 ('VS','WS','Vaisigano',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('AB','YE','Abyan',NULL),
	 ('AD','YE','Adan',NULL),
	 ('AM','YE','Amran',NULL),
	 ('BA','YE','Al Bayda''',NULL),
	 ('DA','YE','Ad Dali',NULL),
	 ('DH','YE','Dhamar',NULL),
	 ('HD','YE','Hadramawt',NULL),
	 ('HJ','YE','Hajjah',NULL),
	 ('IB','YE','Ibb',NULL),
	 ('LA','YE','Lahij',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('MA','YE','Ma''rib',NULL),
	 ('MR','YE','Al Mahrah',NULL),
	 ('MU','YE','Al Hudaydah',NULL),
	 ('MW','YE','Al Mahwit',NULL),
	 ('SD','YE','Sa''dah',NULL),
	 ('SH','YE','Shabwah',NULL),
	 ('SN','YE','San''a''',NULL),
	 ('TA','YE','Ta''izz',NULL),
	 ('EC','ZA','Eastern Cape',NULL),
	 ('FS','ZA','Free State',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('GT','ZA','Gauteng',NULL),
	 ('MP','ZA','Mpumalanga',NULL),
	 ('NC','ZA','Northern Cape',NULL),
	 ('NL','ZA','Kwazulu-Natal',NULL),
	 ('NP','ZA','Limpopo',NULL),
	 ('NW','ZA','North West',NULL),
	 ('WC','ZA','Western Cape',NULL),
	 ('4','ZM','Luapula',NULL),
	 ('6','ZM','North-Western',NULL),
	 ('8','ZM','Copperbelt',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('9','ZM','Lusaka',NULL),
	 ('BU','ZW','Bulawayo',NULL),
	 ('HA','ZW','Harare',NULL),
	 ('MA','ZW','Manicaland',NULL),
	 ('MC','ZW','Mashonaland Central',NULL),
	 ('ME','ZW','Mashonaland East',NULL),
	 ('MI','ZW','Midlands',NULL),
	 ('MN','ZW','Matabeleland North',NULL),
	 ('MS','ZW','Matabeleland South',NULL),
	 ('MV','ZW','Masvingo',NULL);
INSERT INTO public.code_list_states (state_code,country_code,description,ord) VALUES
	 ('MW','ZW','Mashonaland West',NULL);


---------------------------------------------------------------------------------------------------------------------------------------------------------------

-- add codelists to code_lists
INSERT INTO public.code_lists ("table",description,editable,icon,meta) VALUES
	 ('code_list_registry_forms','Registry forms',false,NULL,NULL);
INSERT INTO public.code_lists ("table",description,editable,icon,meta) VALUES
	 ('code_list_registry_categories','Registry categories',false,NULL,NULL);
INSERT INTO public.code_lists ("table",description,editable,icon,meta) VALUES
	 ('code_list_countries','Countries',false,NULL,NULL);
INSERT INTO public.code_lists ("table",description,editable,icon,meta) VALUES
	 ('code_list_states','States',false,NULL,NULL);



---------------------------------------------------------------------------------------------------------------------------------------------------------------

INSERT INTO public.core_user_roles (id, role_name,hidden) VALUES
	(15, 'Registry',0); 

INSERT INTO core_permissions (code,permission_name,parent,permission_function,default_child,permission_namespace,"module",permission_description,permission_type,icon,ord,hidden,guest,meta) VALUES
	 ('BRFLFLT','registry_list_button_filters','SREGLW','','','registry/list','registry','Permission to filter lists button','BUT','fas fa-filter',1,false,false,NULL),
	 ('BRLSSRC','registry_list_button_search','SREGLW','','','registry/list','registry','Permission to search registry lists button','BUT','fas fa-search',1,false,false,NULL),
	 ('BRFREMV','registry_list_button_filters_remove','SREGLW','','','registry/list','registry','Permission to remove filters button','BUT','fas fa-times',1,false,false,NULL);

INSERT INTO core_assets (asset_type,asset_name,description,custom,asset_innerhtml,asset_parameters,asset_code,before_trigger,after_trigger,failure_rollback,exec_order,meta,role_id) VALUES
	 ('form','registry_list_filters_form','Form for registry list filters',false,NULL,'{"form": [[{"id": "entity_name", "cols": 3, "name": "entity_name", "type": "text", "label": "form_registry_list_filters_name", "mandatory": false, "onkeydown": "jivaCoreFunc.setFilter(event);", "filterType": "like"}, {"id": "entity_category", "cols": 3, "list": "/api/v1/misc/codelists/registry_categories", "name": "entity_category", "type": "dropdown", "label": "form_registry_list_filters_category", "onchange": "jivaCoreFunc.setFilter(event);", "mandatory": false}]]}',NULL,NULL,NULL,NULL,NULL,NULL,NULL);


INSERT INTO public.core_permissions (code,permission_name,parent,permission_function,default_child,permission_namespace,"module",permission_description,permission_type,icon,ord,hidden,guest,meta) VALUES
	 ('XRELEAD','registry_list_add_lead','SREGLE','addNewLead',NULL,'registry/list','registry','Add a new lead with registry','EXE',NULL,1,false,false,NULL);

INSERT INTO public.core_settings (setting_type,setting_name,value,properties,ord) VALUES
	 ('email_templates','new_lead_template','{"body": "<p>Buongiorno,</p>\n<p>hai una nuova richiesta per una demo.</p>\n\n<p>Lead Client: {client_name}</p>\n\n<p>Phone: {phone_number}</p>\n\n<p>Email: {email}</p>\n\n<p>Richiesta: {client_request}</p>", "types": {"message": "EMAIL"}, "sender": {"Name": "noReply", "Address": "admin@jivalabs.com"}, "subject": "New Lead", "recipients": [{"Name": "Jivalabs", "Address": "info@jivalabs.com"}]}','{"section_desc": "Change email templates", "section_icon": "fas fa-envelope-open-text", "setting_desc": "New Lead template", "setting_icon": "fas fa-thumbs-up", "section_button": "View templates", "setting_button": "Edit"}',20);
