conformed to standards, better names
set attribute sort order by attribute name
fixed numbering issue by creating as MyISAM then switching to InnoDB