LinuxMCE Forums

General => Developers => Topic started by: golgoj4 on February 15, 2011, 07:50:52 am

Title: Database Changes?
Post by: golgoj4 on February 15, 2011, 07:50:52 am
Hello again fellow hobbyists,

So as another component that needs to be wrapped together in the media part of linuxmce, I have made some changes to the database and im not sure how to submit them.

Change #1: Adding 'Program' to the list of filters
Purpose: To quickly bring up a listing of tv shows and associated episodes
Change made:
In the 'MediaType_AttributeType' table of pluto_media, i inserted a new record similar to the others only specifying the media_type as 5, the FK_AttributeType as 12 ('Program') with MediaSortOption set to 4.

Now I can browse tagged television shows by the show and because they are tagged with the release dates, go in chronological order when presented in Orbiter.

Change #2 is simply to add another attributetype to the existing ones called seriesID.
Purpose: This is a unique identifier that helps differentiate between say Battlestar Galactica and Battlestar Galactica of 2003. While this generally isnt an issue as the series are noted with a year in case of a remake, but i like to be complete.
Change Made: Added 'seriesID' to the 'AttributeType' table in pluto_media.

Any suggestions on how I submit this cleanly are greatly appreciated.
-golgoj4 - maybe this clarifies what i mean?