Salary Market

1. Refonte modèle BDD

CREATE TABLE company_reports (
id INT AUTO_INCREMENT PRIMARY KEY,
label VARCHAR NOT NULL,
date DATETIME NULL,
description TEXT,
fileId INT NULL,
companyId INT NOT NULL,
createdAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updatedAt TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
FOREIGN KEY (companyId) REFERENCES company(id) ON DELETE CASCADE ON UPDATE CASCADE
ADD FOREIGN KEY (fileId ) REFERENCES company_files(id) ON DELETE CASCADE ON UPDATE CASCADE TOADD
);
-- Alter company_files table
ALTER TABLE company_files TODELETE
ADD COLUMN reportId INT NULL; TODELETE

2. affichage de la date selon langue