05. januar 2005 - 17:49
#3
--
-- Struktur-dump for tabellen `country`
--
CREATE TABLE IF NOT EXISTS `country` (
`c_id` int(2) NOT NULL default '0',
`c_name` varchar(255) NOT NULL default '',
`c_short` varchar(10) NOT NULL default '',
PRIMARY KEY (`c_id`)
) TYPE=MyISAM;
--
-- Data dump for tabellen `country`
--
INSERT DELAYED INTO `country` (`c_id`, `c_name`, `c_short`) VALUES (0, '', ''),
(1, 'Argentina', 'AR'),
(2, 'Australia', 'AUS'),
(3, 'Austria', 'A'),
(4, 'Barbados', ''),
(5, 'Belgium', 'B'),
(6, 'Botswana', ''),
(7, 'Brazil', ''),
(8, 'Bulgaria', 'BL'),
(9, 'Canada', 'CAN'),
(10, 'Chile', ''),
(11, 'China, Peoples Rep. of', 'CN'),
(12, 'Colombia', 'COL'),
(13, 'Cook Islands (* NZ)', ''),
(14, 'Costa Rica', 'CR'),
(15, 'Croatia', 'HR'),
(16, 'Cyprus', 'CY'),
(17, 'Czech Republic', 'CZ'),
(18, 'Czechoslovakia, Former', 'CS'),
(19, 'Denmark', 'DK'),
(20, 'Dominican Republic', ''),
(21, 'East Germany, Former', 'DDR'),
(22, 'El Salvador', ''),
(23, 'Equador', ''),
(24, 'Eritrea', ''),
(25, 'Estonia', 'EST'),
(26, 'Ethiopia', ''),
(27, 'Faroe Islands (* DK)', 'FR'),
(28, 'Finland', 'FIN'),
(29, 'France', 'F'),
(30, 'French Polynesia (* F)', ''),
(31, 'Gambia', ''),
(32, 'Germany', 'D'),
(33, 'Great Britain', 'GB'),
(34, 'Greece', 'GR'),
(35, 'Grenada', ''),
(36, 'Guatemala', ''),
(37, 'Guernsey (* GB)', 'GBG'),
(38, 'Hungary', 'H'),
(39, 'Iceland', 'IS'),
(40, 'India', ''),
(41, 'Indonesia', ''),
(42, 'Ireland', 'EIR'),
(43, 'Israel', 'IL'),
(44, 'Italy', 'I'),
(45, 'Jamaica', ''),
(46, 'Japan', 'JP'),
(47, 'Jersey (* GB)', 'GBJ'),
(48, 'Kenya', ''),
(49, 'Latvia', 'LV'),
(50, 'Lesotho', ''),
(51, 'Lithuania', 'LT'),
(52, 'Luxemburg', 'L'),
(53, 'Madagascar', ''),
(54, 'Malaysia', 'MY'),
(55, 'Malta', 'M'),
(56, 'Marocko', ''),
(57, 'Mexico', 'MX'),
(58, 'Namibia', ''),
(59, 'Netherlands, The', 'NL'),
(60, 'New Zealand', 'NZ'),
(61, 'Nigeria', ''),
(62, 'Norway', 'N'),
(63, 'Palestinian West Bank (* IL)', ''),
(64, 'Paraguay', ''),
(65, 'Peru', ''),
(66, 'Poland', 'PL'),
(67, 'Portugal', 'P'),
(68, 'Puerto Rico (* USA)', ''),
(69, 'Russia', 'RUS'),
(70, 'Saint Kitts and Nevis', ''),
(71, 'Singapore', ''),
(72, 'Slovakia', 'SK'),
(73, 'Slovenia', 'SI'),
(74, 'South Africa', 'ZA'),
(75, 'Soviet Union, Former', 'USSR'),
(76, 'Spain', 'E'),
(77, 'Sri Lanka', ''),
(78, 'Sweden', 'S'),
(79, 'Switzerland', 'CH'),
(80, 'Taiwan', ''),
(81, 'Tanzania', ''),
(82, 'Thailand', ''),
(83, 'Trinidad and Tobago', ''),
(84, 'Tunisia', 'TN'),
(85, 'Turkey', 'TR'),
(86, 'Uganda', ''),
(87, 'USA', 'USA'),
(88, 'Venzuela', ''),
(89, 'Vietnam', ''),
(90, 'West Samoa', ''),
(91, 'Yugoslavia, Former', 'YU'),
(92, 'Zimbabwe', '');
05. januar 2005 - 18:07
#7
--
-- Struktur-dump for tabellen `country`
--
CREATE TABLE `country` (
`c_short` varchar(10) NOT NULL default '',
`c_name` varchar(255) NOT NULL default ''
) TYPE=MyISAM;
--
-- Data dump for tabellen `country`
--
INSERT DELAYED INTO `country` (`c_short`, `c_name`) VALUES ('AF', 'Afghanistan'),
('AL', 'Albania'),
('AG', 'Algeria'),
('AQ', 'American Samoa'),
('AN', 'Andorra'),
('AO', 'Angola'),
('AV', 'Anguilla'),
('AY', 'Antarctica'),
('AC', 'Antigua And Barbuda'),
('AR', 'Argentina'),
('AA', 'Aruba'),
('AT', 'Ashmore And Cartier Isl'),
('AS', 'Australia'),
('AU', 'Austria'),
('AJ', 'Azerbaijan Republic'),
('BA', 'Bahrain'),
('FQ', 'Baker Island'),
('BG', 'Bangladesh'),
('BB', 'Barbados'),
('BS', 'Bassas Da India'),
('BE', 'Belgium'),
('BH', 'Belize'),
('BN', 'Benin'),
('BD', 'Bermuda'),
('BT', 'Bhutan'),
('BL', 'Bolivia'),
('BC', 'Botswana'),
('BV', 'Bouvet Island'),
('IO', 'Br Indian Ocean Terr'),
('BR', 'Brazil'),
('VI', 'British Virgin Is.'),
('BX', 'Brunei'),
('BU', 'Bulgaria'),
('UV', 'Burkina Fasco'),
('BM', 'Burma'),
('BY', 'Burundi'),
('CB', 'Cambodia'),
('CM', 'Cameroon'),
('CA', 'Canada'),
('CV', 'Cape Verde'),
('CJ', 'Cayman Islands'),
('CT', 'Central African Rep.'),
('CD', 'Chad'),
('CI', 'Chile'),
('CH', 'China'),
('IP', 'Clipperton Island'),
('CK', 'Cocos (Keeling) Islands'),
('CO', 'Colombia'),
('CN', 'Comoros'),
('CF', 'Congo'),
('CW', 'Cook Islands'),
('CR', 'Coral Sea Islands'),
('CS', 'Costa Rica'),
('CU', 'Cuba'),
('CY', 'Cyprus'),
('CZ', 'Czechoslovakia'),
('DA', 'Denmark'),
('DJ', 'Djibouti'),
('DO', 'Dominica'),
('DR', 'Dominican Republic'),
('EC', 'Ecuador'),
('EG', 'Egypt'),
('ES', 'El Salvador'),
('EK', 'Equatorial Guinea'),
('ET', 'Ethiopia'),
('EU', 'Europa Island'),
('FA', 'Falkland(Malvinas) Is'),
('FO', 'Faroe Islands'),
('FM', 'Fed States Micronesia'),
('FJ', 'Fiji'),
('FI', 'Finland'),
('FS', 'Fr So & Antarctic Lnds'),
('FR', 'France'),
('FG', 'French Guiana'),
('FP', 'French Polynesia'),
('GB', 'Gabon'),
('GA', 'Gambia The'),
('GZ', 'Gaza Strip'),
('GE', 'Germany, Federal Rep Of'),
('GC', 'Germany,Democratic Rep'),
('GH', 'Ghana'),
('GI', 'Gibraltar'),
('GO', 'Glorioso Islands'),
('GR', 'Greece'),
('GL', 'Greenland'),
('GJ', 'Grenada'),
('GP', 'Guadeloupe'),
('GQ', 'Guam'),
('GT', 'Guatemala'),
('GK', 'Guernsey'),
('GV', 'Guinea'),
('PU', 'Guinea-Bissau'),
('GY', 'Guyana'),
('HA', 'Haiti'),
('HM', 'Heard Is&Mcdonald Isls'),
('HO', 'Honduras'),
('HK', 'Hong Kong'),
('HQ', 'Howland Island'),
('HU', 'Hungary'),
('IC', 'Iceland'),
('IN', 'India'),
('ID', 'Indonesia'),
('IR', 'Iran'),
('IZ', 'Iraq'),
('IY', 'Iraq-Saudi Arabia N-Zon'),
('EI', 'Ireland'),
('IS', 'Israel'),
('IT', 'Italy'),
('IV', 'Ivory Coast'),
('JM', 'Jamaica'),
('JN', 'Jan Mayen'),
('JA', 'Japan'),
('DQ', 'Jarvis Island'),
('JE', 'Jersey'),
('JQ', 'Johnston Atoll'),
('JO', 'Jordan'),
('JU', 'Juan De Novaisland'),
('KE', 'Kenya'),
('KQ', 'Kingman Reef'),
('KR', 'Kiribati'),
('KS', 'Korea, Republic Of'),
('KN', 'Korea,Dem Peoples Rep'),
('KU', 'Kuwait'),
('LA', 'Laos'),
('LE', 'Lebanon'),
('LT', 'Lesotho'),
('LI', 'Liberia'),
('LY', 'Libya'),
('LS', 'Liechtenstein'),
('LU', 'Luxembourg'),
('MC', 'Macau'),
('MA', 'Madagascar'),
('MI', 'Malawi'),
('MY', 'Malaysia'),
('MV', 'Maldives'),
('ML', 'Mali'),
('MT', 'Malta'),
('IM', 'Man, Isle Of'),
('RM', 'Marshall Island'),
('MB', 'Martinique'),
('MR', 'Mauritania'),
('MP', 'Mauritius'),
('MF', 'Mayotte'),
('MX', 'Mexico'),
('MQ', 'Midway Islands'),
('MN', 'Monaco'),
('MG', 'Mongolia'),
('MH', 'Montserrat'),
('MO', 'Morocco'),
('MZ', 'Mozambique'),
('WA', 'Namibia'),
('NR', 'Nauru'),
('BQ', 'Navassa Island'),
('NP', 'Nepal'),
('NL', 'Netherlands'),
('NA', 'Netherlands Antilles'),
('NC', 'New Caledonia'),
('NZ', 'New Zealand'),
('NU', 'Nicaragua'),
('NG', 'Niger'),
('NI', 'Nigeria'),
('NE', 'Niue'),
('NF', 'Norfolk Island'),
('CQ', 'Northern Mariana Is'),
('NO', 'Norway'),
('MU', 'Oman'),
('PK', 'Pakistan'),
('LQ', 'Palmyra Atoll'),
('PM', 'Panama'),
('PP', 'Papua New Guinea'),
('PF', 'Paracel Islands'),
('PA', 'Paraguay'),
('PE', 'Peru'),
('RP', 'Philippines'),
('PC', 'Pitcairn Islands'),
('PL', 'Poland'),
('PO', 'Portugal'),
('PT', 'Portuguese Timor'),
('RQ', 'Puerto Rico'),
('QA', 'Qatar'),
('RE', 'Reunion'),
('RO', 'Romania'),
('RW', 'Rwanda'),
('SM', 'San Marino'),
('TP', 'Sao Tome And Principe'),
('SA', 'Saudi Arabia'),
('SG', 'Senegal'),
('SE', 'Seychelles'),
('SL', 'Sierra Leone'),
('SN', 'Singapore'),
('BP', 'Solomon Islands'),
('SO', 'Somalia'),
('SF', 'South Africa'),
('SP', 'Spain'),
('PG', 'Spratly Islands'),
('CE', 'Sri Lanka'),
('ST', 'St Lucia'),
('VC', 'St Vincent Grenadines'),
('SC', 'St. Christopher And Nev'),
('SH', 'St. Helena'),
('SB', 'St. Pierre And Miquelon'),
('SU', 'Sudan'),
('NS', 'Suriname'),
('SV', 'Svalbard'),
('WZ', 'Swaziland'),
('SW', 'Sweden'),
('SZ', 'Switzerland'),
('SY', 'Syria'),
('TW', 'Taiwan'),
('TZ', 'Tanzania, United Rep Of'),
('TH', 'Thailand'),
('BF', 'The Bahamas'),
('TO', 'Togo'),
('TL', 'Tokelau'),
('TN', 'Tonga'),
('TD', 'Trinidad And Tobago'),
('TE', 'Tromelin Island'),
('PS', 'Trust Terr Of Pacific'),
('TS', 'Tunisia'),
('TU', 'Turkey'),
('TK', 'Turks And Caicos Isl'),
('TV', 'Tuvalu'),
('UG', 'Uganda'),
('UP', 'Ukraine'),
('UR', 'Union Of Soviet Soc Rep'),
('TC', 'United Arab Emirates'),
('UK', 'United Kingdom'),
('US', 'United States'),
('UY', 'Uruguay'),
('NH', 'Vanuatu'),
('VT', 'Vatican City'),
('VE', 'Venezuela'),
('VM', 'Vietnam'),
('VQ', 'Virgin Islands'),
('WQ', 'Wake Island'),
('WF', 'Wallis And Futuna'),
('WE', 'West Bank'),
('WI', 'Western Sahara'),
('WS', 'Western Samoa'),
('YE', 'Yemen (Sanaa)'),
('YS', 'Yemen People''S Dem Of'),
('YO', 'Yugoslavia'),
('CG', 'Zaire'),
('ZA', 'Zambia'),
('ZI', 'Zimbabwe');
Ny bruger
Nybegynder
Opret
Preview
