Revision 6302
Added by Aaron Marcuse-Kubitza over 11 years ago
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 |
|
Also available in: Unified diff
schemas/vegbien.sql: source: Added matched_source_id