[geeklog-hg] [Geeklog-Core/geeklog] a0789a: Fixed subtype and primary key for topic assignment...

[Tom]

  Branch: refs/heads/master
  Home:   https://github.com/Geeklog-Core/geeklog
  Commit: a0789ae62f34924bc57ecaf08b078ce0895f787f
      https://github.com/Geeklog-Core/geeklog/commit/a0789ae62f34924bc57ecaf08b078ce0895f787f
  Author: eSilverStrike <eSilverStrike at users.noreply.github.com>
  Date:   2020-01-23 (Thu, 23 Jan 2020)

  Changed paths:
    M public_html/admin/install/devel-db-update.php
    M sql/mysql_tableanddata.php
    M sql/pgsql_tableanddata.php
    M sql/updates/mysql_2.2.0_to_2.2.1.php
    M sql/updates/pgsql_2.2.0_to_2.2.1.php

  Log Message:
  -----------
  Fixed subtype and primary key for topic assignments and likes tables

For #1027. For topic assignments table the primary key now is (tid,type,subtype,id) and max key length is kept under 1000 bytes by reducing subtype eto 15 chars