/* 20:41:26 */ 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 ('6106', '6101', '10', 'polozka_faktury', 'szcp', NULL, NULL, 'SZČP', '7', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
/* 20:41:35 */ UPDATE `form_element` SET `form_element_type_id` = '2' WHERE `id` = '6106';
/* 20:41:54 */ UPDATE `form_element` SET `height` = '40' WHERE `id` = '6106';
/* 21:20:12 */ UPDATE `sluzba` SET `analyticky_ucet` = 'BTS' WHERE `id` = '12';
/* 21:20:19 */ UPDATE `sluzba` SET `analyticky_ucet` = 'VTZ' WHERE `id` = '13';
/* 21:20:27 */ UPDATE `sluzba` SET `analyticky_ucet` = 'PZS' WHERE `id` = '14';
/* 21:20:45 */ UPDATE `sluzba` SET `analyticky_ucet` = 'OOÚ' WHERE `id` = '20';
/* 21:20:52 */ UPDATE `sluzba` SET `analyticky_ucet` = 'ŽP' WHERE `id` = '11';
/* 21:20:57 */ UPDATE `sluzba` SET `analyticky_ucet` = 'CO' WHERE `id` = '18';
/* 21:21:39 */ UPDATE `sluzba` SET `analyticky_ucet` = '' WHERE `id` = '11';
/* 21:21:40 */ UPDATE `sluzba` SET `analyticky_ucet` = 'ŽP' WHERE `id` = '10';
/* 21:21:45 */ UPDATE `sluzba` SET `analyticky_ucet` = 'BTS' WHERE `id` = '11';
/* 21:21:54 */ UPDATE `sluzba` SET `analyticky_ucet` = 'BTS' WHERE `id` = '15';
/* 21:23:11 */ INSERT INTO `sluzba` (`id`, `nazov`, `kratky_nazov`, `gm_sluzba_id`, `nazov_web`, `poradie`, `code`, `icon`, `modul_id`, `visibility_type`, `analyticky_ucet`) VALUES ('22', 'Elektrické zariadenia', 'ELE', NULL, NULL, '290', NULL, NULL, NULL, '1', 'ELE');
/* 21:23:49 */ INSERT INTO `sluzba` (`id`, `nazov`, `kratky_nazov`, `gm_sluzba_id`, `nazov_web`, `poradie`, `code`, `icon`, `modul_id`, `visibility_type`, `analyticky_ucet`) VALUES ('23', 'Revízie hasiacich prístrojov', 'HP', NULL, NULL, '300', NULL, NULL, NULL, '1', 'HP');
/* 21:32:25 */ ALTER TABLE `pobocka` DROP `analyticky_ucet`;

INSERT INTO `stredisko` (`id`, `nazov`, `analyticky_ucet`, `visibility_type`)
VALUES
  (1, 'správa VTZ ZA', 'ZAVS', 0),
  (2, 'technici ELE ZA', 'ZAELE', 1),
  (3, 'technici BTS ZA	', 'ZABTS', 1),
  (4, 'technici ŽP ZA', 'ZAŽP', 1),
  (5, 'PZS PB', 'PBPZS', 1),
  (6, 'správa PZS PB', 'PBPS', 0),
  (7, 'technici VTZ PB', 'PBVTZ', 1),
  (8, 'technici BTS PB	', 'PBBTS', 1),
  (9, 'technici ŽP PB', 'PBŽP', 1),
  (10, 'PZS LM', 'LMPZS', 1),
  (11, 'predajňa LM', 'LMPR', 0),
  (12, 'technici ELE LM	', 'LMELE', 1),
  (13, 'technici VTZ LM', 'LMVTZ', 1),
  (14, 'správa VTZ LM', 'LMVS', 1),
  (15, 'dielňa LM', 'LMHP', 1),
  (16, 'technici BTS LM', 'LMBTS', 1),
  (17, 'technici BTS BA', 'BABTS', 1),
  (18, 'správa PB', 'PBS', 1),
  (19, 'technici BTS ZM', 'ZMBTS', 1),
  (20, 'životné prostredie LM', 'LMŽP', 1),
  (21, 'ochrana osobných údajov LM', 'LMOOÚ', 1),
  (22, 'GAJOS administratíva', 'GAA', 1),
  (23, 'technici VTZ ZA', 'ZAVTZ', 1),
  (24, 'PZS ZA', 'ZAPZS', 1),
  (25, 'správa dielne LM', 'LMDS', 1),
  (26, 'správa ZA', 'ZAS', 1),
  (27, 'správa ELE LM', 'LMES', 1),
  (28, 'správa BA', 'BAS', 1),
  (29, 'CO LM', 'LMCO', 1),
  (30, 'správa LM', 'LMS', 1),
  (31, 'správa ZM', 'ZMS', 1);

/* 21:40:53 */ CREATE TABLE `zamestnanec_stredisko` (   `zamestnanec_id` int(11) NOT NULL,   `stredisko_id` int(11) NOT NULL,   PRIMARY KEY (`stredisko_id`,`zamestnanec_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/* 21:41:43 */ 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 ('138', '21001', '9', 'zamestnanec', 'stredisko_id', 'stredisko', NULL, 'Stredisko', '75', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, 'select2', NULL, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL);
/* 22:18:51 */ INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES 	(156, 21000, 'Stredisko', 'stredisko_vypis', 40, 2, 1), 	(157, 21000, 'Pridanie strediska', 'stredisko_pridaj', 20, 2, 0), 	(158, 156, 'Detail strediska', 'stredisko_view', 10, 3, 1), 	(159, 156, 'Editovanie strediska', 'stredisko_edituj', 20, 3, 1), 	(160, 156, 'Zmazanie strediska', 'stredisko_zmaz', 30, 3, 0);
/* 22:27:15 */ INSERT INTO `form` (`id`, `nazov`, `code`) VALUES ('71', 'Stredisko', 'stredisko');
/* 22:27:34 */ INSERT INTO `form_group` (`id`, `form_id`, `nazov`, `code`, `position`, `poznamka`, `group_type`) VALUES ('28', '71', 'Základné informácie', 'stredisko', '10', NULL, '1');
/* 22:29:47 */ 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 	(139, 28, 1, 'stredisko', 'nazov', NULL, NULL, 'Názov', 10, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
/* 22:30:15 */ 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 ('140', '28', '1', 'stredisko', 'analyticky_ucet', NULL, NULL, 'Analytický účet', '20', NULL, NULL, NULL, NULL, NULL, '1', '+', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
/* 22:30:17 */ UPDATE `form_element` SET `required` = '1' WHERE `id` = '139';
/* 22:30:17 */ UPDATE `form_element` SET `required` = '1' WHERE `id` = '140';
/* 22:32:42 */ INSERT INTO `log_type` (`id`, `nazov`, `code`, `primary_table`) VALUES 	(59, 'Pridanie strediska', 'strediska_pridaj', NULL), 	(60, 'Editovanie strediska', 'strediska_edituj', NULL), 	(61, 'Zmazanie strediska', 'strediska_zmaz', NULL);
/* 22:32:59 */ UPDATE `log_type` SET `code` = 'stredisko_pridaj' WHERE `id` = '59';
/* 22:33:01 */ UPDATE `log_type` SET `code` = 'stredisko_edituj' WHERE `id` = '60';
/* 22:33:04 */ UPDATE `log_type` SET `code` = 'stredisko_zmaz' WHERE `id` = '61';
