CREATE TABLE `dodavatelska_objednavka` (
                              `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
                              `visibility_type` INT(11) NULL DEFAULT NULL,
                              `cislo` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
                              `verzia` INT(11) NULL DEFAULT NULL,
                              `nazov` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
                              `hash` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
                              `pocet_dni_splatnosti` INT(11) NULL DEFAULT NULL,
                              `interna_poznamka` TEXT NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
                              `text_pre_zakaznika` TEXT NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
                              `dolny_text` TEXT NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
                              `obchodny_partner_id` INT(10) UNSIGNED NULL DEFAULT NULL,
                              `osoba_id` INT(10) UNSIGNED NULL DEFAULT NULL,
                              `vytvoril_id` INT(10) UNSIGNED NULL DEFAULT NULL,
                              `stav_objednavky_id` INT(10) UNSIGNED NULL DEFAULT NULL,
                              `datum_odoslania` DATETIME NULL DEFAULT NULL,
                              `datum_vytvorenia` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
                              `predpokladany_datum_dodania` DATE NULL DEFAULT NULL,
                              `cenova_ponuka_id` INT(11) NULL DEFAULT NULL,
                              `typ_objednavky_id` INT(11) NULL DEFAULT NULL,
                              PRIMARY KEY (`id`) USING BTREE
)
    COLLATE='utf8_unicode_ci'
ENGINE=InnoDB
;

CREATE TABLE `polozka_dodavatelskej_objednavky` (
                                      `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
                                      `visibility_type` INT(11) NULL DEFAULT NULL,
                                      `dodavatelska_objednavka_id` INT(10) UNSIGNED NULL DEFAULT NULL,
                                      `nazov` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
                                      `cena_bez_dph` DOUBLE(10,2) NULL DEFAULT NULL,
	`cena_s_dph` DOUBLE(10,2) NULL DEFAULT NULL,
	`sadzba_dph` DOUBLE NULL DEFAULT NULL,
	`mnozstvo` DOUBLE(8,2) NULL DEFAULT NULL,
	`popis` TEXT NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
	`merna_jednotka_id` INT(10) UNSIGNED NULL DEFAULT NULL,
	`poradie` INT(11) NULL DEFAULT NULL,
	`uloha_id` INT(11) NULL DEFAULT NULL,
	`skupina` VARCHAR(255) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
	PRIMARY KEY (`id`) USING BTREE
)
    COLLATE='utf8_unicode_ci'
ENGINE=InnoDB
;

INSERT INTO `form` (`id`, `nazov`, `code`) VALUES (410, 'Dodávateľská objednávka', 'dodavatelska_objednavka');
INSERT INTO `form` (`id`, `nazov`, `code`) VALUES (411, 'Položka dodávateľskej objednávky', 'polozka_dodavatelskej_objednavky');

