ALTER TABLE `firm` ADD COLUMN `streetAddress1` VARCHAR(255) NULL  AFTER `firmname` ,
ADD COLUMN `streetAddress2` VARCHAR(255) NULL  AFTER `streetAddress1` ,
ADD COLUMN `city` VARCHAR(255) NULL  AFTER `streetAddress2` ,
ADD COLUMN `zipcode` VARCHAR(45) NULL  AFTER `city` ,
ADD COLUMN `statecode` VARCHAR(10) NULL  AFTER `zipcode` ,
ADD COLUMN `countrycode` VARCHAR(10) NULL  AFTER `statecode` ,
ADD COLUMN `phone` VARCHAR(45) NULL  AFTER `countrycode`;
