-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL version:             7.0.0.4053
-- Date/time:                    2012-06-10 23:56:24
-- --------------------------------------------------------


-- Dumping database structure for hrms
CREATE DATABASE IF NOT EXISTS `hrms` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `hrms`;


-- Dumping structure for table hrms.tbl_appl_functions
CREATE TABLE IF NOT EXISTS `tbl_appl_functions` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `FUNCTION_NAME` varchar(32) NOT NULL,
  `CREATION_DATE` datetime DEFAULT NULL,
  `CREATED_BY` bigint(16) DEFAULT NULL,
  `MODIFY_DATE` datetime DEFAULT NULL,
  `MODIFIED_BY` bigint(16) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_tbl_appl_functions_tbl_appl_user` (`CREATED_BY`),
  KEY `FK_tbl_appl_functions_tbl_appl_user_2` (`MODIFIED_BY`),
  CONSTRAINT `FK_tbl_appl_functions_tbl_appl_user` FOREIGN KEY (`CREATED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_appl_functions_tbl_appl_user_2` FOREIGN KEY (`MODIFIED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_appl_functions: ~113 rows (approximately)
INSERT INTO `tbl_appl_functions` (`ID`, `FUNCTION_NAME`, `CREATION_DATE`, `CREATED_BY`, `MODIFY_DATE`, `MODIFIED_BY`) VALUES
	(1, 'Sicil No', NULL, NULL, NULL, NULL),
	(2, 'Adı', NULL, NULL, NULL, NULL),
	(3, 'Soyadı', NULL, NULL, NULL, NULL),
	(4, 'Cinsiyet', NULL, NULL, NULL, NULL),
	(5, 'Uyruğu', NULL, NULL, NULL, NULL),
	(6, 'Kan Grubu', NULL, NULL, NULL, NULL),
	(7, 'Doğum Tarihi', NULL, NULL, NULL, NULL),
	(8, 'Medeni Hali', NULL, NULL, NULL, NULL),
	(9, 'Sürücü Belgesi', NULL, NULL, NULL, NULL),
	(10, 'E-Posta', NULL, NULL, NULL, NULL),
	(11, 'İş Telefonu', NULL, NULL, NULL, NULL),
	(12, 'Cep Telefonu', NULL, NULL, NULL, NULL),
	(13, 'Ev Telefonu', NULL, NULL, NULL, NULL),
	(14, 'Görev', NULL, NULL, NULL, NULL),
	(15, 'Bölüm', NULL, NULL, NULL, NULL),
	(16, 'Yönetici', NULL, NULL, NULL, NULL),
	(17, 'Yönetici Adı', NULL, NULL, NULL, NULL),
	(18, 'Ünvanı', NULL, NULL, NULL, NULL),
	(19, 'TC Kimlik No', NULL, NULL, NULL, NULL),
	(20, 'SSK Numarası', NULL, NULL, NULL, NULL),
	(21, 'Mezuniyet Tarihi', NULL, NULL, NULL, NULL),
	(22, 'Kontrat Tipi', NULL, NULL, NULL, NULL),
	(23, 'Siemens EC işe başlama tarihi', NULL, NULL, NULL, NULL),
	(24, 'Siemens A.Ş. işe başlama Tarihi', NULL, NULL, NULL, NULL),
	(25, 'Askerlik Durumu', NULL, NULL, NULL, NULL),
	(26, 'Askerlik Tecil/Terhis Tarihi', NULL, NULL, NULL, NULL),
	(27, 'Yer', NULL, NULL, NULL, NULL),
	(28, 'Ofis Yeri', NULL, NULL, NULL, NULL),
	(29, 'Arbis kaydı', NULL, NULL, NULL, NULL),
	(30, 'Fotoğraf', NULL, NULL, NULL, NULL),
	(31, 'Özlük Onay', NULL, NULL, NULL, NULL),
	(32, 'Eğitim Seviyesi', NULL, NULL, NULL, NULL),
	(33, 'Kurum Adı', NULL, NULL, NULL, NULL),
	(34, 'Bölüm', NULL, NULL, NULL, NULL),
	(35, 'Tez', NULL, NULL, NULL, NULL),
	(36, 'Giriş Tarihi', NULL, NULL, NULL, NULL),
	(37, 'Mezuniyet', NULL, NULL, NULL, NULL),
	(38, 'Eğitime Devam Ediyor', NULL, NULL, NULL, NULL),
	(39, 'Eğitim Onay', NULL, NULL, NULL, NULL),
	(40, 'Eğitim Notlar', NULL, NULL, NULL, NULL),
	(41, 'Firma Adı', NULL, NULL, NULL, NULL),
	(42, 'Çalışma Yeri', NULL, NULL, NULL, NULL),
	(43, 'Görev', NULL, NULL, NULL, NULL),
	(44, 'Başlangıç Tarihi', NULL, NULL, NULL, NULL),
	(45, 'Bitiş Tarihi', NULL, NULL, NULL, NULL),
	(46, 'Tecrübe Notlar', NULL, NULL, NULL, NULL),
	(47, 'Tecrübe Onay', NULL, NULL, NULL, NULL),
	(48, 'Dil', NULL, NULL, NULL, NULL),
	(49, 'Yazma Seviyesi', NULL, NULL, NULL, NULL),
	(50, 'Konuşma Seviyesi', NULL, NULL, NULL, NULL),
	(51, 'Okuma Seviyesi', NULL, NULL, NULL, NULL),
	(52, 'Anadil', NULL, NULL, NULL, NULL),
	(53, 'Dil Onay', NULL, NULL, NULL, NULL),
	(54, 'Proje Adı', NULL, NULL, NULL, NULL),
	(55, 'Proje Görevi', NULL, NULL, NULL, NULL),
	(56, 'Tamamlanmış', NULL, NULL, NULL, NULL),
	(57, 'Başlangıç Tarihi', NULL, NULL, NULL, NULL),
	(58, 'Bitiş Tarihi', NULL, NULL, NULL, NULL),
	(59, 'Proje Notlar', NULL, NULL, NULL, NULL),
	(60, 'Proje Onay', NULL, NULL, NULL, NULL),
	(61, 'Tubitak', NULL, NULL, NULL, NULL),
	(62, 'Sertifika Kurumu', NULL, NULL, NULL, NULL),
	(63, 'Sertifika Adı', NULL, NULL, NULL, NULL),
	(64, 'Sertifika Tarihi', NULL, NULL, NULL, NULL),
	(65, 'Sertifika Notlar', NULL, NULL, NULL, NULL),
	(66, 'Sertifika Onay', NULL, NULL, NULL, NULL),
	(67, 'Bilgi Adı', NULL, NULL, NULL, NULL),
	(68, 'Bilgi Seviyesi', NULL, NULL, NULL, NULL),
	(69, 'Bilgi Onay', NULL, NULL, NULL, NULL),
	(70, 'Bilgi Notlar', NULL, NULL, NULL, NULL),
	(71, 'Eğitim Adı', NULL, NULL, NULL, NULL),
	(72, 'Eğitim Yeri', NULL, NULL, NULL, NULL),
	(73, 'Eğitim Kurumu', NULL, NULL, NULL, NULL),
	(74, 'Eğitim Başlangıç Tarihi', NULL, NULL, NULL, NULL),
	(75, 'Eğitim Bitiş Tarihi', NULL, NULL, NULL, NULL),
	(76, 'Eğitim Süresi', NULL, NULL, NULL, NULL),
	(77, 'Eğitim Onay', NULL, NULL, NULL, NULL),
	(78, 'Eğitim Notlar', NULL, NULL, NULL, NULL),
	(79, 'Masraf Yeri', NULL, NULL, NULL, NULL),
	(80, 'Ağırlık%', NULL, NULL, NULL, NULL),
	(81, 'Açıklama', NULL, NULL, NULL, NULL),
	(82, 'Ek Tipi', NULL, NULL, NULL, NULL),
	(83, 'Dosya İçeriği', NULL, NULL, NULL, NULL),
	(84, 'Dosya Adı', NULL, NULL, NULL, NULL),
	(85, 'Sadece Adres', NULL, NULL, NULL, NULL),
	(86, 'Ek Notlar', NULL, NULL, NULL, NULL),
	(87, 'Ek Onay', NULL, NULL, NULL, NULL),
	(88, 'Dosya Yükle', NULL, NULL, NULL, NULL),
	(89, 'Acil Durum Adı', NULL, NULL, NULL, NULL),
	(90, 'Acil Durum Soyadı', NULL, NULL, NULL, NULL),
	(91, 'Acil Yakınlık Derecesi', NULL, NULL, NULL, NULL),
	(92, 'Acil Telefon Numarası', NULL, NULL, NULL, NULL),
	(93, 'Özlük Kaydet', NULL, NULL, NULL, NULL),
	(94, 'Yeni Eğitim Bilgisi', NULL, NULL, NULL, NULL),
	(95, 'Eğitim Bilgisi Kaydet', NULL, NULL, NULL, NULL),
	(96, 'Yeni İş Tecrübesi', NULL, NULL, NULL, NULL),
	(97, 'İş Tecrübesi Kaydet', NULL, NULL, NULL, NULL),
	(98, 'Yeni Dil', NULL, NULL, NULL, NULL),
	(99, 'Dil Kaydet', NULL, NULL, NULL, NULL),
	(100, 'Proje Ekle', NULL, NULL, NULL, NULL),
	(101, 'Proje Kaydet', NULL, NULL, NULL, NULL),
	(102, 'Yeni Sertifika', NULL, NULL, NULL, NULL),
	(103, 'Sertifika Kaydet', NULL, NULL, NULL, NULL),
	(104, 'Yeni Teknik Bilgi', NULL, NULL, NULL, NULL),
	(105, 'Teknik Bilgi Kaydet', NULL, NULL, NULL, NULL),
	(106, 'Yeni Eğitim', NULL, NULL, NULL, NULL),
	(107, 'Eğitim Kaydet', NULL, NULL, NULL, NULL),
	(108, 'Yeni Masraf Yeri', NULL, NULL, NULL, NULL),
	(109, 'Masraf Yeri Kaydet', NULL, NULL, NULL, NULL),
	(110, 'Yeni Ek', NULL, NULL, NULL, NULL),
	(111, 'Ek Kaydet', NULL, NULL, NULL, NULL),
	(112, 'Yeni Acil', NULL, NULL, NULL, NULL),
	(113, 'Acil Kaydet', NULL, NULL, NULL, NULL);


-- Dumping structure for table hrms.tbl_appl_func_role_edit
CREATE TABLE IF NOT EXISTS `tbl_appl_func_role_edit` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `ROLE_ID` bigint(16) NOT NULL,
  `FUNCTION_ID` bigint(16) NOT NULL,
  `VALUE` bit(1) NOT NULL,
  `CREATION_DATE` datetime DEFAULT NULL,
  `CREATED_BY` bigint(16) DEFAULT NULL,
  `MODIFY_DATE` datetime DEFAULT NULL,
  `MODIFIED_BY` bigint(16) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_tbl_appl_func_role_tbl_appl_roles` (`ROLE_ID`),
  KEY `FK_tbl_appl_func_role_tbl_appl_functions` (`FUNCTION_ID`),
  KEY `FK_tbl_appl_func_role_tbl_appl_user` (`CREATED_BY`),
  KEY `FK_tbl_appl_func_role_tbl_appl_user_2` (`MODIFIED_BY`),
  CONSTRAINT `FK_tbl_appl_func_role_tbl_appl_functions` FOREIGN KEY (`FUNCTION_ID`) REFERENCES `tbl_appl_functions` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_appl_func_role_tbl_appl_roles` FOREIGN KEY (`ROLE_ID`) REFERENCES `tbl_appl_roles` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_appl_func_role_tbl_appl_user` FOREIGN KEY (`CREATED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_appl_func_role_tbl_appl_user_2` FOREIGN KEY (`MODIFIED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=453 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_appl_func_role_edit: ~452 rows (approximately)
