LinuxMCE Forums
May 24, 2013, 08:59:49 pm GMT-1 *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Rule #1 - Be Patient - Rule #2 - Don't ask when, if you don't contribute - Rule #3 - You have coding skills - LinuxMCE's small brother is available: http://www.agocontrol.com
 
   Home   Help Search Chat Login Register  
Pages: [1]
  Print  
Author Topic: Database Changes?  (Read 437 times)
golgoj4
wants to work for LinuxMCE
**
Posts: 823


hrumpf!


View Profile WWW
« 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 » Logged

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
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!