In pset 7 CS50 Finance I have a problem where new rows are not being added to my data tables Portfolio and History, and I think the reason is that I set the id column to be the Primary Key. So, now I wonder how to uncheck the primary key option. When I try to edit my table in phpLiteAdmin I am not able to edit the primary key. Just the field name and data type are editable.
Do I need to just delete the column and make a new one with the same name, and not check the primary key option? Or do I need to write some SQL statement?
Also, for some reason I think I set the id column to auto increment when I made the table. I guess that would be wrong too, so I also need to uncheck that option as well.
Any help would be appreciated!