Apply the following changes to your database:
ALTER TABLE svc_acct_pop ADD loc CHAR(4);
CREATE TABLE prepay_credit (
prepaynum int NOT NULL,
identifier varchar(80) NOT NULL,
amount decimal(10,2) NOT NULL,
PRIMARY KEY (prepaynum),
INDEX (identifier)
);
CREATE TABLE domain_record (
recnum int NOT NULL,
svcnum int NOT NULL,
reczone varchar(80) NOT NULL,
recaf char(2) NOT NULL,
rectype char(5) NOT NULL,
recdata varchar(80) NOT NULL,
PRIMARY KEY (recnum)
);
CREATE TABLE svc_www (
svcnum int NOT NULL,
recnum int NOT NULL,
usersvc int NOT NULL,
PRIMARY KEY (svcnum)
);
ALTER TABLE part_svc ADD svc_www__svcnum varchar(80) NULL;
ALTER TABLE part_svc ADD svc_www__svcnum_flag char(1) NULL;
ALTER TABLE part_svc ADD svc_www__recnum varchar(80) NULL;
ALTER TABLE part_svc ADD svc_www__recnum_flag char(1) NULL;
ALTER TABLE part_svc ADD svc_www__usersvc varchar(80) NULL;
ALTER TABLE part_svc ADD svc_www__uesrsvc_flag char(1) NULL;