3 reg_country_id int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
4 alpha2 varchar(2) not null,
5 reg_collection_id int(11) UNSIGNED not null default '0',
6 PRIMARY KEY(reg_country_id)
10 insert into reg_country (alpha2, reg_collection_id) values ("00", 1);
12 insert into reg_country (alpha2, reg_collection_id) values ("01", 2);
14 insert into reg_country (alpha2, reg_collection_id) values ("02", 3);
16 insert into reg_country (alpha2, reg_collection_id) values ("03", 4);
19 insert into reg_country (alpha2, reg_collection_id) values ("BR", 5);
20 insert into reg_country (alpha2, reg_collection_id) values ("BZ", 5);
23 insert into reg_country (alpha2, reg_collection_id) values ("PH", 6);
26 insert into reg_country (alpha2, reg_collection_id) values ("CO", 7);
27 insert into reg_country (alpha2, reg_collection_id) values ("DO", 7);
28 insert into reg_country (alpha2, reg_collection_id) values ("GT", 7);
29 insert into reg_country (alpha2, reg_collection_id) values ("MX", 7);
30 insert into reg_country (alpha2, reg_collection_id) values ("PA", 7);
31 insert into reg_country (alpha2, reg_collection_id) values ("PR", 7);
32 insert into reg_country (alpha2, reg_collection_id) values ("US", 7);
35 insert into reg_country (alpha2, reg_collection_id) values ("AU", 8);
36 insert into reg_country (alpha2, reg_collection_id) values ("HK", 8);
37 insert into reg_country (alpha2, reg_collection_id) values ("MO", 8);
40 insert into reg_country (alpha2, reg_collection_id) values ("CA", 9);
43 insert into reg_country (alpha2, reg_collection_id) values ("NZ", 10);
46 insert into reg_country (alpha2, reg_collection_id) values ("UZ", 11);
49 insert into reg_country (alpha2, reg_collection_id) values ("CY", 12);
50 insert into reg_country (alpha2, reg_collection_id) values ("DE", 12);
51 insert into reg_country (alpha2, reg_collection_id) values ("DK", 12);
52 insert into reg_country (alpha2, reg_collection_id) values ("EE", 12);
53 insert into reg_country (alpha2, reg_collection_id) values ("ES", 12);
54 insert into reg_country (alpha2, reg_collection_id) values ("FI", 12);
55 insert into reg_country (alpha2, reg_collection_id) values ("GB", 12);
56 insert into reg_country (alpha2, reg_collection_id) values ("IE", 12);
57 insert into reg_country (alpha2, reg_collection_id) values ("IS", 12);
58 insert into reg_country (alpha2, reg_collection_id) values ("IT", 12);
59 insert into reg_country (alpha2, reg_collection_id) values ("LT", 12);
60 insert into reg_country (alpha2, reg_collection_id) values ("LU", 12);
61 insert into reg_country (alpha2, reg_collection_id) values ("LN", 12);
62 insert into reg_country (alpha2, reg_collection_id) values ("NO", 12);
63 insert into reg_country (alpha2, reg_collection_id) values ("PL", 12);
64 insert into reg_country (alpha2, reg_collection_id) values ("PT", 12);
65 insert into reg_country (alpha2, reg_collection_id) values ("SE", 12);
66 insert into reg_country (alpha2, reg_collection_id) values ("SI", 12);
67 insert into reg_country (alpha2, reg_collection_id) values ("UK", 12);
68 insert into reg_country (alpha2, reg_collection_id) values ("ZA", 12);
71 insert into reg_country (alpha2, reg_collection_id) values ("CH", 13);
72 insert into reg_country (alpha2, reg_collection_id) values ("HU", 13);
73 insert into reg_country (alpha2, reg_collection_id) values ("LI", 13);
74 insert into reg_country (alpha2, reg_collection_id) values ("AT", 13);
77 insert into reg_country (alpha2, reg_collection_id) values ("CZ", 14);
78 insert into reg_country (alpha2, reg_collection_id) values ("F2", 14); /* ? */
79 insert into reg_country (alpha2, reg_collection_id) values ("HR", 14);
80 insert into reg_country (alpha2, reg_collection_id) values ("SK", 14);
81 insert into reg_country (alpha2, reg_collection_id) values ("TN", 14);
82 insert into reg_country (alpha2, reg_collection_id) values ("TR", 14);
83 insert into reg_country (alpha2, reg_collection_id) values ("AM", 14);
84 insert into reg_country (alpha2, reg_collection_id) values ("AZ", 14);
85 insert into reg_country (alpha2, reg_collection_id) values ("BE", 14);
86 insert into reg_country (alpha2, reg_collection_id) values ("GE", 14);
87 insert into reg_country (alpha2, reg_collection_id) values ("MC", 14);
88 insert into reg_country (alpha2, reg_collection_id) values ("TT", 14);
91 insert into reg_country (alpha2, reg_collection_id) values ("BG", 15);
94 insert into reg_country (alpha2, reg_collection_id) values ("JP", 16);
96 insert into reg_country (alpha2, reg_collection_id) values ("J1", 17);
98 insert into reg_country (alpha2, reg_collection_id) values ("J2", 18);
101 insert into reg_country (alpha2, reg_collection_id) values ("BN", 19);
102 insert into reg_country (alpha2, reg_collection_id) values ("CH", 19);
103 insert into reg_country (alpha2, reg_collection_id) values ("IR", 19);
104 insert into reg_country (alpha2, reg_collection_id) values ("CL", 19);
107 insert into reg_country (alpha2, reg_collection_id) values ("BO", 20);
110 insert into reg_country (alpha2, reg_collection_id) values ("KP", 21);
111 insert into reg_country (alpha2, reg_collection_id) values ("KR", 21);
112 insert into reg_country (alpha2, reg_collection_id) values ("TH", 21);
113 insert into reg_country (alpha2, reg_collection_id) values ("UY", 21);
116 insert into reg_country (alpha2, reg_collection_id) values ("VE", 22);
119 insert into reg_country (alpha2, reg_collection_id) values ("AR", 23);
120 insert into reg_country (alpha2, reg_collection_id) values ("TW", 23);
123 insert into reg_country (alpha2, reg_collection_id) values ("SG", 24);