diff options
author | tilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b> | 2010-07-20 23:23:25 +0000 |
---|---|---|
committer | tilghman <tilghman@f38db490-d61c-443f-a65b-d21fe96a405b> | 2010-07-20 23:23:25 +0000 |
commit | f36de042adeff1e1ab6c153b657c41219b2cf3fb (patch) | |
tree | a6b69cab8006e8443b27dc3cc022852499254c24 /contrib | |
parent | 19fad2d909c697872dff634ee6ce1ae2abae9152 (diff) |
Separate queue_log arguments into separate fields, and allow the text file to be used, even when realtime is used.
(closes issue #17082)
Reported by: coolmig
Patches:
20100720__issue17082.diff.txt uploaded by tilghman (license 14)
Tested by: coolmig
git-svn-id: http://svn.digium.com/svn/asterisk/trunk@278307 f38db490-d61c-443f-a65b-d21fe96a405b
Diffstat (limited to 'contrib')
-rw-r--r-- | contrib/realtime/mysql/queue_log.sql | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/contrib/realtime/mysql/queue_log.sql b/contrib/realtime/mysql/queue_log.sql new file mode 100644 index 000000000..0b74f81a1 --- /dev/null +++ b/contrib/realtime/mysql/queue_log.sql @@ -0,0 +1,24 @@ +CREATE TABLE queue_log ( + -- Event date and time + time datetime, + -- "REALTIME", "NONE", or channel uniqueid + callid char(50), + -- Name of the queue affected + queuename char(50), + -- Interface name of the queue member + agent char(50), + -- One of ADDMEMBER, REMOVEMEMBER, RINGNOANSWER, EXITEMPTY, TRANSFER, + -- AGENTDUMP, ABANDON, SYSCOMPAT, CONNECT, COMPLETECALLER, COMPLETEAGENT, + -- PAUSEALL, UNPAUSEALL, PAUSE, UNPAUSE, PENALTY, ENTERQUEUE, + -- EXITWITHTIMEOUT, EXITEMPTY, EXITWITHKEY, or another defined by the user. + event char(20), + -- data1 through data5 are possible arguments to the event, the definitions + -- of which are dependent upon the type of event. + data1 char(50), + data2 char(50), + data3 char(50), + data4 char(50), + data5 char(50), + index bydate (time), + index qname (queuename,datetime) +); |