Revision 7060
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 6322 | 6322 |
|
| 6323 | 6323 |
|
| 6324 | 6324 |
-- |
| 6325 |
-- Name: analytical_aggregate_datasource_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6326 |
-- |
|
| 6327 |
|
|
| 6328 |
|
|
| 6329 |
|
|
| 6330 |
|
|
| 6331 |
-- |
|
| 6332 |
-- Name: analytical_stem_datasource_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6333 |
-- |
|
| 6334 |
|
|
| 6335 |
|
|
| 6336 |
|
|
| 6337 |
|
|
| 6338 |
-- |
|
| 6325 | 6339 |
-- Name: classcontributor_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6326 | 6340 |
-- |
| 6327 | 6341 |
|
| schemas/filter_ERD.csv | ||
|---|---|---|
| 8 | 8 |
"^ALTER TABLE (?!method)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES method\b[^;]*;",,inward |
| 9 | 9 |
"^ALTER TABLE \b[^;]*\bFOREIGN KEY\b[^;]*\(submethod_id\) REFERENCES method\b[^;]*;",,inward |
| 10 | 10 |
"^ALTER TABLE (?!party|address|sourcecontributor|telephone)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES party\b[^;]*;",,inward |
| 11 |
"^ALTER TABLE (?!sourcecontributor)\b[^;]*\bFOREIGN KEY\b[^;]*\((?:source_id|commauthority_id|concept_reference_id|reference_id)\) REFERENCES source\b[^;]*;",,inward |
|
| 11 |
"^ALTER TABLE (?!sourcecontributor)\b[^;]*\bFOREIGN KEY\b[^;]*\((?:source_id|commauthority_id|concept_reference_id|datasource|reference_id)\) REFERENCES source\b[^;]*;",,inward
|
|
| 12 | 12 |
"^ALTER TABLE (?!sourcename)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES sourcelist\b[^;]*;",,inward |
| 13 | 13 |
"^ALTER TABLE (?:projectcontributor)\b[^;]*\bFOREIGN KEY\b[^;]*\((?:project_id)\) REFERENCES \b[^;]*;",,inward |
| 14 | 14 |
"^ALTER TABLE (?:partymember)\b[^;]*\bFOREIGN KEY\b[^;]*\((?:parentparty_id)\) REFERENCES \b[^;]*;",,inward |
| schemas/vegbien.sql | ||
|---|---|---|
| 929 | 929 |
GRANT SELECT ON TABLE analytical_aggregate TO bien_read; |
| 930 | 930 |
GRANT SELECT ON TABLE analytical_aggregate_view TO bien_read; |
| 931 | 931 |
|
| 932 |
ALTER TABLE analytical_aggregate ADD FOREIGN KEY (datasource) REFERENCES source (shortname) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 933 |
|
|
| 932 | 934 |
ALTER TABLE analytical_aggregate ALTER COLUMN "datasource" SET NOT NULL; |
| 933 | 935 |
ALTER TABLE analytical_aggregate ALTER COLUMN "locationID" SET NOT NULL; |
| 934 | 936 |
|
| ... | ... | |
| 949 | 951 |
GRANT SELECT ON TABLE analytical_stem TO bien_read; |
| 950 | 952 |
GRANT SELECT ON TABLE analytical_stem_view TO bien_read; |
| 951 | 953 |
|
| 954 |
ALTER TABLE analytical_stem ADD FOREIGN KEY (datasource) REFERENCES source (shortname) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 955 |
|
|
| 952 | 956 |
ALTER TABLE analytical_stem ALTER COLUMN "datasource" SET NOT NULL; |
| 953 | 957 |
ALTER TABLE analytical_stem ALTER COLUMN "locationID" SET NOT NULL; |
| 954 | 958 |
|
| ... | ... | |
| 7439 | 7443 |
|
| 7440 | 7444 |
|
| 7441 | 7445 |
-- |
| 7446 |
-- Name: analytical_aggregate_datasource_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 7447 |
-- |
|
| 7448 |
|
|
| 7449 |
ALTER TABLE ONLY analytical_aggregate |
|
| 7450 |
ADD CONSTRAINT analytical_aggregate_datasource_fkey FOREIGN KEY (datasource) REFERENCES source(shortname) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 7451 |
|
|
| 7452 |
|
|
| 7453 |
-- |
|
| 7454 |
-- Name: analytical_stem_datasource_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 7455 |
-- |
|
| 7456 |
|
|
| 7457 |
ALTER TABLE ONLY analytical_stem |
|
| 7458 |
ADD CONSTRAINT analytical_stem_datasource_fkey FOREIGN KEY (datasource) REFERENCES source(shortname) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 7459 |
|
|
| 7460 |
|
|
| 7461 |
-- |
|
| 7442 | 7462 |
-- Name: classcontributor_commclass_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 7443 | 7463 |
-- |
| 7444 | 7464 |
|
Also available in: Unified diff
schemas/vegbien.sql: sync_analytical_*_to_view(): Added datasource fkey to source.shortname so removing a datasource will also remove the corresponding rows in the analytical views