/*3*/ INSERT INTO `typ_ulohy` (`id`, `visibility_type`, `nazov`, `kratky_nazov`) VALUES (4, 1, 'Oboznamovanie / školenie', 'Š');
/*4*/ INSERT INTO `typ_ulohy` (`id`, `visibility_type`, `nazov`, `kratky_nazov`) VALUES (5, 1, 'Úloha z porady vedenia / oddelenia', 'P');
/*5*/ INSERT INTO `typ_ulohy` (`id`, `visibility_type`, `nazov`, `kratky_nazov`) VALUES (6, 1, 'Úloha z kontroly technika u zákazníka', 'Z');
/*6*/ INSERT INTO `typ_ulohy` (`id`, `visibility_type`, `nazov`, `kratky_nazov`) VALUES (7, 1, 'Úloha z auditu', 'AU');
/*7*/ INSERT INTO `typ_ulohy` (`id`, `visibility_type`, `nazov`, `kratky_nazov`) VALUES (8, 1, 'Iné / ďalšie úlohy', 'I');
/*8*/ INSERT INTO `typ_ulohy` (`id`, `visibility_type`, `nazov`, `kratky_nazov`) VALUES (9, 1, 'PPP (preventívnu protipožiarnu prehliadku)', 'PPP');
/*9*/ INSERT INTO `typ_ulohy` (`id`, `visibility_type`, `nazov`, `kratky_nazov`) VALUES (10, 1, 'previerku BOZP', 'BOZP');
/*10*/ INSERT INTO `typ_ulohy` (`id`, `visibility_type`, `nazov`, `kratky_nazov`) VALUES (11, 1, 'Revízia – odborná prehliadka / odborná skúška', 'R');
/*11*/ INSERT INTO `typ_ulohy` (`id`, `visibility_type`, `nazov`, `kratky_nazov`) VALUES (12, 1, 'Alko test – dychová skúška na alkohol', 'AL');
/*12*/ INSERT INTO `typ_ulohy` (`id`, `visibility_type`, `nazov`, `kratky_nazov`) VALUES (13, 1, 'Kontrola regálov', 'KR');
/*13*/ INSERT INTO `typ_ulohy` (`id`, `visibility_type`, `nazov`, `kratky_nazov`) VALUES (14, 1, 'Kontrola rebríkov', 'KRB');
/*14*/ UPDATE `typ_ulohy` SET `kratky_nazov`='KRG' WHERE  `id`=13;
/*15*/ INSERT INTO `typ_ulohy` (`id`, `visibility_type`, `nazov`, `kratky_nazov`) VALUES (15, 1, 'Audit – interný, externý', 'AUD');
/*16*/ UPDATE `typ_ulohy` SET `kratky_nazov`='ALK' WHERE  `id`=12;
/*17*/ UPDATE `typ_ulohy` SET `kratky_nazov`='REV' WHERE  `id`=11;
/*18*/ UPDATE `typ_ulohy` SET `kratky_nazov`='INE' WHERE  `id`=8;
/*19*/ UPDATE `typ_ulohy` SET `kratky_nazov`='UAU' WHERE  `id`=7;
/*20*/ UPDATE `typ_ulohy` SET `kratky_nazov`='UZK' WHERE  `id`=6;
/*21*/ UPDATE `typ_ulohy` SET `kratky_nazov`='UPO' WHERE  `id`=5;
/*22*/ UPDATE `typ_ulohy` SET `kratky_nazov`='UKO' WHERE  `id`=6;
/*23*/ UPDATE `typ_ulohy` SET `kratky_nazov`='ŠKO' WHERE  `id`=4;
/*24*/ UPDATE `typ_ulohy` SET `kratky_nazov`='ANA' WHERE  `id`=3;
/*25*/ UPDATE `typ_ulohy` SET `kratky_nazov`='CPO' WHERE  `id`=2;
/*26*/ UPDATE `typ_ulohy` SET `kratky_nazov`='DOK' WHERE  `id`=1;
/*27*/ INSERT INTO `typ_ulohy` (`id`, `visibility_type`, `nazov`, `kratky_nazov`) VALUES (16, 1, 'Kontrola zariadenia', 'KZA');
/*28*/ UPDATE `typ_ulohy` SET `kratky_nazov`='BOZ' WHERE  `id`=10;
/*29*/ UPDATE `typ_ulohy` SET `nazov`='Previerka BOZP' WHERE  `id`=10;
/*30*/ UPDATE `typ_kalendar_udalost` SET `nazov`='Oboznamovanie / školenie' WHERE  `id`=1;
/*31*/ UPDATE `typ_kalendar_udalost` SET `nazov`='PPP (preventívna protipožiarna prehliadka)', `code`='ppp' WHERE  `id`=2;
/*32*/ INSERT INTO `typ_kalendar_udalost` (`id`, `nazov`, `code`) VALUES (3, 'Previerka BOZP', 'bozp');
/*33*/ INSERT INTO `typ_kalendar_udalost` (`id`, `nazov`, `code`) VALUES (4, 'Revízia - odborná prehliadka / odborná skúška', 'revizia');
/*34*/ INSERT INTO `typ_kalendar_udalost` (`id`, `nazov`, `code`) VALUES (5, 'Alko test - dychová skúška na alkohol', 'alko');
/*35*/ INSERT INTO `typ_kalendar_udalost` (`id`, `nazov`, `code`) VALUES (6, 'Kontrola regálov', 'regal');
/*36*/ INSERT INTO `typ_kalendar_udalost` (`id`, `nazov`, `code`) VALUES (7, 'Kontrola rebríkov', 'rebrik');
/*37*/ INSERT INTO `typ_kalendar_udalost` (`id`, `nazov`, `code`) VALUES (8, 'Audit – interný, externý', 'audit');
/*38*/ INSERT INTO `typ_kalendar_udalost` (`id`, `nazov`, `code`) VALUES (9, 'Kontrola zariadenia', 'zariadenie');

/*1*/ ALTER TABLE `typ_ulohy`
	ADD COLUMN `typ_kalendar_udalost_id` INT(11) UNSIGNED NULL DEFAULT NULL AFTER `kratky_nazov`;
/*2*/ UPDATE `typ_ulohy` SET `typ_kalendar_udalost_id`=1 WHERE  `id`=4;
/*3*/ UPDATE `typ_ulohy` SET `typ_kalendar_udalost_id`=2 WHERE  `id`=9;
/*4*/ UPDATE `typ_ulohy` SET `typ_kalendar_udalost_id`=3 WHERE  `id`=10;
/*5*/ UPDATE `typ_ulohy` SET `typ_kalendar_udalost_id`=4 WHERE  `id`=11;
/*6*/ UPDATE `typ_ulohy` SET `typ_kalendar_udalost_id`=5 WHERE  `id`=12;
/*7*/ UPDATE `typ_ulohy` SET `typ_kalendar_udalost_id`=6 WHERE  `id`=13;
/*8*/ UPDATE `typ_ulohy` SET `typ_kalendar_udalost_id`=7 WHERE  `id`=14;
/*9*/ UPDATE `typ_ulohy` SET `typ_kalendar_udalost_id`=8 WHERE  `id`=15;
/*10*/ UPDATE `typ_ulohy` SET `typ_kalendar_udalost_id`=9 WHERE  `id`=16;