blob: 0027d345027b96494f45061c615e2ca686060b4c (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
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
|
