/* 10:36:06 gmspider gmspider */ SET FOREIGN_KEY_CHECKS = 0;

/* 17:15:36 gmspider gmspider */ INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES ('36008', '36000', 'Graf majetku', 'majetok_network', NULL, '2', NULL);
/* 17:16:36 gmspider gmspider */ UPDATE `menu` SET `visibility_type` = '1' WHERE `id` = '36008';
/* 17:16:55 gmspider gmspider */ UPDATE `menu` SET `poradie` = '20' WHERE `id` = '36008';
/* 17:17:17 gmspider gmspider */ UPDATE `menu` SET `poradie` = NULL, `visibility_type` = NULL WHERE `id` = '36008';
/* 17:18:11 gmspider gmspider */ UPDATE `menu` SET `nazov` = 'Súbory k majetku' WHERE `id` = '36006';
/* 17:21:17 gmspider gmspider */ INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES ('138', '36000', 'Záznamy', 'majetok_dokument_vypis', '30', '2', '1');
/* 17:21:53 gmspider gmspider */ UPDATE `menu` SET `page` = 'dokument_majetok_vypis' WHERE `id` = '138';
/* 21:14:29 gmspider gmspider */ INSERT INTO `rozsireny_typ_suboru` (`id`, `nazov`, `code`) VALUES ('4', 'Záznam', 'zaznam');
/* 22:12:44 gmspider gmspider */ UPDATE `uloha` SET `stav_ulohy_id` = '1' WHERE `id` = '37';
/* 22:14:37 gmspider gmspider */ UPDATE `uloha` SET `stav_ulohy_id` = '0' WHERE `id` = '37';
/* 22:14:40 gmspider gmspider */ UPDATE `uloha` SET `stav_ulohy_id` = '1' WHERE `id` = '37';
/* 00:05:46 gmspider gmspider */ ALTER TABLE `dokument` ADD `obchodny_partner_id` INT(11)  UNSIGNED  NULL  DEFAULT NULL  AFTER `dokument_id`;
/* 09:00:50 gmspider gmspider */ UPDATE `menu` SET `page` = 'smernica_dokument_view' WHERE `id` = '125';
/* 09:00:58 gmspider gmspider */ UPDATE `menu` SET `page` = 'dokument_smernica_view' WHERE `id` = '125';
/* 09:01:25 gmspider gmspider */ INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES ('139', '117', 'Detail dokumentu', 'dokument_view', NULL, '3', NULL);
/* 09:01:50 gmspider gmspider */ UPDATE `menu` SET `poradie` = '10', `visibility_type` = '3' WHERE `id` = '139';
/* 09:02:01 gmspider gmspider */ UPDATE `menu` SET `menu_id` = '119' WHERE `id` = '139';
/* 09:02:55 gmspider gmspider */ UPDATE `menu` SET `menu_id` = '118' WHERE `id` = '139';
/* 09:03:45 gmspider gmspider */ UPDATE `menu` SET `page` = 'dokument_majetok_view' WHERE `id` = '139';
/* 09:04:40 gmspider gmspider */ UPDATE `menu` SET `menu_id` = '138' WHERE `id` = '139';
/* 09:05:51 gmspider gmspider */ UPDATE `menu` SET `page` = 'dokument_smernica_vypis' WHERE `id` = '118';
/* 09:14:10 gmspider gmspider */ INSERT INTO `form_element` (`id`, `form_group_id`, `form_element_type_id`, `db_table`, `db_column`, `db_multi_table`, `db_multivalue_table`, `column_title`, `position`, `attribute`, `width`, `height`, `help`, `example`, `direct_to_db`, `required`, `number`, `float_number`, `email`, `css_style`, `css_class`, `javascript`, `direct_multi_label`, `direct_multi_data`, `default_val`, `vdaemon`, `add_empty_option`, `html`, `lang_code`, `read_only`) VALUES ('39', '35000', '5', 'dokument', 'obchodny_partner_id', 'obchodny_partner', NULL, 'Obchodný partner', NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, 'select2', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
/* 09:14:21 gmspider gmspider */ UPDATE `form_element` SET `direct_multi_label` = '1', `add_empty_option` = '1' WHERE `id` = '39';
/* 09:14:50 gmspider gmspider */ UPDATE `uloha` SET `stav_ulohy_id` = '1' WHERE `id` = '38';
/* 09:27:10 gmspider gmspider */ INSERT INTO `form_element` (`id`, `form_group_id`, `form_element_type_id`, `db_table`, `db_column`, `db_multi_table`, `db_multivalue_table`, `column_title`, `position`, `attribute`, `width`, `height`, `help`, `example`, `direct_to_db`, `required`, `number`, `float_number`, `email`, `css_style`, `css_class`, `javascript`, `direct_multi_label`, `direct_multi_data`, `default_val`, `vdaemon`, `add_empty_option`, `html`, `lang_code`, `read_only`) VALUES ('40', '35000', '5', 'dokument', 'majetok_id', 'majetok', NULL, 'Majetok', NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, 'select2', NULL, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL);
/* 09:27:17 gmspider gmspider */ UPDATE `form_element` SET `form_element_type_id` = '9' WHERE `id` = '40';
/* 09:27:36 gmspider gmspider */ UPDATE `form_element` SET `position` = '90' WHERE `id` = '40';
/* 10:11:34 gmspider gmspider */ UPDATE `menu` SET `menu_id` = '36001' WHERE `id` = '139';
/* 10:18:58 gmspider gmspider */ UPDATE `menu` SET `page` = 'majetok_dokument_view', `poradie` = NULL WHERE `id` = '139';
/* 10:19:31 gmspider gmspider */ INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES ('140', '138', 'Detail dokumentu', 'dokument_majetok_view', NULL, '3', '3');
/* 10:20:43 gmspider gmspider */ UPDATE `form_element` SET `position` = '80' WHERE `id` = '39';
/* 10:31:11 gmspider gmspider */ ALTER TABLE `uloha` ADD `perioda_opakovania` INT(11)  UNSIGNED  NULL  DEFAULT NULL  AFTER `obchodny_partner_id`;
/* 10:31:18 gmspider gmspider */ ALTER TABLE `uloha` CHANGE `perioda_opakovania` `perioda_opakovania` INT(11)  UNSIGNED  NULL  DEFAULT NULL  COMMENT 'denne, týždenne, mesačne, ročne';
/* 10:31:19 gmspider gmspider */ ALTER TABLE `uloha` CHANGE `perioda_opakovania` `perioda_opakovania_id` INT(11)  UNSIGNED  NULL  DEFAULT NULL  COMMENT 'denne, týždenne, mesačne, ročne';
/* 10:31:36 gmspider gmspider */ ALTER TABLE `uloha` ADD `interval_opakovania` INT(11)  UNSIGNED  NULL  DEFAULT NULL  COMMENT 'každý 2. deň, každý 1. mesiac'  AFTER `perioda_opakovania_id`;
/* 10:31:58 gmspider gmspider */ ALTER TABLE `uloha` ADD `dev_v_periode` INT(11)  UNSIGNED  NULL  DEFAULT NULL  COMMENT '15. deň v mesiaci'  AFTER `interval_opakovania`;
/* 10:32:25 gmspider gmspider */ ALTER TABLE `uloha` ADD `pocet_opakovania` INT(11)  UNSIGNED  NOT NULL  COMMENT 'opakovať 10x'  AFTER `dev_v_periode`;
/* 10:32:43 gmspider gmspider */ ALTER TABLE `uloha` ADD `datum_platnosti_od` DATE  NULL  AFTER `pocet_opakovania`;
/* 10:32:52 gmspider gmspider */ ALTER TABLE `uloha` ADD `datum_platnosti_di` DATE  NULL  AFTER `datum_platnosti_od`;
/* 10:32:56 gmspider gmspider */ ALTER TABLE `uloha` CHANGE `datum_platnosti_di` `datum_platnosti_do` DATE  NULL  DEFAULT NULL;
/* 10:33:14 gmspider gmspider */ ALTER TABLE `uloha` ADD `mesiac_id` INT(11)  UNSIGNED  NULL  DEFAULT NULL  AFTER `datum_platnosti_do`;
/* 10:33:22 gmspider gmspider */ ALTER TABLE `uloha` CHANGE `mesiac_id` `mesiac_id` INT(11)  UNSIGNED  NULL  DEFAULT NULL  COMMENT 'pri ročnom opakovaní';
/* 10:33:38 gmspider gmspider */ DROP TABLE `uloha_opakovanie`;
/* 10:33:44 gmspider gmspider */ ALTER TABLE `uloha_opakovanie_den` CHANGE `uloha_opakovanie_id` `uloha_id` INT(11)  NOT NULL;
/* 10:33:47 gmspider gmspider */ /*!50003 SHOW TRIGGERS WHERE `Table` = 'uloha_opakovanie_den' */;
/* 10:33:57 gmspider gmspider */ RENAME TABLE `uloha_opakovanie_den` TO `uloha_den`;
/* 10:35:29 gmspider gmspider */ DELETE FROM `menu` WHERE `id` IN ('33100','33101','33102','33103');
/* 10:36:15 gmspider gmspider */ DELETE FROM `log_type` WHERE `id` IN ('33101','33100','33102');
/* 10:38:49 gmspider gmspider */ UPDATE `form_group` SET `position` = '30' WHERE `id` = '37002';
/* 10:38:52 gmspider gmspider */ UPDATE `form_group` SET `position` = '30' WHERE `id` = '37001';
/* 10:38:53 gmspider gmspider */ UPDATE `form_group` SET `position` = '20' WHERE `id` = '37002';
/* 10:39:24 gmspider gmspider */ UPDATE `form_group` SET `code` = 'uloha_opakovanie' WHERE `id` = '33100';
/* 10:39:36 gmspider gmspider */ UPDATE `form_group` SET `code` = 'uloha_opakovanie_rozsah_opakovania' WHERE `id` = '33101';
/* 10:39:40 gmspider gmspider */ UPDATE `form_group` SET `position` = '30' WHERE `id` = '33101';
/* 10:39:49 gmspider gmspider */ UPDATE `form_group` SET `code` = 'uloha_opakovanie_sposob_opakovania' WHERE `id` = '33100';
/* 10:39:55 gmspider gmspider */ UPDATE `form_group` SET `form_id` = '330' WHERE `id` = '33100';
/* 10:39:56 gmspider gmspider */ UPDATE `form_group` SET `form_id` = '330' WHERE `id` = '33101';
/* 10:40:30 gmspider gmspider */ DELETE FROM `form_element` WHERE `id` IN ('33100');
/* 10:40:32 gmspider gmspider */ UPDATE `form_element` SET `db_table` = 'uloha' WHERE `id` = '33101';
/* 10:40:36 gmspider gmspider */ UPDATE `form_element` SET `db_table` = 'uloha' WHERE `id` = '33102';
/* 10:40:40 gmspider gmspider */ UPDATE `form_element` SET `db_table` = 'uloha' WHERE `id` = '33103';
/* 10:40:43 gmspider gmspider */ UPDATE `form_element` SET `db_table` = 'uloha' WHERE `id` = '33104';
/* 10:40:46 gmspider gmspider */ UPDATE `form_element` SET `db_table` = 'uloha' WHERE `id` = '33105';
/* 10:40:50 gmspider gmspider */ UPDATE `form_element` SET `db_table` = 'uloha' WHERE `id` = '33106';
/* 10:40:53 gmspider gmspider */ UPDATE `form_element` SET `db_table` = 'uloha' WHERE `id` = '33107';
/* 10:40:57 gmspider gmspider */ UPDATE `form_element` SET `db_table` = 'uloha' WHERE `id` = '33108';
/* 10:41:10 gmspider gmspider */ DELETE FROM `form` WHERE `id` IN ('331');
/* 10:42:50 gmspider gmspider */ UPDATE `form_group` SET `position` = '20' WHERE `id` = '33100';
/* 10:43:02 gmspider gmspider */ UPDATE `form_group` SET `position` = '50' WHERE `id` = '33002';
/* 10:43:03 gmspider gmspider */ UPDATE `form_group` SET `position` = '40' WHERE `id` = '33001';
/* 10:43:34 gmspider gmspider */ UPDATE `form_element` SET `css_class` = 'select2' WHERE `id` = '33101';
/* 10:44:49 gmspider gmspider */ UPDATE `form_element` SET `column_title` = 'Opakovať udalosť' WHERE `id` = '37015';
/* 10:45:05 gmspider gmspider */ ALTER TABLE `uloha` ADD `opakovanie` TINYINT(1)  NULL  DEFAULT NULL  AFTER `mesiac_id`;
/* 10:49:01 gmspider gmspider */ INSERT INTO `form_element` (`id`, `form_group_id`, `form_element_type_id`, `db_table`, `db_column`, `db_multi_table`, `db_multivalue_table`, `column_title`, `position`, `attribute`, `width`, `height`, `help`, `example`, `direct_to_db`, `required`, `number`, `float_number`, `email`, `css_style`, `css_class`, `javascript`, `direct_multi_label`, `direct_multi_data`, `default_val`, `vdaemon`, `add_empty_option`, `html`, `lang_code`, `read_only`) VALUES ('33013', '33000', '3', 'uloha', 'opakovanie', NULL, NULL, 'Opakovanie úlohy', '100', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
/* 10:55:35 gmspider gmspider */ UPDATE `form_group` SET `code` = 'uloha_sposob_opakovania' WHERE `id` = '33100';
/* 10:55:39 gmspider gmspider */ UPDATE `form_group` SET `code` = 'uloha_rozsah_opakovania' WHERE `id` = '33101';
/* 10:58:09 gmspider gmspider */ UPDATE `form_element` SET `css_class` = 'select2' WHERE `id` = '33108';
/* 10:58:42 gmspider gmspider */ ALTER TABLE `uloha` CHANGE `dev_v_periode` `den_v_periode` INT(11)  UNSIGNED  NULL  DEFAULT NULL  COMMENT '15. deň v mesiaci';
/* 10:58:52 gmspider gmspider */ ALTER TABLE `uloha` CHANGE `pocet_opakovania` `pocet_opakovi` INT(11)  UNSIGNED  NOT NULL  COMMENT 'opakovať 10x';
/* 10:58:56 gmspider gmspider */ ALTER TABLE `uloha` CHANGE `pocet_opakovi` `pocet_opakovani` INT(11)  UNSIGNED  NOT NULL  COMMENT 'opakovať 10x';
/* 11:00:08 gmspider gmspider */ ALTER TABLE `uloha` CHANGE `pocet_opakovani` `pocet_opakovani` INT(11)  UNSIGNED  NULL  COMMENT 'opakovať 10x';
/* 11:05:32 gmspider gmspider */ UPDATE `form_element` SET `number` = '1' WHERE `id` = '33104';
/* 11:10:09 gmspider gmspider */ ALTER TABLE `uloha` CHANGE `pocet_opakovani` `pocet_opakovani` INT(11)  NULL  DEFAULT NULL  COMMENT 'opakovať 10x';
/* 11:14:07 gmspider gmspider */ UPDATE `uloha` SET `pocet_opakovani` = NULL WHERE `id` = '59';
/* 11:15:57 gmspider gmspider */ UPDATE uloha SET pocet_opakovani = NULL WHERE id = 59;
/* 12:14:49 gmspider gmspider */ UPDATE `form_element` SET `required` = '1' WHERE `id` = '33010';
/* 12:55:00 gmspider gmspider */ INSERT INTO `sluzba` (`id`, `nazov`, `poradie`, `code`, `icon`, `modul_id`) VALUES ('11', NULL, NULL, NULL, NULL, '0');
/* 12:55:27 gmspider gmspider */ UPDATE `sluzba` SET `id` = '10', `nazov` = 'Životné prostredie', `poradie` = '10', `modul_id` = '5' WHERE `id` = '11';
/* 12:55:35 gmspider gmspider */ UPDATE `sluzba` SET `nazov` = 'GM Spider - Životné prostredie' WHERE `id` = '1';
/* 12:55:37 gmspider gmspider */ UPDATE `sluzba` SET `nazov` = 'GM Spider - Požiarna ochrana' WHERE `id` = '2';
/* 12:55:39 gmspider gmspider */ UPDATE `sluzba` SET `nazov` = 'GM Spider - Bezpečnosť a ochrana zdravia pri práci' WHERE `id` = '3';
/* 12:55:41 gmspider gmspider */ UPDATE `sluzba` SET `nazov` = 'GM Spider - Ochrana osobných údajov' WHERE `id` = '4';
/* 12:55:44 gmspider gmspider */ UPDATE `sluzba` SET `nazov` = 'GM Spider - Pracovná zdravotná služba' WHERE `id` = '5';
/* 12:55:46 gmspider gmspider */ UPDATE `sluzba` SET `nazov` = 'GM Spider - Vyhradené technické zariadenia' WHERE `id` = '6';
/* 12:56:01 gmspider gmspider */ INSERT INTO `sluzba` (`id`, `nazov`, `poradie`, `code`, `icon`, `modul_id`) VALUES ('11', 'Požiarna ochrana', '20', NULL, NULL, '5');
/* 12:56:33 gmspider gmspider */ INSERT INTO `sluzba` (`id`, `nazov`, `poradie`, `code`, `icon`, `modul_id`) VALUES ('12', 'Bezpečnosť a ochrana zdravia pri práci', '30', NULL, NULL, '5');
/* 12:56:41 gmspider gmspider */ INSERT INTO `sluzba` (`id`, `nazov`, `poradie`, `code`, `icon`, `modul_id`) VALUES ('13', 'Vyhradené technické zariadenia', '40', NULL, NULL, '5');
/* 12:56:53 gmspider gmspider */ INSERT INTO `sluzba` (`id`, `nazov`, `poradie`, `code`, `icon`, `modul_id`) VALUES ('14', 'Pracovná zdravotná služba', '60', NULL, NULL, '5');
/* 12:57:12 gmspider gmspider */ INSERT INTO `sluzba` (`id`, `nazov`, `poradie`, `code`, `icon`, `modul_id`) VALUES ('15', 'Ochrana osobných údajov', '50', NULL, NULL, '5');
/* 12:57:36 gmspider gmspider */ UPDATE `sluzba` SET `modul_id` = 'NULL' WHERE `id` = '10';
/* 12:57:51 gmspider gmspider */ ALTER TABLE `sluzba` CHANGE `modul_id` `modul_id` INT(11)  UNSIGNED  NULL;
/* 12:57:54 gmspider gmspider */ UPDATE `sluzba` SET `modul_id` = NULL WHERE `id` = '10';
/* 12:57:57 gmspider gmspider */ UPDATE `sluzba` SET `modul_id` = NULL WHERE `id` = '11';
/* 12:57:59 gmspider gmspider */ UPDATE `sluzba` SET `modul_id` = NULL WHERE `id` = '12';
/* 12:58:01 gmspider gmspider */ UPDATE `sluzba` SET `modul_id` = NULL WHERE `id` = '13';
/* 12:58:04 gmspider gmspider */ UPDATE `sluzba` SET `modul_id` = NULL WHERE `id` = '14';
/* 12:58:07 gmspider gmspider */ UPDATE `sluzba` SET `modul_id` = NULL WHERE `id` = '15';
/* 13:47:27 gmspider gmspider */ ALTER TABLE `sluzba` ADD `nazov_web` VARCHAR(255)  CHARACTER SET utf8  COLLATE utf8_general_ci  NULL  DEFAULT NULL  AFTER `modul_id`;
/* 13:47:30 gmspider gmspider */ ALTER TABLE `sluzba` MODIFY COLUMN `nazov_web` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL AFTER `nazov`;
/* 13:48:14 gmspider gmspider */ UPDATE sluzba SET nazov_web = nazov WHERE modul_id IS NOT NULL;
/* 13:48:22 gmspider gmspider */ UPDATE `sluzba` SET `nazov_web` = 'Životné prostredie' WHERE `id` = '1';
/* 13:48:25 gmspider gmspider */ UPDATE `sluzba` SET `nazov_web` = 'Požiarna ochrana' WHERE `id` = '2';
/* 13:48:28 gmspider gmspider */ UPDATE `sluzba` SET `nazov_web` = 'Bezpečnosť a ochrana zdravia pri práci' WHERE `id` = '3';
/* 13:48:31 gmspider gmspider */ UPDATE `sluzba` SET `nazov_web` = 'Ochrana osobných údajov' WHERE `id` = '4';
/* 13:48:37 gmspider gmspider */ UPDATE `sluzba` SET `nazov_web` = 'Pracovná zdravotná služba' WHERE `id` = '5';
/* 13:48:40 gmspider gmspider */ UPDATE `sluzba` SET `nazov_web` = 'Vyhradené technické zariadenia' WHERE `id` = '6';
/* 13:48:44 gmspider gmspider */ UPDATE `sluzba` SET `nazov_web` = 'Správa majetku' WHERE `id` = '7';
/* 13:48:47 gmspider gmspider */ UPDATE `sluzba` SET `nazov_web` = 'Plánovanie' WHERE `id` = '8';
/* 13:48:51 gmspider gmspider */ UPDATE `sluzba` SET `nazov_web` = 'Zákazník' WHERE `id` = '9';
/* 14:56:04 gmspider gmspider */ DROP TABLE `dokument_sluzba`;
/* 16:42:46 gmspider gmspider */ ALTER TABLE `uloha` CHANGE `datum_platnosti_od` `datum_opakovania_od` DATE  NULL  DEFAULT NULL;
/* 16:42:51 gmspider gmspider */ ALTER TABLE `uloha` CHANGE `datum_platnosti_do` `datum_opakovania_do` DATE  NULL  DEFAULT NULL;
/* 22:11:01 gmspider gmspider */ UPDATE `form_element` SET `db_column` = 'datum_opakovania_od' WHERE `id` = '33105';
/* 22:11:06 gmspider gmspider */ UPDATE `form_element` SET `db_column` = 'datum_opakovania_do' WHERE `id` = '33106';
/* 22:34:20 gmspider gmspider */ DELETE FROM `uloha` WHERE `id` IN ('64');
/* 00:09:49 gmspider gmspider */ ALTER TABLE `uloha` ADD `kratky_nazov` VARCHAR(255)  CHARACTER SET utf8  COLLATE utf8_general_ci  NOT NULL  DEFAULT ''  AFTER `opakovanie`;
/* 00:09:51 gmspider gmspider */ ALTER TABLE `uloha` MODIFY COLUMN `kratky_nazov` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `nazov`;
/* 00:09:55 gmspider gmspider */ ALTER TABLE `uloha` CHANGE `nazov` `nazov` VARCHAR(255)  CHARACTER SET utf8  COLLATE utf8_general_ci  NOT NULL  DEFAULT '';
/* 00:10:16 gmspider gmspider */ UPDATE `form_element` SET `db_column` = 'kratky_nazov' WHERE `id` = '33001';
/* 00:13:14 gmspider gmspider */ UPDATE uloha SET kratky_nazov = nazov;
