Revision 8208
Added by Aaron Marcuse-Kubitza over 11 years ago
| import | ||
|---|---|---|
| 17 | 17 |
SELECT create_if_not_exists($$ALTER TABLE "SUBPLOT" ADD CONSTRAINT "SUBPLOT.ID" UNIQUE ("subplotID")$$);
|
| 18 | 18 |
SELECT create_if_not_exists($$ALTER TABLE "SUBPLOT" ADD CONSTRAINT "SUBPLOT.unique" UNIQUE ("STATECD", "UNITCD", "COUNTYCD", "locationName", "INVYR", "subplot")$$);
|
| 19 | 19 |
SELECT cluster_once('"SUBPLOT"', '"SUBPLOT.unique"');
|
| 20 |
EOF |
|
| 21 |
mk_derived |
|
Also available in: Unified diff
inputs/FIA/*/import: Run mk_derived after postprocessing commands