ALTER TABLE `zamestnanec`
	ADD COLUMN `datum_zmena_hesla` DATETIME NULL AFTER `funkcia`;

CREATE TABLE `zamestnanec_stare_hesla` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`zamestnanec_id` INT(11) NULL DEFAULT NULL,
	`heslo` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
	`created_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
	PRIMARY KEY (`id`) USING BTREE
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
;

ALTER TABLE `zamestnanec`
	ADD COLUMN `pocet_zlych_prihlaseni` INT NULL DEFAULT '0' AFTER `datum_zmena_hesla`,
	ADD COLUMN `zablokovany` TINYINT(1) NULL DEFAULT NULL AFTER `pocet_zlych_prihlaseni`;
