inconistent column definition in server database (1 Viewer)

Wiedmann

Portal Pro
June 22, 2007
107
28
Germany Germany
Country flag
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 (Users: 0, Guests: 1)

Top Bottom