CREATE TEMPORARY TABLE IF NOT EXISTS `temp_ymk2liste` (
  `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `gcid` BIGINT(20) DEFAULT NULL, 
  `kartno` VARCHAR(10) COLLATE latin5_turkish_ci DEFAULT NULL,
  `isim` VARCHAR(100) COLLATE latin5_turkish_ci DEFAULT NULL, 
  `giristarihi` DATE DEFAULT NULL,
  `girissaati` TIME DEFAULT NULL,
  `cikistarihi` DATE DEFAULT NULL,
  `cikissaati` TIME DEFAULT NULL,
  `surefarki` VARCHAR(20) COLLATE latin5_turkish_ci DEFAULT NULL,
  `ogun` VARCHAR(100) COLLATE latin5_turkish_ci DEFAULT NULL,
  `bolumad` VARCHAR(200) COLLATE latin5_turkish_ci DEFAULT NULL,
  `grupad` VARCHAR(200) COLLATE latin5_turkish_ci DEFAULT NULL, 
  `firmaad` VARCHAR(200) COLLATE latin5_turkish_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
)ENGINE=InnoDB
AUTO_INCREMENT=1 CHARACTER SET 'latin5' COLLATE 'latin5_turkish_ci';