Edgewall Software

Trac Database Schema: Attachments

Trac's attachment module uses just a single database table.

Table attachment

attachmenttype, id, filename
type Realm (e.g. wiki for wiki page attachments, ticket for ticket attachments)
id Resource id (ticket id or wiki page name)
filename Attachment file name
sizeint Attachment file size in bytes
timeint64 Time attachment was uploaded
author User name of uploader
ipnr IP address of the uploader Removed in Trac 1.3.1 (see #9612)

Stores metadata describing the attachments of e.g. Wiki pages or tickets. The actual file contents are stored on disk, not in the DB.

Use the trac.attachment.Attachment model class to access this table.

See trac.attachment.Attachment

Last modified 14 months ago Last modified on Feb 9, 2017, 11:17:50 PM
Note: See TracWiki for help on using the wiki.