Author Topic: Database Changes?  (Read 542 times)

golgoj4

  • NEEDS to work for LinuxMCE
  • ***
  • Posts: 1072
  • hrumpf!
    • View Profile
    • La Smarthomes - SoCal smarthome site
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 »
Those people who tell you not to take chances, they are all missing what life's all about.

Wiki Hardware Page http://wiki.linuxmce.org/index.php/User:Langstonius