[sr-dev] git:tteras/mohqueue: mohqueue schema files

[Timo Teras]

Module: sip-router
Branch: tteras/mohqueue
Commit: 1af34ca5b9f799b83242a9ecddf8abe9521114dd
URL:    http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=1af34ca5b9f799b83242a9ecddf8abe9521114dd

Author: Robert Boisvert <rdboisvert at gmail.com>
Committer: Timo Teräs <timo.teras at iki.fi>
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>