INSERT INTO `log_type` (`id`, `nazov`, `code`, `primary_table`)
VALUES
    (87, 'Záznamy zamestnancov import', 'zaznamy_zamestnancov_import', NULL);

CREATE TABLE `zaznamy_zamestnancov_import` (
                                               `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
                                               `nadradeny_majetok_id` int(11) DEFAULT NULL,
                                               `stav` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL,
                                               `created_by` int(11) DEFAULT NULL,
                                               `created_at` datetime DEFAULT NULL,
                                               `updated_at` datetime DEFAULT NULL ON UPDATE current_timestamp(),
                                               PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

CREATE TABLE `zaznamy_zamestnancov_import_subor` (
                                                     `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
                                                     `zaznamy_zamestnancov_import_id` int(11) DEFAULT NULL,
                                                     `nazov` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_uca1400_ai_ci DEFAULT NULL,
                                                     `majetok_id` int(11) DEFAULT NULL,
                                                     `rok` int(11) DEFAULT NULL,
                                                     PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`)
VALUES
    (36010, 36001, 'Záznamy zamestnancov', 'zaznamy_zamestnancov_import', NULL, 3, 3);
