[TEP-COMMIT] [CVS catalog] Update Address Formats as per http://www.bitboost.com/ref/international-address-formats.html

Commit in catalog/catalog/install on MAIN

oscommerce.sql +38 -32 1.98 -> 1.99

Update Address Formats as per http://www.bitboost.com/ref/international-address-formats.html

----------

catalog /catalog /install

oscommerce.sql 1.98 -> 1.99

diff -u -r1.98 -r1.99
--- oscommerce.sql 2004/05/12 19:34:41 1.98
+++ oscommerce.sql 2004/05/23 12:18:00 1.99
@@ -598,6 +598,12 @@

INSERT INTO osc_address_format VALUES (3, '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country','$state / $country');
INSERT INTO osc_address_format VALUES (4, '$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country');
INSERT INTO osc_address_format VALUES (5, '$firstname $lastname$cr$streets$cr$postcode $city$cr$country','$city / $country');

+INSERT INTO osc_address_format VALUES (6, '$firstname $lastname$cr$streets$cr$city$cr$postcode$cr$country','$city / $country');
+INSERT INTO osc_address_format VALUES (7, '$firstname $lastname$cr$streets$cr$city$cr$state$cr$country','$city / $country');
+INSERT INTO osc_address_format VALUES (8, '$firstname $lastname$cr$streets$cr$city $postcode$cr$country','$city / $country');
+INSERT INTO osc_address_format VALUES (9, '$firstname $lastname$cr$streets$cr$postcode $city $state$cr$country','$city / $country');
+INSERT INTO osc_address_format VALUES (10, '$firstname $lastname$cr$streets$cr$city$cr$postcode $country','$city / $country');
+INSERT INTO osc_address_format VALUES (11, '$firstname $lastname$cr$streets$cr$city$cr$state$cr$postcode$cr$country','$city / $country');

INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Store Name', 'STORE_NAME', 'osCommerce', 'The name of my store', '1', '1', now());
INSERT INTO osc_configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) VALUES ('Store Owner', 'STORE_OWNER', 'Harald Ponce de Leon', 'The name of my store owner', '1', '2', now());

@@ -784,7 +790,7 @@

INSERT INTO osc_countries VALUES (10,'Argentina','AR','ARG','1');
INSERT INTO osc_countries VALUES (11,'Armenia','AM','ARM','1');
INSERT INTO osc_countries VALUES (12,'Aruba','AW','ABW','1');

-INSERT INTO osc_countries VALUES (13,'Australia','AU','AUS','1');

+INSERT INTO osc_countries VALUES (13,'Australia','AU','AUS','2');

INSERT INTO osc_countries VALUES (14,'Austria','AT','AUT','5');
INSERT INTO osc_countries VALUES (15,'Azerbaijan','AZ','AZE','1');
INSERT INTO osc_countries VALUES (16,'Bahamas','BS','BHS','1');

@@ -792,7 +798,7 @@

INSERT INTO osc_countries VALUES (18,'Bangladesh','BD','BGD','1');
INSERT INTO osc_countries VALUES (19,'Barbados','BB','BRB','1');
INSERT INTO osc_countries VALUES (20,'Belarus','BY','BLR','1');

-INSERT INTO osc_countries VALUES (21,'Belgium','BE','BEL','1');

+INSERT INTO osc_countries VALUES (21,'Belgium','BE','BEL','5');

INSERT INTO osc_countries VALUES (22,'Belize','BZ','BLZ','1');
INSERT INTO osc_countries VALUES (23,'Benin','BJ','BEN','1');
INSERT INTO osc_countries VALUES (24,'Bermuda','BM','BMU','1');

@@ -801,7 +807,7 @@

INSERT INTO osc_countries VALUES (27,'Bosnia and Herzegowina','BA','BIH','1');
INSERT INTO osc_countries VALUES (28,'Botswana','BW','BWA','1');
INSERT INTO osc_countries VALUES (29,'Bouvet Island','BV','BVT','1');

