Revision 14332
Added by Aaron Marcuse-Kubitza over 10 years ago
trunk/inputs/.TNRS/schema.sql | ||
---|---|---|
552 | 552 |
whenever columns are renamed: |
553 | 553 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''); |
554 | 554 |
|
555 |
to port derived column changes to vegbiendev: |
|
556 |
SELECT util.derived_cols_export(''"TNRS".taxon_match''); |
|
557 |
# run the returned SQL on vegbiendev |
|
558 |
|
|
555 | 559 |
to remove columns or add columns at the end: |
556 | 560 |
$ rm=1 inputs/.TNRS/data.sql.run |
557 | 561 |
$ make schemas/remake |
trunk/schemas/vegbien.sql | ||
---|---|---|
19656 | 19656 |
whenever columns are renamed: |
19657 | 19657 |
SELECT util.derived_cols_update(''"TNRS".taxon_match''); |
19658 | 19658 |
|
19659 |
to port derived column changes to vegbiendev: |
|
19660 |
SELECT util.derived_cols_export(''"TNRS".taxon_match''); |
|
19661 |
# run the returned SQL on vegbiendev |
|
19662 |
|
|
19659 | 19663 |
to remove columns or add columns at the end: |
19660 | 19664 |
$ rm=1 inputs/.TNRS/data.sql.run |
19661 | 19665 |
$ make schemas/remake |
Also available in: Unified diff
inputs/.TNRS/schema.sql: taxon_match: COMMENT: added steps to port derived column changes to vegbiendev