search

WinWorldPC / adventure

WinWorld's open library management system
GNU Affero General Public License v3.0
238 stars 33 forks source link

Artwork uploading for downloads #75

Open cathoderaydude opened 4 years ago

cathoderaydude commented 4 years ago

Downloads could be extended with artwork on the download info page. We already have the proof of concept with Screenshots, although we can't reuse that table because it's FKed back to Releases. Would probably be wisest to just duplicate Screenshots to a new table, Artwork

NattyNarwhal commented 4 years ago

Couldn't this be extended through screenshots on the release instead? I.E. we have "screenshots" that are box scans. We could even extend Screenshot to have a type property (for i.e disk label, box, application itself, magazine article, etc.)

cathoderaydude commented 4 years ago

My beef is that Screenshots is FKed on Releases. If we want to FK to Downloads we can do that but we'll have to make both columns nillable (ouch!).

We could also add DownloadUUID but also FK to ReleaseUUID, but if a Download is moved from one release to another, all associated screenshots with populated ReleaseUUIDs that are actually intended to be Artwork will have to be touched.

NattyNarwhal commented 4 years ago

My counter-beef is that images to me make more sense attached to releases (think cases of magazine scans, boxes with floppy and CD versions of software, the fact the boxes represent software), though I can see the case for downloads (label scans if they aren't in the archive, specific language boxart.