/*1*/ CREATE TABLE `zakaznik_subor` (
	`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	`popis` VARCHAR(255) NULL DEFAULT NULL,
	`nazov` VARCHAR(255) NULL DEFAULT NULL,
	`hash` VARCHAR(255) NULL DEFAULT NULL,	
	`visibility_type` TINYINT(1) UNSIGNED NULL DEFAULT NULL,
	`datum_vytvorenia` DATETIME NULL DEFAULT NULL,
	`osoba_id` INT(11) UNSIGNED NULL DEFAULT NULL,
	PRIMARY KEY (`id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;
/*2*/ ALTER TABLE `zakaznik_subor`
	ADD COLUMN `velkost` BIGINT NULL AFTER `osoba_id`;
/*3*/ ALTER TABLE `zakaznik_subor`
	ADD COLUMN `zakaznik_subor_id` INT(11) NULL DEFAULT NULL AFTER `velkost`;
/*4*/ ALTER TABLE `zakaznik_subor`
	ADD COLUMN `is_dir` TINYINT(1) NULL DEFAULT NULL AFTER `zakaznik_subor_id`;
/*5*/ ALTER TABLE `zakaznik_subor`
	CHANGE COLUMN `is_dir` `is_dir` TINYINT(1) NOT NULL DEFAULT '0' AFTER `zakaznik_subor_id`;
/*6*/ ALTER TABLE `uloha`
	ADD COLUMN `datum_uzavretia` DATE NOT NULL AFTER `datum_vytvorenia`;
/*7*/ INSERT INTO `form_element` (`id`, `form_group_id`, `form_element_type_id`, `db_table`, `db_column`, `column_title`, `position`, `direct_to_db`, `read_only`) VALUES (33015, 33000, 4, 'uloha', 'datum_uzavretia', 'Dátum uzavretia', 95, 0, 1);
/*8*/ UPDATE `form_element` SET `position`=91 WHERE  `id`=33015;