Register Database Schema

From Yate Documentation
Revision as of 14:54, 3 October 2012 by Dana (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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