[OpenSIPS-Devel] [OpenSIPS/opensips] 78e8be: Migrate the "expires" column from DATETIME to INT.

Bogdan-Andrei Iancu bogdan at opensips.org
Tue Feb 27 07:03:39 EST 2018


  Branch: refs/heads/master
  Home:   https://github.com/OpenSIPS/opensips
  Commit: 78e8bea12f023de3fd861ffc297c34b77caafe30
      https://github.com/OpenSIPS/opensips/commit/78e8bea12f023de3fd861ffc297c34b77caafe30
  Author: Bogdan-Andrei Iancu <bogdan at opensips.org>
  Date:   2018-02-27 (Tue, 27 Feb 2018)

  Changed paths:
    M db/schema/aliases.xml
    M db/schema/entities.xml
    M db/schema/location.xml
    M modules/usrloc/ucontact.c
    M modules/usrloc/udomain.c
    M modules/usrloc/ul_mod.h
    M scripts/db_berkeley/opensips/aliases
    M scripts/db_berkeley/opensips/location
    M scripts/db_berkeley/opensips/version
    M scripts/dbtext/opensips/version
    M scripts/mysql/registrar-create.sql
    M scripts/mysql/usrloc-create.sql
    M scripts/oracle/registrar-create.sql
    M scripts/oracle/usrloc-create.sql
    M scripts/pi_http/pi_framework.xml
    M scripts/pi_http/registrar-table
    M scripts/pi_http/usrloc-table
    M scripts/postgres/registrar-create.sql
    M scripts/postgres/usrloc-create.sql
    M scripts/sqlite/registrar-create.sql
    M scripts/sqlite/usrloc-create.sql

  Log Message:
  -----------
  Migrate the "expires" column from DATETIME to INT.

Instead of keeping a DATETIME which is impacted by TZ and DST changes, use UNIX timestamp
Fixes #1196.




More information about the Devel mailing list