INSERT INTO `tbl_appl_func_role_edit` (`ID`, `ROLE_ID`, `FUNCTION_ID`, `VALUE`, `CREATION_DATE`, `CREATED_BY`, `MODIFY_DATE`, `MODIFIED_BY`) VALUES
	(1, 1, 1, b'00000000', NULL, NULL, NULL, NULL),
	(2, 1, 2, b'00000000', NULL, NULL, NULL, NULL),
	(3, 1, 3, b'00000000', NULL, NULL, NULL, NULL),
	(4, 1, 4, b'00000000', NULL, NULL, NULL, NULL),
	(5, 1, 5, b'00000000', NULL, NULL, NULL, NULL),
	(6, 1, 6, b'00000000', NULL, NULL, NULL, NULL),
	(7, 1, 7, b'00000000', NULL, NULL, NULL, NULL),
	(8, 1, 8, b'00000000', NULL, NULL, NULL, NULL),
	(9, 1, 9, b'00000000', NULL, NULL, NULL, NULL),
	(10, 1, 10, b'00000000', NULL, NULL, NULL, NULL),
	(11, 1, 11, b'00000000', NULL, NULL, NULL, NULL),
	(12, 1, 12, b'00000000', NULL, NULL, NULL, NULL),
	(13, 1, 13, b'00000000', NULL, NULL, NULL, NULL),
	(14, 1, 14, b'00000000', NULL, NULL, NULL, NULL),
	(15, 1, 15, b'00000000', NULL, NULL, NULL, NULL),
	(16, 1, 16, b'00000000', NULL, NULL, NULL, NULL),
	(17, 1, 17, b'00000000', NULL, NULL, NULL, NULL),
	(18, 1, 18, b'00000000', NULL, NULL, NULL, NULL),
	(19, 1, 19, b'00000000', NULL, NULL, NULL, NULL),
	(20, 1, 20, b'00000000', NULL, NULL, NULL, NULL),
	(21, 1, 21, b'00000000', NULL, NULL, NULL, NULL),
	(22, 1, 22, b'00000000', NULL, NULL, NULL, NULL),
	(23, 1, 23, b'00000000', NULL, NULL, NULL, NULL),
	(24, 1, 24, b'00000000', NULL, NULL, NULL, NULL),
	(25, 1, 25, b'00000000', NULL, NULL, NULL, NULL),
	(26, 1, 26, b'00000000', NULL, NULL, NULL, NULL),
	(27, 1, 27, b'00000000', NULL, NULL, NULL, NULL),
	(28, 1, 28, b'00000000', NULL, NULL, NULL, NULL),
	(29, 1, 29, b'00000000', NULL, NULL, NULL, NULL),
	(30, 1, 30, b'00000000', NULL, NULL, NULL, NULL),
	(31, 1, 31, b'00000000', NULL, NULL, NULL, NULL),
	(32, 2, 1, b'00000000', NULL, NULL, NULL, NULL),
	(33, 2, 2, b'00000000', NULL, NULL, NULL, NULL),
	(34, 2, 3, b'00000000', NULL, NULL, NULL, NULL),
	(35, 2, 4, b'00000000', NULL, NULL, NULL, NULL),
	(36, 2, 5, b'00000000', NULL, NULL, NULL, NULL),
	(37, 2, 6, b'00000000', NULL, NULL, NULL, NULL),
	(38, 2, 7, b'00000000', NULL, NULL, NULL, NULL),
	(39, 2, 8, b'00000000', NULL, NULL, NULL, NULL),
	(40, 2, 9, b'00000000', NULL, NULL, NULL, NULL),
	(41, 2, 10, b'00000000', NULL, NULL, NULL, NULL),
	(42, 2, 11, b'00000000', NULL, NULL, NULL, NULL),
	(43, 2, 12, b'00000000', NULL, NULL, NULL, NULL),
	(44, 2, 13, b'00000000', NULL, NULL, NULL, NULL),
	(45, 2, 14, b'00000000', NULL, NULL, NULL, NULL),
	(46, 2, 15, b'00000000', NULL, NULL, NULL, NULL),
	(47, 2, 16, b'00000000', NULL, NULL, NULL, NULL),
	(48, 2, 17, b'00000000', NULL, NULL, NULL, NULL),
	(49, 2, 18, b'00000000', NULL, NULL, NULL, NULL),
	(50, 2, 19, b'00000000', NULL, NULL, NULL, NULL),
	(51, 2, 20, b'00000000', NULL, NULL, NULL, NULL),
	(52, 2, 21, b'00000000', NULL, NULL, NULL, NULL),
	(53, 2, 22, b'00000000', NULL, NULL, NULL, NULL),
	(54, 2, 23, b'00000000', NULL, NULL, NULL, NULL),
	(55, 2, 24, b'00000000', NULL, NULL, NULL, NULL),
	(56, 2, 25, b'00000000', NULL, NULL, NULL, NULL),
	(57, 2, 26, b'00000000', NULL, NULL, NULL, NULL),
	(58, 2, 27, b'00000000', NULL, NULL, NULL, NULL),
	(59, 2, 28, b'00000000', NULL, NULL, NULL, NULL),
	(60, 2, 29, b'00000000', NULL, NULL, NULL, NULL),
	(61, 2, 30, b'00000000', NULL, NULL, NULL, NULL),
	(62, 2, 31, b'00000000', NULL, NULL, NULL, NULL),
	(63, 3, 1, b'10000000', NULL, NULL, NULL, NULL),
	(64, 3, 2, b'10000000', NULL, NULL, NULL, NULL),
	(65, 3, 3, b'10000000', NULL, NULL, NULL, NULL),
	(66, 3, 4, b'10000000', NULL, NULL, NULL, NULL),
	(67, 3, 5, b'10000000', NULL, NULL, NULL, NULL),
	(68, 3, 6, b'10000000', NULL, NULL, NULL, NULL),
	(69, 3, 7, b'10000000', NULL, NULL, NULL, NULL),
	(70, 3, 8, b'10000000', NULL, NULL, NULL, NULL),
	(71, 3, 9, b'10000000', NULL, NULL, NULL, NULL),
	(72, 3, 10, b'10000000', NULL, NULL, NULL, NULL),
	(73, 3, 11, b'10000000', NULL, NULL, NULL, NULL),
	(74, 3, 12, b'10000000', NULL, NULL, NULL, NULL),
	(75, 3, 13, b'10000000', NULL, NULL, NULL, NULL),
	(76, 3, 14, b'10000000', NULL, NULL, NULL, NULL),
	(77, 3, 15, b'10000000', NULL, NULL, NULL, NULL),
	(78, 3, 16, b'10000000', NULL, NULL, NULL, NULL),
	(79, 3, 17, b'00000000', NULL, NULL, NULL, NULL),
	(80, 3, 18, b'10000000', NULL, NULL, NULL, NULL),
	(81, 3, 19, b'10000000', NULL, NULL, NULL, NULL),
	(82, 3, 20, b'10000000', NULL, NULL, NULL, NULL),
	(83, 3, 21, b'10000000', NULL, NULL, NULL, NULL),
	(84, 3, 22, b'10000000', NULL, NULL, NULL, NULL),
	(85, 3, 23, b'10000000', NULL, NULL, NULL, NULL),
	(86, 3, 24, b'00000000', NULL, NULL, NULL, NULL),
	(87, 3, 25, b'10000000', NULL, NULL, NULL, NULL),
	(88, 3, 26, b'10000000', NULL, NULL, NULL, NULL),
	(89, 3, 27, b'10000000', NULL, NULL, NULL, NULL),
	(90, 3, 28, b'10000000', NULL, NULL, NULL, NULL),
	(91, 3, 29, b'10000000', NULL, NULL, NULL, NULL),
	(92, 3, 30, b'10000000', NULL, NULL, NULL, NULL),
	(93, 3, 31, b'10000000', NULL, NULL, NULL, NULL),
	(94, 4, 1, b'00000000', NULL, NULL, NULL, NULL),
	(95, 4, 2, b'00000000', NULL, NULL, NULL, NULL),
	(96, 4, 3, b'00000000', NULL, NULL, NULL, NULL),
	(97, 4, 4, b'00000000', NULL, NULL, NULL, NULL),
	(98, 4, 5, b'00000000', NULL, NULL, NULL, NULL),
	(99, 4, 6, b'00000000', NULL, NULL, NULL, NULL),
	(100, 4, 7, b'00000000', NULL, NULL, NULL, NULL),
	(101, 4, 8, b'00000000', NULL, NULL, NULL, NULL),
	(102, 4, 9, b'00000000', NULL, NULL, NULL, NULL),
	(103, 4, 10, b'00000000', NULL, NULL, NULL, NULL),
	(104, 4, 11, b'00000000', NULL, NULL, NULL, NULL),
	(105, 4, 12, b'00000000', NULL, NULL, NULL, NULL),
	(106, 4, 13, b'00000000', NULL, NULL, NULL, NULL),
	(107, 4, 14, b'00000000', NULL, NULL, NULL, NULL),
	(108, 4, 15, b'00000000', NULL, NULL, NULL, NULL),
	(109, 4, 16, b'00000000', NULL, NULL, NULL, NULL),
	(110, 4, 17, b'00000000', NULL, NULL, NULL, NULL),
	(111, 4, 18, b'00000000', NULL, NULL, NULL, NULL),
	(112, 4, 19, b'00000000', NULL, NULL, NULL, NULL),
	(113, 4, 20, b'00000000', NULL, NULL, NULL, NULL),
	(114, 4, 21, b'00000000', NULL, NULL, NULL, NULL),
	(115, 4, 22, b'00000000', NULL, NULL, NULL, NULL),
	(116, 4, 23, b'00000000', NULL, NULL, NULL, NULL),
	(117, 4, 24, b'00000000', NULL, NULL, NULL, NULL),
	(118, 4, 25, b'00000000', NULL, NULL, NULL, NULL),
	(119, 4, 26, b'00000000', NULL, NULL, NULL, NULL),
	(120, 4, 27, b'00000000', NULL, NULL, NULL, NULL),
	(121, 4, 28, b'00000000', NULL, NULL, NULL, NULL),
	(122, 4, 29, b'00000000', NULL, NULL, NULL, NULL),
	(123, 4, 30, b'00000000', NULL, NULL, NULL, NULL),
	(124, 4, 31, b'00000000', NULL, NULL, NULL, NULL),
	(125, 1, 32, b'00000000', NULL, NULL, NULL, NULL),
	(126, 1, 33, b'00000000', NULL, NULL, NULL, NULL),
	(127, 1, 34, b'00000000', NULL, NULL, NULL, NULL),
	(128, 1, 35, b'00000000', NULL, NULL, NULL, NULL),
	(129, 1, 36, b'00000000', NULL, NULL, NULL, NULL),
	(130, 1, 37, b'00000000', NULL, NULL, NULL, NULL),
	(131, 1, 38, b'00000000', NULL, NULL, NULL, NULL),
	(132, 1, 39, b'00000000', NULL, NULL, NULL, NULL),
	(133, 1, 40, b'00000000', NULL, NULL, NULL, NULL),
	(134, 1, 41, b'00000000', NULL, NULL, NULL, NULL),
	(135, 1, 42, b'00000000', NULL, NULL, NULL, NULL),
	(136, 1, 43, b'00000000', NULL, NULL, NULL, NULL),
	(137, 1, 44, b'00000000', NULL, NULL, NULL, NULL),
	(138, 1, 45, b'00000000', NULL, NULL, NULL, NULL),
	(139, 1, 46, b'00000000', NULL, NULL, NULL, NULL),
	(140, 1, 47, b'00000000', NULL, NULL, NULL, NULL),
	(141, 2, 32, b'00000000', NULL, NULL, NULL, NULL),
	(142, 2, 33, b'00000000', NULL, NULL, NULL, NULL),
	(143, 2, 34, b'00000000', NULL, NULL, NULL, NULL),
	(144, 2, 35, b'00000000', NULL, NULL, NULL, NULL),
	(145, 2, 36, b'00000000', NULL, NULL, NULL, NULL),
	(146, 2, 37, b'00000000', NULL, NULL, NULL, NULL),
	(147, 2, 38, b'00000000', NULL, NULL, NULL, NULL),
	(148, 2, 39, b'00000000', NULL, NULL, NULL, NULL),
	(149, 2, 40, b'00000000', NULL, NULL, NULL, NULL),
	(150, 2, 41, b'00000000', NULL, NULL, NULL, NULL),
	(151, 2, 42, b'00000000', NULL, NULL, NULL, NULL),
	(152, 2, 43, b'00000000', NULL, NULL, NULL, NULL),
	(153, 2, 44, b'00000000', NULL, NULL, NULL, NULL),
	(154, 2, 45, b'00000000', NULL, NULL, NULL, NULL),
	(155, 2, 46, b'00000000', NULL, NULL, NULL, NULL),
	(156, 2, 47, b'00000000', NULL, NULL, NULL, NULL),
	(157, 3, 32, b'10000000', NULL, NULL, NULL, NULL),
	(158, 3, 33, b'10000000', NULL, NULL, NULL, NULL),
	(159, 3, 34, b'10000000', NULL, NULL, NULL, NULL),
	(160, 3, 35, b'10000000', NULL, NULL, NULL, NULL),
	(161, 3, 36, b'10000000', NULL, NULL, NULL, NULL),
	(162, 3, 37, b'10000000', NULL, NULL, NULL, NULL),
	(163, 3, 38, b'10000000', NULL, NULL, NULL, NULL),
	(164, 3, 39, b'10000000', NULL, NULL, NULL, NULL),
	(165, 3, 40, b'10000000', NULL, NULL, NULL, NULL),
	(166, 3, 41, b'10000000', NULL, NULL, NULL, NULL),
	(167, 3, 42, b'10000000', NULL, NULL, NULL, NULL),
	(168, 3, 43, b'10000000', NULL, NULL, NULL, NULL),
	(169, 3, 44, b'10000000', NULL, NULL, NULL, NULL),
	(170, 3, 45, b'10000000', NULL, NULL, NULL, NULL),
	(171, 3, 46, b'10000000', NULL, NULL, NULL, NULL),
	(172, 3, 47, b'10000000', NULL, NULL, NULL, NULL),
	(173, 4, 32, b'00000000', NULL, NULL, NULL, NULL),
	(174, 4, 33, b'00000000', NULL, NULL, NULL, NULL),
	(175, 4, 34, b'00000000', NULL, NULL, NULL, NULL),
	(176, 4, 35, b'00000000', NULL, NULL, NULL, NULL),
	(177, 4, 36, b'00000000', NULL, NULL, NULL, NULL),
	(178, 4, 37, b'00000000', NULL, NULL, NULL, NULL),
	(179, 4, 38, b'00000000', NULL, NULL, NULL, NULL),
	(180, 4, 39, b'00000000', NULL, NULL, NULL, NULL),
	(181, 4, 40, b'00000000', NULL, NULL, NULL, NULL),
	(182, 4, 41, b'00000000', NULL, NULL, NULL, NULL),
	(183, 4, 42, b'00000000', NULL, NULL, NULL, NULL),
	(184, 4, 43, b'00000000', NULL, NULL, NULL, NULL),
	(185, 4, 44, b'00000000', NULL, NULL, NULL, NULL),
	(186, 4, 45, b'00000000', NULL, NULL, NULL, NULL),
	(187, 4, 46, b'00000000', NULL, NULL, NULL, NULL),
	(188, 4, 47, b'00000000', NULL, NULL, NULL, NULL),
	(189, 1, 48, b'00000000', NULL, NULL, NULL, NULL),
	(190, 1, 49, b'00000000', NULL, NULL, NULL, NULL),
	(191, 1, 50, b'00000000', NULL, NULL, NULL, NULL),
	(192, 1, 51, b'00000000', NULL, NULL, NULL, NULL),
	(193, 1, 52, b'00000000', NULL, NULL, NULL, NULL),
	(194, 1, 53, b'00000000', NULL, NULL, NULL, NULL),
	(195, 2, 48, b'00000000', NULL, NULL, NULL, NULL),
	(196, 2, 49, b'00000000', NULL, NULL, NULL, NULL),
	(197, 2, 50, b'00000000', NULL, NULL, NULL, NULL),
	(198, 2, 51, b'00000000', NULL, NULL, NULL, NULL),
	(199, 2, 52, b'00000000', NULL, NULL, NULL, NULL),
	(200, 2, 53, b'00000000', NULL, NULL, NULL, NULL),
	(201, 3, 48, b'10000000', NULL, NULL, NULL, NULL),
	(202, 3, 49, b'10000000', NULL, NULL, NULL, NULL),
	(203, 3, 50, b'10000000', NULL, NULL, NULL, NULL),
	(204, 3, 51, b'10000000', NULL, NULL, NULL, NULL),
	(205, 3, 52, b'10000000', NULL, NULL, NULL, NULL),
	(206, 3, 53, b'10000000', NULL, NULL, NULL, NULL),
	(207, 4, 48, b'00000000', NULL, NULL, NULL, NULL),
	(208, 4, 49, b'00000000', NULL, NULL, NULL, NULL),
	(209, 4, 50, b'00000000', NULL, NULL, NULL, NULL),
	(210, 4, 51, b'00000000', NULL, NULL, NULL, NULL),
	(211, 4, 52, b'00000000', NULL, NULL, NULL, NULL),
	(212, 4, 53, b'00000000', NULL, NULL, NULL, NULL),
	(213, 1, 54, b'00000000', NULL, NULL, NULL, NULL),
	(214, 1, 55, b'00000000', NULL, NULL, NULL, NULL),
	(215, 1, 56, b'00000000', NULL, NULL, NULL, NULL),
	(216, 1, 57, b'00000000', NULL, NULL, NULL, NULL),
	(217, 1, 58, b'00000000', NULL, NULL, NULL, NULL),
	(218, 1, 59, b'00000000', NULL, NULL, NULL, NULL),
	(219, 1, 60, b'00000000', NULL, NULL, NULL, NULL),
	(220, 1, 61, b'00000000', NULL, NULL, NULL, NULL),
	(221, 2, 54, b'10000000', NULL, NULL, NULL, NULL),
	(222, 2, 55, b'10000000', NULL, NULL, NULL, NULL),
	(223, 2, 56, b'10000000', NULL, NULL, NULL, NULL),
	(224, 2, 57, b'10000000', NULL, NULL, NULL, NULL),
	(225, 2, 58, b'10000000', NULL, NULL, NULL, NULL),
	(226, 2, 59, b'10000000', NULL, NULL, NULL, NULL),
	(227, 2, 60, b'00000000', NULL, NULL, NULL, NULL),
	(228, 2, 61, b'10000000', NULL, NULL, NULL, NULL),
	(229, 3, 54, b'10000000', NULL, NULL, NULL, NULL),
	(230, 3, 55, b'10000000', NULL, NULL, NULL, NULL),
	(231, 3, 56, b'10000000', NULL, NULL, NULL, NULL),
	(232, 3, 57, b'10000000', NULL, NULL, NULL, NULL),
	(233, 3, 58, b'10000000', NULL, NULL, NULL, NULL),
	(234, 3, 59, b'10000000', NULL, NULL, NULL, NULL),
	(235, 3, 60, b'10000000', NULL, NULL, NULL, NULL),
	(236, 3, 61, b'10000000', NULL, NULL, NULL, NULL),
	(237, 4, 54, b'00000000', NULL, NULL, NULL, NULL),
	(238, 4, 55, b'00000000', NULL, NULL, NULL, NULL),
	(239, 4, 56, b'00000000', NULL, NULL, NULL, NULL),
	(240, 4, 57, b'00000000', NULL, NULL, NULL, NULL),
	(241, 4, 58, b'00000000', NULL, NULL, NULL, NULL),
	(242, 4, 59, b'00000000', NULL, NULL, NULL, NULL),
	(243, 4, 60, b'00000000', NULL, NULL, NULL, NULL),
	(244, 4, 61, b'00000000', NULL, NULL, NULL, NULL),
	(245, 1, 62, b'00000000', NULL, NULL, NULL, NULL),
	(246, 1, 63, b'00000000', NULL, NULL, NULL, NULL),
	(247, 1, 64, b'00000000', NULL, NULL, NULL, NULL),
	(248, 1, 65, b'00000000', NULL, NULL, NULL, NULL),
	(249, 1, 66, b'00000000', NULL, NULL, NULL, NULL),
	(250, 2, 62, b'00000000', NULL, NULL, NULL, NULL),
	(251, 2, 63, b'00000000', NULL, NULL, NULL, NULL),
	(252, 2, 64, b'00000000', NULL, NULL, NULL, NULL),
	(253, 2, 65, b'00000000', NULL, NULL, NULL, NULL),
	(254, 2, 66, b'00000000', NULL, NULL, NULL, NULL),
	(255, 3, 62, b'10000000', NULL, NULL, NULL, NULL),
	(256, 3, 63, b'10000000', NULL, NULL, NULL, NULL),
	(257, 3, 64, b'10000000', NULL, NULL, NULL, NULL),
	(258, 3, 65, b'10000000', NULL, NULL, NULL, NULL),
	(259, 3, 66, b'10000000', NULL, NULL, NULL, NULL),
	(260, 4, 62, b'00000000', NULL, NULL, NULL, NULL),
	(261, 4, 63, b'00000000', NULL, NULL, NULL, NULL),
	(262, 4, 64, b'00000000', NULL, NULL, NULL, NULL),
	(263, 4, 65, b'00000000', NULL, NULL, NULL, NULL),
	(264, 4, 66, b'00000000', NULL, NULL, NULL, NULL),
	(265, 1, 67, b'00000000', NULL, NULL, NULL, NULL),
	(266, 1, 68, b'00000000', NULL, NULL, NULL, NULL),
	(267, 1, 69, b'00000000', NULL, NULL, NULL, NULL),
	(268, 1, 70, b'00000000', NULL, NULL, NULL, NULL),
	(269, 2, 67, b'00000000', NULL, NULL, NULL, NULL),
	(270, 2, 68, b'00000000', NULL, NULL, NULL, NULL),
	(271, 2, 69, b'00000000', NULL, NULL, NULL, NULL),
	(272, 2, 70, b'00000000', NULL, NULL, NULL, NULL),
	(273, 3, 67, b'10000000', NULL, NULL, NULL, NULL),
	(274, 3, 68, b'10000000', NULL, NULL, NULL, NULL),
	(275, 3, 69, b'10000000', NULL, NULL, NULL, NULL),
	(276, 3, 70, b'10000000', NULL, NULL, NULL, NULL),
	(277, 4, 67, b'00000000', NULL, NULL, NULL, NULL),
	(278, 4, 68, b'00000000', NULL, NULL, NULL, NULL),
	(279, 4, 69, b'00000000', NULL, NULL, NULL, NULL),
	(280, 4, 70, b'00000000', NULL, NULL, NULL, NULL),
	(281, 1, 71, b'00000000', NULL, NULL, NULL, NULL),
	(282, 1, 72, b'00000000', NULL, NULL, NULL, NULL),
	(283, 1, 73, b'00000000', NULL, NULL, NULL, NULL),
	(284, 1, 74, b'00000000', NULL, NULL, NULL, NULL),
	(285, 1, 75, b'00000000', NULL, NULL, NULL, NULL),
	(286, 1, 76, b'00000000', NULL, NULL, NULL, NULL),
	(287, 1, 77, b'00000000', NULL, NULL, NULL, NULL),
	(288, 1, 78, b'00000000', NULL, NULL, NULL, NULL),
	(289, 2, 71, b'00000000', NULL, NULL, NULL, NULL),
	(290, 2, 72, b'00000000', NULL, NULL, NULL, NULL),
	(291, 2, 73, b'00000000', NULL, NULL, NULL, NULL),
	(292, 2, 74, b'00000000', NULL, NULL, NULL, NULL),
	(293, 2, 75, b'00000000', NULL, NULL, NULL, NULL),
	(294, 2, 76, b'00000000', NULL, NULL, NULL, NULL),
	(295, 2, 77, b'00000000', NULL, NULL, NULL, NULL),
	(296, 2, 78, b'00000000', NULL, NULL, NULL, NULL),
	(297, 3, 71, b'10000000', NULL, NULL, NULL, NULL),
	(298, 3, 72, b'10000000', NULL, NULL, NULL, NULL),
	(299, 3, 73, b'10000000', NULL, NULL, NULL, NULL),
	(300, 3, 74, b'10000000', NULL, NULL, NULL, NULL),
	(301, 3, 75, b'10000000', NULL, NULL, NULL, NULL),
	(302, 3, 76, b'10000000', NULL, NULL, NULL, NULL),
	(303, 3, 77, b'10000000', NULL, NULL, NULL, NULL),
	(304, 3, 78, b'10000000', NULL, NULL, NULL, NULL),
	(305, 4, 71, b'00000000', NULL, NULL, NULL, NULL),
	(306, 4, 72, b'00000000', NULL, NULL, NULL, NULL),
	(307, 4, 73, b'00000000', NULL, NULL, NULL, NULL),
	(308, 4, 74, b'00000000', NULL, NULL, NULL, NULL),
	(309, 4, 75, b'00000000', NULL, NULL, NULL, NULL),
	(310, 4, 76, b'00000000', NULL, NULL, NULL, NULL),
	(311, 4, 77, b'00000000', NULL, NULL, NULL, NULL),
	(312, 4, 78, b'00000000', NULL, NULL, NULL, NULL),
	(313, 1, 79, b'00000000', NULL, NULL, NULL, NULL),
	(314, 1, 80, b'00000000', NULL, NULL, NULL, NULL),
	(315, 1, 81, b'00000000', NULL, NULL, NULL, NULL),
	(316, 2, 79, b'00000000', NULL, NULL, NULL, NULL),
	(317, 2, 80, b'00000000', NULL, NULL, NULL, NULL),
	(318, 2, 81, b'00000000', NULL, NULL, NULL, NULL),
	(319, 3, 79, b'10000000', NULL, NULL, NULL, NULL),
	(320, 3, 80, b'10000000', NULL, NULL, NULL, NULL),
	(321, 3, 81, b'10000000', NULL, NULL, NULL, NULL),
	(322, 4, 79, b'00000000', NULL, NULL, NULL, NULL),
	(323, 4, 80, b'00000000', NULL, NULL, NULL, NULL),
	(324, 4, 81, b'00000000', NULL, NULL, NULL, NULL),
	(325, 1, 82, b'00000000', NULL, NULL, NULL, NULL),
	(326, 1, 83, b'00000000', NULL, NULL, NULL, NULL),
	(327, 1, 84, b'00000000', NULL, NULL, NULL, NULL),
	(328, 1, 85, b'00000000', NULL, NULL, NULL, NULL),
	(329, 1, 86, b'00000000', NULL, NULL, NULL, NULL),
	(330, 1, 87, b'00000000', NULL, NULL, NULL, NULL),
	(331, 1, 88, b'00000000', NULL, NULL, NULL, NULL),
	(332, 1, 89, b'00000000', NULL, NULL, NULL, NULL),
	(333, 1, 90, b'00000000', NULL, NULL, NULL, NULL),
	(334, 1, 91, b'00000000', NULL, NULL, NULL, NULL),
	(335, 1, 92, b'00000000', NULL, NULL, NULL, NULL),
	(336, 2, 82, b'00000000', NULL, NULL, NULL, NULL),
	(337, 2, 83, b'00000000', NULL, NULL, NULL, NULL),
	(338, 2, 84, b'00000000', NULL, NULL, NULL, NULL),
	(339, 2, 85, b'00000000', NULL, NULL, NULL, NULL),
	(340, 2, 86, b'00000000', NULL, NULL, NULL, NULL),
	(341, 2, 87, b'00000000', NULL, NULL, NULL, NULL),
	(342, 2, 88, b'00000000', NULL, NULL, NULL, NULL),
	(343, 2, 89, b'00000000', NULL, NULL, NULL, NULL),
	(344, 2, 90, b'00000000', NULL, NULL, NULL, NULL),
	(345, 2, 91, b'00000000', NULL, NULL, NULL, NULL),
	(346, 2, 92, b'00000000', NULL, NULL, NULL, NULL),
	(347, 3, 82, b'10000000', NULL, NULL, NULL, NULL),
	(348, 3, 83, b'00000000', NULL, NULL, NULL, NULL),
	(349, 3, 84, b'00000000', NULL, NULL, NULL, NULL),
	(350, 3, 85, b'00000000', NULL, NULL, NULL, NULL),
	(351, 3, 86, b'10000000', NULL, NULL, NULL, NULL),
	(352, 3, 87, b'10000000', NULL, NULL, NULL, NULL),
	(353, 3, 88, b'10000000', NULL, NULL, NULL, NULL),
	(354, 3, 89, b'10000000', NULL, NULL, NULL, NULL),
	(355, 3, 90, b'10000000', NULL, NULL, NULL, NULL),
	(356, 3, 91, b'10000000', NULL, NULL, NULL, NULL),
	(357, 3, 92, b'10000000', NULL, NULL, NULL, NULL),
	(358, 4, 82, b'00000000', NULL, NULL, NULL, NULL),
	(359, 4, 83, b'00000000', NULL, NULL, NULL, NULL),
	(360, 4, 84, b'00000000', NULL, NULL, NULL, NULL),
	(361, 4, 85, b'00000000', NULL, NULL, NULL, NULL),
	(362, 4, 86, b'00000000', NULL, NULL, NULL, NULL),
	(363, 4, 87, b'00000000', NULL, NULL, NULL, NULL),
	(364, 4, 88, b'00000000', NULL, NULL, NULL, NULL),
	(365, 4, 89, b'00000000', NULL, NULL, NULL, NULL),
	(366, 4, 90, b'00000000', NULL, NULL, NULL, NULL),
	(367, 4, 91, b'00000000', NULL, NULL, NULL, NULL),
	(368, 4, 92, b'00000000', NULL, NULL, NULL, NULL),
	(369, 1, 93, b'00000000', NULL, NULL, NULL, NULL),
	(370, 1, 94, b'00000000', NULL, NULL, NULL, NULL),
	(371, 1, 95, b'00000000', NULL, NULL, NULL, NULL),
	(372, 1, 96, b'00000000', NULL, NULL, NULL, NULL),
	(373, 1, 97, b'00000000', NULL, NULL, NULL, NULL),
	(374, 1, 98, b'00000000', NULL, NULL, NULL, NULL),
	(375, 1, 99, b'00000000', NULL, NULL, NULL, NULL),
	(376, 1, 100, b'00000000', NULL, NULL, NULL, NULL),
	(377, 1, 101, b'00000000', NULL, NULL, NULL, NULL),
	(378, 1, 102, b'00000000', NULL, NULL, NULL, NULL),
	(379, 1, 103, b'00000000', NULL, NULL, NULL, NULL),
	(380, 1, 104, b'00000000', NULL, NULL, NULL, NULL),
	(381, 1, 105, b'00000000', NULL, NULL, NULL, NULL),
	(382, 1, 106, b'00000000', NULL, NULL, NULL, NULL),
	(383, 1, 107, b'00000000', NULL, NULL, NULL, NULL),
	(384, 1, 108, b'00000000', NULL, NULL, NULL, NULL),
	(385, 1, 109, b'00000000', NULL, NULL, NULL, NULL),
	(386, 1, 110, b'00000000', NULL, NULL, NULL, NULL),
	(387, 1, 111, b'00000000', NULL, NULL, NULL, NULL),
	(388, 1, 112, b'00000000', NULL, NULL, NULL, NULL),
	(389, 1, 113, b'00000000', NULL, NULL, NULL, NULL),
	(390, 2, 93, b'00000000', NULL, NULL, NULL, NULL),
	(391, 2, 94, b'00000000', NULL, NULL, NULL, NULL),
	(392, 2, 95, b'00000000', NULL, NULL, NULL, NULL),
	(393, 2, 96, b'00000000', NULL, NULL, NULL, NULL),
	(394, 2, 97, b'00000000', NULL, NULL, NULL, NULL),
	(395, 2, 98, b'00000000', NULL, NULL, NULL, NULL),
	(396, 2, 99, b'00000000', NULL, NULL, NULL, NULL),
	(397, 2, 100, b'10000000', NULL, NULL, NULL, NULL),
	(398, 2, 101, b'10000000', NULL, NULL, NULL, NULL),
	(399, 2, 102, b'00000000', NULL, NULL, NULL, NULL),
	(400, 2, 103, b'00000000', NULL, NULL, NULL, NULL),
	(401, 2, 104, b'00000000', NULL, NULL, NULL, NULL),
	(402, 2, 105, b'00000000', NULL, NULL, NULL, NULL),
	(403, 2, 106, b'00000000', NULL, NULL, NULL, NULL),
	(404, 2, 107, b'00000000', NULL, NULL, NULL, NULL),
	(405, 2, 108, b'00000000', NULL, NULL, NULL, NULL),
	(406, 2, 109, b'00000000', NULL, NULL, NULL, NULL),
	(407, 2, 110, b'00000000', NULL, NULL, NULL, NULL),
	(408, 2, 111, b'00000000', NULL, NULL, NULL, NULL),
	(409, 2, 112, b'00000000', NULL, NULL, NULL, NULL),
	(410, 2, 113, b'00000000', NULL, NULL, NULL, NULL),
	(411, 3, 93, b'10000000', NULL, NULL, NULL, NULL),
	(412, 3, 94, b'10000000', NULL, NULL, NULL, NULL),
	(413, 3, 95, b'10000000', NULL, NULL, NULL, NULL),
	(414, 3, 96, b'10000000', NULL, NULL, NULL, NULL),
	(415, 3, 97, b'10000000', NULL, NULL, NULL, NULL),
	(416, 3, 98, b'10000000', NULL, NULL, NULL, NULL),
	(417, 3, 99, b'10000000', NULL, NULL, NULL, NULL),
	(418, 3, 100, b'10000000', NULL, NULL, NULL, NULL),
	(419, 3, 101, b'10000000', NULL, NULL, NULL, NULL),
	(420, 3, 102, b'10000000', NULL, NULL, NULL, NULL),
	(421, 3, 103, b'10000000', NULL, NULL, NULL, NULL),
	(422, 3, 104, b'10000000', NULL, NULL, NULL, NULL),
	(423, 3, 105, b'10000000', NULL, NULL, NULL, NULL),
	(424, 3, 106, b'10000000', NULL, NULL, NULL, NULL),
	(425, 3, 107, b'10000000', NULL, NULL, NULL, NULL),
	(426, 3, 108, b'10000000', NULL, NULL, NULL, NULL),
	(427, 3, 109, b'10000000', NULL, NULL, NULL, NULL),
	(428, 3, 110, b'10000000', NULL, NULL, NULL, NULL),
	(429, 3, 111, b'10000000', NULL, NULL, NULL, NULL),
	(430, 3, 112, b'10000000', NULL, NULL, NULL, NULL),
	(431, 3, 113, b'10000000', NULL, NULL, NULL, NULL),
	(432, 4, 93, b'00000000', NULL, NULL, NULL, NULL),
	(433, 4, 94, b'00000000', NULL, NULL, NULL, NULL),
	(434, 4, 95, b'00000000', NULL, NULL, NULL, NULL),
	(435, 4, 96, b'00000000', NULL, NULL, NULL, NULL),
	(436, 4, 97, b'00000000', NULL, NULL, NULL, NULL),
	(437, 4, 98, b'00000000', NULL, NULL, NULL, NULL),
	(438, 4, 99, b'00000000', NULL, NULL, NULL, NULL),
	(439, 4, 100, b'00000000', NULL, NULL, NULL, NULL),
	(440, 4, 101, b'00000000', NULL, NULL, NULL, NULL),
	(441, 4, 102, b'00000000', NULL, NULL, NULL, NULL),
	(442, 4, 103, b'00000000', NULL, NULL, NULL, NULL),
	(443, 4, 104, b'00000000', NULL, NULL, NULL, NULL),
	(444, 4, 105, b'00000000', NULL, NULL, NULL, NULL),
	(445, 4, 106, b'00000000', NULL, NULL, NULL, NULL),
	(446, 4, 107, b'00000000', NULL, NULL, NULL, NULL),
	(447, 4, 108, b'00000000', NULL, NULL, NULL, NULL),
	(448, 4, 109, b'00000000', NULL, NULL, NULL, NULL),
	(449, 4, 110, b'00000000', NULL, NULL, NULL, NULL),
	(450, 4, 111, b'00000000', NULL, NULL, NULL, NULL),
	(451, 4, 112, b'00000000', NULL, NULL, NULL, NULL),
	(452, 4, 113, b'00000000', NULL, NULL, NULL, NULL);


