Women in Technology

This weird thing happens when I try to add additional items to the database. It's as if the id field in the recipies table never increments.

Adding the first recipe went fine, however adding a second one gives me something like this:

Mysql::Error: #23000Duplicate entry '0' for key 1: INSERT INTO recipes ... blah blah blah

If I go to Heidi and manually change the field default value from 0 to 1, then I can go add a second recipe. But, adding a third recipe does the same thing. I can manually keep changing the default value from 0, to 1, to 2, to 3, and so on, to continue to add items.

I can open the id field and put a check on "AutoIncrement", but that doesn't seem to do anything. When I look at it again, and I open it back up, AutoIncrement is unchecked.

So... is this a problem with HeidiSQL?

Or is there something I've missed completely?