CREATE TABLE GBIFexport (
  TaxonOccurrence_gbifKey int(10) unsigned NOT NULL,
  TaxonOccurrence_about varchar(54) CHARACTER SET latin1 NOT NULL DEFAULT '',
  basisOfRecordString varchar(100) DEFAULT NULL,
  catalogNumber varchar(255) DEFAULT NULL,
  collectionCode varchar(255) DEFAULT NULL,
  collector varchar(255) NOT NULL DEFAULT '',
  country varchar(100) NOT NULL DEFAULT '',
  country_code_interpreted char(2) DEFAULT NULL,
  decimalLatitude varchar(50) DEFAULT NULL,
  decimalLongitude varchar(50) DEFAULT NULL,
  decimalLatitude_interpreted float DEFAULT NULL,
  decimalLongitude_interpreted float DEFAULT NULL,
  geospatial_issue_flag mediumint(8) unsigned DEFAULT NULL,
  institutionCode varchar(255) DEFAULT NULL,
  earliestDateCollected date DEFAULT NULL,
  latestDateCollected date DEFAULT NULL,
  TaxonConcept_gbifKey int(10) unsigned NOT NULL,
  TaxonConcept_about varchar(49) CHARACTER SET latin1 NOT NULL DEFAULT '',
  NubConcept_gbifKey int(10) unsigned DEFAULT NULL,
  nameComplete varchar(255) DEFAULT NULL,
  scientific varchar(4) CHARACTER SET latin1 NOT NULL DEFAULT '',
  taxonName varchar(255) DEFAULT NULL,
  locality longtext NOT NULL,
  gbifNotes varchar(44) CHARACTER SET latin1 NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8;