CREATE TABLE GBIF_Export (
  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,
  Collector_name varchar(255) NOT NULL DEFAULT '',
  Collector_number char(0) CHARACTER SET latin1 NOT NULL DEFAULT '',
  Field_number char(0) CHARACTER SET latin1 NOT NULL DEFAULT '',
  GUID char(0) CHARACTER SET latin1 NOT NULL DEFAULT '',
  Date_collected date DEFAULT NULL,
  Institution_code varchar(255) DEFAULT NULL,
  Collection_code varchar(255) DEFAULT NULL,
  Catalogue_number varchar(255) DEFAULT NULL,
  Basis_of_record varchar(100) DEFAULT NULL,
  Image_url varchar(255),
  last_indexed timestamp NULL DEFAULT NULL,
  Identifier varchar(255) DEFAULT NULL,
  Identification_date datetime DEFAULT NULL,
  Scientific_name varchar(255) NOT NULL DEFAULT '',
  Author varchar(255) NOT NULL DEFAULT '',
  Scientific_name_interpreted text,
  Kingdom_original varchar(150) DEFAULT NULL,
  Kingdom text,
  Phylum_original varchar(150) DEFAULT NULL,
  Phylum text,
  Class_original varchar(250) DEFAULT NULL,
  Class text,
  Order_rank_original varchar(50) DEFAULT NULL,
  Order_rank text,
  Family_original varchar(250) DEFAULT NULL,
  Family text,
  Genus_original varchar(150) DEFAULT NULL,
  Genus text,
  Country varchar(100) NOT NULL DEFAULT '',
  Country_interpreted varchar(2) NOT NULL DEFAULT '',
  Locality longtext NOT NULL,
  County varchar(100) DEFAULT NULL,
  Continent_or_Ocean varchar(100) DEFAULT NULL,
  State_Province varchar(100) DEFAULT NULL,
  Region char(3) DEFAULT NULL,
  Provider_country char(2) DEFAULT NULL,
  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,
  cell_id smallint(5) unsigned DEFAULT NULL,
  centi_cell_id tinyint(3) unsigned DEFAULT NULL,
  Min_depth varchar(50) DEFAULT NULL,
  Max_depth varchar(50) DEFAULT NULL,
  Min_altitude varchar(50) DEFAULT NULL,
  Max_altitude varchar(50) DEFAULT NULL,
  Altitude_precision varchar(50) DEFAULT NULL,
  gbif_portal_url varchar(43) CHARACTER SET latin1 NOT NULL DEFAULT '',
  gbif_webservice_url varchar(54) CHARACTER SET latin1 NOT NULL DEFAULT '',
  occurrence_id int(10) unsigned NOT NULL,
  nub_concept_id int(10) unsigned DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;