ALTER TABLE cust_main ADD middle varchar(80) NULL; ALTER TABLE cust_main ADD titlenum int NULL; ALTER TABLE cust_main CHANGE state state varchar(80) NULL; ALTER TABLE cust_main_county CHANGE state state varchar(80) NULL; ALTER TABLE cust_main_county ADD country char(2); UPDATE cust_main_county SET country = "US" where country IS NULL; CREATE TABLE part_title ( titlenum int NOT NULL, title varchar(80), PRIMARY KEY (titlenum) );