-INSERT INTO osc_countries VALUES (30,'Brazil','BR','BRA','1');

+INSERT INTO osc_countries VALUES (30,'Brazil','BR','BRA','6');

INSERT INTO osc_countries VALUES (31,'British Indian Ocean Territory','IO','IOT','1');
INSERT INTO osc_countries VALUES (32,'Brunei Darussalam','BN','BRN','1');
INSERT INTO osc_countries VALUES (33,'Bulgaria','BG','BGR','1');

@@ -809,13 +815,13 @@

INSERT INTO osc_countries VALUES (35,'Burundi','BI','BDI','1');
INSERT INTO osc_countries VALUES (36,'Cambodia','KH','KHM','1');
INSERT INTO osc_countries VALUES (37,'Cameroon','CM','CMR','1');

-INSERT INTO osc_countries VALUES (38,'Canada','CA','CAN','1');

+INSERT INTO osc_countries VALUES (38,'Canada','CA','CAN','2');

INSERT INTO osc_countries VALUES (39,'Cape Verde','CV','CPV','1');
INSERT INTO osc_countries VALUES (40,'Cayman Islands','KY','CYM','1');
INSERT INTO osc_countries VALUES (41,'Central African Republic','CF','CAF','1');
INSERT INTO osc_countries VALUES (42,'Chad','TD','TCD','1');
INSERT INTO osc_countries VALUES (43,'Chile','CL','CHL','1');

-INSERT INTO osc_countries VALUES (44,'China','CN','CHN','1');

+INSERT INTO osc_countries VALUES (44,'China','CN','CHN','5');

INSERT INTO osc_countries VALUES (45,'Christmas Island','CX','CXR','1');
INSERT INTO osc_countries VALUES (46,'Cocos (Keeling) Islands','CC','CCK','1');
INSERT INTO osc_countries VALUES (47,'Colombia','CO','COL','1');

@@ -828,7 +834,7 @@

INSERT INTO osc_countries VALUES (54,'Cuba','CU','CUB','1');
INSERT INTO osc_countries VALUES (55,'Cyprus','CY','CYP','1');
INSERT INTO osc_countries VALUES (56,'Czech Republic','CZ','CZE','1');

-INSERT INTO osc_countries VALUES (57,'Denmark','DK','DNK','1');

+INSERT INTO osc_countries VALUES (57,'Denmark','DK','DNK','5');

INSERT INTO osc_countries VALUES (58,'Djibouti','DJ','DJI','1');
INSERT INTO osc_countries VALUES (59,'Dominica','DM','DMA','1');
INSERT INTO osc_countries VALUES (60,'Dominican Republic','DO','DOM','1');

@@ -843,8 +849,8 @@

INSERT INTO osc_countries VALUES (69,'Falkland Islands (Malvinas)','FK','FLK','1');
INSERT INTO osc_countries VALUES (70,'Faroe Islands','FO','FRO','1');
INSERT INTO osc_countries VALUES (71,'Fiji','FJ','FJI','1');

-INSERT INTO osc_countries VALUES (72,'Finland','FI','FIN','1');
-INSERT INTO osc_countries VALUES (73,'France','FR','FRA','1');

+INSERT INTO osc_countries VALUES (72,'Finland','FI','FIN','5');
+INSERT INTO osc_countries VALUES (73,'France','FR','FRA','5');

INSERT INTO osc_countries VALUES (74,'France, Metropolitan','FX','FXX','1');
INSERT INTO osc_countries VALUES (75,'French Guiana','GF','GUF','1');
INSERT INTO osc_countries VALUES (76,'French Polynesia','PF','PYF','1');

@@ -856,7 +862,7 @@

INSERT INTO osc_countries VALUES (82,'Ghana','GH','GHA','1');
INSERT INTO osc_countries VALUES (83,'Gibraltar','GI','GIB','1');
INSERT INTO osc_countries VALUES (84,'Greece','GR','GRC','1');

-INSERT INTO osc_countries VALUES (85,'Greenland','GL','GRL','1');

