6 print "ALTER TABLE users ADD COLUMN firstname varchar(60);
7 ALTER TABLE users ADD COLUMN lastname varchar(60);
8 ALTER TABLE users ADD COLUMN address2 text;
9 ALTER TABLE users ADD COLUMN ccode char(2);
10 ALTER TABLE users ALTER COLUMN ccode SET DEFAULT 'US';
11 UPDATE USERS SET ccode='US',firstname=realname WHERE firstname is null;
13 CREATE TABLE country_code (
14 country_name varchar(80),
15 ccode char(2) primary key
20 foreach (`isoquery -c`) {
22 my $cc = substr($_,0,2);
25 print "INSERT INTO country_code VALUES ('$_','$cc');\n";