[OpenSIPS-Devel] [OpenSIPS/opensips] 5839c0: auth_jwt DB schema: Change jwt_secrets.secret to TEXT

[Liviu Chircu]

  Branch: refs/heads/master
  Home:   https://github.com/OpenSIPS/opensips
  Commit: 5839c042ae2cbe898c1c0706e1a03717bd56e567
      https://github.com/OpenSIPS/opensips/commit/5839c042ae2cbe898c1c0706e1a03717bd56e567
  Author: Liviu Chircu <liviu at opensips.org>
  Date:   2020-05-26 (Tue, 26 May 2020)

  Changed paths:
    M db/schema/auth_jwt_secrets.xml
    M scripts/mysql/authjwt-create.sql
    M scripts/oracle/authjwt-create.sql
    M scripts/pi_http/authjwt-table
    M scripts/pi_http/pi_framework.xml
    M scripts/postgres/authjwt-create.sql
    M scripts/sqlite/authjwt-create.sql

  Log Message:
  -----------
  auth_jwt DB schema: Change jwt_secrets.secret to TEXT

Fixes the following with MariaDB 10.1.44 (Xubuntu 18.04):

_mysql.connection.query(self, query) sqlalchemy.exc.OperationalError:
(_mysql_exceptions.OperationalError) (1074, "Column length too big for
column 'secret' (max = 255); use BLOB or TEXT instead")
[SQL: CREATE TABLE jwt_secrets (
    id INT(10) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL,
    corresponding_tag CHAR(128) NOT NULL,
    secret CHAR(2048) NOT NULL,
    start_ts INT NOT NULL,
    end_ts INT NOT NULL
) ENGINE=InnoDB]