1 ALTER TABLE users ADD COLUMN firstname varchar(60);
2 ALTER TABLE users ADD COLUMN lastname varchar(60);
3 ALTER TABLE users ADD COLUMN address2 text;
4 ALTER TABLE users ADD COLUMN ccode char(2);
5 ALTER TABLE users ALTER COLUMN ccode SET DEFAULT 'US';
6 UPDATE USERS SET ccode='US',firstname=realname WHERE firstname is null;
8 CREATE TABLE country_code (
9 country_name varchar(80),
10 ccode char(2) primary key
13 INSERT INTO country_code VALUES ('Afghanistan','AF');
14 INSERT INTO country_code VALUES ('Åland Islands','AX');
15 INSERT INTO country_code VALUES ('Albania','AL');
16 INSERT INTO country_code VALUES ('Algeria','DZ');
17 INSERT INTO country_code VALUES ('American Samoa','AS');
18 INSERT INTO country_code VALUES ('Andorra','AD');
19 INSERT INTO country_code VALUES ('Angola','AO');
20 INSERT INTO country_code VALUES ('Anguilla','AI');
21 INSERT INTO country_code VALUES ('Antarctica','AQ');
22 INSERT INTO country_code VALUES ('Antigua and Barbuda','AG');
23 INSERT INTO country_code VALUES ('Argentina','AR');
24 INSERT INTO country_code VALUES ('Armenia','AM');
25 INSERT INTO country_code VALUES ('Aruba','AW');
26 INSERT INTO country_code VALUES ('Australia','AU');
27 INSERT INTO country_code VALUES ('Austria','AT');
28 INSERT INTO country_code VALUES ('Azerbaijan','AZ');
29 INSERT INTO country_code VALUES ('Bahamas','BS');
30 INSERT INTO country_code VALUES ('Bahrain','BH');
31 INSERT INTO country_code VALUES ('Bangladesh','BD');
32 INSERT INTO country_code VALUES ('Barbados','BB');
33 INSERT INTO country_code VALUES ('Belarus','BY');
34 INSERT INTO country_code VALUES ('Belgium','BE');
35 INSERT INTO country_code VALUES ('Belize','BZ');
36 INSERT INTO country_code VALUES ('Benin','BJ');
37 INSERT INTO country_code VALUES ('Bermuda','BM');
38 INSERT INTO country_code VALUES ('Bhutan','BT');
39 INSERT INTO country_code VALUES ('Bolivia','BO');
40 INSERT INTO country_code VALUES ('Bonaire, Sint Eustatius and Saba','BQ');
41 INSERT INTO country_code VALUES ('Bosnia and Herzegovina','BA');
42 INSERT INTO country_code VALUES ('Botswana','BW');
43 INSERT INTO country_code VALUES ('Bouvet Island','BV');
44 INSERT INTO country_code VALUES ('Brazil','BR');
45 INSERT INTO country_code VALUES ('British Indian Ocean Territory','IO');
46 INSERT INTO country_code VALUES ('Brunei Darussalam','BN');
47 INSERT INTO country_code VALUES ('Bulgaria','BG');
48 INSERT INTO country_code VALUES ('Burkina Faso','BF');
49 INSERT INTO country_code VALUES ('Burundi','BI');
50 INSERT INTO country_code VALUES ('Cambodia','KH');
51 INSERT INTO country_code VALUES ('Cameroon','CM');
52 INSERT INTO country_code VALUES ('Canada','CA');
53 INSERT INTO country_code VALUES ('Cape Verde','CV');
54 INSERT INTO country_code VALUES ('Cayman Islands','KY');
55 INSERT INTO country_code VALUES ('Central African Republic','CF');
56 INSERT INTO country_code VALUES ('Chad','TD');
57 INSERT INTO country_code VALUES ('Chile','CL');
58 INSERT INTO country_code VALUES ('China','CN');
59 INSERT INTO country_code VALUES ('Christmas Island','CX');
60 INSERT INTO country_code VALUES ('Cocos (Keeling) Islands','CC');
61 INSERT INTO country_code VALUES ('Colombia','CO');
62 INSERT INTO country_code VALUES ('Comoros','KM');
63 INSERT INTO country_code VALUES ('Congo','CG');
64 INSERT INTO country_code VALUES ('Congo, The Democratic Republic of the','CD');
65 INSERT INTO country_code VALUES ('Cook Islands','CK');
66 INSERT INTO country_code VALUES ('Costa Rica','CR');
67 INSERT INTO country_code VALUES ('Côte d''Ivoire','CI');
68 INSERT INTO country_code VALUES ('Croatia','HR');
69 INSERT INTO country_code VALUES ('Cuba','CU');
70 INSERT INTO country_code VALUES ('Curaçao','CW');
71 INSERT INTO country_code VALUES ('Cyprus','CY');
72 INSERT INTO country_code VALUES ('Czech Republic','CZ');
73 INSERT INTO country_code VALUES ('Denmark','DK');
74 INSERT INTO country_code VALUES ('Djibouti','DJ');
75 INSERT INTO country_code VALUES ('Dominica','DM');
76 INSERT INTO country_code VALUES ('Dominican Republic','DO');
77 INSERT INTO country_code VALUES ('Ecuador','EC');
78 INSERT INTO country_code VALUES ('Egypt','EG');
79 INSERT INTO country_code VALUES ('El Salvador','SV');
80 INSERT INTO country_code VALUES ('Equatorial Guinea','GQ');
81 INSERT INTO country_code VALUES ('Eritrea','ER');
82 INSERT INTO country_code VALUES ('Estonia','EE');
83 INSERT INTO country_code VALUES ('Ethiopia','ET');
84 INSERT INTO country_code VALUES ('Falkland Islands (Malvinas)','FK');
85 INSERT INTO country_code VALUES ('Faroe Islands','FO');
86 INSERT INTO country_code VALUES ('Fiji','FJ');
87 INSERT INTO country_code VALUES ('Finland','FI');
88 INSERT INTO country_code VALUES ('France','FR');
89 INSERT INTO country_code VALUES ('French Guiana','GF');
90 INSERT INTO country_code VALUES ('French Polynesia','PF');
91 INSERT INTO country_code VALUES ('French Southern Territories','TF');
92 INSERT INTO country_code VALUES ('Gabon','GA');
93 INSERT INTO country_code VALUES ('Gambia','GM');
94 INSERT INTO country_code VALUES ('Georgia','GE');
95 INSERT INTO country_code VALUES ('Germany','DE');
96 INSERT INTO country_code VALUES ('Ghana','GH');
97 INSERT INTO country_code VALUES ('Gibraltar','GI');
98 INSERT INTO country_code VALUES ('Greece','GR');
99 INSERT INTO country_code VALUES ('Greenland','GL');
100 INSERT INTO country_code VALUES ('Grenada','GD');
101 INSERT INTO country_code VALUES ('Guadeloupe','GP');
102 INSERT INTO country_code VALUES ('Guam','GU');
103 INSERT INTO country_code VALUES ('Guatemala','GT');
104 INSERT INTO country_code VALUES ('Guernsey','GG');
105 INSERT INTO country_code VALUES ('Guinea','GN');
106 INSERT INTO country_code VALUES ('Guinea-Bissau','GW');
107 INSERT INTO country_code VALUES ('Guyana','GY');
108 INSERT INTO country_code VALUES ('Haiti','HT');
109 INSERT INTO country_code VALUES ('Heard Island and McDonald Islands','HM');
110 INSERT INTO country_code VALUES ('Holy See (Vatican City State)','VA');
111 INSERT INTO country_code VALUES ('Honduras','HN');
112 INSERT INTO country_code VALUES ('Hong Kong','HK');
113 INSERT INTO country_code VALUES ('Hungary','HU');
114 INSERT INTO country_code VALUES ('Iceland','IS');
115 INSERT INTO country_code VALUES ('India','IN');
116 INSERT INTO country_code VALUES ('Indonesia','ID');
117 INSERT INTO country_code VALUES ('Iran, Islamic Republic of','IR');
118 INSERT INTO country_code VALUES ('Iraq','IQ');
119 INSERT INTO country_code VALUES ('Ireland','IE');
120 INSERT INTO country_code VALUES ('Isle of Man','IM');
121 INSERT INTO country_code VALUES ('Israel','IL');
122 INSERT INTO country_code VALUES ('Italy','IT');
123 INSERT INTO country_code VALUES ('Jamaica','JM');
124 INSERT INTO country_code VALUES ('Japan','JP');
125 INSERT INTO country_code VALUES ('Jersey','JE');
126 INSERT INTO country_code VALUES ('Jordan','JO');
127 INSERT INTO country_code VALUES ('Kazakhstan','KZ');
128 INSERT INTO country_code VALUES ('Kenya','KE');
129 INSERT INTO country_code VALUES ('Kiribati','KI');
130 INSERT INTO country_code VALUES ('Korea, Democratic People''s Republic of','KP');
131 INSERT INTO country_code VALUES ('Korea, Republic of','KR');
132 INSERT INTO country_code VALUES ('Kuwait','KW');
133 INSERT INTO country_code VALUES ('Kyrgyzstan','KG');
134 INSERT INTO country_code VALUES ('Lao People''s Democratic Republic','LA');
135 INSERT INTO country_code VALUES ('Latvia','LV');
136 INSERT INTO country_code VALUES ('Lebanon','LB');
137 INSERT INTO country_code VALUES ('Lesotho','LS');
138 INSERT INTO country_code VALUES ('Liberia','LR');
139 INSERT INTO country_code VALUES ('Libya','LY');
140 INSERT INTO country_code VALUES ('Liechtenstein','LI');
141 INSERT INTO country_code VALUES ('Lithuania','LT');
142 INSERT INTO country_code VALUES ('Luxembourg','LU');
143 INSERT INTO country_code VALUES ('Macao','MO');
144 INSERT INTO country_code VALUES ('Macedonia, Republic of','MK');
145 INSERT INTO country_code VALUES ('Madagascar','MG');
146 INSERT INTO country_code VALUES ('Malawi','MW');
147 INSERT INTO country_code VALUES ('Malaysia','MY');
148 INSERT INTO country_code VALUES ('Maldives','MV');
149 INSERT INTO country_code VALUES ('Mali','ML');
150 INSERT INTO country_code VALUES ('Malta','MT');
151 INSERT INTO country_code VALUES ('Marshall Islands','MH');
152 INSERT INTO country_code VALUES ('Martinique','MQ');
153 INSERT INTO country_code VALUES ('Mauritania','MR');
154 INSERT INTO country_code VALUES ('Mauritius','MU');
155 INSERT INTO country_code VALUES ('Mayotte','YT');
156 INSERT INTO country_code VALUES ('Mexico','MX');
157 INSERT INTO country_code VALUES ('Micronesia, Federated States of','FM');
158 INSERT INTO country_code VALUES ('Moldova','MD');
159 INSERT INTO country_code VALUES ('Monaco','MC');
160 INSERT INTO country_code VALUES ('Mongolia','MN');
161 INSERT INTO country_code VALUES ('Montenegro','ME');
162 INSERT INTO country_code VALUES ('Montserrat','MS');
163 INSERT INTO country_code VALUES ('Morocco','MA');
164 INSERT INTO country_code VALUES ('Mozambique','MZ');
165 INSERT INTO country_code VALUES ('Myanmar','MM');
166 INSERT INTO country_code VALUES ('Namibia','NA');
167 INSERT INTO country_code VALUES ('Nauru','NR');
168 INSERT INTO country_code VALUES ('Nepal','NP');
169 INSERT INTO country_code VALUES ('Netherlands','NL');
170 INSERT INTO country_code VALUES ('New Caledonia','NC');
171 INSERT INTO country_code VALUES ('New Zealand','NZ');
172 INSERT INTO country_code VALUES ('Nicaragua','NI');
173 INSERT INTO country_code VALUES ('Niger','NE');
174 INSERT INTO country_code VALUES ('Nigeria','NG');
175 INSERT INTO country_code VALUES ('Niue','NU');
176 INSERT INTO country_code VALUES ('Norfolk Island','NF');
177 INSERT INTO country_code VALUES ('Northern Mariana Islands','MP');
178 INSERT INTO country_code VALUES ('Norway','NO');
179 INSERT INTO country_code VALUES ('Oman','OM');
180 INSERT INTO country_code VALUES ('Pakistan','PK');
181 INSERT INTO country_code VALUES ('Palau','PW');
182 INSERT INTO country_code VALUES ('Palestinian Territory, Occupied','PS');
183 INSERT INTO country_code VALUES ('Panama','PA');
184 INSERT INTO country_code VALUES ('Papua New Guinea','PG');
185 INSERT INTO country_code VALUES ('Paraguay','PY');
186 INSERT INTO country_code VALUES ('Peru','PE');
187 INSERT INTO country_code VALUES ('Philippines','PH');
188 INSERT INTO country_code VALUES ('Pitcairn','PN');
189 INSERT INTO country_code VALUES ('Poland','PL');
190 INSERT INTO country_code VALUES ('Portugal','PT');
191 INSERT INTO country_code VALUES ('Puerto Rico','PR');
192 INSERT INTO country_code VALUES ('Qatar','QA');
193 INSERT INTO country_code VALUES ('Réunion','RE');
194 INSERT INTO country_code VALUES ('Romania','RO');
195 INSERT INTO country_code VALUES ('Russian Federation','RU');
196 INSERT INTO country_code VALUES ('Rwanda','RW');
197 INSERT INTO country_code VALUES ('Saint Barthélemy','BL');
198 INSERT INTO country_code VALUES ('Saint Helena, Ascension and Tristan da Cunha','SH');
199 INSERT INTO country_code VALUES ('Saint Kitts and Nevis','KN');
200 INSERT INTO country_code VALUES ('Saint Lucia','LC');
201 INSERT INTO country_code VALUES ('Saint Martin (French part)','MF');
202 INSERT INTO country_code VALUES ('Saint Pierre and Miquelon','PM');
203 INSERT INTO country_code VALUES ('Saint Vincent and the Grenadines','VC');
204 INSERT INTO country_code VALUES ('Samoa','WS');
205 INSERT INTO country_code VALUES ('San Marino','SM');
206 INSERT INTO country_code VALUES ('Sao Tome and Principe','ST');
207 INSERT INTO country_code VALUES ('Saudi Arabia','SA');
208 INSERT INTO country_code VALUES ('Senegal','SN');
209 INSERT INTO country_code VALUES ('Serbia','RS');
210 INSERT INTO country_code VALUES ('Seychelles','SC');
211 INSERT INTO country_code VALUES ('Sierra Leone','SL');
212 INSERT INTO country_code VALUES ('Singapore','SG');
213 INSERT INTO country_code VALUES ('Sint Maarten (Dutch part)','SX');
214 INSERT INTO country_code VALUES ('Slovakia','SK');
215 INSERT INTO country_code VALUES ('Slovenia','SI');
216 INSERT INTO country_code VALUES ('Solomon Islands','SB');
217 INSERT INTO country_code VALUES ('Somalia','SO');
218 INSERT INTO country_code VALUES ('South Africa','ZA');
219 INSERT INTO country_code VALUES ('South Georgia and the South Sandwich Islands','GS');
220 INSERT INTO country_code VALUES ('Spain','ES');
221 INSERT INTO country_code VALUES ('Sri Lanka','LK');
222 INSERT INTO country_code VALUES ('Sudan','SD');
223 INSERT INTO country_code VALUES ('Suriname','SR');
224 INSERT INTO country_code VALUES ('South Sudan','SS');
225 INSERT INTO country_code VALUES ('Svalbard and Jan Mayen','SJ');
226 INSERT INTO country_code VALUES ('Swaziland','SZ');
227 INSERT INTO country_code VALUES ('Sweden','SE');
228 INSERT INTO country_code VALUES ('Switzerland','CH');
229 INSERT INTO country_code VALUES ('Syrian Arab Republic','SY');
230 INSERT INTO country_code VALUES ('Taiwan','TW');
231 INSERT INTO country_code VALUES ('Tajikistan','TJ');
232 INSERT INTO country_code VALUES ('Tanzania, United Republic of','TZ');
233 INSERT INTO country_code VALUES ('Thailand','TH');
234 INSERT INTO country_code VALUES ('Timor-Leste','TL');
235 INSERT INTO country_code VALUES ('Togo','TG');
236 INSERT INTO country_code VALUES ('Tokelau','TK');
237 INSERT INTO country_code VALUES ('Tonga','TO');
238 INSERT INTO country_code VALUES ('Trinidad and Tobago','TT');
239 INSERT INTO country_code VALUES ('Tunisia','TN');
240 INSERT INTO country_code VALUES ('Turkey','TR');
241 INSERT INTO country_code VALUES ('Turkmenistan','TM');
242 INSERT INTO country_code VALUES ('Turks and Caicos Islands','TC');
243 INSERT INTO country_code VALUES ('Tuvalu','TV');
244 INSERT INTO country_code VALUES ('Uganda','UG');
245 INSERT INTO country_code VALUES ('Ukraine','UA');
246 INSERT INTO country_code VALUES ('United Arab Emirates','AE');
247 INSERT INTO country_code VALUES ('United Kingdom','GB');
248 INSERT INTO country_code VALUES ('United States','US');
249 INSERT INTO country_code VALUES ('United States Minor Outlying Islands','UM');
250 INSERT INTO country_code VALUES ('Uruguay','UY');
251 INSERT INTO country_code VALUES ('Uzbekistan','UZ');
252 INSERT INTO country_code VALUES ('Vanuatu','VU');
253 INSERT INTO country_code VALUES ('Venezuela','VE');
254 INSERT INTO country_code VALUES ('Viet Nam','VN');
255 INSERT INTO country_code VALUES ('Virgin Islands, British','VG');
256 INSERT INTO country_code VALUES ('Virgin Islands, U.S.','VI');
257 INSERT INTO country_code VALUES ('Wallis and Futuna','WF');
258 INSERT INTO country_code VALUES ('Western Sahara','EH');
259 INSERT INTO country_code VALUES ('Yemen','YE');
260 INSERT INTO country_code VALUES ('Zambia','ZM');
261 INSERT INTO country_code VALUES ('Zimbabwe','ZW');