Issues with creating tables when trying to install lcr and billing

Status
Not open for further replies.

gin92

New Member
Apr 12, 2018
16
0
1
31
I am trying to install OKAY LCR and Billing in my fusionpbx. But I am having trouble creating proper tables. The fusionpbx does not seem to create the proper table names and fileds on its own. Can anyone please help if they know the correct table structure or share their own table here if possible? Or is there any setting I am missing that created this issue?

As you can see below fusionpbx created tables with names with only v without proper correct name and fields-


Table-

CREATE TABLE v (
lcr_uuid uuid PRIMARY KEY,
carrier_uuid uuid,
digits text,
rate numeric,
intrastate_rate numeric,
intralata_rate numeric,
lead_strip numeric,
trail_strip numeric,
prefix text,
suffix text,
lcr_profile text,
date_start timestamp,
date_end timestamp,
quality numeric,
reliability numeric,
cid text,
enabled text,
description text,
connect_increment integer,
talk_increment integer,
lcr_direction text,
currency text,
connect_rate numeric);

CREATE TABLE v (
lcr_uuid uuid PRIMARY KEY,
carrier_uuid uuid,
digits text,
rate numeric,
intrastate_rate numeric,
intralata_rate numeric,
lead_strip numeric,
trail_strip numeric,
prefix text,
suffix text,
lcr_profile text,
date_start timestamp,
date_end timestamp,
quality numeric,
reliability numeric,
cid text,
enabled text,
description text,
connect_increment integer,
talk_increment integer,
lcr_direction text,
currency text,
connect_rate numeric);

CREATE TABLE v (
lcr_uuid uuid PRIMARY KEY,
carrier_uuid uuid,
digits text,
rate numeric,
intrastate_rate numeric,
intralata_rate numeric,
lead_strip numeric,
trail_strip numeric,
prefix text,
suffix text,
lcr_profile text,
date_start timestamp,
date_end timestamp,
quality numeric,
reliability numeric,
cid text,
enabled text,
description text,
connect_increment integer,
talk_increment integer,
lcr_direction text,
currency text,
connect_rate numeric);
 
Status
Not open for further replies.