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

Module: kamailio Branch: master Commit: 022145f251b1551c01dc409333b4945147736aef URL: https://github.com/kamailio/kamailio/commit/022145f251b1551c01dc409333b4945… Author: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; Committer: Daniel-Constantin Mierla &lt;miconda(a)gmail.com&gt; 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/022145f251b1551c01dc409333b4945… Patch: https://github.com/kamailio/kamailio/commit/022145f251b1551c01dc409333b4945… --- 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@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@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>