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 ('ALBANIA','AL');
15 INSERT INTO country_code VALUES ('ALGERIA','DZ');
16 INSERT INTO country_code VALUES ('AMERICAN SAMOA','AS');
17 INSERT INTO country_code VALUES ('ANDORRA','AD');
18 INSERT INTO country_code VALUES ('ANGOLA','AO');
19 INSERT INTO country_code VALUES ('ANGUILLA','AI');
20 INSERT INTO country_code VALUES ('ANTARCTICA','AQ');
21 INSERT INTO country_code VALUES ('ANTIGUA AND BARBUDA','AG');
22 INSERT INTO country_code VALUES ('ARGENTINA','AR');
23 INSERT INTO country_code VALUES ('ARMENIA','AM');
24 INSERT INTO country_code VALUES ('ARUBA','AW');
25 INSERT INTO country_code VALUES ('AUSTRALIA','AU');
26 INSERT INTO country_code VALUES ('AUSTRIA','AT');
27 INSERT INTO country_code VALUES ('AZERBAIJAN','AZ');
28 INSERT INTO country_code VALUES ('BAHAMAS','BS');
29 INSERT INTO country_code VALUES ('BAHRAIN','BH');
30 INSERT INTO country_code VALUES ('BANGLADESH','BD');
31 INSERT INTO country_code VALUES ('BARBADOS','BB');
32 INSERT INTO country_code VALUES ('BELARUS','BY');
33 INSERT INTO country_code VALUES ('BELGIUM','BE');
34 INSERT INTO country_code VALUES ('BELIZE','BZ');
35 INSERT INTO country_code VALUES ('BENIN','BJ');
36 INSERT INTO country_code VALUES ('BERMUDA','BM');
37 INSERT INTO country_code VALUES ('BHUTAN','BT');
38 INSERT INTO country_code VALUES ('BOLIVIA','BO');
39 INSERT INTO country_code VALUES ('BOSNIA AND HERZEGOVINA','BA');
40 INSERT INTO country_code VALUES ('BOTSWANA','BW');
41 INSERT INTO country_code VALUES ('BOUVET ISLAND','BV');
42 INSERT INTO country_code VALUES ('BRAZIL','BR');
43 INSERT INTO country_code VALUES ('BRITISH INDIAN OCEAN TERRITORY','IO');
44 INSERT INTO country_code VALUES ('BRUNEI DARUSSALAM','BN');
45 INSERT INTO country_code VALUES ('BULGARIA','BG');
46 INSERT INTO country_code VALUES ('BURKINA FASO','BF');
47 INSERT INTO country_code VALUES ('BURUNDI','BI');
48 INSERT INTO country_code VALUES ('CAMBODIA','KH');
49 INSERT INTO country_code VALUES ('CAMEROON','CM');
50 INSERT INTO country_code VALUES ('CANADA','CA');
51 INSERT INTO country_code VALUES ('CAPE VERDE','CV');
52 INSERT INTO country_code VALUES ('CAYMAN ISLANDS','KY');
53 INSERT INTO country_code VALUES ('CENTRAL AFRICAN REPUBLIC','CF');
54 INSERT INTO country_code VALUES ('CHAD','TD');
55 INSERT INTO country_code VALUES ('CHILE','CL');
56 INSERT INTO country_code VALUES ('CHINA','CN');
57 INSERT INTO country_code VALUES ('CHRISTMAS ISLAND','CX');
58 INSERT INTO country_code VALUES ('COCOS (KEELING) ISLANDS','CC');
59 INSERT INTO country_code VALUES ('COLOMBIA','CO');
60 INSERT INTO country_code VALUES ('COMOROS','KM');
61 INSERT INTO country_code VALUES ('CONGO','CG');
62 INSERT INTO country_code VALUES ('CONGO, THE DEMOCRATIC REPUBLIC OF THE','CD');
63 INSERT INTO country_code VALUES ('COOK ISLANDS','CK');
64 INSERT INTO country_code VALUES ('COSTA RICA','CR');
65 INSERT INTO country_code VALUES ('COTE D\'IVOIRE','CI');
66 INSERT INTO country_code VALUES ('CROATIA','HR');
67 INSERT INTO country_code VALUES ('CUBA','CU');
68 INSERT INTO country_code VALUES ('CYPRUS','CY');
69 INSERT INTO country_code VALUES ('CZECH REPUBLIC','CZ');
70 INSERT INTO country_code VALUES ('DENMARK','DK');
71 INSERT INTO country_code VALUES ('DJIBOUTI','DJ');
72 INSERT INTO country_code VALUES ('DOMINICA','DM');
73 INSERT INTO country_code VALUES ('DOMINICAN REPUBLIC','DO');
74 INSERT INTO country_code VALUES ('EAST TIMOR','TP');
75 INSERT INTO country_code VALUES ('ECUADOR','EC');
76 INSERT INTO country_code VALUES ('EGYPT','EG');
77 INSERT INTO country_code VALUES ('EL SALVADOR','SV');
78 INSERT INTO country_code VALUES ('EQUATORIAL GUINEA','GQ');
79 INSERT INTO country_code VALUES ('ERITREA','ER');
80 INSERT INTO country_code VALUES ('ESTONIA','EE');
81 INSERT INTO country_code VALUES ('ETHIOPIA','ET');
82 INSERT INTO country_code VALUES ('FALKLAND ISLANDS (MALVINAS)','FK');
83 INSERT INTO country_code VALUES ('FAROE ISLANDS','FO');
84 INSERT INTO country_code VALUES ('FIJI','FJ');
85 INSERT INTO country_code VALUES ('FINLAND','FI');
86 INSERT INTO country_code VALUES ('FRANCE','FR');
87 INSERT INTO country_code VALUES ('FRENCH GUIANA','GF');
88 INSERT INTO country_code VALUES ('FRENCH POLYNESIA','PF');
89 INSERT INTO country_code VALUES ('FRENCH SOUTHERN TERRITORIES','TF');
90 INSERT INTO country_code VALUES ('GABON','GA');
91 INSERT INTO country_code VALUES ('GAMBIA','GM');
92 INSERT INTO country_code VALUES ('GEORGIA','GE');
93 INSERT INTO country_code VALUES ('GERMANY','DE');
94 INSERT INTO country_code VALUES ('GHANA','GH');
95 INSERT INTO country_code VALUES ('GIBRALTAR','GI');
96 INSERT INTO country_code VALUES ('GREECE','GR');
97 INSERT INTO country_code VALUES ('GREENLAND','GL');
98 INSERT INTO country_code VALUES ('GRENADA','GD');
99 INSERT INTO country_code VALUES ('GUADELOUPE','GP');
100 INSERT INTO country_code VALUES ('GUAM','GU');
101 INSERT INTO country_code VALUES ('GUATEMALA','GT');
102 INSERT INTO country_code VALUES ('GUINEA','GN');
103 INSERT INTO country_code VALUES ('GUINEA-BISSAU','GW');
104 INSERT INTO country_code VALUES ('GUYANA','GY');
105 INSERT INTO country_code VALUES ('HAITI','HT');
106 INSERT INTO country_code VALUES ('HEARD ISLAND AND MCDONALD ISLANDS','HM');
107 INSERT INTO country_code VALUES ('HOLY SEE (VATICAN CITY STATE)','VA');
108 INSERT INTO country_code VALUES ('HONDURAS','HN');
109 INSERT INTO country_code VALUES ('HONG KONG','HK');
110 INSERT INTO country_code VALUES ('HUNGARY','HU');
111 INSERT INTO country_code VALUES ('ICELAND','IS');
112 INSERT INTO country_code VALUES ('INDIA','IN');
113 INSERT INTO country_code VALUES ('INDONESIA','ID');
114 INSERT INTO country_code VALUES ('IRAN, ISLAMIC REPUBLIC OF','IR');
115 INSERT INTO country_code VALUES ('IRAQ','IQ');
116 INSERT INTO country_code VALUES ('IRELAND','IE');
117 INSERT INTO country_code VALUES ('ISRAEL','IL');
118 INSERT INTO country_code VALUES ('ITALY','IT');
119 INSERT INTO country_code VALUES ('JAMAICA','JM');
120 INSERT INTO country_code VALUES ('JAPAN','JP');
121 INSERT INTO country_code VALUES ('JORDAN','JO');
122 INSERT INTO country_code VALUES ('KAZAKSTAN','KZ');
123 INSERT INTO country_code VALUES ('KENYA','KE');
124 INSERT INTO country_code VALUES ('KIRIBATI','KI');
125 INSERT INTO country_code VALUES ('KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF','KP');
126 INSERT INTO country_code VALUES ('KOREA, REPUBLIC OF','KR');
127 INSERT INTO country_code VALUES ('KUWAIT','KW');
128 INSERT INTO country_code VALUES ('KYRGYZSTAN','KG');
129 INSERT INTO country_code VALUES ('LAO PEOPLE\'S DEMOCRATIC REPUBLIC','LA');
130 INSERT INTO country_code VALUES ('LATVIA','LV');
131 INSERT INTO country_code VALUES ('LEBANON','LB');
132 INSERT INTO country_code VALUES ('LESOTHO','LS');
133 INSERT INTO country_code VALUES ('LIBERIA','LR');
134 INSERT INTO country_code VALUES ('LIBYAN ARAB JAMAHIRIYA','LY');
135 INSERT INTO country_code VALUES ('LIECHTENSTEIN','LI');
136 INSERT INTO country_code VALUES ('LITHUANIA','LT');
137 INSERT INTO country_code VALUES ('LUXEMBOURG','LU');
138 INSERT INTO country_code VALUES ('MACAU','MO');
139 INSERT INTO country_code VALUES ('MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF','MK');
140 INSERT INTO country_code VALUES ('MADAGASCAR','MG');
141 INSERT INTO country_code VALUES ('MALAWI','MW');
142 INSERT INTO country_code VALUES ('MALAYSIA','MY');
143 INSERT INTO country_code VALUES ('MALDIVES','MV');
144 INSERT INTO country_code VALUES ('MALI','ML');
145 INSERT INTO country_code VALUES ('MALTA','MT');
146 INSERT INTO country_code VALUES ('MARSHALL ISLANDS','MH');
147 INSERT INTO country_code VALUES ('MARTINIQUE','MQ');
148 INSERT INTO country_code VALUES ('MAURITANIA','MR');
149 INSERT INTO country_code VALUES ('MAURITIUS','MU');
150 INSERT INTO country_code VALUES ('MAYOTTE','YT');
151 INSERT INTO country_code VALUES ('MEXICO','MX');
152 INSERT INTO country_code VALUES ('MICRONESIA, FEDERATED STATES OF','FM');
153 INSERT INTO country_code VALUES ('MOLDOVA, REPUBLIC OF','MD');
154 INSERT INTO country_code VALUES ('MONACO','MC');
155 INSERT INTO country_code VALUES ('MONGOLIA','MN');
156 INSERT INTO country_code VALUES ('MONTSERRAT','MS');
157 INSERT INTO country_code VALUES ('MOROCCO','MA');
158 INSERT INTO country_code VALUES ('MOZAMBIQUE','MZ');
159 INSERT INTO country_code VALUES ('MYANMAR','MM');
160 INSERT INTO country_code VALUES ('NAMIBIA','NA');
161 INSERT INTO country_code VALUES ('NAURU','NR');
162 INSERT INTO country_code VALUES ('NEPAL','NP');
163 INSERT INTO country_code VALUES ('NETHERLANDS','NL');
164 INSERT INTO country_code VALUES ('NETHERLANDS ANTILLES','AN');
165 INSERT INTO country_code VALUES ('NEW CALEDONIA','NC');
166 INSERT INTO country_code VALUES ('NEW ZEALAND','NZ');
167 INSERT INTO country_code VALUES ('NICARAGUA','NI');
168 INSERT INTO country_code VALUES ('NIGER','NE');
169 INSERT INTO country_code VALUES ('NIGERIA','NG');
170 INSERT INTO country_code VALUES ('NIUE','NU');
171 INSERT INTO country_code VALUES ('NORFOLK ISLAND','NF');
172 INSERT INTO country_code VALUES ('NORTHERN MARIANA ISLANDS','MP');
173 INSERT INTO country_code VALUES ('NORWAY','NO');
174 INSERT INTO country_code VALUES ('OMAN','OM');
175 INSERT INTO country_code VALUES ('PAKISTAN','PK');
176 INSERT INTO country_code VALUES ('PALAU','PW');
177 INSERT INTO country_code VALUES ('PALESTINIAN TERRITORY, OCCUPIED','PS');
178 INSERT INTO country_code VALUES ('PANAMA','PA');
179 INSERT INTO country_code VALUES ('PAPUA NEW GUINEA','PG');
180 INSERT INTO country_code VALUES ('PARAGUAY','PY');
181 INSERT INTO country_code VALUES ('PERU','PE');
182 INSERT INTO country_code VALUES ('PHILIPPINES','PH');
183 INSERT INTO country_code VALUES ('PITCAIRN','PN');
184 INSERT INTO country_code VALUES ('POLAND','PL');
185 INSERT INTO country_code VALUES ('PORTUGAL','PT');
186 INSERT INTO country_code VALUES ('PUERTO RICO','PR');
187 INSERT INTO country_code VALUES ('QATAR','QA');
188 INSERT INTO country_code VALUES ('REUNION','RE');
189 INSERT INTO country_code VALUES ('ROMANIA','RO');
190 INSERT INTO country_code VALUES ('RUSSIAN FEDERATION','RU');
191 INSERT INTO country_code VALUES ('RWANDA','RW');
192 INSERT INTO country_code VALUES ('SAINT HELENA','SH');
193 INSERT INTO country_code VALUES ('SAINT KITTS AND NEVIS','KN');
194 INSERT INTO country_code VALUES ('SAINT LUCIA','LC');
195 INSERT INTO country_code VALUES ('SAINT PIERRE AND MIQUELON','PM');
196 INSERT INTO country_code VALUES ('SAINT VINCENT AND THE GRENADINES','VC');
197 INSERT INTO country_code VALUES ('SAMOA','WS');
198 INSERT INTO country_code VALUES ('SAN MARINO','SM');
199 INSERT INTO country_code VALUES ('SAO TOME AND PRINCIPE','ST');
200 INSERT INTO country_code VALUES ('SAUDI ARABIA','SA');
201 INSERT INTO country_code VALUES ('SENEGAL','SN');
202 INSERT INTO country_code VALUES ('SEYCHELLES','SC');
203 INSERT INTO country_code VALUES ('SIERRA LEONE','SL');
204 INSERT INTO country_code VALUES ('SINGAPORE','SG');
205 INSERT INTO country_code VALUES ('SLOVAKIA','SK');
206 INSERT INTO country_code VALUES ('SLOVENIA','SI');
207 INSERT INTO country_code VALUES ('SOLOMON ISLANDS','SB');
208 INSERT INTO country_code VALUES ('SOMALIA','SO');
209 INSERT INTO country_code VALUES ('SOUTH AFRICA','ZA');
210 INSERT INTO country_code VALUES ('SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS','GS');
211 INSERT INTO country_code VALUES ('SPAIN','ES');
212 INSERT INTO country_code VALUES ('SRI LANKA','LK');
213 INSERT INTO country_code VALUES ('SUDAN','SD');
214 INSERT INTO country_code VALUES ('SURINAME','SR');
215 INSERT INTO country_code VALUES ('SVALBARD AND JAN MAYEN','SJ');
216 INSERT INTO country_code VALUES ('SWAZILAND','SZ');
217 INSERT INTO country_code VALUES ('SWEDEN','SE');
218 INSERT INTO country_code VALUES ('SWITZERLAND','CH');
219 INSERT INTO country_code VALUES ('SYRIAN ARAB REPUBLIC','SY');
220 INSERT INTO country_code VALUES ('TAIWAN, PROVINCE OF CHINA','TW');
221 INSERT INTO country_code VALUES ('TAJIKISTAN','TJ');
222 INSERT INTO country_code VALUES ('TANZANIA, UNITED REPUBLIC OF','TZ');
223 INSERT INTO country_code VALUES ('THAILAND','TH');
224 INSERT INTO country_code VALUES ('TOGO','TG');
225 INSERT INTO country_code VALUES ('TOKELAU','TK');
226 INSERT INTO country_code VALUES ('TONGA','TO');
227 INSERT INTO country_code VALUES ('TRINIDAD AND TOBAGO','TT');
228 INSERT INTO country_code VALUES ('TUNISIA','TN');
229 INSERT INTO country_code VALUES ('TURKEY','TR');
230 INSERT INTO country_code VALUES ('TURKMENISTAN','TM');
231 INSERT INTO country_code VALUES ('TURKS AND CAICOS ISLANDS','TC');
232 INSERT INTO country_code VALUES ('TUVALU','TV');
233 INSERT INTO country_code VALUES ('UGANDA','UG');
234 INSERT INTO country_code VALUES ('UKRAINE','UA');
235 INSERT INTO country_code VALUES ('UNITED ARAB EMIRATES','AE');
236 INSERT INTO country_code VALUES ('UNITED STATES','US');
237 INSERT INTO country_code VALUES ('UNITED STATES MINOR OUTLYING ISLANDS','UM');
238 INSERT INTO country_code VALUES ('URUGUAY','UY');
239 INSERT INTO country_code VALUES ('UZBEKISTAN','UZ');
240 INSERT INTO country_code VALUES ('VANUATU','VU');
241 INSERT INTO country_code VALUES ('VENEZUELA','VE');
242 INSERT INTO country_code VALUES ('VIET NAM','VN');
243 INSERT INTO country_code VALUES ('VIRGIN ISLANDS, BRITISH','VG');
244 INSERT INTO country_code VALUES ('VIRGIN ISLANDS, U.S.','VI');
245 INSERT INTO country_code VALUES ('WALLIS AND FUTUNA','WF');
246 INSERT INTO country_code VALUES ('WESTERN SAHARA','EH');
247 INSERT INTO country_code VALUES ('YEMEN','YE');
248 INSERT INTO country_code VALUES ('YUGOSLAVIA','YU');
249 INSERT INTO country_code VALUES ('ZAMBIA','ZM');
250 INSERT INTO country_code VALUES ('ZIMBABWE','ZW');
251 INSERT INTO country_code VALUES ('UNITED KINGDOM','UK');