-- Dumping structure for table hrms.tbl_appl_func_role_visible
CREATE TABLE IF NOT EXISTS `tbl_appl_func_role_visible` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `ROLE_ID` bigint(16) NOT NULL,
  `FUNCTION_ID` bigint(16) NOT NULL,
  `VALUE` bit(1) NOT NULL,
  `CREATED_BY` bigint(16) DEFAULT NULL,
  `CREATED_DATE` datetime DEFAULT NULL,
  `MODIFIED_BY` bigint(16) DEFAULT NULL,
  `MODIFY_DATE` datetime DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_tbl_appl_func_role_visible_tbl_appl_roles` (`ROLE_ID`),
  KEY `FK_tbl_appl_func_role_visible_tbl_appl_functions` (`FUNCTION_ID`),
  KEY `FK_tbl_appl_func_role_visible_tbl_appl_user` (`CREATED_BY`),
  KEY `FK_tbl_appl_func_role_visible_tbl_appl_user_2` (`MODIFIED_BY`),
  CONSTRAINT `FK_tbl_appl_func_role_visible_tbl_appl_functions` FOREIGN KEY (`FUNCTION_ID`) REFERENCES `tbl_appl_functions` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_appl_func_role_visible_tbl_appl_roles` FOREIGN KEY (`ROLE_ID`) REFERENCES `tbl_appl_roles` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_appl_func_role_visible_tbl_appl_user` FOREIGN KEY (`CREATED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_appl_func_role_visible_tbl_appl_user_2` FOREIGN KEY (`MODIFIED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=453 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_appl_func_role_visible: ~452 rows (approximately)
