use salarymarket ;
INSERT INTO solution_subscription_menu (subscriptionCode, menuCode) VALUES

  ('on_The_menu', 'home'),
  ('on_The_menu', 'home_indicators'),
  ('on_The_menu', 'home_indicateurs_number_of_employees'),
  ('on_The_menu', 'home_indicateurs_payroll'),
  ('on_The_menu', 'home_indicateurs_average_salaries_by_career_path'),
  ('on_The_menu', 'home_indicateurs_supervision_rate'),
  ('on_The_menu', 'company_compensation'),
  ('on_The_menu', 'company_quiz'),
  ('on_The_menu', 'quiz_sector'),
  ('on_The_menu', 'quiz_market'),
  ('on_The_menu', 'report'),
  ('on_The_menu', 'myCompany'),
  ('on_The_menu', 'myCompany_informations'),
  ('on_The_menu', 'myCompany_users'),
  ('on_The_menu', 'myCompany_entities'),
  ('on_The_menu', 'myCompany_profiles'),
  ('on_The_menu', 'myCompany_configuration'),
  ('on_The_menu', 'myCompany_settings'),
  ('on_The_menu', 'myCompany_settings_language');
  
  
  
INSERT INTO solution_subscription_menu_rights (subscriptionCode, menuCode, solution_menu_rights_code) VALUES
-- on the menu 
-- Compensation
('on_The_menu','company_compensation','compensation_import'), 
('on_The_menu','company_compensation','compensation_search'),
('on_The_menu','company_compensation','compensation_export'),
('on_The_menu','company_compensation','compensation_create'),
('on_The_menu','company_compensation','compensation_delete'),
('on_The_menu','company_compensation','compensation_update'),
('on_The_menu','company_compensation','compensation_view'),
                
-- quiz
( 'on_The_menu','company_quiz', 'quiz_View'),
-- report 
('on_The_menu','report','report_create'),
('on_The_menu','report','report_View'),
('on_The_menu','report','report_update'),
('on_The_menu','report','report_delete'),
('on_The_menu','report','report_upload'),
-- Informations
('on_The_menu','myCompany_informations', 'company_Informations_update'), 
-- Users
('on_The_menu','myCompany_users', 'company_user_create'),
('on_The_menu','myCompany_users', 'company_user_update'),
('on_The_menu','myCompany_users', 'company_user_delete'), 
('on_The_menu','myCompany_users', 'company_user_desactivate'),
('on_The_menu','myCompany_users', 'company_user_activity'),
-- entities
('on_The_menu','myCompany_entities','company_entites_Create'), 
('on_The_menu','myCompany_entities','company_entites_update'),  
('on_The_menu','myCompany_entities','company_entites_delete'), 
-- profiles
('on_The_menu','myCompany_profiles','company_profil_Create'),  
('on_The_menu','myCompany_profiles','company_profil_update'),  
('on_The_menu','myCompany_profiles','company_profil_delete'),  
-- languages
( 'on_The_menu','myCompany_settings_language', 'company_language_activate');