Changes between Version 12 and Version 13 of TracDev/DatabaseSchema
- Timestamp:
- Mar 11, 2012, 8:04:30 PM (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TracDev/DatabaseSchema
v12 v13 7 7 * [./Attachments] 8 8 * [./WikiSystem Wiki System] 9 * [./VersionControl Cache Version control cache]9 * [./VersionControl Version control system] 10 10 * [./TicketSystem Ticket system] 11 11 * [./ReportSystem Report system] … … 18 18 || `enum` || Maps integer IDs for issues' priorities, severities, etc. to human-readable names. || 19 19 || `milestone` || Project milestones. || 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. ||20 || [./VersionControl#Tablenode_change 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. || 21 21 || [./Common#Tablepermission permission] || Username/action pairs describing who's allowed to do what. This table's contents also hold permission groups. || 22 22 || `report` || Stores the SQL to generate canned database reports. || 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. || 23 || [./VersionControl#Tablerepository repository] || Stores cached and configured repository properties. || 24 || [./VersionControl#Tablerevision 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. || 24 25 || [./Common#Tablesession session] || Last user visit time. || 25 26 || [./Common#Tablesession_attribute session_attribute] || Information about user settings, including name, email, and diff options. || … … 29 30 || `ticket_custom` || The values of custom ticket fields. || 30 31 || `version` || As in `component` and `milestone`, this holds the options of the drop-down `version` list on the ticket form. Every version can have a `time` set, although that is not presently used other than for ordering the list of versions in the UI. || 31 || `wiki` || Wiki pages (including old revisions). || 32 33 {{{ 34 #!div class=important 35 TODO: add 0.12 tables 36 - ~~cache~~ 37 - repository 38 }}} 32 || [./WikiSystem#Tablewiki wiki] || Wiki pages (including old revisions). || 39 33 40 34 == Database Schema 0.11 ==