Revision 8552
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 70 | 70 |
|
| 71 | 71 |
|
| 72 | 72 |
-- ----------------------------------------------------- |
| 73 |
-- Table `taxon_string` |
|
| 74 |
-- ----------------------------------------------------- |
|
| 75 |
CREATE TABLE IF NOT EXISTS `taxon_string` ( |
|
| 76 |
`string` TEXT NOT NULL , |
|
| 77 |
PRIMARY KEY (`string`) ) |
|
| 78 |
ENGINE = InnoDB |
|
| 79 |
DEFAULT CHARACTER SET = latin1 |
|
| 80 |
COLLATE = latin1_swedish_ci; |
|
| 81 |
|
|
| 82 |
|
|
| 83 |
-- ----------------------------------------------------- |
|
| 73 | 84 |
-- Table `taxon_assertion` |
| 74 | 85 |
-- ----------------------------------------------------- |
| 75 | 86 |
CREATE TABLE IF NOT EXISTS `taxon_assertion` ( |
| 76 | 87 |
`id` TEXT NOT NULL , |
| 88 |
`taxon_string` TEXT NOT NULL , |
|
| 77 | 89 |
PRIMARY KEY (`id`) , |
| 90 |
INDEX `fk_taxon_assertion_taxon_string1` (`taxon_string` ASC) , |
|
| 78 | 91 |
CONSTRAINT `fk_qualified_taxon_record1` |
| 79 | 92 |
FOREIGN KEY (`id` ) |
| 80 | 93 |
REFERENCES `record` (`id` ) |
| 81 | 94 |
ON DELETE CASCADE |
| 95 |
ON UPDATE CASCADE, |
|
| 96 |
CONSTRAINT `fk_taxon_assertion_taxon_string1` |
|
| 97 |
FOREIGN KEY (`taxon_string` ) |
|
| 98 |
REFERENCES `taxon_string` (`string` ) |
|
| 99 |
ON DELETE CASCADE |
|
| 82 | 100 |
ON UPDATE CASCADE) |
| 83 | 101 |
ENGINE = InnoDB |
| 84 | 102 |
DEFAULT CHARACTER SET = latin1 |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: added taxon_string, which is used by taxon_assertion