MediaPortal Version: 1.6.0
Description
History.title = varchar(1000)
History.genre = varchar(1000)
History.description = text
vs.
Program.title = varchar(2000)
Program.genre = varchar(200)
Program.description = text
vs.
Recording.title = varchar(2000)
Recording.genre = varchar(200)
Recording.description = varchar(8000)
should all the same
Steps to Reproduce:
see Description
Description
History.title = varchar(1000)
History.genre = varchar(1000)
History.description = text
vs.
Program.title = varchar(2000)
Program.genre = varchar(200)
Program.description = text
vs.
Recording.title = varchar(2000)
Recording.genre = varchar(200)
Recording.description = varchar(8000)
Code:
SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH
FROM INFORMATION_SCHEMA.COLUMNS
WHERE table_schema = 'MpTvDb'
AND (table_name = 'History' OR table_name = 'Program' OR table_name = 'Recording')
AND (column_name = 'title' OR column_name = 'genre' OR column_name = 'description');
should all the same
Steps to Reproduce:
see Description