CREATE TEMPORARY TABLE IF NOT EXISTS `temp_yillikizin2` (
	`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
        `personelid` BIGINT(20) NOT NULL,
	`kartno` VARCHAR(10) NULL DEFAULT NULL,
	`isim` VARCHAR(60) NULL DEFAULT NULL,
        `grupad` VARCHAR(200) NULL DEFAULT NULL,
	`bolumad` VARCHAR(200) NULL DEFAULT NULL,
	`gorevad` VARCHAR(200) NULL DEFAULT NULL,
	`isegiristarihi` DATE NULL DEFAULT NULL,
	`dogumtarihi` DATE NULL DEFAULT NULL,
	`toplamgun` INT(11) NULL DEFAULT NULL,
	`toplamyil` INT(11) NULL DEFAULT NULL,
	`yas` INT(11) NULL DEFAULT NULL,
	`hakedilen`INT(11) NULL DEFAULT NULL,
        `eklenen` INT(11) NULL DEFAULT NULL, 
	`kullanilan` INT(11) NULL DEFAULT NULL,
	`kalan` INT(11) NULL DEFAULT NULL,
	PRIMARY KEY (`id`)
)
COLLATE='latin5_turkish_ci'
ENGINE=InnoDB
ROW_FORMAT=DEFAULT
AUTO_INCREMENT=1