Revision 4525
Added by Aaron Marcuse-Kubitza over 12 years ago
| inputs/VegBank/vegbank.~.clean_up.sql | ||
|---|---|---|
| 63 | 63 |
DROP VIEW view_taxonobs_distinctid_curr CASCADE; |
| 64 | 64 |
DROP VIEW view_taxonobs_distinctid_curr_counts CASCADE; |
| 65 | 65 |
DROP VIEW view_taxonobs_distinctid_curr_counts_plants CASCADE; |
| 66 |
|
|
| 67 |
-- Prevent "column name specified more than once" errors when tables are joined |
|
| 68 |
ALTER TABLE taxonobservation RENAME accessioncode TO taxonobservation_accessioncode; |
|
| 69 |
ALTER TABLE taxoninterpretation RENAME plantname_id TO taxoninterpretation_plantname_id; |
|
| 70 |
ALTER TABLE taxoninterpretation RENAME accessioncode TO taxoninterpretation_accessioncode; |
|
| 71 |
ALTER TABLE plantconcept_ RENAME reference_id TO plantconcept__reference_id; |
|
| 72 |
ALTER TABLE plantconcept_ RENAME accessioncode TO plantconcept__accessioncode; |
|
Also available in: Unified diff
inputs/VegBank/vegbank.~.clean_up.sql: Prevent "column name specified more than once" errors when tables are joined