Revision 13538
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.sql | ||
|---|---|---|
| 2826 | 2826 |
GRANT SELECT ON TABLE analytical_stem TO bien_read; |
| 2827 | 2827 |
GRANT SELECT ON TABLE analytical_stem_view TO bien_read; |
| 2828 | 2828 |
|
| 2829 |
ALTER TABLE analytical_stem ADD FOREIGN KEY (datasource) REFERENCES source (shortname) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 2830 |
|
|
| 2831 | 2829 |
ALTER TABLE analytical_stem ALTER COLUMN "datasource" SET NOT NULL; |
| 2832 | 2830 |
ALTER TABLE analytical_stem ALTER COLUMN "locationID" SET NOT NULL; |
| 2833 | 2831 |
|
Also available in: Unified diff
fix: schemas/public_.sql: sync_analytical_stem_to_view(): removed fkey to source.shortname because this prevents reloading individual datasources