Revision 909
Added by Aaron Marcuse-Kubitza about 13 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1487 | 1487 |
CREATE TABLE plantconceptscope ( |
| 1488 | 1488 |
plantconceptscope_id int(11) NOT NULL, |
| 1489 | 1489 |
locationevent_id int(11), |
| 1490 |
project_id int(11) |
|
| 1490 |
project_id int(11), |
|
| 1491 |
namedplace_id int(11) |
|
| 1491 | 1492 |
); |
| 1492 | 1493 | |
| 1493 | 1494 | |
| ... | ... | |
| 4852 | 4853 | |
| 4853 | 4854 | |
| 4854 | 4855 |
-- |
| 4856 |
-- Name: fki_plantconceptscope_namedplace_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4857 |
-- |
|
| 4858 | ||
| 4859 |
CREATE INDEX fki_plantconceptscope_namedplace_id ON plantconceptscope (namedplace_id); |
|
| 4860 | ||
| 4861 | ||
| 4862 |
-- |
|
| 4855 | 4863 |
-- Name: fki_plantconceptscope_project_id; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4856 | 4864 |
-- |
| 4857 | 4865 | |
| ... | ... | |
| 6247 | 6255 | |
| 6248 | 6256 | |
| 6249 | 6257 |
-- |
| 6258 |
-- Name: plantconceptscope_namedplace_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6259 |
-- |
|
| 6260 | ||
| 6261 |
ALTER TABLE plantconceptscope |
|
| 6262 |
ADD CONSTRAINT plantconceptscope_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6263 | ||
| 6264 | ||
| 6265 |
-- |
|
| 6250 | 6266 |
-- Name: plantconceptscope_project_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6251 | 6267 |
-- |
| 6252 | 6268 | |
Also available in: Unified diff
vegbien.sql: Added plantconceptscope.namedplace_id