Revision 14365
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 586 | 586 |
SELECT util.recreate_view(''"TNRS".taxon_best_match'');
|
| 587 | 587 |
$ make schemas/remake |
| 588 | 588 |
|
| 589 |
to move a column to the middle: |
|
| 589 |
to remove a column: |
|
| 590 |
SELECT util.recreate_view(''"TNRS".taxon_best_match'');
|
|
| 591 |
$ make schemas/remake |
|
| 592 |
|
|
| 593 |
to move a derived column to the middle or to add a non-derived column: |
|
| 590 | 594 |
make the changes in inputs/.TNRS/schema.sql |
| 591 | 595 |
$ inputs/.TNRS/data.sql.run refresh # re-run TNRS |
| 592 | 596 |
SELECT util.derived_cols_update(''"TNRS".taxon_match'');
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 20247 | 20247 |
SELECT util.recreate_view(''"TNRS".taxon_best_match'');
|
| 20248 | 20248 |
$ make schemas/remake |
| 20249 | 20249 |
|
| 20250 |
to move a column to the middle: |
|
| 20250 |
to remove a column: |
|
| 20251 |
SELECT util.recreate_view(''"TNRS".taxon_best_match'');
|
|
| 20252 |
$ make schemas/remake |
|
| 20253 |
|
|
| 20254 |
to move a derived column to the middle or to add a non-derived column: |
|
| 20251 | 20255 |
make the changes in inputs/.TNRS/schema.sql |
| 20252 | 20256 |
$ inputs/.TNRS/data.sql.run refresh # re-run TNRS |
| 20253 | 20257 |
SELECT util.derived_cols_update(''"TNRS".taxon_match'');
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: added steps to remove a column and to add a non-derived column