inconistent column definition in server database (1 Viewer)

Wiedmann

Portal Pro
June 22, 2007
107
28
Home Country
Germany Germany
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)

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
 

Users who are viewing this thread

Top Bottom