extracted table engine type specification to alter statements at the end of the file.