Author Topic: Database Changes?  (Read 578 times)

golgoj4

  • NEEDS to work for LinuxMCE
  • ***
  • Posts: 1082
  • hrumpf!
    • View Profile
    • Mah Website
Database Changes?
« 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

http://www.youtube.com/watch?v=B-Bt4A7NR_g - maybe this clarifies what i mean?
« Last Edit: February 16, 2011, 09:58:57 am by golgoj4 »
Official Releases
http://deb.linuxmce.org/QOrbiter-release.apk latest Qt4 android apk  http://deb.linuxmce.org/QOrbiterQt5-release.apk for the Qt5 Android version http://deb.linuxmce.org/QOrbiter-release.dmg for the MacOSX version

Unstable Nightlies
http://langstonball.com/downloads