Fix missing AUTO_INCREMENT features.

I missed this the first time.
Refactor case switch and add missing types.
Add very basic primary key support.

Add basic single and multi column primary key support.
Add various kinds of non length based indexes.

Add support for the main non-foriegn key types used in MySQL.
I still need to add support for indexes with lengths.