#!/bin/bash

# :mode=transact-sql:

cd "$(dirname "$0")"

. ../../../lib/import.sh

map_table

psql <<'EOF'

SELECT set_col_types('"COUNTY"', ARRAY[

  ('*STATECD', 'integer')

, ('*UNITCD', 'integer')

, ('*COUNTYCD', 'integer')

]::col_cast[]);

SELECT create_if_not_exists($$ALTER TABLE "COUNTY" ADD CONSTRAINT "COUNTY.ID"     UNIQUE ("*COUNTY-CN")$$);

SELECT create_if_not_exists($$ALTER TABLE "COUNTY" ADD CONSTRAINT "COUNTY.unique" UNIQUE ("*STATECD", "*UNITCD", "*COUNTYCD")$$);

EOF

mk_derived