Project

General

Profile

« Previous | Next » 

Revision 8542

schemas/VegCore/VegCore.ERD.mwb: added taxon_path

View differences:

schemas/VegCore/VegCore.my.sql
863 863
COLLATE = latin1_swedish_ci;
864 864

  
865 865

  
866
-- -----------------------------------------------------
867
-- Table `taxon_path`
868
-- -----------------------------------------------------
869
CREATE  TABLE IF NOT EXISTS `taxon_path` (
870
  `id` TEXT NOT NULL ,
871
  PRIMARY KEY (`id`) ,
872
  CONSTRAINT `fk_taxon_path_taxon_concept1`
873
    FOREIGN KEY (`id` )
874
    REFERENCES `taxon_concept` (`id` )
875
    ON DELETE CASCADE
876
    ON UPDATE CASCADE)
877
ENGINE = InnoDB
878
DEFAULT CHARACTER SET = latin1
879
COLLATE = latin1_swedish_ci;
866 880

  
881

  
882

  
867 883
SET SQL_MODE=@OLD_SQL_MODE;
868 884
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
869 885
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

Also available in: Unified diff