SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;

SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;

SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';

CREATE SCHEMA IF NOT EXISTS `default_schema` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci ;

USE `default_schema` ;

-- -----------------------------------------------------

-- Table `default_schema`.`source`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`source` (

  `source` TEXT NOT NULL ,

  `source_parent` TEXT NULL DEFAULT NULL ,

  PRIMARY KEY (`source`) ,

  INDEX `fk_source1` (`source_parent` ASC) ,

  CONSTRAINT `fk_source1`

    FOREIGN KEY (`source_parent` )

    REFERENCES `default_schema`.`source` (`source` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`record`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`record` (

  `record` TEXT NOT NULL ,

  `source` TEXT NOT NULL ,

  PRIMARY KEY (`record`) ,

  INDEX `fk_record_source1` (`source` ASC) ,

  CONSTRAINT `fk_record_source1`

    FOREIGN KEY (`source` )

    REFERENCES `default_schema`.`source` (`source` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`relationship`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`relationship` (

  `relationship` TEXT NOT NULL ,

  `record` TEXT NOT NULL ,

  `related_record` TEXT NOT NULL ,

  PRIMARY KEY (`relationship`) ,

  INDEX `fk_relationship_record1` (`record` ASC) ,

  INDEX `fk_relationship_related_record` (`related_record` ASC) ,

  CONSTRAINT `fk_relationship_record1`

    FOREIGN KEY (`relationship` )

    REFERENCES `default_schema`.`record` (`record` )

    ON DELETE CASCADE

    ON UPDATE CASCADE,

  CONSTRAINT `fk_relationship_record1`

    FOREIGN KEY (`record` )

    REFERENCES `default_schema`.`record` (`record` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_relationship_related_record`

    FOREIGN KEY (`related_record` )

    REFERENCES `default_schema`.`record` (`record` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`coordinates`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`coordinates` (

  `coordinates` TEXT NOT NULL ,

  PRIMARY KEY (`coordinates`) ,

  CONSTRAINT `fk_coordinates_record1`

    FOREIGN KEY (`coordinates` )

    REFERENCES `default_schema`.`record` (`record` )

    ON DELETE CASCADE

    ON UPDATE CASCADE)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`named_place`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`named_place` (

  `named_place` TEXT NOT NULL ,

  PRIMARY KEY (`named_place`) ,

  CONSTRAINT `fk_named_place_record1`

    FOREIGN KEY (`named_place` )

    REFERENCES `default_schema`.`record` (`record` )

    ON DELETE CASCADE

    ON UPDATE CASCADE)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`location`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`location` (

  `location` TEXT NOT NULL ,

  `location_parent` TEXT NULL DEFAULT NULL ,

  `placename` TEXT NULL DEFAULT NULL ,

  `coordinates` TEXT NULL DEFAULT NULL ,

  PRIMARY KEY (`location`) ,

  INDEX `fk_location_coordinates1` (`coordinates` ASC) ,

  INDEX `fk_location_placename1` (`placename` ASC) ,

  INDEX `fk_location1` (`location_parent` ASC) ,

  CONSTRAINT `fk_location_record1`

    FOREIGN KEY (`location` )

    REFERENCES `default_schema`.`record` (`record` )

    ON DELETE CASCADE

    ON UPDATE CASCADE,

  CONSTRAINT `fk_location_coordinates1`

    FOREIGN KEY (`coordinates` )

    REFERENCES `default_schema`.`coordinates` (`coordinates` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_location_placename1`

    FOREIGN KEY (`placename` )

    REFERENCES `default_schema`.`named_place` (`named_place` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_location1`

    FOREIGN KEY (`location_parent` )

    REFERENCES `default_schema`.`location` (`location` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`method`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`method` (

  `method` TEXT NOT NULL ,

  PRIMARY KEY (`method`) ,

  CONSTRAINT `fk_method_record1`

    FOREIGN KEY (`method` )

    REFERENCES `default_schema`.`record` (`record` )

    ON DELETE CASCADE

    ON UPDATE CASCADE)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`event`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`event` (

  `event` TEXT NOT NULL ,

  `event_parent` TEXT NULL DEFAULT NULL ,

  `location` TEXT NULL DEFAULT NULL ,

  `method` TEXT NULL DEFAULT NULL ,

  PRIMARY KEY (`event`) ,

  INDEX `fk_event_location1` (`location` ASC) ,

  INDEX `fk_event1` (`event_parent` ASC) ,

  INDEX `fk_event_method1` (`method` ASC) ,

  CONSTRAINT `fk_event_record1`

    FOREIGN KEY (`event` )

    REFERENCES `default_schema`.`record` (`record` )

    ON DELETE CASCADE

    ON UPDATE CASCADE,

  CONSTRAINT `fk_event_location1`

    FOREIGN KEY (`location` )

    REFERENCES `default_schema`.`location` (`location` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_event1`

    FOREIGN KEY (`event_parent` )

    REFERENCES `default_schema`.`event` (`event` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_event_method1`

    FOREIGN KEY (`method` )

    REFERENCES `default_schema`.`method` (`method` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`occurrence`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`occurrence` (

  `occurrence` TEXT NOT NULL ,

  PRIMARY KEY (`occurrence`) ,

  INDEX `fk_occurrence_record1` (`occurrence` ASC) ,

  CONSTRAINT `fk_occurrence_event1`

    FOREIGN KEY (`occurrence` )

    REFERENCES `default_schema`.`event` (`event` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`measurement`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`measurement` (

  `measurement` TEXT NOT NULL ,

  `occurrence` TEXT NOT NULL ,

  PRIMARY KEY (`measurement`) ,

  INDEX `fk_measurement_occurrence1` (`occurrence` ASC) ,

  CONSTRAINT `fk_measurement_record1`

    FOREIGN KEY (`measurement` )

    REFERENCES `default_schema`.`record` (`record` )

    ON DELETE CASCADE

    ON UPDATE CASCADE,

  CONSTRAINT `fk_measurement_occurrence1`

    FOREIGN KEY (`occurrence` )

    REFERENCES `default_schema`.`occurrence` (`occurrence` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`taxon`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`taxon` (

  `taxon` TEXT NOT NULL ,

  PRIMARY KEY (`taxon`) ,

  CONSTRAINT `fk_taxon_record1`

    FOREIGN KEY (`taxon` )

    REFERENCES `default_schema`.`record` (`record` )

    ON DELETE CASCADE

    ON UPDATE CASCADE)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`qualified_taxon`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`qualified_taxon` (

  `qualified_taxon` TEXT NOT NULL ,

  `taxon` TEXT NOT NULL ,

  PRIMARY KEY (`qualified_taxon`) ,

  INDEX `fk_qualified_taxon_name_taxon1` (`taxon` ASC) ,

  CONSTRAINT `fk_qualified_taxon_record1`

    FOREIGN KEY (`qualified_taxon` )

    REFERENCES `default_schema`.`record` (`record` )

    ON DELETE CASCADE

    ON UPDATE CASCADE,

  CONSTRAINT `fk_qualified_taxon_name_taxon1`

    FOREIGN KEY (`taxon` )

    REFERENCES `default_schema`.`taxon` (`taxon` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`taxon_determination`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`taxon_determination` (

  `taxon_determination` VARCHAR(45) NOT NULL ,

  `taxon_occurrence` TEXT NOT NULL ,

  `qualified_taxon` TEXT NOT NULL ,

  INDEX `fk_taxon_occurrence_has_qualified_taxon1` (`qualified_taxon` ASC) ,

  INDEX `fk_taxon_occurrence_has_qualified_taxon_occurrence1` (`taxon_occurrence` ASC) ,

  PRIMARY KEY (`taxon_determination`) ,

  CONSTRAINT `fk_taxon_occurrence_has_qualified_taxon_occurrence1`

    FOREIGN KEY (`taxon_occurrence` )

    REFERENCES `default_schema`.`taxon_occurrence` (`taxon_occurrence` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_taxon_occurrence_has_qualified_taxon1`

    FOREIGN KEY (`qualified_taxon` )

    REFERENCES `default_schema`.`qualified_taxon` (`qualified_taxon` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_taxon_determination_record1`

    FOREIGN KEY (`taxon_determination` )

    REFERENCES `default_schema`.`record` (`record` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`taxon_occurrence`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`taxon_occurrence` (

  `taxon_occurrence` TEXT NOT NULL ,

  `current_taxon_determination` VARCHAR(45) NULL DEFAULT NULL ,

  `original_taxon_determination` VARCHAR(45) NULL DEFAULT NULL ,

  PRIMARY KEY (`taxon_occurrence`) ,

  INDEX `fk_taxon_occurrence_taxon_determination1` (`original_taxon_determination` ASC) ,

  INDEX `fk_taxon_occurrence_taxon_determination2` (`current_taxon_determination` ASC) ,

  CONSTRAINT `fk_taxon_occurrence1`

    FOREIGN KEY (`taxon_occurrence` )

    REFERENCES `default_schema`.`occurrence` (`occurrence` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_taxon_occurrence_taxon_determination1`

    FOREIGN KEY (`original_taxon_determination` )

    REFERENCES `default_schema`.`taxon_determination` (`taxon_determination` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_taxon_occurrence_taxon_determination2`

    FOREIGN KEY (`current_taxon_determination` )

    REFERENCES `default_schema`.`taxon_determination` (`taxon_determination` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`collection`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`collection` (

  `collection` TEXT NOT NULL ,

  PRIMARY KEY (`collection`) ,

  CONSTRAINT `fk_collection_source1`

    FOREIGN KEY (`collection` )

    REFERENCES `default_schema`.`source` (`source` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`specimen`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`specimen` (

  `specimen` TEXT NOT NULL ,

  `collection` TEXT NOT NULL ,

  PRIMARY KEY (`specimen`) ,

  INDEX `fk_specimen_collection1` (`collection` ASC) ,

  CONSTRAINT `fk_specimen_taxon_occurrence1`

    FOREIGN KEY (`specimen` )

    REFERENCES `default_schema`.`taxon_occurrence` (`taxon_occurrence` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_specimen_collection1`

    FOREIGN KEY (`collection` )

    REFERENCES `default_schema`.`collection` (`collection` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`voucher`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`voucher` (

  `voucher` TEXT NOT NULL ,

  `taxon_occurrence` TEXT NOT NULL ,

  `specimen` TEXT NOT NULL ,

  PRIMARY KEY (`voucher`) ,

  INDEX `fk_voucher_taxon_occurrence1` (`taxon_occurrence` ASC) ,

  INDEX `fk_voucher_specimen1` (`specimen` ASC) ,

  CONSTRAINT `fk_voucher_record1`

    FOREIGN KEY (`voucher` )

    REFERENCES `default_schema`.`record` (`record` )

    ON DELETE CASCADE

    ON UPDATE CASCADE,

  CONSTRAINT `fk_voucher_taxon_occurrence1`

    FOREIGN KEY (`taxon_occurrence` )

    REFERENCES `default_schema`.`taxon_occurrence` (`taxon_occurrence` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_voucher_specimen1`

    FOREIGN KEY (`specimen` )

    REFERENCES `default_schema`.`specimen` (`specimen` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`individual`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`individual` (

  `individual` TEXT NOT NULL ,

  PRIMARY KEY (`individual`) ,

  CONSTRAINT `fk_individual_record1`

    FOREIGN KEY (`individual` )

    REFERENCES `default_schema`.`record` (`record` )

    ON DELETE CASCADE

    ON UPDATE CASCADE)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`individual_observation`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`individual_observation` (

  `individual_observation` TEXT NOT NULL ,

  `individual` TEXT NOT NULL ,

  PRIMARY KEY (`individual_observation`) ,

  INDEX `fk_individual_observation_individual1` (`individual` ASC) ,

  CONSTRAINT `fk_individual_observation_taxon_occurrence1`

    FOREIGN KEY (`individual_observation` )

    REFERENCES `default_schema`.`taxon_occurrence` (`taxon_occurrence` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_individual_observation_individual1`

    FOREIGN KEY (`individual` )

    REFERENCES `default_schema`.`individual` (`individual` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`stem`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`stem` (

  `stem` TEXT NOT NULL ,

  `individual` TEXT NOT NULL ,

  PRIMARY KEY (`stem`) ,

  INDEX `fk_stem_individual1` (`individual` ASC) ,

  CONSTRAINT `fk_stem_record1`

    FOREIGN KEY (`stem` )

    REFERENCES `default_schema`.`record` (`record` )

    ON DELETE CASCADE

    ON UPDATE CASCADE,

  CONSTRAINT `fk_stem_individual1`

    FOREIGN KEY (`individual` )

    REFERENCES `default_schema`.`individual` (`individual` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`stem_observation`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`stem_observation` (

  `stem_observation` TEXT NOT NULL ,

  `individual_observation` TEXT NOT NULL ,

  `stem` TEXT NOT NULL ,

  PRIMARY KEY (`stem_observation`) ,

  INDEX `fk_stem_observation_individual_observation1` (`individual_observation` ASC) ,

  INDEX `fk_stem_observation_stem1` (`stem` ASC) ,

  CONSTRAINT `fk_stem_observation_record1`

    FOREIGN KEY (`stem_observation` )

    REFERENCES `default_schema`.`record` (`record` )

    ON DELETE CASCADE

    ON UPDATE CASCADE,

  CONSTRAINT `fk_stem_observation_individual_observation1`

    FOREIGN KEY (`individual_observation` )

    REFERENCES `default_schema`.`individual_observation` (`individual_observation` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_stem_observation_stem1`

    FOREIGN KEY (`stem` )

    REFERENCES `default_schema`.`stem` (`stem` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`aggregate_observation`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`aggregate_observation` (

  `aggregate_observation` TEXT NOT NULL ,

  PRIMARY KEY (`aggregate_observation`) ,

  CONSTRAINT `fk_aggregate_observation_taxon_occurrence1`

    FOREIGN KEY (`aggregate_observation` )

    REFERENCES `default_schema`.`taxon_occurrence` (`taxon_occurrence` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`taxon_observation`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`taxon_observation` (

  `taxon_observation` TEXT NOT NULL ,

  PRIMARY KEY (`taxon_observation`) ,

  CONSTRAINT `fk_taxon_observation_taxon_occurrence1`

    FOREIGN KEY (`taxon_observation` )

    REFERENCES `default_schema`.`taxon_occurrence` (`taxon_occurrence` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`verbatim_taxon`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`verbatim_taxon` (

  `verbatim_taxon` TEXT NOT NULL ,

  PRIMARY KEY (`verbatim_taxon`) ,

  CONSTRAINT `fk_matched_taxon_qualified_taxon100`

    FOREIGN KEY (`verbatim_taxon` )

    REFERENCES `default_schema`.`qualified_taxon` (`qualified_taxon` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`parsed_taxon`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`parsed_taxon` (

  `parsed_taxon` TEXT NOT NULL ,

  `verbatim_taxon` TEXT NOT NULL ,

  PRIMARY KEY (`parsed_taxon`) ,

  INDEX `fk_parsed_taxon_verbatim_taxon1` (`verbatim_taxon` ASC) ,

  CONSTRAINT `fk_matched_taxon_qualified_taxon10`

    FOREIGN KEY (`parsed_taxon` )

    REFERENCES `default_schema`.`qualified_taxon` (`qualified_taxon` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_parsed_taxon_verbatim_taxon1`

    FOREIGN KEY (`verbatim_taxon` )

    REFERENCES `default_schema`.`verbatim_taxon` (`verbatim_taxon` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`matched_taxon`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`matched_taxon` (

  `matched_taxon` TEXT NOT NULL ,

  `parsed_taxon` TEXT NOT NULL ,

  PRIMARY KEY (`matched_taxon`) ,

  INDEX `fk_matched_taxon_parsed_taxon1` (`parsed_taxon` ASC) ,

  CONSTRAINT `fk_matched_taxon_qualified_taxon1`

    FOREIGN KEY (`matched_taxon` )

    REFERENCES `default_schema`.`qualified_taxon` (`qualified_taxon` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_matched_taxon_parsed_taxon1`

    FOREIGN KEY (`parsed_taxon` )

    REFERENCES `default_schema`.`parsed_taxon` (`parsed_taxon` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`accepted_taxon`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`accepted_taxon` (

  `accepted_taxon` TEXT NOT NULL ,

  `matched_taxon` TEXT NOT NULL ,

  PRIMARY KEY (`accepted_taxon`) ,

  INDEX `fk_accepted_taxon_matched_taxon1` (`matched_taxon` ASC) ,

  CONSTRAINT `fk_accepted_taxon_qualified_taxon1`

    FOREIGN KEY (`accepted_taxon` )

    REFERENCES `default_schema`.`qualified_taxon` (`qualified_taxon` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_accepted_taxon_matched_taxon1`

    FOREIGN KEY (`matched_taxon` )

    REFERENCES `default_schema`.`matched_taxon` (`matched_taxon` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`taxon_concept`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`taxon_concept` (

  `taxon_concept` TEXT NOT NULL ,

  `source` TEXT NOT NULL ,

  PRIMARY KEY (`taxon_concept`) ,

  INDEX `fk_taxon_concept_source1` (`source` ASC) ,

  CONSTRAINT `fk_taxon_concept_taxon1`

    FOREIGN KEY (`taxon_concept` )

    REFERENCES `default_schema`.`taxon` (`taxon` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_taxon_concept_source1`

    FOREIGN KEY (`source` )

    REFERENCES `default_schema`.`source` (`source` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`community`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`community` (

  `community` TEXT NOT NULL ,

  PRIMARY KEY (`community`) ,

  CONSTRAINT `fk_community_record1`

    FOREIGN KEY (`community` )

    REFERENCES `default_schema`.`record` (`record` )

    ON DELETE CASCADE

    ON UPDATE CASCADE)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`geological_context`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`geological_context` (

  `geological_context` TEXT NOT NULL ,

  PRIMARY KEY (`geological_context`) ,

  CONSTRAINT `fk_geological_context_record1`

    FOREIGN KEY (`geological_context` )

    REFERENCES `default_schema`.`record` (`record` )

    ON DELETE CASCADE

    ON UPDATE CASCADE)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`location_observation`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`location_observation` (

  `location_observation` TEXT NOT NULL ,

  `location` TEXT NOT NULL ,

  `geological_context` TEXT NULL DEFAULT NULL ,

  `community` TEXT NULL DEFAULT NULL ,

  PRIMARY KEY (`location_observation`) ,

  INDEX `fk_location_observation_location1` (`location` ASC) ,

  INDEX `fk_location_observation_geological_context1` (`geological_context` ASC) ,

  INDEX `fk_location_observation_community1` (`community` ASC) ,

  CONSTRAINT `fk_location_observation_location1`

    FOREIGN KEY (`location` )

    REFERENCES `default_schema`.`location` (`location` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_location_observation_occurrence1`

    FOREIGN KEY (`location_observation` )

    REFERENCES `default_schema`.`occurrence` (`occurrence` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_location_observation_geological_context1`

    FOREIGN KEY (`geological_context` )

    REFERENCES `default_schema`.`geological_context` (`geological_context` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_location_observation_community1`

    FOREIGN KEY (`community` )

    REFERENCES `default_schema`.`community` (`community` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`soil_observation`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`soil_observation` (

  `soil_observation` TEXT NOT NULL ,

  PRIMARY KEY (`soil_observation`) ,

  CONSTRAINT `fk_soil_observation_location_observation1`

    FOREIGN KEY (`soil_observation` )

    REFERENCES `default_schema`.`location_observation` (`location_observation` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`subplot`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`subplot` (

  `subplot` TEXT NOT NULL ,

  PRIMARY KEY (`subplot`) ,

  CONSTRAINT `fk_subplot_location1`

    FOREIGN KEY (`subplot` )

    REFERENCES `default_schema`.`location` (`location` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`geovalidation`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`geovalidation` (

  `geovalidation` TEXT NOT NULL ,

  `coordinates` TEXT NOT NULL ,

  `placename` TEXT NOT NULL ,

  PRIMARY KEY (`geovalidation`) ,

  INDEX `fk_geovalidation_coordinates1` (`coordinates` ASC) ,

  INDEX `fk_geovalidation_placename1` (`placename` ASC) ,

  CONSTRAINT `fk_geovalidation_record1`

    FOREIGN KEY (`geovalidation` )

    REFERENCES `default_schema`.`record` (`record` )

    ON DELETE CASCADE

    ON UPDATE CASCADE,

  CONSTRAINT `fk_geovalidation_coordinates1`

    FOREIGN KEY (`coordinates` )

    REFERENCES `default_schema`.`coordinates` (`coordinates` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION,

  CONSTRAINT `fk_geovalidation_placename1`

    FOREIGN KEY (`placename` )

    REFERENCES `default_schema`.`named_place` (`named_place` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`project`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`project` (

  `project` TEXT NOT NULL ,

  PRIMARY KEY (`project`) ,

  CONSTRAINT `fk_project_event1`

    FOREIGN KEY (`project` )

    REFERENCES `default_schema`.`event` (`event` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`party`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`party` (

  `party` TEXT NOT NULL ,

  PRIMARY KEY (`party`) ,

  CONSTRAINT `fk_collection_source10`

    FOREIGN KEY (`party` )

    REFERENCES `default_schema`.`source` (`source` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

-- -----------------------------------------------------

-- Table `default_schema`.`first_publisher`

-- -----------------------------------------------------

CREATE  TABLE IF NOT EXISTS `default_schema`.`first_publisher` (

  `first_publisher` TEXT NOT NULL ,

  PRIMARY KEY (`first_publisher`) ,

  CONSTRAINT `fk_collection_source100`

    FOREIGN KEY (`first_publisher` )

    REFERENCES `default_schema`.`source` (`source` )

    ON DELETE NO ACTION

    ON UPDATE NO ACTION)

ENGINE = InnoDB

DEFAULT CHARACTER SET = latin1

COLLATE = latin1_swedish_ci;

SET SQL_MODE=@OLD_SQL_MODE;

SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;

SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;