Changed TYPE to ENGINE to support mysql 5.5.