[sr-dev] git:master:c9f2aa71: db_redis: Align schema with usrloc expires_type default

Module: kamailio Branch: master Commit: c9f2aa71b2e0d4a4f71b3da92f97306e86f93eea URL: https://github.com/kamailio/kamailio/commit/c9f2aa71b2e0d4a4f71b3da92f97306… Author: Andreas Granig &lt;agranig(a)sipwise.com&gt; Committer: Andreas Granig &lt;agranig(a)sipwise.com&gt; Date: 2018-03-08T15:54:24+01:00 db_redis: Align schema with usrloc expires_type default Since expires_type is DATETIME by default, use "time" type in upstream schema for location table. --- Modified: src/modules/db_redis/doc/db_redis_admin.xml Modified: utils/kamctl/db_redis/kamailio/location --- Diff: https://github.com/kamailio/kamailio/commit/c9f2aa71b2e0d4a4f71b3da92f97306… Patch: https://github.com/kamailio/kamailio/commit/c9f2aa71b2e0d4a4f71b3da92f97306… --- diff --git a/src/modules/db_redis/doc/db_redis_admin.xml b/src/modules/db_redis/doc/db_redis_admin.xml index 168bd500d4..f57fa8064e 100644 --- a/src/modules/db_redis/doc/db_redis_admin.xml +++ b/src/modules/db_redis/doc/db_redis_admin.xml @@ -189,4 +189,17 @@ modparam("auth_db", "db_url", DBURL_AUTH) </programlisting> </example> </section> + + <section> + <title>Module specific considerations</title> + <section> + <title>usrloc</title> + <para> + If you set "expires_type" to "1" in order to use BIGINT instead of DATETIME, + make sure to update your location schema file and change the type of "expires" + and "last_modified" from "time" to "int". + </para> + </section> + </section> + </chapter> diff --git a/utils/kamctl/db_redis/kamailio/location b/utils/kamctl/db_redis/kamailio/location index 9ca18f2fb0..7c0ea2ab81 100644 --- a/utils/kamctl/db_redis/kamailio/location +++ b/utils/kamctl/db_redis/kamailio/location @@ -1,2 +1,2 @@ -id/int,ruid/string,username/string,domain/string,contact/string,received/string,path/string,expires/int,q/double,callid/string,cseq/int,last_modified/int,flags/int,cflags/int,user_agent/string,socket/string,methods/int,instance/string,reg_id/int,server_id/int,connection_id/int,keepalive/int,partition/int, +id/int,ruid/string,username/string,domain/string,contact/string,received/string,path/string,expires/time,q/double,callid/string,cseq/int,last_modified/time,flags/int,cflags/int,user_agent/string,socket/string,methods/int,instance/string,reg_id/int,server_id/int,connection_id/int,keepalive/int,partition/int, 9