diff options
| author | cvs2git <cvs2git> | 2004-04-07 09:08:35 +0000 |
|---|---|---|
| committer | cvs2git <cvs2git> | 2004-04-07 09:08:35 +0000 |
| commit | 022491d9d2723ca4d7d0718cdb1fd67e7652428e (patch) | |
| tree | fc1e50c0d78ecc401ef2214a6a11ee07242be0f8 /rt/etc/constraints.mysql | |
| parent | 35effa1bf4ac902547615c816960bbc8db8e7256 (diff) | |
This commit was manufactured by cvs2svn to create tag 'NET_WHOIS_RAW_0_31'.NET_WHOIS_RAW_0_31
Diffstat (limited to 'rt/etc/constraints.mysql')
| -rw-r--r-- | rt/etc/constraints.mysql | 42 |
1 files changed, 0 insertions, 42 deletions
diff --git a/rt/etc/constraints.mysql b/rt/etc/constraints.mysql deleted file mode 100644 index fd557d5e4..000000000 --- a/rt/etc/constraints.mysql +++ /dev/null @@ -1,42 +0,0 @@ - ALTER TABLE Links ADD FOREIGN KEY (LocalBase) REFERENCES Tickets(id) ; - ALTER TABLE Links ADD FOREIGN KEY (LocalTarget) REFERENCES Tickets(id); - ALTER TABLE Tickets ADD FOREIGN KEY (Queue) REFERENCES Queues(id); - ALTER TABLE Tickets ADD FOREIGN KEY (EffectiveId) REFERENCES Tickets(id); - ALTER TABLE Tickets ADD FOREIGN KEY (Owner) REFERENCES Principals(id); - ALTER TABLE Tickets ADD FOREIGN KEY (Creator) REFERENCES Users(id); - ALTER TABLE Tickets ADD FOREIGN KEY (LastUpdatedBy) REFERENCES Users(id); - ALTER TABLE Transactions ADD FOREIGN KEY (Creator) REFERENCES Users(id); - ALTER TABLE Transactions ADD FOREIGN KEY (Ticket) REFERENCES Tickets(id); - ALTER TABLE Transactions ADD FOREIGN KEY (EffectiveTicket) REFERENCES Tickets(id); - ALTER TABLE Attachments ADD FOREIGN KEY (TransactionId) REFERENCES Transactions(id); - ALTER TABLE Attachments ADD FOREIGN KEY (Parent) REFERENCES Attachments(id); - ALTER TABLE Scrips ADD FOREIGN KEY (ScripCondition) REFERENCES ScripConditions(id); - ALTER TABLE Scrips ADD FOREIGN KEY (ScripAction) REFERENCES ScripActions(id); - ALTER TABLE Scrips ADD FOREIGN KEY (Template) REFERENCES Templates(id); - ALTER TABLE Scrips ADD FOREIGN KEY (Queue) REFERENCES Queues(id); - ALTER TABLE Scrips ADD FOREIGN KEY (Creator) REFERENCES Users(id); - ALTER TABLE Scrips ADD FOREIGN KEY (LastUpdatedBy) REFERENCES Users(id); - ALTER TABLE ACL ADD FOREIGN KEY (PrincipalId) REFERENCES Principals(id); - ALTER TABLE ACL ADD FOREIGN KEY (DelegatedBy) REFERENCES Principals(id); - ALTER TABLE ACL ADD FOREIGN KEY (DelegatedFrom) REFERENCES ACL(id); - ALTER TABLE GroupMembers ADD FOREIGN KEY (GroupId) REFERENCES Groups(id); - ALTER TABLE GroupMembers ADD FOREIGN KEY (MemberId) REFERENCES Principals(id); - ALTER TABLE CachedGroupMembers ADD FOREIGN KEY (ImmediateParentId) REFERENCES Principals(id); - ALTER TABLE CachedGroupMembers ADD FOREIGN KEY (GroupId) REFERENCES Principals(id); - ALTER TABLE CachedGroupMembers ADD FOREIGN KEY (MemberId) REFERENCES Principals(id); - ALTER TABLE CachedGroupMembers ADD FOREIGN KEY (Via) REFERENCES CachedGroupMembers(id); - ALTER TABLE ScripActions ADD FOREIGN KEY (Creator) REFERENCES Users(id); - ALTER TABLE ScripActions ADD FOREIGN KEY (LastUpdatedBy) REFERENCES Users(id); - ALTER TABLE Templates ADD FOREIGN KEY (Queue) REFERENCES Queues(id); - ALTER TABLE Templates ADD FOREIGN KEY (Creator) REFERENCES Users(id); - ALTER TABLE Templates ADD FOREIGN KEY (LastUpdatedBy) REFERENCES Users(id); - ALTER TABLE CustomFields ADD FOREIGN KEY (Queue) REFERENCES Queues(id); - ALTER TABLE CustomFields ADD FOREIGN KEY (Creator) REFERENCES Users(id); - ALTER TABLE CustomFields ADD FOREIGN KEY (LastUpdatedBy) REFERENCES Users(id); - ALTER TABLE TicketCustomFieldValues ADD FOREIGN KEY (Ticket) REFERENCES Tickets(id); - ALTER TABLE TicketCustomFieldValues ADD FOREIGN KEY (CustomField) REFERENCES CustomFields(id); - ALTER TABLE TicketCustomFieldValues ADD FOREIGN KEY (Creator) REFERENCES Users(id); - ALTER TABLE TicketCustomFieldValues ADD FOREIGN KEY (LastUpdatedBy) REFERENCES Users(id); - ALTER TABLE CustomFieldValues ADD FOREIGN KEY (CustomField) REFERENCES CustomFields(id); - ALTER TABLE CustomFieldValues ADD FOREIGN KEY (Creator) REFERENCES Users(id); - ALTER TABLE CustomFieldValues ADD FOREIGN KEY (LastUpdatedBy) REFERENCES Users(id); |
