add part_pop_local table

[freeside.git] / README.1.4.0pre3-4

diff --git a/README.1.4.0pre3-4 b/README.1.4.0pre3-4
index d2fcf7f..0ac8591 100644 (file)
--- 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
 
 
 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
 
 Run bin/dbdef-create