Revision 6761
Added by Aaron Marcuse-Kubitza almost 12 years ago
| cvs.~.clean_up.sql | ||
|---|---|---|
| 13 | 13 |
ALTER TABLE "stemCount" RENAME "dba_src_ID" TO "stemCount_dba_src_ID"; |
| 14 | 14 |
ALTER TABLE "stemCount" RENAME "entry_herbLineID" TO "stemCount_entry_herbLineID"; |
| 15 | 15 |
ALTER TABLE "stemCount" RENAME "entry_treeLineID" TO "stemCount_entry_treeLineID"; |
| 16 |
ALTER TABLE "stemCount" RENAME "entry_sortOrder" TO "stemCount_entry_sortOrder"; |
|
| 17 |
ALTER TABLE "stemLocation" RENAME "entry_sortOrder" TO "stemLocation_entry_sortOrder"; |
|
| 16 | 18 |
ALTER TABLE "taxonInterpretation" RENAME "PARTY_ID" TO "taxonInterpretation_PARTY_ID"; |
| 17 | 19 |
ALTER TABLE "taxonInterpretation" RENAME "PLANTNAME_ID" TO "taxonInterpretation_PLANTNAME_ID"; |
| 18 | 20 |
ALTER TABLE "taxonInterpretation" RENAME "dba_src_ID" TO "taxonInterpretation_dba_src_ID"; |
Also available in: Unified diff
inputs/CVS/: Joined together stemCount and stemLocation tables to create stemLocation_, in order to include the stem size class's measurements in each tagged stem's stemobservation (in addition to in the stemobservation for the aggregateoccurrence as a whole)