Edgewall Software
Home
Trac
Trac Hacks
Genshi
Babel
Bitten
Home
Download
Documentation
Mailing Lists
License
FAQ
Search:
Login
Preferences
Help/Guide
About Trac
Wiki
Timeline
Roadmap
Browse Source
View Tickets
New Ticket
Search
Context Navigation
-1
Start Page
Index
History
Editing TracDev/DatabaseSchema/Attachments
Adjust edit area height:
8
12
16
20
24
28
32
36
40
Edit side-by-side
[[PageOutline(2)]] = Trac Database Schema: Attachments Trac's attachment module uses just a single database table. == Table `attachment` ||'''Table'''||'''Key'''|| ||''attachment''||''type'', ''id'', ''filename''|| ||'''Columns'''||'''Type'''||'''Notes'''|| ||''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 || ||''size''||`int`|| Attachment file size in bytes || ||''time''||`int64`|| Time attachment was uploaded || ||''description''|| || || ||''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 [browser:trunk/trac/attachment.py trac.attachment.Attachment]
Note:
See
WikiFormatting
and
TracWiki
for help on editing wiki content.
Change information
Your email or username:
E-mail address and name can be saved in the
Preferences
Comment about this change (optional):
Note:
See
TracWiki
for help on using the wiki.