use socle ;

CREATE TABLE company_reports_authorization (
id INT AUTO_INCREMENT PRIMARY KEY,
report_generated INT NOT NULL,
report_authorized VARCHAR(255) NOT 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);