-- Table structure for table `QRTZ_BLOB_TRIGGERS`
--

DROP TABLE IF EXISTS `QRTZ_BLOB_TRIGGERS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `QRTZ_BLOB_TRIGGERS` (
  `trigger_name` varchar(100) NOT NULL,
  `trigger_group` varchar(100) NOT NULL,
  `blob_data` blob,
  PRIMARY KEY (`trigger_name`,`trigger_group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `QRTZ_CALENDARS`
--

DROP TABLE IF EXISTS `QRTZ_CALENDARS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `QRTZ_CALENDARS` (
  `calendar_name` varchar(255) NOT NULL,
  `calendar` blob NOT NULL,
  PRIMARY KEY (`calendar_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `QRTZ_CRON_TRIGGERS`
--

DROP TABLE IF EXISTS `QRTZ_CRON_TRIGGERS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `QRTZ_CRON_TRIGGERS` (
  `trigger_name` varchar(100) NOT NULL,
  `trigger_group` varchar(100) NOT NULL,
  `cron_expression` varchar(255) NOT NULL,
  `time_zone_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`trigger_name`,`trigger_group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `QRTZ_FIRED_TRIGGERS`
--

DROP TABLE IF EXISTS `QRTZ_FIRED_TRIGGERS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `QRTZ_FIRED_TRIGGERS` (
  `entry_id` varchar(95) NOT NULL,
  `trigger_name` varchar(100) NOT NULL,
  `trigger_group` varchar(100) NOT NULL,
  `is_volatile` varchar(1) NOT NULL,
  `instance_name` varchar(255) NOT NULL,
  `fired_time` bigint(13) NOT NULL,
  `priority` int(11) NOT NULL,
  `state` varchar(16) NOT NULL,
  `job_name` varchar(100) DEFAULT NULL,
  `job_group` varchar(100) DEFAULT NULL,
  `is_stateful` varchar(1) DEFAULT NULL,
  `requests_recovery` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`entry_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `QRTZ_JOB_DETAILS`
--

DROP TABLE IF EXISTS `QRTZ_JOB_DETAILS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `QRTZ_JOB_DETAILS` (
  `job_name` varchar(100) NOT NULL,
  `job_group` varchar(100) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `job_class_name` varchar(128) NOT NULL,
  `is_durable` varchar(1) NOT NULL,
  `is_volatile` varchar(1) NOT NULL,
  `is_stateful` varchar(1) NOT NULL,
  `requests_recovery` varchar(1) NOT NULL,
  `job_data` blob,
  PRIMARY KEY (`job_name`,`job_group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `QRTZ_JOB_LISTENERS`
--

DROP TABLE IF EXISTS `QRTZ_JOB_LISTENERS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `QRTZ_JOB_LISTENERS` (
  `job_name` varchar(100) NOT NULL,
  `job_group` varchar(100) NOT NULL,
  `job_listener` varchar(100) NOT NULL,
  PRIMARY KEY (`job_name`,`job_group`,`job_listener`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `QRTZ_LOCKS`
--

DROP TABLE IF EXISTS `QRTZ_LOCKS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `QRTZ_LOCKS` (
  `lock_name` varchar(40) NOT NULL,
  PRIMARY KEY (`lock_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `QRTZ_PAUSED_TRIGGER_GRPS`
--

DROP TABLE IF EXISTS `QRTZ_PAUSED_TRIGGER_GRPS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `QRTZ_PAUSED_TRIGGER_GRPS` (
  `trigger_group` varchar(100) NOT NULL,
  PRIMARY KEY (`trigger_group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `QRTZ_SCHEDULER_STATE`
--

DROP TABLE IF EXISTS `QRTZ_SCHEDULER_STATE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `QRTZ_SCHEDULER_STATE` (
  `instance_name` varchar(255) NOT NULL,
  `last_checkin_time` bigint(13) NOT NULL,
  `checkin_interval` bigint(13) NOT NULL,
  PRIMARY KEY (`instance_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `QRTZ_SIMPLE_TRIGGERS`
--

DROP TABLE IF EXISTS `QRTZ_SIMPLE_TRIGGERS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `QRTZ_SIMPLE_TRIGGERS` (
  `trigger_name` varchar(100) NOT NULL,
  `trigger_group` varchar(100) NOT NULL,
  `repeat_count` bigint(7) NOT NULL,
  `repeat_interval` bigint(12) NOT NULL,
  `times_triggered` bigint(7) NOT NULL,
  PRIMARY KEY (`trigger_name`,`trigger_group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `QRTZ_TRIGGERS`
--

DROP TABLE IF EXISTS `QRTZ_TRIGGERS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `QRTZ_TRIGGERS` (
  `trigger_name` varchar(100) NOT NULL,
  `trigger_group` varchar(100) NOT NULL,
  `job_name` varchar(100) NOT NULL,
  `job_group` varchar(100) NOT NULL,
  `is_volatile` varchar(1) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `next_fire_time` bigint(13) DEFAULT NULL,
  `prev_fire_time` bigint(13) DEFAULT NULL,
  `priority` int(11) DEFAULT NULL,
  `trigger_state` varchar(16) NOT NULL,
  `trigger_type` varchar(8) NOT NULL,
  `start_time` bigint(13) NOT NULL,
  `end_time` bigint(13) DEFAULT NULL,
  `calendar_name` varchar(255) DEFAULT NULL,
  `misfire_instr` smallint(2) DEFAULT NULL,
  `job_data` blob,
  PRIMARY KEY (`trigger_name`,`trigger_group`),
  KEY `job_name` (`job_name`,`job_group`),
  KEY `ix_qrtz_nft` (`next_fire_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `QRTZ_TRIGGER_LISTENERS`
--

DROP TABLE IF EXISTS `QRTZ_TRIGGER_LISTENERS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `QRTZ_TRIGGER_LISTENERS` (
  `trigger_name` varchar(100) NOT NULL,
  `trigger_group` varchar(100) NOT NULL,
  `trigger_listener` varchar(100) NOT NULL,
  PRIMARY KEY (`trigger_name`,`trigger_group`,`trigger_listener`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `agent`
--

DROP TABLE IF EXISTS `agent`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `agent` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `address` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `telephone` varchar(255) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `deleted` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4456 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `backup_data_provider_nov15_kyle`
--

DROP TABLE IF EXISTS `backup_data_provider_nov15_kyle`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `backup_data_provider_nov15_kyle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `description` text,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `at_latitude` float DEFAULT NULL,
  `at_longitude` float DEFAULT NULL,
  `website_url` varchar(255) DEFAULT NULL,
  `logo_url` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `telephone` varchar(255) DEFAULT NULL,
  `uuid` char(50) DEFAULT NULL,
  `concept_count` int(11) DEFAULT '0',
  `higher_concept_count` int(11) DEFAULT '0',
  `species_count` int(11) DEFAULT '0',
  `occurrence_count` int(11) DEFAULT '0',
  `occurrence_coordinate_count` int(11) DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `deleted` datetime DEFAULT NULL,
  `iso_country_code` char(2) DEFAULT NULL,
  `stated_count_served` int(11) DEFAULT NULL,
  `gbif_approver` varchar(255) DEFAULT NULL,
  `lock_description` tinyint(1) NOT NULL DEFAULT '0',
  `lock_iso_country_code` tinyint(1) NOT NULL DEFAULT '0',
  `data_resource_count` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `IX_data_provider_name` (`name`),
  KEY `IX_data_provider_country` (`iso_country_code`)
) ENGINE=MyISAM AUTO_INCREMENT=474 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `backup_data_resource_nov15_kyle`
--

DROP TABLE IF EXISTS `backup_data_resource_nov15_kyle`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `backup_data_resource_nov15_kyle` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data_provider_id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `display_name` varchar(255) DEFAULT NULL,
  `description` text,
  `rights` text,
  `citation` text,
  `logo_url` varchar(255) DEFAULT NULL,
  `shared_taxonomy` tinyint(1) DEFAULT '0',
  `concept_count` int(11) DEFAULT '0',
  `higher_concept_count` int(11) DEFAULT '0',
  `species_count` int(11) DEFAULT '0',
  `occurrence_count` int(11) DEFAULT '0',
  `occurrence_coordinate_count` int(11) DEFAULT '0',
  `basis_of_record` int(11) NOT NULL DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `deleted` datetime DEFAULT NULL,
  `citable_agent` varchar(255) DEFAULT NULL,
  `root_taxon_rank` int(11) DEFAULT NULL,
  `root_taxon_name` varchar(150) DEFAULT NULL,
  `scope_continent_code` char(2) DEFAULT NULL,
  `scope_country_code` char(2) DEFAULT NULL,
  `provider_record_count` int(11) DEFAULT NULL,
  `taxonomic_priority` int(11) NOT NULL DEFAULT '100',
  `website_url` varchar(255) DEFAULT NULL,
  `occurrence_clean_geospatial_count` int(11) DEFAULT NULL,
  `lock_display_name` tinyint(1) NOT NULL DEFAULT '0',
  `lock_citable_agent` tinyint(1) NOT NULL DEFAULT '0',
  `lock_basis_of_record` tinyint(1) NOT NULL DEFAULT '0',
  `override_citation` tinyint(1) NOT NULL DEFAULT '0',
  `gbif_registry_uuid` char(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `data_provider_id` (`data_provider_id`),
  KEY `IX_data_resource_name` (`name`),
  KEY `IX_data_resource_display_name` (`display_name`),
  KEY `IX_data_resource_shared_taxonomy` (`shared_taxonomy`)
) ENGINE=MyISAM AUTO_INCREMENT=14568 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `bi_relation_tag`
--

DROP TABLE IF EXISTS `bi_relation_tag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `bi_relation_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tag_id` int(11) DEFAULT NULL,
  `to_entity_id` int(11) DEFAULT NULL,
  `from_entity_id` int(11) DEFAULT NULL,
  `count` int(10) unsigned DEFAULT NULL,
  `is_system_generated` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tag_id` (`tag_id`),
  KEY `ix_bi_relation_tag_tag_id` (`tag_id`),
  KEY `ix_bi_relation_tag_tag_id_to_entity_id` (`tag_id`,`to_entity_id`),
  KEY `ix_bi_relation_tag_tag_id_from_entity_id` (`tag_id`,`from_entity_id`)
) ENGINE=MyISAM AUTO_INCREMENT=256598456 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `boolean_tag`
--

DROP TABLE IF EXISTS `boolean_tag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `boolean_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tag_id` int(11) DEFAULT NULL,
  `entity_id` int(11) DEFAULT NULL,
  `is_true` tinyint(1) DEFAULT '0',
  `is_system_generated` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tag_id` (`tag_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `catalogue_number`
--

DROP TABLE IF EXISTS `catalogue_number`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `catalogue_number` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_cn_catalogue_number` (`code`)
) ENGINE=MyISAM AUTO_INCREMENT=297418559 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `cell_country`
--

DROP TABLE IF EXISTS `cell_country`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cell_country` (
  `cell_id` int(11) NOT NULL,
  `iso_country_code` char(2) NOT NULL,
  PRIMARY KEY (`cell_id`,`iso_country_code`),
  KEY `IX_cell_ids` (`cell_id`),
  KEY `IX_iso_country_codes` (`iso_country_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `cell_density`
--

DROP TABLE IF EXISTS `cell_density`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cell_density` (
  `type` smallint(5) unsigned NOT NULL,
  `entity_id` int(10) unsigned NOT NULL,
  `cell_id` smallint(5) unsigned NOT NULL,
  `count` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`type`,`entity_id`,`cell_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `centi_cell_density`
--

DROP TABLE IF EXISTS `centi_cell_density`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `centi_cell_density` (
  `type` smallint(5) unsigned NOT NULL,
  `entity_id` int(10) unsigned NOT NULL,
  `cell_id` smallint(5) unsigned NOT NULL,
  `centi_cell_id` tinyint(3) unsigned NOT NULL,
  `count` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`type`,`entity_id`,`cell_id`,`centi_cell_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `collection_code`
--

DROP TABLE IF EXISTS `collection_code`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `collection_code` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_cc_collection_code` (`code`)
) ENGINE=MyISAM AUTO_INCREMENT=1939467 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `common_name`
--

DROP TABLE IF EXISTS `common_name`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `common_name` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `taxon_concept_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
  `iso_language_code` char(2) COLLATE utf8mb4_bin DEFAULT NULL,
  `language` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `taxon_concept_id` (`taxon_concept_id`),
  KEY `IX_common_name_1` (`name`(50)),
  KEY `IX_common_name_2` (`iso_language_code`),
  KEY `IX_common_name_3` (`language`(100))
) ENGINE=MyISAM AUTO_INCREMENT=19723683 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `common_name_orig`
--

DROP TABLE IF EXISTS `common_name_orig`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `common_name_orig` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `taxon_concept_id` int(11) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `iso_language_code` char(2) DEFAULT NULL,
  `language` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `taxon_concept_id` (`taxon_concept_id`),
  KEY `IX_common_name_1` (`name`),
  KEY `IX_common_name_2` (`iso_language_code`),
  KEY `IX_common_name_3` (`language`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `country`
--

DROP TABLE IF EXISTS `country`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `country` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `iso_country_code` char(2) DEFAULT NULL,
  `concept_count` int(11) DEFAULT '0',
  `species_count` int(11) DEFAULT '0',
  `occurrence_count` int(11) DEFAULT '0',
  `occurrence_coordinate_count` int(11) DEFAULT '0',
  `continent_code` enum('AF','AS','EU','NA','OC','SA','AN') DEFAULT NULL,
  `region` char(3) DEFAULT NULL,
  `min_latitude` float DEFAULT NULL,
  `max_latitude` float DEFAULT NULL,
  `min_longitude` float DEFAULT NULL,
  `max_longitude` float DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_country_iso_country_code` (`iso_country_code`),
  KEY `IX_country_continent_code` (`continent_code`),
  KEY `IX_country_region` (`region`)
) ENGINE=MyISAM AUTO_INCREMENT=254 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `country_name`
--

DROP TABLE IF EXISTS `country_name`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `country_name` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `country_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `searchable_name` varchar(255) DEFAULT NULL,
  `iso_country_code` char(2) DEFAULT NULL,
  `locale` char(2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `country_id` (`country_id`),
  KEY `IX_country_name_name` (`name`),
  KEY `IX_country_name_searchable_name` (`searchable_name`),
  KEY `IX_country_name_iso_country_code` (`iso_country_code`),
  KEY `IX_country_name_locale` (`locale`)
) ENGINE=MyISAM AUTO_INCREMENT=2909 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `data_provider`
--

DROP TABLE IF EXISTS `data_provider`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `data_provider` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `description` text,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `at_latitude` float DEFAULT NULL,
  `at_longitude` float DEFAULT NULL,
  `website_url` varchar(255) DEFAULT NULL,
  `logo_url` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `telephone` varchar(255) DEFAULT NULL,
  `uuid` char(50) DEFAULT NULL,
  `concept_count` int(11) DEFAULT '0',
  `higher_concept_count` int(11) DEFAULT '0',
  `species_count` int(11) DEFAULT '0',
  `occurrence_count` int(11) DEFAULT '0',
  `occurrence_coordinate_count` int(11) DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `deleted` datetime DEFAULT NULL,
  `iso_country_code` char(2) DEFAULT NULL,
  `stated_count_served` int(11) DEFAULT NULL,
  `gbif_approver` varchar(255) DEFAULT NULL,
  `lock_description` tinyint(1) NOT NULL DEFAULT '0',
  `lock_iso_country_code` tinyint(1) NOT NULL DEFAULT '0',
  `data_resource_count` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `IX_data_provider_name` (`name`),
  KEY `IX_data_provider_country` (`iso_country_code`)
) ENGINE=MyISAM AUTO_INCREMENT=510 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `data_provider_agent`
--

DROP TABLE IF EXISTS `data_provider_agent`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `data_provider_agent` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data_provider_id` int(11) NOT NULL,
  `agent_id` int(11) NOT NULL,
  `agent_type` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `data_provider_id` (`data_provider_id`),
  KEY `agent_id` (`agent_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2446 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `data_resource`
--

DROP TABLE IF EXISTS `data_resource`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `data_resource` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data_provider_id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `display_name` varchar(255) DEFAULT NULL,
  `description` text,
  `rights` text,
  `citation` text,
  `logo_url` varchar(255) DEFAULT NULL,
  `shared_taxonomy` tinyint(1) DEFAULT '0',
  `concept_count` int(11) DEFAULT '0',
  `higher_concept_count` int(11) DEFAULT '0',
  `species_count` int(11) DEFAULT '0',
  `occurrence_count` int(11) DEFAULT '0',
  `occurrence_coordinate_count` int(11) DEFAULT '0',
  `basis_of_record` int(11) NOT NULL DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `deleted` datetime DEFAULT NULL,
  `citable_agent` varchar(255) DEFAULT NULL,
  `root_taxon_rank` int(11) DEFAULT NULL,
  `root_taxon_name` varchar(150) DEFAULT NULL,
  `scope_continent_code` char(2) DEFAULT NULL,
  `scope_country_code` char(2) DEFAULT NULL,
  `provider_record_count` int(11) DEFAULT NULL,
  `taxonomic_priority` int(11) NOT NULL DEFAULT '100',
  `website_url` varchar(255) DEFAULT NULL,
  `occurrence_clean_geospatial_count` int(11) DEFAULT NULL,
  `lock_display_name` tinyint(1) NOT NULL DEFAULT '0',
  `lock_citable_agent` tinyint(1) NOT NULL DEFAULT '0',
  `lock_basis_of_record` tinyint(1) NOT NULL DEFAULT '0',
  `override_citation` tinyint(1) NOT NULL DEFAULT '0',
  `gbif_registry_uuid` char(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `data_provider_id` (`data_provider_id`),
  KEY `IX_data_resource_name` (`name`),
  KEY `IX_data_resource_display_name` (`display_name`),
  KEY `IX_data_resource_shared_taxonomy` (`shared_taxonomy`)
) ENGINE=MyISAM AUTO_INCREMENT=14696 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `data_resource_agent`
--

DROP TABLE IF EXISTS `data_resource_agent`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `data_resource_agent` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data_resource_id` int(11) NOT NULL,
  `agent_id` int(11) NOT NULL,
  `agent_type` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `data_resource_id` (`data_resource_id`),
  KEY `agent_id` (`agent_id`)
) ENGINE=MyISAM AUTO_INCREMENT=13452 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `entity_type`
--

DROP TABLE IF EXISTS `entity_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `entity_type` (
  `id` smallint(5) unsigned NOT NULL,
  `entity_type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `gbif_log_message`
--

DROP TABLE IF EXISTS `gbif_log_message`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gbif_log_message` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `portal_instance_id` tinyint(3) unsigned DEFAULT NULL,
  `log_group_id` int(10) unsigned DEFAULT NULL,
  `event_id` mediumint(8) unsigned DEFAULT '0',
  `level` smallint(5) unsigned DEFAULT NULL,
  `data_provider_id` smallint(5) unsigned DEFAULT NULL,
  `data_resource_id` smallint(5) unsigned DEFAULT NULL,
  `occurrence_id` int(10) unsigned DEFAULT NULL,
  `taxon_concept_id` int(10) unsigned DEFAULT NULL,
  `user_id` smallint(5) unsigned DEFAULT NULL,
  `message` text,
  `restricted` tinyint(1) unsigned DEFAULT NULL,
  `count` int(10) unsigned DEFAULT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `log_group_id` (`log_group_id`),
  KEY `portal_instance_id` (`portal_instance_id`),
  KEY `level` (`level`),
  KEY `event_id` (`event_id`),
  KEY `timestamp` (`timestamp`),
  KEY `user_id` (`user_id`),
  KEY `portal_instance_id_2` (`portal_instance_id`,`log_group_id`),
  KEY `data_resource_id` (`data_resource_id`,`event_id`,`timestamp`),
  KEY `data_provider_id` (`data_provider_id`,`event_id`,`timestamp`),
  KEY `occurrence_id` (`occurrence_id`,`event_id`,`timestamp`)
) ENGINE=MyISAM AUTO_INCREMENT=591015197 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `gbif_user`
--

DROP TABLE IF EXISTS `gbif_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gbif_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `portal_instance_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `verified` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `IX_gbif_user_verified` (`verified`)
) ENGINE=MyISAM AUTO_INCREMENT=2281 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `geo_mapping`
--

DROP TABLE IF EXISTS `geo_mapping`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `geo_mapping` (
  `geo_region_id` int(11) NOT NULL,
  `occurrence_id` int(11) NOT NULL,
  PRIMARY KEY (`geo_region_id`,`occurrence_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `geo_region`
--

DROP TABLE IF EXISTS `geo_region`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `geo_region` (
  `id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `region_type` smallint(6) DEFAULT NULL,
  `iso_country_code` char(2) DEFAULT NULL,
  `concept_count` int(11) DEFAULT '0',
  `species_count` int(11) DEFAULT '0',
  `occurrence_count` int(11) DEFAULT NULL,
  `occurrence_coordinate_count` int(11) DEFAULT '0',
  `min_latitude` float DEFAULT NULL,
  `max_latitude` float DEFAULT NULL,
  `min_longitude` float DEFAULT NULL,
  `max_longitude` float DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_geo_region_iso_country_code` (`iso_country_code`),
  KEY `ix_geo_region_name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `geographical_coverage_tag`
--

DROP TABLE IF EXISTS `geographical_coverage_tag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `geographical_coverage_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tag_id` int(11) DEFAULT NULL,
  `entity_id` int(11) DEFAULT NULL,
  `min_longitude` float DEFAULT NULL,
  `min_latitude` float DEFAULT NULL,
  `max_longitude` float DEFAULT NULL,
  `max_latitude` float DEFAULT NULL,
  `is_system_generated` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tag_id` (`tag_id`)
) ENGINE=MyISAM AUTO_INCREMENT=319746 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `gmba`
--

DROP TABLE IF EXISTS `gmba`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gmba` (
  `cellnr` int(11) DEFAULT NULL,
  `latitude` float DEFAULT NULL,
  `longitude` float DEFAULT NULL,
  `elevation` smallint(6) DEFAULT NULL,
  `relief` smallint(6) DEFAULT NULL,
  `continent` tinyint(4) DEFAULT NULL,
  `seadist` mediumint(9) DEFAULT NULL,
  `mtdist` mediumint(9) DEFAULT NULL,
  `vegcode` tinyint(4) DEFAULT NULL,
  `tpcode` tinyint(4) DEFAULT NULL,
  `cell_id` int(10) unsigned DEFAULT NULL,
  `tvzcode` int(11) DEFAULT NULL,
  `cell_id2` int(11) DEFAULT NULL,
  KEY `relief` (`relief`),
  KEY `cell_id` (`cell_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `identifier_record`
--

DROP TABLE IF EXISTS `identifier_record`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `identifier_record` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `data_resource_id` smallint(5) unsigned NOT NULL,
  `occurrence_id` int(10) unsigned DEFAULT NULL,
  `identifier_type` smallint(5) unsigned NOT NULL DEFAULT '0',
  `identifier` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_identifier_record_occurrence` (`occurrence_id`),
  KEY `id_identifier_record_resource` (`data_resource_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=3034438092 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `image_record`
--

DROP TABLE IF EXISTS `image_record`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `image_record` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `data_resource_id` smallint(5) unsigned NOT NULL,
  `occurrence_id` int(10) unsigned DEFAULT NULL,
  `taxon_concept_id` int(10) unsigned DEFAULT NULL,
  `raw_image_type` varchar(128) DEFAULT NULL,
  `image_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `url` varchar(255) NOT NULL,
  `description` text,
  `rights` text,
  `html_for_display` text,
  PRIMARY KEY (`id`),
  KEY `ix_image_record_occurrence` (`occurrence_id`),
  KEY `ix_image_record_resource_taxon_concept` (`data_resource_id`,`taxon_concept_id`),
  KEY `ix_image_record_taxon_concept_id` (`taxon_concept_id`)
) ENGINE=MyISAM AUTO_INCREMENT=119777778 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `index_data`
--

DROP TABLE IF EXISTS `index_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `index_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `resource_access_point_id` int(11) NOT NULL,
  `type` int(11) DEFAULT NULL,
  `lower_value` varchar(255) DEFAULT NULL,
  `upper_value` varchar(255) DEFAULT NULL,
  `started` datetime DEFAULT NULL,
  `finished` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_indexing_data_1` (`resource_access_point_id`),
  KEY `IX_indexing_data_2` (`started`)
) ENGINE=MyISAM AUTO_INCREMENT=2420758 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `institution_code`
--

DROP TABLE IF EXISTS `institution_code`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `institution_code` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_ic_institution_code` (`code`)
) ENGINE=MyISAM AUTO_INCREMENT=10636 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `ip_country`
--

DROP TABLE IF EXISTS `ip_country`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ip_country` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `start` char(15) NOT NULL,
  `end` char(15) NOT NULL,
  `start_long` bigint(20) unsigned DEFAULT NULL,
  `end_long` bigint(20) unsigned DEFAULT NULL,
  `iso_country_code` char(12) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_ip_country_range` (`start_long`,`end_long`)
) ENGINE=MyISAM AUTO_INCREMENT=140426 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `link_record`
--

DROP TABLE IF EXISTS `link_record`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `link_record` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `data_resource_id` smallint(5) unsigned NOT NULL,
  `occurrence_id` int(10) unsigned DEFAULT NULL,
  `taxon_concept_id` int(10) unsigned DEFAULT NULL,
  `raw_link_type` varchar(128) DEFAULT NULL,
  `link_type` smallint(5) unsigned NOT NULL DEFAULT '0',
  `url` varchar(255) NOT NULL,
  `description` text,
  PRIMARY KEY (`id`),
  KEY `ix_link_record_occurrence` (`occurrence_id`),
  KEY `ix_link_record_taxon_concept` (`taxon_concept_id`),
  KEY `id_link_record_resource` (`data_resource_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=60493025 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `lookup_agent_type`
--

DROP TABLE IF EXISTS `lookup_agent_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lookup_agent_type` (
  `la_key` int(11) DEFAULT NULL,
  `la_value` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `lookup_basis_of_record`
--

DROP TABLE IF EXISTS `lookup_basis_of_record`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lookup_basis_of_record` (
  `br_key` int(11) DEFAULT NULL,
  `br_value` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `lookup_cell_density_type`
--

DROP TABLE IF EXISTS `lookup_cell_density_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lookup_cell_density_type` (
  `cd_key` int(11) DEFAULT NULL,
  `cd_value` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `lookup_identifier_type`
--

DROP TABLE IF EXISTS `lookup_identifier_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lookup_identifier_type` (
  `it_key` int(11) DEFAULT NULL,
  `it_value` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `lookup_image_type`
--

DROP TABLE IF EXISTS `lookup_image_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lookup_image_type` (
  `im_key` int(11) DEFAULT NULL,
  `im_value` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `lookup_link_type`
--

DROP TABLE IF EXISTS `lookup_link_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lookup_link_type` (
  `li_key` int(11) DEFAULT NULL,
  `li_value` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `lookup_log_event_type`
--

DROP TABLE IF EXISTS `lookup_log_event_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lookup_log_event_type` (
  `le_key` int(11) DEFAULT NULL,
  `le_value` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `lookup_quad_relation_entity`
--

DROP TABLE IF EXISTS `lookup_quad_relation_entity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lookup_quad_relation_entity` (
  `qe_attribute` varchar(25) DEFAULT NULL,
  `qe_resolution` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `lookup_relationship_assertion_type`
--

DROP TABLE IF EXISTS `lookup_relationship_assertion_type`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lookup_relationship_assertion_type` (
  `ra_key` int(11) DEFAULT NULL,
  `ra_value` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `lookup_remote_concept_remote_id`
--

DROP TABLE IF EXISTS `lookup_remote_concept_remote_id`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lookup_remote_concept_remote_id` (
  `rc_key` int(11) DEFAULT NULL,
  `rc_value` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `namespace_mapping`
--

DROP TABLE IF EXISTS `namespace_mapping`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `namespace_mapping` (
  `resource_access_point_id` int(11) NOT NULL,
  `property_store_namespace_id` int(11) NOT NULL,
  `priority` int(11) NOT NULL,
  PRIMARY KEY (`property_store_namespace_id`,`resource_access_point_id`),
  KEY `property_store_namespace_id` (`property_store_namespace_id`),
  KEY `resource_access_point_id` (`resource_access_point_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `network_membership`
--

DROP TABLE IF EXISTS `network_membership`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `network_membership` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data_resource_id` int(11) NOT NULL,
  `resource_network_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `data_resource_id` (`data_resource_id`),
  KEY `resource_network_id` (`resource_network_id`),
  KEY `IX_network_membership_id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=440592 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `number_tag`
--

DROP TABLE IF EXISTS `number_tag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `number_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tag_id` int(11) DEFAULT NULL,
  `entity_id` int(11) DEFAULT NULL,
  `value` float DEFAULT NULL,
  `is_system_generated` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tag_id` (`tag_id`)
) ENGINE=MyISAM AUTO_INCREMENT=852747 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `occurrence_record`
--

DROP TABLE IF EXISTS `occurrence_record`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `occurrence_record` (
  `id` int(10) unsigned NOT NULL,
  `data_provider_id` smallint(5) unsigned NOT NULL,
  `data_resource_id` smallint(5) unsigned NOT NULL,
  `institution_code_id` mediumint(8) unsigned DEFAULT NULL,
  `collection_code_id` mediumint(8) unsigned NOT NULL,
  `catalogue_number_id` int(10) unsigned NOT NULL,
  `taxon_concept_id` int(10) unsigned NOT NULL,
  `taxon_name_id` mediumint(8) unsigned NOT NULL,
  `kingdom_concept_id` int(10) unsigned DEFAULT NULL,
  `phylum_concept_id` int(10) unsigned DEFAULT NULL,
  `class_concept_id` int(10) unsigned DEFAULT NULL,
  `order_concept_id` int(10) unsigned DEFAULT NULL,
  `family_concept_id` int(10) unsigned DEFAULT NULL,
  `genus_concept_id` int(10) unsigned DEFAULT NULL,
  `species_concept_id` int(10) unsigned DEFAULT NULL,
  `nub_concept_id` int(10) unsigned DEFAULT NULL,
  `iso_country_code` char(2) DEFAULT NULL,
  `latitude` float DEFAULT NULL,
  `longitude` float DEFAULT NULL,
  `cell_id` smallint(5) unsigned DEFAULT NULL,
  `centi_cell_id` tinyint(3) unsigned DEFAULT NULL,
  `mod360_cell_id` smallint(5) unsigned DEFAULT NULL,
  `year` smallint(5) unsigned DEFAULT NULL,
  `month` tinyint(3) unsigned DEFAULT NULL,
  `occurrence_date` date DEFAULT NULL,
  `basis_of_record` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `taxonomic_issue` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `geospatial_issue` mediumint(8) unsigned DEFAULT NULL,
  `other_issue` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `deleted` timestamp NULL DEFAULT NULL,
  `altitude_metres` smallint(6) DEFAULT NULL,
  `depth_centimetres` mediumint(8) unsigned DEFAULT NULL,
  `modified` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_or_data_provider_id` (`data_provider_id`),
  KEY `ix_or_data_resource_id` (`data_resource_id`),
  KEY `ix_or_institution_code` (`institution_code_id`),
  KEY `ix_or_collection_code` (`collection_code_id`),
  KEY `ix_or_catalogue_number` (`catalogue_number_id`),
  KEY `ix_or_taxon_concept_id` (`taxon_concept_id`),
  KEY `ix_or_taxon_name_id` (`taxon_name_id`),
  KEY `ix_or_iso_country_code` (`iso_country_code`),
  KEY `ix_or_occurrence_date` (`occurrence_date`),
  KEY `ix_or_month` (`month`),
  KEY `ix_or_year` (`year`),
  KEY `ix_or_k_cell_mod_cell` (`kingdom_concept_id`,`cell_id`,`mod360_cell_id`),
  KEY `ix_or_p_cell_mod_cell` (`phylum_concept_id`,`cell_id`,`mod360_cell_id`),
  KEY `ix_or_c_cell_mod_cell` (`class_concept_id`,`cell_id`,`mod360_cell_id`),
  KEY `ix_or_o_cell_mod_cell` (`order_concept_id`,`cell_id`,`mod360_cell_id`),
  KEY `ix_or_f_cell_mod_cell` (`family_concept_id`,`cell_id`,`mod360_cell_id`),
  KEY `ix_or_g_cell_mod_cell` (`genus_concept_id`,`cell_id`,`mod360_cell_id`),
  KEY `ix_or_s_cell_mod_cell` (`species_concept_id`,`cell_id`,`mod360_cell_id`),
  KEY `ix_or_cell_mod_cell_nub` (`cell_id`,`mod360_cell_id`,`nub_concept_id`),
  KEY `ix_or_nub_country` (`nub_concept_id`,`iso_country_code`),
  KEY `ix_or_altitude_metres` (`altitude_metres`),
  KEY `ix_or_depth_centimetres` (`depth_centimetres`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `property_store_namespace`
--

DROP TABLE IF EXISTS `property_store_namespace`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `property_store_namespace` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `namespace` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `quad_relation_tag`
--

DROP TABLE IF EXISTS `quad_relation_tag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `quad_relation_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tag_id` int(11) DEFAULT NULL,
  `entity1_id` int(10) unsigned DEFAULT NULL,
  `entity2_id` int(10) unsigned DEFAULT NULL,
  `entity3_id` int(10) unsigned DEFAULT NULL,
  `entity4_id` int(10) unsigned DEFAULT NULL,
  `count` int(10) unsigned DEFAULT NULL,
  `rollover_id` mediumint(8) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `entity1_id` (`entity1_id`,`entity2_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1067893 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `rank`
--

DROP TABLE IF EXISTS `rank`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rank` (
  `id` int(11) NOT NULL,
  `name` char(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_rank_1` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `raw_occurrence_record`
--

DROP TABLE IF EXISTS `raw_occurrence_record`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `raw_occurrence_record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data_provider_id` smallint(6) DEFAULT NULL,
  `data_resource_id` smallint(6) DEFAULT NULL,
  `resource_access_point_id` smallint(6) DEFAULT NULL,
  `institution_code` varchar(255) DEFAULT NULL,
  `collection_code` varchar(255) DEFAULT NULL,
  `catalogue_number` varchar(255) DEFAULT NULL,
  `scientific_name` varchar(255) DEFAULT NULL,
  `author` varchar(255) DEFAULT NULL,
  `rank` varchar(50) DEFAULT NULL,
  `kingdom` varchar(150) DEFAULT NULL,
  `phylum` varchar(150) DEFAULT NULL,
  `class` varchar(250) DEFAULT NULL,
  `order_rank` varchar(50) DEFAULT NULL,
  `family` varchar(250) DEFAULT NULL,
  `genus` varchar(150) DEFAULT NULL,
  `species` varchar(150) DEFAULT NULL,
  `subspecies` varchar(150) DEFAULT NULL,
  `latitude` varchar(50) DEFAULT NULL,
  `longitude` varchar(50) DEFAULT NULL,
  `lat_long_precision` varchar(50) DEFAULT NULL,
  `max_altitude` varchar(50) DEFAULT NULL,
  `min_altitude` varchar(50) DEFAULT NULL,
  `altitude_precision` varchar(50) DEFAULT NULL,
  `min_depth` varchar(50) DEFAULT NULL,
  `max_depth` varchar(50) DEFAULT NULL,
  `depth_precision` varchar(50) DEFAULT NULL,
  `continent_ocean` varchar(100) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `state_province` varchar(100) DEFAULT NULL,
  `county` varchar(100) DEFAULT NULL,
  `collector_name` varchar(255) DEFAULT NULL,
  `locality` text,
  `year` varchar(50) DEFAULT NULL,
  `month` varchar(50) DEFAULT NULL,
  `day` varchar(50) DEFAULT NULL,
  `basis_of_record` varchar(100) DEFAULT NULL,
  `identifier_name` varchar(255) DEFAULT NULL,
  `identification_date` datetime DEFAULT NULL,
  `unit_qualifier` varchar(255) DEFAULT NULL,
  `created` timestamp NULL DEFAULT NULL,
  `modified` timestamp NULL DEFAULT NULL,
  `deleted` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `primarykey` (`id`),
  KEY `created` (`created`,`modified`),
  KEY `resource_access_point_id` (`resource_access_point_id`,`id`),
  KEY `data_resource_id` (`data_resource_id`,`catalogue_number`(50),`collection_code`(10),`institution_code`(10))
) ENGINE=MyISAM AUTO_INCREMENT=767068790 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `registration_login`
--

DROP TABLE IF EXISTS `registration_login`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `registration_login` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `login_id` varchar(255) DEFAULT NULL,
  `business_key` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_registration_login_login_id` (`login_id`),
  KEY `IX_registration_login_business_key` (`business_key`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `relationship_assertion`
--

DROP TABLE IF EXISTS `relationship_assertion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `relationship_assertion` (
  `from_concept_id` int(11) NOT NULL,
  `to_concept_id` int(11) NOT NULL,
  `relationship_type` int(11) NOT NULL,
  PRIMARY KEY (`from_concept_id`,`to_concept_id`,`relationship_type`),
  KEY `from_concept_id` (`from_concept_id`),
  KEY `IX_relationship_assertion_1` (`relationship_type`),
  KEY `IX_TO_CONCEPT_ID` (`to_concept_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `remote_concept`
--

DROP TABLE IF EXISTS `remote_concept`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `remote_concept` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `taxon_concept_id` int(11) NOT NULL,
  `remote_id` varchar(255) DEFAULT NULL,
  `id_type` smallint(5) unsigned NOT NULL,
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `ix_remote_concept_remote_id` (`remote_id`),
  KEY `ix_remote_concept_tc_id` (`taxon_concept_id`)
) ENGINE=MyISAM AUTO_INCREMENT=191799134 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `resource_access_point`
--

DROP TABLE IF EXISTS `resource_access_point`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `resource_access_point` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `data_provider_id` int(11) DEFAULT NULL,
  `data_resource_id` int(11) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `remote_id_at_url` varchar(255) DEFAULT NULL,
  `uuid` char(50) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `deleted` datetime DEFAULT NULL,
  `last_harvest_start` datetime DEFAULT NULL,
  `last_extract_start` datetime DEFAULT NULL,
  `supports_date_last_modified` tinyint(1) NOT NULL DEFAULT '0',
  `interval_metadata_days` int(11) DEFAULT NULL,
  `interval_harvest_days` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `data_provider_id` (`data_provider_id`),
  KEY `ix_rap_dr` (`data_resource_id`)
) ENGINE=MyISAM AUTO_INCREMENT=15267 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `resource_country`
--

DROP TABLE IF EXISTS `resource_country`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `resource_country` (
  `data_resource_id` int(11) NOT NULL,
  `iso_country_code` char(2) NOT NULL,
  `count` int(11) DEFAULT NULL,
  `occurrence_coordinate_count` int(11) DEFAULT '0',
  PRIMARY KEY (`data_resource_id`,`iso_country_code`),
  KEY `IX_data_resource_ids` (`data_resource_id`),
  KEY `IX_iso_country_codes` (`iso_country_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `resource_network`
--

DROP TABLE IF EXISTS `resource_network`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `resource_network` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `code` varchar(50) DEFAULT NULL,
  `description` text,
  `address` varchar(255) DEFAULT NULL,
  `website_url` varchar(255) DEFAULT NULL,
  `logo_url` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `telephone` varchar(255) DEFAULT NULL,
  `concept_count` int(11) DEFAULT '0',
  `species_count` int(11) DEFAULT '0',
  `occurrence_count` int(11) DEFAULT '0',
  `occurrence_coordinate_count` int(11) DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `deleted` datetime DEFAULT NULL,
  `data_resource_count` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `IX_resource_network_name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=72 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `resource_rank`
--

DROP TABLE IF EXISTS `resource_rank`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `resource_rank` (
  `id` int(11) NOT NULL,
  `resource_type` int(11) DEFAULT NULL,
  `entity_id` int(11) DEFAULT NULL,
  `entity_type` int(11) DEFAULT NULL,
  `rank` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IX_resource_rank_type` (`resource_type`),
  KEY `IX_resource_rank_entity_id` (`entity_id`),
  KEY `IX_resource_rank_entity_type` (`entity_type`),
  KEY `IX_resource_rank_rank` (`rank`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `rollover`
--

DROP TABLE IF EXISTS `rollover`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rollover` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rollover_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `stats_country_contribution`
--

DROP TABLE IF EXISTS `stats_country_contribution`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stats_country_contribution` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rollover_id` int(11) NOT NULL,
  `iso_country_code` char(2) DEFAULT NULL,
  `provider_count` int(11) DEFAULT '0',
  `dataset_count` int(11) DEFAULT '0',
  `occurrence_count` int(11) DEFAULT '0',
  `occurrence_georeferenced_count` int(11) DEFAULT '0',
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1461 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `stats_participant_contribution`
--

DROP TABLE IF EXISTS `stats_participant_contribution`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stats_participant_contribution` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `rollover_id` int(11) NOT NULL,
  `gbif_approver` varchar(255) DEFAULT NULL,
  `provider_count` int(11) DEFAULT '0',
  `dataset_count` int(11) DEFAULT '0',
  `occurrence_count` int(11) DEFAULT '0',
  `occurrence_georeferenced_count` int(11) DEFAULT '0',
  `created` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1883 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `stats_participant_data_usage`
--

DROP TABLE IF EXISTS `stats_participant_data_usage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stats_participant_data_usage` (
  `gbif_approver` varchar(150) DEFAULT NULL,
  `month` varchar(50) DEFAULT NULL,
  `year` varchar(50) DEFAULT NULL,
  `search_event_count` int(10) unsigned DEFAULT '0',
  `search_record_count` int(10) unsigned DEFAULT '0',
  `occurrence_detail_page_view` int(10) unsigned DEFAULT '0',
  `download_event_count` int(10) unsigned DEFAULT '0',
  `download_record_count` int(10) unsigned DEFAULT '0'
) ENGINE=MyISAM AUTO_INCREMENT=286295989 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `string_tag`
--

DROP TABLE IF EXISTS `string_tag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `string_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tag_id` int(11) DEFAULT NULL,
  `entity_id` int(11) DEFAULT NULL,
  `value` text,
  `is_system_generated` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tag_id` (`tag_id`)
) ENGINE=MyISAM AUTO_INCREMENT=5663064 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `tag`
--

DROP TABLE IF EXISTS `tag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tag` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` char(200) DEFAULT NULL,
  `entity_type` smallint(5) unsigned DEFAULT NULL,
  `tag_table` char(30) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6001 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `taxon_concept`
--

DROP TABLE IF EXISTS `taxon_concept`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `taxon_concept` (
  `id` int(10) unsigned NOT NULL DEFAULT '0',
  `rank` smallint(5) unsigned NOT NULL,
  `taxon_name_id` mediumint(8) unsigned NOT NULL,
  `data_provider_id` smallint(5) unsigned NOT NULL,
  `data_resource_id` smallint(5) unsigned NOT NULL,
  `parent_concept_id` int(10) unsigned DEFAULT NULL,
  `kingdom_concept_id` int(10) unsigned DEFAULT NULL,
  `phylum_concept_id` int(10) unsigned DEFAULT NULL,
  `class_concept_id` int(10) unsigned DEFAULT NULL,
  `order_concept_id` int(10) unsigned DEFAULT NULL,
  `family_concept_id` int(10) unsigned DEFAULT NULL,
  `genus_concept_id` int(10) unsigned DEFAULT NULL,
  `species_concept_id` int(10) unsigned DEFAULT NULL,
  `is_accepted` tinyint(1) DEFAULT '1',
  `is_nub_concept` tinyint(1) DEFAULT '0',
  `partner_concept_id` int(10) unsigned DEFAULT NULL,
  `priority` smallint(6) NOT NULL DEFAULT '100',
  `is_secondary` tinyint(1) DEFAULT '0',
  `created` timestamp NULL DEFAULT NULL,
  `modified` timestamp NULL DEFAULT NULL,
  `deleted` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_taxon_concept_dr_rank` (`data_resource_id`,`rank`),
  KEY `ix_taxon_concept_partner_dr` (`partner_concept_id`,`data_resource_id`),
  KEY `ix_taxon_concept_tn_dr` (`taxon_name_id`,`data_resource_id`),
  KEY `ix_taxon_concept_parent` (`parent_concept_id`),
  KEY `ix_taxon_concept_k` (`kingdom_concept_id`),
  KEY `ix_taxon_concept_p` (`phylum_concept_id`),
  KEY `ix_taxon_concept_c` (`class_concept_id`),
  KEY `ix_taxon_concept_o` (`order_concept_id`),
  KEY `ix_taxon_concept_f` (`family_concept_id`),
  KEY `ix_taxon_concept_g` (`genus_concept_id`),
  KEY `ix_taxon_concept_s` (`species_concept_id`),
  KEY `ix_taxon_concept_dp` (`data_provider_id`),
  KEY `ix_taxon_concept_dp_rank` (`data_provider_id`,`rank`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `taxon_country`
--

DROP TABLE IF EXISTS `taxon_country`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `taxon_country` (
  `taxon_concept_id` int(11) NOT NULL,
  `iso_country_code` char(2) NOT NULL,
  `count` int(11) DEFAULT NULL,
  PRIMARY KEY (`taxon_concept_id`,`iso_country_code`),
  KEY `IX_taxon_concept_ids` (`taxon_concept_id`),
  KEY `IX_iso_country_codes` (`iso_country_code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `taxon_name`
--

DROP TABLE IF EXISTS `taxon_name`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `taxon_name` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `canonical` text,
  `supra_generic` varchar(255) DEFAULT NULL,
  `generic` varchar(255) DEFAULT NULL,
  `infrageneric` varchar(255) DEFAULT NULL,
  `specific_epithet` varchar(255) DEFAULT NULL,
  `infraspecific` varchar(255) DEFAULT NULL,
  `infraspecific_marker` varchar(255) DEFAULT NULL,
  `is_hybrid` tinyint(1) DEFAULT NULL,
  `rank` smallint(5) unsigned NOT NULL,
  `author` varchar(255) DEFAULT NULL,
  `searchable_canonical` text,
  PRIMARY KEY (`id`),
  KEY `IX_taxon_name_specific_epithet` (`specific_epithet`),
  KEY `ix_taxon_name_canonical_rank` (`canonical`(50),`rank`),
  KEY `ix_taxon_name_searchable_canonical_rank` (`searchable_canonical`(50),`rank`)
) ENGINE=MyISAM AUTO_INCREMENT=13344684 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `temporal_coverage_tag`
--

DROP TABLE IF EXISTS `temporal_coverage_tag`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `temporal_coverage_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tag_id` int(11) DEFAULT NULL,
  `entity_id` int(11) DEFAULT NULL,
  `start_date` date NOT NULL,
  `end_date` date DEFAULT NULL,
  `is_system_generated` bit(1) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=319745 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `tmp_IMSregions`
--

DROP TABLE IF EXISTS `tmp_IMSregions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tmp_IMSregions` (
  `gbif_membership` varchar(100) DEFAULT NULL,
  `name_lct` varchar(255) DEFAULT NULL,
  `name_short` varchar(100) DEFAULT NULL,
  `iso2` varchar(2) DEFAULT NULL,
  `gbif_area` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
-- Table structure for table `typification_record`
--

DROP TABLE IF EXISTS `typification_record`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `typification_record` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `data_resource_id` smallint(5) unsigned NOT NULL,
  `occurrence_id` int(10) unsigned DEFAULT NULL,
  `taxon_name_id` mediumint(8) unsigned DEFAULT NULL,
  `scientific_name` varchar(255) DEFAULT NULL,
  `publication` text,
  `type_status` varchar(255) NOT NULL,
  `notes` text,
  PRIMARY KEY (`id`),
  KEY `ix_typification_record_occurrence` (`occurrence_id`),
  KEY `ix_typification_record_name` (`taxon_name_id`),
  KEY `ix_typification_record_resource` (`data_resource_id`)
) ENGINE=MyISAM AUTO_INCREMENT=22770377 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;