Revision 8614
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/VegCore/VegCore.my.sql | ||
|---|---|---|
| 976 | 976 |
|
| 977 | 977 |
|
| 978 | 978 |
-- ----------------------------------------------------- |
| 979 |
-- Table `5. accepted`
|
|
| 979 |
-- Table `1. verbatim`
|
|
| 980 | 980 |
-- ----------------------------------------------------- |
| 981 |
CREATE TABLE IF NOT EXISTS `5. accepted` (
|
|
| 981 |
CREATE TABLE IF NOT EXISTS `1. verbatim` (
|
|
| 982 | 982 |
`id` TEXT NOT NULL , |
| 983 | 983 |
PRIMARY KEY (`id`) ) |
| 984 |
ENGINE = InnoDB; |
|
| 984 |
ENGINE = InnoDB |
|
| 985 |
DEFAULT CHARACTER SET = utf8 |
|
| 986 |
COLLATE = utf8_general_ci; |
|
| 985 | 987 |
|
| 986 | 988 |
|
| 987 | 989 |
-- ----------------------------------------------------- |
| 988 |
-- Table `4. matched`
|
|
| 990 |
-- Table `2. concatenated`
|
|
| 989 | 991 |
-- ----------------------------------------------------- |
| 990 |
CREATE TABLE IF NOT EXISTS `4. matched` (
|
|
| 992 |
CREATE TABLE IF NOT EXISTS `2. concatenated` (
|
|
| 991 | 993 |
`id` TEXT NOT NULL , |
| 992 |
`5. accepted_id` TEXT NOT NULL , |
|
| 993 |
PRIMARY KEY (`id`) , |
|
| 994 |
INDEX `fk_4. matched_5. accepted1_idx` (`5. accepted_id` ASC) , |
|
| 995 |
CONSTRAINT `fk_4. matched_5. accepted1` |
|
| 996 |
FOREIGN KEY (`5. accepted_id` ) |
|
| 997 |
REFERENCES `5. accepted` (`id` ) |
|
| 998 |
ON DELETE CASCADE |
|
| 999 |
ON UPDATE CASCADE) |
|
| 1000 |
ENGINE = InnoDB; |
|
| 994 |
PRIMARY KEY (`id`) ) |
|
| 995 |
ENGINE = InnoDB |
|
| 996 |
DEFAULT CHARACTER SET = utf8 |
|
| 997 |
COLLATE = utf8_general_ci; |
|
| 1001 | 998 |
|
| 1002 | 999 |
|
| 1003 | 1000 |
-- ----------------------------------------------------- |
| ... | ... | |
| 1005 | 1002 |
-- ----------------------------------------------------- |
| 1006 | 1003 |
CREATE TABLE IF NOT EXISTS `3. parsed` ( |
| 1007 | 1004 |
`id` TEXT NOT NULL , |
| 1008 |
`4. matched_id` TEXT NOT NULL , |
|
| 1009 |
PRIMARY KEY (`id`) , |
|
| 1010 |
INDEX `fk_3. parsed_4. matched1_idx` (`4. matched_id` ASC) , |
|
| 1011 |
CONSTRAINT `fk_3. parsed_4. matched1` |
|
| 1012 |
FOREIGN KEY (`4. matched_id` ) |
|
| 1013 |
REFERENCES `4. matched` (`id` ) |
|
| 1014 |
ON DELETE CASCADE |
|
| 1015 |
ON UPDATE CASCADE) |
|
| 1016 |
ENGINE = InnoDB; |
|
| 1005 |
PRIMARY KEY (`id`) ) |
|
| 1006 |
ENGINE = InnoDB |
|
| 1007 |
DEFAULT CHARACTER SET = utf8 |
|
| 1008 |
COLLATE = utf8_general_ci; |
|
| 1017 | 1009 |
|
| 1018 | 1010 |
|
| 1019 | 1011 |
-- ----------------------------------------------------- |
| 1020 |
-- Table `2. concatenated`
|
|
| 1012 |
-- Table `4. matched`
|
|
| 1021 | 1013 |
-- ----------------------------------------------------- |
| 1022 |
CREATE TABLE IF NOT EXISTS `2. concatenated` (
|
|
| 1014 |
CREATE TABLE IF NOT EXISTS `4. matched` (
|
|
| 1023 | 1015 |
`id` TEXT NOT NULL , |
| 1024 |
`3. parsed_id` TEXT NOT NULL , |
|
| 1025 |
PRIMARY KEY (`id`) , |
|
| 1026 |
INDEX `fk_2. concatenated_3. parsed1_idx` (`3. parsed_id` ASC) , |
|
| 1027 |
CONSTRAINT `fk_2. concatenated_3. parsed1` |
|
| 1028 |
FOREIGN KEY (`3. parsed_id` ) |
|
| 1029 |
REFERENCES `3. parsed` (`id` ) |
|
| 1030 |
ON DELETE CASCADE |
|
| 1031 |
ON UPDATE CASCADE) |
|
| 1032 |
ENGINE = InnoDB; |
|
| 1016 |
PRIMARY KEY (`id`) ) |
|
| 1017 |
ENGINE = InnoDB |
|
| 1018 |
DEFAULT CHARACTER SET = utf8 |
|
| 1019 |
COLLATE = utf8_general_ci; |
|
| 1033 | 1020 |
|
| 1034 | 1021 |
|
| 1035 | 1022 |
-- ----------------------------------------------------- |
| 1036 |
-- Table `1. verbatim`
|
|
| 1023 |
-- Table `5. accepted`
|
|
| 1037 | 1024 |
-- ----------------------------------------------------- |
| 1038 |
CREATE TABLE IF NOT EXISTS `1. verbatim` (
|
|
| 1025 |
CREATE TABLE IF NOT EXISTS `5. accepted` (
|
|
| 1039 | 1026 |
`id` TEXT NOT NULL , |
| 1040 |
`2. concatenated_id` TEXT NOT NULL , |
|
| 1041 |
PRIMARY KEY (`id`) , |
|
| 1042 |
INDEX `fk_1. verbatim_2. concatenated1_idx` (`2. concatenated_id` ASC) , |
|
| 1043 |
CONSTRAINT `fk_1. verbatim_2. concatenated1` |
|
| 1044 |
FOREIGN KEY (`2. concatenated_id` ) |
|
| 1045 |
REFERENCES `2. concatenated` (`id` ) |
|
| 1046 |
ON DELETE CASCADE |
|
| 1047 |
ON UPDATE CASCADE) |
|
| 1048 |
ENGINE = InnoDB; |
|
| 1027 |
PRIMARY KEY (`id`) ) |
|
| 1028 |
ENGINE = InnoDB |
|
| 1029 |
DEFAULT CHARACTER SET = utf8 |
|
| 1030 |
COLLATE = utf8_general_ci; |
|
| 1049 | 1031 |
|
| 1050 | 1032 |
|
| 1051 | 1033 |
-- ----------------------------------------------------- |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: TNRS taxonomic scrubbing steps labels: removed fkey columns to the next step since these are not needed and were causing problems with round-trip sync to the .my.sql file