MySQL - will the primary key create another index if the column is already indexed?

Question

I have two tables for multilingual articles. In the first table, I have no text columns (id, authorid, date, etc.). In the second table, I have text columns (headers, content, etc.).

For each row in the first table, I can have many rows in the second table. For example, for an article translated into three languages, I have three lines in table 2.

In table 2, the column (id) has a foreign key to table 1, so it is already indexed. I cannot set a unique column identifier for table 2 since it is not unique. However, I cannot edit the data from table 2 in the workbench, as it says - there is no primary key or non-zero unique key.

What I say according to the scheme:

Table1{
 id
 date
 authorId
}

Table2{
 id
 title
 content
 languageId
}

, - (id) 2 - mysql ?

Answer 1

id 2, id UNIQUE NOT NULL.

, 2 workbench, composite primary key on Table2, id languageId.

ALTER TABLE table2 ADD PRIMARY KEY( id, languageId );

, id, languageId 2.