Deleted manufacturers_id on accident HELP!!!!!

[Arpit]

Plz help me, i deleted the manufacturers_id under manufactures table on accident plz help ....
arpit

[michael_s]

Just add the field to the table again using phpmyadmin. You can also open the sql file included with the zip archive and find the mysql command that creates the field and paste it into a mysql query using phpmyadmin.

[Arpit]

how do i add the field? i m sorry i m new to phpmyadmin

[michael_s]

The easiest way would be to open the original sql file found in the oscommerce zip archive in a text editor. Then, find the structure and data for the manuafacturers table. Copy it to the clipboard.

Then in phpMyadmin, select the oscommerce database. You will get a list of tables. Click the checkbox next to the manuafacturers table. Then select the drop table from the dropdown box.

Next, you need to click on the SQL tab at the top of phpmyadmin. Then in the text box, paste the sql info that you copied earlier to the text box.

Click the go button. That will re-create the manufacturers table. Done