[mb-devel] ASIN editing

[Andy Grundman]

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.  :)

-Andy