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