/* 20:48:36 gmspider gmspider */ INSERT INTO `log_type` (`id`, `nazov`, `code`, `primary_table`) VALUES ('13', 'Webmin - správny login', 'webmin_spravny_login', NULL);
/* 20:48:50 gmspider gmspider */ INSERT INTO `log_type` (`id`, `nazov`, `code`, `primary_table`) VALUES ('14', 'Webmin - nesprávny login', 'webmin_nespravny_login', NULL);
/* 21:41:32 gmspider gmspider */ ALTER TABLE `kalendar_udalost` ADD `obchodny_partner_id` INT(10)  UNSIGNED  NOT NULL  AFTER `mesiac_id`;
/* 21:41:56 gmspider gmspider */ ALTER TABLE `kalendar_udalost` CHANGE `obchodny_partner_id` `obchodny_partner_id` INT(10)  UNSIGNED  NULL;
/* 21:43:15 gmspider gmspider */ UPDATE kalendar_udalost SET obchodny_partner_id = NULL;
/* 21:43:24 gmspider gmspider */ /* 21:42:36 gmspider gmspider */ ALTER TABLE `kalendar_udalost` ADD CONSTRAINT `obchodny_partner_id` FOREIGN KEY (`obchodny_partner_id`) REFERENCES `obchodny_partner` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
/* 21:44:42 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 ('14', '37000', '5', 'kalendar_udalost', 'obchodny_partner_id', 'obchodny_partner', NULL, 'Obchodný partner', '90', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, 'select2', NULL, '1', NULL, NULL, NULL, '1', NULL, NULL, NULL);
/* 22:03:11 gmspider gmspider */ ALTER TABLE `kalendar_udalost` ADD `typ_kalendar_udalost_id` INT(10)  UNSIGNED  NULL  DEFAULT NULL  AFTER `obchodny_partner_id`;
/* 22:03:39 gmspider gmspider */ CREATE TABLE `typ_kalendar_udalost` (   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,   `nazov` varchar(45) NOT NULL,   `code` varchar(45) DEFAULT NULL,   PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/* 22:06:02 gmspider gmspider */ INSERT INTO `typ_kalendar_udalost` (`id`, `nazov`, `code`) VALUES ('1', 'Školenie', 'skolenie');
/* 22:06:09 gmspider gmspider */ INSERT INTO `typ_kalendar_udalost` (`id`, `nazov`, `code`) VALUES ('2', 'Revízia', 'revizia');
/* 22:07:07 gmspider gmspider */ ALTER TABLE `kalendar_udalost` ADD CONSTRAINT `typ_kalendar_udalost_id` FOREIGN KEY (`typ_kalendar_udalost_id`) REFERENCES `typ_kalendar_udalost` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
/* 22:11:08 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 ('15', '37000', '5', 'kalendar_udalost', 'typ_kalendar_udalost_id', 'typ_kalendar_udalost', NULL, 'Typ udalosti', '5', NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, 'select2', NULL, '1', NULL, NULL, NULL, '1', NULL, NULL, NULL);
/* 23:06:44 gmspider gmspider */ UPDATE `stav_ulohy` SET `code` = 'vyriesena' WHERE `id` = '3';
/* 23:06:46 gmspider gmspider */ UPDATE `stav_ulohy` SET `code` = 'rozpracovana' WHERE `id` = '2';
/* 23:06:48 gmspider gmspider */ UPDATE `stav_ulohy` SET `code` = 'otvorena' WHERE `id` = '1';
