Edgewall Software

Changes between Version 16 and Version 17 of TracDev/DatabaseSchema


Ignore:
Timestamp:
Jul 27, 2015, 9:37:14 PM (4 years ago)
Author:
figaro
Comment:

Cosmetic changes

Legend:

Unmodified
Added
Removed
Modified
  • TracDev/DatabaseSchema

    v16 v17  
    1 = Trac Database Schema =
     1[[PageOutline(2-5,Contents,pullout)]]
     2
     3= Trac Database Schema
    24
    35The database schema is defined in [source:/trunk/trac/db_default.py trac.db_default], along with the initial contents of the database. The schema includes the tables listed below.
    46
    5 == Overview ==
     7== Overview
     8
    69* [./Common]
    710* [./Attachments]
     
    1316
    1417|| '''Table Name''' || '''Purpose''' ||
    15 || [./Attachments#Tableattachment attachment] || Descriptions of attachments (the files themselves are stored on disk). ||
     18|| [./Attachments#Tableattachment attachment] || Descriptions of attachments, the files themselves are stored on disk. ||
    1619|| [./Common#Tableauth_cookie auth_cookie] || User login cookies. ||
    1720|| [./Common#Tablecache cache] || Synchronization table for process- and thread-local caches. ||
    18 || [./TicketSystem#Tablecomponent 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. ||
     21|| [./TicketSystem#Tablecomponent 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. ||
    1922|| [./TicketSystem#Tableenum enum] || Maps integer IDs for issues' priorities, severities, etc. to human-readable names. ||
    2023|| [./TicketSystem#Tablemilestone milestone] || Project milestones. ||
    21 || [./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. ||
     24|| [./VersionControl#Tablenode_change node_change] || First half of the repository cache: for every changeset (as identified by the revision number), this table contains the nodes (files or directories) that have been added, modified or deleted. ||
    2225||[./NotificationSystem#Tablenotify_subscription notify_subscription] || User preferences for notification subscriptions. ||
    23 || [./Common#Tablepermission permission] || Username/action pairs describing who's allowed to do what. This table's contents also hold permission groups. ||
     26|| [./Common#Tablepermission permission] || Username/action pairs describing who is allowed to do what. This table's contents also hold permission groups. ||
    2427|| [./ReportSystem#Tablereport report] || Stores the SQL to generate canned database reports. ||
    2528|| [./VersionControl#Tablerepository repository] || Stores cached and configured repository properties. ||
    26 || [./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. ||
     29|| [./VersionControl#Tablerevision revision] || Second 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. ||
    2730|| [./Common#Tablesession session] || Last user visit time. ||
    2831|| [./Common#Tablesession_attribute session_attribute] || Information about user settings, including name, email, and diff options. ||
    29 || [./Common#Tablesystem system] || System information such as the database version and repository cache metadata  ||
     32|| [./Common#Tablesystem system] || System information such as the database version and repository cache metadata.  ||
    3033|| [./TicketSystem#Tableticket ticket] || Tickets. ||
    31 || [./TicketSystem#Tableticket_change 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. ||
     34|| [./TicketSystem#Tableticket_change 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. ||
    3235|| [./TicketSystem#Tableticket_custom ticket_custom] || The values of custom ticket fields. ||
    3336|| [./TicketSystem#Tableversion 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. ||
    34 || [./WikiSystem#Tablewiki wiki] || Wiki pages (including old revisions). ||
     37|| [./WikiSystem#Tablewiki wiki] || Wiki pages, including old revisions. ||
    3538
    36 == Database Schema 0.11 ==
     39== Database Schema Trac 0.11
     40
    3741[[Image(trac-schema-v2.png)]]
    3842
    3943Note that some of the pictured relations are not "true" relations in the traditional relational meaning. Also, there's no "real" user table. The particular cases are explained in the embedded notes.
    4044
    41 ''This schema is incomplete, for Trac [milestone:0.12].''
     45This schema is incomplete and Trac 0.11 is no longer supported.
    4246
    43 == Database Schema 0.12 ==
     47== Database Schema Trac 0.12
     48
    4449[[Image(db_trac_eng_final.png)]]
    4550
    46 ''This schema is not reviewed and "validated" by trac devs''
     51This schema is not reviewed or validated by Trac developers.
    4752
    4853----