Revision 6117
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbank.~.clean_up.sql | ||
|---|---|---|
| 424 | 424 |
ALTER TABLE plot DROP COLUMN reallatitude; |
| 425 | 425 |
ALTER TABLE plot DROP COLUMN reallongitude; |
| 426 | 426 |
|
| 427 |
DELETE FROM plot WHERE plot_id IN ( |
|
| 428 |
SELECT plot_id FROM embargo WHERE embargostop > now() |
|
| 429 |
); |
|
| 430 |
|
|
| 427 | 431 |
-- Prevent "column name specified more than once" errors when tables are joined |
| 428 | 432 |
ALTER TABLE taxonobservation RENAME reference_id TO taxonobservation_reference_id; |
| 429 | 433 |
ALTER TABLE taxonobservation RENAME accessioncode TO taxonobservation_accessioncode; |
Also available in: Unified diff
inputs/VegBank/vegbank.~.clean_up.sql: Remove still-embargoed plots