use socle;
CREATE TABLE IF NOT EXISTS company_reports_files (
    report_id INT NOT NULL,
    files_id INT NOT NULL,
    PRIMARY KEY (report_id, files_id),
    FOREIGN KEY (report_id) REFERENCES company_reports(id) ON DELETE CASCADE ON UPDATE CASCADE,
    FOREIGN KEY (files_id) REFERENCES company_files(id) ON DELETE CASCADE ON UPDATE CASCADE
);