+INSERT INTO osc_countries VALUES (85,'Greenland','GL','GRL','5');

INSERT INTO osc_countries VALUES (86,'Grenada','GD','GRD','1');
INSERT INTO osc_countries VALUES (87,'Guadeloupe','GP','GLP','1');
INSERT INTO osc_countries VALUES (88,'Guam','GU','GUM','1');

@@ -867,24 +873,24 @@

INSERT INTO osc_countries VALUES (93,'Haiti','HT','HTI','1');
INSERT INTO osc_countries VALUES (94,'Heard and Mc Donald Islands','HM','HMD','1');
INSERT INTO osc_countries VALUES (95,'Honduras','HN','HND','1');

-INSERT INTO osc_countries VALUES (96,'Hong Kong','HK','HKG','1');

+INSERT INTO osc_countries VALUES (96,'Hong Kong','HK','HKG','7');

INSERT INTO osc_countries VALUES (97,'Hungary','HU','HUN','1');

-INSERT INTO osc_countries VALUES (98,'Iceland','IS','ISL','1');
-INSERT INTO osc_countries VALUES (99,'India','IN','IND','1');
-INSERT INTO osc_countries VALUES (100,'Indonesia','ID','IDN','1');

+INSERT INTO osc_countries VALUES (98,'Iceland','IS','ISL','5');
+INSERT INTO osc_countries VALUES (99,'India','IN','IND','8');
+INSERT INTO osc_countries VALUES (100,'Indonesia','ID','IDN','8');

INSERT INTO osc_countries VALUES (101,'Iran (Islamic Republic of)','IR','IRN','1');
INSERT INTO osc_countries VALUES (102,'Iraq','IQ','IRQ','1');

-INSERT INTO osc_countries VALUES (103,'Ireland','IE','IRL','1');
-INSERT INTO osc_countries VALUES (104,'Israel','IL','ISR','1');
-INSERT INTO osc_countries VALUES (105,'Italy','IT','ITA','1');

+INSERT INTO osc_countries VALUES (103,'Ireland','IE','IRL','8');
+INSERT INTO osc_countries VALUES (104,'Israel','IL','ISR','5');
+INSERT INTO osc_countries VALUES (105,'Italy','IT','ITA','9');

INSERT INTO osc_countries VALUES (106,'Jamaica','JM','JAM','1');

-INSERT INTO osc_countries VALUES (107,'Japan','JP','JPN','1');

+INSERT INTO osc_countries VALUES (107,'Japan','JP','JPN','2');

INSERT INTO osc_countries VALUES (108,'Jordan','JO','JOR','1');
INSERT INTO osc_countries VALUES (109,'Kazakhstan','KZ','KAZ','1');
INSERT INTO osc_countries VALUES (110,'Kenya','KE','KEN','1');
INSERT INTO osc_countries VALUES (111,'Kiribati','KI','KIR','1');

-INSERT INTO osc_countries VALUES (112,'Korea, Democratic People\'s Republic of','KP','PRK','1');
-INSERT INTO osc_countries VALUES (113,'Korea, Republic of','KR','KOR','1');

+INSERT INTO osc_countries VALUES (112,'Korea, Democratic People\'s Republic of','KP','PRK','8');
+INSERT INTO osc_countries VALUES (113,'Korea, Republic of','KR','KOR','8');

INSERT INTO osc_countries VALUES (114,'Kuwait','KW','KWT','1');
INSERT INTO osc_countries VALUES (115,'Kyrgyzstan','KG','KGZ','1');
INSERT INTO osc_countries VALUES (116,'Lao People\'s Democratic Republic','LA','LAO','1');

@@ -895,7 +901,7 @@

INSERT INTO osc_countries VALUES (121,'Libyan Arab Jamahiriya','LY','LBY','1');
INSERT INTO osc_countries VALUES (122,'Liechtenstein','LI','LIE','1');
INSERT INTO osc_countries VALUES (123,'Lithuania','LT','LTU','1');

-INSERT INTO osc_countries VALUES (124,'Luxembourg','LU','LUX','1');

