70
70
ALTER TABLE ticket ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`;
71
71
ALTER TABLE ticket ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`;
72
72
ALTER TABLE ticket ADD FOREIGN KEY (user_id) REFERENCES `system_user(id)`;
73
74
ALTER TABLE ticket ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`;
74
75
ALTER TABLE ticket_history ADD FOREIGN KEY (priority_id) REFERENCES `ticket_priority(id)`;
75
76
ALTER TABLE ticket_history ADD FOREIGN KEY (owner_id) REFERENCES `system_user(id)`;