/* 08:00:08 gmspider gmspider */ INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES ('117', NULL, 'Riadená dokumentácia', 'dokument', '90', '1', '1');
/* 08:00:38 gmspider gmspider */ INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES ('118', NULL, 'Výpis dokumentov', 'dokument_vypis', '10', '1', '1');
/* 08:01:03 gmspider gmspider */ INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES ('119', NULL, 'Výpis smerníc', 'smernica_vypis', '20', '1', '1');
/* 08:01:28 gmspider gmspider */ INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES ('120', NULL, 'Pridanie smernice', 'smernica_pridaj', '30', '1', '1');
/* 08:01:43 gmspider gmspider */ INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES ('130', NULL, 'Detail smernice', 'smernica_view', '40', '1', '1');
/* 08:02:02 gmspider gmspider */ INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES ('122', NULL, 'Editovanie smernice', 'smernica_edituj', '20', '1', '1');
/* 08:02:04 gmspider gmspider */ UPDATE `menu` SET `id` = '121' WHERE `id` = '130';
/* 08:02:22 gmspider gmspider */ INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES ('123', NULL, 'Zmazanie smernice', 'smernica_zmaz', NULL, '3', '0');
/* 08:02:23 gmspider gmspider */ UPDATE `menu` SET `level` = '2' WHERE `id` = '122';
/* 08:02:25 gmspider gmspider */ UPDATE `menu` SET `level` = '2' WHERE `id` = '121';
/* 08:06:33 gmspider gmspider */ UPDATE `menu` SET `level` = '2' WHERE `id` = '120';
/* 08:06:34 gmspider gmspider */ UPDATE `menu` SET `level` = '2' WHERE `id` = '119';
/* 08:06:42 gmspider gmspider */ UPDATE `menu` SET `menu_id` = '117' WHERE `id` = '119';
/* 08:06:45 gmspider gmspider */ UPDATE `menu` SET `menu_id` = '117', `level` = '2' WHERE `id` = '118';
/* 08:06:49 gmspider gmspider */ UPDATE `menu` SET `menu_id` = '117' WHERE `id` = '120';
/* 08:06:56 gmspider gmspider */ UPDATE `menu` SET `menu_id` = '119' WHERE `id` = '121';
/* 08:06:58 gmspider gmspider */ UPDATE `menu` SET `menu_id` = '119' WHERE `id` = '122';
/* 08:07:00 gmspider gmspider */ UPDATE `menu` SET `menu_id` = '119' WHERE `id` = '123';
/* 08:16:08 gmspider gmspider */ UPDATE `form_element` SET `position` = '10' WHERE `id` = '10';
/* 08:16:10 gmspider gmspider */ UPDATE `form_element` SET `position` = '30' WHERE `id` = '8';
/* 08:16:38 gmspider gmspider */ ALTER TABLE `smernica` ADD `nazov_u_zakaznika` VARCHAR(255)  NULL  DEFAULT NULL  AFTER `visibility_type`;
/* 08:17:29 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 ('20', '4', '1', 'smernica', 'nazov_u_zakaznika', NULL, NULL, 'Názov u zákazníka', '40', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
/* 08:18:13 gmspider gmspider */ INSERT INTO `log_type` (`id`, `nazov`, `code`, `primary_table`) VALUES ('18', 'Pridanie smernice', 'smernica_pridaj', NULL);
/* 08:18:21 gmspider gmspider */ INSERT INTO `log_type` (`id`, `nazov`, `code`, `primary_table`) VALUES ('20', 'Editovanie smernice', 'smernica_edituj', NULL);
/* 08:18:31 gmspider gmspider */ INSERT INTO `log_type` (`id`, `nazov`, `code`, `primary_table`) VALUES ('19', 'Zmazanie smernice', 'smernica_zmaz', NULL);
/* 08:20:55 gmspider gmspider */ UPDATE `menu` SET `level` = '3' WHERE `id` = '121';
/* 08:20:56 gmspider gmspider */ UPDATE `menu` SET `level` = '3' WHERE `id` = '122';
/* 08:35:04 gmspider gmspider */ UPDATE `menu` SET `poradie` = '10' WHERE `id` = '121';
/* 11:41:49 gmspider gmspider */ ALTER TABLE `dokument` DROP FOREIGN KEY `FK_dokument_obchodny_partner`;
/* 11:41:49 gmspider gmspider */ ALTER TABLE `dokument` DROP `obchodny_partner_id`;
/* 11:43:43 gmspider gmspider */ DELETE FROM `form_element` WHERE `id` IN ('35008');
/* 11:47:23 gmspider gmspider */ INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES ('124', '119', 'Pridanie dokumentu', 'dokument_pridaj', NULL, '3', NULL);
/* 11:51:14 gmspider gmspider */ DELETE FROM `form_element` WHERE `id` IN ('35003');
/* 11:53:47 gmspider gmspider */ INSERT INTO `log_type` (`id`, `nazov`, `code`, `primary_table`) VALUES ('21', 'Pridanie dokumentu', 'dokument_pridaj', NULL);
/* 11:53:56 gmspider gmspider */ INSERT INTO `log_type` (`id`, `nazov`, `code`, `primary_table`) VALUES ('22', 'Editovanie dokumentu', 'dokument_edituj', NULL);
/* 11:54:04 gmspider gmspider */ INSERT INTO `log_type` (`id`, `nazov`, `code`, `primary_table`) VALUES ('23', 'Zmazanie dokumentu', 'dokument_zmaz', NULL);
/* 12:21:57 gmspider gmspider */ INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES ('125', '119', 'Detail dokumentu', 'dokument_view', NULL, '3', NULL);
/* 12:22:09 gmspider gmspider */ INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES ('126', '119', 'Editovanie dokumentu', 'dokument_edituj', NULL, '3', NULL);
/* 20:01:31 gmspider gmspider */ UPDATE `menu` SET `poradie` = '10' WHERE `id` = '119';
/* 20:01:34 gmspider gmspider */ UPDATE `menu` SET `poradie` = '20' WHERE `id` = '120';
/* 20:01:34 gmspider gmspider */ UPDATE `menu` SET `poradie` = '30' WHERE `id` = '118';
/* 20:02:22 gmspider gmspider */ UPDATE `menu` SET `page` = 'smernica' WHERE `id` = '117';
/* 21:06:02 gmspider gmspider */ UPDATE `menu` SET `visibility_type` = '3' WHERE `id` = '118';
/* 21:18:08 gmspider gmspider */ CREATE TABLE `zmena` (id INT(11) UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT) DEFAULT CHARACTER SET `utf8` DEFAULT COLLATE `utf8_general_ci`;
/* 21:18:18 gmspider gmspider */ ALTER TABLE `zmena` CHANGE `id` `id` INT(10)  UNSIGNED  NOT NULL  AUTO_INCREMENT;
/* 21:18:22 gmspider gmspider */ ALTER TABLE `zmena` ADD `nazov` VARCHAR(255)  NULL  DEFAULT NULL  AFTER `id`;
/* 21:18:37 gmspider gmspider */ ALTER TABLE `zmena` ADD `smernica_id` INT(10)  UNSIGNED  NULL  DEFAULT NULL  AFTER `nazov`;
/* 21:20:27 gmspider gmspider */ ALTER TABLE `zmena` ADD `datum_prijatia` DATE  NULL  AFTER `smernica_id`;
/* 21:20:32 gmspider gmspider */ ALTER TABLE `zmena` ADD `datum_vytvorenia` DATETIME  NULL  AFTER `datum_prijatia`;
/* 21:20:40 gmspider gmspider */ ALTER TABLE `zmena` ADD `vytvoril_id` INT(10)  UNSIGNED  NULL  DEFAULT NULL  AFTER `datum_vytvorenia`;
/* 21:20:45 gmspider gmspider */ ALTER TABLE `zmena` CHANGE `smernica_id` `ochodny_partner_id` INT(10)  UNSIGNED  NULL  DEFAULT NULL;
/* 21:20:54 gmspider gmspider */ ALTER TABLE `zmena` ADD `cislo` INT(10)  NULL  DEFAULT NULL  AFTER `vytvoril_id`;
/* 21:21:01 gmspider gmspider */ ALTER TABLE `zmena` ADD `nazov_u_zakaznika` VARCHAR(255)  NULL  DEFAULT NULL  AFTER `cislo`;
/* 21:21:13 gmspider gmspider */ ALTER TABLE `zmena` ADD `visibility_type` TINYINT(1)  NULL  DEFAULT NULL  AFTER `nazov_u_zakaznika`;
/* 21:21:18 gmspider gmspider */ ALTER TABLE `zmena` ADD `platnost_od` DATE  NULL  AFTER `visibility_type`;
/* 21:21:55 gmspider gmspider */ ALTER TABLE `zmena` ADD `popis` TEXT  NULL  AFTER `platnost_od`;
/* 21:21:57 gmspider gmspider */ ALTER TABLE `zmena` MODIFY COLUMN `nazov_u_zakaznika` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL AFTER `nazov`;
/* 21:22:00 gmspider gmspider */ ALTER TABLE `zmena` MODIFY COLUMN `cislo` INT(10) DEFAULT NULL AFTER `id`;
/* 21:22:19 gmspider gmspider */ INSERT INTO `form` (`id`, `nazov`, `code`) VALUES ('2', 'Zmena', 'zmena');
/* 21:22:35 gmspider gmspider */ INSERT INTO `form_group` (`id`, `form_id`, `nazov`, `code`, `position`, `poznamka`, `group_type`) VALUES ('7', '2', 'Základné informácie', 'zmena_zakladne_informacie', '10', NULL, '1');
/* 21:22:48 gmspider gmspider */ INSERT INTO `form_group` (`id`, `form_id`, `nazov`, `code`, `position`, `poznamka`, `group_type`) VALUES ('8', '2', 'Priradenie zmeny', 'zmena_priradenie', '20', NULL, '1');
/* 21:25:54 gmspider gmspider */ INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES ('127', NULL, 'Zmenové konanie', 'zmena', '100', '1', NULL);
/* 21:26:09 gmspider gmspider */ INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES ('128', '127', 'Výpis zmien', 'zmena_vypis', '10', '2', NULL);
/* 21:27:19 gmspider gmspider */ INSERT INTO `menu`(`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES 	(129, 127, 'Pridanie zmeny', 'zmena_pridaj', 20, 2, 1), 	(130, 128, 'Detail zmeny', 'zmena_view', 10, 3, 1), 	(131, 128, 'Editovanie zmeny', 'zmena_edituj', 20, 3, 1), 	(132, 128, 'Zmazanie zmeny', 'zmena_zmaz', 30, 3, 0);
/* 21:27:49 gmspider gmspider */ INSERT INTO log_type (id, nazov, code) VALUES (24, 'Pridanie zmeny', 'zmena_pridaj');
/* 21:27:49 gmspider gmspider */ INSERT INTO log_type (id, nazov, code) VALUES (25, 'Editovanie zmeny', 'zmena_edituj');
/* 21:27:49 gmspider gmspider */ INSERT INTO log_type (id, nazov, code) VALUES (26, 'Zmazanie zmeny', 'zmena_zmaz');
/* 21:30:20 gmspider gmspider */ UPDATE `menu` SET `visibility_type` = '1' WHERE `id` = '127';
/* 21:30:21 gmspider gmspider */ UPDATE `menu` SET `visibility_type` = '1' WHERE `id` = '128';
/* 21:39:38 gmspider gmspider */ ALTER TABLE `zmena` ADD `typ_zmeny_id` INT(10)  UNSIGNED  NULL  DEFAULT NULL  AFTER `popis`;
/* 21:39:51 gmspider gmspider */ CREATE TABLE `typ_zmeny` (   `id` int(11) DEFAULT NULL,   `nazov` varchar(50) DEFAULT NULL,   `code` varchar(50) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/* 21:40:02 gmspider gmspider */ INSERT INTO `typ_zmeny` (`id`, `nazov`, `code`) VALUES ('1', 'Interná', 'interna');
/* 21:40:07 gmspider gmspider */ INSERT INTO `typ_zmeny` (`id`, `nazov`, `code`) VALUES ('2', 'Externá', 'externa');
/* 21:41:33 gmspider gmspider */ ALTER TABLE `zmena` CHANGE `ochodny_partner_id` `obchodny_partner_id` INT(10)  UNSIGNED  NULL  DEFAULT NULL;
/* 21:46:22 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 ('21', '7', '1', 'zmena', 'cislo', NULL, NULL, 'Číslo zmeny', '10', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
/* 21:47:40 gmspider gmspider */ UPDATE `form_element` SET `direct_to_db` = '0', `read_only` = '1' WHERE `id` = '21';
/* 21:48:33 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 ('22', '7', '11', 'zmena', 'datum_vytvorenia', NULL, NULL, 'Dátum vytvorenia', '20', NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1');
/* 21:49:24 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 ('23', '7', '11', 'zmena', 'datum_prijatia', NULL, NULL, 'Dátum prijatia', '30', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'NOW', NULL, NULL, NULL, NULL, '1');
/* 21:49:28 gmspider gmspider */ UPDATE `form_element` SET `read_only` = NULL WHERE `id` = '23';
/* 21:50:31 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 ('24', '8', '5', 'zmena', 'obchodny_partner_id', 'obchodny_partner', NULL, 'Obchodný partner', '10', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, 'select2', NULL, '1', NULL, NULL, NULL, '1', NULL, NULL, NULL);
/* 21:51:18 gmspider gmspider */ UPDATE `form_element` SET `attribute` = '{\"datetime_format\":\"d.m.Y H:i\",\"step\":1}' WHERE `id` = '22';
/* 21:51:40 gmspider gmspider */ UPDATE `form_element` SET `form_element_type_id` = '4' WHERE `id` = '23';
/* 21:54:17 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 ('25', '7', '5', 'zmena', 'vytvoril_id', 'zamestnanec', NULL, 'Vytvoril', '30', NULL, NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
/* 21:54:21 gmspider gmspider */ UPDATE `form_element` SET `read_only` = '1' WHERE `id` = '25';
/* 21:56:06 gmspider gmspider */ UPDATE `form_element` SET `read_only` = NULL WHERE `id` = '21';
/* 21:57:07 gmspider gmspider */ UPDATE `form_element` SET `position` = '20' WHERE `id` = '23';
/* 21:57:11 gmspider gmspider */ UPDATE `form_element` SET `position` = '30' WHERE `id` = '22';
/* 22:01:59 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 ('27', '7', '5', 'zmena', 'typ_zmeny_id', 'typ_zmeny', NULL, 'Typ zmeny', '40', NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, 'select2', NULL, '1', NULL, NULL, NULL, '1', NULL, NULL, '1');
/* 22:02:24 gmspider gmspider */ UPDATE `form_element` SET `read_only` = NULL WHERE `id` = '27';
/* 22:04:05 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 ('28', '7', '4', 'zmena', 'platnost_od', NULL, NULL, 'Platnosť od', '50', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
/* 22:04:35 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 ('29', '7', '10', 'zmena', 'popis', NULL, NULL, 'Popis', '60', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

/* 22:10:07 gmspider gmspider */ UPDATE `form_element` SET `width` = '600', `height` = '300' WHERE `id` = '29';
/* 22:11:10 gmspider gmspider */ UPDATE `form_element` SET `position` = '20' WHERE `id` = '22';
/* 22:11:15 gmspider gmspider */ UPDATE `form_element` SET `position` = '40' WHERE `id` = '23';
/* 22:11:38 gmspider gmspider */ UPDATE `form_element` SET `default_val` = '1' WHERE `id` = '27';
/* 22:11:47 gmspider gmspider */ UPDATE `form_element` SET `add_empty_option` = NULL WHERE `id` = '27';
/* 22:15:07 gmspider gmspider */ UPDATE `form_element` SET `required` = '1' WHERE `id` = '24';
/* 22:15:25 gmspider gmspider */ CREATE TABLE `stav_zmeny` (   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,   `nazov` varchar(45) DEFAULT NULL,   `code` varchar(45) DEFAULT NULL,   PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
/* 22:15:38 gmspider gmspider */ INSERT INTO `stav_zmeny` (`id`, `nazov`, `code`) VALUES ('1', 'Otvorená', 'otvorena');
/* 22:15:46 gmspider gmspider */ INSERT INTO `stav_zmeny` (`id`, `nazov`, `code`) VALUES ('2', 'Uzavretá', 'uzavreta');
/* 22:15:50 gmspider gmspider */ INSERT INTO `stav_zmeny` (`id`, `nazov`, `code`) VALUES ('3', 'Zrušená', 'zrusena');
/* 22:16:04 gmspider gmspider */ ALTER TABLE `zmena` ADD `stav_zmeny_id` INT(10)  UNSIGNED  NULL  DEFAULT NULL  AFTER `typ_zmeny_id`;
/* 22:16: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 ('30', '5', '5', 'zmena', 'stav_zmeny_id', 'stav_zmeny', NULL, 'Stav zmeny', '60', NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, 'select2', NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL);
/* 22:16:53 gmspider gmspider */ UPDATE `form_element` SET `position` = '70' WHERE `id` = '29';
/* 22:17:04 gmspider gmspider */ UPDATE `form_element` SET `form_group_id` = '7' WHERE `id` = '30';
/* 22:17:16 gmspider gmspider */ UPDATE `form_element` SET `direct_multi_label` = '1' WHERE `id` = '30';
/* 22:18:56 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 ('31', '7', '1', 'zmena', 'nazov_u_zakaznika', NULL, NULL, 'Číslo u zákazníka', '20', NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
/* 22:19:22 gmspider gmspider */ UPDATE `form_element` SET `position` = '30' WHERE `id` = '22';
/* 22:19:23 gmspider gmspider */ UPDATE `form_element` SET `position` = '40' WHERE `id` = '25';
/* 22:19:25 gmspider gmspider */ UPDATE `form_element` SET `position` = '50' WHERE `id` = '23';
/* 22:19:33 gmspider gmspider */ UPDATE `form_element` SET `position` = '60' WHERE `id` = '27';
/* 22:19:35 gmspider gmspider */ UPDATE `form_element` SET `position` = '70' WHERE `id` = '28';
/* 22:19:44 gmspider gmspider */ UPDATE `form_element` SET `position` = '80' WHERE `id` = '30';
/* 22:19:47 gmspider gmspider */ UPDATE `form_element` SET `position` = '9-' WHERE `id` = '29';
/* 22:19:49 gmspider gmspider */ UPDATE `form_element` SET `position` = '90' WHERE `id` = '29';
/* 22:25:07 gmspider gmspider */ ALTER TABLE `zmena` ADD `smernica_id` INT(10)  UNSIGNED  NULL  DEFAULT NULL  AFTER `stav_zmeny_id`;
/* 22:25: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 ('32', '8', '5', 'zmena', 'smernica_id', 'smernica', NULL, 'Smernica', '20', NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, 'select2', NULL, '1', NULL, NULL, NULL, '1', NULL, NULL, NULL);
/* 22:32:44 gmspider gmspider */ INSERT INTO `menu` (`id`, `menu_id`, `nazov`, `page`, `poradie`, `level`, `visibility_type`) VALUES ('133', '128', 'Zmenená dokumentácia', 'zmena_subor', '30', '3', '1');
/* 22:32:45 gmspider gmspider */ UPDATE `menu` SET `poradie` = NULL WHERE `id` = '132';
/* 22:38:36 gmspider gmspider */ INSERT INTO `priradenie_suboru` (`id`, `nazov`, `code`) VALUES ('1', 'Zmena', 'zmena');
/* 22:41:59 gmspider gmspider */ UPDATE `form_element` SET `read_only` = '1' WHERE `id` = '30';
/* 22:42:25 gmspider gmspider */ UPDATE `form_element` SET `direct_multi_label` = NULL, `default_val` = NULL WHERE `id` = '30';
/* 22:43:53 gmspider gmspider */ UPDATE `form_element` SET `direct_multi_label` = '1' WHERE `id` = '29';
/* 22:44:03 gmspider gmspider */ UPDATE `form_element` SET `direct_multi_label` = '1' WHERE `id` = '30';
/* 22:44:05 gmspider gmspider */ UPDATE `form_element` SET `direct_multi_label` = NULL WHERE `id` = '29';
/* 22:56:59 gmspider gmspider */ CREATE TABLE `zmena_dokument` (   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,   `zmena_id` int(10) unsigned NOT NULL,   `dokument_pred_zmenou_id` int(10) unsigned NOT NULL,   `dokument_po_zmene_id` int(11) unsigned DEFAULT NULL,   `zrusenie_dokumentu` TINYINT(1) unsigned DEFAULT NULL,   `visibility_type` tinyint(1) unsigned DEFAULT NULL,   PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/* 22:57:28 gmspider gmspider */ UPDATE `menu` SET `page` = 'zmena_dokument' WHERE `id` = '133';
/* 23:45:30 gmspider gmspider */ ALTER TABLE `dokument` CHANGE `revizia` `edicia` INT(11)  NULL  DEFAULT NULL;
/* 23:45:54 gmspider gmspider */ UPDATE `form_element` SET `db_column` = 'edicia' WHERE `id` = '35004';
/* 23:57:44 gmspider gmspider */ INSERT INTO `log_type` (`id`, `nazov`, `code`, `primary_table`) VALUES ('27', 'Pridanie dokumentu do zmeny', 'zmena_dokument_pridaj', NULL);
/* 23:57:54 gmspider gmspider */ INSERT INTO `log_type` (`id`, `nazov`, `code`, `primary_table`) VALUES ('28', 'Editovanie dokumentu v zmene', 'zmena_dokument_edituj', NULL);
/* 23:58:05 gmspider gmspider */ INSERT INTO `log_type` (`id`, `nazov`, `code`, `primary_table`) VALUES ('29', 'Zmazanie dokumentu zo zmeny', 'zmena_dokument_zmaz', NULL);
/* 00:10:20 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 ('33', '35000', '1', 'dokument', 'smernica_id', 'smernica', NULL, 'Smernica', NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
/* 00:10:33 gmspider gmspider */ UPDATE `form_element` SET `form_element_type_id` = '13' WHERE `id` = '33';
/* 09:07:03 gmspider gmspider */ ALTER TABLE `zmena_dokument` DROP `zrusenie_dokumentu`;
