Revision 13577
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/inputs/.TNRS/schema.sql | ||
|---|---|---|
| 316 | 316 |
-- |
| 317 | 317 |
|
| 318 | 318 |
COMMENT ON TABLE tnrs IS ' |
| 319 |
IMPORTANT: when changing this table''s schema, you may need to re-run TNRS: |
|
| 320 |
$ inputs/.TNRS/data.sql.run refresh |
|
| 319 |
to remove columns or add columns at the end: |
|
| 320 |
$ rm=1 inputs/.TNRS/data.sql.run |
|
| 321 |
$ make schemas/remake |
|
| 322 |
|
|
| 323 |
to add columns in the middle: |
|
| 324 |
make the changes in inputs/.TNRS/schema.sql |
|
| 325 |
$ inputs/.TNRS/data.sql.run refresh # re-run TNRS |
|
| 326 |
$ make schemas/remake |
|
| 321 | 327 |
'; |
| 322 | 328 |
|
| 323 | 329 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 17153 | 17153 |
-- |
| 17154 | 17154 |
|
| 17155 | 17155 |
COMMENT ON TABLE tnrs IS ' |
| 17156 |
IMPORTANT: when changing this table''s schema, you may need to re-run TNRS: |
|
| 17157 |
$ inputs/.TNRS/data.sql.run refresh |
|
| 17156 |
to remove columns or add columns at the end: |
|
| 17157 |
$ rm=1 inputs/.TNRS/data.sql.run |
|
| 17158 |
$ make schemas/remake |
|
| 17159 |
|
|
| 17160 |
to add columns in the middle: |
|
| 17161 |
make the changes in inputs/.TNRS/schema.sql |
|
| 17162 |
$ inputs/.TNRS/data.sql.run refresh # re-run TNRS |
|
| 17163 |
$ make schemas/remake |
|
| 17158 | 17164 |
'; |
| 17159 | 17165 |
|
| 17160 | 17166 |
|
Also available in: Unified diff
inputs/.TNRS/schema.sql: tnrs: documented how to add and remove columns