[mb-devel] ASIN editing
andy at hybridized.org
Tue Jun 1 01:59:34 UTC 2004
Robert J Munro wrote:
> Andy Grundman wrote:
>> OK, now that I've submitted some Match.pl improvements, I want to work
>> on user editing of the ASIN field.
>> This will require a schema change because we need to mark ASINs that
>> have been manually assigned so the Amazon script can ignore them. To
>> make a schema change, do I just create a new file in admin/sql/update?
>> Does this change sound OK?
> I've kind of already said this, but would it be a good idea to move
> ASINs to another table? You can then use the same table and editing
> features for UPCs, EANs, other on-line shop's identifiers etc. The table
> would have 3 fields, an albumID (or releaseID), a type, and a value for
> the identifier.
I agree, although I don't think anyone is ready to commit to a format
for this table yet. Could we add ASIN editing on the current field and
migrate it later? This new matching script will probably mismatch a few
VA albums so it would be nice for people to be able to fix that.
> Another random thought just occured to me - maybe it should be linked to
> the release dates, rather than the albums themselves. I guess that
> depends on if re-releases, and releases in different countries usually
> get the same ASIN, UPC, or EAN. It might make more sense if relase
> format is added - links to the same album on CD, tape, MiniDisc, SACD
> etc. could be separated correctly.
Interesting...I can't really wrap my brain around all the possibilities
just yet. :)
More information about the MusicBrainz-devel