0,0 → 1,69 |
create sequence cdr_acctid_seq; |
create table cdr ( |
acctid bigint not null default nextval('cdr_acctid_seq'), |
calldate timestamp with time zone not null default now(), |
clid varchar(80) not null default '', |
src varchar(80) not null default '', |
dst varchar(80) not null default '', |
dcontext varchar(80) not null default '', |
channel varchar(80) not null default '', |
dstchannel varchar(80) not null default '', |
lastapp varchar(80) not null default '', |
lastdata varchar(80) not null default '', |
duration integer not null default 0, |
billsec integer not null default 0, |
disposition varchar(45) not null default '', |
amaflags integer not null default 0, |
accountcode varchar(20) not null default '', |
uniqueid varchar(32) not null default '', |
userfield varchar(255) not null default '' |
); |
|
create sequence activecalls_acctid_seq; |
create table activecalls ( |
acctid bigint not null, |
calldate timestamp with time zone not null, |
linkdate timestamp with time zone, |
clid varchar(80), |
src varchar(80), |
dst varchar(80), |
dcontext varchar(80), |
channel varchar(80), |
dstchannel varchar(80), |
lastapp varchar(80), |
lastdata varchar(80), |
duration integer, |
billsec integer, |
disposition varchar(45), |
amaflags integer, |
accountcode varchar(20), |
uniqueid varchar(32), |
userfield varchar(255) |
); |
|
create table telbook_categories ( |
category_id serial primary key, |
category_name varchar(255) not null unique, |
category_export_key integer, |
category_comment text |
); |
|
create table telbook_persons ( |
person_id serial primary key, |
person_name varchar(255) not null unique, |
person_category integer, |
person_comment text, |
|
foreign key (person_category) references telbook_categories(category_id) |
); |
|
create table telbook_entries ( |
entry_id serial primary key, |
entry_value varchar(255) not null unique, |
entry_title varchar(255), |
entry_person integer not null, |
entry_comment text, |
|
foreign key (entry_person) references telbook_persons(person_id) |
); |
|