ALTER TABLE users DROP COLUMN addr;
ALTER TABLE users DROP COLUMN locidispid;
ALTER TABLE users DROP COLUMN internet_service_provider;
ALTER TABLE users ADD COLUMN statecode varchar(2);
ALTER TABLE users ADD COLUMN countrycode varchar(2);