Revision 11157
Added by Aaron Marcuse-Kubitza about 11 years ago
| vegbank.~.clean_up.sql | ||
|---|---|---|
| 431 | 431 |
-- This corresponds to location/public/full embargos (http://vegbank.org/vegbank/views/dba_tabledescription_detail.jsp?view=detail&wparam=plot&entity=dba_tabledescription&where=where_tablename#confidentialityStatus) |
| 432 | 432 |
|
| 433 | 433 |
-- Prevent "column name specified more than once" errors when tables are joined |
| 434 |
ALTER TABLE commconcept RENAME commname TO commconcept__commname; |
|
| 434 | 435 |
ALTER TABLE taxonobservation RENAME reference_id TO taxonobservation_reference_id; |
| 435 | 436 |
ALTER TABLE taxonobservation RENAME accessioncode TO taxonobservation_accessioncode; |
| 436 | 437 |
ALTER TABLE taxoninterpretation RENAME party_id TO taxoninterpretation_party_id; |
Also available in: Unified diff
inputs/VegBank/vegbank.~.clean_up.sql: commconcept.commname: rename to prevent collision with commname.commname