CREATE TEMPORARY TABLE IF NOT EXISTS `temp_personel3` (
  `kartno` VARCHAR(10) COLLATE latin5_turkish_ci DEFAULT NULL,
  `isim` VARCHAR(150) COLLATE latin5_turkish_ci DEFAULT NULL,
`ad` VARCHAR(70) COLLATE latin5_turkish_ci DEFAULT NULL,
`soyad` VARCHAR(70) COLLATE latin5_turkish_ci DEFAULT NULL,
`kimlikno` VARCHAR(15) COLLATE latin5_turkish_ci DEFAULT NULL,
`ncgun` VARCHAR(6) NULL DEFAULT NULL,
`mesaisaat` VARCHAR(10) NULL DEFAULT NULL,
`devamsizliksaat` VARCHAR(6) NULL DEFAULT NULL,
`agi` DECIMAL(11,2) DEFAULT NULL,
`net` DECIMAL(11,2) DEFAULT NULL,
  `dogumtarihi` DATE DEFAULT NULL,
  `kalangun` INTEGER(11) DEFAULT NULL 
   
)ENGINE=InnoDB
AUTO_INCREMENT=0 CHARACTER SET 'latin5' COLLATE 'latin5_turkish_ci';