/ - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 8522

Added by Aaron Marcuse-Kubitza over 11 years ago

schemas/VegCore/VegCore.my.sql: removed default_schema qualifier from names because all objects are in the same schema

     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`
     -- Table `source`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`source` (
     CREATE  TABLE IF NOT EXISTS `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` )
         REFERENCES `source` (`source` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`record`
     -- Table `record`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`record` (
     CREATE  TABLE IF NOT EXISTS `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` )
         REFERENCES `source` (`source` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`relationship`
     -- Table `relationship`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`relationship` (
     CREATE  TABLE IF NOT EXISTS `relationship` (
       `relationship` TEXT NOT NULL ,
       `record` TEXT NOT NULL ,
       `related_record` TEXT NOT NULL ,
-...
       INDEX `fk_relationship_related_record` (`related_record` ASC) ,
       CONSTRAINT `fk_relationship_record1`
         FOREIGN KEY (`relationship` )
         REFERENCES `default_schema`.`record` (`record` )
         REFERENCES `record` (`record` )
         ON DELETE CASCADE
         ON UPDATE CASCADE,
       CONSTRAINT `fk_relationship_record1`
         FOREIGN KEY (`record` )
         REFERENCES `default_schema`.`record` (`record` )
         REFERENCES `record` (`record` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION,
       CONSTRAINT `fk_relationship_related_record`
         FOREIGN KEY (`related_record` )
         REFERENCES `default_schema`.`record` (`record` )
         REFERENCES `record` (`record` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`taxon`
     -- Table `taxon`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`taxon` (
     CREATE  TABLE IF NOT EXISTS `taxon` (
       `taxon` TEXT NOT NULL ,
       `taxon_parent` TEXT NULL ,
       PRIMARY KEY (`taxon`) ,
       INDEX `fk_taxon_taxon1` (`taxon_parent` ASC) ,
       CONSTRAINT `fk_taxon_record1`
         FOREIGN KEY (`taxon` )
         REFERENCES `default_schema`.`record` (`record` )
         REFERENCES `record` (`record` )
         ON DELETE CASCADE
         ON UPDATE CASCADE,
       CONSTRAINT `fk_taxon_taxon1`
         FOREIGN KEY (`taxon_parent` )
         REFERENCES `default_schema`.`taxon` (`taxon` )
         REFERENCES `taxon` (`taxon` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`taxon_assertion`
     -- Table `taxon_assertion`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`taxon_assertion` (
     CREATE  TABLE IF NOT EXISTS `taxon_assertion` (
       `taxon_assertion` TEXT NOT NULL ,
       `taxon` TEXT NOT NULL ,
       PRIMARY KEY (`taxon_assertion`) ,
       INDEX `fk_qualified_taxon_name_taxon1` (`taxon` ASC) ,
       CONSTRAINT `fk_qualified_taxon_record1`
         FOREIGN KEY (`taxon_assertion` )
         REFERENCES `default_schema`.`record` (`record` )
         REFERENCES `record` (`record` )
         ON DELETE CASCADE
         ON UPDATE CASCADE,
       CONSTRAINT `fk_qualified_taxon_name_taxon1`
         FOREIGN KEY (`taxon` )
         REFERENCES `default_schema`.`taxon` (`taxon` )
         REFERENCES `taxon` (`taxon` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`taxon_determination`
     -- Table `taxon_determination`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`taxon_determination` (
     CREATE  TABLE IF NOT EXISTS `taxon_determination` (
       `taxon_determination` VARCHAR(45) NOT NULL ,
       `taxon_occurrence` TEXT NOT NULL ,
       `qualified_taxon` TEXT NOT NULL ,
-...
       PRIMARY KEY (`taxon_determination`) ,
       CONSTRAINT `fk_taxon_occurrence_has_qualified_taxon_occurrence1`
         FOREIGN KEY (`taxon_occurrence` )
         REFERENCES `default_schema`.`taxon_occurrence` (`taxon_occurrence` )
         REFERENCES `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`.`taxon_assertion` (`taxon_assertion` )
         REFERENCES `taxon_assertion` (`taxon_assertion` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION,
       CONSTRAINT `fk_taxon_determination_record1`
         FOREIGN KEY (`taxon_determination` )
         REFERENCES `default_schema`.`record` (`record` )
         REFERENCES `record` (`record` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`coordinates`
     -- Table `coordinates`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`coordinates` (
     CREATE  TABLE IF NOT EXISTS `coordinates` (
       `coordinates` TEXT NOT NULL ,
       PRIMARY KEY (`coordinates`) ,
       CONSTRAINT `fk_coordinates_record1`
         FOREIGN KEY (`coordinates` )
         REFERENCES `default_schema`.`record` (`record` )
         REFERENCES `record` (`record` )
         ON DELETE CASCADE
         ON UPDATE CASCADE)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`named_place`
     -- Table `named_place`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`named_place` (
     CREATE  TABLE IF NOT EXISTS `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` )
         REFERENCES `record` (`record` )
         ON DELETE CASCADE
         ON UPDATE CASCADE)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`location`
     -- Table `location`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`location` (
     CREATE  TABLE IF NOT EXISTS `location` (
       `location` TEXT NOT NULL ,
       `location_parent` TEXT NULL DEFAULT NULL ,
       `named_place` TEXT NULL DEFAULT NULL ,
-...
       INDEX `fk_location1` (`location_parent` ASC) ,
       CONSTRAINT `fk_location_record1`
         FOREIGN KEY (`location` )
         REFERENCES `default_schema`.`record` (`record` )
         REFERENCES `record` (`record` )
         ON DELETE CASCADE
         ON UPDATE CASCADE,
       CONSTRAINT `fk_location_coordinates1`
         FOREIGN KEY (`coordinates` )
         REFERENCES `default_schema`.`coordinates` (`coordinates` )
         REFERENCES `coordinates` (`coordinates` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION,
       CONSTRAINT `fk_location_placename1`
         FOREIGN KEY (`named_place` )
         REFERENCES `default_schema`.`named_place` (`named_place` )
         REFERENCES `named_place` (`named_place` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION,
       CONSTRAINT `fk_location1`
         FOREIGN KEY (`location_parent` )
         REFERENCES `default_schema`.`location` (`location` )
         REFERENCES `location` (`location` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`method`
     -- Table `method`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`method` (
     CREATE  TABLE IF NOT EXISTS `method` (
       `method` TEXT NOT NULL ,
       PRIMARY KEY (`method`) ,
       CONSTRAINT `fk_method_record1`
         FOREIGN KEY (`method` )
         REFERENCES `default_schema`.`record` (`record` )
         REFERENCES `record` (`record` )
         ON DELETE CASCADE
         ON UPDATE CASCADE)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`event`
     -- Table `event`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`event` (
     CREATE  TABLE IF NOT EXISTS `event` (
       `event` TEXT NOT NULL ,
       `event_parent` TEXT NULL DEFAULT NULL ,
       `location` TEXT NULL DEFAULT NULL ,
-...
       INDEX `fk_event_method1` (`method` ASC) ,
       CONSTRAINT `fk_event_record1`
         FOREIGN KEY (`event` )
         REFERENCES `default_schema`.`record` (`record` )
         REFERENCES `record` (`record` )
         ON DELETE CASCADE
         ON UPDATE CASCADE,
       CONSTRAINT `fk_event_location1`
         FOREIGN KEY (`location` )
         REFERENCES `default_schema`.`location` (`location` )
         REFERENCES `location` (`location` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION,
       CONSTRAINT `fk_event1`
         FOREIGN KEY (`event_parent` )
         REFERENCES `default_schema`.`event` (`event` )
         REFERENCES `event` (`event` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION,
       CONSTRAINT `fk_event_method1`
         FOREIGN KEY (`method` )
         REFERENCES `default_schema`.`method` (`method` )
         REFERENCES `method` (`method` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`taxon_occurrence`
     -- Table `taxon_occurrence`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`taxon_occurrence` (
     CREATE  TABLE IF NOT EXISTS `taxon_occurrence` (
       `taxon_occurrence` TEXT NOT NULL ,
       `current_taxon_determination` VARCHAR(45) NULL DEFAULT NULL ,
       `original_taxon_determination` VARCHAR(45) NULL DEFAULT NULL ,
-...
       INDEX `fk_taxon_occurrence_event1` (`taxon_occurrence` ASC) ,
       CONSTRAINT `fk_taxon_occurrence_taxon_determination1`
         FOREIGN KEY (`original_taxon_determination` )
         REFERENCES `default_schema`.`taxon_determination` (`taxon_determination` )
         REFERENCES `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` )
         REFERENCES `taxon_determination` (`taxon_determination` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION,
       CONSTRAINT `fk_taxon_occurrence_event1`
         FOREIGN KEY (`taxon_occurrence` )
         REFERENCES `default_schema`.`event` (`event` )
         REFERENCES `event` (`event` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`trait`
     -- Table `trait`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`trait` (
     CREATE  TABLE IF NOT EXISTS `trait` (
       `trait` TEXT NOT NULL ,
       `taxon_occurrence` TEXT NOT NULL ,
       PRIMARY KEY (`trait`) ,
       INDEX `fk_trait_taxon_occurrence1` (`taxon_occurrence` ASC) ,
       CONSTRAINT `fk_measurement_record1`
         FOREIGN KEY (`trait` )
         REFERENCES `default_schema`.`record` (`record` )
         REFERENCES `record` (`record` )
         ON DELETE CASCADE
         ON UPDATE CASCADE,
       CONSTRAINT `fk_trait_taxon_occurrence1`
         FOREIGN KEY (`taxon_occurrence` )
         REFERENCES `default_schema`.`taxon_occurrence` (`taxon_occurrence` )
         REFERENCES `taxon_occurrence` (`taxon_occurrence` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`collection`
     -- Table `collection`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`collection` (
     CREATE  TABLE IF NOT EXISTS `collection` (
       `collection` TEXT NOT NULL ,
       PRIMARY KEY (`collection`) ,
       CONSTRAINT `fk_collection_source1`
         FOREIGN KEY (`collection` )
         REFERENCES `default_schema`.`source` (`source` )
         REFERENCES `source` (`source` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`specimen`
     -- Table `specimen`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`specimen` (
     CREATE  TABLE IF NOT EXISTS `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` )
         REFERENCES `taxon_occurrence` (`taxon_occurrence` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION,
       CONSTRAINT `fk_specimen_collection1`
         FOREIGN KEY (`collection` )
         REFERENCES `default_schema`.`collection` (`collection` )
         REFERENCES `collection` (`collection` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`voucher`
     -- Table `voucher`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`voucher` (
     CREATE  TABLE IF NOT EXISTS `voucher` (
       `voucher` TEXT NOT NULL ,
       `taxon_occurrence` TEXT NOT NULL ,
       `specimen` TEXT NOT NULL ,
-...
       INDEX `fk_voucher_specimen1` (`specimen` ASC) ,
       CONSTRAINT `fk_voucher_record1`
         FOREIGN KEY (`voucher` )
         REFERENCES `default_schema`.`record` (`record` )
         REFERENCES `record` (`record` )
         ON DELETE CASCADE
         ON UPDATE CASCADE,
       CONSTRAINT `fk_voucher_taxon_occurrence1`
         FOREIGN KEY (`taxon_occurrence` )
         REFERENCES `default_schema`.`taxon_occurrence` (`taxon_occurrence` )
         REFERENCES `taxon_occurrence` (`taxon_occurrence` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION,
       CONSTRAINT `fk_voucher_specimen1`
         FOREIGN KEY (`specimen` )
         REFERENCES `default_schema`.`specimen` (`specimen` )
         REFERENCES `specimen` (`specimen` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`individual`
     -- Table `individual`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`individual` (
     CREATE  TABLE IF NOT EXISTS `individual` (
       `individual` TEXT NOT NULL ,
       PRIMARY KEY (`individual`) ,
       CONSTRAINT `fk_individual_record1`
         FOREIGN KEY (`individual` )
         REFERENCES `default_schema`.`record` (`record` )
         REFERENCES `record` (`record` )
         ON DELETE CASCADE
         ON UPDATE CASCADE)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`individual_observation`
     -- Table `individual_observation`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`individual_observation` (
     CREATE  TABLE IF NOT EXISTS `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` )
         REFERENCES `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` )
         REFERENCES `individual` (`individual` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`stem`
     -- Table `stem`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`stem` (
     CREATE  TABLE IF NOT EXISTS `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` )
         REFERENCES `record` (`record` )
         ON DELETE CASCADE
         ON UPDATE CASCADE,
       CONSTRAINT `fk_stem_individual1`
         FOREIGN KEY (`individual` )
         REFERENCES `default_schema`.`individual` (`individual` )
         REFERENCES `individual` (`individual` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`stem_observation`
     -- Table `stem_observation`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`stem_observation` (
     CREATE  TABLE IF NOT EXISTS `stem_observation` (
       `stem_observation` TEXT NOT NULL ,
       `individual_observation` TEXT NOT NULL ,
       `stem` TEXT NOT NULL ,
-...
       INDEX `fk_stem_observation_stem1` (`stem` ASC) ,
       CONSTRAINT `fk_stem_observation_record1`
         FOREIGN KEY (`stem_observation` )
         REFERENCES `default_schema`.`record` (`record` )
         REFERENCES `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` )
         REFERENCES `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` )
         REFERENCES `stem` (`stem` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`aggregate_observation`
     -- Table `aggregate_observation`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`aggregate_observation` (
     CREATE  TABLE IF NOT EXISTS `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` )
         REFERENCES `taxon_occurrence` (`taxon_occurrence` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`taxon_observation`
     -- Table `taxon_observation`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`taxon_observation` (
     CREATE  TABLE IF NOT EXISTS `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` )
         REFERENCES `taxon_occurrence` (`taxon_occurrence` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`accepted_taxon`
     -- Table `accepted_taxon`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`accepted_taxon` (
     CREATE  TABLE IF NOT EXISTS `accepted_taxon` (
       `accepted_taxon` TEXT NOT NULL ,
       PRIMARY KEY (`accepted_taxon`) ,
       CONSTRAINT `fk_accepted_taxon_taxon1`
         FOREIGN KEY (`accepted_taxon` )
         REFERENCES `default_schema`.`taxon` (`taxon` )
         REFERENCES `taxon` (`taxon` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`synonym_taxon`
     -- Table `synonym_taxon`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`synonym_taxon` (
     CREATE  TABLE IF NOT EXISTS `synonym_taxon` (
       `synonym_taxon` TEXT NOT NULL ,
       `accepted_taxon` TEXT NULL ,
       PRIMARY KEY (`synonym_taxon`) ,
       INDEX `fk_matched_taxon_accepted_taxon1` (`accepted_taxon` ASC) ,
       CONSTRAINT `fk_matched_taxon_taxon1`
         FOREIGN KEY (`synonym_taxon` )
         REFERENCES `default_schema`.`taxon` (`taxon` )
         REFERENCES `taxon` (`taxon` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION,
       CONSTRAINT `fk_matched_taxon_accepted_taxon1`
         FOREIGN KEY (`accepted_taxon` )
         REFERENCES `default_schema`.`accepted_taxon` (`accepted_taxon` )
         REFERENCES `accepted_taxon` (`accepted_taxon` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`taxon_concept`
     -- Table `taxon_concept`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`taxon_concept` (
     CREATE  TABLE IF NOT EXISTS `taxon_concept` (
       `taxon_concept` TEXT NOT NULL ,
       `according_to` TEXT NOT NULL ,
       PRIMARY KEY (`taxon_concept`) ,
       INDEX `fk_taxon_concept_source1` (`according_to` ASC) ,
       CONSTRAINT `fk_taxon_concept_taxon1`
         FOREIGN KEY (`taxon_concept` )
         REFERENCES `default_schema`.`taxon` (`taxon` )
         REFERENCES `taxon` (`taxon` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION,
       CONSTRAINT `fk_taxon_concept_source1`
         FOREIGN KEY (`according_to` )
         REFERENCES `default_schema`.`source` (`source` )
         REFERENCES `source` (`source` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`community`
     -- Table `community`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`community` (
     CREATE  TABLE IF NOT EXISTS `community` (
       `community` TEXT NOT NULL ,
       PRIMARY KEY (`community`) ,
       CONSTRAINT `fk_community_record1`
         FOREIGN KEY (`community` )
         REFERENCES `default_schema`.`record` (`record` )
         REFERENCES `record` (`record` )
         ON DELETE CASCADE
         ON UPDATE CASCADE)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`geological_context`
     -- Table `geological_context`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`geological_context` (
     CREATE  TABLE IF NOT EXISTS `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` )
         REFERENCES `record` (`record` )
         ON DELETE CASCADE
         ON UPDATE CASCADE)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`location_observation`
     -- Table `location_observation`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`location_observation` (
     CREATE  TABLE IF NOT EXISTS `location_observation` (
       `location_observation` TEXT NOT NULL ,
       `location` TEXT NOT NULL ,
       `geological_context` TEXT NULL DEFAULT NULL ,
-...
       INDEX `fk_location_observation_community1` (`community` ASC) ,
       CONSTRAINT `fk_location_observation_location1`
         FOREIGN KEY (`location` )
         REFERENCES `default_schema`.`location` (`location` )
         REFERENCES `location` (`location` )
         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` )
         REFERENCES `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` )
         REFERENCES `community` (`community` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION,
       CONSTRAINT `fk_location_observation_event1`
         FOREIGN KEY (`location_observation` )
         REFERENCES `default_schema`.`event` (`event` )
         REFERENCES `event` (`event` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`soil_observation`
     -- Table `soil_observation`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`soil_observation` (
     CREATE  TABLE IF NOT EXISTS `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` )
         REFERENCES `location_observation` (`location_observation` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`subplot`
     -- Table `subplot`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`subplot` (
     CREATE  TABLE IF NOT EXISTS `subplot` (
       `subplot` TEXT NOT NULL ,
       PRIMARY KEY (`subplot`) ,
       CONSTRAINT `fk_subplot_location1`
         FOREIGN KEY (`subplot` )
         REFERENCES `default_schema`.`location` (`location` )
         REFERENCES `location` (`location` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`geovalidation`
     -- Table `geovalidation`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`geovalidation` (
     CREATE  TABLE IF NOT EXISTS `geovalidation` (
       `geovalidation` TEXT NOT NULL ,
       `coordinates` TEXT NOT NULL ,
       `named_place` TEXT NOT NULL ,
-...
       INDEX `fk_geovalidation_placename1` (`named_place` ASC) ,
       CONSTRAINT `fk_geovalidation_record1`
         FOREIGN KEY (`geovalidation` )
         REFERENCES `default_schema`.`record` (`record` )
         REFERENCES `record` (`record` )
         ON DELETE CASCADE
         ON UPDATE CASCADE,
       CONSTRAINT `fk_geovalidation_coordinates1`
         FOREIGN KEY (`coordinates` )
         REFERENCES `default_schema`.`coordinates` (`coordinates` )
         REFERENCES `coordinates` (`coordinates` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION,
       CONSTRAINT `fk_geovalidation_placename1`
         FOREIGN KEY (`named_place` )
         REFERENCES `default_schema`.`named_place` (`named_place` )
         REFERENCES `named_place` (`named_place` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`project`
     -- Table `project`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`project` (
     CREATE  TABLE IF NOT EXISTS `project` (
       `project` TEXT NOT NULL ,
       PRIMARY KEY (`project`) ,
       CONSTRAINT `fk_project_event1`
         FOREIGN KEY (`project` )
         REFERENCES `default_schema`.`event` (`event` )
         REFERENCES `event` (`event` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`parsed_taxon_assertion`
     -- Table `parsed_taxon_assertion`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`parsed_taxon_assertion` (
     CREATE  TABLE IF NOT EXISTS `parsed_taxon_assertion` (
       `parsed_taxon_assertion` TEXT NOT NULL ,
       `matched_taxon` TEXT NULL ,
       PRIMARY KEY (`parsed_taxon_assertion`) ,
       INDEX `fk_parsed_taxon_matched_taxon1` (`matched_taxon` ASC) ,
       CONSTRAINT `fk_matched_taxon_qualified_taxon10`
         FOREIGN KEY (`parsed_taxon_assertion` )
         REFERENCES `default_schema`.`taxon_assertion` (`taxon_assertion` )
         REFERENCES `taxon_assertion` (`taxon_assertion` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION,
       CONSTRAINT `fk_parsed_taxon_matched_taxon1`
         FOREIGN KEY (`matched_taxon` )
         REFERENCES `default_schema`.`synonym_taxon` (`synonym_taxon` )
         REFERENCES `synonym_taxon` (`synonym_taxon` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`verbatim_taxon_assertion`
     -- Table `verbatim_taxon_assertion`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`verbatim_taxon_assertion` (
     CREATE  TABLE IF NOT EXISTS `verbatim_taxon_assertion` (
       `verbatim_taxon_assertion` TEXT NOT NULL ,
       `parsed_taxon` TEXT NULL ,
       PRIMARY KEY (`verbatim_taxon_assertion`) ,
       INDEX `fk_verbatim_taxon_parsed_taxon1` (`parsed_taxon` ASC) ,
       CONSTRAINT `fk_matched_taxon_qualified_taxon100`
         FOREIGN KEY (`verbatim_taxon_assertion` )
         REFERENCES `default_schema`.`taxon_assertion` (`taxon_assertion` )
         REFERENCES `taxon_assertion` (`taxon_assertion` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION,
       CONSTRAINT `fk_verbatim_taxon_parsed_taxon1`
         FOREIGN KEY (`parsed_taxon` )
         REFERENCES `default_schema`.`parsed_taxon_assertion` (`parsed_taxon_assertion` )
         REFERENCES `parsed_taxon_assertion` (`parsed_taxon_assertion` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`party`
     -- Table `party`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`party` (
     CREATE  TABLE IF NOT EXISTS `party` (
       `party` TEXT NOT NULL ,
       PRIMARY KEY (`party`) ,
       CONSTRAINT `fk_collection_source10`
         FOREIGN KEY (`party` )
         REFERENCES `default_schema`.`source` (`source` )
         REFERENCES `source` (`source` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`first_publisher`
     -- Table `first_publisher`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`first_publisher` (
     CREATE  TABLE IF NOT EXISTS `first_publisher` (
       `first_publisher` TEXT NOT NULL ,
       PRIMARY KEY (`first_publisher`) ,
       CONSTRAINT `fk_collection_source100`
         FOREIGN KEY (`first_publisher` )
         REFERENCES `default_schema`.`source` (`source` )
         REFERENCES `source` (`source` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB
-...
     -- -----------------------------------------------------
     -- Table `default_schema`.`referenced_class`
     -- Table `referenced_class`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`referenced_class` (
     CREATE  TABLE IF NOT EXISTS `referenced_class` (
       `referenced_class` INT NOT NULL ,
       PRIMARY KEY (`referenced_class`) ,
       CONSTRAINT `fk_example_record10`
         FOREIGN KEY (`referenced_class` )
         REFERENCES `default_schema`.`record` (`record` )
         REFERENCES `record` (`record` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB;
     -- -----------------------------------------------------
     -- Table `default_schema`.`base_class`
     -- Table `base_class`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`base_class` (
     CREATE  TABLE IF NOT EXISTS `base_class` (
       `base_class` INT NOT NULL ,
       `referenced_class` INT NOT NULL ,
       PRIMARY KEY (`base_class`) ,
       INDEX `fk_base_class_referenced_class1` (`referenced_class` ASC) ,
       CONSTRAINT `fk_example_record1`
         FOREIGN KEY (`base_class` )
         REFERENCES `default_schema`.`record` (`record` )
         REFERENCES `record` (`record` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION,
       CONSTRAINT `fk_base_class_referenced_class1`
         FOREIGN KEY (`referenced_class` )
         REFERENCES `default_schema`.`referenced_class` (`referenced_class` )
         REFERENCES `referenced_class` (`referenced_class` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB;
     -- -----------------------------------------------------
     -- Table `default_schema`.`derived_class`
     -- Table `derived_class`
     -- -----------------------------------------------------
     CREATE  TABLE IF NOT EXISTS `default_schema`.`derived_class` (
     CREATE  TABLE IF NOT EXISTS `derived_class` (
       `derived_class` INT NOT NULL ,
       PRIMARY KEY (`derived_class`) ,
       CONSTRAINT `fk_derived_class_base_class1`
         FOREIGN KEY (`derived_class` )
         REFERENCES `default_schema`.`base_class` (`base_class` )
         REFERENCES `base_class` (`base_class` )
         ON DELETE NO ACTION
         ON UPDATE NO ACTION)
     ENGINE = InnoDB;

Also available in: Unified diff

Project

General

Profile

Revision 8522

Added by Aaron Marcuse-Kubitza over 11 years ago