Revision 1031
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1080 | 1080 |
sourceaccessioncode text, |
| 1081 | 1081 |
previous_id int(11), |
| 1082 | 1082 |
dateaccuracy text, |
| 1083 |
covermethod_id int(11), |
|
| 1084 | 1083 |
method_id int(11), |
| 1085 | 1084 |
methodnarrative text, |
| 1086 | 1085 |
taxonoccurrencearea double precision, |
| ... | ... | |
| 1271 | 1270 |
observationmeasure text, |
| 1272 | 1271 |
observationmeasureunits text, |
| 1273 | 1272 |
taxonclassincluded text, |
| 1274 |
taxonclassexcluded text |
|
| 1273 |
taxonclassexcluded text, |
|
| 1274 |
covermethod_id int(11) |
|
| 1275 | 1275 |
); |
| 1276 | 1276 |
|
| 1277 | 1277 |
|
| ... | ... | |
| 4876 | 4876 |
|
| 4877 | 4877 |
|
| 4878 | 4878 |
-- |
| 4879 |
-- Name: locationevent_covermethod_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4880 |
-- |
|
| 4881 |
|
|
| 4882 |
CREATE INDEX locationevent_covermethod_id_x ON locationevent (covermethod_id); |
|
| 4883 |
|
|
| 4884 |
|
|
| 4885 |
-- |
|
| 4886 | 4879 |
-- Name: locationevent_keys_accessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4887 | 4880 |
-- |
| 4888 | 4881 |
|
| ... | ... | |
| 5920 | 5913 |
|
| 5921 | 5914 |
|
| 5922 | 5915 |
-- |
| 5923 |
-- Name: locationevent_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5924 |
-- |
|
| 5925 |
|
|
| 5926 |
ALTER TABLE locationevent |
|
| 5927 |
ADD CONSTRAINT locationevent_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5928 |
|
|
| 5929 |
|
|
| 5930 |
-- |
|
| 5931 | 5916 |
-- Name: locationevent_location_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5932 | 5917 |
-- |
| 5933 | 5918 |
|
| ... | ... | |
| 6030 | 6015 |
|
| 6031 | 6016 |
|
| 6032 | 6017 |
-- |
| 6018 |
-- Name: method_covermethod_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6019 |
-- |
|
| 6020 |
|
|
| 6021 |
ALTER TABLE method |
|
| 6022 |
ADD CONSTRAINT method_covermethod_id FOREIGN KEY (covermethod_id) REFERENCES covermethod(covermethod_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6023 |
|
|
| 6024 |
|
|
| 6025 |
-- |
|
| 6033 | 6026 |
-- Name: method_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6034 | 6027 |
-- |
| 6035 | 6028 |
|
Also available in: Unified diff
vegbien.sql: Point to covermethod from method instead of locationevent