[mythtv] Database upgrade failure

[Gary Buhrmaster]

On Mon, Jan 24, 2022 at 5:22 PM Gary Buhrmaster
<gary.buhrmaster at gmail.com> wrote:

> That said, the create table statement
> for these sports extensions *should*
> have explicitly set the engine to be
> MYISAM(*), as the other create tables
> do, in order to avoid the random issues
> one otherwise can encounter with
> different configurations.
>
> I would suggest you open a github
> issue against the failure to upgrade
> (and the commit).

I just noticed another issue.  The sportslisting
table uses a foreign key.  And MYISAM does
not support foreign keys.

TTBOMK, the MythTV project as historically
avoided using foreign keys (preferring to
implement the business logic in the code,
and any cleanups, including inconsistencies,
to be in the housekeeping codes) in order
to be database independent.

So, with MYISAM not supporting foreign
keys, and INNODB needing to be configured
specifically to support such large key lengths,
one would seem to have additional issues
to consider and decide upon.