OstDB DEV: Difference between revisions

Line 23: Line 23:


==Audio File==
==Audio File==
Representation of an actual physical file which was encountered by an AniDB client at least once (it is not possible to add files manually). Files are initially not linked to any songs, albums or artists. Once known to AniDB a file can be linked to a song via the webinterface or an AniDB client.
Users can add files to their my(ost)lists. Songs can also be added to mylist directly by using generic files.
Data stored:
* id (ofid)
* id (ofid)
* size (without header)
* size (without header)
Line 33: Line 38:
* flags (unused)
* flags (unused)


special cached values:
Special cached values:
* number of users who have this file in their ost list (unique)
* number of users who have this file in their ost list (unique)
* number of users who have submitted data for this file (unique)
* number of users who have submitted data for this file (unique)
* number of meta data entries submitted for this file
* number of meta data entries submitted for this file


constraints:
Constraints:
* unique (size, content hash)
* unique (size, content hash)


MediaWiki spam blocked by CleanTalk.
MediaWiki spam blocked by CleanTalk.