added field lengths to make it compatible with MySQL