Revision 14361
Added by Aaron Marcuse-Kubitza almost 10 years ago
| schema.sql | ||
|---|---|---|
| 575 | 575 |
to port derived column changes to vegbiendev: |
| 576 | 576 |
SELECT util.derived_cols_export(''"TNRS".taxon_match'');
|
| 577 | 577 |
# run the returned SQL on vegbiendev |
| 578 |
SELECT util.recreate_view(''"TNRS".taxon_best_match'');
|
|
| 578 | 579 |
|
| 579 | 580 |
to remove columns or add columns at the end: |
| 581 |
SELECT util.recreate_view(''"TNRS".taxon_best_match'');
|
|
| 580 | 582 |
$ make schemas/remake |
| 581 | 583 |
|
| 582 | 584 |
to add columns in the middle: |
| ... | ... | |
| 584 | 586 |
$ inputs/.TNRS/data.sql.run refresh # re-run TNRS |
| 585 | 587 |
SELECT util.derived_cols_update(''"TNRS".taxon_match'');
|
| 586 | 588 |
SELECT util.derived_cols_repopulate(''"TNRS".taxon_match'');
|
| 589 |
SELECT util.recreate_view(''"TNRS".taxon_best_match'');
|
|
| 587 | 590 |
$ make schemas/remake |
| 588 | 591 |
|
| 589 | 592 |
to populate a new column: |
Also available in: Unified diff
fix: inputs/.TNRS/schema.sql: taxon_match: to remove columns or add columns: also need to run util.recreate_view()