Prerequisites

• I understand and accept the project's code of conduct.
• I have already searched in existing issues and found no previous report of this bug.

Describe the bug and add attachments

When updating the database scema to the latest installed version, php bin/console doctrine:schema:update --dump-sql showed these lines related to the psgdpr module:

ALTER TABLE ps_psgdpr_consent_lang MODIFY id_gdpr_consent INT UNSIGNED NOT NULL;
ALTER TABLE ps_psgdpr_consent_lang DROP PRIMARY KEY;
ALTER TABLE ps_psgdpr_consent_lang CHANGE id_gdpr_consent id_gdpr_consent INT NOT NULL, CHANGE id_lang id_lang INT NOT NULL, CHANGE id_shop id_shop INT NOT NULL, CHANGE message message VARCHAR(255) NOT NULL;
ALTER TABLE ps_psgdpr_consent_lang ADD CONSTRAINT FK_9C2246C9BEB78BEF FOREIGN KEY (id_gdpr_consent) REFERENCES ps_psgdpr_consent (id_gdpr_consent);
ALTER TABLE ps_psgdpr_consent_lang ADD CONSTRAINT FK_9C2246C9BA299860 FOREIGN KEY (id_lang) REFERENCES ps_lang (id_lang) ON DELETE CASCADE;
CREATE INDEX IDX_9C2246C9BEB78BEF ON ps_psgdpr_consent_lang (id_gdpr_consent);
CREATE INDEX IDX_9C2246C9BA299860 ON ps_psgdpr_consent_lang (id_lang);
# Bug in psgdpr : id_shop must be included
ALTER TABLE ps_psgdpr_consent_lang ADD PRIMARY KEY (id_gdpr_consent, id_lang);

The last line is incorrect. The table ps_psgdpr_consent_lang contains a column id_shop that must be part of the primary key. The SQL command will fail, with an error duplicate key, because there is a line for each shop in the table.

Expected behavior

php bin/console doctrine:schema:update --dump-sql should produce valid output. This means, it must be ALTER TABLE ps_psgdpr_consent_lang ADD PRIMARY KEY (id_gdpr_consent, id_lang, id_shop); instead of ALTER TABLE ps_psgdpr_consent_lang ADD PRIMARY KEY (id_gdpr_consent, id_lang);

Steps to reproduce

1. Install Prestashop, enable multishop and configure at least 2 shops
2. Install the module psgdpr at version 1.4.3
3. Look at the table PREFIX_psgdpr_consent_lang, it has a primary key (id_gdpr_consent, id_lang, id_shop). You can also look at the file modules/psgdpr/sql/install/psgdpr_consent_lang.sql both for psgdpr 1.4.3 and psgdpr 2.0.1 and find this same definition
4. Update psgdpr to version 2.0.1
5. On the command line run php bin/console doctrine:schema:update --dump-sql and observe the output. It will contain a primary key (id_gdpr_consent, id_lang) with id_shop absent.

PrestaShop version(s) where the bug happened

8.1.4

PHP version(s) where the bug happened

8.0 / 8.1

If your bug is related to a module, specify its name and its version

psgdpr 2.0.1

Your company or customer's name goes here (if applicable).

Société Biblique de Genève