+INSERT INTO osc_countries VALUES (124,'Luxembourg','LU','LUX','5');

INSERT INTO osc_countries VALUES (125,'Macau','MO','MAC','1');
INSERT INTO osc_countries VALUES (126,'Macedonia, The Former Yugoslav Republic of','MK','MKD','1');
INSERT INTO osc_countries VALUES (127,'Madagascar','MG','MDG','1');

@@ -909,7 +915,7 @@

INSERT INTO osc_countries VALUES (135,'Mauritania','MR','MRT','1');
INSERT INTO osc_countries VALUES (136,'Mauritius','MU','MUS','1');
INSERT INTO osc_countries VALUES (137,'Mayotte','YT','MYT','1');

-INSERT INTO osc_countries VALUES (138,'Mexico','MX','MEX','1');

+INSERT INTO osc_countries VALUES (138,'Mexico','MX','MEX','9');

INSERT INTO osc_countries VALUES (139,'Micronesia, Federated States of','FM','FSM','1');
INSERT INTO osc_countries VALUES (140,'Moldova, Republic of','MD','MDA','1');
INSERT INTO osc_countries VALUES (141,'Monaco','MC','MCO','1');

@@ -921,17 +927,17 @@

INSERT INTO osc_countries VALUES (147,'Namibia','NA','NAM','1');
INSERT INTO osc_countries VALUES (148,'Nauru','NR','NRU','1');
INSERT INTO osc_countries VALUES (149,'Nepal','NP','NPL','1');

-INSERT INTO osc_countries VALUES (150,'Netherlands','NL','NLD','1');

+INSERT INTO osc_countries VALUES (150,'Netherlands','NL','NLD','5');

INSERT INTO osc_countries VALUES (151,'Netherlands Antilles','AN','ANT','1');
INSERT INTO osc_countries VALUES (152,'New Caledonia','NC','NCL','1');

-INSERT INTO osc_countries VALUES (153,'New Zealand','NZ','NZL','1');

+INSERT INTO osc_countries VALUES (153,'New Zealand','NZ','NZL','8');

INSERT INTO osc_countries VALUES (154,'Nicaragua','NI','NIC','1');
INSERT INTO osc_countries VALUES (155,'Niger','NE','NER','1');
INSERT INTO osc_countries VALUES (156,'Nigeria','NG','NGA','1');
INSERT INTO osc_countries VALUES (157,'Niue','NU','NIU','1');
INSERT INTO osc_countries VALUES (158,'Norfolk Island','NF','NFK','1');
INSERT INTO osc_countries VALUES (159,'Northern Mariana Islands','MP','MNP','1');

-INSERT INTO osc_countries VALUES (160,'Norway','NO','NOR','1');

+INSERT INTO osc_countries VALUES (160,'Norway','NO','NOR','5');

INSERT INTO osc_countries VALUES (161,'Oman','OM','OMN','1');
INSERT INTO osc_countries VALUES (162,'Pakistan','PK','PAK','1');
INSERT INTO osc_countries VALUES (163,'Palau','PW','PLW','1');

@@ -941,13 +947,13 @@

INSERT INTO osc_countries VALUES (167,'Peru','PE','PER','1');
INSERT INTO osc_countries VALUES (168,'Philippines','PH','PHL','1');
INSERT INTO osc_countries VALUES (169,'Pitcairn','PN','PCN','1');

-INSERT INTO osc_countries VALUES (170,'Poland','PL','POL','1');
-INSERT INTO osc_countries VALUES (171,'Portugal','PT','PRT','1');

+INSERT INTO osc_countries VALUES (170,'Poland','PL','POL','5');
+INSERT INTO osc_countries VALUES (171,'Portugal','PT','PRT','5');

INSERT INTO osc_countries VALUES (172,'Puerto Rico','PR','PRI','1');
INSERT INTO osc_countries VALUES (173,'Qatar','QA','QAT','1');
INSERT INTO osc_countries VALUES (174,'Reunion','RE','REU','1');
INSERT INTO osc_countries VALUES (175,'Romania','RO','ROM','1');

