Project

General

Profile

1 8163 aaronmk
#!/bin/bash
2
# :mode=transact-sql:
3
cd "$(dirname "$0")"
4
. ../../../lib/import.sh
5
6 8164 aaronmk
map_table
7 8163 aaronmk
psql <<'EOF'
8 8136 aaronmk
SELECT functions.set_col_types('"COUNTY"', ARRAY[
9 8124 aaronmk
  ('.STATECD' , 'integer')
10
, ('.UNITCD'  , 'integer')
11
, ('.COUNTYCD', 'integer')
12
]::functions.col_cast[]);
13
14 8166 aaronmk
SELECT functions.create_if_not_exists($$ALTER TABLE "COUNTY" ADD CONSTRAINT "COUNTY.ID"     UNIQUE ("COUNTY.CN")                    $$);
15
SELECT functions.create_if_not_exists($$ALTER TABLE "COUNTY" ADD CONSTRAINT "COUNTY.unique" UNIQUE ("STATECD", "UNITCD", "COUNTYCD")$$);