| 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) |
| ); |
| |