Changes between Version 10 and Version 11 of TracDev/DatabaseSchema
- Timestamp:
- Mar 11, 2012, 7:18:47 PM (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TracDev/DatabaseSchema
v10 v11 4 4 5 5 == Overview == 6 * [./Common] 7 * [./Attachments] 8 * [./WikiSystem Wiki System] 9 * [./VersionControlCache Version control cache] 10 * [./TicketSystem Ticket system] 11 * [./ReportSystem Report system] 12 6 13 || '''Table Name''' || '''Purpose''' || 7 14 || `attachment` || Descriptions of attachments (the files themselves are stored on disk). || 8 || `auth_cookie` || User login cookies. || 15 || [./Common#Tableauthcookie auth_cookie] || User login cookies. || 16 || [./Common#Tablecache cache] || Synchronization table for process- and thread-local caches. || 9 17 || `component` || Values that can be used in a ticket's "component" field. The `owner` column is used as the default assignee for new tickets, if not overridden at the time of ticket submission. || 10 18 || `enum` || Maps integer IDs for issues' priorities, severities, etc. to human-readable names. || 11 19 || `milestone` || Project milestones. || 12 20 || `node_change` || 1^st^ half of the repository cache: for every changeset (as identified by the revision number), this table contains the nodes (i.e. files or directories) that have been added/modified/deleted. || 13 || `permission`|| Username/action pairs describing who's allowed to do what. This table's contents also hold permission groups. ||21 || [./Common#Tablepermission permission] || Username/action pairs describing who's allowed to do what. This table's contents also hold permission groups. || 14 22 || `report` || Stores the SQL to generate canned database reports. || 15 23 || `revision` || 2^nd^ half of the repository cache: changesets, containing the revision number, author, time, and log message. The list of files and directories modified by a changeset can be found by joining with `node_change` on the `rev` column. || 16 || `session`|| Last user visit time. ||17 || `session_attribute`|| Information about user settings, including name, email, and diff options. ||18 || `system`|| System information such as the database version and repository cache metadata ||24 || [./Common#Tablesession session] || Last user visit time. || 25 || [./Common#Tablesessionattribute session_attribute] || Information about user settings, including name, email, and diff options. || 26 || [./Common#Tablesystem system] || System information such as the database version and repository cache metadata || 19 27 || `ticket` || Tickets. || 20 28 || `ticket_change` || Changes to tickets, on a field-by-field basis. The field value `comment` is special: it associates a comment with a set of field changes. || … … 26 34 #!div class=important 27 35 TODO: add 0.12 tables 28 - cache36 - ~~cache~~ 29 37 - repository 30 38 }}}