Create as 'Int' and set to 'Auto Increment'

Don't call the row Index as its a special MySQL word which you'll have to use in quotes if you do.