[lcg_]

[...] How do use that ALTER TABLE command to fix it?

You need to run this as an SQL command for your database to alter the table. In my case that's MariaDB, in a standard Kodi installation it is a local SQLite. I like to use DBeaver for tinkering with SQL databases, it works for both.

Cheers,
L.