Edgewall Software

Changes between Version 10 and Version 11 of TracDev/DatabaseSchema


Ignore:
Timestamp:
Mar 11, 2012, 7:18:47 PM (11 years ago)
Author:
Peter Suter
Comment:

Start linking to subpages

Legend:

Unmodified
Added
Removed
Modified
  • TracDev/DatabaseSchema

    v10 v11  
    44
    55== Overview ==
     6* [./Common]
     7* [./Attachments]
     8* [./WikiSystem Wiki System]
     9* [./VersionControlCache Version control cache]
     10* [./TicketSystem Ticket system]
     11* [./ReportSystem Report system]
     12
    613|| '''Table Name''' || '''Purpose''' ||
    714|| `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. ||
    917|| `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. ||
    1018|| `enum` || Maps integer IDs for issues' priorities, severities, etc. to human-readable names. ||
    1119|| `milestone` || Project milestones. ||
    1220|| `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. ||
    1422|| `report` || Stores the SQL to generate canned database reports. ||
    1523|| `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  ||
    1927|| `ticket` || Tickets. ||
    2028|| `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. ||
     
    2634#!div class=important
    2735TODO: add 0.12 tables
    28  - cache
     36 - ~~cache~~
    2937 - repository
    3038}}}