INSERT INTO `tbl_appl_func_role_visible` (`ID`, `ROLE_ID`, `FUNCTION_ID`, `VALUE`, `CREATED_BY`, `CREATED_DATE`, `MODIFIED_BY`, `MODIFY_DATE`) VALUES
	(1, 1, 1, b'00000000', NULL, NULL, NULL, NULL),
	(2, 1, 2, b'00000000', NULL, NULL, NULL, NULL),
	(3, 1, 3, b'00000000', NULL, NULL, NULL, NULL),
	(4, 1, 4, b'00000000', NULL, NULL, NULL, NULL),
	(5, 1, 5, b'00000000', NULL, NULL, NULL, NULL),
	(6, 1, 6, b'00000000', NULL, NULL, NULL, NULL),
	(7, 1, 7, b'00000000', NULL, NULL, NULL, NULL),
	(8, 1, 8, b'00000000', NULL, NULL, NULL, NULL),
	(9, 1, 9, b'00000000', NULL, NULL, NULL, NULL),
	(10, 1, 10, b'00000000', NULL, NULL, NULL, NULL),
	(11, 1, 11, b'00000000', NULL, NULL, NULL, NULL),
	(12, 1, 12, b'00000000', NULL, NULL, NULL, NULL),
	(13, 1, 13, b'00000000', NULL, NULL, NULL, NULL),
	(14, 1, 14, b'00000000', NULL, NULL, NULL, NULL),
	(15, 1, 15, b'00000000', NULL, NULL, NULL, NULL),
	(16, 1, 16, b'00000000', NULL, NULL, NULL, NULL),
	(17, 1, 17, b'00000000', NULL, NULL, NULL, NULL),
	(18, 1, 18, b'00000000', NULL, NULL, NULL, NULL),
	(19, 1, 19, b'00000000', NULL, NULL, NULL, NULL),
	(20, 1, 20, b'00000000', NULL, NULL, NULL, NULL),
	(21, 1, 21, b'00000000', NULL, NULL, NULL, NULL),
	(22, 1, 22, b'00000000', NULL, NULL, NULL, NULL),
	(23, 1, 23, b'00000000', NULL, NULL, NULL, NULL),
	(24, 1, 24, b'00000000', NULL, NULL, NULL, NULL),
	(25, 1, 25, b'00000000', NULL, NULL, NULL, NULL),
	(26, 1, 26, b'00000000', NULL, NULL, NULL, NULL),
	(27, 1, 27, b'00000000', NULL, NULL, NULL, NULL),
	(28, 1, 28, b'00000000', NULL, NULL, NULL, NULL),
	(29, 1, 29, b'00000000', NULL, NULL, NULL, NULL),
	(30, 1, 30, b'00000000', NULL, NULL, NULL, NULL),
	(31, 2, 1, b'10000000', NULL, NULL, NULL, NULL),
	(32, 2, 2, b'10000000', NULL, NULL, NULL, NULL),
	(33, 2, 3, b'10000000', NULL, NULL, NULL, NULL),
	(34, 2, 4, b'10000000', NULL, NULL, NULL, NULL),
	(35, 2, 5, b'10000000', NULL, NULL, NULL, NULL),
	(36, 2, 6, b'10000000', NULL, NULL, NULL, NULL),
	(37, 2, 7, b'10000000', NULL, NULL, NULL, NULL),
	(38, 2, 8, b'10000000', NULL, NULL, NULL, NULL),
	(39, 2, 9, b'10000000', NULL, NULL, NULL, NULL),
	(40, 2, 10, b'10000000', NULL, NULL, NULL, NULL),
	(41, 2, 11, b'10000000', NULL, NULL, NULL, NULL),
	(42, 2, 12, b'10000000', NULL, NULL, NULL, NULL),
	(43, 2, 13, b'10000000', NULL, NULL, NULL, NULL),
	(44, 2, 14, b'10000000', NULL, NULL, NULL, NULL),
	(45, 2, 15, b'10000000', NULL, NULL, NULL, NULL),
	(46, 2, 16, b'10000000', NULL, NULL, NULL, NULL),
	(47, 2, 17, b'10000000', NULL, NULL, NULL, NULL),
	(48, 2, 18, b'10000000', NULL, NULL, NULL, NULL),
	(49, 2, 19, b'10000000', NULL, NULL, NULL, NULL),
	(50, 2, 20, b'10000000', NULL, NULL, NULL, NULL),
	(51, 2, 21, b'10000000', NULL, NULL, NULL, NULL),
	(52, 2, 22, b'10000000', NULL, NULL, NULL, NULL),
	(53, 2, 23, b'10000000', NULL, NULL, NULL, NULL),
	(54, 2, 24, b'10000000', NULL, NULL, NULL, NULL),
	(55, 2, 25, b'10000000', NULL, NULL, NULL, NULL),
	(56, 2, 26, b'10000000', NULL, NULL, NULL, NULL),
	(57, 2, 27, b'10000000', NULL, NULL, NULL, NULL),
	(58, 2, 28, b'10000000', NULL, NULL, NULL, NULL),
	(59, 2, 29, b'10000000', NULL, NULL, NULL, NULL),
	(60, 2, 30, b'10000000', NULL, NULL, NULL, NULL),
	(61, 3, 1, b'10000000', NULL, NULL, NULL, NULL),
	(62, 3, 2, b'10000000', NULL, NULL, NULL, NULL),
	(63, 3, 3, b'10000000', NULL, NULL, NULL, NULL),
	(64, 3, 4, b'10000000', NULL, NULL, NULL, NULL),
	(65, 3, 5, b'10000000', NULL, NULL, NULL, NULL),
	(66, 3, 6, b'10000000', NULL, NULL, NULL, NULL),
	(67, 3, 7, b'10000000', NULL, NULL, NULL, NULL),
	(68, 3, 8, b'10000000', NULL, NULL, NULL, NULL),
	(69, 3, 9, b'10000000', NULL, NULL, NULL, NULL),
	(70, 3, 10, b'10000000', NULL, NULL, NULL, NULL),
	(71, 3, 11, b'10000000', NULL, NULL, NULL, NULL),
	(72, 3, 12, b'10000000', NULL, NULL, NULL, NULL),
	(73, 3, 13, b'10000000', NULL, NULL, NULL, NULL),
	(74, 3, 14, b'10000000', NULL, NULL, NULL, NULL),
	(75, 3, 15, b'10000000', NULL, NULL, NULL, NULL),
	(76, 3, 16, b'10000000', NULL, NULL, NULL, NULL),
	(77, 3, 17, b'10000000', NULL, NULL, NULL, NULL),
	(78, 3, 18, b'10000000', NULL, NULL, NULL, NULL),
	(79, 3, 19, b'10000000', NULL, NULL, NULL, NULL),
	(80, 3, 20, b'10000000', NULL, NULL, NULL, NULL),
	(81, 3, 21, b'10000000', NULL, NULL, NULL, NULL),
	(82, 3, 22, b'10000000', NULL, NULL, NULL, NULL),
	(83, 3, 23, b'10000000', NULL, NULL, NULL, NULL),
	(84, 3, 24, b'10000000', NULL, NULL, NULL, NULL),
	(85, 3, 25, b'10000000', NULL, NULL, NULL, NULL),
	(86, 3, 26, b'10000000', NULL, NULL, NULL, NULL),
	(87, 3, 27, b'10000000', NULL, NULL, NULL, NULL),
	(88, 3, 28, b'10000000', NULL, NULL, NULL, NULL),
	(89, 3, 29, b'10000000', NULL, NULL, NULL, NULL),
	(90, 3, 30, b'10000000', NULL, NULL, NULL, NULL),
	(91, 4, 1, b'00000000', NULL, NULL, NULL, NULL),
	(92, 4, 2, b'00000000', NULL, NULL, NULL, NULL),
	(93, 4, 3, b'00000000', NULL, NULL, NULL, NULL),
	(94, 4, 4, b'00000000', NULL, NULL, NULL, NULL),
	(95, 4, 5, b'00000000', NULL, NULL, NULL, NULL),
	(96, 4, 6, b'00000000', NULL, NULL, NULL, NULL),
	(97, 4, 7, b'00000000', NULL, NULL, NULL, NULL),
	(98, 4, 8, b'00000000', NULL, NULL, NULL, NULL),
	(99, 4, 9, b'00000000', NULL, NULL, NULL, NULL),
	(100, 4, 10, b'00000000', NULL, NULL, NULL, NULL),
	(101, 4, 11, b'00000000', NULL, NULL, NULL, NULL),
	(102, 4, 12, b'00000000', NULL, NULL, NULL, NULL),
	(103, 4, 13, b'00000000', NULL, NULL, NULL, NULL),
	(104, 4, 14, b'00000000', NULL, NULL, NULL, NULL),
	(105, 4, 15, b'00000000', NULL, NULL, NULL, NULL),
	(106, 4, 16, b'00000000', NULL, NULL, NULL, NULL),
	(107, 4, 17, b'00000000', NULL, NULL, NULL, NULL),
	(108, 4, 18, b'00000000', NULL, NULL, NULL, NULL),
	(109, 4, 19, b'00000000', NULL, NULL, NULL, NULL),
	(110, 4, 20, b'00000000', NULL, NULL, NULL, NULL),
	(111, 4, 21, b'00000000', NULL, NULL, NULL, NULL),
	(112, 4, 22, b'00000000', NULL, NULL, NULL, NULL),
	(113, 4, 23, b'00000000', NULL, NULL, NULL, NULL),
	(114, 4, 24, b'00000000', NULL, NULL, NULL, NULL),
	(115, 4, 25, b'00000000', NULL, NULL, NULL, NULL),
	(116, 4, 26, b'00000000', NULL, NULL, NULL, NULL),
	(117, 4, 27, b'00000000', NULL, NULL, NULL, NULL),
	(118, 4, 28, b'00000000', NULL, NULL, NULL, NULL),
	(119, 4, 29, b'00000000', NULL, NULL, NULL, NULL),
	(120, 4, 30, b'00000000', NULL, NULL, NULL, NULL),
	(121, 1, 31, b'00000000', NULL, NULL, NULL, NULL),
	(122, 2, 31, b'10000000', NULL, NULL, NULL, NULL),
	(123, 3, 31, b'10000000', NULL, NULL, NULL, NULL),
	(124, 4, 31, b'00000000', NULL, NULL, NULL, NULL),
	(125, 1, 32, b'00000000', NULL, NULL, NULL, NULL),
	(126, 1, 33, b'00000000', NULL, NULL, NULL, NULL),
	(127, 1, 34, b'00000000', NULL, NULL, NULL, NULL),
	(128, 1, 35, b'00000000', NULL, NULL, NULL, NULL),
	(129, 1, 36, b'00000000', NULL, NULL, NULL, NULL),
	(130, 1, 37, b'00000000', NULL, NULL, NULL, NULL),
	(131, 1, 38, b'00000000', NULL, NULL, NULL, NULL),
	(132, 1, 39, b'00000000', NULL, NULL, NULL, NULL),
	(133, 1, 40, b'00000000', NULL, NULL, NULL, NULL),
	(134, 2, 32, b'10000000', NULL, NULL, NULL, NULL),
	(135, 2, 33, b'10000000', NULL, NULL, NULL, NULL),
	(136, 2, 34, b'10000000', NULL, NULL, NULL, NULL),
	(137, 2, 35, b'10000000', NULL, NULL, NULL, NULL),
	(138, 2, 36, b'10000000', NULL, NULL, NULL, NULL),
	(139, 2, 37, b'10000000', NULL, NULL, NULL, NULL),
	(140, 2, 38, b'10000000', NULL, NULL, NULL, NULL),
	(141, 2, 39, b'10000000', NULL, NULL, NULL, NULL),
	(142, 2, 40, b'10000000', NULL, NULL, NULL, NULL),
	(143, 3, 32, b'10000000', NULL, NULL, NULL, NULL),
	(144, 3, 33, b'10000000', NULL, NULL, NULL, NULL),
	(145, 3, 34, b'10000000', NULL, NULL, NULL, NULL),
	(146, 3, 35, b'10000000', NULL, NULL, NULL, NULL),
	(147, 3, 36, b'10000000', NULL, NULL, NULL, NULL),
	(148, 3, 37, b'10000000', NULL, NULL, NULL, NULL),
	(149, 3, 38, b'10000000', NULL, NULL, NULL, NULL),
	(150, 3, 39, b'10000000', NULL, NULL, NULL, NULL),
	(151, 3, 40, b'10000000', NULL, NULL, NULL, NULL),
	(152, 4, 32, b'00000000', NULL, NULL, NULL, NULL),
	(153, 4, 33, b'00000000', NULL, NULL, NULL, NULL),
	(154, 4, 34, b'00000000', NULL, NULL, NULL, NULL),
	(155, 4, 35, b'00000000', NULL, NULL, NULL, NULL),
	(156, 4, 36, b'00000000', NULL, NULL, NULL, NULL),
	(157, 4, 37, b'00000000', NULL, NULL, NULL, NULL),
	(158, 4, 38, b'00000000', NULL, NULL, NULL, NULL),
	(159, 4, 39, b'00000000', NULL, NULL, NULL, NULL),
	(160, 4, 40, b'00000000', NULL, NULL, NULL, NULL),
	(161, 1, 41, b'00000000', NULL, NULL, NULL, NULL),
	(162, 1, 42, b'00000000', NULL, NULL, NULL, NULL),
	(163, 1, 43, b'00000000', NULL, NULL, NULL, NULL),
	(164, 1, 44, b'00000000', NULL, NULL, NULL, NULL),
	(165, 1, 45, b'00000000', NULL, NULL, NULL, NULL),
	(166, 1, 46, b'00000000', NULL, NULL, NULL, NULL),
	(167, 1, 47, b'00000000', NULL, NULL, NULL, NULL),
	(168, 2, 41, b'10000000', NULL, NULL, NULL, NULL),
	(169, 2, 42, b'10000000', NULL, NULL, NULL, NULL),
	(170, 2, 43, b'10000000', NULL, NULL, NULL, NULL),
	(171, 2, 44, b'10000000', NULL, NULL, NULL, NULL),
	(172, 2, 45, b'10000000', NULL, NULL, NULL, NULL),
	(173, 2, 46, b'10000000', NULL, NULL, NULL, NULL),
	(174, 2, 47, b'10000000', NULL, NULL, NULL, NULL),
	(175, 3, 41, b'10000000', NULL, NULL, NULL, NULL),
	(176, 3, 42, b'10000000', NULL, NULL, NULL, NULL),
	(177, 3, 43, b'10000000', NULL, NULL, NULL, NULL),
	(178, 3, 44, b'10000000', NULL, NULL, NULL, NULL),
	(179, 3, 45, b'10000000', NULL, NULL, NULL, NULL),
	(180, 3, 46, b'10000000', NULL, NULL, NULL, NULL),
	(181, 3, 47, b'10000000', NULL, NULL, NULL, NULL),
	(182, 4, 41, b'00000000', NULL, NULL, NULL, NULL),
	(183, 4, 42, b'00000000', NULL, NULL, NULL, NULL),
	(184, 4, 43, b'00000000', NULL, NULL, NULL, NULL),
	(185, 4, 44, b'00000000', NULL, NULL, NULL, NULL),
	(186, 4, 45, b'00000000', NULL, NULL, NULL, NULL),
	(187, 4, 46, b'00000000', NULL, NULL, NULL, NULL),
	(188, 4, 47, b'00000000', NULL, NULL, NULL, NULL),
	(189, 1, 48, b'00000000', NULL, NULL, NULL, NULL),
	(190, 1, 49, b'00000000', NULL, NULL, NULL, NULL),
	(191, 1, 50, b'00000000', NULL, NULL, NULL, NULL),
	(192, 1, 51, b'00000000', NULL, NULL, NULL, NULL),
	(193, 1, 52, b'00000000', NULL, NULL, NULL, NULL),
	(194, 1, 53, b'00000000', NULL, NULL, NULL, NULL),
	(195, 2, 48, b'10000000', NULL, NULL, NULL, NULL),
	(196, 2, 49, b'10000000', NULL, NULL, NULL, NULL),
	(197, 2, 50, b'10000000', NULL, NULL, NULL, NULL),
	(198, 2, 51, b'10000000', NULL, NULL, NULL, NULL),
	(199, 2, 52, b'10000000', NULL, NULL, NULL, NULL),
	(200, 2, 53, b'10000000', NULL, NULL, NULL, NULL),
	(201, 3, 48, b'10000000', NULL, NULL, NULL, NULL),
	(202, 3, 49, b'10000000', NULL, NULL, NULL, NULL),
	(203, 3, 50, b'10000000', NULL, NULL, NULL, NULL),
	(204, 3, 51, b'10000000', NULL, NULL, NULL, NULL),
	(205, 3, 52, b'10000000', NULL, NULL, NULL, NULL),
	(206, 3, 53, b'10000000', NULL, NULL, NULL, NULL),
	(207, 4, 48, b'00000000', NULL, NULL, NULL, NULL),
	(208, 4, 49, b'00000000', NULL, NULL, NULL, NULL),
	(209, 4, 50, b'00000000', NULL, NULL, NULL, NULL),
	(210, 4, 51, b'00000000', NULL, NULL, NULL, NULL),
	(211, 4, 52, b'00000000', NULL, NULL, NULL, NULL),
	(212, 4, 53, b'00000000', NULL, NULL, NULL, NULL),
	(213, 1, 54, b'00000000', NULL, NULL, NULL, NULL),
	(214, 1, 55, b'00000000', NULL, NULL, NULL, NULL),
	(215, 1, 56, b'00000000', NULL, NULL, NULL, NULL),
	(216, 1, 57, b'00000000', NULL, NULL, NULL, NULL),
	(217, 1, 58, b'00000000', NULL, NULL, NULL, NULL),
	(218, 1, 59, b'00000000', NULL, NULL, NULL, NULL),
	(219, 1, 60, b'00000000', NULL, NULL, NULL, NULL),
	(220, 1, 61, b'00000000', NULL, NULL, NULL, NULL),
	(221, 2, 54, b'10000000', NULL, NULL, NULL, NULL),
	(222, 2, 55, b'10000000', NULL, NULL, NULL, NULL),
	(223, 2, 56, b'10000000', NULL, NULL, NULL, NULL),
	(224, 2, 57, b'10000000', NULL, NULL, NULL, NULL),
	(225, 2, 58, b'10000000', NULL, NULL, NULL, NULL),
	(226, 2, 59, b'10000000', NULL, NULL, NULL, NULL),
	(227, 2, 60, b'10000000', NULL, NULL, NULL, NULL),
	(228, 2, 61, b'10000000', NULL, NULL, NULL, NULL),
	(229, 3, 54, b'10000000', NULL, NULL, NULL, NULL),
	(230, 3, 55, b'10000000', NULL, NULL, NULL, NULL),
	(231, 3, 56, b'10000000', NULL, NULL, NULL, NULL),
	(232, 3, 57, b'10000000', NULL, NULL, NULL, NULL),
	(233, 3, 58, b'10000000', NULL, NULL, NULL, NULL),
	(234, 3, 59, b'10000000', NULL, NULL, NULL, NULL),
	(235, 3, 60, b'10000000', NULL, NULL, NULL, NULL),
	(236, 3, 61, b'10000000', NULL, NULL, NULL, NULL),
	(237, 4, 54, b'00000000', NULL, NULL, NULL, NULL),
	(238, 4, 55, b'00000000', NULL, NULL, NULL, NULL),
	(239, 4, 56, b'00000000', NULL, NULL, NULL, NULL),
	(240, 4, 57, b'00000000', NULL, NULL, NULL, NULL),
	(241, 4, 58, b'00000000', NULL, NULL, NULL, NULL),
	(242, 4, 59, b'00000000', NULL, NULL, NULL, NULL),
	(243, 4, 60, b'00000000', NULL, NULL, NULL, NULL),
	(244, 4, 61, b'00000000', NULL, NULL, NULL, NULL),
	(245, 1, 62, b'00000000', NULL, NULL, NULL, NULL),
	(246, 1, 63, b'00000000', NULL, NULL, NULL, NULL),
	(247, 1, 64, b'00000000', NULL, NULL, NULL, NULL),
	(248, 1, 65, b'00000000', NULL, NULL, NULL, NULL),
	(249, 1, 66, b'00000000', NULL, NULL, NULL, NULL),
	(250, 2, 62, b'10000000', NULL, NULL, NULL, NULL),
	(251, 2, 63, b'10000000', NULL, NULL, NULL, NULL),
	(252, 2, 64, b'10000000', NULL, NULL, NULL, NULL),
	(253, 2, 65, b'10000000', NULL, NULL, NULL, NULL),
	(254, 2, 66, b'10000000', NULL, NULL, NULL, NULL),
	(255, 3, 62, b'10000000', NULL, NULL, NULL, NULL),
	(256, 3, 63, b'10000000', NULL, NULL, NULL, NULL),
	(257, 3, 64, b'10000000', NULL, NULL, NULL, NULL),
	(258, 3, 65, b'10000000', NULL, NULL, NULL, NULL),
	(259, 3, 66, b'10000000', NULL, NULL, NULL, NULL),
	(260, 4, 62, b'00000000', NULL, NULL, NULL, NULL),
	(261, 4, 63, b'00000000', NULL, NULL, NULL, NULL),
	(262, 4, 64, b'00000000', NULL, NULL, NULL, NULL),
	(263, 4, 65, b'00000000', NULL, NULL, NULL, NULL),
	(264, 4, 66, b'00000000', NULL, NULL, NULL, NULL),
	(265, 1, 67, b'00000000', NULL, NULL, NULL, NULL),
	(266, 1, 68, b'00000000', NULL, NULL, NULL, NULL),
	(267, 1, 69, b'00000000', NULL, NULL, NULL, NULL),
	(268, 1, 70, b'00000000', NULL, NULL, NULL, NULL),
	(269, 2, 67, b'10000000', NULL, NULL, NULL, NULL),
	(270, 2, 68, b'10000000', NULL, NULL, NULL, NULL),
	(271, 2, 69, b'10000000', NULL, NULL, NULL, NULL),
	(272, 2, 70, b'10000000', NULL, NULL, NULL, NULL),
	(273, 3, 67, b'10000000', NULL, NULL, NULL, NULL),
	(274, 3, 68, b'10000000', NULL, NULL, NULL, NULL),
	(275, 3, 69, b'10000000', NULL, NULL, NULL, NULL),
	(276, 3, 70, b'10000000', NULL, NULL, NULL, NULL),
	(277, 4, 67, b'00000000', NULL, NULL, NULL, NULL),
	(278, 4, 68, b'00000000', NULL, NULL, NULL, NULL),
	(279, 4, 69, b'00000000', NULL, NULL, NULL, NULL),
	(280, 4, 70, b'00000000', NULL, NULL, NULL, NULL),
	(281, 1, 71, b'00000000', NULL, NULL, NULL, NULL),
	(282, 1, 72, b'00000000', NULL, NULL, NULL, NULL),
	(283, 1, 73, b'00000000', NULL, NULL, NULL, NULL),
	(284, 1, 74, b'00000000', NULL, NULL, NULL, NULL),
	(285, 1, 75, b'00000000', NULL, NULL, NULL, NULL),
	(286, 1, 76, b'00000000', NULL, NULL, NULL, NULL),
	(287, 1, 77, b'00000000', NULL, NULL, NULL, NULL),
	(288, 1, 78, b'00000000', NULL, NULL, NULL, NULL),
	(289, 2, 71, b'10000000', NULL, NULL, NULL, NULL),
	(290, 2, 72, b'10000000', NULL, NULL, NULL, NULL),
	(291, 2, 73, b'10000000', NULL, NULL, NULL, NULL),
	(292, 2, 74, b'10000000', NULL, NULL, NULL, NULL),
	(293, 2, 75, b'10000000', NULL, NULL, NULL, NULL),
	(294, 2, 76, b'10000000', NULL, NULL, NULL, NULL),
	(295, 2, 77, b'10000000', NULL, NULL, NULL, NULL),
	(296, 2, 78, b'10000000', NULL, NULL, NULL, NULL),
	(297, 3, 71, b'10000000', NULL, NULL, NULL, NULL),
	(298, 3, 72, b'10000000', NULL, NULL, NULL, NULL),
	(299, 3, 73, b'10000000', NULL, NULL, NULL, NULL),
	(300, 3, 74, b'10000000', NULL, NULL, NULL, NULL),
	(301, 3, 75, b'10000000', NULL, NULL, NULL, NULL),
	(302, 3, 76, b'10000000', NULL, NULL, NULL, NULL),
	(303, 3, 77, b'10000000', NULL, NULL, NULL, NULL),
	(304, 3, 78, b'10000000', NULL, NULL, NULL, NULL),
	(305, 4, 71, b'00000000', NULL, NULL, NULL, NULL),
	(306, 4, 72, b'00000000', NULL, NULL, NULL, NULL),
	(307, 4, 73, b'00000000', NULL, NULL, NULL, NULL),
	(308, 4, 74, b'00000000', NULL, NULL, NULL, NULL),
	(309, 4, 75, b'00000000', NULL, NULL, NULL, NULL),
	(310, 4, 76, b'00000000', NULL, NULL, NULL, NULL),
	(311, 4, 77, b'00000000', NULL, NULL, NULL, NULL),
	(312, 4, 78, b'00000000', NULL, NULL, NULL, NULL),
	(313, 1, 79, b'00000000', NULL, NULL, NULL, NULL),
	(314, 1, 80, b'00000000', NULL, NULL, NULL, NULL),
	(315, 1, 81, b'00000000', NULL, NULL, NULL, NULL),
	(316, 2, 79, b'10000000', NULL, NULL, NULL, NULL),
	(317, 2, 80, b'10000000', NULL, NULL, NULL, NULL),
	(318, 2, 81, b'10000000', NULL, NULL, NULL, NULL),
	(319, 3, 79, b'10000000', NULL, NULL, NULL, NULL),
	(320, 3, 80, b'10000000', NULL, NULL, NULL, NULL),
	(321, 3, 81, b'10000000', NULL, NULL, NULL, NULL),
	(322, 4, 79, b'00000000', NULL, NULL, NULL, NULL),
	(323, 4, 80, b'00000000', NULL, NULL, NULL, NULL),
	(324, 4, 81, b'00000000', NULL, NULL, NULL, NULL),
	(325, 1, 82, b'00000000', NULL, NULL, NULL, NULL),
	(326, 1, 83, b'00000000', NULL, NULL, NULL, NULL),
	(327, 1, 84, b'00000000', NULL, NULL, NULL, NULL),
	(328, 1, 85, b'00000000', NULL, NULL, NULL, NULL),
	(329, 1, 86, b'00000000', NULL, NULL, NULL, NULL),
	(330, 1, 87, b'00000000', NULL, NULL, NULL, NULL),
	(331, 1, 88, b'00000000', NULL, NULL, NULL, NULL),
	(332, 1, 89, b'00000000', NULL, NULL, NULL, NULL),
	(333, 1, 90, b'00000000', NULL, NULL, NULL, NULL),
	(334, 1, 91, b'00000000', NULL, NULL, NULL, NULL),
	(335, 1, 92, b'00000000', NULL, NULL, NULL, NULL),
	(336, 2, 82, b'10000000', NULL, NULL, NULL, NULL),
	(337, 2, 83, b'10000000', NULL, NULL, NULL, NULL),
	(338, 2, 84, b'10000000', NULL, NULL, NULL, NULL),
	(339, 2, 85, b'10000000', NULL, NULL, NULL, NULL),
	(340, 2, 86, b'10000000', NULL, NULL, NULL, NULL),
	(341, 2, 87, b'10000000', NULL, NULL, NULL, NULL),
	(342, 2, 88, b'10000000', NULL, NULL, NULL, NULL),
	(343, 2, 89, b'10000000', NULL, NULL, NULL, NULL),
	(344, 2, 90, b'10000000', NULL, NULL, NULL, NULL),
	(345, 2, 91, b'10000000', NULL, NULL, NULL, NULL),
	(346, 2, 92, b'10000000', NULL, NULL, NULL, NULL),
	(347, 3, 82, b'10000000', NULL, NULL, NULL, NULL),
	(348, 3, 83, b'10000000', NULL, NULL, NULL, NULL),
	(349, 3, 84, b'10000000', NULL, NULL, NULL, NULL),
	(350, 3, 85, b'10000000', NULL, NULL, NULL, NULL),
	(351, 3, 86, b'10000000', NULL, NULL, NULL, NULL),
	(352, 3, 87, b'10000000', NULL, NULL, NULL, NULL),
	(353, 3, 88, b'10000000', NULL, NULL, NULL, NULL),
	(354, 3, 89, b'10000000', NULL, NULL, NULL, NULL),
	(355, 3, 90, b'10000000', NULL, NULL, NULL, NULL),
	(356, 3, 91, b'10000000', NULL, NULL, NULL, NULL),
	(357, 3, 92, b'10000000', NULL, NULL, NULL, NULL),
	(358, 4, 82, b'00000000', NULL, NULL, NULL, NULL),
	(359, 4, 83, b'00000000', NULL, NULL, NULL, NULL),
	(360, 4, 84, b'00000000', NULL, NULL, NULL, NULL),
	(361, 4, 85, b'00000000', NULL, NULL, NULL, NULL),
	(362, 4, 86, b'00000000', NULL, NULL, NULL, NULL),
	(363, 4, 87, b'00000000', NULL, NULL, NULL, NULL),
	(364, 4, 88, b'00000000', NULL, NULL, NULL, NULL),
	(365, 4, 89, b'00000000', NULL, NULL, NULL, NULL),
	(366, 4, 90, b'00000000', NULL, NULL, NULL, NULL),
	(367, 4, 91, b'00000000', NULL, NULL, NULL, NULL),
	(368, 4, 92, b'00000000', NULL, NULL, NULL, NULL),
	(369, 1, 93, b'00000000', NULL, NULL, NULL, NULL),
	(370, 1, 94, b'00000000', NULL, NULL, NULL, NULL),
	(371, 1, 95, b'00000000', NULL, NULL, NULL, NULL),
	(372, 1, 96, b'00000000', NULL, NULL, NULL, NULL),
	(373, 1, 97, b'00000000', NULL, NULL, NULL, NULL),
	(374, 1, 98, b'00000000', NULL, NULL, NULL, NULL),
	(375, 1, 99, b'00000000', NULL, NULL, NULL, NULL),
	(376, 1, 100, b'00000000', NULL, NULL, NULL, NULL),
	(377, 1, 101, b'00000000', NULL, NULL, NULL, NULL),
	(378, 1, 102, b'00000000', NULL, NULL, NULL, NULL),
	(379, 1, 103, b'00000000', NULL, NULL, NULL, NULL),
	(380, 1, 104, b'00000000', NULL, NULL, NULL, NULL),
	(381, 1, 105, b'00000000', NULL, NULL, NULL, NULL),
	(382, 1, 106, b'00000000', NULL, NULL, NULL, NULL),
	(383, 1, 107, b'00000000', NULL, NULL, NULL, NULL),
	(384, 1, 108, b'00000000', NULL, NULL, NULL, NULL),
	(385, 1, 109, b'00000000', NULL, NULL, NULL, NULL),
	(386, 1, 110, b'00000000', NULL, NULL, NULL, NULL),
	(387, 1, 111, b'00000000', NULL, NULL, NULL, NULL),
	(388, 1, 112, b'00000000', NULL, NULL, NULL, NULL),
	(389, 1, 113, b'00000000', NULL, NULL, NULL, NULL),
	(390, 2, 93, b'10000000', NULL, NULL, NULL, NULL),
	(391, 2, 94, b'10000000', NULL, NULL, NULL, NULL),
	(392, 2, 95, b'10000000', NULL, NULL, NULL, NULL),
	(393, 2, 96, b'10000000', NULL, NULL, NULL, NULL),
	(394, 2, 97, b'10000000', NULL, NULL, NULL, NULL),
	(395, 2, 98, b'10000000', NULL, NULL, NULL, NULL),
	(396, 2, 99, b'10000000', NULL, NULL, NULL, NULL),
	(397, 2, 100, b'10000000', NULL, NULL, NULL, NULL),
	(398, 2, 101, b'10000000', NULL, NULL, NULL, NULL),
	(399, 2, 102, b'10000000', NULL, NULL, NULL, NULL),
	(400, 2, 103, b'10000000', NULL, NULL, NULL, NULL),
	(401, 2, 104, b'10000000', NULL, NULL, NULL, NULL),
	(402, 2, 105, b'10000000', NULL, NULL, NULL, NULL),
	(403, 2, 106, b'10000000', NULL, NULL, NULL, NULL),
	(404, 2, 107, b'10000000', NULL, NULL, NULL, NULL),
	(405, 2, 108, b'10000000', NULL, NULL, NULL, NULL),
	(406, 2, 109, b'10000000', NULL, NULL, NULL, NULL),
	(407, 2, 110, b'10000000', NULL, NULL, NULL, NULL),
	(408, 2, 111, b'10000000', NULL, NULL, NULL, NULL),
	(409, 2, 112, b'10000000', NULL, NULL, NULL, NULL),
	(410, 2, 113, b'10000000', NULL, NULL, NULL, NULL),
	(411, 3, 93, b'10000000', NULL, NULL, NULL, NULL),
	(412, 3, 94, b'10000000', NULL, NULL, NULL, NULL),
	(413, 3, 95, b'10000000', NULL, NULL, NULL, NULL),
	(414, 3, 96, b'10000000', NULL, NULL, NULL, NULL),
	(415, 3, 97, b'10000000', NULL, NULL, NULL, NULL),
	(416, 3, 98, b'10000000', NULL, NULL, NULL, NULL),
	(417, 3, 99, b'10000000', NULL, NULL, NULL, NULL),
	(418, 3, 100, b'10000000', NULL, NULL, NULL, NULL),
	(419, 3, 101, b'10000000', NULL, NULL, NULL, NULL),
	(420, 3, 102, b'10000000', NULL, NULL, NULL, NULL),
	(421, 3, 103, b'10000000', NULL, NULL, NULL, NULL),
	(422, 3, 104, b'10000000', NULL, NULL, NULL, NULL),
	(423, 3, 105, b'10000000', NULL, NULL, NULL, NULL),
	(424, 3, 106, b'10000000', NULL, NULL, NULL, NULL),
	(425, 3, 107, b'10000000', NULL, NULL, NULL, NULL),
	(426, 3, 108, b'10000000', NULL, NULL, NULL, NULL),
	(427, 3, 109, b'10000000', NULL, NULL, NULL, NULL),
	(428, 3, 110, b'10000000', NULL, NULL, NULL, NULL),
	(429, 3, 111, b'10000000', NULL, NULL, NULL, NULL),
	(430, 3, 112, b'10000000', NULL, NULL, NULL, NULL),
	(431, 3, 113, b'10000000', NULL, NULL, NULL, NULL),
	(432, 4, 93, b'00000000', NULL, NULL, NULL, NULL),
	(433, 4, 94, b'00000000', NULL, NULL, NULL, NULL),
	(434, 4, 95, b'00000000', NULL, NULL, NULL, NULL),
	(435, 4, 96, b'00000000', NULL, NULL, NULL, NULL),
	(436, 4, 97, b'00000000', NULL, NULL, NULL, NULL),
	(437, 4, 98, b'00000000', NULL, NULL, NULL, NULL),
	(438, 4, 99, b'00000000', NULL, NULL, NULL, NULL),
	(439, 4, 100, b'00000000', NULL, NULL, NULL, NULL),
	(440, 4, 101, b'00000000', NULL, NULL, NULL, NULL),
	(441, 4, 102, b'00000000', NULL, NULL, NULL, NULL),
	(442, 4, 103, b'00000000', NULL, NULL, NULL, NULL),
	(443, 4, 104, b'00000000', NULL, NULL, NULL, NULL),
	(444, 4, 105, b'00000000', NULL, NULL, NULL, NULL),
	(445, 4, 106, b'00000000', NULL, NULL, NULL, NULL),
	(446, 4, 107, b'00000000', NULL, NULL, NULL, NULL),
	(447, 4, 108, b'00000000', NULL, NULL, NULL, NULL),
	(448, 4, 109, b'00000000', NULL, NULL, NULL, NULL),
	(449, 4, 110, b'00000000', NULL, NULL, NULL, NULL),
	(450, 4, 111, b'00000000', NULL, NULL, NULL, NULL),
	(451, 4, 112, b'00000000', NULL, NULL, NULL, NULL),
	(452, 4, 113, b'00000000', NULL, NULL, NULL, NULL);


