[Trac-tickets] Re: [The Trac Project] #826: database does not make use of foreign keys

[The Trac Project]

#826: database does not make use of foreign keys
---------------------------+------------------------------------------------
       Id:  826            |      Status:  closed                  
Component:  ticket system  |    Modified:  Wed Mar  2 18:38:09 2005
 Severity:  normal         |   Milestone:                          
 Priority:  normal         |     Version:  devel                   
    Owner:  jonas          |    Reporter:  anonymous               
---------------------------+------------------------------------------------
Changes (by cmlenz):

  * resolution:  => worksforme
  * status:  new => closed

Old description:

> It looks like the ticket table recreates information that is kept in
> other tables.  For example, the milestone table contains all the
> milestones entered in the system.  The ticket table should reference the
> milestone text from the milestone table rather than entering the text
> itself (i.e. reference it by id 2 rather than entering the text
> "milestone1").

New description:

 It looks like the ticket table recreates information that is kept in other
 tables.  For example, the milestone table contains all the milestones
 entered in the system.  The ticket table should reference the milestone
 text from the milestone table rather than entering the text itself (i.e.
 reference it by id 2 rather than entering the text "milestone1").

Comment:

 Implementation detail. The actual functional restriction is better tracked
 by #880.

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