[Trac-tickets] Re: [The Trac Project] #1242: [ER] Generalized automatic cross-references in Trac

[The Trac Project]

#1242: [ER] Generalized automatic cross-references in Trac
-------------------------+--------------------------------------------------
       Id:  1242         |      Status:  new                     
Component:  general      |    Modified:  Thu Mar  3 05:43:27 2005
 Severity:  enhancement  |   Milestone:                          
 Priority:  normal       |     Version:  0.8                     
    Owner:  jonas        |    Reporter:  cboos at bct-technology.com
-------------------------+--------------------------------------------------
Comment (by cmlenz):

 Yeah, this has been discussed before.

 In the {{{xref}}} table, separate source type from source id, and context
 type from context id (would "dest" be a better name?), for quicker lookup:

 {{{
 CREATE TABLE xref (
     src_type    string,
     src_id      string,
     dest_type   string,
     dest_id     string,
     title       string
     relation    string
 );
 }}}

 I've added a {{{relation}}} column here, which would be optional. This
 could be used for things like ticket dependencies. So you'd have both
 implicit backlinks (normal links in wiki text) and explicit relations
 (such as ticket dependencies) in the same table, which makes sense IMHO.

-- 
Ticket URL: <http://projects.edgewall.com/trac/ticket/1242>
The Trac Project <>