[Approved] Fix MySQL Case Sensitive (1 Viewer)

[esdk]

When upgrading from mysql database version 56->57 the case of the table name is with lower case but should be upper case:

Reproduce:
Compile and install the mediaportal on case sensitive mysql database (Default). In last part of installation the database is created and upgraded. - crash.

Change file: ...\MediaPortal\TvEngine3\TVLibrary\SetupTv\57_upgrade_mysql_database.sql

From:
USE %TvLibrary%;
ALTER TABLE channel DROP COLUMN name;
ALTER TABLE channel DROP COLUMN freetoair;
UPDATE Version SET versionNumber=57;

To:
USE %TvLibrary%;
ALTER TABLE Channel DROP COLUMN name;
ALTER TABLE Channel DROP COLUMN freetoair;
UPDATE Version SET versionNumber=57;

Rgds

Søren Kristensen
Denmark

 

[chemelli]

Change commited.

a lot for your report.

Simone