installation: change table TYPE to ENGINE in SQL

• In CREATE TABLE SQL statements, use ENGINE instead of deprecated TYPE for better compliance with higher MySQL versions.

• Remove forcing of PACK_KEYS along the way, since the usual MySQL default behaviour is very nice already.

• Cherry-picked from fbbfaa66645e3cb0b9d37c7abf083f76e3e31344.