X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=README.1.4.0pre3-4;h=0ac859137f867179550c8711751f6618e94dcb80;hp=d2fcf7f91debfb1ee69c79f64b8ef96ec6efd87b;hb=8ca6f203e5dae208d7af581d68671fe47c5e1a1a;hpb=fec5c7b3ffb749ad8658ea6f2366aa5c2be3d3fc 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