CREATE TABLE temp_deleteMe (
  data_provider_id smallint(5) unsigned NOT NULL,
  data_resource_id smallint(5) unsigned NOT NULL,
  Basis_of_record varchar(100) DEFAULT NULL,
  Scientific_name_interpreted text,
  Kingdom_original varchar(150) DEFAULT NULL,
  Phylum_original varchar(150) DEFAULT NULL,
  Class_original varchar(250) DEFAULT NULL,
  Order_rank_original varchar(50) DEFAULT NULL,
  Family_original varchar(250) DEFAULT NULL,
  Latitude varchar(50) DEFAULT NULL,
  Longitude varchar(50) DEFAULT NULL,
  Coordinate_precision varchar(50) DEFAULT NULL,
  geospatial_issue mediumint(8) unsigned DEFAULT NULL,
  occurrence_id int(10) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;