Revision 709
Added by Aaron Marcuse-Kubitza almost 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 927 | 927 |
accessioncode character varying(255), |
| 928 | 928 |
sublocationxposition double precision, |
| 929 | 929 |
sublocationyposition double precision, |
| 930 |
namedplace_id int(11), |
|
| 931 | 930 |
authore character varying(20), |
| 932 | 931 |
authorn character varying(20), |
| 933 | 932 |
authorzone character varying(20), |
| ... | ... | |
| 4722 | 4721 |
|
| 4723 | 4722 |
|
| 4724 | 4723 |
-- |
| 4725 |
-- Name: fki_location_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4726 |
-- |
|
| 4727 |
|
|
| 4728 |
CREATE INDEX fki_location_namedplace_id ON location (namedplace_id); |
|
| 4729 |
|
|
| 4730 |
|
|
| 4731 |
-- |
|
| 4732 | 4724 |
-- Name: fki_plantobservation_plant_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4733 | 4725 |
-- |
| 4734 | 4726 |
|
| ... | ... | |
| 5814 | 5806 |
|
| 5815 | 5807 |
|
| 5816 | 5808 |
-- |
| 5817 |
-- Name: location_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5818 |
-- |
|
| 5819 |
|
|
| 5820 |
ALTER TABLE location |
|
| 5821 |
ADD CONSTRAINT location_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5822 |
|
|
| 5823 |
|
|
| 5824 |
-- |
|
| 5825 | 5809 |
-- Name: location_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5826 | 5810 |
-- |
| 5827 | 5811 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1081 | 1081 |
accessioncode character varying(255), |
| 1082 | 1082 |
sublocationxposition double precision, |
| 1083 | 1083 |
sublocationyposition double precision, |
| 1084 |
namedplace_id integer, |
|
| 1085 | 1084 |
authore character varying(20), |
| 1086 | 1085 |
authorn character varying(20), |
| 1087 | 1086 |
authorzone character varying(20), |
| ... | ... | |
| 5161 | 5160 |
|
| 5162 | 5161 |
|
| 5163 | 5162 |
-- |
| 5164 |
-- Name: fki_location_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 5165 |
-- |
|
| 5166 |
|
|
| 5167 |
CREATE INDEX fki_location_namedplace_id ON location USING btree (namedplace_id); |
|
| 5168 |
|
|
| 5169 |
|
|
| 5170 |
-- |
|
| 5171 | 5163 |
-- Name: fki_plantobservation_plant_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 5172 | 5164 |
-- |
| 5173 | 5165 |
|
| ... | ... | |
| 6253 | 6245 |
|
| 6254 | 6246 |
|
| 6255 | 6247 |
-- |
| 6256 |
-- Name: location_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6257 |
-- |
|
| 6258 |
|
|
| 6259 |
ALTER TABLE ONLY location |
|
| 6260 |
ADD CONSTRAINT location_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6261 |
|
|
| 6262 |
|
|
| 6263 |
-- |
|
| 6264 | 6248 |
-- Name: location_parent_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6265 | 6249 |
-- |
| 6266 | 6250 |
|
Also available in: Unified diff
vegbien.sql: Removed direct pointer from location to namedplace because locationplace already has this relationship and we don't want to have an extra pointer just for duplicate elimination