how can i edit on phpmyadmin to give fk_i_item on table oc_item_location a    AUTO_INCREMENT option like pk_i_id on oc_t_item table

to take both the same number

when i try to edit it

appear to me this error

Cannot change column 'fk_i_item_id': used in a foreign key constraint 'oc_t_item_location_ibfk_1'

how can i solve this problem


thanks in advanced

@Ahmed
That is foreign key protecting your tables. Not a problem, it is feature.

@MB Themes

i know sir that but when i upload content to oc_t_item it take pk_i_id automatic without i enter it but in oc_t_item_location it must to enter fk_i_item value manully and it will be hard for thousands of ads for that i need to know how to disable this feature to can make the field on oc_t_item take the fk_i_item auto like pk_i_id on oc_t_item

@Ahmed
fk_i_item_id must match to something from t_item.pk_i_id, otherwise do not put there such value.

@ MB Themes

can i change these column

   fk_c_country_code   s_country   s_address   s_zip   fk_i_region_id   s_region   fk_i_city_id   s_city   fk_i_city_area_id   s_city_area   d_coord_lat   d_coord_long

that located on oc_t_item_location to oc_t_item table



and delete the column fk_i_item_id that located on oc_t_item_location and depend on pk_i_id rather than depend on it



is this possible or not ?

I do not think you understand to concept of relational database
No it is not possible.