Fix some MySQL queries

[kay0u]

AUTOINCREMENT should be AUTO_INCREMENT in MySQL

datetime('now')) doesn't exist in MySQL, use DATE(NOW())

[matthewalanpenning]

Great catch. I will plan on merging this in the next release. Thanks!