Mailinglisten-Archive

Re: Domain/Country-Tabelle?

Archiv Mailingliste mysql-de

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Domain/Country-Tabelle?

Subject: Re: Domain/Country-Tabelle?
From: Thomas Feyrer <Dante_(at)_altmuehlnet.de>
Date: Thu, 29 Jul 1999 15:25:21 +0200
In-Reply-To: <00a901bed9c3$d699b400$0428090a_(at)_pc4.schleupen.de>
Old-Return-Path: <Dante_(at)_altmuehlnet.de>
Reply-To: mysql-de_(at)_lists.4t2.com

At 15:11 29.07.99 +0200, Stefan Hundenborn wrote:
>Bei den URLs ist aber keine dabei, die alle korrekten Domain Endungen hat,
>z.B.
>uk für England
>in für Indien

Hi Stefan,
das gleiche hab ich leider auch bemerken müssen, also hab ich noch 'n
bisschen gesucht, und siehe da:
http://koi.cs.columbia.edu/~min/misc/suffix.html

Hab's grad schnell in ne MySQL-Table reingehaun... (s. Attachment)

PS (für Andreas Kempf): An dem zip-file wäre ich auch interresiert!

Bye
 Dante

# MySQL dump 5.12
#
# Host: localhost    Database: Abk
#--------------------------------------------------------
# Server version	3.22.16a-gamma

#
# Table structure for table 'domains'
#
CREATE TABLE domains (
  id int(8) DEFAULT '0' NOT NULL auto_increment,
  kuerzel varchar(4) DEFAULT '' NOT NULL,
  bezeichnung varchar(50) DEFAULT '' NOT NULL,
  ist_land enum('Y','N') DEFAULT 'Y' NOT NULL,
  PRIMARY KEY (id)
);

#
# Dumping data for table 'domains'
#

