ALTER TABLE Occupation 
ADD COLUMN ui_name varchar(100) DEFAULT NULL,
ADD COLUMN system_defined tinyint(1) NOT NULL DEFAULT '1';

Update Occupation SET ui_name = name;

ALTER TABLE EmployeeTitle 
ADD COLUMN ui_name varchar(100) DEFAULT NULL,
ADD COLUMN system_defined tinyint(1) NOT NULL DEFAULT '1';

Update EmployeeTitle SET ui_name = name;

