diff options
author | ivan <ivan> | 2001-09-26 09:17:06 +0000 |
---|---|---|
committer | ivan <ivan> | 2001-09-26 09:17:06 +0000 |
commit | 8ca6f203e5dae208d7af581d68671fe47c5e1a1a (patch) | |
tree | 1b3abd74d3b2118a3ca059e4b2ad65632f98c5e4 /README.1.4.0pre3-4 | |
parent | fec5c7b3ffb749ad8658ea6f2366aa5c2be3d3fc (diff) |
add part_pop_local table
Diffstat (limited to 'README.1.4.0pre3-4')
-rw-r--r-- | README.1.4.0pre3-4 | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/README.1.4.0pre3-4 b/README.1.4.0pre3-4 index d2fcf7f91..0ac859137 100644 --- a/README.1.4.0pre3-4 +++ b/README.1.4.0pre3-4 @@ -2,5 +2,15 @@ the following is necessary to upgrade from 1.4.0pre3 to pre4 or later. install the perl modules and httemplate as per install.html or upgrade8.html +CREATE TABLE part_pop_local ( + localnum int primary key, + popnum int not null, + city varchar(80) null, + state char(2) null, + npa char(3) not null, + nxx char(3) not null +); +CREATE UNIQUE INDEX part_pop_local1 ON part_pop_local ( npa, nxx ); + Run bin/dbdef-create |