Register Database Schema
From Yate Documentation
(Difference between revisions)
| Line 16: | Line 16: | ||
) | ) | ||
| − | CREATE TABLE accounts | + | CREATE TABLE accounts |
| − | ( | + | ( |
| − | enabled boolean, | + | enabled boolean, |
| − | protocol text, | + | protocol text, |
| − | username text, | + | username text, |
| − | description text, | + | description text, |
| − | "interval" text, | + | "interval" text, |
| − | formats text, | + | formats text, |
| − | authname text, | + | authname text, |
| − | "password" text, | + | "password" text, |
| − | "number" text, | + | "number" text, |
| − | server text, | + | server text, |
| − | gatekeeper text, | + | gatekeeper text, |
| − | "domain" text, | + | "domain" text, |
| − | registrar text, | + | registrar text, |
| − | outbound text, | + | outbound text, |
| − | localaddress text, | + | localaddress text, |
| − | modified boolean, | + | modified boolean, |
| − | account text, | + | account text, |
| − | id serial NOT NULL, | + | id serial NOT NULL, |
| − | status text | + | status text |
| − | ) | + | ) |
| − | CREATE TABLE users | + | CREATE TABLE users |
| − | ( | + | ( |
| − | "password" text, | + | "password" text, |
| − | first_name text, | + | first_name text, |
| − | last_name text, | + | last_name text, |
| − | address text, | + | address text, |
| − | inuse integer, | + | inuse integer, |
| − | "location" text, | + | "location" text, |
| − | expires timestamp without time zone, | + | expires timestamp without time zone, |
| − | username text | + | username text |
| − | ) | + | ) |
Revision as of 14:56, 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 )
