You will need to adjust the SQL for the table structure to suit the requirements of your server. The Windows implementation of MySQL seems to enforce restrictions that don't manifest problems on other operating systems.