Upgrade to MySQL 5.5 breaks SQL scripts due to syntax change

[GoogleCodeExporter]

Which plugin is the bug/enhancement related to ?
Custom Browse / Custom Scan


What version of SlimServer/SqueezeCeneter are you using? On what operating
system?
Logitech Media Server Version: 7.7.6 - 1418369353 @ Sat Dec 13 02:04:05 UTC 2014
Hostname: cardinalfang
Server HTTP Port Number: 9000
Operating system: Debian - EN - utf8
Platform Architecture: x86_64-linux
Perl Version: 5.18.2 - x86_64-linux-gnu-thread-multi
Database Version: MySQL 5.5.40-0ubuntu0.14.04.1
Total Players Recognized: 1


Could you describe the problem or enhancment ?

Creating/Modifying MySQL tables fails with an error because the syntax for 
"Type=InnoDB" changed to "Engine=InnoDB"in MySQL 5.5. Manually creating tables 
does not seem to resolve the issue
See: 
http://stackoverflow.com/questions/16408334/how-do-i-fix-error-in-your-sql-synta
x-check-the-manual-for-the-right-synta

What steps will reproduce the problem?
1. Upgrade MySQL to 5.5
2.
3.

Original issue reported on code.google.com by vanraaij...@gmail.com on 14 Jan 2015 at 10:14