Revision 8542
Added by Aaron Marcuse-Kubitza over 11 years ago
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
schemas/VegCore/VegCore.ERD.mwb: added taxon_path