[sr-dev] git:master: srdb1: updated schema for dialog table

Daniel-Constantin Mierla miconda at gmail.com
Fri Feb 17 09:37:45 CET 2012


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

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date:   Fri Feb 17 09:21:37 2012 +0100

srdb1: updated schema for dialog table

- new column xdata to store aditional info per dialog
- it will store the profiles dialog belongs to, serialized as json
- toroute column (unused) renamed to iflags to store the internal dialog
  flags (such as flag for sending BYE on timeout)

---

 lib/srdb1/schema/dialog.xml |   17 ++++++++++++-----
 1 files changed, 12 insertions(+), 5 deletions(-)

diff --git a/lib/srdb1/schema/dialog.xml b/lib/srdb1/schema/dialog.xml
index 8c5e5b4..e8a5527 100644
--- a/lib/srdb1/schema/dialog.xml
+++ b/lib/srdb1/schema/dialog.xml
@@ -9,7 +9,7 @@
 
 <table id="dialog" xmlns:db="http://docbook.org/ns/docbook">
 	<name>dialog</name>
-	<version>5</version>
+	<version>6</version>
 	<type db="mysql">&MYSQL_TABLE_TYPE;</type>
 	<description>
 		<db:para>Persistent dialog information for the dialog module. More 
@@ -172,17 +172,16 @@
 		<type>unsigned int</type>
 		<size>10</size>
 		<default>0</default>
-		<description>The flags to set for dialog and usable from config file.
+		<description>The flags to set for dialog and accesible from config file.
 		</description>
 	</column>
 
 	<column>
-		<name>toroute</name>
+		<name>iflags</name>
 		<type>unsigned int</type>
 		<size>10</size>
 		<default>0</default>
-		<description>The ID of route to be executed at dialog timeout (ignored from v3.1,
-			using instead toroute_name).
+		<description>The internal flags for dialog.
 		</description>
 	</column>
 
@@ -202,6 +201,14 @@
 		<description>The URI of initial request in dialog</description>
 	</column>
 
+	<column>
+		<name>xdata</name>
+		<type>string</type>
+		<size>512</size>
+		<null/>
+		<description>Extra data associated to the dialog (e.g., serialized profiles).</description>
+	</column>
+
 	<index>
 		<name>hash_idx</name>
 		<colref linkend="hash_entry"/>




More information about the sr-dev mailing list