#!/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")$$);