-- Dumping structure for table hrms.tbl_appl_page
CREATE TABLE IF NOT EXISTS `tbl_appl_page` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `DESCRIPTION` varchar(32) NOT NULL,
  `CREATED_BY` bigint(16) DEFAULT NULL,
  `CREATED_DATE` datetime DEFAULT NULL,
  `MODIFIED_BY` bigint(16) DEFAULT NULL,
  `MODIFY_DATE` datetime DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_tbl_appl_page_tbl_appl_user` (`CREATED_BY`),
  KEY `FK_tbl_appl_page_tbl_appl_user_2` (`MODIFIED_BY`),
  CONSTRAINT `FK_tbl_appl_page_tbl_appl_user` FOREIGN KEY (`CREATED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_appl_page_tbl_appl_user_2` FOREIGN KEY (`MODIFIED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_appl_page: ~26 rows (approximately)
INSERT INTO `tbl_appl_page` (`ID`, `DESCRIPTION`, `CREATED_BY`, `CREATED_DATE`, `MODIFIED_BY`, `MODIFY_DATE`) VALUES
	(1, 'Özlük Bilgileri', NULL, '2012-03-14 20:31:55', NULL, NULL),
	(2, 'Performans Değerlendirme', NULL, '2012-03-17 17:13:38', NULL, NULL),
	(3, 'Sorumluluklar/Yetkinlikler', NULL, NULL, NULL, NULL),
	(4, 'Hedeflere Ulaşım', NULL, NULL, NULL, NULL),
	(5, 'Performans Değ ve Gel', NULL, NULL, NULL, NULL),
	(6, 'Çalışan Değerlendirme Formu', NULL, NULL, NULL, NULL),
	(7, 'Yönetici Değerlendirme Formu', NULL, NULL, NULL, NULL),
	(8, 'Çalışanlar', NULL, NULL, NULL, NULL),
	(9, 'Çalışanlarım', NULL, NULL, NULL, NULL),
	(10, 'Raporlama', NULL, NULL, NULL, NULL),
	(11, 'Eğitim Bilgileri', NULL, NULL, NULL, NULL),
	(12, 'İş Tecrübeleri', NULL, NULL, NULL, NULL),
	(13, 'Diller', NULL, NULL, NULL, NULL),
	(14, 'Projeler', NULL, NULL, NULL, NULL),
	(15, 'Proje Amaçları', NULL, NULL, NULL, NULL),
	(16, 'Sertifikalar', NULL, NULL, NULL, NULL),
	(17, 'Teknik Bilgiler', NULL, NULL, NULL, NULL),
	(18, 'Eğitimler', NULL, NULL, NULL, NULL),
	(19, 'Ekler', NULL, NULL, NULL, NULL),
	(20, 'Sorumluluklar', NULL, NULL, NULL, NULL),
	(21, 'Yetkinlikler', NULL, NULL, NULL, NULL),
	(22, 'Yönetim', NULL, NULL, NULL, NULL),
	(23, 'Kullanıcılar', NULL, NULL, NULL, NULL),
	(24, 'Kullanıcılara Rol Atama', NULL, NULL, NULL, NULL),
	(25, 'Rol Ekleme / Değiştirme', NULL, NULL, NULL, NULL),
	(26, 'Özlük Bilgilerim', NULL, NULL, NULL, NULL);


-- Dumping structure for table hrms.tbl_appl_page_func
CREATE TABLE IF NOT EXISTS `tbl_appl_page_func` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `PAGE_ID` bigint(16) NOT NULL,
  `FUNC_ID` bigint(16) NOT NULL,
  `CREATED_BY` bigint(16) DEFAULT NULL,
  `CREATED_DATE` datetime DEFAULT NULL,
  `MODIFIED_BY` bigint(16) DEFAULT NULL,
  `MODIFY_DATE` datetime DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_tbl_appl_page_func_tbl_appl_page` (`PAGE_ID`),
  KEY `FK_tbl_appl_page_func_tbl_appl_functions` (`FUNC_ID`),
  KEY `FK_tbl_appl_page_func_tbl_appl_user` (`CREATED_BY`),
  KEY `FK_tbl_appl_page_func_tbl_appl_user_2` (`MODIFIED_BY`),
  CONSTRAINT `FK_tbl_appl_page_func_tbl_appl_functions` FOREIGN KEY (`FUNC_ID`) REFERENCES `tbl_appl_functions` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_appl_page_func_tbl_appl_page` FOREIGN KEY (`PAGE_ID`) REFERENCES `tbl_appl_page` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_appl_page_func_tbl_appl_user` FOREIGN KEY (`CREATED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_appl_page_func_tbl_appl_user_2` FOREIGN KEY (`MODIFIED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=114 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_appl_page_func: ~113 rows (approximately)
INSERT INTO `tbl_appl_page_func` (`ID`, `PAGE_ID`, `FUNC_ID`, `CREATED_BY`, `CREATED_DATE`, `MODIFIED_BY`, `MODIFY_DATE`) VALUES
	(1, 26, 1, NULL, NULL, NULL, NULL),
	(2, 26, 2, NULL, NULL, NULL, NULL),
	(3, 26, 3, NULL, NULL, NULL, NULL),
	(4, 26, 4, NULL, NULL, NULL, NULL),
	(5, 26, 5, NULL, NULL, NULL, NULL),
	(6, 26, 6, NULL, NULL, NULL, NULL),
	(7, 26, 7, NULL, NULL, NULL, NULL),
	(8, 26, 8, NULL, NULL, NULL, NULL),
	(9, 26, 9, NULL, NULL, NULL, NULL),
	(10, 26, 10, NULL, NULL, NULL, NULL),
	(11, 26, 11, NULL, NULL, NULL, NULL),
	(12, 26, 12, NULL, NULL, NULL, NULL),
	(13, 26, 13, NULL, NULL, NULL, NULL),
	(14, 26, 14, NULL, NULL, NULL, NULL),
	(15, 26, 15, NULL, NULL, NULL, NULL),
	(16, 26, 16, NULL, NULL, NULL, NULL),
	(17, 26, 17, NULL, NULL, NULL, NULL),
	(18, 26, 18, NULL, NULL, NULL, NULL),
	(19, 26, 19, NULL, NULL, NULL, NULL),
	(20, 26, 20, NULL, NULL, NULL, NULL),
	(21, 26, 21, NULL, NULL, NULL, NULL),
	(22, 26, 22, NULL, NULL, NULL, NULL),
	(23, 26, 23, NULL, NULL, NULL, NULL),
	(24, 26, 24, NULL, NULL, NULL, NULL),
	(25, 26, 25, NULL, NULL, NULL, NULL),
	(26, 26, 26, NULL, NULL, NULL, NULL),
	(27, 26, 27, NULL, NULL, NULL, NULL),
	(28, 26, 28, NULL, NULL, NULL, NULL),
	(29, 26, 29, NULL, NULL, NULL, NULL),
	(30, 26, 30, NULL, NULL, NULL, NULL),
	(31, 26, 31, NULL, NULL, NULL, NULL),
	(32, 26, 32, NULL, NULL, NULL, NULL),
	(33, 26, 33, NULL, NULL, NULL, NULL),
	(34, 26, 34, NULL, NULL, NULL, NULL),
	(35, 26, 35, NULL, NULL, NULL, NULL),
	(36, 26, 36, NULL, NULL, NULL, NULL),
	(37, 26, 37, NULL, NULL, NULL, NULL),
	(38, 26, 38, NULL, NULL, NULL, NULL),
	(39, 26, 39, NULL, NULL, NULL, NULL),
	(40, 26, 40, NULL, NULL, NULL, NULL),
	(41, 26, 41, NULL, NULL, NULL, NULL),
	(42, 26, 42, NULL, NULL, NULL, NULL),
	(43, 26, 43, NULL, NULL, NULL, NULL),
	(44, 26, 44, NULL, NULL, NULL, NULL),
	(45, 26, 45, NULL, NULL, NULL, NULL),
	(46, 26, 46, NULL, NULL, NULL, NULL),
	(47, 26, 47, NULL, NULL, NULL, NULL),
	(48, 26, 48, NULL, NULL, NULL, NULL),
	(49, 26, 49, NULL, NULL, NULL, NULL),
	(50, 26, 50, NULL, NULL, NULL, NULL),
	(51, 26, 51, NULL, NULL, NULL, NULL),
	(52, 26, 52, NULL, NULL, NULL, NULL),
	(53, 26, 53, NULL, NULL, NULL, NULL),
	(54, 26, 54, NULL, NULL, NULL, NULL),
	(55, 26, 55, NULL, NULL, NULL, NULL),
	(56, 26, 56, NULL, NULL, NULL, NULL),
	(57, 26, 57, NULL, NULL, NULL, NULL),
	(58, 26, 58, NULL, NULL, NULL, NULL),
	(59, 26, 59, NULL, NULL, NULL, NULL),
	(60, 26, 60, NULL, NULL, NULL, NULL),
	(61, 26, 61, NULL, NULL, NULL, NULL),
	(62, 26, 62, NULL, NULL, NULL, NULL),
	(63, 26, 63, NULL, NULL, NULL, NULL),
	(64, 26, 64, NULL, NULL, NULL, NULL),
	(65, 26, 65, NULL, NULL, NULL, NULL),
	(66, 26, 66, NULL, NULL, NULL, NULL),
	(67, 26, 67, NULL, NULL, NULL, NULL),
	(68, 26, 68, NULL, NULL, NULL, NULL),
	(69, 26, 69, NULL, NULL, NULL, NULL),
	(70, 26, 70, NULL, NULL, NULL, NULL),
	(71, 26, 71, NULL, NULL, NULL, NULL),
	(72, 26, 72, NULL, NULL, NULL, NULL),
	(73, 26, 73, NULL, NULL, NULL, NULL),
	(74, 26, 74, NULL, NULL, NULL, NULL),
	(75, 26, 75, NULL, NULL, NULL, NULL),
	(76, 26, 76, NULL, NULL, NULL, NULL),
	(77, 26, 77, NULL, NULL, NULL, NULL),
	(78, 26, 78, NULL, NULL, NULL, NULL),
	(79, 26, 79, NULL, NULL, NULL, NULL),
	(80, 26, 80, NULL, NULL, NULL, NULL),
	(81, 26, 81, NULL, NULL, NULL, NULL),
	(82, 26, 82, NULL, NULL, NULL, NULL),
	(83, 26, 83, NULL, NULL, NULL, NULL),
	(84, 26, 84, NULL, NULL, NULL, NULL),
	(85, 26, 85, NULL, NULL, NULL, NULL),
	(86, 26, 86, NULL, NULL, NULL, NULL),
	(87, 26, 87, NULL, NULL, NULL, NULL),
	(88, 26, 88, NULL, NULL, NULL, NULL),
	(89, 26, 89, NULL, NULL, NULL, NULL),
	(90, 26, 90, NULL, NULL, NULL, NULL),
	(91, 26, 91, NULL, NULL, NULL, NULL),
	(92, 26, 92, NULL, NULL, NULL, NULL),
	(93, 26, 93, NULL, NULL, NULL, NULL),
	(94, 26, 94, NULL, NULL, NULL, NULL),
	(95, 26, 95, NULL, NULL, NULL, NULL),
	(96, 26, 96, NULL, NULL, NULL, NULL),
	(97, 26, 98, NULL, NULL, NULL, NULL),
	(98, 26, 99, NULL, NULL, NULL, NULL),
	(99, 26, 100, NULL, NULL, NULL, NULL),
	(100, 26, 101, NULL, NULL, NULL, NULL),
	(101, 26, 102, NULL, NULL, NULL, NULL),
	(102, 26, 103, NULL, NULL, NULL, NULL),
	(103, 26, 104, NULL, NULL, NULL, NULL),
	(104, 26, 105, NULL, NULL, NULL, NULL),
	(105, 26, 106, NULL, NULL, NULL, NULL),
	(106, 26, 107, NULL, NULL, NULL, NULL),
	(107, 26, 108, NULL, NULL, NULL, NULL),
	(108, 26, 109, NULL, NULL, NULL, NULL),
	(109, 26, 110, NULL, NULL, NULL, NULL),
	(110, 26, 111, NULL, NULL, NULL, NULL),
	(111, 26, 112, NULL, NULL, NULL, NULL),
	(112, 26, 113, NULL, NULL, NULL, NULL),
	(113, 26, 97, NULL, NULL, NULL, NULL);


-- Dumping structure for table hrms.tbl_appl_page_role
CREATE TABLE IF NOT EXISTS `tbl_appl_page_role` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `PAGE_ID` bigint(16) NOT NULL,
  `ROLE_ID` bigint(16) NOT NULL,
  `VALUE` bit(1) NOT NULL,
  `CREATED_BY` bigint(16) DEFAULT NULL,
  `CREATED_DATE` datetime DEFAULT NULL,
  `MODIFIED_BY` bigint(16) DEFAULT NULL,
  `MODIFY_DATE` datetime DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_tbl_appl_page_role_tbl_appl_page` (`PAGE_ID`),
  KEY `FK_tbl_appl_page_role_tbl_appl_roles` (`ROLE_ID`),
  KEY `FK_tbl_appl_page_role_tbl_appl_user` (`CREATED_BY`),
  KEY `FK_tbl_appl_page_role_tbl_appl_user_2` (`MODIFIED_BY`),
  CONSTRAINT `FK_tbl_appl_page_role_tbl_appl_page` FOREIGN KEY (`PAGE_ID`) REFERENCES `tbl_appl_page` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_appl_page_role_tbl_appl_roles` FOREIGN KEY (`ROLE_ID`) REFERENCES `tbl_appl_roles` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_appl_page_role_tbl_appl_user` FOREIGN KEY (`CREATED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_appl_page_role_tbl_appl_user_2` FOREIGN KEY (`MODIFIED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_appl_page_role: ~104 rows (approximately)
