8 May
2015
8 May
'15
10 a.m.
Module: kamailio
Branch: master
Commit: 7046d22486b80fe7f9facf2facc844fd0c0267d7
URL: https://github.com/kamailio/kamailio/commit/7046d22486b80fe7f9facf2facc844f…
Author: Daniel-Constantin Mierla <miconda(a)gmail.com>
Committer: Daniel-Constantin Mierla <miconda(a)gmail.com>
Date: 2015-05-08T09:54:29+02:00
lib/srdb1: aliases table needs to be same structure as location
---
Modified: lib/srdb1/schema/aliases.xml
---
Diff:
https://github.com/kamailio/kamailio/commit/7046d22486b80fe7f9facf2facc844f…
Patch:
https://github.com/kamailio/kamailio/commit/7046d22486b80fe7f9facf2facc844f…
---
diff --git a/lib/srdb1/schema/aliases.xml b/lib/srdb1/schema/aliases.xml
index 5f135b9..449ca60 100644
--- a/lib/srdb1/schema/aliases.xml
+++ b/lib/srdb1/schema/aliases.xml
@@ -9,7 +9,7 @@
<table id="aliases" xmlns:db="http://docbook.org/ns/docbook">
<name>aliases</name>
- <version>6</version>
+ <version>8</version>
<type db="mysql">&MYSQL_TABLE_TYPE;</type>
<description>
<db:para>This table for the registrar module is similar to the
"location" table, (the aliases index makes lookup of missed calls much faster).
Thus, the function lookup("alias") can be used to map aliases to AORs. More
information is available at: &KAMAILIO_MOD_DOC;registrar.html. Most people uses the
dbaliases table with the alias_db module now.
@@ -35,23 +35,23 @@
<natural/>
</column>
- <column id="username">
+ <column id="username">
<name>&USERCOL;</name>
<type>string</type>
<size>&user_len;</size>
<default/>
+ <description>Username / phone number </description>
<natural/>
- <description>Alias Username / Phone Number </description>
</column>
<column id="domain">
<name>domain</name>
<type>string</type>
<size>&domain_len;</size>
- <null/>
- <default><null/></default>
- <natural/>
+ <null/>
+ <default><null/></default>
<description>Domain name</description>
+ <natural/>
</column>
<column id="contact">
@@ -74,13 +74,13 @@
<column>
<name>path</name>
<type>string</type>
- <size>&uri_len;</size>
+ <size>&long_hf_len;</size>
<null/>
<default><null/></default>
<description>Path Header(s) per RFC 3327</description>
</column>
- <column>
+ <column id="expires">
<name>expires</name>
<type>datetime</type>
<default>&DEFAULT_ALIASES_EXPIRES;</default>
@@ -125,7 +125,7 @@
<type>int</type>
<size>&flag_len;</size>
<default>0</default>
- <description>Flags</description>
+ <description>Internal flags</description>
</column>
<column>
@@ -133,7 +133,7 @@
<type>int</type>
<size>&flag_len;</size>
<default>0</default>
- <description>CFlags</description>
+ <description>Branch and contact flags</description>
</column>
<column>
@@ -179,9 +179,42 @@
<description>The value of reg-id contact parameter</description>
</column>
+ <column>
+ <name>server_id</name>
+ <type>int</type>
+ <size>11</size>
+ <default>0</default>
+ <description>The value of server_id from configuration
file</description>
+ </column>
+
+ <column>
+ <name>connection_id</name>
+ <type>int</type>
+ <size>11</size>
+ <default>0</default>
+ <description>The value of connection id for location
record</description>
+ </column>
+
+ <column>
+ <name>keepalive</name>
+ <type>int</type>
+ <size>11</size>
+ <default>0</default>
+ <description>The value to control sending keep alive
requests</description>
+ </column>
+
- <index>
- <name>alias_idx</name>
+ <column>
+ <name>partition</name>
+ <type>int</type>
+ <size>11</size>
+ <default>0</default>
+ <description>The value to of the partition for keep alive
requests</description>
+ </column>
+
+
+ <index>
+ <name>account_contact_idx</name>
<colref linkend="username"/>
<colref linkend="domain"/>
<colref linkend="contact"/>
@@ -191,5 +224,9 @@
<colref linkend="ruid"/>
<unique/>
</index>
+ <index>
+ <name>expires_idx</name>
+ <colref linkend="expires"/>
+ </index>
</table>