Author
Topic: Database Changes? (Read 697 times)

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 episodesChange 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