Edgewall Software

Changes between Initial Version and Version 1 of TracDev/DatabaseSchema/ReportSystem


Ignore:
Timestamp:
Mar 11, 2012, 10:24:23 PM (10 years ago)
Author:
Peter Suter
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • TracDev/DatabaseSchema/ReportSystem

    v1 v1  
     1[[PageOutline(2)]]
     2
     3= Trac Database Schema: Report System
     4
     5TracReports use just a single database table.
     6
     7== Table `report`
     8||'''Table'''||'''Key'''||
     9||''report''||''id''||
     10
     11||'''Columns'''||'''Type'''||
     12||''id''||`auto_increment`||
     13||''author''|| ||
     14||''title''|| ||
     15||''query''|| ||
     16||''description''|| ||
     17
     18Stores the report SQL queries and associated metadata.
     19
     20Trac initializes this table with the default reports during installation.
     21
     22See [browser:trunk/trac/ticket/report.py trac.ticket.report.ReportModule]