Revision 9990
Added by Aaron Marcuse-Kubitza over 11 years ago
| inputs/.TNRS/schema.sql | ||
|---|---|---|
| 24 | 24 |
|
| 25 | 25 |
/* IMPORTANT: when changing this table's schema, you must regenerate data.sql: |
| 26 | 26 |
$ <this_file>/../test_taxonomic_names/test_scrub |
| 27 |
you must also make the same changes on vegbiendev: e.g. |
|
| 28 |
SELECT util.set_col_types('"TNRS".tnrs', ARRAY[
|
|
| 29 |
('col', 'new_type')
|
|
| 30 |
]::util.col_cast[]); |
|
| 31 |
runtime: 4 min ("242100 ms")
|
|
| 27 | 32 |
*/ |
| 28 | 33 |
CREATE TABLE tnrs |
| 29 | 34 |
( |
Also available in: Unified diff
inputs/.TNRS/schema.sql: tnrs: documented that when changing this table's schema, you must also make the same changes on vegbiendev. included sample util.set_col_types() call with runtime (4 min).