summaryrefslogtreecommitdiff
path: root/README.1.4.0pre3-4
blob: 9814a658a159d28ddda60df39c2b87dbd17d1cc1 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
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_pay_batch ADD paybatchnum integer;
CREATE UNIQUE INDEX cust_pay_batch_pkey ON cust_pay_batch ( paybatchnum );

Run bin/dbdef-create