INSERT INTO domains VALUES (1,'AD','Andorra','Y');
INSERT INTO domains VALUES (2,'AE','United Arab Emirates','Y');
INSERT INTO domains VALUES (3,'AF','Afghanistan','Y');
INSERT INTO domains VALUES (4,'AG','Antigua and Barbuda','Y');
INSERT INTO domains VALUES (5,'AI','Anguilla','Y');
INSERT INTO domains VALUES (6,'AL','Albania','Y');
INSERT INTO domains VALUES (7,'AM','Armenia','Y');
INSERT INTO domains VALUES (8,'AN','Netherland Antilles','Y');
INSERT INTO domains VALUES (9,'AO','Angola','Y');
INSERT INTO domains VALUES (10,'AQ','Antarctica','Y');
INSERT INTO domains VALUES (11,'AR','Argentina','Y');
INSERT INTO domains VALUES (12,'AS','American Samoa','Y');
INSERT INTO domains VALUES (13,'AT','Austria','Y');
INSERT INTO domains VALUES (14,'AU','Australia','Y');
INSERT INTO domains VALUES (15,'AW','Aruba','Y');
INSERT INTO domains VALUES (16,'AZ','Azerbaidjan','Y');
INSERT INTO domains VALUES (17,'BA','Bosnia-Herzegovina','Y');
INSERT INTO domains VALUES (18,'BB','Barbados','Y');
INSERT INTO domains VALUES (19,'BD','Banglades','Y');
INSERT INTO domains VALUES (20,'BE','Belgium','Y');
INSERT INTO domains VALUES (21,'BF','Burkina Faso','Y');
INSERT INTO domains VALUES (22,'BG','Bulgaria','Y');
INSERT INTO domains VALUES (23,'BH','Bahrain','Y');
INSERT INTO domains VALUES (24,'BI','Burundi','Y');
INSERT INTO domains VALUES (25,'BJ','Benin','Y');
INSERT INTO domains VALUES (26,'BM','Bermuda','Y');
INSERT INTO domains VALUES (27,'BN','Brunei Darussalam','Y');
INSERT INTO domains VALUES (28,'BO','Bolivia','Y');
INSERT INTO domains VALUES (29,'BR','Brazil','Y');
INSERT INTO domains VALUES (30,'BS','Bahamas','Y');
INSERT INTO domains VALUES (31,'BT','Buthan','Y');
INSERT INTO domains VALUES (32,'BV','Bouvet Island','Y');
INSERT INTO domains VALUES (33,'BW','Botswana','Y');
INSERT INTO domains VALUES (34,'BY','Belarus','Y');
INSERT INTO domains VALUES (35,'BZ','Belize','Y');
INSERT INTO domains VALUES (36,'CA','Canada','Y');
INSERT INTO domains VALUES (37,'CC','Cocos (Keeling) Islands','Y');
INSERT INTO domains VALUES (38,'CF','Central African Republic','Y');
INSERT INTO domains VALUES (39,'CG','Congo','Y');
INSERT INTO domains VALUES (40,'CH','Switzerland','Y');
INSERT INTO domains VALUES (41,'CI','Ivory Coast','Y');
INSERT INTO domains VALUES (42,'CK','Cook Islands','Y');
INSERT INTO domains VALUES (43,'CL','Chile','Y');
INSERT INTO domains VALUES (44,'CM','Cameroon','Y');
INSERT INTO domains VALUES (45,'CN','China','Y');
INSERT INTO domains VALUES (46,'CO','Colombia','Y');
INSERT INTO domains VALUES (47,'CR','Costa Rica','Y');
INSERT INTO domains VALUES (48,'CS','Czechoslovakia','Y');
INSERT INTO domains VALUES (49,'CU','Cuba','Y');
INSERT INTO domains VALUES (50,'CV','Cape Verde','Y');
INSERT INTO domains VALUES (51,'CX','Christmas Island','Y');
INSERT INTO domains VALUES (52,'CY','Cyprus','Y');
INSERT INTO domains VALUES (53,'CZ','Czech Republic','Y');
INSERT INTO domains VALUES (54,'DE','Germany','Y');
INSERT INTO domains VALUES (55,'DJ','Djibouti','Y');
INSERT INTO domains VALUES (56,'DK','Denmark','Y');
INSERT INTO domains VALUES (57,'DM','Dominica','Y');
INSERT INTO domains VALUES (58,'DO','Dominican Republic','Y');
INSERT INTO domains VALUES (59,'DZ','Algeria','Y');
INSERT INTO domains VALUES (60,'EC','Ecuador','Y');
INSERT INTO domains VALUES (61,'EE','Estonia','Y');
INSERT INTO domains VALUES (62,'EG','Egypt','Y');
INSERT INTO domains VALUES (63,'EH','Western Sahara','Y');
INSERT INTO domains VALUES (64,'ES','Spain','Y');
INSERT INTO domains VALUES (65,'ET','Ethiopia','Y');
INSERT INTO domains VALUES (66,'FI','Finland','Y');
INSERT INTO domains VALUES (67,'FJ','Fiji','Y');
INSERT INTO domains VALUES (68,'FK','Falkland Islands (Malvinas)','Y');
INSERT INTO domains VALUES (69,'FM','Micronesia','Y');
INSERT INTO domains VALUES (70,'FO','Faroe Islands','Y');
INSERT INTO domains VALUES (71,'FR','France','Y');
INSERT INTO domains VALUES (72,'FX','France (European Territory)','Y');
INSERT INTO domains VALUES (73,'GA','Gabon','Y');
INSERT INTO domains VALUES (74,'GB','Great Britain (UK)','Y');
INSERT INTO domains VALUES (75,'GD','Grenada','Y');
INSERT INTO domains VALUES (76,'GE','Georgia','Y');
INSERT INTO domains VALUES (77,'GH','Ghana','Y');
INSERT INTO domains VALUES (78,'GI','Gibraltar','Y');
INSERT INTO domains VALUES (79,'GL','Greenland','Y');
INSERT INTO domains VALUES (80,'GP','Guadeloupe (French)','Y');
INSERT INTO domains VALUES (81,'GQ','Equatorial Guinea','Y');
INSERT INTO domains VALUES (82,'GF','Guyana (French)','Y');
INSERT INTO domains VALUES (83,'GM','Gambia','Y');
INSERT INTO domains VALUES (84,'GN','Guinea','Y');
INSERT INTO domains VALUES (85,'GR','Greece','Y');
INSERT INTO domains VALUES (86,'GT','Guatemala','Y');
INSERT INTO domains VALUES (87,'GU','Guam (US)','Y');
INSERT INTO domains VALUES (88,'GW','Guinea Bissau','Y');
INSERT INTO domains VALUES (89,'GY','Guyana','Y');
INSERT INTO domains VALUES (90,'HK','Hong Kong','Y');
INSERT INTO domains VALUES (91,'HM','Heard and McDonald Islands','Y');
INSERT INTO domains VALUES (92,'HN','Honduras','Y');
INSERT INTO domains VALUES (93,'HR','Croatia','Y');
INSERT INTO domains VALUES (94,'HT','Haiti','Y');
INSERT INTO domains VALUES (95,'HU','Hungary','Y');
INSERT INTO domains VALUES (96,'ID','Indonesia','Y');
INSERT INTO domains VALUES (97,'IE','Ireland','Y');
INSERT INTO domains VALUES (98,'IL','Israel','Y');
INSERT INTO domains VALUES (99,'IN','India','Y');
INSERT INTO domains VALUES (100,'IO','British Indian Ocean Territory','Y');
INSERT INTO domains VALUES (101,'IQ','Iraq','Y');
INSERT INTO domains VALUES (102,'IR','Iran','Y');
INSERT INTO domains VALUES (103,'IS','Iceland','Y');
INSERT INTO domains VALUES (104,'IT','Italy','Y');
INSERT INTO domains VALUES (105,'JM','Jamaica','Y');
INSERT INTO domains VALUES (106,'JO','Jordan','Y');
INSERT INTO domains VALUES (107,'JP','Japan','Y');
INSERT INTO domains VALUES (108,'KE','Kenya','Y');
INSERT INTO domains VALUES (109,'KG','Kirgistan','Y');
INSERT INTO domains VALUES (110,'KH','Cambodia','Y');
INSERT INTO domains VALUES (111,'KI','Kiribati','Y');
INSERT INTO domains VALUES (112,'KM','Comoros','Y');
INSERT INTO domains VALUES (113,'KN','Saint Kitts Nevis Anguilla','Y');
INSERT INTO domains VALUES (114,'KP','North Korea','Y');
INSERT INTO domains VALUES (115,'KR','South Korea','Y');
INSERT INTO domains VALUES (116,'KW','Kuwait','Y');
INSERT INTO domains VALUES (117,'KY','Cayman Islands','Y');
INSERT INTO domains VALUES (118,'KZ','Kazachstan','Y');
INSERT INTO domains VALUES (119,'LA','Laos','Y');
INSERT INTO domains VALUES (120,'LB','Lebanon','Y');
INSERT INTO domains VALUES (121,'LC','Saint Lucia','Y');
INSERT INTO domains VALUES (122,'LI','Liechtenstein','Y');
INSERT INTO domains VALUES (123,'LK','Sri Lanka','Y');
INSERT INTO domains VALUES (124,'LR','Liberia','Y');
INSERT INTO domains VALUES (125,'LS','Lesotho','Y');
INSERT INTO domains VALUES (126,'LT','Lithuania','Y');
INSERT INTO domains VALUES (127,'LU','Luxembourg','Y');
INSERT INTO domains VALUES (128,'LV','Latvia','Y');
INSERT INTO domains VALUES (129,'LY','Libya','Y');
INSERT INTO domains VALUES (130,'MA','Morocco','Y');
INSERT INTO domains VALUES (131,'MC','Monaco','Y');
INSERT INTO domains VALUES (132,'MD','Moldavia','Y');
INSERT INTO domains VALUES (133,'MG','Madagascar','Y');
INSERT INTO domains VALUES (134,'MH','Marshall Islands','Y');
INSERT INTO domains VALUES (135,'ML','Mali','Y');
INSERT INTO domains VALUES (136,'MM','Myanmar','Y');
INSERT INTO domains VALUES (137,'MN','Mongolia','Y');
INSERT INTO domains VALUES (138,'MO','Macau','Y');
INSERT INTO domains VALUES (139,'MP','Northern Mariana Islands','Y');
INSERT INTO domains VALUES (140,'MQ','Martinique (French)','Y');
INSERT INTO domains VALUES (141,'MR','Mauritania','Y');
INSERT INTO domains VALUES (142,'MS','Montserrat','Y');
INSERT INTO domains VALUES (143,'MT','Malta','Y');
INSERT INTO domains VALUES (144,'MU','Mauritius','Y');
INSERT INTO domains VALUES (145,'MV','Maldives','Y');
INSERT INTO domains VALUES (146,'MW','Malawi','Y');
INSERT INTO domains VALUES (147,'MX','Mexico','Y');
INSERT INTO domains VALUES (148,'MY','Malaysia','Y');
INSERT INTO domains VALUES (149,'MZ','Mozambique','Y');
INSERT INTO domains VALUES (150,'NA','Namibia','Y');
INSERT INTO domains VALUES (151,'NC','New Caledonia (French)','Y');
INSERT INTO domains VALUES (152,'NE','Niger','Y');
INSERT INTO domains VALUES (153,'NF','Norfolk Island','Y');
INSERT INTO domains VALUES (154,'NG','Nigeria','Y');
INSERT INTO domains VALUES (155,'NI','Nicaragua','Y');
INSERT INTO domains VALUES (156,'NL','Netherlands','Y');
INSERT INTO domains VALUES (157,'NO','Norway','Y');
INSERT INTO domains VALUES (158,'NP','Nepal','Y');
INSERT INTO domains VALUES (159,'NR','Nauru','Y');
INSERT INTO domains VALUES (160,'NT','Neutral Zone','Y');
INSERT INTO domains VALUES (161,'NU','Niue','Y');
INSERT INTO domains VALUES (162,'NZ','New Zealand','Y');
INSERT INTO domains VALUES (163,'OM','Oman','Y');
INSERT INTO domains VALUES (164,'PA','Panama','Y');
INSERT INTO domains VALUES (165,'PE','Peru','Y');
INSERT INTO domains VALUES (166,'PF','Polynesia (French)','Y');
INSERT INTO domains VALUES (167,'PG','Papua New','Y');
INSERT INTO domains VALUES (168,'PH','Philippines','Y');
INSERT INTO domains VALUES (169,'PK','Pakistan','Y');
INSERT INTO domains VALUES (170,'PL','Poland','Y');
INSERT INTO domains VALUES (171,'PM','Saint Pierre and Miquelon','Y');
INSERT INTO domains VALUES (172,'PN','Pitcairn','Y');
INSERT INTO domains VALUES (173,'PT','Portugal','Y');
INSERT INTO domains VALUES (174,'PR','Puerto Rico (US)','Y');
INSERT INTO domains VALUES (175,'PW','Palau','Y');
INSERT INTO domains VALUES (176,'PY','Paraguay','Y');
INSERT INTO domains VALUES (177,'QA','Qatar','Y');
INSERT INTO domains VALUES (178,'RE','Reunion (French)','Y');
INSERT INTO domains VALUES (179,'RO','Romania','Y');
INSERT INTO domains VALUES (180,'RU','Russian Federation','Y');
INSERT INTO domains VALUES (181,'RW','Rwanda','Y');
INSERT INTO domains VALUES (182,'SA','Saudi Arabia','Y');
INSERT INTO domains VALUES (183,'SB','Solomon Islands','Y');
INSERT INTO domains VALUES (184,'SC','Seychelles','Y');
INSERT INTO domains VALUES (185,'SD','Sudan','Y');
INSERT INTO domains VALUES (186,'SE','Sweden','Y');
INSERT INTO domains VALUES (187,'SG','Singapore','Y');
INSERT INTO domains VALUES (188,'SH','Saint Helena','Y');
INSERT INTO domains VALUES (189,'SI','Slovenia','Y');
INSERT INTO domains VALUES (190,'SJ','Svalbard and Jan Mayen Islands','Y');
INSERT INTO domains VALUES (191,'SK','Slovak Republic','Y');
INSERT INTO domains VALUES (192,'SL','Sierra Leone','Y');
INSERT INTO domains VALUES (193,'SM','San Marino','Y');
INSERT INTO domains VALUES (194,'SN','Senegal','Y');
INSERT INTO domains VALUES (195,'SO','Somalia','Y');
INSERT INTO domains VALUES (196,'SR','Suriname','Y');
INSERT INTO domains VALUES (197,'ST','Saint Tome and Principe','Y');
INSERT INTO domains VALUES (198,'SU','Soviet Union','Y');
INSERT INTO domains VALUES (199,'SV','El Salvador','Y');
INSERT INTO domains VALUES (200,'SY','Syria','Y');
INSERT INTO domains VALUES (201,'SZ','Swaziland','Y');
INSERT INTO domains VALUES (202,'TC','Turks and Caicos Islands','Y');
INSERT INTO domains VALUES (203,'TD','Chad','Y');
INSERT INTO domains VALUES (204,'TF','French Southern Territory','Y');
INSERT INTO domains VALUES (205,'TG','Togo','Y');
INSERT INTO domains VALUES (206,'TH','Thailand','Y');
INSERT INTO domains VALUES (207,'TJ','Tadjikistan','Y');
INSERT INTO domains VALUES (208,'TK','Tokelau','Y');
INSERT INTO domains VALUES (209,'TM','Turkmenistan','Y');
INSERT INTO domains VALUES (210,'TN','Tunisia','Y');
INSERT INTO domains VALUES (211,'TO','Tonga','Y');
INSERT INTO domains VALUES (212,'TP','East Timor','Y');
INSERT INTO domains VALUES (213,'TR','Turkey','Y');
INSERT INTO domains VALUES (214,'TT','Trinidad and Tobago','Y');
INSERT INTO domains VALUES (215,'TV','Tuvalu','Y');
INSERT INTO domains VALUES (216,'TW','Taiwan','Y');
INSERT INTO domains VALUES (217,'TZ','Tanzania','Y');
INSERT INTO domains VALUES (218,'UA','Ukraine','Y');
INSERT INTO domains VALUES (219,'UG','Uganda','Y');
INSERT INTO domains VALUES (220,'UK','United Kingdom','Y');
INSERT INTO domains VALUES (221,'UM','US Minor Outlying Islands','Y');
INSERT INTO domains VALUES (222,'US','United States','Y');
INSERT INTO domains VALUES (223,'UY','Uruguay','Y');
INSERT INTO domains VALUES (224,'UZ','Uzbekistan','Y');
INSERT INTO domains VALUES (225,'VA','Vatican City State','Y');
INSERT INTO domains VALUES (226,'VC','Saint Vincent and Grenadines','Y');
INSERT INTO domains VALUES (227,'VE','Venezuela','Y');
INSERT INTO domains VALUES (228,'VG','Virgin Islands (British)','Y');
INSERT INTO domains VALUES (229,'VI','Virgin Islands (US)','Y');
INSERT INTO domains VALUES (230,'VN','Vietnam','Y');
INSERT INTO domains VALUES (231,'VU','Vanuatu','Y');
INSERT INTO domains VALUES (232,'WF','Wallis and Futuna Islands','Y');
INSERT INTO domains VALUES (233,'WS','Samoa','Y');
INSERT INTO domains VALUES (234,'YE','Yemen','Y');
INSERT INTO domains VALUES (235,'YU','Yugoslavia','Y');
INSERT INTO domains VALUES (236,'ZA','South Africa','Y');
INSERT INTO domains VALUES (237,'ZM','Zambia','Y');
INSERT INTO domains VALUES (238,'ZR','Zaire','Y');
INSERT INTO domains VALUES (239,'ZW','Zimbabwe','Y');
INSERT INTO domains VALUES (240,'ARPA','Old style Arpanet','N');
INSERT INTO domains VALUES (241,'COM','US Commercial','N');
INSERT INTO domains VALUES (242,'EDU','US Educational','N');
INSERT INTO domains VALUES (243,'GOV','US Government','N');
INSERT INTO domains VALUES (244,'INT','International','N');
INSERT INTO domains VALUES (245,'MIL','US Military','N');
INSERT INTO domains VALUES (246,'NATO','Nato field','N');
INSERT INTO domains VALUES (247,'NET','Network','N');
INSERT INTO domains VALUES (248,'ORG','Non-Profit','N');

Follow-Ups:
- Re: Domain/Country-Tabelle?
  - From: aka_(at)_bigfoot.de (andreas kempf aka 'amalesh')

References:
- Re: Domain/Country-Tabelle?
  - From: "Stefan Hundenborn" <st.h_(at)_gmx.de>

Prev by Date: Re: Domain/Country-Tabelle?
Next by Date: Re: Domain/Country-Tabelle?
Prev by thread: Re: Domain/Country-Tabelle?
Next by thread: Re: Domain/Country-Tabelle?
Index(es):
- Date
- Thread

Home | Main Index | Thread Index

php::bar PHP Wiki - Listenarchive