/* 07:52:05 gmspider gmspider */ CREATE TABLE `typ_klienta` (   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,   `nazov` varchar(45) NOT NULL,   PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/* 07:52:17 gmspider gmspider */ INSERT INTO `typ_klienta` (`id`, `nazov`) VALUES ('1', 'Paušálny klient');
/* 07:52:28 gmspider gmspider */ INSERT INTO `typ_klienta` (`id`, `nazov`) VALUES ('2', 'Objednávkový klient');
/* 07:52:50 gmspider gmspider */ ALTER TABLE `obchodny_partner` ADD `typ_klienta_id` INT(11)  NULL  DEFAULT NULL  AFTER `typ_obchodneho_partnera_id`;
/* 07:53:52 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 ('446', '26000', '5', 'obchodny_partner', 'typ_klienta_id', 'typ_klienta', NULL, 'Typ klienta', '25', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, 'select2', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
/* 07:55:19 gmspider gmspider */ UPDATE `form_element` SET `add_empty_option` = '1' WHERE `id` = '446';

/* 07:58:30 gmspider gmspider */ INSERT INTO `role` (`id`, `nazov`, `code`) VALUES ('8', 'Vedúci oddelenia', 'veduci_oddelenia');
/* 08:00:41 gmspider gmspider */ INSERT INTO `permission` (`id`, `nazov`) VALUES ('190', 'zamestnanec_all');
/* 08:01:08 gmspider gmspider */ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES ('8', '100');
/* 08:01:16 gmspider gmspider */ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES ('8', '105');
/* 08:01:21 gmspider gmspider */ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES ('8', '108');
/* 08:01:26 gmspider gmspider */ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES ('8', '109');
/* 08:01:31 gmspider gmspider */ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES ('8', '190');
/* 08:05:10 gmspider gmspider */ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES ('8', '175');
/* 08:29:45 gmspider gmspider */ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES ('8', '135');
/* 08:30:20 gmspider gmspider */ INSERT INTO `role_permission` (`role_id`, `permission_id`) VALUES ('8', '123');
