Edgewall Software

Changes between Version 12 and Version 13 of TracDev/DatabaseSchema


Ignore:
Timestamp:
Mar 11, 2012, 8:04:30 PM (10 years ago)
Author:
Peter Suter
Comment:

Link to WikiSystem and VersionControl subpages

Legend:

Unmodified
Added
Removed
Modified
  • TracDev/DatabaseSchema

    v12 v13  
    77* [./Attachments]
    88* [./WikiSystem Wiki System]
    9 * [./VersionControlCache Version control cache]
     9* [./VersionControl Version control system]
    1010* [./TicketSystem Ticket system]
    1111* [./ReportSystem Report system]
     
    1818|| `enum` || Maps integer IDs for issues' priorities, severities, etc. to human-readable names. ||
    1919|| `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. ||
    2121|| [./Common#Tablepermission permission] || Username/action pairs describing who's allowed to do what. This table's contents also hold permission groups. ||
    2222|| `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. ||
    2425|| [./Common#Tablesession session] || Last user visit time. ||
    2526|| [./Common#Tablesession_attribute session_attribute] || Information about user settings, including name, email, and diff options. ||
     
    2930|| `ticket_custom` || The values of custom ticket fields. ||
    3031|| `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). ||
    3933
    4034== Database Schema 0.11 ==