Revision 6163
Added by Aaron Marcuse-Kubitza about 12 years ago
| inputs/SALVIAS/salvias_plots.~.clean_up.sql | ||
|---|---|---|
| 11 | 11 |
|
| 12 | 12 |
CREATE INDEX ON stems ("PlotObsID");
|
| 13 | 13 |
ALTER TABLE stems ADD FOREIGN KEY ("PlotObsID") REFERENCES "plotObservations"("PlotObsID") ON UPDATE CASCADE ON DELETE CASCADE;
|
| 14 |
|
|
| 15 |
-- Remove private data that should not be publicly visible |
|
| 16 |
DELETE FROM "plotMetadata" WHERE "AccessCode" = 1; |
|
Also available in: Unified diff
inputs/SALVIAS/salvias_plots.~.clean_up.sql: Remove private data that should not be publicly visible, indicated by plotMetadata.AccessCode = 1