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

Timestamp:

Mar 11, 2012, 10:24:23 PM (12 years ago)

Author:

Peter Suter

Comment:

—

TracDev/DatabaseSchema/ReportSystem

@@ +1 @@
+[[PageOutline(2)]]
+
+= Trac Database Schema: Report System
+
+TracReports use just a single database table.
+
+== Table `report`
+||'''Table'''||'''Key'''||
+||''report''||''id''||
+
+||'''Columns'''||'''Type'''||
+||''id''||`auto_increment`||
+||''author''|| ||
+||''title''|| ||
+||''query''|| ||
+||''description''|| ||
+
+Stores the report SQL queries and associated metadata.
+
+Trac initializes this table with the default reports during installation.
+
+See [browser:trunk/trac/ticket/report.py trac.ticket.report.ReportModule]