broken audio info about universalmediaserver HOT 4 CLOSED

fixed in 2c3a7c5

Thanks to found it.

from universalmediaserver.

You're welcome.

After looking at the table, I'd propose to modify the primary key of AUDIOTRACKS using the tuple (FILEID, ID) leaving LANG out. The two SQL statements in the supporting class are using only "FILEID" and "FILEID, ID" as parameter.

from universalmediaserver.

I think that was for video file audiotrack language to allow same file and id with different lang ? IDK

from universalmediaserver.

I don't mind the LANG field! I think indexes have to match the query to be taken into account.

• One query has as WHERE parameter fileid and will use the index generated by the FOREIGN_KEY constraint.
• The other query stepping through the audiotracks uses fileid and ID and will most likely not match the PRIMARY_KEY constraint because the index spans over 3 fields (fileid, id, lang).

I proposed to change

CONSTRAINT + TABLE_NAME + PK_MARKER + PRIMARY_KEY + "(" + COL_FILEID + COMMA + COL_ID + COMMA + COL_LANG + ")" + COMMA +

into

CONSTRAINT + TABLE_NAME + PK_MARKER + PRIMARY_KEY + "(" + COL_FILEID + COMMA + COL_ID + ")" + COMMA +

from universalmediaserver.