1 ALTER TABLE Links ADD FOREIGN KEY (LocalBase) REFERENCES Tickets(id) ;
2 ALTER TABLE Links ADD FOREIGN KEY (LocalTarget) REFERENCES Tickets(id);
3 ALTER TABLE Tickets ADD FOREIGN KEY (Queue) REFERENCES Queues(id);
4 ALTER TABLE Tickets ADD FOREIGN KEY (EffectiveId) REFERENCES Tickets(id);
5 ALTER TABLE Tickets ADD FOREIGN KEY (Owner) REFERENCES Principals(id);
6 ALTER TABLE Tickets ADD FOREIGN KEY (Creator) REFERENCES Users(id);
7 ALTER TABLE Tickets ADD FOREIGN KEY (LastUpdatedBy) REFERENCES Users(id);
8 ALTER TABLE Transactions ADD FOREIGN KEY (Creator) REFERENCES Users(id);
9 ALTER TABLE Transactions ADD FOREIGN KEY (Ticket) REFERENCES Tickets(id);
10 ALTER TABLE Transactions ADD FOREIGN KEY (EffectiveTicket) REFERENCES Tickets(id);
11 ALTER TABLE Attachments ADD FOREIGN KEY (TransactionId) REFERENCES Transactions(id);
12 ALTER TABLE Attachments ADD FOREIGN KEY (Parent) REFERENCES Attachments(id);
13 ALTER TABLE Scrips ADD FOREIGN KEY (ScripCondition) REFERENCES ScripConditions(id);
14 ALTER TABLE Scrips ADD FOREIGN KEY (ScripAction) REFERENCES ScripActions(id);
15 ALTER TABLE Scrips ADD FOREIGN KEY (Template) REFERENCES Templates(id);
16 ALTER TABLE Scrips ADD FOREIGN KEY (Queue) REFERENCES Queues(id);
17 ALTER TABLE Scrips ADD FOREIGN KEY (Creator) REFERENCES Users(id);
18 ALTER TABLE Scrips ADD FOREIGN KEY (LastUpdatedBy) REFERENCES Users(id);
19 ALTER TABLE ACL ADD FOREIGN KEY (PrincipalId) REFERENCES Principals(id);
20 ALTER TABLE ACL ADD FOREIGN KEY (DelegatedBy) REFERENCES Principals(id);
21 ALTER TABLE ACL ADD FOREIGN KEY (DelegatedFrom) REFERENCES ACL(id);
22 ALTER TABLE GroupMembers ADD FOREIGN KEY (GroupId) REFERENCES Groups(id);
23 ALTER TABLE GroupMembers ADD FOREIGN KEY (MemberId) REFERENCES Principals(id);
24 ALTER TABLE CachedGroupMembers ADD FOREIGN KEY (ImmediateParentId) REFERENCES Principals(id);
25 ALTER TABLE CachedGroupMembers ADD FOREIGN KEY (GroupId) REFERENCES Principals(id);
26 ALTER TABLE CachedGroupMembers ADD FOREIGN KEY (MemberId) REFERENCES Principals(id);
27 ALTER TABLE CachedGroupMembers ADD FOREIGN KEY (Via) REFERENCES CachedGroupMembers(id);
28 ALTER TABLE ScripActions ADD FOREIGN KEY (Creator) REFERENCES Users(id);
29 ALTER TABLE ScripActions ADD FOREIGN KEY (LastUpdatedBy) REFERENCES Users(id);
30 ALTER TABLE Templates ADD FOREIGN KEY (Queue) REFERENCES Queues(id);
31 ALTER TABLE Templates ADD FOREIGN KEY (Creator) REFERENCES Users(id);
32 ALTER TABLE Templates ADD FOREIGN KEY (LastUpdatedBy) REFERENCES Users(id);
33 ALTER TABLE CustomFields ADD FOREIGN KEY (Queue) REFERENCES Queues(id);
34 ALTER TABLE CustomFields ADD FOREIGN KEY (Creator) REFERENCES Users(id);
35 ALTER TABLE CustomFields ADD FOREIGN KEY (LastUpdatedBy) REFERENCES Users(id);
36 ALTER TABLE TicketCustomFieldValues ADD FOREIGN KEY (Ticket) REFERENCES Tickets(id);
37 ALTER TABLE TicketCustomFieldValues ADD FOREIGN KEY (CustomField) REFERENCES CustomFields(id);
38 ALTER TABLE TicketCustomFieldValues ADD FOREIGN KEY (Creator) REFERENCES Users(id);
39 ALTER TABLE TicketCustomFieldValues ADD FOREIGN KEY (LastUpdatedBy) REFERENCES Users(id);
40 ALTER TABLE CustomFieldValues ADD FOREIGN KEY (CustomField) REFERENCES CustomFields(id);
41 ALTER TABLE CustomFieldValues ADD FOREIGN KEY (Creator) REFERENCES Users(id);
42 ALTER TABLE CustomFieldValues ADD FOREIGN KEY (LastUpdatedBy) REFERENCES Users(id);