Revision 10072
Added by Aaron Marcuse-Kubitza about 11 years ago
| inputs/FIA/REF_SPECIES/import | ||
|---|---|---|
| 9 | 9 |
('*SPCD', 'integer')
|
| 10 | 10 |
]::col_cast[]); |
| 11 | 11 |
|
| 12 |
SELECT mk_const_col(('"REF_SPECIES"', 'PLANT_SYMBOL_TYPE'), 'Species'::text);
|
|
| 12 |
SELECT mk_const_col(('"REF_SPECIES"', '*PLANT_SYMBOL_TYPE'), 'Species'::text);
|
|
| 13 | 13 |
|
| 14 | 14 |
SELECT create_if_not_exists($$ALTER TABLE "REF_SPECIES" ADD CONSTRAINT "REF_SPECIES.unique" UNIQUE ("*SPCD")$$);
|
| 15 | 15 |
EOF |
Also available in: Unified diff
bugfix: inputs/FIA/REF_SPECIES/import: PLANT_SYMBOL_TYPE: prepended * since it's a datasource column, and needs to match up with *PLANT_SYMBOL_TYPE in other table for joins