Salary Market

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');