X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=README.1.4.0pre3-4;h=0027d345027b96494f45061c615e2ca686060b4c;hb=20c1183d2673b62bd0e29eb65f0a9a2c974b8027;hp=d2fcf7f91debfb1ee69c79f64b8ef96ec6efd87b;hpb=310a027b9b72cf7d98c7f3e05b3bd1164077f2ab;p=freeside.git diff --git a/README.1.4.0pre3-4 b/README.1.4.0pre3-4 index d2fcf7f91..0027d3450 100644 --- a/README.1.4.0pre3-4 +++ b/README.1.4.0pre3-4 @@ -2,5 +2,22 @@ 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; +ALTER TABLE part_pkg ADD setuptax char(1) NULL; +ALTER TABLE part_pkg ADD recurtax char(1) NULL; + Run bin/dbdef-create