root/trunk/hotstuff/database.txt

Revision 196, 1.1 KB (checked in by josef, 7 years ago)

- more documentation

Line 
1Some information about the Hotstuff database
2============================================
3
4* Table directory *
5
6This table does mostly contain the values of the .meta file data associated
7with each upload.
8Of special importance is the 'validity' field.
9If set to anything else than '' or NULL, the entry should be considered to be
10inexistent. In particular, it may contain the values:
11 - file-not-available, if a preview image or payload file was not found
12 - to-be-approved, if an upload did not yet pass the moderator queue
13 - replaced, if it refers to an old version which has been superseded
14
15* Table contents *
16
17This table contains internationalised versions for the name, summary, preview
18and payload data. Note that name still exists as primary key in the directory
19table in its original variant.
20
21* Format changes *
22
23The following changes have been done to be able to adhere to the spec from
24ghns.freedesktop.org:
25 - the field 'type' has been renamed to 'category'
26 - the field 'name' can have translations now
27 - if a file is not available, currently the meta file is skipped
28
Note: See TracBrowser for help on using the browser.