X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=README.1.4.0pre3-4;h=49ca5a4d03892b86892df709839ae8cf674ef3ac;hp=d2fcf7f91debfb1ee69c79f64b8ef96ec6efd87b;hb=fcb5658290eb457f0b2493b405c152a9cc1ad5a4;hpb=310a027b9b72cf7d98c7f3e05b3bd1164077f2ab

diff --git a/README.1.4.0pre3-4 b/README.1.4.0pre3-4
index d2fcf7f91..49ca5a4d0 100644
--- a/README.1.4.0pre3-4
+++ b/README.1.4.0pre3-4
@@ -2,5 +2,20 @@ 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 INDEX part_pop_local1 ON part_pop_local ( npa, nxx );
+ALTER TABLE cust_pkg ADD manual_flag char(1) NULL;
+ALTER TABLE cust_pay_batch ADD paybatchnum integer;
+CREATE UNIQUE INDEX cust_pay_batch_pkey ON cust_pay_batch ( paybatchnum );
+ALTER TABLE part_pkg ADD plan varchar NULL;
+ALTER TABLE part_pkg ADD plandata varchar NULL;
+
 Run bin/dbdef-create