do the same as in products_description (duplicated rows for two ids) on another php file

[Pelvis 2]

Hallo Community!

When we add a new language, in the database some tables (eg products_description) get duplicated ids. For example we have for the same products_id values for both English and german ..the thing is that since in products_id is a Primary key,this seems to violate the uniqueness of the key and generally, Sql throws an error if we try to add a new row with an existing id. So the question is how can we do the same thing (duplicated rows for two ids), in tables apart from those that change when we add a language. 

Edited February 1 by Pelvis

[♥ecartz 442]

The products_description table has a multiple column key on products_id and language_id. 

  PRIMARY KEY  (products_id,language_id),

So one row per combination.  I.e. if English is 1 and German is 2, then you can have products_id 1/language_id 1 and products_id 1/language_id 2 but not a second 1/1. 

You could change other tables to have multiple column keys too or even remove the key entirely.  But weird things can happen if the system is relying on the values being unique. 

[Pelvis 2]

Thank you so much! now I have understand how it works :-)