Apply the following changes to your database:
CREATE TABLE svc_forward (
svcnum int NOT NULL,
srcsvc int NOT NULL,
dstsvc int NOT NULL,
dst varchar(80),
PRIMARY KEY (svcnum)
);
CREATE TABLE cust_credit_bill (
creditbillnum int primary key,
crednum int not null,
invnum int not null,
_date int not null,
amount decimal(10,2) not null
);
CREATE TABLE cust_bill_pay (
billpaynum int primary key,
invnum int not null,
paynum int not null,
_date int not null,
amount decimal(10,2) not null
);
CREATE TABLE cust_credit_refund (
creditrefundnum int primary key,
crednum int not null,
refundnum int not null,
_date int not null,
amount decimal(10,2) not null
);
CREATE TABLE part_svc_column (
columnnum int primary key,
svcpart int not null,
columnname varchar(64) not null,
columnvalue varchar(80) null,
columnflag char(1) null
);
CREATE TABLE queue (
jobnum int primary key,
job text not null,
_date int not null,
status varchar(80) not null
);
CREATE TABLE queue_arg (
argnum int primary key,
jobnum int not null,
arg text null
);
CREATE INDEX queue_arg1 ON queue_arg ( jobnum );
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 UNIQUE INDEX part_pop_local1 ON part_pop_local ( npa, nxx );
CREATE TABLE cust_bill_event (
eventnum int primary key,
invnum int not null,
eventpart int not null,
_date int not null,
);
CREATE UNIQUE INDEX cust_bill_event1 ON cust_bill_event ( eventpart, invnum );
CREATE INDEX cust_bill_event2 ON cust_bill_event ( invnum );
CREATE TABLE part_bill_event (
eventpart int primary key,
payby char(4) not null,
event varchar(80) not null,
eventcode text null,
seconds int null,
disabled char(1) null,
);
CREATE INDEX part_bill_event1 ON part_bill_event ( payby );
CREATE TABLE part_export (
exportnum int primary key,
svcpart int not null,
machine varchar(80) not null,
exporttype varchar(80) not null,
nodomain char(1) NULL
);
CREATE INDEX part_export1 ON part_export ( machine );
CREATE INDEX part_export2 ON part_export ( exporttype );
CREATE INDEX part_export_option (
optionnum int primary key,
exportnum int not null,
option varchar(80) not null,
optionvalue text NULL
);
CREATE INDEX part_export_option1 ON part_export ( exportnum );
CREATE INDEX part_export_option2 ON part_export ( option );
ALTER TABLE svc_acct ADD domsvc integer NOT NULL;
ALTER TABLE svc_domain ADD catchall integer NULL;
ALTER TABLE cust_main ADD referral_custnum integer NULL;
ALTER TABLE cust_pay ADD custnum integer;
ALTER TABLE cust_pay_batch ADD paybatchnum integer;
ALTER TABLE cust_refund ADD custnum integer;
ALTER TABLE cust_pkg ADD manual_flag char(1) NULL;
ALTER TABLE part_pkg ADD plan varchar(80) NULL;
ALTER TABLE part_pkg ADD plandata text NULL;
ALTER TABLE part_pkg ADD setuptax char(1) NULL;
ALTER TABLE part_pkg ADD recurtax char(1) NULL;
ALTER TABLE part_pkg ADD disabled char(1) NULL;
ALTER TABLE part_svc ADD disabled char(1) NULL;
ALTER TABLE cust_bill ADD closed char(1) NULL;
ALTER TABLE cust_pay ADD closed char(1) NULL;
ALTER TABLE cust_credit ADD closed char(1) NULL;
ALTER TABLE cust_refund ADD closed char(1) NULL;
CREATE INDEX cust_main3 ON cust_main ( referral_custnum );
CREATE INDEX cust_credit_bill1 ON cust_credit_bill ( crednum );
CREATE INDEX cust_credit_bill2 ON cust_credit_bill ( invnum );
CREATE INDEX cust_bill_pay1 ON cust_bill_pay ( invnum );
CREATE INDEX cust_bill_pay2 ON cust_bill_pay ( paynum );
CREATE INDEX cust_credit_refund1 ON cust_credit_refund ( crednum );
CREATE INDEX cust_credit_refund2 ON cust_credit_refund ( refundnum );
CREATE UNIQUE INDEX cust_pay_batch_pkey ON cust_pay_batch ( paybatchnum );
CREATE UNIQUE INDEX part_svc_column1 ON part_svc_column ( svcpart, columnname );