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

Module: sip-router Branch: master Commit: 3cb33d3a5a24e228be69596910349c4732297f55 URL: http://git.sip-router.org/cgi-bin/gitweb.cgi/sip-router/?a=commit;h=3cb33d3… Author: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; Committer: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; 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"/>