added slipip insertion for icradius and vpopmail restart config

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

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