[mythtv-users] sql query to identify duplicates

[Gary Buhrmaster]

On Thu, May 1, 2014 at 12:23 PM, Leo Butler <leo.butler at member.ams.org> wrote:
...
> A second question: from Raymond's description, the duplicate field
> sounds like it should be a boolean. Is that correct? If so, I take it
> that the database has no boolean datatype and the tinyint is used in
> place?

In MySQL, the BOOL (and BOOLEAN) datatype is an alias for
TINYINT(1) and will be displayed as TINYINT(1) in schema
dumps (where at least some of the wiki content was generated
from).