SQL Schema Error

[fdterr]

Repeatedly getting this error when trying to run the retrosheets schema.sql file:

Line no.:350 Error Code: 1178 - The storage engine for the table doesn't support native partitioning

I haven't edited anything except lines 351 and 537 to add years 2016 and 2017

[dsriggs1]

@fdterr I ran into this same issue when switching to mysql 8.0. I changed the schema definition partitioning from 'MYISAM' to 'INNODB', and this resolved the issue for me:

https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-storage-engines.html