/* 13:35:02 gmspider gmspider */ INSERT INTO `typ_kalendar_udalost` (`id`, `nazov`, `code`, `kratky_nazov`) VALUES ('14', 'Dovolenka', 'dovolenka', 'DOV');
/* 13:35:15 gmspider gmspider */ INSERT INTO `typ_kalendar_udalost` (`id`, `nazov`, `code`, `kratky_nazov`) VALUES ('15', 'Priepustka', 'priepustka', 'PRI');

/* 13:53:18 gmspider gmspider */ ALTER TABLE `typ_majetku` ADD `poradie` INT(10)  NULL  DEFAULT NULL  AFTER `code`;
/* 13:53:21 gmspider gmspider */ UPDATE `typ_majetku` SET `poradie` = '10' WHERE `id` = '1';
/* 13:53:23 gmspider gmspider */ UPDATE `typ_majetku` SET `poradie` = '20' WHERE `id` = '2';
/* 13:53:24 gmspider gmspider */ UPDATE `typ_majetku` SET `poradie` = '30' WHERE `id` = '3';
/* 13:53:26 gmspider gmspider */ UPDATE `typ_majetku` SET `poradie` = '40' WHERE `id` = '4';
/* 13:53:28 gmspider gmspider */ UPDATE `typ_majetku` SET `poradie` = '50' WHERE `id` = '5';
/* 13:53:36 gmspider gmspider */ UPDATE `typ_majetku` SET `poradie` = '30' WHERE `id` = '7';
/* 13:53:38 gmspider gmspider */ UPDATE `typ_majetku` SET `poradie` = '40' WHERE `id` = '6';

UPDATE osoba SET nazov = CONCAT(priezvisko,' ',meno);

/* 09:58:46 gmspider gmspider */ UPDATE `typ_majetku` SET `poradie` = '30' WHERE `id` = '6';
/* 09:58:48 gmspider gmspider */ UPDATE `typ_majetku` SET `poradie` = '40' WHERE `id` = '7';
/* 09:58:54 gmspider gmspider */ UPDATE `typ_majetku` SET `nazov` = 'Rok' WHERE `id` = '6';
/* 09:58:58 gmspider gmspider */ UPDATE `typ_majetku` SET `nazov` = 'Druh VTZ', `code` = '' WHERE `id` = '7';
/* 09:59:00 gmspider gmspider */ UPDATE `typ_majetku` SET `code` = 'rok' WHERE `id` = '6';
/* 09:59:01 gmspider gmspider */ UPDATE `typ_majetku` SET `code` = 'druh_vtz' WHERE `id` = '7';

INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`)
VALUES
    (214, 36001, 'Hromadné pridanie záznamov', 'majetok_zaznam_hromadne', NULL, 3, 0);
