use "ENGINE=InnoDB" rather than deprecated "TYPE=InnoDB"