removed crazy collation definition on an integer column. corrected column data type syntax by putting the collation behind the type declaration.
Merge pull request #351 from stopfstedt/sql_cleanup

SQL syntax fixes