summaryrefslogtreecommitdiff
path: root/README.1.4.0pre3-4
diff options
context:
space:
mode:
authorivan <ivan>2001-09-26 09:17:06 +0000
committerivan <ivan>2001-09-26 09:17:06 +0000
commit8ca6f203e5dae208d7af581d68671fe47c5e1a1a (patch)
tree1b3abd74d3b2118a3ca059e4b2ad65632f98c5e4 /README.1.4.0pre3-4
parentfec5c7b3ffb749ad8658ea6f2366aa5c2be3d3fc (diff)
add part_pop_local table
Diffstat (limited to 'README.1.4.0pre3-4')
-rw-r--r--README.1.4.0pre3-410
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