removed crazy collation definition on an integer column. corrected column data type syntax by putting the collation behind the type declaration.