Revision 14317
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 519 | 519 |
make the changes in inputs/.TNRS/schema.sql |
| 520 | 520 |
$ inputs/.TNRS/data.sql.run refresh # re-run TNRS |
| 521 | 521 |
SELECT util.derived_cols_update(''"TNRS".taxon_match'');
|
| 522 |
SELECT util.derived_cols_repopulate(''"TNRS".taxon_match'');
|
|
| 522 | 523 |
$ make schemas/remake |
| 523 | 524 |
|
| 524 | 525 |
to populate a new column: |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 19623 | 19623 |
make the changes in inputs/.TNRS/schema.sql |
| 19624 | 19624 |
$ inputs/.TNRS/data.sql.run refresh # re-run TNRS |
| 19625 | 19625 |
SELECT util.derived_cols_update(''"TNRS".taxon_match'');
|
| 19626 |
SELECT util.derived_cols_repopulate(''"TNRS".taxon_match'');
|
|
| 19626 | 19627 |
$ make schemas/remake |
| 19627 | 19628 |
|
| 19628 | 19629 |
to populate a new column: |
Also available in: Unified diff
bugfix: inputs/.TNRS/schema.sql: taxon_match: to add columns in the middle: also need to run util.derived_cols_repopulate() since the dependency order has changed