-INSERT INTO osc_countries VALUES (176,'Russian Federation','RU','RUS','1');

+INSERT INTO osc_countries VALUES (176,'Russian Federation','RU','RUS','5');

INSERT INTO osc_countries VALUES (177,'Rwanda','RW','RWA','1');
INSERT INTO osc_countries VALUES (178,'Saint Kitts and Nevis','KN','KNA','1');
INSERT INTO osc_countries VALUES (179,'Saint Lucia','LC','LCA','1');

@@ -959,12 +965,12 @@

INSERT INTO osc_countries VALUES (185,'Senegal','SN','SEN','1');
INSERT INTO osc_countries VALUES (186,'Seychelles','SC','SYC','1');
INSERT INTO osc_countries VALUES (187,'Sierra Leone','SL','SLE','1');

-INSERT INTO osc_countries VALUES (188,'Singapore','SG','SGP', '4');

+INSERT INTO osc_countries VALUES (188,'Singapore','SG','SGP', '8');

INSERT INTO osc_countries VALUES (189,'Slovakia (Slovak Republic)','SK','SVK','1');
INSERT INTO osc_countries VALUES (190,'Slovenia','SI','SVN','1');
INSERT INTO osc_countries VALUES (191,'Solomon Islands','SB','SLB','1');
INSERT INTO osc_countries VALUES (192,'Somalia','SO','SOM','1');

-INSERT INTO osc_countries VALUES (193,'South Africa','ZA','ZAF','1');

+INSERT INTO osc_countries VALUES (193,'South Africa','ZA','ZAF','10');

INSERT INTO osc_countries VALUES (194,'South Georgia and the South Sandwich Islands','GS','SGS','1');
INSERT INTO osc_countries VALUES (195,'Spain','ES','ESP','3');
INSERT INTO osc_countries VALUES (196,'Sri Lanka','LK','LKA','1');

@@ -974,10 +980,10 @@

INSERT INTO osc_countries VALUES (200,'Suriname','SR','SUR','1');
INSERT INTO osc_countries VALUES (201,'Svalbard and Jan Mayen Islands','SJ','SJM','1');
INSERT INTO osc_countries VALUES (202,'Swaziland','SZ','SWZ','1');

-INSERT INTO osc_countries VALUES (203,'Sweden','SE','SWE','1');

+INSERT INTO osc_countries VALUES (203,'Sweden','SE','SWE','5');

INSERT INTO osc_countries VALUES (204,'Switzerland','CH','CHE','5');
INSERT INTO osc_countries VALUES (205,'Syrian Arab Republic','SY','SYR','1');

-INSERT INTO osc_countries VALUES (206,'Taiwan','TW','TWN','1');

+INSERT INTO osc_countries VALUES (206,'Taiwan','TW','TWN','8');

INSERT INTO osc_countries VALUES (207,'Tajikistan','TJ','TJK','1');
INSERT INTO osc_countries VALUES (208,'Tanzania, United Republic of','TZ','TZA','1');
INSERT INTO osc_countries VALUES (209,'Thailand','TH','THA','1');

@@ -993,7 +999,7 @@

INSERT INTO osc_countries VALUES (219,'Uganda','UG','UGA','1');
INSERT INTO osc_countries VALUES (220,'Ukraine','UA','UKR','1');
INSERT INTO osc_countries VALUES (221,'United Arab Emirates','AE','ARE','1');

-INSERT INTO osc_countries VALUES (222,'United Kingdom','GB','GBR','1');

+INSERT INTO osc_countries VALUES (222,'United Kingdom','GB','GBR','11');

INSERT INTO osc_countries VALUES (223,'United States','US','USA', '2');
INSERT INTO osc_countries VALUES (224,'United States Minor Outlying Islands','UM','UMI','1');
INSERT INTO osc_countries VALUES (225,'Uruguay','UY','URY','1');

CVSspam 0.2.8

-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g.
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click