Since the MySQL-Front isn't available, I went for the free HeidiSQL.
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?