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
add missing semicolon
add missing semicolon
add missing semi-colon #3
rm var before variable already defined (parameter of function)
replace new Array() with more idiomatic []
Merge pull request #353 from Trott/course-manager-session-dom-js-cleanup

Course manager session dom js cleanup
fixed #354.