Changes between Initial Version and Version 1 of TracDev/DatabaseSchema/Attachments

Timestamp:

Mar 11, 2012, 7:26:30 PM (12 years ago)

Author:

Peter Suter

Comment:

—

TracDev/DatabaseSchema/Attachments

@@ +1 @@
+[[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'''||
+||''type''|| ||
+||''id''|| ||
+||''filename''|| ||
+||''size''||`int`||
+||''time''||`int64`||
+||''description''|| ||
+||''author''|| ||
+||''ipnr''|| ||
+
+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]