add pkey to batch payments and fix a doc typo

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

diff --git a/README.1.4.0pre3-4 b/README.1.4.0pre3-4
index d2fcf7f..9814a65 100644 (file)
--- a/README.1.4.0pre3-4
+++ b/README.1.4.0pre3-4
@@ -2,5 +2,18 @@ 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 INDEX part_pop_local1 ON part_pop_local ( npa, nxx );
+
+ALTER TABLE cust_pay_batch ADD paybatchnum integer;
+CREATE UNIQUE INDEX cust_pay_batch_pkey ON cust_pay_batch ( paybatchnum );
+

 Run bin/dbdef-create
 
 Run bin/dbdef-create