Work in Progress - New Database structure for 1.4

  Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
m.savazzi Offline
Moderator
Posts: 908
Joined: Mar 2008
Reputation: 28
Post: #1
Team,
here is the topic for the discussion on the new DB structure for 1.4

Major objective is to make it flexible enough to support all possible additional files (CD Art, etc...) and to add the Tags/Keywords

Online database view: http://dl.dropboxusercontent.com/u/78566...index.html

Some info gathered from other threads:
Skydrive of new propose structure: http://sdrv.ms/12Pg0HP

Good message on some points Smile Message #9

Suggested tools to view and edit the structure:
SQLite Studio 2.1.5
SQLite Maestro Trial
SQLite Browser
TkSQLite

Full list of mangement tools
Please help us Smile

If you think I'm useful please use the +/- button to raise my reputation
(This post was last modified: 2014-02-13 20:44 by Cocotus.)
find quote
Cocotus Offline
Moderator
Posts: 328
Joined: Mar 2011
Reputation: 7
Post: #2
Very nice thanks! I see 3 .emm databases on your skydrive, I think EmberNewDatabase.emm is the one that's up to date? You mentionend in the other thread that you had included the keywords table/column for movies but I can't find it in there?
find quote
m.savazzi Offline
Moderator
Posts: 908
Joined: Mar 2008
Reputation: 28
Post: #3
(2014-02-06 09:45)Cocotus Wrote:  Very nice thanks! I see 3 .emm databases on your skydrive, I think EmberNewDatabase.emm is the one that's up to date? You mentionend in the other thread that you had included the keywords table/column for movies but I can't find it in there?

I've cleaned up the folder. There is only my new structure.

If you think I'm useful please use the +/- button to raise my reputation
find quote
hatbrox Offline
Member
Posts: 97
Joined: Sep 2010
Reputation: 0
Post: #4
will the DB also contain movie set information?
find quote
m.savazzi Offline
Moderator
Posts: 908
Joined: Mar 2008
Reputation: 28
Post: #5
should have them if someone adds them Smile

If you think I'm useful please use the +/- button to raise my reputation
find quote
Cocotus Offline
Moderator
Posts: 328
Joined: Mar 2011
Reputation: 7
Post: #6
(2014-02-11 10:15)hatbrox Wrote:  will the DB also contain movie set information?

It's there, take a look: http://dl.dropboxusercontent.com/u/78566...index.html
find quote
Cocotus Offline
Moderator
Posts: 328
Joined: Mar 2011
Reputation: 7
Post: #7
Missing Runtime field in Episode table (needs a field like the runtime field in movie table)
find quote
m.savazzi Offline
Moderator
Posts: 908
Joined: Mar 2008
Reputation: 28
Post: #8
see here: http://forum.xbmc.org/showthread.php?tid=200911

If you think I'm useful please use the +/- button to raise my reputation
find quote