Normal
[USER=48495]@morpheus_xx[/USER]I have a MS SQL Express server running, so I thought why not finish this plugin.Is this something that could be of interest for MediaPortal 2? It would probably require changes to the installer or maybe even its own installer because the database creation cannot by done by the MediaPortal 2 service. If still of interest, should I create a branch?I also found a problem in the file: MediaLibrary-1.0-1.1.sql.The following SQL syntax is not supported by MS SQL:[CODE=SQL]ALTER TABLE MIA_TYPES ADD COLUMN CREATION_DATE %TIMESTAMP%;[/CODE]Instead it should be:[CODE=SQL]ALTER TABLE MIA_TYPES ADD CREATION_DATE %TIMESTAMP%;[/CODE]which is also supported by MySQL, SQLite and SQLCE plugins (I haven't tested the other two, are they still relevant?).
[USER=48495]@morpheus_xx[/USER]
I have a MS SQL Express server running, so I thought why not finish this plugin.
Is this something that could be of interest for MediaPortal 2? It would probably require changes to the installer or maybe even its own installer because the database creation cannot by done by the MediaPortal 2 service. If still of interest, should I create a branch?
I also found a problem in the file: MediaLibrary-1.0-1.1.sql.
The following SQL syntax is not supported by MS SQL:
[CODE=SQL]ALTER TABLE MIA_TYPES ADD COLUMN CREATION_DATE %TIMESTAMP%;[/CODE]
Instead it should be:
[CODE=SQL]ALTER TABLE MIA_TYPES ADD CREATION_DATE %TIMESTAMP%;[/CODE]
which is also supported by MySQL, SQLite and SQLCE plugins (I haven't tested the other two, are they still relevant?).