I ran the alter table code and then installed the corrected file you provided. Thank you very much. The following messages appeared at the top of the page after updating with the patch.
-17 statements processed
-cannot create table subcontractors already exists (shown 2 times)
-Note 1 statement ignored see upgrade_exceptions table for additional details

I don't know where to find the table can you point me in the right direction? Also at the end of one of the error callouts it lists PHP:171 . Is that a clue to help me find the error in the code? What does 171 mean? I am very new to this so any help is greatly appreciated. thanks again