Edgewall Software

Changes between Version 11 and Version 12 of TracDev/DatabaseSchema


Ignore:
Timestamp:
Mar 11, 2012, 7:28:34 PM (10 years ago)
Author:
Peter Suter
Comment:

Link to ./Attachments subpage

Legend:

Unmodified
Added
Removed
Modified
  • TracDev/DatabaseSchema

    v11 v12  
    1212
    1313|| '''Table Name''' || '''Purpose''' ||
    14 || `attachment` || Descriptions of attachments (the files themselves are stored on disk). ||
    15 || [./Common#Tableauthcookie auth_cookie] || User login cookies. ||
     14|| [./Attachments#Tableattachment attachment] || Descriptions of attachments (the files themselves are stored on disk). ||
     15|| [./Common#Tableauth_cookie auth_cookie] || User login cookies. ||
    1616|| [./Common#Tablecache cache] || Synchronization table for process- and thread-local caches. ||
    1717|| `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. ||
     
    2323|| `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. ||
    2424|| [./Common#Tablesession session] || Last user visit time. ||
    25 || [./Common#Tablesessionattribute session_attribute] || Information about user settings, including name, email, and diff options. ||
     25|| [./Common#Tablesession_attribute session_attribute] || Information about user settings, including name, email, and diff options. ||
    2626|| [./Common#Tablesystem system] || System information such as the database version and repository cache metadata  ||
    2727|| `ticket` || Tickets. ||