Revision 6302
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 1191 | 1191 |
|
| 1192 | 1192 |
CREATE TABLE source ( |
| 1193 | 1193 |
source_id int(11) NOT NULL, |
| 1194 |
matched_source_id int(11), |
|
| 1194 | 1195 |
parent_id int(11), |
| 1195 | 1196 |
shortname text, |
| 1196 | 1197 |
`fulltext` text, |
| ... | ... | |
| 5982 | 5983 |
|
| 5983 | 5984 |
|
| 5984 | 5985 |
-- |
| 5986 |
-- Name: source_matched_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5987 |
-- |
|
| 5988 |
|
|
| 5989 |
ALTER TABLE source |
|
| 5990 |
ADD CONSTRAINT source_matched_source_id_fkey FOREIGN KEY (matched_source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 5991 |
|
|
| 5992 |
|
|
| 5993 |
-- |
|
| 5985 | 5994 |
-- Name: source_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5986 | 5995 |
-- |
| 5987 | 5996 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1888 | 1888 |
|
| 1889 | 1889 |
CREATE TABLE source ( |
| 1890 | 1890 |
source_id integer NOT NULL, |
| 1891 |
matched_source_id integer, |
|
| 1891 | 1892 |
parent_id integer, |
| 1892 | 1893 |
shortname text, |
| 1893 | 1894 |
fulltext text, |
| ... | ... | |
| 7015 | 7016 |
|
| 7016 | 7017 |
|
| 7017 | 7018 |
-- |
| 7019 |
-- Name: source_matched_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 7020 |
-- |
|
| 7021 |
|
|
| 7022 |
ALTER TABLE ONLY source |
|
| 7023 |
ADD CONSTRAINT source_matched_source_id_fkey FOREIGN KEY (matched_source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 7024 |
|
|
| 7025 |
|
|
| 7026 |
-- |
|
| 7018 | 7027 |
-- Name: source_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 7019 | 7028 |
-- |
| 7020 | 7029 |
|
Also available in: Unified diff
schemas/vegbien.sql: source: Added matched_source_id