INSERT INTO `form_group` (`id`, `form_id`, `nazov`, `code`, `position`, `poznamka`, `group_type`) VALUES (410, 410, 'Základné informácie', 'dodavatelska_objednavka_zakladne_informacie', 10, NULL, 1);
INSERT INTO `form_group` (`id`, `form_id`, `nazov`, `code`, `position`, `poznamka`, `group_type`) VALUES (411, 410, 'Ďalšie informácie', 'dodavatelska_objednavka_dalsie_informacie', 20, NULL, 1);
INSERT INTO `form_group` (`id`, `form_id`, `nazov`, `code`, `position`, `poznamka`, `group_type`) VALUES (412, 410, 'Texty', 'dodavatelska_objednavka_texty', 30, NULL, 1);
INSERT INTO `form_group` (`id`, `form_id`, `nazov`, `code`, `position`, `poznamka`, `group_type`) VALUES (413, 411, 'Základné informácie', 'polozka_dodavatelskej_objednavky_zakladne_informacie', 10, NULL, 1);


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 (410, 410, 1, 'dodavatelska_objednavka', 'cislo', NULL, NULL, 'Číslo', 10, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '<vlvalidator name="customCislo" type="custom" function="vdaemonCislo">', NULL, NULL, NULL, NULL);
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 (411, 410, 11, 'dodavatelska_objednavka', 'datum_vytvorenia', NULL, NULL, 'Dátum vytvorenia', 20, '{"datetime_format":"d.m.Y H:i:s","step":1}', NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'NOW', NULL, NULL, NULL, NULL, NULL);
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 (412, 411, 4, 'dodavatelska_objednavka', 'predpokladany_datum_dodania', NULL, NULL, 'Predpokladný dátum dodania', 20, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
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 (413, 410, 5, 'dodavatelska_objednavka', 'osoba_id', 'osoba', NULL, 'Kontaktná osoba', 50, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'select2', NULL, NULL, NULL, NULL, NULL, 1, '<a class="btn btn-primary get-ajax-form" href="osoba_pridaj_modal.php" title="Pridanie osoby" data-before-load="osoba.beforeLoad" data-parent="osoba_id"> <i class="fa fa-plus"></i></a>', NULL, NULL);
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 (414, 410, 5, 'dodavatelska_objednavka', 'stav_objednavky_id', 'stav_objednavky', NULL, 'Stav objednávky', 70, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'select2', NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
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 (415, 412, 10, 'dodavatelska_objednavka', 'interna_poznamka', NULL, NULL, 'Interná poznámka', 40, NULL, 600, 300, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
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 (416, 410, 5, 'dodavatelska_objednavka', 'vytvoril_id', 'zamestnanec', NULL, 'Vytvoril', 30, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, 'select2', NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, 1);
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 (417, 411, 1, 'dodavatelska_objednavka', 'pocet_dni_splatnosti', NULL, NULL, 'Počet dní splatnosti', 40, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '14', NULL, NULL, NULL, NULL, NULL);
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 (418, 410, 5, 'dodavatelska_objednavka', 'obchodny_partner_id', 'obchodny_partner', NULL, 'Obchodný partner', 40, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'select2', NULL, 1, NULL, NULL, NULL, 1, '<a class="btn btn-primary get-ajax-form" href="obchodny_partner_pridaj_modal.php" title="Pridanie obchodného partnera" data-after_load="obchodnyPartner.afterLoad" data-parent="obchodny_partner_id"><i class="fa fa-plus"></i></a>', NULL, NULL);
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 (419, 412, 10, 'dodavatelska_objednavka', 'text_pre_zakaznika', NULL, NULL, 'Text pre zákazníka', 10, NULL, 600, 300, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
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 (420, 412, 10, 'dodavatelska_objednavka', 'dolny_text', NULL, NULL, 'Poznámka', 30, NULL, 600, 300, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
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 (421, 410, 5, 'dodavatelska_objednavka', 'typ_objednavky_id', 'typ_objednavky', NULL, 'Typ', 5, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, NULL, NULL, NULL, 'select2', NULL, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL);
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 (422, 410, 1, 'dodavatelska_objednavka', 'verzia', NULL, NULL, 'Verzia', 15, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL);

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 (430, 413, 1, 'polozka_dodavatelskej_objednavky', 'nazov', NULL, NULL, 'Názov', 40, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
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 (431, 413, 13, 'polozka_dodavatelskej_objednavky', 'dodavatelska_objednavka_id', 'dodavatelska_objednavka', NULL, 'Objednávka', 1, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
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 (432, 413, 1, 'polozka_dodavatelskej_objednavky', 'cena_bez_dph', NULL, NULL, 'Cena bez DPH', 50, NULL, NULL, NULL, NULL, NULL, 1, 1, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
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 (433, 413, 1, 'polozka_dodavatelskej_objednavky', 'mnozstvo', NULL, NULL, 'Množstvo', 70, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
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 (434, 413, 2, 'polozka_dodavatelskej_objednavky', 'popis', NULL, NULL, 'Popis', 100, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
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 (435, 413, 5, 'polozka_dodavatelskej_objednavky', 'merna_jednotka_id', 'merna_jednotka', NULL, 'Merná jednotka', 80, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, 'select2', NULL, 1, NULL, NULL, NULL, 1, NULL, NULL, NULL);
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 (436, 413, 1, 'polozka_dodavatelskej_objednavky', 'poradie', NULL, NULL, 'Poradie', 120, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
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 (437, 413, 1, 'polozka_dodavatelskej_objednavky', 'skupina', NULL, NULL, 'Skupina', 130, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

INSERT INTO `log_type` (`id`, `nazov`, `code`, `primary_table`) VALUES (400, 'Pridanie dodávatelskej objednávky', 'dodavatelska_objednavka_pridaj', NULL);
INSERT INTO `log_type` (`id`, `nazov`, `code`, `primary_table`) VALUES (401, 'Editovanie dodávatelskej objednávky', 'dodavatelska_objednavka_edituj', NULL);
INSERT INTO `log_type` (`id`, `nazov`, `code`, `primary_table`) VALUES (402, 'Zmazanie dodávatelskej objednávky', 'dodavatelska_objednavka_zmaz', NULL);
INSERT INTO `log_type` (`id`, `nazov`, `code`, `primary_table`) VALUES (403, 'Pridanie položky dodávatelskej objednávky', 'polozka_dodavatelskej_objednavky_pridaj', NULL);
INSERT INTO `log_type` (`id`, `nazov`, `code`, `primary_table`) VALUES (404, 'Editovanie položky dodávatelskej objednávky', 'polozka_dodavatelskej_objednavky_edituj', NULL);
INSERT INTO `log_type` (`id`, `nazov`, `code`, `primary_table`) VALUES (405, 'Zmazanie položky dodávatelskej objednávky', 'polozka_dodavatelskej_objednavky_zmaz', NULL);

INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES (401, 36, 'Dodávatelské objednávky', 'dodavatelska_objednavka_vypis', 30, 2, 1);
INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES (402, 36, 'Pridanie dodávatelskej objednávky', 'dodavatelska_objednavka_pridaj', 20, 2, 3);
INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES (403, 401, 'Detail dodávatelskej objednávky', 'dodavatelska_objednavka_view', 10, 3, 1);
INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES (404, 401, 'Editovanie dodávatelskej objednávky', 'dodavatelska_objednavka_edituj', 20, 3, 1);
INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES (405, 401, 'Zmazanie dodávatelskej objednávky', 'dodavatelska_objednavka_zmaz', NULL, 3, NULL);
INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES (406, 401, 'Súbory dodávatelskej objednávky', 'dodavatelska_objednavka_subor', 40, 3, 1);
INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES (408, 401, 'Foto k objednávke', 'dodavatelska_objednavka_foto', 30, 3, 1);
INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES (410, 401, 'Pridanie položky dodávatelskej objednávky', 'polozka_dodavatelskej_objednavky_pridaj', NULL, 3, NULL);
INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES (411, 401, 'Editovanie položky dodávatelskej objednávky', 'polozka_dodavatelskej_objednavky_edituj', NULL, 3, NULL);
INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES (412, 401, 'Zmazanie položky dodávatelskej objednávky', 'polozka_dodavatelskej_objednavky_zmaz', NULL, 3, NULL);

INSERT INTO `priradenie_komunikacie` (`id`, `nazov`, `code`) VALUES (410, 'Dodávatelská objednávka', 'dodavatelska_objednavka ');

INSERT INTO `priradenie_suboru` (`id`, `nazov`, `code`) VALUES (410, 'Dodávateľská objednávka', 'dodavatelska_objednavka');
