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
|