Monica Tepelus | 5 Dec 2011 09:37
Picon
Favicon

Re: Can somebody help me to configure my server

Фаррух Касымов wrote:
> I want to build Sip server for users on my network.
> Authorization, and contact list,  I want to make contact through the database MYSQL.
> Next, I want to set up voicemail and  notification via e-mail.
>
> I you give references to studies or examples of the configuration database through
>   
- we don't have a database schema because it depends the application. 
Below are the most important tables from register module. Even if you 
build a custom script the queries will be similar

CREATE TABLE cdr
(
 "time" timestamp without time zone,
 chan text,
 address text,
 direction text,
 billid text,
 caller text,
 "called" text,
 duration time without time zone,
 billtime time without time zone,
 ringtime time without time zone,
 status text,
 reason text,
 ended boolean
)

CREATE TABLE accounts
(
(Continue reading)


Gmane