[sr-dev] git:master:022145f2: lib/srdb1: schema updated for subscriber table to use entities for columns size

[Daniel-Constantin Mierla]

Module: kamailio
Branch: master
Commit: 022145f251b1551c01dc409333b4945147736aef
URL: https://github.com/kamailio/kamailio/commit/022145f251b1551c01dc409333b4945147736aef

Author: Daniel-Constantin Mierla <miconda at gmail.com>
Committer: Daniel-Constantin Mierla <miconda at gmail.com>
Date: 2016-10-06T14:48:59+02:00

lib/srdb1: schema updated for subscriber table to use entities for columns size

- password column len is 64, ha1 and ha1b are 128
- table version increased to 7
- related to GH #779

---

Modified: lib/srdb1/schema/subscriber.xml

---

Diff:  https://github.com/kamailio/kamailio/commit/022145f251b1551c01dc409333b4945147736aef.diff
Patch: https://github.com/kamailio/kamailio/commit/022145f251b1551c01dc409333b4945147736aef.patch

---

diff --git a/lib/srdb1/schema/subscriber.xml b/lib/srdb1/schema/subscriber.xml
index 726db61..7300177 100644
--- a/lib/srdb1/schema/subscriber.xml
+++ b/lib/srdb1/schema/subscriber.xml
@@ -9,7 +9,7 @@
 
 <table id="subscriber" xmlns:db="http://docbook.org/ns/docbook">
     <name>subscriber</name>
-    <version>6</version>
+    <version>7</version>
     <type db="mysql">&MYSQL_TABLE_TYPE;</type>
     <description>
         <db:para>This table is used to provide authentication information. More information about the auth_db module can be found at: &KAMAILIO_MOD_DOC;auth_db.html
@@ -47,39 +47,39 @@
     <column>
         <name>password</name>
         <type>string</type>
-        <size>25</size>
+        <size>&password_len;</size>
         <default/>
         <description>Password</description>
     </column>
 
     <column>
-        <name>email_address</name>
+        <name>ha1</name>
         <type>string</type>
-        <size>&user_len;</size>
+        <size>&ha1_len;</size>
         <default/>
-        <description>Email address</description>
+        <description>md5(username:realm:password)</description>
     </column>
 
     <column>
-        <name>ha1</name>
+        <name>ha1b</name>
         <type>string</type>
-        <size>&domain_len;</size>
+        <size>&ha1_len;</size>
         <default/>
-        <description>md5(username:realm:password)</description>
+        <description>md5(username at domain:realm:password)</description>
     </column>
 
     <column>
-        <name>ha1b</name>
+        <name>email_address</name>
         <type>string</type>
-        <size>&domain_len;</size>
+        <size>&uri_len;</size>
         <default/>
-        <description>md5(username at domain:realm:password)</description>
+        <description>Email address</description>
     </column>
 
     <column>
         <name>rpid</name>
         <type>string</type>
-        <size>&domain_len;</size>
+        <size>&uri_len;</size>
         <null/>
         <default><null/></default>
         <description>The SIP Remote-Party-ID header identifies the calling party and includes user, party, screen and privacy headers that specify how a call is presented and screened.</description>