Revision 11955
Added by Aaron Marcuse-Kubitza about 11 years ago
| vegbank.~.clean_up.sql | ||
|---|---|---|
| 434 | 434 |
ALTER TABLE commclass RENAME commcode TO commclass__commcode; |
| 435 | 435 |
ALTER TABLE commclass RENAME commname TO commclass__commname; |
| 436 | 436 |
ALTER TABLE commconcept RENAME commname TO commconcept__commname; |
| 437 |
ALTER TABLE taxonobservation RENAME reference_id TO taxonobservation_reference_id; |
|
| 438 |
ALTER TABLE taxonobservation RENAME accessioncode TO taxonobservation_accessioncode; |
|
| 439 |
ALTER TABLE taxoninterpretation RENAME plantname_id TO taxoninterpretation_plantname_id; |
|
| 440 |
ALTER TABLE taxoninterpretation RENAME accessioncode TO taxoninterpretation_accessioncode; |
|
| 441 | 437 |
ALTER TABLE party RENAME d_obscount TO party_d_obscount; |
| 442 | 438 |
ALTER TABLE plantconcept RENAME reference_id TO plantconcept_reference_id; |
| 443 | 439 |
ALTER TABLE plantconcept RENAME plantname TO plantconcept_plantname; |
| 444 | 440 |
ALTER TABLE plantconcept RENAME accessioncode TO plantconcept_accessioncode; |
| 445 | 441 |
ALTER TABLE plantname RENAME reference_id TO plantname_reference_id; |
| 442 |
ALTER TABLE taxoninterpretation RENAME plantname_id TO taxoninterpretation_plantname_id; |
|
| 443 |
ALTER TABLE taxoninterpretation RENAME accessioncode TO taxoninterpretation_accessioncode; |
|
| 444 |
ALTER TABLE taxonobservation RENAME reference_id TO taxonobservation_reference_id; |
|
| 445 |
ALTER TABLE taxonobservation RENAME accessioncode TO taxonobservation_accessioncode; |
|
| 446 | 446 |
|
| 447 | 447 |
-- indicate required columns |
| 448 | 448 |
--ALTER TABLE comminterpretation ALTER COLUMN commname SET NOT NULL; -- now NULL in 10 rows, where commconcept_id is also NULL |
Also available in: Unified diff
inputs/VegBank/vegbank.~.clean_up.sql, inputs/CVS/cvs.~.clean_up.sql: Prevent "column name specified more than once" errors when tables are joined: put tables in alphabetical order for consistency