use salarymarket;
 ALTER TABLE salarymarket.company_reports
ADD COLUMN includeCompany boolean;
 ALTER TABLE salarymarket.company_reports
ADD COLUMN category ENUM('market', 'personalized', 'matricule') NOT NULL;

CREATE TABLE solution_reports_config_gaps (
  category ENUM('market', 'personalized', 'matricule') NOT NULL,
  subscription_code VARCHAR(255) NOT NULL,
  gap BOOLEAN NOT NULL,
  PRIMARY KEY (category, subscription_code),
  FOREIGN KEY (subscription_code) REFERENCES solution_subscription(subscription_code)
    ON DELETE NO ACTION
    ON UPDATE CASCADE
);

INSERT INTO solution_reports_config_gaps (subscription_code,category, gap)
VALUES 
('essential', 'market', false),

('advanced','market', false),
('advanced','personalized ', true),
('advanced','matricule', true),

('on_the_menu','market', false),
('on_the_menu','personalized', true),
('on_the_menu','matricule', true);

