[mlov420]

Anyone having issues with SQL stats?

I see that the Table creation and other SQL is written for MySQL 8+ . That is a relatively new version and most people are still in version 5.7. I can't get a table created with the current SQL query included with this plugin. It gives an error for the COLLATE part, since it doesn't exist until MySQL 8. Even if I remove it, there is another error that I can't seem to identify that is stopping it from creating a table.

Having no other issues with about 20 other DBs in this SQL setup. Figured I'd ask if others are experiencing this or if using this with MySQL 5.7 or less is going to cause problems. Maybe it's something the dev could include in a future update...compatibility with older versions?