INSERT INTO `tbl_appl_page_role` (`ID`, `PAGE_ID`, `ROLE_ID`, `VALUE`, `CREATED_BY`, `CREATED_DATE`, `MODIFIED_BY`, `MODIFY_DATE`) VALUES
	(1, 1, 1, b'00000000', NULL, '2012-03-17 17:25:10', NULL, NULL),
	(2, 2, 1, b'10000000', NULL, NULL, NULL, NULL),
	(3, 3, 1, b'10000000', NULL, NULL, NULL, NULL),
	(4, 4, 1, b'10000000', NULL, NULL, NULL, NULL),
	(5, 5, 1, b'10000000', NULL, NULL, NULL, NULL),
	(6, 6, 1, b'10000000', NULL, NULL, NULL, NULL),
	(7, 7, 1, b'00000000', NULL, NULL, NULL, NULL),
	(8, 8, 1, b'00000000', NULL, NULL, NULL, NULL),
	(9, 9, 1, b'00000000', NULL, NULL, NULL, NULL),
	(10, 10, 1, b'00000000', NULL, NULL, NULL, NULL),
	(11, 11, 1, b'00000000', NULL, NULL, NULL, NULL),
	(12, 12, 1, b'00000000', NULL, NULL, NULL, NULL),
	(13, 13, 1, b'00000000', NULL, NULL, NULL, NULL),
	(14, 14, 1, b'00000000', NULL, NULL, NULL, NULL),
	(15, 15, 1, b'00000000', NULL, NULL, NULL, NULL),
	(16, 16, 1, b'00000000', NULL, NULL, NULL, NULL),
	(17, 17, 1, b'00000000', NULL, NULL, NULL, NULL),
	(18, 18, 1, b'00000000', NULL, NULL, NULL, NULL),
	(19, 19, 1, b'00000000', NULL, NULL, NULL, NULL),
	(20, 20, 1, b'00000000', NULL, NULL, NULL, NULL),
	(21, 21, 1, b'00000000', NULL, NULL, NULL, NULL),
	(22, 22, 1, b'00000000', NULL, NULL, NULL, NULL),
	(23, 23, 1, b'00000000', NULL, NULL, NULL, NULL),
	(24, 24, 1, b'00000000', NULL, NULL, NULL, NULL),
	(25, 25, 1, b'00000000', NULL, NULL, NULL, NULL),
	(26, 1, 2, b'10000000', NULL, NULL, NULL, NULL),
	(27, 2, 2, b'10000000', NULL, NULL, NULL, NULL),
	(28, 3, 2, b'10000000', NULL, NULL, NULL, NULL),
	(29, 4, 2, b'10000000', NULL, NULL, NULL, NULL),
	(30, 5, 2, b'10000000', NULL, NULL, NULL, NULL),
	(31, 6, 2, b'10000000', NULL, NULL, NULL, NULL),
	(32, 7, 2, b'10000000', NULL, NULL, NULL, NULL),
	(33, 8, 2, b'00000000', NULL, NULL, NULL, NULL),
	(34, 9, 2, b'10000000', NULL, NULL, NULL, NULL),
	(35, 10, 2, b'10000000', NULL, NULL, NULL, NULL),
	(36, 11, 2, b'10000000', NULL, NULL, NULL, NULL),
	(37, 12, 2, b'10000000', NULL, NULL, NULL, NULL),
	(38, 13, 2, b'10000000', NULL, NULL, NULL, NULL),
	(39, 14, 2, b'10000000', NULL, NULL, NULL, NULL),
	(40, 15, 2, b'10000000', NULL, NULL, NULL, NULL),
	(41, 16, 2, b'10000000', NULL, NULL, NULL, NULL),
	(42, 17, 2, b'10000000', NULL, NULL, NULL, NULL),
	(43, 18, 2, b'10000000', NULL, NULL, NULL, NULL),
	(44, 19, 2, b'10000000', NULL, NULL, NULL, NULL),
	(45, 20, 2, b'10000000', NULL, NULL, NULL, NULL),
	(46, 21, 2, b'10000000', NULL, NULL, NULL, NULL),
	(47, 22, 2, b'00000000', NULL, NULL, NULL, NULL),
	(48, 23, 2, b'00000000', NULL, NULL, NULL, NULL),
	(49, 24, 2, b'00000000', NULL, NULL, NULL, NULL),
	(50, 25, 2, b'00000000', NULL, NULL, NULL, NULL),
	(51, 1, 3, b'10000000', NULL, NULL, NULL, NULL),
	(52, 2, 3, b'10000000', NULL, NULL, NULL, NULL),
	(53, 3, 3, b'10000000', NULL, NULL, NULL, NULL),
	(54, 4, 3, b'10000000', NULL, NULL, NULL, NULL),
	(55, 5, 3, b'10000000', NULL, NULL, NULL, NULL),
	(56, 6, 3, b'10000000', NULL, NULL, NULL, NULL),
	(57, 7, 3, b'10000000', NULL, NULL, NULL, NULL),
	(58, 8, 3, b'10000000', NULL, NULL, NULL, NULL),
	(59, 9, 3, b'00000000', NULL, NULL, NULL, NULL),
	(60, 10, 3, b'10000000', NULL, NULL, NULL, NULL),
	(61, 11, 3, b'10000000', NULL, NULL, NULL, NULL),
	(62, 12, 3, b'10000000', NULL, NULL, NULL, NULL),
	(63, 13, 3, b'10000000', NULL, NULL, NULL, NULL),
	(64, 14, 3, b'10000000', NULL, NULL, NULL, NULL),
	(65, 15, 3, b'10000000', NULL, NULL, NULL, NULL),
	(66, 16, 3, b'10000000', NULL, NULL, NULL, NULL),
	(67, 17, 3, b'10000000', NULL, NULL, NULL, NULL),
	(68, 18, 3, b'10000000', NULL, NULL, NULL, NULL),
	(69, 19, 3, b'10000000', NULL, NULL, NULL, NULL),
	(70, 20, 3, b'10000000', NULL, NULL, NULL, NULL),
	(71, 21, 3, b'10000000', NULL, NULL, NULL, NULL),
	(72, 22, 3, b'00000000', NULL, NULL, NULL, NULL),
	(73, 23, 3, b'00000000', NULL, NULL, NULL, NULL),
	(74, 24, 3, b'00000000', NULL, NULL, NULL, NULL),
	(75, 25, 3, b'00000000', NULL, NULL, NULL, NULL),
	(76, 1, 4, b'00000000', NULL, NULL, NULL, NULL),
	(77, 2, 4, b'00000000', NULL, NULL, NULL, NULL),
	(78, 3, 4, b'00000000', NULL, NULL, NULL, NULL),
	(79, 4, 4, b'00000000', NULL, NULL, NULL, NULL),
	(80, 5, 4, b'00000000', NULL, NULL, NULL, NULL),
	(81, 6, 4, b'00000000', NULL, NULL, NULL, NULL),
	(82, 7, 4, b'00000000', NULL, NULL, NULL, NULL),
	(83, 8, 4, b'00000000', NULL, NULL, NULL, NULL),
	(84, 9, 4, b'00000000', NULL, NULL, NULL, NULL),
	(85, 10, 4, b'00000000', NULL, NULL, NULL, NULL),
	(86, 11, 4, b'00000000', NULL, NULL, NULL, NULL),
	(87, 12, 4, b'00000000', NULL, NULL, NULL, NULL),
	(88, 13, 4, b'00000000', NULL, NULL, NULL, NULL),
	(89, 14, 4, b'00000000', NULL, NULL, NULL, NULL),
	(90, 15, 4, b'00000000', NULL, NULL, NULL, NULL),
	(91, 16, 4, b'00000000', NULL, NULL, NULL, NULL),
	(92, 17, 4, b'00000000', NULL, NULL, NULL, NULL),
	(93, 18, 4, b'00000000', NULL, NULL, NULL, NULL),
	(94, 19, 4, b'00000000', NULL, NULL, NULL, NULL),
	(95, 20, 4, b'00000000', NULL, NULL, NULL, NULL),
	(96, 21, 4, b'00000000', NULL, NULL, NULL, NULL),
	(97, 22, 4, b'10000000', NULL, NULL, NULL, NULL),
	(98, 23, 4, b'10000000', NULL, NULL, NULL, NULL),
	(99, 24, 4, b'10000000', NULL, NULL, NULL, NULL),
	(100, 25, 4, b'10000000', NULL, NULL, NULL, NULL),
	(101, 26, 1, b'10000000', NULL, NULL, NULL, NULL),
	(102, 26, 2, b'00000000', NULL, NULL, NULL, NULL),
	(103, 26, 3, b'00000000', NULL, NULL, NULL, NULL),
	(104, 26, 4, b'00000000', NULL, NULL, NULL, NULL);


-- Dumping structure for table hrms.tbl_appl_roles
CREATE TABLE IF NOT EXISTS `tbl_appl_roles` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `ROLE_NAME` varchar(16) NOT NULL,
  `CREATION_DATE` datetime DEFAULT NULL,
  `CREATED_BY` bigint(16) DEFAULT NULL,
  `MODIFY_DATE` datetime DEFAULT NULL,
  `MODIFIED_BY` bigint(16) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_tbl_appl_roles_tbl_appl_user` (`CREATED_BY`),
  KEY `FK_tbl_appl_roles_tbl_appl_user_2` (`MODIFIED_BY`),
  CONSTRAINT `FK_tbl_appl_roles_tbl_appl_user` FOREIGN KEY (`CREATED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_appl_roles_tbl_appl_user_2` FOREIGN KEY (`MODIFIED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_appl_roles: ~4 rows (approximately)
INSERT INTO `tbl_appl_roles` (`ID`, `ROLE_NAME`, `CREATION_DATE`, `CREATED_BY`, `MODIFY_DATE`, `MODIFIED_BY`) VALUES
	(1, 'Employee', '2012-03-14 20:20:05', NULL, NULL, NULL),
	(2, 'Manager', '2012-03-14 20:20:45', NULL, NULL, NULL),
	(3, 'HR', '2012-03-14 20:20:55', NULL, NULL, NULL),
	(4, 'Admin', '2012-03-14 20:21:06', NULL, NULL, NULL);


