CREATE TABLE GBIFexport (
  data_provider_id smallint(5) unsigned NOT NULL,
  data_resource_id smallint(5) unsigned NOT NULL,
  Data_provider varchar(255) DEFAULT NULL,
  Dataset varchar(255) DEFAULT NULL,
  Date_collected date DEFAULT NULL,
  Institution_code varchar(255) DEFAULT NULL,
  Basis_of_record varchar(100) DEFAULT NULL,
  Scientific_name_original varchar(255) DEFAULT NULL,
  Scientific_name text,
  Genus_original varchar(150) DEFAULT NULL,
  Genus text,
  Latitude varchar(50) DEFAULT NULL,
  Latitude_interpreted float DEFAULT NULL,
  Longitude varchar(50) DEFAULT NULL,
  Longitude_interpreted float DEFAULT NULL,
  Coordinate_precision varchar(50) DEFAULT NULL,
  geospatial_issue mediumint(8) unsigned DEFAULT NULL,
  occurrence_id int(10) unsigned NOT NULL,
  nub_concept_id int(10) unsigned DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;