Module: sip-router Branch: tteras/mohqueue Commit: 1af34ca5b9f799b83242a9ecddf8abe9521114dd URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1af34ca… Author: Robert Boisvert &lt;rdboisvert(a)gmail.com&gt; Committer: Timo Teräs &lt;timo.teras(a)iki.fi&gt; Date: Thu Oct 3 11:36:08 2013 -0400 mohqueue schema files --- lib/srdb1/schema/kamailio-mohqueue.xml | 14 ++++++ lib/srdb1/schema/mohqcalls.xml | 76 ++++++++++++++++++++++++++++++++ lib/srdb1/schema/mohqueues.xml | 75 +++++++++++++++++++++++++++++++ 3 files changed, 165 insertions(+), 0 deletions(-) diff --git a/lib/srdb1/schema/kamailio-mohqueue.xml b/lib/srdb1/schema/kamailio-mohqueue.xml new file mode 100644 index 0000000..27d9a0d --- /dev/null +++ b/lib/srdb1/schema/kamailio-mohqueue.xml @@ -0,0 +1,14 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE database PUBLIC "-//kamailio.org//DTD DBSchema V1.1//EN" + "http://kamailio.org/pub/kamailio/dbschema/dtd/1.1/dbschema.dtd" [ + +<!ENTITY % entities SYSTEM "entities.xml"> +%entities; + +]> + +<database xmlns:xi="http://www.w3.org/2001/XInclude"> + <name>mohqueue</name> + <xi:include href="mohqcalls.xml"/> + <xi:include href="mohqueues.xml"/> +</database> diff --git a/lib/srdb1/schema/mohqcalls.xml b/lib/srdb1/schema/mohqcalls.xml new file mode 100644 index 0000000..6c99ec2 --- /dev/null +++ b/lib/srdb1/schema/mohqcalls.xml @@ -0,0 +1,76 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE table PUBLIC "-//kamailio.org//DTD DBSchema V1.1//EN" + "http://kamailio.org/pub/kamailio/dbschema/dtd/1.1/dbschema.dtd" [ + +<!ENTITY % entities SYSTEM "entities.xml"> +%entities; + +]> + +<table id="mohqcalls" xmlns:db="http://docbook.org/ns/docbook"> + <name>mohqcalls</name> + <version>1</version> + <type db="mysql">&MYSQL_TABLE_TYPE;</type> + <description> + <db:para>This table is used by the mohqueue module to store call information. This is a read-only table from the viewpoint of outside processes. More information about the mohqueue module can be found at: &KAMAILIO_MOD_DOC;mohqueue.html + </db:para> + </description> + + <column id="id"> + <name>id</name> + <type>unsigned int</type> + <size>&table_id_len;</size> + <autoincrement/> + <primary/> + <type db="dbtext">int,auto</type> + <description>Unique ID</description> + </column> + + <column id="mohq_id"> + <name>mohq_id</name> + <type>unsigned int</type> + <size>&table_id_len;</size> + <description>queue id</description> + </column> + + <column id="call_id"> + <name>call_id</name> + <type>string</type> + <size>100</size> + <description>Call-ID header</description> + </column> + + <column id="call_status"> + <name>call_status</name> + <type>unsigned int</type> + <description>status of call</description> + </column> + + <column id="call_from"> + <name>call_from</name> + <type>string</type> + <size>100</size> + <description>From header</description> + </column> + + <column id="call_contact"> + <name>call_contact</name> + <type>string</type> + <size>100</size> + <null/> + <description>Contact header</description> + </column> + + <column id="call_time"> + <name>call_time</name> + <type>datetime</type> + <default db="oracle">to_date('','yyyy-mm-dd hh24:mi:ss')</default> + <description>time when call first entered queue</description> + </column> + + <index> + <name>mohqcalls_idx</name> + <colref linkend="call_id" /> + <unique/> + </index> +</table> diff --git a/lib/srdb1/schema/mohqueues.xml b/lib/srdb1/schema/mohqueues.xml new file mode 100644 index 0000000..168e1ca --- /dev/null +++ b/lib/srdb1/schema/mohqueues.xml @@ -0,0 +1,75 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE table PUBLIC "-//kamailio.org//DTD DBSchema V1.1//EN" + "http://kamailio.org/pub/kamailio/dbschema/dtd/1.1/dbschema.dtd" [ + +<!ENTITY % entities SYSTEM "entities.xml"> +%entities; + +]> + +<table id="mohqueues" xmlns:db="http://docbook.org/ns/docbook"> + <name>mohqueues</name> + <version>1</version> + <type db="mysql">&MYSQL_TABLE_TYPE;</type> + <description> + <db:para>This table is used by the mohqueue module to store queue definitions. This is a read-only table from the viewpoint of the module. More information about the mohqueue module can be found at: &KAMAILIO_MOD_DOC;mohqueue.html + </db:para> + </description> + + <column id="id"> + <name>id</name> + <type>unsigned int</type> + <size>&table_id_len;</size> + <autoincrement/> + <primary/> + <type db="dbtext">int,auto</type> + <description>Unique ID</description> + </column> + + <column id="name"> + <name>name</name> + <type>string</type> + <size>25</size> + <description>queue name</description> + </column> + + <column id="uri"> + <name>uri</name> + <type>string</type> + <size>100</size> + <description>URI for the queue</description> + </column> + + <column id="mohdir"> + <name>mohdir</name> + <type>string</type> + <size>100</size> + <null/> + <description>directory for MOH files</description> + </column> + + <column id="mohfile"> + <name>mohfile</name> + <type>string</type> + <size>100</size> + <description>base name for the MOH file</description> + </column> + + <column id="debug"> + <name>debug</name> + <type>int</type> + <description>debug flag</description> + </column> + + <index> + <name>mohqueue_uri_idx</name> + <colref linkend="uri" /> + <unique/> + </index> + + <index> + <name>mohqueue_name_idx</name> + <colref linkend="name" /> + <unique/> + </index> +</table>