-- Dumping structure for table hrms.tbl_appl_user_log
CREATE TABLE IF NOT EXISTS `tbl_appl_user_log` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `USER_ID` bigint(16) NOT NULL,
  `LOGIN_DATE` datetime DEFAULT NULL,
  `LOGOUT_DATE` datetime DEFAULT NULL,
  `LOGOUT_TYPE` varchar(10) DEFAULT NULL,
  `IP` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_tbl_appl_user_log_tbl_appl_user` (`USER_ID`),
  CONSTRAINT `FK_tbl_appl_user_log_tbl_appl_user` FOREIGN KEY (`USER_ID`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_appl_user_log: ~0 rows (approximately)


-- Dumping structure for table hrms.tbl_appl_user_role
CREATE TABLE IF NOT EXISTS `tbl_appl_user_role` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `ROLE_ID` bigint(16) NOT NULL,
  `USER_ID` bigint(16) NOT NULL,
  `CREATION_DATE` datetime DEFAULT NULL,
  `CREATED_BY` bigint(16) DEFAULT NULL,
  `MODIFY_DATE` datetime DEFAULT NULL,
  `MODIFIED_BY` bigint(16) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_tbl_appl_user_role_tbl_appl_roles` (`ROLE_ID`),
  KEY `FK_tbl_appl_user_role_tbl_appl_user` (`USER_ID`),
  KEY `FK_tbl_appl_user_role_tbl_appl_user_2` (`CREATED_BY`),
  KEY `FK_tbl_appl_user_role_tbl_appl_user_3` (`MODIFIED_BY`),
  CONSTRAINT `FK_tbl_appl_user_role_tbl_appl_roles` FOREIGN KEY (`ROLE_ID`) REFERENCES `tbl_appl_roles` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_appl_user_role_tbl_appl_user` FOREIGN KEY (`USER_ID`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_appl_user_role_tbl_appl_user_2` FOREIGN KEY (`CREATED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_appl_user_role_tbl_appl_user_3` FOREIGN KEY (`MODIFIED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_appl_user_role: ~4 rows (approximately)
INSERT INTO `tbl_appl_user_role` (`ID`, `ROLE_ID`, `USER_ID`, `CREATION_DATE`, `CREATED_BY`, `MODIFY_DATE`, `MODIFIED_BY`) VALUES
	(1, 4, 1, '2012-03-14 20:28:42', NULL, NULL, NULL),
	(2, 3, 2, '2012-03-14 20:29:03', NULL, NULL, NULL),
	(3, 2, 3, '2012-03-14 20:29:14', NULL, NULL, NULL),
	(4, 1, 4, '2012-03-14 20:29:23', NULL, NULL, NULL);


-- Dumping structure for table hrms.tbl_employee
CREATE TABLE IF NOT EXISTS `tbl_employee` (
  `EMPLOYEEID` varchar(16) NOT NULL,
  `NAME` varchar(32) NOT NULL,
  `SURNAME` varchar(32) NOT NULL,
  `PHOTO` blob,
  `GENDERID` varchar(1) DEFAULT NULL,
  `NATIONALITY` varchar(20) DEFAULT NULL,
  `BLOODTYPEID` varchar(3) DEFAULT NULL,
  `BIRTHDATE` datetime DEFAULT NULL,
  `MARITALSTATUSID` varchar(1) DEFAULT NULL,
  `DRIVINGLICENCEID` varchar(1) DEFAULT NULL,
  `EMAIL` varchar(50) DEFAULT NULL,
  `PHONE` varchar(16) DEFAULT NULL,
  `CELLPHONE` varchar(16) DEFAULT NULL,
  `HOUSEPHONE` varchar(16) DEFAULT NULL,
  `POSITIONID` varchar(1) DEFAULT NULL,
  `DEPARTMENTID` varchar(1) DEFAULT NULL,
  `SUPERVISORID` varchar(16) DEFAULT NULL,
  `IDENTITYNO` varchar(11) DEFAULT NULL,
  `SSKNO` varchar(13) DEFAULT NULL,
  `CONTRACTTYPE` varchar(1) DEFAULT NULL,
  `SIEMENSENTRANCE` datetime DEFAULT NULL,
  `STARTDATE` datetime DEFAULT NULL,
  `MILITARYSERVICEID` varchar(1) DEFAULT NULL,
  `MILITARYSERVICEDATE` datetime DEFAULT NULL,
  `LOCATION` varchar(50) DEFAULT NULL,
  `OFFICESEAT` varchar(10) DEFAULT NULL,
  `ARBISRECORD` bit(1) DEFAULT NULL,
  `CONFIRMATION` bit(1) DEFAULT NULL,
  `CREATEDATE` datetime DEFAULT NULL,
  `CREATEDBY` bigint(16) DEFAULT NULL,
  `MODIFYDATE` datetime DEFAULT NULL,
  `MODIFIEDBY` bigint(16) DEFAULT NULL,
  PRIMARY KEY (`EMPLOYEEID`),
  KEY `FK_tbl_employee_tbl_appl_user` (`CREATEDBY`),
  KEY `FK_tbl_employee_tbl_appl_user_2` (`MODIFIEDBY`),
  KEY `POSITIONID` (`POSITIONID`),
  CONSTRAINT `FK_tbl_employee_tbl_appl_user` FOREIGN KEY (`CREATEDBY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_employee_tbl_appl_user_2` FOREIGN KEY (`MODIFIEDBY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_employee: ~6 rows (approximately)
INSERT INTO `tbl_employee` (`EMPLOYEEID`, `NAME`, `SURNAME`, `PHOTO`, `GENDERID`, `NATIONALITY`, `BLOODTYPEID`, `BIRTHDATE`, `MARITALSTATUSID`, `DRIVINGLICENCEID`, `EMAIL`, `PHONE`, `CELLPHONE`, `HOUSEPHONE`, `POSITIONID`, `DEPARTMENTID`, `SUPERVISORID`, `IDENTITYNO`, `SSKNO`, `CONTRACTTYPE`, `SIEMENSENTRANCE`, `STARTDATE`, `MILITARYSERVICEID`, `MILITARYSERVICEDATE`, `LOCATION`, `OFFICESEAT`, `ARBISRECORD`, `CONFIRMATION`, `CREATEDATE`, `CREATEDBY`, `MODIFYDATE`, `MODIFIEDBY`) VALUES
	('1111', 'Nuda', 'Safari', NULL, 'F', 'Br', 'B+', '1991-05-25 04:17:25', 'B', 'A', 'nuda@isafari.com', '', '', '', 'G', '', '', '', '', '', NULL, NULL, '', NULL, '', '', b'00000000', b'00000000', '2012-05-24 21:55:25', 2, '2012-05-24 21:55:25', 2),
	('1234', 'Zaman', 'Safari', NULL, 'M', 'AF', 'A+', '1987-04-23 01:01:47', 'B', 'B', NULL, NULL, '05557864433', NULL, '2', NULL, '2345', '99221108712', '12345', NULL, NULL, '2012-05-24 17:14:40', NULL, NULL, 'Antalya', 'genius', b'00000000', b'10000000', '2010-05-24 20:18:55', 1, NULL, NULL),
	('2345', 'Bekir', 'Doğru', NULL, 'M', 'TC', 'A+', '1988-05-09 01:02:59', 'B', 'B', 'bekirdogru@gmail.com', '03122869294', '', '09876', 'h', '9', '3456', '', '', 'A', '2012-05-24 20:14:35', NULL, 'S', '2012-05-24 18:14:58', 'Malatya', '', b'10000000', b'00000000', NULL, NULL, '2012-03-30 11:24:23', 2),
	('3456', 'Cansu', 'Hekim', NULL, 'F', 'TC', NULL, NULL, 'B', NULL, NULL, NULL, NULL, NULL, '4', NULL, '2345', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'tembel', b'00000000', b'10000000', '2022-05-24 20:18:41', 3, NULL, NULL),
	('4567', 'Hamid', 'Sıddıqi', NULL, 'M', 'AF', 'A+', '1989-04-14 01:03:25', 'B', 'A', 'hamidsiddiqi@gmail.com', '03123454334', '05554534755', '0876554', '3', '5', '3456', '234567873', '34565', 'F', '2011-03-25 23:04:19', '2011-04-25 23:04:22', 'N', '2014-04-25 23:04:26', '', '', b'00000000', b'00000000', NULL, NULL, '2012-03-30 03:49:22', 4),
	('5555', 'restert', 'ertert', NULL, 'F', '', '', NULL, '', '', '', '', '', '', 'B', '', '', '', '', '', NULL, NULL, '', NULL, '', '', b'00000000', b'00000000', '2012-05-25 15:35:59', 2, '2012-05-25 15:35:59', 2);


-- Dumping structure for table hrms.tbl_employee_attachment
CREATE TABLE IF NOT EXISTS `tbl_employee_attachment` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `EMPLOYEEID` varchar(16) NOT NULL,
  `FILE_NAME` varchar(250) NOT NULL,
  `FILE_ID` varchar(32) NOT NULL,
  `DOCUMENT` blob NOT NULL,
  `TYPE_ID` varchar(50) NOT NULL,
  `CONTENT_TYPE` varchar(64) NOT NULL,
  `CONFIRMATION` bit(1) NOT NULL,
  `NOTES` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `EMPLOYEEID` (`EMPLOYEEID`),
  CONSTRAINT `FK_tbl_employee_attachment_tbl_employee` FOREIGN KEY (`EMPLOYEEID`) REFERENCES `tbl_employee` (`EMPLOYEEID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_employee_attachment: ~0 rows (approximately)


-- Dumping structure for table hrms.tbl_employee_certificates
CREATE TABLE IF NOT EXISTS `tbl_employee_certificates` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `EMPLOYEEID` varchar(16) NOT NULL,
  `PROVIDER` varchar(32) NOT NULL,
  `NAME` varchar(32) NOT NULL,
  `DATE` datetime DEFAULT NULL,
  `CONFIRMATION` bit(1) DEFAULT NULL,
  `NOTES` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `EMPLOYEEID` (`EMPLOYEEID`),
  CONSTRAINT `FK_tbl_employee_certificates_tbl_employee` FOREIGN KEY (`EMPLOYEEID`) REFERENCES `tbl_employee` (`EMPLOYEEID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_employee_certificates: ~4 rows (approximately)
INSERT INTO `tbl_employee_certificates` (`ID`, `EMPLOYEEID`, `PROVIDER`, `NAME`, `DATE`, `CONFIRMATION`, `NOTES`) VALUES
	(1, '1234', 'Cyber Park', 'Ahmet', NULL, b'00000000', NULL),
	(2, '2345', 'Siemens', 'bekir', NULL, b'10000000', NULL),
	(3, '3456', 'Intel', 'Osman Bey', NULL, b'10000000', NULL),
	(4, '4567', 'IBM', 'Bob', NULL, b'00000000', NULL);


-- Dumping structure for table hrms.tbl_employee_cost_center
CREATE TABLE IF NOT EXISTS `tbl_employee_cost_center` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `EMPLOYEEID` varchar(16) NOT NULL,
  `COST_CENTER_ID` varchar(8) DEFAULT NULL,
  `WEIGHT` varchar(2) DEFAULT NULL,
  `CONFIRMATION` bit(1) DEFAULT NULL,
  `NOTES` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `EMPLOYEEID` (`EMPLOYEEID`),
  CONSTRAINT `FK_tbl_employee_cost_center_tbl_employee` FOREIGN KEY (`EMPLOYEEID`) REFERENCES `tbl_employee` (`EMPLOYEEID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_employee_cost_center: ~4 rows (approximately)
INSERT INTO `tbl_employee_cost_center` (`ID`, `EMPLOYEEID`, `COST_CENTER_ID`, `WEIGHT`, `CONFIRMATION`, `NOTES`) VALUES
	(1, '1234', NULL, NULL, NULL, NULL),
	(2, '2345', NULL, NULL, NULL, NULL),
	(3, '3456', NULL, NULL, NULL, NULL),
	(4, '4567', NULL, NULL, NULL, NULL);


-- Dumping structure for table hrms.tbl_employee_education
CREATE TABLE IF NOT EXISTS `tbl_employee_education` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `EMPLOYEEID` varchar(16) NOT NULL,
  `DEGREEID` varchar(1) NOT NULL,
  `INSTITUTION` varchar(32) NOT NULL,
  `DEPARTMENT` varchar(32) NOT NULL,
  `THESIS` varchar(128) DEFAULT NULL,
  `STILLSTUDYING` bit(1) NOT NULL,
  `ENTRANCEDATE` date DEFAULT NULL,
  `GRADUATIONDATE` date DEFAULT NULL,
  `CONFIRMATION` bit(1) NOT NULL,
  `NOTES` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `EMPLOYEEID_DEGREEID_INSTITUTION_DEPARTMENT` (`EMPLOYEEID`,`DEGREEID`,`INSTITUTION`,`DEPARTMENT`),
  CONSTRAINT `FK_tbl_employee_education_tbl_employee` FOREIGN KEY (`EMPLOYEEID`) REFERENCES `tbl_employee` (`EMPLOYEEID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_employee_education: ~8 rows (approximately)
INSERT INTO `tbl_employee_education` (`ID`, `EMPLOYEEID`, `DEGREEID`, `INSTITUTION`, `DEPARTMENT`, `THESIS`, `STILLSTUDYING`, `ENTRANCEDATE`, `GRADUATIONDATE`, `CONFIRMATION`, `NOTES`) VALUES
	(1, '1234', 'B', 'metu', 'computer eng.', 'The Batak Game', b'10000000', '2011-07-29', '2011-08-29', b'00000000', 'on development'),
	(2, '2345', 'H', 'Denizli Fen Lisesi', 'FM', '', b'10000000', '2012-04-16', '2012-04-16', b'10000000', ''),
	(3, '3456', 'B', 'METU', 'CENG', 'Kelaynak Server', b'00000000', '2012-03-22', '2012-04-16', b'00000000', 'on development'),
	(4, '4567', 'B', 'ODTÜ', 'Bilgisayar Müh.', 'Siemens EC HRMS', b'10000000', '2007-09-20', '2012-04-16', b'00000000', 'on development'),
	(5, '4567', 'H', 'Lise', 'FM', 'Robotics', b'00000000', '2002-09-25', '2006-06-15', b'10000000', ''),
	(6, '2345', 'B', 'METU', 'ceng', '', b'10000000', '2012-05-03', '2012-04-30', b'00000000', 'still studying'),
	(7, '1234', 'M', 'MIT', 'ceng', '', b'00000000', '2012-03-04', '2011-12-04', b'00000000', ''),
	(8, '3456', 'H', 'Ankara Ataturk Anadolu Lisesi', 'FM', '', b'00000000', '2012-03-04', '2012-01-04', b'10000000', '');


-- Dumping structure for table hrms.tbl_employee_emergency_call
CREATE TABLE IF NOT EXISTS `tbl_employee_emergency_call` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `EMPLOYEEID` varchar(16) NOT NULL,
  `NAME` varchar(32) NOT NULL,
  `SURNAME` varchar(32) NOT NULL,
  `RELATION_TO` varchar(16) DEFAULT NULL,
  `PHONE` varchar(16) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `EMPLOYEEID_NAME_SURNAME` (`EMPLOYEEID`,`NAME`,`SURNAME`),
  CONSTRAINT `FK_tbl_employee_emergency_call_tbl_employee` FOREIGN KEY (`EMPLOYEEID`) REFERENCES `tbl_employee` (`EMPLOYEEID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_employee_emergency_call: ~6 rows (approximately)
INSERT INTO `tbl_employee_emergency_call` (`ID`, `EMPLOYEEID`, `NAME`, `SURNAME`, `RELATION_TO`, `PHONE`) VALUES
	(1, '1234', 'hajira', 'safari', 'kardeşi', '567897654'),
	(2, '2345', 'cansu', 'hekim', 'arkadaş', '876789'),
	(3, '3456', 'hamit', 'sıddıqi', 'proje arkadaşı', '567898765'),
	(4, '4567', 'bekir', 'doğru', 'sınıf arkadaşı', '5334344522'),
	(5, '4567', 'cansu', 'hekim', 'okul', '345678765'),
	(6, '4567', 'zaman', 'safari', 'okul', '678987654');


-- Dumping structure for table hrms.tbl_employee_language
CREATE TABLE IF NOT EXISTS `tbl_employee_language` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `EMPLOYEEID` varchar(16) NOT NULL,
  `LANGUAGEID` varchar(10) NOT NULL,
  `WRITTEN_LEVEL_ID` varchar(1) NOT NULL,
  `SPEAKING_LEVEL_ID` varchar(1) NOT NULL,
  `READING_LEVEL_ID` varchar(1) NOT NULL,
  `NATIVE_LANG` bit(1) NOT NULL,
  `CONFIRMATION` bit(1) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `EMPLOYEEID_LANGUAGEID` (`EMPLOYEEID`,`LANGUAGEID`),
  CONSTRAINT `FK_tbl_employee_language_tbl_employee` FOREIGN KEY (`EMPLOYEEID`) REFERENCES `tbl_employee` (`EMPLOYEEID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_employee_language: ~6 rows (approximately)
INSERT INTO `tbl_employee_language` (`ID`, `EMPLOYEEID`, `LANGUAGEID`, `WRITTEN_LEVEL_ID`, `SPEAKING_LEVEL_ID`, `READING_LEVEL_ID`, `NATIVE_LANG`, `CONFIRMATION`) VALUES
	(1, '1234', 'özbekçe', '9', '9', '9', b'10000000', b'10000000'),
	(2, '2345', 'ing.', '6', '8', '5', b'00000000', b'00000000'),
	(3, '3456', 'ingilizce', '2', '4', '5', b'10000000', b'00000000'),
	(4, '4567', 'eng', '5', '4', '4', b'00000000', b'10000000'),
	(5, '4567', 'frans?zca', '4', '3', '3', b'00000000', b'00000000'),
	(6, '4567', 'pers', '5', '5', '5', b'10000000', b'10000000');


-- Dumping structure for table hrms.tbl_employee_projects
CREATE TABLE IF NOT EXISTS `tbl_employee_projects` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `PROJECTID` varchar(16) NOT NULL,
  `EMPLOYEEID` varchar(16) NOT NULL,
  `NAME` varchar(32) NOT NULL,
  `START` datetime NOT NULL,
  `POSITION` varchar(32) NOT NULL,
  `COMPLETED` varchar(3) DEFAULT NULL,
  `FINISH` datetime DEFAULT NULL,
  `TUBITAK` bit(1) NOT NULL,
  `CONFIRMATION` bit(1) NOT NULL,
  `NOTES` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `PROJECTID_EMPLOYEEID_NAME_START` (`PROJECTID`,`EMPLOYEEID`,`NAME`,`START`),
  KEY `FK_tbl_employee_projects_tbl_employee` (`EMPLOYEEID`),
  CONSTRAINT `FK_tbl_employee_projects_tbl_employee` FOREIGN KEY (`EMPLOYEEID`) REFERENCES `tbl_employee` (`EMPLOYEEID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_employee_projects: ~4 rows (approximately)
INSERT INTO `tbl_employee_projects` (`ID`, `PROJECTID`, `EMPLOYEEID`, `NAME`, `START`, `POSITION`, `COMPLETED`, `FINISH`, `TUBITAK`, `CONFIRMATION`, `NOTES`) VALUES
	(1, '1', '1234', 'HRMS', '2005-03-30 07:37:12', 'DAOs', 'no', '2017-03-30 07:37:21', b'00000000', b'10000000', 'deneme'),
	(2, '1', '2345', 'OYUN', '2017-03-30 07:37:49', 'Algorithm', 'no', '2017-03-30 07:38:05', b'10000000', b'00000000', NULL),
	(3, '1', '3456', 'TETRIS', '2020-03-30 07:38:22', 'GUIs', 'yes', '2011-03-30 07:38:34', b'10000000', b'00000000', NULL),
	(4, '1', '4567', 'HRMS', '2011-09-29 01:16:01', 'programmer', 'no', '2012-06-30 01:16:30', b'00000000', b'00000000', NULL);


-- Dumping structure for table hrms.tbl_employee_technicalskills
CREATE TABLE IF NOT EXISTS `tbl_employee_technicalskills` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `EMPLOYEEID` varchar(16) NOT NULL,
  `NAMEID` varchar(8) NOT NULL,
  `LEVELID` varchar(2) NOT NULL,
  `CONFIRMATION` bit(1) NOT NULL,
  `NOTES` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `EMPLOYEEID_NAMEID_LEVELID` (`EMPLOYEEID`,`NAMEID`,`LEVELID`),
  CONSTRAINT `FK_tbl_employee_technicalskills_tbl_employee` FOREIGN KEY (`EMPLOYEEID`) REFERENCES `tbl_employee` (`EMPLOYEEID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_employee_technicalskills: ~5 rows (approximately)
INSERT INTO `tbl_employee_technicalskills` (`ID`, `EMPLOYEEID`, `NAMEID`, `LEVELID`, `CONFIRMATION`, `NOTES`) VALUES
	(1, '1234', 'Database', '5', b'10000000', NULL),
	(2, '2345', 'zk', '5', b'10000000', NULL),
	(3, '3456', 'c++', '4', b'00000000', NULL),
	(4, '4567', 'c', '3', b'00000000', 'ceng140 almış'),
	(5, '4567', 'java', '4', b'00000000', NULL);


-- Dumping structure for table hrms.tbl_employee_trainings
CREATE TABLE IF NOT EXISTS `tbl_employee_trainings` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `EMPLOYEEID` varchar(16) NOT NULL,
  `NAME` varchar(128) NOT NULL,
  `PROVIDER` varchar(64) DEFAULT NULL,
  `LOCATION` varchar(32) DEFAULT NULL,
  `START` datetime DEFAULT NULL,
  `FINISH` datetime DEFAULT NULL,
  `DURATION` varchar(16) DEFAULT NULL,
  `CONFIRMATION` bit(1) NOT NULL,
  `NOTES` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `EMPLOYEEID_NAME` (`EMPLOYEEID`,`NAME`),
  CONSTRAINT `FK_tbl_employee_trainings_TBL_Employee` FOREIGN KEY (`EMPLOYEEID`) REFERENCES `tbl_employee` (`EMPLOYEEID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_employee_trainings: ~5 rows (approximately)
INSERT INTO `tbl_employee_trainings` (`ID`, `EMPLOYEEID`, `NAME`, `PROVIDER`, `LOCATION`, `START`, `FINISH`, `DURATION`, `CONFIRMATION`, `NOTES`) VALUES
	(1, '1234', 'project cycle', 'kalder', 'istanbul', '2012-08-30 07:41:14', '1111-07-02 12:44:44', NULL, b'10000000', NULL),
	(2, '2345', 'java', 'metu', 'denizli', '2012-03-30 07:41:55', '2012-03-30 07:41:53', NULL, b'00000000', NULL),
	(3, '3456', 'zk', 'deneme', 'ankara', '2012-03-30 07:42:00', '2012-03-30 07:42:02', '1 month', b'10000000', 'deneme'),
	(4, '4567', 'hibernate', 'odtü', 'ankara', '2012-05-30 01:18:25', '2012-05-30 01:18:26', '1 month', b'00000000', 'talep a?amas?nda'),
	(5, '4567', 'zk', 'bilgeadam', 'ankara', '2012-05-30 01:17:47', '2012-08-30 01:17:49', '3 month', b'00000000', '');


-- Dumping structure for table hrms.tbl_employee_workexpreience
CREATE TABLE IF NOT EXISTS `tbl_employee_workexpreience` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT,
  `EMPLOYEEID` varchar(16) NOT NULL,
  `COMPANY_NAME` varchar(32) NOT NULL,
  `POSITION` varchar(32) NOT NULL,
  `START_DATE` datetime NOT NULL,
  `END_DATE` datetime NOT NULL,
  `WORK_PLACE` varchar(50) NOT NULL,
  `CONFIRMATION` bit(1) NOT NULL,
  `NOTES` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `EMPLOYEEID_COMPANY_NAME_POSITIOIN_START_DATE_END_DATE` (`EMPLOYEEID`,`COMPANY_NAME`,`POSITION`,`START_DATE`,`END_DATE`),
  CONSTRAINT `FK_tbl_employee_workexpreience_tbl_employee` FOREIGN KEY (`EMPLOYEEID`) REFERENCES `tbl_employee` (`EMPLOYEEID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_employee_workexpreience: ~4 rows (approximately)
INSERT INTO `tbl_employee_workexpreience` (`ID`, `EMPLOYEEID`, `COMPANY_NAME`, `POSITION`, `START_DATE`, `END_DATE`, `WORK_PLACE`, `CONFIRMATION`, `NOTES`) VALUES
	(1, '1234', 'Koç Sistem', 'Stajyer', '2012-03-30 07:29:18', '2012-03-30 07:25:19', 'ankara', b'10000000', ' '),
	(2, '2345', 'CyberSoft', 'Stajyer', '2011-05-29 07:35:19', '2003-03-30 07:35:22', 'Denizli', b'10000000', 'Deneme'),
	(3, '3456', 'Siemens', 'Stajyer', '2012-03-30 07:21:53', '2012-03-30 07:21:55', 'istanbul', b'00000000', 'deneme'),
	(4, '4567', 'ES PC', 'Stajyer', '2011-03-25 22:31:14', '2011-05-25 22:31:25', 'Ankara', b'00000000', '');


-- Dumping structure for table hrms.tbl_pes
CREATE TABLE IF NOT EXISTS `tbl_pes` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `EMPLOYEEID` varchar(16) NOT NULL,
  `MANAGERID` varchar(16) NOT NULL,
  `POSITION_START` datetime NOT NULL,
  `DATE` datetime DEFAULT NULL,
  `TERM_START` datetime NOT NULL,
  `TERM_END` datetime DEFAULT NULL,
  `PROJECT_ID` varchar(16) NOT NULL,
  `EVALUATION` varchar(512) DEFAULT NULL,
  `PERSONAL_OPENION` varchar(512) DEFAULT NULL,
  `IMPROVEMENT` varchar(512) DEFAULT NULL,
  `CONFIRMAITON_DATE` datetime DEFAULT NULL,
  `CONFIRMATION_BY_EMPLOYEE` bit(1) DEFAULT NULL,
  `CONFIRMATION_BY_MANAGER` bit(1) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ID` (`ID`),
  KEY `FK_tbl_pes_employeeId_tbl_employee` (`EMPLOYEEID`),
  KEY `FK_tbl_pes_managerId_tbl_employee` (`MANAGERID`),
  KEY `FK_tbl_pes_tbl_employee_projects` (`PROJECT_ID`),
  CONSTRAINT `FK_tbl_pes_employeeId_tbl_employee` FOREIGN KEY (`EMPLOYEEID`) REFERENCES `tbl_employee` (`EMPLOYEEID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_managerId_tbl_employee` FOREIGN KEY (`MANAGERID`) REFERENCES `tbl_employee` (`EMPLOYEEID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_tbl_employee_projects` FOREIGN KEY (`PROJECT_ID`) REFERENCES `tbl_employee_projects` (`PROJECTID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4445 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_pes: ~4 rows (approximately)
INSERT INTO `tbl_pes` (`ID`, `EMPLOYEEID`, `MANAGERID`, `POSITION_START`, `DATE`, `TERM_START`, `TERM_END`, `PROJECT_ID`, `EVALUATION`, `PERSONAL_OPENION`, `IMPROVEMENT`, `CONFIRMAITON_DATE`, `CONFIRMATION_BY_EMPLOYEE`, `CONFIRMATION_BY_MANAGER`) VALUES
	(1111, '1234', '2345', '2012-11-08 20:20:39', '2012-05-25 06:40:20', '2012-04-04 20:20:43', NULL, '1', NULL, NULL, NULL, NULL, b'00000000', b'00000000'),
	(2222, '2345', '1234', '2012-04-06 20:21:40', '2012-02-25 06:40:08', '2012-04-05 20:21:42', NULL, '1', NULL, NULL, NULL, NULL, b'00000000', b'00000000'),
	(3333, '3456', '4567', '2012-04-06 20:21:55', '2012-04-08 20:21:57', '2012-04-08 20:22:02', NULL, '1', NULL, NULL, NULL, NULL, b'00000000', b'00000000'),
	(4444, '4567', '3456', '2012-04-08 20:22:29', '2012-01-25 06:40:13', '2012-04-08 20:22:30', NULL, '1', NULL, NULL, NULL, NULL, b'00000000', b'00000000');


-- Dumping structure for table hrms.tbl_pes_aim
CREATE TABLE IF NOT EXISTS `tbl_pes_aim` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `EMPLOYEE_ID` varchar(16) NOT NULL,
  `PES_ID` bigint(16) NOT NULL,
  `MANAGER_ID` varchar(16) NOT NULL,
  `AIM` varchar(64) NOT NULL,
  `DUE_DATE` datetime NOT NULL,
  `RESULT_BY_EMPLOYEE` varchar(16) DEFAULT NULL,
  `RESULT_BY_MANAGER` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_tbl_pes_aim_tbl_employee` (`EMPLOYEE_ID`),
  KEY `FK_tbl_pes_aim_tbl_pes` (`PES_ID`),
  KEY `FK_tbl_pes_aim_tbl_employee_2` (`MANAGER_ID`),
  CONSTRAINT `FK_tbl_pes_aim_tbl_employee` FOREIGN KEY (`EMPLOYEE_ID`) REFERENCES `tbl_employee` (`EMPLOYEEID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_aim_tbl_employee_2` FOREIGN KEY (`MANAGER_ID`) REFERENCES `tbl_employee` (`EMPLOYEEID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_aim_tbl_pes` FOREIGN KEY (`PES_ID`) REFERENCES `tbl_pes` (`ID`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=571 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_pes_aim: ~5 rows (approximately)
INSERT INTO `tbl_pes_aim` (`ID`, `EMPLOYEE_ID`, `PES_ID`, `MANAGER_ID`, `AIM`, `DUE_DATE`, `RESULT_BY_EMPLOYEE`, `RESULT_BY_MANAGER`) VALUES
	(234, '2345', 2222, '3456', 'finalize iteration3', '2012-04-09 03:11:25', 'tamamlandı', 'tamamlandı'),
	(567, '3456', 3333, '2345', 'iteration4', '2012-04-09 03:13:10', 'tam değil', 'tam değil'),
	(568, '4567', 4444, '3456', 'iteration 5', '2012-05-09 03:21:27', NULL, NULL),
	(569, '1234', 1111, '2345', 'iteration 6', '2012-05-08 03:22:23', NULL, 'mid'),
	(570, '1234', 1111, '2345', 'deneme', '2012-06-10 23:31:52', NULL, NULL);


-- Dumping structure for table hrms.tbl_pes_comp
CREATE TABLE IF NOT EXISTS `tbl_pes_comp` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `COMP_NAME` varchar(16) NOT NULL,
  `CREATED_BY` bigint(16) DEFAULT NULL,
  `CREATION_DATE` datetime DEFAULT NULL,
  `MODIFIED_BY` bigint(16) DEFAULT NULL,
  `MODIFY_DATE` datetime DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_tlb_pes_comp_tbl_appl_user` (`CREATED_BY`),
  KEY `FK_tlb_pes_comp_tbl_appl_user_2` (`MODIFIED_BY`),
  CONSTRAINT `FK_tlb_pes_comp_tbl_appl_user` FOREIGN KEY (`CREATED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tlb_pes_comp_tbl_appl_user_2` FOREIGN KEY (`MODIFIED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2014 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_pes_comp: ~9 rows (approximately)
INSERT INTO `tbl_pes_comp` (`ID`, `COMP_NAME`, `CREATED_BY`, `CREATION_DATE`, `MODIFIED_BY`, `MODIFY_DATE`) VALUES
	(2001, 'Access Database', 1, '2012-04-08 20:23:53', 1, '2012-04-08 20:23:52'),
	(2002, 'Access Server', 2, '2012-04-08 20:30:08', 2, '2012-04-08 20:30:05'),
	(2003, 'Modify Database', 3, '2012-04-08 21:10:05', 3, '2012-04-08 21:10:11'),
	(2004, 'Insert New Entry', 4, '2012-04-08 21:10:27', 4, '2012-04-08 21:10:33'),
	(2005, 'Modify Budget', 2, '2012-06-05 16:55:36', 1, NULL),
	(2006, 'Passage\'a gitmek', 2, '2012-05-17 23:11:45', 2, '2012-05-17 23:11:45'),
	(2007, 'Yalincak', 1, NULL, 1, NULL),
	(2008, 'Telwe', 2, NULL, 2, NULL),
	(2011, 'bypass', 2, '2012-06-09 22:55:13', 2, '2012-06-09 22:55:13');


-- Dumping structure for table hrms.tbl_pes_employee_comp
CREATE TABLE IF NOT EXISTS `tbl_pes_employee_comp` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `PES_ID` bigint(16) NOT NULL,
  `EMPLOYEE_ID` varchar(16) NOT NULL,
  `COMP_ID` bigint(16) NOT NULL,
  `CREATED_BY` bigint(16) DEFAULT NULL,
  `CREATION_DATE` datetime DEFAULT NULL,
  `MODIFIED_BY` bigint(16) DEFAULT NULL,
  `MODIFY_DATE` datetime DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_tbl_pes_employee_comp_tbl_pes` (`PES_ID`),
  KEY `FK_tbl_pes_employee_comp_tbl_employee` (`EMPLOYEE_ID`),
  KEY `FK_tbl_pes_employee_comp_tlb_pes_comp` (`COMP_ID`),
  KEY `FK_tbl_pes_employee_comp_tbl_appl_user` (`CREATED_BY`),
  KEY `FK_tbl_pes_employee_comp_tbl_appl_user_2` (`MODIFIED_BY`),
  CONSTRAINT `FK_tbl_pes_employee_comp_tbl_appl_user` FOREIGN KEY (`CREATED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_employee_comp_tbl_appl_user_2` FOREIGN KEY (`MODIFIED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_employee_comp_tbl_employee` FOREIGN KEY (`EMPLOYEE_ID`) REFERENCES `tbl_employee` (`EMPLOYEEID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_employee_comp_tbl_pes` FOREIGN KEY (`PES_ID`) REFERENCES `tbl_pes` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_employee_comp_tlb_pes_comp` FOREIGN KEY (`COMP_ID`) REFERENCES `tbl_pes_comp` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_pes_employee_comp: ~4 rows (approximately)
INSERT INTO `tbl_pes_employee_comp` (`ID`, `PES_ID`, `EMPLOYEE_ID`, `COMP_ID`, `CREATED_BY`, `CREATION_DATE`, `MODIFIED_BY`, `MODIFY_DATE`) VALUES
	(1, 1111, '1234', 2001, 1, NULL, NULL, NULL),
	(2, 2222, '2345', 2002, 2, NULL, NULL, NULL),
	(3, 3333, '3456', 2003, 3, NULL, NULL, NULL),
	(4, 4444, '4567', 2004, 4, NULL, NULL, NULL);


-- Dumping structure for table hrms.tbl_pes_employee_resp
CREATE TABLE IF NOT EXISTS `tbl_pes_employee_resp` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `PES_ID` bigint(16) NOT NULL,
  `EMPLOYEE_ID` varchar(16) NOT NULL,
  `RESP_ID` bigint(16) NOT NULL,
  `CREATED_BY` bigint(16) DEFAULT NULL,
  `CREATION_DATE` datetime DEFAULT NULL,
  `MODIFIED_BY` bigint(16) DEFAULT NULL,
  `MODIFY_DATE` datetime DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `PES_ID` (`PES_ID`),
  KEY `EMPLOYEE_ID` (`EMPLOYEE_ID`),
  KEY `RESP_ID` (`RESP_ID`),
  KEY `CREATED_BY` (`CREATED_BY`),
  KEY `MODIFIED_BY` (`MODIFIED_BY`),
  CONSTRAINT `CREATED_BY` FOREIGN KEY (`CREATED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `EMPLOYEE_ID` FOREIGN KEY (`EMPLOYEE_ID`) REFERENCES `tbl_employee` (`EMPLOYEEID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `MODIFIED_BY` FOREIGN KEY (`MODIFIED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `PES_ID` FOREIGN KEY (`PES_ID`) REFERENCES `tbl_pes` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `RESP_ID` FOREIGN KEY (`RESP_ID`) REFERENCES `tbl_pes_resp` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_pes_employee_resp: ~4 rows (approximately)
INSERT INTO `tbl_pes_employee_resp` (`ID`, `PES_ID`, `EMPLOYEE_ID`, `RESP_ID`, `CREATED_BY`, `CREATION_DATE`, `MODIFIED_BY`, `MODIFY_DATE`) VALUES
	(1, 1111, '1234', 1, NULL, NULL, NULL, NULL),
	(2, 2222, '2345', 2, NULL, NULL, NULL, NULL),
	(3, 3333, '3456', 3, NULL, NULL, NULL, NULL),
	(4, 4444, '4567', 4, NULL, NULL, NULL, NULL);


-- Dumping structure for table hrms.tbl_pes_evaluation_form
CREATE TABLE IF NOT EXISTS `tbl_pes_evaluation_form` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `PES_ID` bigint(16) DEFAULT NULL,
  `EMPLOYEE_ID` varchar(16) DEFAULT NULL,
  `LEADERSHIP_PROFILE` varchar(256) DEFAULT NULL,
  `EVALUATION_FORM_TYPE` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_tbl_pes_evaluation_form_tbl_pes` (`PES_ID`),
  KEY `FK_tbl_pes_evaluation_form_tbl_employee` (`EMPLOYEE_ID`),
  KEY `EVALUATION_FORM_TYPE` (`EVALUATION_FORM_TYPE`),
  CONSTRAINT `FK_tbl_pes_evaluation_form_tbl_employee` FOREIGN KEY (`EMPLOYEE_ID`) REFERENCES `tbl_employee` (`EMPLOYEEID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_evaluation_form_tbl_pes` FOREIGN KEY (`PES_ID`) REFERENCES `tbl_pes` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_pes_evaluation_form: ~2 rows (approximately)
INSERT INTO `tbl_pes_evaluation_form` (`ID`, `PES_ID`, `EMPLOYEE_ID`, `LEADERSHIP_PROFILE`, `EVALUATION_FORM_TYPE`) VALUES
	(4, 4444, '2345', 'developer', 'g'),
	(7, 2222, '1234', 'recorder', 'h');


-- Dumping structure for table hrms.tbl_pes_evaluation_person
CREATE TABLE IF NOT EXISTS `tbl_pes_evaluation_person` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `EVALUATION_TYPE_DEF_ID` bigint(16) NOT NULL,
  `EVALUATION_FORM_ID` bigint(16) NOT NULL,
  `EVALUATOR_ID` varchar(16) NOT NULL,
  `EVALUATION` varchar(10) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_tbl_pes_evaluation_person_tbl_pes_eval_type_def` (`EVALUATION_TYPE_DEF_ID`),
  KEY `FK_tbl_pes_evaluation_person_tbl_pes_evaluation_form` (`EVALUATION_FORM_ID`),
  KEY `FK_tbl_pes_evaluation_person_tbl_employee` (`EVALUATOR_ID`),
  CONSTRAINT `FK_tbl_pes_evaluation_person_tbl_employee` FOREIGN KEY (`EVALUATOR_ID`) REFERENCES `tbl_employee` (`EMPLOYEEID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_evaluation_person_tbl_pes_evaluation_form` FOREIGN KEY (`EVALUATION_FORM_ID`) REFERENCES `tbl_pes_evaluation_form` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_evaluation_person_tbl_pes_eval_type_def` FOREIGN KEY (`EVALUATION_TYPE_DEF_ID`) REFERENCES `tbl_pes_eval_type_def` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_pes_evaluation_person: ~0 rows (approximately)


-- Dumping structure for table hrms.tbl_pes_evaluation_type
CREATE TABLE IF NOT EXISTS `tbl_pes_evaluation_type` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `TITLE` varchar(16) NOT NULL,
  `DESCRIPION` varchar(256) DEFAULT NULL,
  `SEQUENCE` varchar(2) DEFAULT NULL,
  `EVALUATION_FORM_TYPE` varchar(3) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_pes_evaluation_type: ~3 rows (approximately)
INSERT INTO `tbl_pes_evaluation_type` (`ID`, `TITLE`, `DESCRIPION`, `SEQUENCE`, `EVALUATION_FORM_TYPE`) VALUES
	(2, 'Analysing', 'oglum bak git', '3', 'bel'),
	(3, 'Date Structure', 'bas git dedim', '6', 'git'),
	(5, 'File Processing', 'sabir sabir sabir', '2', 'del');


-- Dumping structure for table hrms.tbl_pes_eval_type_def
CREATE TABLE IF NOT EXISTS `tbl_pes_eval_type_def` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `EVALUATION_TYPE_ID` bigint(16) NOT NULL,
  `EVALUATION_FORM_TYPE` varchar(3) NOT NULL,
  `CRITERIA_ID` varchar(16) NOT NULL,
  `DESCRIPION` varchar(64) NOT NULL,
  `SEQUENCE` varchar(64) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_tbl_pes_eval_type_def_tbl_pes_evaluation_type` (`EVALUATION_TYPE_ID`),
  KEY `FK_tbl_pes_eval_type_def_tbl_pes_evaluation_form` (`EVALUATION_FORM_TYPE`),
  CONSTRAINT `FK_tbl_pes_eval_type_def_tbl_pes_evaluation_form` FOREIGN KEY (`EVALUATION_FORM_TYPE`) REFERENCES `tbl_pes_evaluation_form` (`EVALUATION_FORM_TYPE`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_eval_type_def_tbl_pes_evaluation_type` FOREIGN KEY (`EVALUATION_TYPE_ID`) REFERENCES `tbl_pes_evaluation_type` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_pes_eval_type_def: ~0 rows (approximately)


-- Dumping structure for table hrms.tbl_pes_man_comp
CREATE TABLE IF NOT EXISTS `tbl_pes_man_comp` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `PES_ID` bigint(16) NOT NULL,
  `EMPLOYEE_ID` varchar(16) NOT NULL,
  `COMPETENCE` varchar(64) NOT NULL,
  `CREATED_BY` bigint(16) DEFAULT NULL,
  `CREATION_DATE` datetime DEFAULT NULL,
  `MODIFIED_BY` bigint(16) DEFAULT NULL,
  `MODIFY_DATE` datetime DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_tbl_pes_man_comp_tbl_pes` (`PES_ID`),
  KEY `FK_tbl_pes_man_comp_tbl_employee` (`EMPLOYEE_ID`),
  KEY `FK_tbl_pes_man_comp_tbl_appl_user` (`CREATED_BY`),
  KEY `FK_tbl_pes_man_comp_tbl_appl_user_2` (`MODIFIED_BY`),
  CONSTRAINT `FK_tbl_pes_man_comp_tbl_appl_user` FOREIGN KEY (`CREATED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_man_comp_tbl_appl_user_2` FOREIGN KEY (`MODIFIED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_man_comp_tbl_employee` FOREIGN KEY (`EMPLOYEE_ID`) REFERENCES `tbl_employee` (`EMPLOYEEID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_man_comp_tbl_pes` FOREIGN KEY (`PES_ID`) REFERENCES `tbl_pes` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_pes_man_comp: ~4 rows (approximately)
INSERT INTO `tbl_pes_man_comp` (`ID`, `PES_ID`, `EMPLOYEE_ID`, `COMPETENCE`, `CREATED_BY`, `CREATION_DATE`, `MODIFIED_BY`, `MODIFY_DATE`) VALUES
	(1, 4444, '1234', 'java knowledge', 4, NULL, NULL, NULL),
	(2, 2222, '4567', 'c++ knowledge', 3, NULL, NULL, NULL),
	(3, 1111, '2345', 'c# knowledge', 2, NULL, NULL, NULL),
	(4, 3333, '3456', 'c knowledge', NULL, NULL, NULL, NULL);


-- Dumping structure for table hrms.tbl_pes_man_resp
CREATE TABLE IF NOT EXISTS `tbl_pes_man_resp` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `PES_ID` bigint(16) NOT NULL,
  `EMPLOYEE_ID` varchar(16) NOT NULL,
  `RESPONSIBILITY` varchar(64) NOT NULL,
  `CREATED_BY` bigint(16) DEFAULT NULL,
  `CREATION_DATE` datetime DEFAULT NULL,
  `MODIFIED_BY` bigint(16) DEFAULT NULL,
  `MODIFY_DATE` datetime DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_tbl_pes_man_resp_tbl_pes` (`PES_ID`),
  KEY `FK_tbl_pes_man_resp_tbl_employee` (`EMPLOYEE_ID`),
  KEY `FK_tbl_pes_man_resp_tbl_appl_user` (`CREATED_BY`),
  KEY `FK_tbl_pes_man_resp_tbl_appl_user_2` (`MODIFIED_BY`),
  CONSTRAINT `FK_tbl_pes_man_resp_tbl_appl_user` FOREIGN KEY (`CREATED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_man_resp_tbl_appl_user_2` FOREIGN KEY (`MODIFIED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_man_resp_tbl_employee` FOREIGN KEY (`EMPLOYEE_ID`) REFERENCES `tbl_employee` (`EMPLOYEEID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_man_resp_tbl_pes` FOREIGN KEY (`PES_ID`) REFERENCES `tbl_pes` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_pes_man_resp: ~4 rows (approximately)
INSERT INTO `tbl_pes_man_resp` (`ID`, `PES_ID`, `EMPLOYEE_ID`, `RESPONSIBILITY`, `CREATED_BY`, `CREATION_DATE`, `MODIFIED_BY`, `MODIFY_DATE`) VALUES
	(1, 1111, '1234', 'eclipse', NULL, NULL, NULL, NULL),
	(2, 2222, '2345', 'netbeans', NULL, NULL, NULL, NULL),
	(3, 3333, '3456', 'zk', NULL, NULL, NULL, NULL),
	(4, 4444, '4567', 'hibernate', NULL, NULL, NULL, NULL);


-- Dumping structure for table hrms.tbl_pes_pos_comp
CREATE TABLE IF NOT EXISTS `tbl_pes_pos_comp` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `POSITIONID` varchar(16) DEFAULT NULL,
  `COMP_ID` bigint(16) DEFAULT NULL,
  `CREATED_BY` bigint(16) DEFAULT NULL,
  `CREATION_DATE` datetime DEFAULT NULL,
  `MODIFIED_BY` bigint(16) DEFAULT NULL,
  `MODIFY_DATE` datetime DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_tbl_pes_pos_comp_tbl_employee` (`POSITIONID`),
  KEY `FK_tbl_pes_pos_comp_tlb_pes_comp` (`COMP_ID`),
  KEY `FK_tbl_pes_pos_comp_tbl_appl_user` (`CREATED_BY`),
  KEY `FK_tbl_pes_pos_comp_tbl_appl_user_2` (`MODIFIED_BY`),
  CONSTRAINT `FK_tbl_pes_pos_comp_tbl_appl_user` FOREIGN KEY (`CREATED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_pos_comp_tbl_appl_user_2` FOREIGN KEY (`MODIFIED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_pos_comp_tbl_employee` FOREIGN KEY (`POSITIONID`) REFERENCES `tbl_employee` (`POSITIONID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_pos_comp_tlb_pes_comp` FOREIGN KEY (`COMP_ID`) REFERENCES `tbl_pes_comp` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_pes_pos_comp: ~4 rows (approximately)
INSERT INTO `tbl_pes_pos_comp` (`ID`, `POSITIONID`, `COMP_ID`, `CREATED_BY`, `CREATION_DATE`, `MODIFIED_BY`, `MODIFY_DATE`) VALUES
	(1, '2', 2001, 2, '2012-06-09 20:09:48', 2, '2012-06-09 20:09:50'),
	(2, 'h', 2002, NULL, NULL, NULL, NULL),
	(3, '4', 2004, NULL, NULL, NULL, NULL),
	(4, '3', 2005, NULL, NULL, NULL, NULL);


-- Dumping structure for table hrms.tbl_pes_pos_resp
CREATE TABLE IF NOT EXISTS `tbl_pes_pos_resp` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `POSITIONID` varchar(16) NOT NULL,
  `RESP_ID` bigint(16) NOT NULL,
  `CREATED_BY` bigint(16) DEFAULT NULL,
  `CREATION_DATE` datetime DEFAULT NULL,
  `MODIFIED_BY` bigint(16) DEFAULT NULL,
  `MODIFY_DATE` datetime DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `POSITION_ID` (`POSITIONID`),
  KEY `FK_tbl_pes_pos_resp_tbl_pes_resp` (`RESP_ID`),
  KEY `FK_tbl_pes_pos_resp_tbl_appl_user` (`CREATED_BY`),
  KEY `FK_tbl_pes_pos_resp_tbl_appl_user_2` (`MODIFIED_BY`),
  CONSTRAINT `FK_tbl_pes_pos_resp_tbl_appl_user` FOREIGN KEY (`CREATED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_pos_resp_tbl_appl_user_2` FOREIGN KEY (`MODIFIED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_pos_resp_tbl_pes_resp` FOREIGN KEY (`RESP_ID`) REFERENCES `tbl_pes_resp` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `POSITION_ID` FOREIGN KEY (`POSITIONID`) REFERENCES `tbl_employee` (`POSITIONID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_pes_pos_resp: ~4 rows (approximately)
INSERT INTO `tbl_pes_pos_resp` (`ID`, `POSITIONID`, `RESP_ID`, `CREATED_BY`, `CREATION_DATE`, `MODIFIED_BY`, `MODIFY_DATE`) VALUES
	(1, '2', 1, 4, '2012-05-15 15:57:04', 1, '2012-05-14 17:57:29'),
	(2, 'h', 2, 2, '2012-05-15 16:57:06', 2, '2012-05-13 17:57:31'),
	(3, '4', 3, 3, '2012-05-15 14:57:08', 3, '2012-05-13 17:57:33'),
	(4, '3', 4, 1, '2012-05-15 14:57:10', 4, '2012-05-15 17:57:32');


-- Dumping structure for table hrms.tbl_pes_project_aim
CREATE TABLE IF NOT EXISTS `tbl_pes_project_aim` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `PROJECT_ID` varchar(16) NOT NULL,
  `AIM` varchar(64) NOT NULL,
  `DUE_DATE` datetime NOT NULL,
  `CREATED_BY` bigint(16) DEFAULT NULL,
  `CREATION_DATE` datetime DEFAULT NULL,
  `MODIFIED_BY` bigint(16) DEFAULT NULL,
  `MODIFY_DATE` datetime DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_tbl_pes_project_aim_tbl_employee_projects` (`PROJECT_ID`),
  KEY `FK_tbl_pes_project_aim_tbl_appl_user` (`CREATED_BY`),
  KEY `FK_tbl_pes_project_aim_tbl_appl_user_2` (`MODIFIED_BY`),
  CONSTRAINT `FK_tbl_pes_project_aim_tbl_appl_user` FOREIGN KEY (`CREATED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_project_aim_tbl_appl_user_2` FOREIGN KEY (`MODIFIED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_project_aim_tbl_employee_projects` FOREIGN KEY (`PROJECT_ID`) REFERENCES `tbl_employee_projects` (`PROJECTID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_pes_project_aim: ~9 rows (approximately)
INSERT INTO `tbl_pes_project_aim` (`ID`, `PROJECT_ID`, `AIM`, `DUE_DATE`, `CREATED_BY`, `CREATION_DATE`, `MODIFIED_BY`, `MODIFY_DATE`) VALUES
	(3, '1', 'developer', '2012-05-14 15:36:05', 2, '2012-05-14 13:44:31', 2, '2012-05-14 13:44:46'),
	(4, '1', 'organizer', '2012-05-14 15:32:32', 3, '2012-05-14 14:44:33', 4, '2012-05-14 13:44:48'),
	(5, '1', 'testing', '2012-05-14 13:35:42', 1, '2012-05-14 12:44:35', 2, '2012-05-14 13:44:50'),
	(8, '1', 'oynamak', '2012-05-16 02:39:53', 2, '2012-05-16 02:39:53', 2, '2012-05-16 02:39:53'),
	(9, '1', 'hehehehe', '2012-05-16 02:47:30', 2, '2012-05-16 02:47:30', 2, '2012-05-16 02:47:30'),
	(10, '1', 'BYBY', '2012-05-16 02:54:35', 2, '2012-05-16 02:54:35', 2, '2012-05-16 02:54:35'),
	(11, '1', 'sinirlari asmak', '2012-05-16 02:56:37', 2, '2012-05-16 02:56:37', 2, '2012-05-16 02:56:37'),
	(12, '1', 'PANDA', '2012-05-17 19:58:25', 2, '2012-05-17 19:58:25', 2, '2012-05-17 19:58:25'),
	(13, '1', 'gelistirmek', '2012-05-17 20:10:54', 2, '2012-05-17 20:10:54', 2, '2012-05-17 20:10:54');


-- Dumping structure for table hrms.tbl_pes_resp
CREATE TABLE IF NOT EXISTS `tbl_pes_resp` (
  `ID` bigint(16) NOT NULL AUTO_INCREMENT,
  `RESP_NAME` varchar(64) NOT NULL,
  `CREATED_BY` bigint(16) DEFAULT NULL,
  `CREATION_DATE` datetime DEFAULT NULL,
  `MODIFIED_BY` bigint(16) DEFAULT NULL,
  `MODIFY_DATE` datetime DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `FK_tbl_pes_resp_created_by_tbl_appl_user` (`CREATED_BY`),
  KEY `FK_tbl_pes_resp_modified_by_tbl_appl_user` (`MODIFIED_BY`),
  CONSTRAINT `FK_tbl_pes_resp_created_by_tbl_appl_user` FOREIGN KEY (`CREATED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `FK_tbl_pes_resp_modified_by_tbl_appl_user` FOREIGN KEY (`MODIFIED_BY`) REFERENCES `tbl_appl_user` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

-- Dumping data for table hrms.tbl_pes_resp: ~8 rows (approximately)
INSERT INTO `tbl_pes_resp` (`ID`, `RESP_NAME`, `CREATED_BY`, `CREATION_DATE`, `MODIFIED_BY`, `MODIFY_DATE`) VALUES
	(1, 'Developer', 1, '2012-05-15 18:02:26', 4, '2012-05-15 18:02:38'),
	(2, 'Security ', 2, '2012-05-15 18:02:27', 3, '2012-05-15 18:02:36'),
	(3, 'Guard', 3, '2012-05-15 18:02:28', 2, '2012-06-09 14:27:21'),
	(4, 'Secratary', 4, '2012-05-15 18:02:32', 1, '2012-06-09 14:27:21'),
	(5, 'temizlik', 2, '2012-05-17 22:13:48', 2, '2012-05-17 22:13:48'),
	(6, 'Satici', 1, '2012-06-09 14:27:02', 1, '2012-06-09 14:27:19'),
	(7, 'Alici', 2, '2012-06-09 14:27:06', 2, '2012-06-09 14:27:16'),
	(8, 'Bilgi Islem', 3, '2012-06-09 14:27:08', 3, '2012-06-09 14:27:14');
