[sr-dev] git:master: lib/srdb1/schema: Add XML files related to dialog variables.

[Timo Reimann]

Module: sip-router
Branch: master
Commit: f54077c7f3c5fbe8863939b5c1aa04b860c08cf1
URL:    http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=f54077c7f3c5fbe8863939b5c1aa04b860c08cf1

Author: Timo Reimann <timo.reimann at 1und1.de>
Committer: Timo Reimann <timo.reimann at 1und1.de>
Date:   Fri Oct  7 15:11:26 2011 +0200

lib/srdb1/schema: Add XML files related to dialog variables.

---

 lib/srdb1/schema/dialog_vars.xml          |   66 +++++++++++++++++++++++++++++
 lib/srdb1/schema/kamailio-dialog_vars.xml |   12 +++++
 2 files changed, 78 insertions(+), 0 deletions(-)

diff --git a/lib/srdb1/schema/dialog_vars.xml b/lib/srdb1/schema/dialog_vars.xml
new file mode 100644
index 0000000..429b01c
--- /dev/null
+++ b/lib/srdb1/schema/dialog_vars.xml
@@ -0,0 +1,66 @@
+<?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="dialog_vars" xmlns:db="http://docbook.org/ns/docbook">
+	<name>dialog_vars</name>
+	<version>1</version>
+	<type db="mysql">&MYSQL_TABLE_TYPE;</type>
+	<description>
+		<db:para>Persistent dialog variable information for the dialog module.
+		More information can be found at: &KAMAILIO_MOD_DOC;dialog.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="hash_entry">
+		<name>hash_entry</name>
+		<type>unsigned int</type>
+		<size>10</size>
+		<description>Number of the hash entry in the dialog hash table
+		</description>
+		<natural/>
+	</column>
+
+	<column id="hash_id">
+		<name>hash_id</name>
+		<type>unsigned int</type>
+		<size>10</size>
+		<description>The ID on the hash entry</description>
+		<natural/>
+	</column>
+
+	<column>
+		<name>dialog_key</name>
+		<type>string</type>
+		<size>128</size>
+		<description>The key of the dialog variable</description>
+	</column>
+
+	<column>
+		<name>dialog_value</name>
+		<type>string</type>
+		<size>512</size>
+		<description>The value of the dialog variable</description>
+	</column>
+
+	<index>
+		<name>hash_idx</name>
+		<colref linkend="hash_entry"/>
+		<colref linkend="hash_id"/>
+	</index>
+</table>
diff --git a/lib/srdb1/schema/kamailio-dialog_vars.xml b/lib/srdb1/schema/kamailio-dialog_vars.xml
new file mode 100644
index 0000000..bd62410
--- /dev/null
+++ b/lib/srdb1/schema/kamailio-dialog_vars.xml
@@ -0,0 +1,12 @@
+<?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>Dialog Variables support</name>
+    <xi:include href="dialog_vars.xml"/>
+</database>