diff options
author | Tilghman Lesher <tilghman@meg.abyt.es> | 2010-07-20 23:23:25 +0000 |
---|---|---|
committer | Tilghman Lesher <tilghman@meg.abyt.es> | 2010-07-20 23:23:25 +0000 |
commit | 82448ad7d23de260487a0b86ea08c70cc6b1eba4 (patch) | |
tree | a6b69cab8006e8443b27dc3cc022852499254c24 /contrib | |
parent | ebf651105ec2ac565fb0b83d210b5370b62c0bcf (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: https://origsvn.digium.com/svn/asterisk/trunk@278307 65c4cc65-6c06-0410-ace0-fbb531ad65f3
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) +); |