/*1*/ INSERT INTO `permission` (`id`, `nazov`) VALUES (120, 'obchodny_partner_sluzba_all');
/*2*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (3, 120);
/*3*/ DELETE FROM `role_permission` WHERE  `role_id`=3 AND `permission_id`=120;
/*4*/ INSERT INTO `permission` (`id`, `nazov`) VALUES (121, 'osoba_view');
/*5*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (3, 121);
/*6*/ DELETE FROM `role_permission` WHERE  `role_id`=3 AND `permission_id`=101;
/*7*/ INSERT INTO `permission` (`id`, `nazov`) VALUES (122, 'sluzba_view');
/*8*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (3, 122);
/*9*/ INSERT INTO `permission` (`id`, `nazov`) VALUES (123, 'subor_all');
/*10*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (2, 123);
/*11*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (3, 123);
/*12*/ INSERT INTO `permission` (`id`, `nazov`) VALUES (124, 'kalendar_udalost_uloha_all');
/*13*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (2, 124);
/*14*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (3, 124);
/*15*/ INSERT INTO `permission` (`id`, `nazov`) VALUES (125, 'foto_all');
/*16*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (3, 125);
/*17*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (2, 125);
/*18*/ UPDATE `permission` SET `nazov`='vzorova_smernica_view' WHERE  `id`=111;
/*19*/ UPDATE `permission` SET `nazov`='vzorovy_dokument_view' WHERE  `id`=110;
/*20*/ INSERT INTO `role` (`id`, `nazov`, `code`) VALUES (4, 'Správca dokumentácie', 'spravca_dokumentacie');
/*22*/ CREATE ALGORITHM = UNDEFINED VIEW `role_permission_view` AS SELECT role.nazov AS role_nazov, permission.nazov AS permission_nazov FROM role JOIN role_permission on role_permission.role_id = role.id JOIN permission ON permission.id = role_permission.permission_id ;
/*23*/ ALTER ALGORITHM = UNDEFINED VIEW `role_permission_view` AS SELECT role.nazov AS role_nazov, permission.nazov AS permission_nazov, permission.id AS permission_id FROM role JOIN role_permission on role_permission.role_id = role.id JOIN permission ON permission.id = role_permission.permission_id  ;
/*24*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (4, 105);
/*25*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (4, 108);
/*26*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (4, 109);
/*27*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (4, 5);
/*28*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (4, 116);
/*29*/ UPDATE `role_permission` SET `permission_id`=115 WHERE  `role_id`=4 AND `permission_id`=5;
/*30*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (4, 117);
/*31*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (4, 118);
/*32*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (4, 119);
/*33*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (4, 123);
/*34*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (4, 124);
/*35*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (4, 125);
/*36*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (4, 107);
/*37*/ INSERT INTO `permission` (`id`, `nazov`) VALUES (126, 'vzorovy_dokument_all');
/*38*/ INSERT INTO `permission` (`id`, `nazov`) VALUES (127, 'vzorova_smernica_all');
/*39*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (4, 126);
/*40*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (4, 127);
/*41*/ INSERT INTO `permission` (`id`, `nazov`) VALUES (128, 'vzorova_smernica_dokument_network_all');
/*42*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (3, 128);
/*43*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (4, 128);
/*44*/ INSERT INTO `permission` (`id`, `nazov`) VALUES (129, 'vzorova_smernica_stiahni_dokumenty_all');
/*45*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (3, 129);
/*46*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (4, 129);
/*47*/ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES (4, 106);