CREATE TABLE `egitim` (
	`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
	`kod` VARCHAR(10) NULL DEFAULT NULL,
	`ad` VARCHAR(60) NULL DEFAULT NULL,
	PRIMARY KEY (`id`)
)
COLLATE='latin5_turkish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=0;

CREATE TABLE `personel_egitim` (
	`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
	`personelid` BIGINT(20) NOT NULL,
	`egitimid` INT(11) NULL DEFAULT NULL,
	`tarih` DATE NULL DEFAULT NULL,
	`sure` INT(11) NULL DEFAULT NULL,
	`aciklama` VARCHAR(500) NULL DEFAULT NULL,
	PRIMARY KEY (`id`),
	INDEX `personelid` (`personelid`, `tarih`)
)
COLLATE='latin5_turkish_ci'
ENGINE=InnoDB;



CREATE TABLE `personel_dosya` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`personelid` BIGINT(11) NOT NULL,
	`ad` VARCHAR(200) NULL DEFAULT NULL,
	`konum` VARCHAR(600) NULL DEFAULT NULL,
	PRIMARY KEY (`id`),
	INDEX `personelid` (`personelid`)
)
COLLATE='latin5_turkish_ci'
ENGINE=InnoDB;

alter table `personel_egitim` add `sure` INT(11) NULL DEFAULT NULL;
