-- Adminer 4.3.1 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `migration_versions`;
CREATE TABLE `migration_versions` (
  `version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
  `username_canonical` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
  `email_canonical` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `salt` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `last_login` datetime DEFAULT NULL,
  `confirmation_token` varchar(180) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password_requested_at` datetime DEFAULT NULL,
  `roles` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_8D93D64992FC23A8` (`username_canonical`),
  UNIQUE KEY `UNIQ_8D93D649A0D96FBF` (`email_canonical`),
  UNIQUE KEY `UNIQ_8D93D649C05FB297` (`confirmation_token`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `user` (`id`, `username`, `username_canonical`, `email`, `email_canonical`, `enabled`, `salt`, `password`, `last_login`, `confirmation_token`, `password_requested_at`, `roles`) VALUES
(1, 'testuser', 'testuser', 'test@test.pl', 'test@test.pl', 1,  NULL,   '$2y$13$rUOYN5bjKIlptlpRhZ9vceKyPnBLipeqgCDVoGRg57qs8KkFzONae', '2017-07-20 21:48:53',  NULL,   NULL,   'a:0:{}');

DROP TABLE IF EXISTS `user_worker`;
CREATE TABLE `user_worker` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `surname` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `pesel` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `street` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `postCode` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `city` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `bsn` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `employment_start` date DEFAULT NULL,
  `employment_end` date DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_FAE0A45F1A0AA036` (`bsn`),
  KEY `IDX_FAE0A45FA76ED395` (`user_id`),
  CONSTRAINT `FK_FAE0A45FA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `user_worker_position`;
CREATE TABLE `user_worker_position` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `worker_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `salary_pl` decimal(7,2) NOT NULL,
  `salary_nl` decimal(7,2) NOT NULL,
  `salary_de` decimal(7,2) NOT NULL,
  `salary_fr` decimal(7,2) NOT NULL,
  `addDate` date NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_5CA95A2C6B20BA36` (`worker_id`),
  CONSTRAINT `FK_5CA95A2C6B20BA36` FOREIGN KEY (`worker_id`) REFERENCES `user_worker` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `work_log`;
CREATE TABLE `work_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `workDay` date NOT NULL,
  `workTimeStart` time DEFAULT NULL,
  `workTimeEnd` time DEFAULT NULL,
  `worker_id` int(11) NOT NULL,
  `code_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_F5513F596B20BA36` (`worker_id`),
  KEY `IDX_F5513F5927DAFE17` (`code_id`),
  CONSTRAINT `FK_F5513F5927DAFE17` FOREIGN KEY (`code_id`) REFERENCES `work_log_code` (`id`),
  CONSTRAINT `FK_F5513F596B20BA36` FOREIGN KEY (`worker_id`) REFERENCES `user_worker` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;


DROP TABLE IF EXISTS `work_log_code`;
CREATE TABLE `work_log_code` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `work_log_code` (`id`, `name`) VALUES
(1, 'PL'),
(2, 'DE'),
(3, 'NL'),
(4, 'FR'),
(5, 'NPL'),
(6, 'NDE'),
(7, 'NL'),
(8, 'NFR'),
(9, 'SPL'),
(10,    'SDE'),
(11,    'SNL'),
(12,    'SFR'),
(13,    'UPL'),
(14,    'UDE'),
(15,    'UNL'),
(16,    'UFR');

-- 2017-07-20 20:01:52