Revision 707
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.my.sql | ||
|---|---|---|
| 999 | 999 |
covermethod_id int(11), |
| 1000 | 1000 |
coverdispersion character varying(30), |
| 1001 | 1001 |
autotaxoncover int(1), |
| 1002 |
stratummethod_id int(11), |
|
| 1003 | 1002 |
methodnarrative text, |
| 1004 | 1003 |
taxonoccurrencearea double precision, |
| 1005 | 1004 |
stemsizelimit double precision, |
| ... | ... | |
| 4856 | 4855 |
|
| 4857 | 4856 |
|
| 4858 | 4857 |
-- |
| 4859 |
-- Name: locationevent_stratummethod_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4860 |
-- |
|
| 4861 |
|
|
| 4862 |
CREATE INDEX locationevent_stratummethod_id_x ON locationevent (stratummethod_id); |
|
| 4863 |
|
|
| 4864 |
|
|
| 4865 |
-- |
|
| 4866 | 4858 |
-- Name: locationeventcontributor_locationevent_id_x; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4867 | 4859 |
-- |
| 4868 | 4860 |
|
| ... | ... | |
| 5886 | 5878 |
|
| 5887 | 5879 |
|
| 5888 | 5880 |
-- |
| 5889 |
-- Name: locationevent_stratummethod_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5890 |
-- |
|
| 5891 |
|
|
| 5892 |
ALTER TABLE locationevent |
|
| 5893 |
ADD CONSTRAINT locationevent_stratummethod_id FOREIGN KEY (stratummethod_id) REFERENCES stratummethod(stratummethod_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5894 |
|
|
| 5895 |
|
|
| 5896 |
-- |
|
| 5897 | 5881 |
-- Name: locationeventcontributor_locationevent_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5898 | 5882 |
-- |
| 5899 | 5883 |
|
Also available in: Unified diff
vegbien.sql: Removed locationevent.stratummethod_id because the stratummethod is a per-stratum (or technically, per-stratumtype) field