use salarymarket ;
INSERT INTO solution_subscription_menu (subscriptionCode, menuCode) VALUES
('essential', 'report'), -- Menu: report
('essential', 'myCompany'), -- Menu: Company
('essential', 'myCompany_informations'), -- SubMenu: Informations
('essential', 'myCompany_users'), -- SubMenu: Users
('essential', 'myCompany_entities'), -- SubMenu: Entities
('essential', 'myCompany_profiles'), -- SubMenu: Profiles
('essential', 'myCompany_configuration'), -- SubMenu: Configuration
('essential', 'myCompany_settings'), -- SubMenu: Settings
('essential', 'myCompany_settings_language'); -- SubMenu: Language
INSERT INTO solution_subscription_menu_rights
 (subscriptionCode, menuCode, solution_menu_rights_code) VALUES
 -- Essential 
-- report
('essential','report', 'report_create'), 
('essential','report', 'report_View'), 
('essential','report', 'report_delete'), 
('essential','report', 'report_upload'),
-- Informations
('essential','myCompany_informations', 'company_Informations_update'), 
-- Users
('essential','myCompany_users', 'company_user_create'),
('essential','myCompany_users', 'company_user_update'),
('essential','myCompany_users', 'company_user_delete'), 
('essential','myCompany_users', 'company_user_desactivate'),
('essential','myCompany_users', 'company_user_activity'), 
-- entities
('essential','myCompany_entities','company_entity_create'), 
('essential','myCompany_entities','company_entity_update'),  
('essential','myCompany_entities','company_entity_delete'), 
-- profiles
('essential','myCompany_profiles','company_profil_Create'),  
('essential','myCompany_profiles','company_profil_update'),  
('essential','myCompany_profiles','company_profil_delete'),  
-- languages
('essential','myCompany_settings_language', 'company_language_activate');