aboutsummaryrefslogtreecommitdiffstats
path: root/doc
diff options
context:
space:
mode:
authortringenbach <tringenbach@f38db490-d61c-443f-a65b-d21fe96a405b>2010-07-14 16:09:11 +0000
committertringenbach <tringenbach@f38db490-d61c-443f-a65b-d21fe96a405b>2010-07-14 16:09:11 +0000
commit615374b0d1acc9711b540cb6c00d0ad58436dee0 (patch)
tree4dbe7cdfc3975c98aaa3a14c0db3e27b3ce05b30 /doc
parentad58aa92a221bb6cd0a4133112672528a52fd4f8 (diff)
Fix documentation for pgsql cel and cdr, and slightly improve pgsql_cel.
Change the documented pgsql schema to use "timestamp" instead of "time", as the latter is only a time without a date. Added some missing columns for cel's pgsql schema, and corrected spelling on some others. Updated cel's uniqueid size to be the same as the cdr. Added id column to cel's pgsql schema and updated code to allow unknown columns to get their default value instead of forcing 0 or empty string. Added microseconds to the timestamp cel logs to pgsql. Review: https://reviewboard.asterisk.org/r/734 git-svn-id: http://svn.digium.com/svn/asterisk/trunk@276349 f38db490-d61c-443f-a65b-d21fe96a405b
Diffstat (limited to 'doc')
-rw-r--r--doc/tex/cdrdriver.tex2
-rw-r--r--doc/tex/celdriver.tex18
2 files changed, 12 insertions, 8 deletions
diff --git a/doc/tex/cdrdriver.tex b/doc/tex/cdrdriver.tex
index a94ddf28b..8e3215c2f 100644
--- a/doc/tex/cdrdriver.tex
+++ b/doc/tex/cdrdriver.tex
@@ -258,7 +258,7 @@ CREATE TABLE cdr (
\begin{astlisting}
\begin{verbatim}
CREATE TABLE cdr (
- calldate time NOT NULL ,
+ calldate timestamp NOT NULL ,
clid varchar (80) NOT NULL ,
src varchar (80) NOT NULL ,
dst varchar (80) NOT NULL ,
diff --git a/doc/tex/celdriver.tex b/doc/tex/celdriver.tex
index c3abf0df0..c1b9e00d3 100644
--- a/doc/tex/celdriver.tex
+++ b/doc/tex/celdriver.tex
@@ -205,13 +205,15 @@ Using MySQL for Channel Event records is supported by using ODBC and the cel_odb
\begin{verbatim}
CREATE TABLE cel (
+ id serial ,
eventtype varchar (30) NOT NULL ,
- eventtime time NOT NULL ,
- cidname varchar (80) NOT NULL ,
- cidnum varchar (80) NOT NULL ,
- cidani varchar (80) NOT NULL ,
- cidrdnis varchar (80) NOT NULL ,
- ciddnis varchar (80) NOT NULL ,
+ eventtime timestamp NOT NULL ,
+ userdeftype varchar(255) NOT NULL ,
+ cid_name varchar (80) NOT NULL ,
+ cid_num varchar (80) NOT NULL ,
+ cid_ani varchar (80) NOT NULL ,
+ cid_rdnis varchar (80) NOT NULL ,
+ cid_dnid varchar (80) NOT NULL ,
exten varchar (80) NOT NULL ,
context varchar (80) NOT NULL ,
channame varchar (80) NOT NULL ,
@@ -219,7 +221,9 @@ Using MySQL for Channel Event records is supported by using ODBC and the cel_odb
appdata varchar (80) NOT NULL ,
amaflags int NOT NULL ,
accountcode varchar (20) NOT NULL ,
- uniqueid varchar (32) NOT NULL ,
+ peeraccount varchar (20) NOT NULL ,
+ uniqueid varchar (150) NOT NULL ,
+ linkedid varchar (150) NOT NULL ,
userfield varchar (255) NOT NULL ,
peer varchar (80) NOT NULL
);