use salarymarket ;
INSERT INTO solution_subscription_menu (subscriptionCode, menuCode) VALUES
('on_the_menu', 'home'), -- Menu: home
('on_the_menu', 'home_indicators'), -- SubMenu: Indicators
('on_the_menu', 'home_indicateurs_number_of_employees'), -- Widget: Number of employees
('on_the_menu', 'home_indicateurs_employees_per_gender'), -- Widget: Number of employees
('on_the_menu', 'home_indicateurs_payroll'), -- Widget: Payroll
('on_the_menu', 'home_indicateurs_median_salaries_by_career_path'), -- Widget: Average salaries by career path
('on_the_menu', 'home_indicateurs_supervision_rate'), -- Widget: Management rate
('on_the_menu', 'home_indicateurs_median_salaries_by_grade'), -- Widget:median salaries by grade
('on_the_menu', 'company_compensation'), -- Menu: Compensation
('on_the_menu', 'company_quiz'), -- Menu: HR Policy and Practices
('on_the_menu', 'quiz_current_sector'), -- Option: HRPP by Sector     
('on_the_menu', 'quiz_market'), -- Option: Quiz by Market
('on_the_menu', 'report'), -- Menu: Reports
('on_the_menu', 'myCompany'), -- Menu: Company
('on_the_menu', 'myCompany_informations'), -- SubMenu: Informations
('on_the_menu', 'myCompany_users'), -- SubMenu: Users
('on_the_menu', 'myCompany_entities'), -- SubMenu: Entities
('on_the_menu', 'myCompany_profiles'), -- SubMenu: Profiles
('on_the_menu', 'myCompany_configuration'), -- SubMenu: Configuration
('on_the_menu', 'myCompany_settings'), -- SubMenu: Settings
('on_the_menu', 'myCompany_settings_language'); -- SubMenu: Language
  
  
INSERT INTO solution_subscription_menu_rights (subscriptionCode, menuCode, solution_menu_rights_code) VALUES
-- on the menu 
-- Compensation
('on_the_menu','company_compensation','compensation_search'),
('on_the_menu','company_compensation','compensation_configuration'),
('on_the_menu','company_compensation','compensation_import'), 
('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_Submit'),  
('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_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_entity_create'), 
('on_the_menu','myCompany_entities','company_entity_update'),  
('on_the_menu','myCompany_entities','company_entity_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');