CREATE TEMPORARY TABLE IF NOT EXISTS `temp_extra` (
  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
   `eid` BIGINT(20) UNSIGNED DEFAULT NULL,	
  `kartno` VARCHAR(10) COLLATE latin5_turkish_ci DEFAULT NULL,
  `ad` VARCHAR(60) COLLATE latin5_turkish_ci DEFAULT NULL,
  `soyad` VARCHAR(60) COLLATE latin5_turkish_ci DEFAULT NULL,
  `isim` VARCHAR(120) COLLATE latin5_turkish_ci DEFAULT NULL, 
  `extraad` VARCHAR(60) COLLATE latin5_turkish_ci DEFAULT NULL,	
  `grupad` VARCHAR(150) COLLATE latin5_turkish_ci DEFAULT NULL,
  `bolumad` VARCHAR(150) COLLATE latin5_turkish_ci DEFAULT NULL, 
  `kazanc` VARCHAR(10) COLLATE latin5_turkish_ci DEFAULT NULL,
  `tarih` DATE DEFAULT NULL,
  `tutar` DECIMAL(11,2) DEFAULT NULL,
  `aciklama` VARCHAR(150) COLLATE latin5_turkish_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
)ENGINE=InnoDB
AUTO_INCREMENT=7827 CHARACTER SET 'latin5' COLLATE 'latin5_turkish_ci';