Need Countries 1-39

[violetcrown]

To limit choices for shipping, I began systematically deleting entries from the countries table STUPID ME I did not back up first. Luckily, I realized the error of my ways, and I only need to restore entries 1-39, including ID, name, and the ISO2 & ISO3 codes. (My #40 is Cayman Islands)

 

I used an auto install, so I don't have the originals anywhere. Since the ID is an auto generated ID, I don't know where else to find this info - I'm hoping somehone will post or email me with the first 39 records.

 

Thanks in advance,

Lea

[thetraveller]

To limit choices for shipping, I began systematically deleting entries from the countries table  STUPID ME I did not back up first.  Luckily, I realized the error of my ways, and I only need to restore entries 1-39, including ID, name, and the ISO2 & ISO3 codes.  (My #40 is Cayman Islands)

 

I used an auto install, so I don't have the originals anywhere.  Since the ID is an auto generated ID, I don't know where else to find this info - I'm hoping somehone will post or email me with the first 39 records.

 

Thanks in advance,

Lea

<{POST_SNAPBACK}>

 

 

Download the full package from the front page of the site and then open the .sql file and grab the data from there and you will have a full backup copy as an added bonus.

 

John

[cullbies]

To limit choices for shipping, I began systematically deleting entries from the countries table  STUPID ME I did not back up first.  Luckily, I realized the error of my ways, and I only need to restore entries 1-39, including ID, name, and the ISO2 & ISO3 codes.  (My #40 is Cayman Islands)

 

I used an auto install, so I don't have the originals anywhere.  Since the ID is an auto generated ID, I don't know where else to find this info - I'm hoping somehone will post or email me with the first 39 records.

 

Thanks in advance,

Lea

<{POST_SNAPBACK}>

 

 

INSERT INTO countries VALUES (1,'Afghanistan','AF','AFG','1');

INSERT INTO countries VALUES (2,'Albania','AL','ALB','1');

INSERT INTO countries VALUES (3,'Algeria','DZ','DZA','1');

INSERT INTO countries VALUES (4,'American Samoa','AS','ASM','1');

INSERT INTO countries VALUES (5,'Andorra','AD','AND','1');

INSERT INTO countries VALUES (6,'Angola','AO','AGO','1');

INSERT INTO countries VALUES (7,'Anguilla','AI','AIA','1');

INSERT INTO countries VALUES (8,'Antarctica','AQ','ATA','1');

INSERT INTO countries VALUES (9,'Antigua and Barbuda','AG','ATG','1');

INSERT INTO countries VALUES (10,'Argentina','AR','ARG','1');

INSERT INTO countries VALUES (11,'Armenia','AM','ARM','1');

INSERT INTO countries VALUES (12,'Aruba','AW','ABW','1');

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

INSERT INTO countries VALUES (14,'Austria','AT','AUT','5');

INSERT INTO countries VALUES (15,'Azerbaijan','AZ','AZE','1');

INSERT INTO countries VALUES (16,'Bahamas','BS','BHS','1');

INSERT INTO countries VALUES (17,'Bahrain','BH','BHR','1');

INSERT INTO countries VALUES (18,'Bangladesh','BD','BGD','1');

INSERT INTO countries VALUES (19,'Barbados','BB','BRB','1');

INSERT INTO countries VALUES (20,'Belarus','BY','BLR','1');

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

INSERT INTO countries VALUES (22,'Belize','BZ','BLZ','1');

INSERT INTO countries VALUES (23,'Benin','BJ','BEN','1');

INSERT INTO countries VALUES (24,'Bermuda','BM','BMU','1');

INSERT INTO countries VALUES (25,'Bhutan','BT','BTN','1');

INSERT INTO countries VALUES (26,'Bolivia','BO','BOL','1');

INSERT INTO countries VALUES (27,'Bosnia and Herzegowina','BA','BIH','1');

INSERT INTO countries VALUES (28,'Botswana','BW','BWA','1');

INSERT INTO countries VALUES (29,'Bouvet Island','BV','BVT','1');

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

INSERT INTO countries VALUES (31,'British Indian Ocean Territory','IO','IOT','1');

INSERT INTO countries VALUES (32,'Brunei Darussalam','BN','BRN','1');

INSERT INTO countries VALUES (33,'Bulgaria','BG','BGR','1');

INSERT INTO countries VALUES (34,'Burkina Faso','BF','BFA','1');

INSERT INTO countries VALUES (35,'Burundi','BI','BDI','1');

INSERT INTO countries VALUES (36,'Cambodia','KH','KHM','1');

INSERT INTO countries VALUES (37,'Cameroon','CM','CMR','1');

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

INSERT INTO countries VALUES (39,'Cape Verde','CV','CPV','1');

INSERT INTO countries VALUES (40,'Cayman Islands','KY','CYM','1');