Edgewall Software
Modify ↓

Opened 20 years ago

Closed 20 years ago

Last modified 16 years ago

#826 closed defect (worksforme)

database does not make use of foreign keys

Reported by: anonymous Owned by: Jonas Borgström
Priority: normal Milestone:
Component: ticket system Version: devel
Severity: normal Keywords: database foreign keys
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description (last modified by Christopher Lenz)

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").

Attachments (0)

Change History (2)

comment:1 by Christopher Lenz, 20 years ago

Description: modified (diff)
Resolution: → worksforme
Status: new → closed

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

comment:2 by Remy Blank, 16 years ago

#5733 was closed as a duplicate.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Jonas Borgström.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from Jonas Borgström to the specified user.

Add Comment
E-mail address and name can be saved in the Preferences .
Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.