Register Database Schema

From Yate Documentation
(Difference between revisions)
Jump to: navigation, search
(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 )

Personal tools
Namespaces

Variants
Actions
Preface
Configuration
Administrators
Developers