1
-- ----------------------------------------------------------
2
-- database: mssql, generated: Mon Aug 28 00:13:30 2006
3
-- ----------------------------------------------------------
4
ALTER TABLE valid ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
5
ALTER TABLE valid ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
6
ALTER TABLE ticket_priority ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
7
ALTER TABLE ticket_priority ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
8
ALTER TABLE ticket_lock_type ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
9
ALTER TABLE ticket_lock_type ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
10
ALTER TABLE ticket_lock_type ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
11
ALTER TABLE system_user ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
12
ALTER TABLE system_user ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
13
ALTER TABLE system_user ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
14
ALTER TABLE user_preferences ADD FOREIGN KEY (user_id) REFERENCES `system_user(id)`;
15
ALTER TABLE groups ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
16
ALTER TABLE groups ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
17
ALTER TABLE groups ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
18
ALTER TABLE group_user ADD FOREIGN KEY (group_id) REFERENCES `groups(id)`;
19
ALTER TABLE group_user ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
20
ALTER TABLE group_user ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
21
ALTER TABLE group_user ADD FOREIGN KEY (user_id) REFERENCES `system_user(id)`;
22
ALTER TABLE group_role ADD FOREIGN KEY (role_id) REFERENCES `roles(id)`;
23
ALTER TABLE group_role ADD FOREIGN KEY (group_id) REFERENCES `groups(id)`;
24
ALTER TABLE group_role ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
25
ALTER TABLE group_role ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
26
ALTER TABLE group_customer_user ADD FOREIGN KEY (group_id) REFERENCES `groups(id)`;
27
ALTER TABLE group_customer_user ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
28
ALTER TABLE group_customer_user ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
29
ALTER TABLE roles ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
30
ALTER TABLE roles ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
31
ALTER TABLE roles ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
32
ALTER TABLE role_user ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
33
ALTER TABLE role_user ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
34
ALTER TABLE role_user ADD FOREIGN KEY (user_id) REFERENCES `system_user(id)`;
35
ALTER TABLE personal_queues ADD FOREIGN KEY (queue_id) REFERENCES `queue(id)`;
36
ALTER TABLE personal_queues ADD FOREIGN KEY (user_id) REFERENCES `system_user(id)`;
37
ALTER TABLE theme ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
38
ALTER TABLE theme ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
39
ALTER TABLE theme ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
40
ALTER TABLE ticket_state ADD FOREIGN KEY (type_id) REFERENCES `ticket_state_type(id)`;
41
ALTER TABLE ticket_state ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
42
ALTER TABLE ticket_state ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
43
ALTER TABLE ticket_state ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
44
ALTER TABLE ticket_state_type ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
45
ALTER TABLE ticket_state_type ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
46
ALTER TABLE salutation ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
47
ALTER TABLE salutation ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
48
ALTER TABLE salutation ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
49
ALTER TABLE signature ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
50
ALTER TABLE signature ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
51
ALTER TABLE signature ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
52
ALTER TABLE system_address ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
53
ALTER TABLE system_address ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
54
ALTER TABLE system_address ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
55
ALTER TABLE follow_up_possible ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
56
ALTER TABLE follow_up_possible ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
57
ALTER TABLE follow_up_possible ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
58
ALTER TABLE queue ADD FOREIGN KEY (salutation_id) REFERENCES `salutation(id)`;
59
ALTER TABLE queue ADD FOREIGN KEY (signature_id) REFERENCES `signature(id)`;
60
ALTER TABLE queue ADD FOREIGN KEY (group_id) REFERENCES `groups(id)`;
61
ALTER TABLE queue ADD FOREIGN KEY (follow_up_id) REFERENCES `follow_up_possible(id)`;
62
ALTER TABLE queue ADD FOREIGN KEY (system_address_id) REFERENCES `system_address(id)`;
63
ALTER TABLE queue ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
64
ALTER TABLE queue ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
65
ALTER TABLE queue ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
66
ALTER TABLE ticket ADD FOREIGN KEY (ticket_lock_id) REFERENCES `ticket_lock_type(id)`;
67
ALTER TABLE ticket ADD FOREIGN KEY (ticket_state_id) REFERENCES `ticket_state(id)`;
68
ALTER TABLE ticket ADD FOREIGN KEY (ticket_priority_id) REFERENCES `ticket_priority(id)`;
69
ALTER TABLE ticket ADD FOREIGN KEY (queue_id) REFERENCES `queue(id)`;
70
ALTER TABLE ticket ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
71
ALTER TABLE ticket ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
72
ALTER TABLE ticket ADD FOREIGN KEY (user_id) REFERENCES `system_user(id)`;
73
ALTER TABLE ticket ADD FOREIGN KEY (responsible_user_id) REFERENCES `system_user(id)`;
74
ALTER TABLE ticket ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
75
ALTER TABLE ticket_history ADD FOREIGN KEY (priority_id) REFERENCES `ticket_priority(id)`;
76
ALTER TABLE ticket_history ADD FOREIGN KEY (owner_id) REFERENCES `system_user(id)`;
77
ALTER TABLE ticket_history ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
78
ALTER TABLE ticket_history ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
79
ALTER TABLE ticket_history ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
80
ALTER TABLE ticket_history ADD FOREIGN KEY (state_id) REFERENCES `ticket_state(id)`;
81
ALTER TABLE ticket_history ADD FOREIGN KEY (history_type_id) REFERENCES `ticket_history_type(id)`;
82
ALTER TABLE ticket_history ADD FOREIGN KEY (article_id) REFERENCES `article(id)`;
83
ALTER TABLE ticket_history ADD FOREIGN KEY (queue_id) REFERENCES `queue(id)`;
84
ALTER TABLE ticket_history ADD FOREIGN KEY (ticket_id) REFERENCES `ticket(id)`;
85
ALTER TABLE ticket_history_type ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
86
ALTER TABLE ticket_history_type ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
87
ALTER TABLE ticket_history_type ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
88
ALTER TABLE article_type ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
89
ALTER TABLE article_type ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
90
ALTER TABLE article_type ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
91
ALTER TABLE article_sender_type ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
92
ALTER TABLE article_sender_type ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
93
ALTER TABLE article_sender_type ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
94
ALTER TABLE article_flag ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
95
ALTER TABLE article ADD FOREIGN KEY (article_sender_type_id) REFERENCES `article_sender_type(id)`;
96
ALTER TABLE article ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
97
ALTER TABLE article ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
98
ALTER TABLE article ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
99
ALTER TABLE article ADD FOREIGN KEY (article_type_id) REFERENCES `article_type(id)`;
100
ALTER TABLE article ADD FOREIGN KEY (ticket_id) REFERENCES `ticket(id)`;
101
ALTER TABLE article_plain ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
102
ALTER TABLE article_plain ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
103
ALTER TABLE article_plain ADD FOREIGN KEY (article_id) REFERENCES `article(id)`;
104
ALTER TABLE article_attachment ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
105
ALTER TABLE article_attachment ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
106
ALTER TABLE article_attachment ADD FOREIGN KEY (article_id) REFERENCES `article(id)`;
107
ALTER TABLE standard_response ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
108
ALTER TABLE standard_response ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
109
ALTER TABLE standard_response ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
110
ALTER TABLE queue_standard_response ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
111
ALTER TABLE queue_standard_response ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
112
ALTER TABLE queue_standard_response ADD FOREIGN KEY (standard_response_id) REFERENCES `standard_response(id)`;
113
ALTER TABLE queue_standard_response ADD FOREIGN KEY (queue_id) REFERENCES `queue(id)`;
114
ALTER TABLE standard_attachment ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
115
ALTER TABLE standard_attachment ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
116
ALTER TABLE standard_attachment ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
117
ALTER TABLE standard_response_attachment ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
118
ALTER TABLE standard_response_attachment ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
119
ALTER TABLE standard_response_attachment ADD FOREIGN KEY (standard_response_id) REFERENCES `standard_response(id)`;
120
ALTER TABLE standard_response_attachment ADD FOREIGN KEY (standard_attachment_id) REFERENCES `standard_attachment(id)`;
121
ALTER TABLE auto_response_type ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
122
ALTER TABLE auto_response_type ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
123
ALTER TABLE auto_response_type ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
124
ALTER TABLE auto_response ADD FOREIGN KEY (type_id) REFERENCES `auto_response_type(id)`;
125
ALTER TABLE auto_response ADD FOREIGN KEY (system_address_id) REFERENCES `system_address(id)`;
126
ALTER TABLE auto_response ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
127
ALTER TABLE auto_response ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
128
ALTER TABLE auto_response ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
129
ALTER TABLE queue_auto_response ADD FOREIGN KEY (auto_response_id) REFERENCES `auto_response(id)`;
130
ALTER TABLE queue_auto_response ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
131
ALTER TABLE queue_auto_response ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
132
ALTER TABLE queue_auto_response ADD FOREIGN KEY (queue_id) REFERENCES `queue(id)`;
133
ALTER TABLE time_accounting ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
134
ALTER TABLE time_accounting ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
135
ALTER TABLE time_accounting ADD FOREIGN KEY (article_id) REFERENCES `article(id)`;
136
ALTER TABLE time_accounting ADD FOREIGN KEY (ticket_id) REFERENCES `ticket(id)`;
137
ALTER TABLE customer_user ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
138
ALTER TABLE customer_user ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
139
ALTER TABLE customer_user ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
140
ALTER TABLE pop3_account ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
141
ALTER TABLE pop3_account ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
142
ALTER TABLE pop3_account ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
143
ALTER TABLE notifications ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
144
ALTER TABLE notifications ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
145
ALTER TABLE package_repository ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
146
ALTER TABLE package_repository ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;