pax_global_header 0000666 0000000 0000000 00000000064 13012652355 0014514 g ustar 00root root 0000000 0000000 52 comment=f0056a0d6a091762aa7a304576ec09929899dbdb
ref-itu-master/ 0000775 0000000 0000000 00000000000 13012652355 0013724 5 ustar 00root root 0000000 0000000 ref-itu-master/ref-itu.info 0000664 0000000 0000000 00000003547 13012652355 0016165 0 ustar 00root root 0000000 0000000
GPL V2.0 or any later version
Reference Data - ITU Code
Reference Data - ITU Codes
f
f
oracle
postgresql
Jon Griffin
Telecom Country codes, ITU-T Recommendation E.164 for acs-reference.
2016-11-15
Mayuli Enterprises, LLC
List of ITU-T Recommendation E.164 assigned country codes.
ref-itu-master/sql/ 0000775 0000000 0000000 00000000000 13012652355 0014523 5 ustar 00root root 0000000 0000000 ref-itu-master/sql/common/ 0000775 0000000 0000000 00000000000 13012652355 0016013 5 ustar 00root root 0000000 0000000 ref-itu-master/sql/common/ref-itu-data.sql 0000664 0000000 0000000 00000115277 13012652355 0021033 0 ustar 00root root 0000000 0000000 -- packages/ref-itu/sql/common/ref-itu-data.sql
--
-- @author jon@jongriffin.com.com
-- @creation-date 2003-02-25
-- @cvs-id $Id$
-- first insert the notes
insert into itu_notes values ('a','Assignment of all 0XX codes is feasible since 31 December 2000. Assignment of some of these codes may be possible as soon as 1 January 1997; this question is currently under study');
insert into itu_notes values ('b','Integrated numbering plan.');
insert into itu_notes values ('c','Code shared between Mayotte Island and Comoros (Islamic Federal Republic of the).');
insert into itu_notes values ('d','Will be allocated only after all three-digit codes from groups of ten are exhausted.');
insert into itu_notes values ('e','Associated with shared country code 878 for Universal Personal Telecommunications (UPT), the identification code "10" has been assigned to the network of VISIONng, +878 10.');
insert into itu_notes values ('f','Reserved for future use.');
insert into itu_notes values ('g','Including Australian Antarctic Territory and Norfolk Island.');
insert into itu_notes values ('h','U.A.E.: Abu Dhabi, Ajman, Dubai, Fujeirah, Ras Al Khaimah, Sharjah, Umm Al Qaiwain.');
insert into itu_notes values ('i','Including Christmas Island and Cocos-Keeling Islands.');
insert into itu_notes values ('j','Associated with shared country code 882, the following two-digit identification code reservations or assignments have been made for the international networks of:
Applicant
|
Network
|
Country Code and
Identification Code
|
Status
|
British Telecommunications plc
|
Global Office Application
|
+882 10
|
Assigned
|
ST Telecommunications Pte Ltd
|
Asia Pacific Mobile Telecommunications (APMT)
|
+882 11
|
Reserved
|
MCIWorldCom
|
HyperStream International (HSI) Data Network
|
+882 12
|
Assigned
|
Telespazio S.p.A.
|
EMS Regional Mobile Satellite System
|
+882 13
|
Assigned
|
Verizon
|
Global ATM Network
|
+882 14
|
Assigned
|
Telstra
|
Global international ATM Network
|
+882 15
|
Assigned
|
United Arab Emirates Administration
|
Thuraya RMSS Network
|
+882 16
|
Assigned
|
AT &T
|
AT &T International ATM Network
|
+882 17
|
Reserved
|
Telecom Italia
|
Telecom Italia Global Network
|
+882 19
|
Reserved
|
Asia Cellular Satellite (ACeS)
|
Garuda Mobile Telecommunication Satellite System
|
+882 20
|
Reserved
|
Cable & Wireless plc
|
Cable & Wireless Global Network
|
+882 22
|
Assigned
|
Sita-Equant Joint Venture
|
Sita-Equant Network
|
+882 23
|
Reserved
|
Telia AB
|
Telia multinational ATM Network
|
+882 24
|
Assigned
|
SBC Communications Inc.
|
Global Data Network
|
+882 26
|
Reserved
|
Williams Communications Inc.
|
Williams Communications Network
|
+882 27
|
Reserved
|
Deutsche Telekom
|
Deutsche Telekom multinational ATM network
|
+882 28
|
Reserved
|
Q-Tel (NZ) ltd. (ex-World IT)
|
SkyMessenger International Network
|
+882 29
|
Assigned
|
Singapore Telecom
|
Global Reach Network
|
+882 30
|
Reserved
|
Telekom Malaysia
|
Global International ATM Network
|
+882 31
|
Assigned
|
');
insert into itu_notes values ('k','Associated with shared country code 881, the following one-digit identification codes have been reserved for / assigned to the GMSS networks:
Network | Country Code and Identification Code | Status |
ICO Global Communications | +881 0 and +881 1 | Reserved |
Ellipso | +881 2 and +881 3 | Assigned |
Iridium Satellite LLC | +881 6 and +881 7 | Assigned |
Globalstar | +881 8 and +881 9 | Assigned |
');
insert into itu_notes values ('l','Reserved for the Palestinian Authority.');
insert into itu_notes values ('m','Reserved for Recommendation ITU-T E.164 country code expansion.');
insert into itu_notes values ('n','Associated with shared country code 388 for Group of countries, the following one-digit identification code has been assigned to the network of ETNS (European Telephony Numbering Space) +388 3.');
insert into itu_notes values ('o','Associated with shared country code 991, for trial, the three-digit trial identification code .001. has been temporarily assigned until May 2002 to Neustar for ENUM trials, +991 001.');
------
insert into itu_codes values (acs_object_id_seq.nextval,'0','Reserved','a');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Anguilla','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Antigua and Barbuda','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Bahamas (Commonwealth of the)','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Barbados','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Bermuda','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','British Virgin Islands','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Canada','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Cayman Islands','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Dominica (Commonwealth of)','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Dominican Republic','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Grenada','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Guam','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Jamaica','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Montserrat','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Northern Mariana Islands (Commonwealth of the)','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Puerto Rico','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Saint Kitts and Nevis','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Saint Lucia','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Saint Vincent and the Grenadines','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Trinidad and Tobago','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','Turks and Caicos Islands','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','United States of America','b');
insert into itu_codes values (acs_object_id_seq.nextval,'1','United States Virgin Islands','b');
insert into itu_codes values (acs_object_id_seq.nextval,'20','Egypt (Arab Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'210','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'211','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'212','Morocco (Kingdom of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'213','Algeria (People''s Democratic Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'214','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'215','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'216','Tunisia',null);
insert into itu_codes values (acs_object_id_seq.nextval,'217','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'218','Libya (Socialist People''s Libyan Arab Jamahiriya)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'219','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'220','Gambia (Republic of the)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'221','Senegal (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'222','Mauritania (Islamic Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'223','Mali (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'224','Guinea (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'225','Cte d''Ivoire (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'226','Burkina Faso',null);
insert into itu_codes values (acs_object_id_seq.nextval,'227','Niger (Republic of the)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'228','Togolese Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'229','Benin (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'230','Mauritius (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'231','Liberia (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'232','Sierra Leone',null);
insert into itu_codes values (acs_object_id_seq.nextval,'233','Ghana',null);
insert into itu_codes values (acs_object_id_seq.nextval,'234','Nigeria (Federal Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'235','Chad (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'236','Central African Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'237','Cameroon (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'238','Cape Verde (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'239','Sao Tome and Principe (Democratic Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'240','Equatorial Guinea (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'241','Gabonese Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'242','Congo (Republic of the)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'243','Democratic Republic of the Congo',null);
insert into itu_codes values (acs_object_id_seq.nextval,'244','Angola (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'245','Guinea-Bissau (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'246','Diego Garcia',null);
insert into itu_codes values (acs_object_id_seq.nextval,'247','Ascension',null);
insert into itu_codes values (acs_object_id_seq.nextval,'248','Seychelles (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'249','Sudan (Republic of the)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'250','Rwandese Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'251','Ethiopia (Federal Democratic Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'252','Somali Democratic Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'253','Djibouti (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'254','Kenya (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'255','Tanzania (United Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'256','Uganda (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'257','Burundi (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'258','Mozambique (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'259','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'260','Zambia (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'261','Madagascar (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'262','Reunion (French Department of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'263','Zimbabwe (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'264','Namibia (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'265','Malawi',null);
insert into itu_codes values (acs_object_id_seq.nextval,'266','Lesotho (Kingdom of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'267','Botswana (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'268','Swaziland (Kingdom of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'269','Comoros (Islamic Federal Republic of the)','c');
insert into itu_codes values (acs_object_id_seq.nextval,'269','Mayotte (Collective Territory Republic of France)','c');
insert into itu_codes values (acs_object_id_seq.nextval,'27','South Africa (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'280','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'281','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'282','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'283','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'284','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'285','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'286','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'287','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'288','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'289','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'290','Saint Helena',null);
insert into itu_codes values (acs_object_id_seq.nextval,'291','Eritrea',null);
insert into itu_codes values (acs_object_id_seq.nextval,'292','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'293','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'294','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'295','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'296','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'297','Aruba',null);
insert into itu_codes values (acs_object_id_seq.nextval,'298','Faroe Islands',null);
insert into itu_codes values (acs_object_id_seq.nextval,'299','Greenland (Denmark)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'30','Greece',null);
insert into itu_codes values (acs_object_id_seq.nextval,'31','Netherlands (Kingdom of the)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'32','Belgium',null);
insert into itu_codes values (acs_object_id_seq.nextval,'33','France',null);
insert into itu_codes values (acs_object_id_seq.nextval,'34','Spain',null);
insert into itu_codes values (acs_object_id_seq.nextval,'350','Gibraltar',null);
insert into itu_codes values (acs_object_id_seq.nextval,'351','Portugal',null);
insert into itu_codes values (acs_object_id_seq.nextval,'352','Luxembourg',null);
insert into itu_codes values (acs_object_id_seq.nextval,'353','Ireland',null);
insert into itu_codes values (acs_object_id_seq.nextval,'354','Iceland',null);
insert into itu_codes values (acs_object_id_seq.nextval,'355','Albania (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'356','Malta',null);
insert into itu_codes values (acs_object_id_seq.nextval,'357','Cyprus (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'358','Finland',null);
insert into itu_codes values (acs_object_id_seq.nextval,'359','Bulgaria (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'36','Hungary (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'370','Lithuania (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'371','Latvia (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'372','Estonia (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'373','Moldova (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'374','Armenia (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'375','Belarus (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'376','Andorra (Principality of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'377','Monaco (Principality of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'378','San Marino (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'379','Vatican City State','f');
insert into itu_codes values (acs_object_id_seq.nextval,'380','Ukraine',null);
insert into itu_codes values (acs_object_id_seq.nextval,'381','Yugoslavia (Federal Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'382','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'383','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'384','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'385','Croatia (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'386','Slovenia (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'387','Bosnia and Herzegovina',null);
insert into itu_codes values (acs_object_id_seq.nextval,'388','Group of countries,shared code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'389','The Former Yugoslav Republic of Macedonia',null);
insert into itu_codes values (acs_object_id_seq.nextval,'39','Italy',null);
insert into itu_codes values (acs_object_id_seq.nextval,'39','Vatican City State',null);
insert into itu_codes values (acs_object_id_seq.nextval,'40','Romania',null);
insert into itu_codes values (acs_object_id_seq.nextval,'41','Switzerland (Confederation of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'420','Czech Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'421','Slovak Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'422','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'423','Liechtenstein (Principality of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'424','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'425','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'426','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'427','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'428','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'429','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'43','Austria',null);
insert into itu_codes values (acs_object_id_seq.nextval,'44','United Kingdom of Great Britain and Northern Ireland',null);
insert into itu_codes values (acs_object_id_seq.nextval,'45','Denmark',null);
insert into itu_codes values (acs_object_id_seq.nextval,'46','Sweden',null);
insert into itu_codes values (acs_object_id_seq.nextval,'47','Norway',null);
insert into itu_codes values (acs_object_id_seq.nextval,'48','Poland (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'49','Germany (Federal Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'500','Falkland Islands (Malvinas)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'501','Belize',null);
insert into itu_codes values (acs_object_id_seq.nextval,'502','Guatemala (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'503','El Salvador (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'504','Honduras (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'505','Nicaragua',null);
insert into itu_codes values (acs_object_id_seq.nextval,'506','Costa Rica',null);
insert into itu_codes values (acs_object_id_seq.nextval,'507','Panama (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'508','Saint Pierre and Miquelon (Collectivite territoriale de la Republique francaise)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'509','Haiti (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'51','Peru',null);
insert into itu_codes values (acs_object_id_seq.nextval,'52','Mexico',null);
insert into itu_codes values (acs_object_id_seq.nextval,'53','Cuba',null);
insert into itu_codes values (acs_object_id_seq.nextval,'54','Argentine Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'55','Brazil (Federative Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'56','Chile',null);
insert into itu_codes values (acs_object_id_seq.nextval,'57','Colombia (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'58','Venezuela (Bolivarian Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'590','Guadeloupe (French Department of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'591','Bolivia (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'592','Guyana',null);
insert into itu_codes values (acs_object_id_seq.nextval,'593','Ecuador',null);
insert into itu_codes values (acs_object_id_seq.nextval,'594','French Guiana (French Department of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'595','Paraguay (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'596','Martinique (French Department of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'597','Suriname (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'598','Uruguay (Eastern Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'599','Netherlands Antilles',null);
insert into itu_codes values (acs_object_id_seq.nextval,'60','Malaysia',null);
insert into itu_codes values (acs_object_id_seq.nextval,'61','Australia','i');
insert into itu_codes values (acs_object_id_seq.nextval,'62','Indonesia (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'63','Philippines (Republic of the)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'64','New Zealand',null);
insert into itu_codes values (acs_object_id_seq.nextval,'65','Singapore (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'66','Thailand',null);
insert into itu_codes values (acs_object_id_seq.nextval,'670','East Timor',null);
insert into itu_codes values (acs_object_id_seq.nextval,'671','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'672','Australian External Territories','g');
insert into itu_codes values (acs_object_id_seq.nextval,'673','Brunei Darussalam',null);
insert into itu_codes values (acs_object_id_seq.nextval,'674','Nauru (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'675','Papua New Guinea',null);
insert into itu_codes values (acs_object_id_seq.nextval,'676','Tonga (Kingdom of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'677','Solomon Islands',null);
insert into itu_codes values (acs_object_id_seq.nextval,'678','Vanuatu (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'679','Fiji (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'680','Palau (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'681','Wallis and Futuna (Territoire francais d''outre-mer)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'682','Cook Islands',null);
insert into itu_codes values (acs_object_id_seq.nextval,'683','Niue',null);
insert into itu_codes values (acs_object_id_seq.nextval,'684','American Samoa',null);
insert into itu_codes values (acs_object_id_seq.nextval,'685','Samoa (Independent State of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'686','Kiribati (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'687','New Caledonia (Territoire francais d''outre-mer)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'688','Tuvalu',null);
insert into itu_codes values (acs_object_id_seq.nextval,'689','French Polynesia (Territoire francais d''outre-mer)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'690','Tokelau',null);
insert into itu_codes values (acs_object_id_seq.nextval,'691','Micronesia (Federated States of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'692','Marshall Islands (Republic of the)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'693','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'694','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'695','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'696','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'697','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'698','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'699','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'7','Kazakstan (Republic of)','b');
insert into itu_codes values (acs_object_id_seq.nextval,'7','Russian Federation','b');
insert into itu_codes values (acs_object_id_seq.nextval,'800','International Freephone Service',null);
insert into itu_codes values (acs_object_id_seq.nextval,'801','Spare code','d');
insert into itu_codes values (acs_object_id_seq.nextval,'802','Spare code','d');
insert into itu_codes values (acs_object_id_seq.nextval,'803','Spare code','d');
insert into itu_codes values (acs_object_id_seq.nextval,'804','Spare code','d');
insert into itu_codes values (acs_object_id_seq.nextval,'805','Spare code','d');
insert into itu_codes values (acs_object_id_seq.nextval,'806','Spare code','d');
insert into itu_codes values (acs_object_id_seq.nextval,'807','Spare code','d');
insert into itu_codes values (acs_object_id_seq.nextval,'808','International Shared Cost Service (ISCS)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'809','Spare code','d');
insert into itu_codes values (acs_object_id_seq.nextval,'81','Japan',null);
insert into itu_codes values (acs_object_id_seq.nextval,'82','Korea (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'830','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'831','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'832','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'833','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'834','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'835','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'836','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'837','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'838','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'839','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'84','Viet Nam (Socialist Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'850','Democratic People''s Republic of Korea',null);
insert into itu_codes values (acs_object_id_seq.nextval,'851','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'852','Hongkong,China',null);
insert into itu_codes values (acs_object_id_seq.nextval,'853','Macao,China',null);
insert into itu_codes values (acs_object_id_seq.nextval,'854','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'855','Cambodia (Kingdom of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'856','Lao People''s Democratic Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'857','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'858','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'859','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'86','China (People''s Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'870','Inmarsat SNAC',null);
insert into itu_codes values (acs_object_id_seq.nextval,'871','Inmarsat (Atlantic Ocean-East)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'872','Inmarsat (Pacific Ocean)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'873','Inmarsat (Indian Ocean)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'874','Inmarsat (Atlantic Ocean-West)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'875','Reserved ? Maritime Mobile Service Applications',null);
insert into itu_codes values (acs_object_id_seq.nextval,'876','Reserved ? Maritime Mobile Service Applications',null);
insert into itu_codes values (acs_object_id_seq.nextval,'877','Reserved ? Maritime Mobile Service Applications',null);
insert into itu_codes values (acs_object_id_seq.nextval,'878','Reserved ? Universal Personal Telecommunication Service (UPT)','e');
insert into itu_codes values (acs_object_id_seq.nextval,'879','Reserved for national non-commercial purposes',null);
insert into itu_codes values (acs_object_id_seq.nextval,'880','Bangladesh (People''s Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'881','Global Mobile Satellite System (GMSS),shared code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'882','International Networks,shared code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'883','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'884','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'885','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'886','Reserved',null);
insert into itu_codes values (acs_object_id_seq.nextval,'887','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'888','Reserved for future global service',null);
insert into itu_codes values (acs_object_id_seq.nextval,'889','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'890','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'891','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'892','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'893','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'894','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'895','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'896','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'897','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'898','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'899','Spare code','m');
insert into itu_codes values (acs_object_id_seq.nextval,'90','Turkey',null);
insert into itu_codes values (acs_object_id_seq.nextval,'91','India (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'92','Pakistan (Islamic Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'93','Afghanistan (Islamic State of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'94','Sri Lanka (Democratic Socialist Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'95','Myanmar (Union of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'960','Maldives (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'961','Lebanon',null);
insert into itu_codes values (acs_object_id_seq.nextval,'962','Jordan (Hashemite Kingdom of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'963','Syrian Arab Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'964','Iraq (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'965','Kuwait (State of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'966','Saudi Arabia (Kingdom of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'967','Yemen (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'968','Oman (Sultanate of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'969','Reserved - Reservation currently under investigation',null);
insert into itu_codes values (acs_object_id_seq.nextval,'970','Reserved','l');
insert into itu_codes values (acs_object_id_seq.nextval,'971','United Arab Emirates','h');
insert into itu_codes values (acs_object_id_seq.nextval,'972','Israel (State of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'973','Bahrain (Kingdom of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'974','Qatar (State of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'975','Bhutan (Kingdom of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'976','Mongolia',null);
insert into itu_codes values (acs_object_id_seq.nextval,'977','Nepal',null);
insert into itu_codes values (acs_object_id_seq.nextval,'978','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'979','International Premium Rate Service (IPRS)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'98','Iran (Islamic Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'990','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'991','Trial of a proposed new international telecommunication public correspondence service,shared code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'992','Tajikistan (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'993','Turkmenistan',null);
insert into itu_codes values (acs_object_id_seq.nextval,'994','Azerbaijani Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'995','Georgia',null);
insert into itu_codes values (acs_object_id_seq.nextval,'996','Kyrgyz Republic',null);
insert into itu_codes values (acs_object_id_seq.nextval,'997','Spare code',null);
insert into itu_codes values (acs_object_id_seq.nextval,'998','Uzbekistan (Republic of)',null);
insert into itu_codes values (acs_object_id_seq.nextval,'999','Spare code',null);
ref-itu-master/sql/oracle/ 0000775 0000000 0000000 00000000000 13012652355 0015770 5 ustar 00root root 0000000 0000000 ref-itu-master/sql/oracle/ref-itu-create.sql 0000664 0000000 0000000 00000003067 13012652355 0021333 0 ustar 00root root 0000000 0000000 -- packages/ref-itu/sql/postgresql/ref-itu-create.sql
--
-- @author jon@jongriffin.com.com
-- @creation-date 2003-02-25
-- @cvs-id $Id$
create table itu_notes (
note_id char(3)
constraint itu_notes_id_pk
primary key,
note varchar(1024)
constraint itu_notes_note_nn
not null
constraint itu_notes_note_uq
unique
);
create table itu_codes (
itu_id integer
constraint itu_code_pk
primary key,
code char(6)
constraint itu_code_nn
not null,
country varchar(100)
constraint itu_country_nn
not null,
note_id char(3)
constraint itu_codes_note_fk
references itu_notes (note_id)
);
comment on table itu_codes is '
This is the ITU country dialing code list.
';
-- add this table into the reference repository
declare
v_id integer;
begin
v_id := acs_reference.new (
table_name => 'itu_codes',
last_update => to_date('2002-05-01','YYYY-MM-DD'),
source => 'ITU',
source_url => 'http://www.itu.int/',
effective_date => '2002-05-01'
);
commit;
end;
/
-- This is the translated mapping of country names
-- Need to see if ITU used the same country names as ISO and if so, we can use those for
-- translated names, but they have some non-country names
@ '../common/ref-itu-data.sql'
ref-itu-master/sql/oracle/ref-itu-drop.sql 0000664 0000000 0000000 00000001762 13012652355 0021034 0 ustar 00root root 0000000 0000000 -- Drop the ACS Reference ITU data
--
-- @author jon@jongriffin.com
-- @cvs-id $Id$
set serveroutput on
-- drop all associated tables and packages
-- I am not sure this is a good idea since we have no way to register
-- if any other packages are using this data.
-- This will probably fail if their is a child table using this.
-- I can probably make this cleaner also, but ... no time today
declare
cursor refsrc_cur is
select table_name,
package_name,
repository_id
from acs_reference_repositories
where upper(table_name) like 'ITU_CODE%'
order by repository_id desc;
begin
for rec in refsrc_cur loop
dbms_output.put_line('Dropping ' || rec.table_name);
execute immediate 'drop table ' || rec.table_name;
if rec.package_name is not null then
execute immediate 'drop package ' || rec.package_name;
end if;
acs_reference.del(rec.repository_id);
end loop;
end;
/
show errors
-- drop the notes
drop table itu_notes;
ref-itu-master/sql/postgresql/ 0000775 0000000 0000000 00000000000 13012652355 0016726 5 ustar 00root root 0000000 0000000 ref-itu-master/sql/postgresql/ref-itu-create.sql 0000664 0000000 0000000 00000002725 13012652355 0022271 0 ustar 00root root 0000000 0000000 -- packages/ref-itu/sql/postgresql/ref-itu-create.sql
--
-- @author jon@jongriffin.com.com
-- @creation-date 2003-02-25
-- @cvs-id $Id$
create table itu_notes (
note_id char(3)
constraint itu_notes_id_pk
primary key,
note text
constraint itu_notes_note_nn
not null
constraint itu_notes_note_uq
unique
);
create table itu_codes (
itu_id integer
constraint itu_code_pk
primary key,
code char(6)
constraint itu_code_nn
not null,
country varchar(100)
constraint itu_country_nn
not null,
note_id char(3)
constraint itu_codes_note_fk
references itu_notes (note_id)
);
comment on table itu_codes is '
This is the ITU country dialing code list.
';
-- add this table into the reference repository
select acs_reference__new (
'itu_codes', -- table_name
'2002-05-01',
'ITU', -- source
'http://www.itu.int/', -- source_url
to_date('2002-05-01','YYYY-MM-DD') -- effective_date
);
-- This is the translated mapping of country names
-- Need to see if ITU used the same country names as ISO and if so, we can use those for
-- translated names, but they have some non-country names
begin;
\i ../common/ref-itu-data.sql
end;
ref-itu-master/sql/postgresql/ref-itu-drop.sql 0000664 0000000 0000000 00000001505 13012652355 0021765 0 ustar 00root root 0000000 0000000 -- Drop the ACS Reference ITU data
--
-- @author jon@jongriffin.com
-- @cvs-id $Id$
-- drop all associated tables and packages
-- I am not sure this is a good idea since we have no way to register
-- if any other packages are using this data.
-- This will probably fail if their is a child table using this.
-- I can probably make this cleaner also, but ... no time today
create function inline_0() returns integer as '
declare
rec acs_reference_repositories%ROWTYPE;
begin
for rec in select * from acs_reference_repositories where upper(table_name) like ''ITU_CODE%'' loop
execute ''drop table '' || rec.table_name;
perform acs_reference__delete(rec.repository_id);
end loop;
return 0;
end;' language 'plpgsql';
select inline_0();
drop function inline_0();
-- drop the notes
drop table itu_notes;