Register Database Schema

Revision as of 14:54, 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 )