Quoting Kulju:

Quote:
I think primary key is already a combination of two fields UPC/Disc ID and locality, so we need to add a third one. Original Title maybe?

Ah yes, you're correct.  In that case, a new PK to replace UPC/Locality.  Original title won't work in this case.  For example, the same UPC is being used for multiple versions of the Iron Man 2 release, some with slip case and some without.

This would allow re-releases to be added.

The problem I see with the "re-release/alternate" release profiles, is how are you going to know which one to download when you enter the UPC of your new DVD?

I would like to the see the new name linking system combined with the single movie profile feature. There would be movie-level data, profile-level data and local-only data. Profile-level data would override movie-level data, so there would have to be some sort of system to say which you were contributing to. It would contain a delta to say things like 'Remove actor X, Add actor Y'

Quoting jmbox:

Quote:
The problem I see with the "re-release/alternate" release profiles, is how are you going to know which one to download when you enter the UPC of your new DVD?
...

Imho it should be a list as it is now for same EAN/UPC in different localities.
With a Preview (as it is now for additions by title) you could choose the correct version.

"Root" was a bad word choice on my part. The way I described it may have sounded as if I was going in reverse (and, of course, there is a possibility I wasn't describing it in the proper way either). Also keep in mind that although I am indicating things through "levels", the System IDs would not indicate anything of the sort. They would all be SID:1234, SID:2345, etc. and not SID:L1-1234, SID:L2-2345.


Level A contains info that is universal across all copies of a title. This would include the title's name, the cast and crew (there are exceptions, of course, but there's no point in getting into those since the system being created isn't likely in the first place), a list of all episodes (and cast and crew within them), and maybe something else.

Level B is information that differs on the most basic level if I picked up two copies of a title from the store that were different. This holds a UPC and can include the rest of what is currently put into the title field such as "Full Screen / Widescreen", Edition, Runtime, Features, etc. This also holds the cover scans.

Level C is information strictly connected to an individual disc. It draws information from Level A's System ID# (but not necessarily the one that I just mentioned above). That includes the title and specific episodes by number that were included in Level A and allows not only for cast/crew data to be entered once, but means it settles the issues with multiple movies on the same disc since each Level A has its own System ID#.


Lets say I had Ghostbusters II and the 8th episode of Ghost Whisperer together. Because this is all about one side of one disc, then we are editing "Level C."

* Ghostbusters II title (Level A) = SID#:1111
* GB-II's UPC [for specific copy/version of the movie] (Level B) = SID#:2222

* Ghost Wisperer title (Level A) = SID#:3333  (and contains the episode list with cast/crew)
* GW's UPC for Season 1 (Level B) = SID#:4444

* Disc ID that I am working on (Level C) = SID#:5555

* SID#:2222 had to be manually linked to SID#:1111 by someone (remember, there could be other IDs linked to SID#:111 as well).
* Likewise, SID#:4444 was manually linked to SID#:3333

Link SID:2222 and SID#:4444-ep8 (because SID#:4444 is linked to SID:3333 which contains the episode info) each to SID#:5555. The disc now contains the data for one movie and a single episode of a completely different title.