Revision 14368
Added by Aaron Marcuse-Kubitza over 10 years ago
| schema.sql | ||
|---|---|---|
| 596 | 596 |
|
| 597 | 597 |
to move a derived column to the middle or to add a non-derived column: |
| 598 | 598 |
make the changes in inputs/.TNRS/schema.sql |
| 599 |
$ inputs/.TNRS/data.sql.run refresh # re-run TNRS |
|
| 599 |
$ inputs/.TNRS/data.sql.run refresh # re-run TNRS; runtime: 1 min ("1m2.629s")
|
|
| 600 | 600 |
SELECT util.derived_cols_update(''"TNRS".taxon_match'');
|
| 601 | 601 |
SELECT util.derived_cols_repopulate(''"TNRS".taxon_match'');
|
| 602 | 602 |
SELECT util.recreate_view(''"TNRS".taxon_best_match'');
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: taxon_match: `inputs/.TNRS/data.sql.run refresh`: documented runtime (1 min)