Register Database Schema
From Yate Documentation
(Difference between revisions)
(Created page with "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, billt...") |
|||
| Line 1: | Line 1: | ||
| − | CREATE TABLE cdr | + | CREATE TABLE cdr |
| − | ( | + | ( |
| − | "time" timestamp without time zone, | + | "time" timestamp without time zone, |
| − | chan text, | + | chan text, |
| − | address text, | + | address text, |
| − | direction text, | + | direction text, |
| − | billid text, | + | billid text, |
| − | caller text, | + | caller text, |
| − | "called" text, | + | "called" text, |
| − | duration time without time zone, | + | duration time without time zone, |
| − | billtime time without time zone, | + | billtime time without time zone, |
| − | ringtime time without time zone, | + | ringtime time without time zone, |
| − | status text, | + | status text, |
| − | reason text, | + | reason text, |
| − | ended boolean | + | ended boolean |
| − | ) | + | ) |
CREATE TABLE accounts | CREATE TABLE accounts | ||
Revision as of 14:55, 3 October 2012
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 ( enabled boolean, protocol text, username text, description text, "interval" text, formats text, authname text, "password" text, "number" text, server text, gatekeeper text, "domain" text, registrar text, outbound text, localaddress text, modified boolean, account text, id serial NOT NULL, status text )
CREATE TABLE users ( "password" text, first_name text, last_name text, address text, inuse integer, "location" text, expires timestamp without time zone, username text )
