Anemometer does not support 5.7 as backend DB

[tkarraker]

The install sql file does not create the tables properly during first setup. It appears to be due to a change in the default timestamp format in 5.7.

[anthonyAdhese]

I fixed it by doing following changes: ts_min datetime NOT NULL DEFAULT '1990-01-01 00:00:00', ts_max datetime NOT NULL DEFAULT '1990-01-01 00:00:00',

Ran it on Server version: 5.7.8-rc MySQL Community Server (GPL)

[tkarraker]

@anthonyAdhese Thank you for the heads up on the fix. If you make any more changes to the codebase, would you be interested in committing them to a feature branch for us to merge? Since 5.7 is becoming more and more common, we really need to get on top of this.

[anthonyAdhese]

I can have a look at it when I'm on my workstation :)