use salarymarket;
INSERT INTO solution_subscription_menu (id, subscriptionCode, menuCode) VALUES
  (1, 'on_The_menu', 'home'),
  (2, 'on_The_menu', 'home_indicators'),
  (3, 'on_The_menu', 'home_indicateurs_number_of_employees'),
  (4, 'on_The_menu', 'home_indicateurs_payroll'),
  (5, 'on_The_menu', 'home_indicateurs_average_salaries_by_career_path'),
  (6, 'on_The_menu', 'home_indicateurs_supervision_rate'),
  (7, 'on_The_menu', 'company_compensation'),
  (8, 'on_The_menu', 'company_quiz'),
  (9, 'on_The_menu', 'quiz_sector'),
  (10, 'on_The_menu', 'quiz_market'),
  (11, 'on_The_menu', 'report'),
  (12, 'on_The_menu', 'myCompany'),
  (13, 'on_The_menu', 'myCompany_informations'),
  (14, 'on_The_menu', 'myCompany_users'),
  (15, 'on_The_menu', 'myCompany_entities'),
  (16, 'on_The_menu', 'myCompany_profiles'),
  (17, 'on_The_menu', 'myCompany_configuration'),
  (18, 'on_The_menu', 'myCompany_settings'),
  (19, 'on_The_menu', 'myCompany_settings_language');
  
  -- rights according for this Type
  INSERT INTO solution_subscription_menu_rights (id, subscriptionCode, menuCode, solution_menu_rights_code) VALUES
-- on the menu 
-- Compensation
(1, 'on_The_menu','company_compensation','compensation_import'), 
(2, 'on_The_menu','company_compensation','compensation_search'),
(3, 'on_The_menu','company_compensation','compensation_export'),
(4, 'on_The_menu','company_compensation','compensation_export'),
(5, 'on_The_menu','company_compensation','compensation_delete'),
(6, 'on_The_menu','company_compensation','compensation_delete'),
-- quiz
(7, 'on_The_menu','company_quiz', 'quiz_View'),
-- report 
(8,'on_The_menu','report','report_create'),
(9,'on_The_menu','report','report_View'),
(10,'on_The_menu','report','report_update'),
(11,'on_The_menu','report','report_delete'),
(12,'on_The_menu','report','report_upload'),
-- Informations
(13, 'on_The_menu','myCompany_informations', 'company_Informations_update'), 
-- Users
(14,'on_The_menu','myCompany_users', 'company_user_create'),
(15,'on_The_menu','myCompany_users', 'company_user_update'),
(16,'on_The_menu','myCompany_users', 'company_user_delete'), 
(17,'on_The_menu','myCompany_users', 'company_user_desactivate'),
(18,'on_The_menu','myCompany_users', 'company_user_activate'),
(19,'on_The_menu','myCompany_users', 'company_user_activity'),
-- entities
(20,'on_The_menu','myCompany_entities','company_entites_Create'), 
(21,'on_The_menu','myCompany_entities','company_entites_update'),  
(22,'on_The_menu','myCompany_entities','company_entites_delete'), 
-- profiles
(23,'on_The_menu','myCompany_profiles','company_profil_Create'),  
(24,'on_The_menu','myCompany_profiles','company_profil_update'),  
(25,'on_The_menu','myCompany_profiles','company_profil_delete'),  
-- languages
(26, 'on_The_menu','myCompany_settings_language', 'company_language_activate');