Revision 14161
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 327 | 327 |
-- |
| 328 | 328 |
|
| 329 | 329 |
COMMENT ON TABLE taxon_match IS ' |
| 330 |
whenever columns are renamed: |
|
| 331 |
SELECT util.derived_cols_sync(''"TNRS".taxon_match'');
|
|
| 332 |
|
|
| 330 | 333 |
to remove columns or add columns at the end: |
| 331 | 334 |
$ rm=1 inputs/.TNRS/data.sql.run |
| 332 | 335 |
$ make schemas/remake |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 19439 | 19439 |
-- |
| 19440 | 19440 |
|
| 19441 | 19441 |
COMMENT ON TABLE taxon_match IS ' |
| 19442 |
whenever columns are renamed: |
|
| 19443 |
SELECT util.derived_cols_sync(''"TNRS".taxon_match'');
|
|
| 19444 |
|
|
| 19442 | 19445 |
to remove columns or add columns at the end: |
| 19443 | 19446 |
$ rm=1 inputs/.TNRS/data.sql.run |
| 19444 | 19447 |
$ make schemas/remake |
Also available in: Unified diff
inputs/.TNRS/schema.sql: taxon_match: documented that whenever columns are renamed, util.derived_cols_sync() should be run