Revision 10437
Added by Aaron Marcuse-Kubitza almost 11 years ago
VegCore.my.sql | ||
---|---|---|
22 | 22 |
"traits" set('hstore') COLLATE utf8_bin DEFAULT NULL, |
23 | 23 |
PRIMARY KEY ("id"), |
24 | 24 |
KEY "fk_aggregate_observation_taxon_name1_idx" ("taxon_concept"), |
25 |
CONSTRAINT "fk_aggregate_observation_taxon_name1" FOREIGN KEY ("taxon_concept") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
26 |
CONSTRAINT "fk_aggregate_observation_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
25 |
CONSTRAINT "fk_aggregate_observation_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
26 |
CONSTRAINT "fk_aggregate_observation_taxon_name1" FOREIGN KEY ("taxon_concept") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
27 | 27 |
); |
28 | 28 |
/*!40101 SET character_set_client = @saved_cs_client */; |
29 | 29 |
|
... | ... | |
45 | 45 |
"referenced_class" varbinary(767) NOT NULL, |
46 | 46 |
PRIMARY KEY ("id"), |
47 | 47 |
KEY "fk_base_class_referenced_class1_idx" ("referenced_class"), |
48 |
CONSTRAINT "fk_base_class_referenced_class1" FOREIGN KEY ("referenced_class") REFERENCES "referenced_class" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
|
49 |
CONSTRAINT "fk_example_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE |
|
48 |
CONSTRAINT "fk_base_class_referenced_class1" FOREIGN KEY ("referenced_class") REFERENCES "referenced_class" ("id") ON DELETE CASCADE ON UPDATE CASCADE |
|
50 | 49 |
); |
51 | 50 |
/*!40101 SET character_set_client = @saved_cs_client */; |
52 | 51 |
|
... | ... | |
71 | 70 |
UNIQUE KEY "collection_unique" ("institution","name"), |
72 | 71 |
KEY "fk_collection_organization1_idx" ("institution"), |
73 | 72 |
KEY "fk_collection_source1_idx" ("id"), |
74 |
CONSTRAINT "fk_collection_organization1" FOREIGN KEY ("institution") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
75 |
CONSTRAINT "fk_collection_source1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
73 |
CONSTRAINT "fk_collection_source1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
74 |
CONSTRAINT "fk_collection_organization1" FOREIGN KEY ("institution") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
76 | 75 |
); |
77 | 76 |
/*!40101 SET character_set_client = @saved_cs_client */; |
78 | 77 |
|
... | ... | |
163 | 162 |
KEY "fk_event_place1_idx" ("place"), |
164 | 163 |
KEY "fk_event1_idx" ("parent"), |
165 | 164 |
KEY "fk_event_method1_idx" ("method"), |
165 |
CONSTRAINT "fk_event_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
|
166 |
CONSTRAINT "fk_event_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
|
166 | 167 |
CONSTRAINT "fk_event1" FOREIGN KEY ("parent") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
167 |
CONSTRAINT "fk_event_method1" FOREIGN KEY ("method") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
|
168 |
CONSTRAINT "fk_event_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
|
169 |
CONSTRAINT "fk_event_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE |
|
168 |
CONSTRAINT "fk_event_method1" FOREIGN KEY ("method") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE |
|
170 | 169 |
); |
171 | 170 |
/*!40101 SET character_set_client = @saved_cs_client */; |
172 | 171 |
|
... | ... | |
281 | 280 |
"traits" set('hstore') COLLATE utf8_bin DEFAULT NULL, |
282 | 281 |
PRIMARY KEY ("id"), |
283 | 282 |
KEY "fk_individual_observation_individual1_idx" ("individual"), |
284 |
CONSTRAINT "fk_individual_observation_individual1" FOREIGN KEY ("individual") REFERENCES "individual" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
285 |
CONSTRAINT "fk_individual_observation_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
283 |
CONSTRAINT "fk_individual_observation_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
284 |
CONSTRAINT "fk_individual_observation_individual1" FOREIGN KEY ("individual") REFERENCES "individual" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
286 | 285 |
); |
287 | 286 |
/*!40101 SET character_set_client = @saved_cs_client */; |
288 | 287 |
|
... | ... | |
305 | 304 |
"info" set('hstore') COLLATE utf8_bin DEFAULT NULL, |
306 | 305 |
PRIMARY KEY ("id"), |
307 | 306 |
KEY "fk_method_method1_idx" ("parent"), |
308 |
CONSTRAINT "fk_method_method1" FOREIGN KEY ("parent") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
309 |
CONSTRAINT "fk_method_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
307 |
CONSTRAINT "fk_method_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
308 |
CONSTRAINT "fk_method_method1" FOREIGN KEY ("parent") REFERENCES "method" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
310 | 309 |
); |
311 | 310 |
/*!40101 SET character_set_client = @saved_cs_client */; |
312 | 311 |
|
... | ... | |
400 | 399 |
KEY "fk_place_coordinates1_idx" ("coordinates"), |
401 | 400 |
KEY "fk_place1_idx" ("parent"), |
402 | 401 |
KEY "fk_place_place_path1_idx" ("path"), |
402 |
CONSTRAINT "fk_place_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
|
403 |
CONSTRAINT "fk_place_coordinates1" FOREIGN KEY ("coordinates") REFERENCES "coordinates" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
|
403 | 404 |
CONSTRAINT "fk_place1" FOREIGN KEY ("parent") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
404 |
CONSTRAINT "fk_place_coordinates1" FOREIGN KEY ("coordinates") REFERENCES "coordinates" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
|
405 |
CONSTRAINT "fk_place_place_path1" FOREIGN KEY ("path") REFERENCES "place_path" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
|
406 |
CONSTRAINT "fk_place_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE |
|
405 |
CONSTRAINT "fk_place_place_path1" FOREIGN KEY ("path") REFERENCES "place_path" ("id") ON DELETE CASCADE ON UPDATE CASCADE |
|
407 | 406 |
); |
408 | 407 |
/*!40101 SET character_set_client = @saved_cs_client */; |
409 | 408 |
|
... | ... | |
434 | 433 |
KEY "fk_place_observation_geological_context1_idx" ("geological_context"), |
435 | 434 |
KEY "fk_place_observation_community1_idx" ("community"), |
436 | 435 |
KEY "fk_place_observation_event1_idx" ("id"), |
436 |
CONSTRAINT "fk_place_observation_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
|
437 |
CONSTRAINT "fk_place_observation_geological_context1" FOREIGN KEY ("geological_context") REFERENCES "geological_context" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
|
437 | 438 |
CONSTRAINT "fk_place_observation_community1" FOREIGN KEY ("community") REFERENCES "community" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
438 |
CONSTRAINT "fk_place_observation_event1" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
|
439 |
CONSTRAINT "fk_place_observation_geological_context1" FOREIGN KEY ("geological_context") REFERENCES "geological_context" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
|
440 |
CONSTRAINT "fk_place_observation_place1" FOREIGN KEY ("place") REFERENCES "place" ("id") ON DELETE CASCADE ON UPDATE CASCADE |
|
439 |
CONSTRAINT "fk_place_observation_event1" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE |
|
441 | 440 |
); |
442 | 441 |
/*!40101 SET character_set_client = @saved_cs_client */; |
443 | 442 |
|
... | ... | |
669 | 668 |
KEY "fk_specimen_individual1_idx" ("individual"), |
670 | 669 |
KEY "fk_specimen_collection2_idx" ("current_collection"), |
671 | 670 |
KEY "fk_specimen_organization3_idx" ("owner_collection"), |
671 |
CONSTRAINT "fk_specimen_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "taxon_occurrence" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
|
672 | 672 |
CONSTRAINT "fk_specimen_collection1" FOREIGN KEY ("orig_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
673 |
CONSTRAINT "fk_specimen_collection2" FOREIGN KEY ("current_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
|
674 |
CONSTRAINT "fk_specimen_individual1" FOREIGN KEY ("individual") REFERENCES "individual" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
|
675 | 673 |
CONSTRAINT "fk_specimen_organization3" FOREIGN KEY ("owner_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
676 | 674 |
CONSTRAINT "fk_specimen_taxon_observation1" FOREIGN KEY ("collection_event") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
677 |
CONSTRAINT "fk_specimen_taxon_occurrence1" FOREIGN KEY ("id") REFERENCES "taxon_occurrence" ("id") ON DELETE CASCADE ON UPDATE CASCADE |
|
675 |
CONSTRAINT "fk_specimen_individual1" FOREIGN KEY ("individual") REFERENCES "individual" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
|
676 |
CONSTRAINT "fk_specimen_collection2" FOREIGN KEY ("current_collection") REFERENCES "collection" ("id") ON DELETE CASCADE ON UPDATE CASCADE |
|
678 | 677 |
); |
679 | 678 |
/*!40101 SET character_set_client = @saved_cs_client */; |
680 | 679 |
|
... | ... | |
697 | 696 |
"traits" set('hstore') COLLATE utf8_bin DEFAULT NULL, |
698 | 697 |
PRIMARY KEY ("id"), |
699 | 698 |
KEY "fk_specimen_observation_specimen1_idx" ("specimen"), |
700 |
CONSTRAINT "fk_specimen_observation_specimen1" FOREIGN KEY ("specimen") REFERENCES "specimen" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
701 |
CONSTRAINT "fk_specimen_taxon_occurrence10" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
699 |
CONSTRAINT "fk_specimen_taxon_occurrence10" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
700 |
CONSTRAINT "fk_specimen_observation_specimen1" FOREIGN KEY ("specimen") REFERENCES "specimen" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
702 | 701 |
); |
703 | 702 |
/*!40101 SET character_set_client = @saved_cs_client */; |
704 | 703 |
|
... | ... | |
722 | 721 |
PRIMARY KEY ("specimen","institution"), |
723 | 722 |
KEY "fk_specimen_has_organization_organization1_idx" ("institution"), |
724 | 723 |
KEY "fk_specimen_has_organization_specimen1_idx" ("specimen"), |
725 |
CONSTRAINT "fk_specimen_has_organization_organization1" FOREIGN KEY ("institution") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
726 |
CONSTRAINT "fk_specimen_has_organization_specimen1" FOREIGN KEY ("specimen") REFERENCES "specimen" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
724 |
CONSTRAINT "fk_specimen_has_organization_specimen1" FOREIGN KEY ("specimen") REFERENCES "specimen" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
725 |
CONSTRAINT "fk_specimen_has_organization_organization1" FOREIGN KEY ("institution") REFERENCES "organization" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
727 | 726 |
); |
728 | 727 |
/*!40101 SET character_set_client = @saved_cs_client */; |
729 | 728 |
|
... | ... | |
773 | 772 |
KEY "fk_stem_observation_individual_observation1_idx" ("individual_observation"), |
774 | 773 |
KEY "fk_stem_observation_stem1_idx" ("stem"), |
775 | 774 |
CONSTRAINT "fk_stem_observation_individual_observation1" FOREIGN KEY ("individual_observation") REFERENCES "individual_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
776 |
CONSTRAINT "fk_stem_observation_individual_observation2" FOREIGN KEY ("id") REFERENCES "individual_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
777 |
CONSTRAINT "fk_stem_observation_stem1" FOREIGN KEY ("stem") REFERENCES "stem" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
775 |
CONSTRAINT "fk_stem_observation_stem1" FOREIGN KEY ("stem") REFERENCES "stem" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
776 |
CONSTRAINT "fk_stem_observation_individual_observation2" FOREIGN KEY ("id") REFERENCES "individual_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
778 | 777 |
); |
779 | 778 |
/*!40101 SET character_set_client = @saved_cs_client */; |
780 | 779 |
|
... | ... | |
845 | 844 |
KEY "fk_taxon_assertion_taxon_string1_idx" ("string"), |
846 | 845 |
KEY "fk_taxon_assertion_taxon_name1_idx" ("taxon"), |
847 | 846 |
CONSTRAINT "fk_qualified_taxon_record1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
848 |
CONSTRAINT "fk_taxon_assertion_taxon_name1" FOREIGN KEY ("taxon") REFERENCES "taxon_name" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
849 |
CONSTRAINT "fk_taxon_assertion_taxon_string1" FOREIGN KEY ("string") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE
|
|
847 |
CONSTRAINT "fk_taxon_assertion_taxon_string1" FOREIGN KEY ("string") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
848 |
CONSTRAINT "fk_taxon_assertion_taxon_name1" FOREIGN KEY ("taxon") REFERENCES "taxon_name" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
850 | 849 |
); |
851 | 850 |
/*!40101 SET character_set_client = @saved_cs_client */; |
852 | 851 |
|
... | ... | |
873 | 872 |
KEY "fk_taxon_taxon1_idx" ("parent"), |
874 | 873 |
KEY "fk_taxon_concept_source1_idx" ("according_to"), |
875 | 874 |
KEY "fk_taxon_concept_taxon_concept1_idx" ("accepted_taxon_concept"), |
875 |
CONSTRAINT "fk_taxon_taxon1" FOREIGN KEY ("parent") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
|
876 | 876 |
CONSTRAINT "fk_taxon_concept_source1" FOREIGN KEY ("according_to") REFERENCES "source" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
877 | 877 |
CONSTRAINT "fk_taxon_concept_taxon_concept1" FOREIGN KEY ("accepted_taxon_concept") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
878 |
CONSTRAINT "fk_taxon_concept_taxon_name1" FOREIGN KEY ("id") REFERENCES "taxon_name" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
|
879 |
CONSTRAINT "fk_taxon_taxon1" FOREIGN KEY ("parent") REFERENCES "taxon_concept" ("id") ON DELETE CASCADE ON UPDATE CASCADE |
|
878 |
CONSTRAINT "fk_taxon_concept_taxon_name1" FOREIGN KEY ("id") REFERENCES "taxon_name" ("id") ON DELETE CASCADE ON UPDATE CASCADE |
|
880 | 879 |
); |
881 | 880 |
/*!40101 SET character_set_client = @saved_cs_client */; |
882 | 881 |
|
... | ... | |
902 | 901 |
UNIQUE KEY "taxon_determination_unique" ("taxon_assertion","identified_by"), |
903 | 902 |
KEY "fk_taxon_occurrence_has_qualified_taxon1_idx" ("taxon_assertion"), |
904 | 903 |
KEY "fk_taxon_determination_party1_idx" ("identified_by"), |
905 |
CONSTRAINT "fk_taxon_determination_party1" FOREIGN KEY ("identified_by") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
904 |
CONSTRAINT "fk_taxon_occurrence_has_qualified_taxon1" FOREIGN KEY ("taxon_assertion") REFERENCES "taxon_assertion" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
906 | 905 |
CONSTRAINT "fk_taxon_determination_record1" FOREIGN KEY ("id") REFERENCES "taxon_observation" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
907 |
CONSTRAINT "fk_taxon_occurrence_has_qualified_taxon1" FOREIGN KEY ("taxon_assertion") REFERENCES "taxon_assertion" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
906 |
CONSTRAINT "fk_taxon_determination_party1" FOREIGN KEY ("identified_by") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
908 | 907 |
); |
909 | 908 |
/*!40101 SET character_set_client = @saved_cs_client */; |
910 | 909 |
|
... | ... | |
931 | 930 |
"rank" varbinary(767) DEFAULT NULL, |
932 | 931 |
PRIMARY KEY ("id"), |
933 | 932 |
KEY "fk_taxon_concept_taxon_string10_idx" ("unique_name"), |
934 |
CONSTRAINT "fk_taxon_concept_taxon_string10" FOREIGN KEY ("unique_name") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
935 |
CONSTRAINT "fk_taxon_record10" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
933 |
CONSTRAINT "fk_taxon_record10" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
934 |
CONSTRAINT "fk_taxon_concept_taxon_string10" FOREIGN KEY ("unique_name") REFERENCES "taxon_string" ("string") ON DELETE CASCADE ON UPDATE CASCADE
|
|
936 | 935 |
); |
937 | 936 |
/*!40101 SET character_set_client = @saved_cs_client */; |
938 | 937 |
|
... | ... | |
963 | 962 |
KEY "fk_taxon_observation_specimen1_idx" ("voucher"), |
964 | 963 |
KEY "fk_taxon_observation_party1_idx" ("collector"), |
965 | 964 |
CONSTRAINT "fk_taxon_observation_event1" FOREIGN KEY ("id") REFERENCES "event" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
966 |
CONSTRAINT "fk_taxon_observation_party1" FOREIGN KEY ("collector") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
965 |
CONSTRAINT "fk_taxon_observation_taxon_occurrence2" FOREIGN KEY ("taxon_occurrence") REFERENCES "taxon_occurrence" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
967 | 966 |
CONSTRAINT "fk_taxon_observation_specimen1" FOREIGN KEY ("voucher") REFERENCES "specimen" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
968 |
CONSTRAINT "fk_taxon_observation_taxon_occurrence2" FOREIGN KEY ("taxon_occurrence") REFERENCES "taxon_occurrence" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
967 |
CONSTRAINT "fk_taxon_observation_party1" FOREIGN KEY ("collector") REFERENCES "party" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
969 | 968 |
); |
970 | 969 |
/*!40101 SET character_set_client = @saved_cs_client */; |
971 | 970 |
|
... | ... | |
989 | 988 |
PRIMARY KEY ("id"), |
990 | 989 |
KEY "fk_taxon_occurrence_taxon_determination1_idx" ("original_determination"), |
991 | 990 |
KEY "fk_taxon_occurrence_taxon_determination2_idx" ("current_determination"), |
992 |
CONSTRAINT "fk_taxon_occurrence_event1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
|
993 | 991 |
CONSTRAINT "fk_taxon_occurrence_taxon_determination1" FOREIGN KEY ("original_determination") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
994 |
CONSTRAINT "fk_taxon_occurrence_taxon_determination2" FOREIGN KEY ("current_determination") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE |
|
992 |
CONSTRAINT "fk_taxon_occurrence_taxon_determination2" FOREIGN KEY ("current_determination") REFERENCES "taxon_determination" ("id") ON DELETE CASCADE ON UPDATE CASCADE, |
|
993 |
CONSTRAINT "fk_taxon_occurrence_event1" FOREIGN KEY ("id") REFERENCES "record" ("id") ON DELETE CASCADE ON UPDATE CASCADE |
|
995 | 994 |
); |
996 | 995 |
/*!40101 SET character_set_client = @saved_cs_client */; |
997 | 996 |
|
... | ... | |
1086 | 1085 |
UNIQUE KEY "validatable_place_unique" ("path","coordinates"), |
1087 | 1086 |
KEY "fk_geovalidation_place_path1_idx" ("path"), |
1088 | 1087 |
KEY "fk_geovalidation_coordinates1_idx" ("coordinates"), |
1089 |
CONSTRAINT "fk_geovalidation_coordinates1" FOREIGN KEY ("coordinates") REFERENCES "coordinates" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
1090 |
CONSTRAINT "fk_geovalidation_place_path1" FOREIGN KEY ("path") REFERENCES "place_path" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
1088 |
CONSTRAINT "fk_geovalidation_place_path1" FOREIGN KEY ("path") REFERENCES "place_path" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
|
|
1089 |
CONSTRAINT "fk_geovalidation_coordinates1" FOREIGN KEY ("coordinates") REFERENCES "coordinates" ("id") ON DELETE CASCADE ON UPDATE CASCADE
|
|
1091 | 1090 |
); |
1092 | 1091 |
/*!40101 SET character_set_client = @saved_cs_client */; |
1093 | 1092 |
|
Also available in: Unified diff
schemas/VegCore/VegCore.my.sql: regenerated from .mwb schema, which apparently reverses the order of the fkeys (possibly a Linux MySQL bug?)