-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all,
http://www.freebsd.org/cgi/query-pr.cgi?pr=123905 The attached patch is required to have the ALTER statements parse as vaild SQL. I guess this must be a MySQL 5.1 thing since it looks like MySQL 5.0 is the primary testing location. It is back-compatible. - -- - ------------------------------------------------------------------------ Philip M. Gollucci ([EMAIL PROTECTED]) o:703.549.2050x206 Senior System Admin - Riderway, Inc. http://riderway.com / http://ridecharge.com 1024D/DB9B8C1C B90B FBC3 A3A1 C71A 8E70 3F8C 75B8 8FFB DB9B 8C1C Work like you don't need the money, love like you'll never get hurt, and dance like nobody's watching. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.8 (FreeBSD) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFINaNEdbiP+9ubjBwRAn15AJ9mlp1Ip3MXeNtSWqLnsi3NSUbFjwCcDy3B reH+b5luChgN1KD4H/XwwSY= =RWX5 -----END PGP SIGNATURE-----
--- ./scripts/database/otrs-schema-post.mysql.sql.orig 2008-05-21 18:58:03.000000000 +0000 +++ ./scripts/database/otrs-schema-post.mysql.sql 2008-05-22 15:48:31.000000000 +0000 @@ -1,159 +1,159 @@ # ---------------------------------------------------------- # driver: mysql, generated: 2007-06-12 16:52:19 # ---------------------------------------------------------- -ALTER TABLE valid ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE valid ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_priority ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_priority ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_type ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_type ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_type ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE ticket_lock_type ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_lock_type ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_lock_type ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE system_user ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE system_user ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE system_user ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE user_preferences ADD FOREIGN KEY (user_id) REFERENCES `system_user(id)`; -ALTER TABLE groups ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE groups ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE groups ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE group_user ADD FOREIGN KEY (group_id) REFERENCES `groups(id)`; -ALTER TABLE group_user ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE group_user ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE group_user ADD FOREIGN KEY (user_id) REFERENCES `system_user(id)`; -ALTER TABLE group_role ADD FOREIGN KEY (role_id) REFERENCES `roles(id)`; -ALTER TABLE group_role ADD FOREIGN KEY (group_id) REFERENCES `groups(id)`; -ALTER TABLE group_role ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE group_role ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE group_customer_user ADD FOREIGN KEY (group_id) REFERENCES `groups(id)`; -ALTER TABLE group_customer_user ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE group_customer_user ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE roles ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE roles ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE roles ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE role_user ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE role_user ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE role_user ADD FOREIGN KEY (user_id) REFERENCES `system_user(id)`; -ALTER TABLE personal_queues ADD FOREIGN KEY (queue_id) REFERENCES `queue(id)`; -ALTER TABLE personal_queues ADD FOREIGN KEY (user_id) REFERENCES `system_user(id)`; -ALTER TABLE theme ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE theme ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE theme ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE ticket_state ADD FOREIGN KEY (type_id) REFERENCES `ticket_state_type(id)`; -ALTER TABLE ticket_state ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_state ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_state ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE ticket_state_type ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_state_type ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE salutation ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE salutation ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE salutation ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE signature ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE signature ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE signature ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE system_address ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE system_address ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE system_address ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE follow_up_possible ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE follow_up_possible ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE follow_up_possible ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE queue ADD FOREIGN KEY (salutation_id) REFERENCES `salutation(id)`; -ALTER TABLE queue ADD FOREIGN KEY (signature_id) REFERENCES `signature(id)`; -ALTER TABLE queue ADD FOREIGN KEY (group_id) REFERENCES `groups(id)`; -ALTER TABLE queue ADD FOREIGN KEY (follow_up_id) REFERENCES `follow_up_possible(id)`; -ALTER TABLE queue ADD FOREIGN KEY (system_address_id) REFERENCES `system_address(id)`; -ALTER TABLE queue ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE queue ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE queue ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (ticket_lock_id) REFERENCES `ticket_lock_type(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (ticket_priority_id) REFERENCES `ticket_priority(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (user_id) REFERENCES `system_user(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (responsible_user_id) REFERENCES `system_user(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (service_id) REFERENCES `service(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (sla_id) REFERENCES `sla(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (ticket_state_id) REFERENCES `ticket_state(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (queue_id) REFERENCES `queue(id)`; -ALTER TABLE ticket ADD FOREIGN KEY (type_id) REFERENCES `ticket_type(id)`; -ALTER TABLE ticket_history ADD FOREIGN KEY (priority_id) REFERENCES `ticket_priority(id)`; -ALTER TABLE ticket_history ADD FOREIGN KEY (owner_id) REFERENCES `system_user(id)`; -ALTER TABLE ticket_history ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_history ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_history ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE ticket_history ADD FOREIGN KEY (state_id) REFERENCES `ticket_state(id)`; -ALTER TABLE ticket_history ADD FOREIGN KEY (history_type_id) REFERENCES `ticket_history_type(id)`; -ALTER TABLE ticket_history ADD FOREIGN KEY (article_id) REFERENCES `article(id)`; -ALTER TABLE ticket_history ADD FOREIGN KEY (queue_id) REFERENCES `queue(id)`; -ALTER TABLE ticket_history ADD FOREIGN KEY (type_id) REFERENCES `ticket_type(id)`; -ALTER TABLE ticket_history ADD FOREIGN KEY (ticket_id) REFERENCES `ticket(id)`; -ALTER TABLE ticket_history_type ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_history_type ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE ticket_history_type ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE article_type ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE article_type ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE article_type ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE article_sender_type ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE article_sender_type ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE article_sender_type ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE article_flag ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE article ADD FOREIGN KEY (article_sender_type_id) REFERENCES `article_sender_type(id)`; -ALTER TABLE article ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE article ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE article ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE article ADD FOREIGN KEY (article_type_id) REFERENCES `article_type(id)`; -ALTER TABLE article ADD FOREIGN KEY (ticket_id) REFERENCES `ticket(id)`; -ALTER TABLE article_plain ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE article_plain ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE article_plain ADD FOREIGN KEY (article_id) REFERENCES `article(id)`; -ALTER TABLE article_attachment ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE article_attachment ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE article_attachment ADD FOREIGN KEY (article_id) REFERENCES `article(id)`; -ALTER TABLE standard_response ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE standard_response ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE standard_response ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE queue_standard_response ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE queue_standard_response ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE queue_standard_response ADD FOREIGN KEY (standard_response_id) REFERENCES `standard_response(id)`; -ALTER TABLE queue_standard_response ADD FOREIGN KEY (queue_id) REFERENCES `queue(id)`; -ALTER TABLE standard_attachment ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE standard_attachment ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE standard_attachment ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE standard_response_attachment ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE standard_response_attachment ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE standard_response_attachment ADD FOREIGN KEY (standard_response_id) REFERENCES `standard_response(id)`; -ALTER TABLE standard_response_attachment ADD FOREIGN KEY (standard_attachment_id) REFERENCES `standard_attachment(id)`; -ALTER TABLE auto_response_type ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE auto_response_type ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE auto_response_type ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE auto_response ADD FOREIGN KEY (type_id) REFERENCES `auto_response_type(id)`; -ALTER TABLE auto_response ADD FOREIGN KEY (system_address_id) REFERENCES `system_address(id)`; -ALTER TABLE auto_response ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE auto_response ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE auto_response ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE queue_auto_response ADD FOREIGN KEY (auto_response_id) REFERENCES `auto_response(id)`; -ALTER TABLE queue_auto_response ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE queue_auto_response ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE queue_auto_response ADD FOREIGN KEY (queue_id) REFERENCES `queue(id)`; -ALTER TABLE time_accounting ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE time_accounting ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE time_accounting ADD FOREIGN KEY (article_id) REFERENCES `article(id)`; -ALTER TABLE time_accounting ADD FOREIGN KEY (ticket_id) REFERENCES `ticket(id)`; -ALTER TABLE service ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE service ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE service_customer_user ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE sla ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE sla ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE sla ADD FOREIGN KEY (service_id) REFERENCES `service(id)`; -ALTER TABLE customer_user ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE customer_user ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE customer_user ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE pop3_account ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE pop3_account ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE pop3_account ADD FOREIGN KEY (valid_id) REFERENCES `valid(id)`; -ALTER TABLE notifications ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE notifications ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; -ALTER TABLE package_repository ADD FOREIGN KEY (create_by) REFERENCES `system_user(id)`; -ALTER TABLE package_repository ADD FOREIGN KEY (change_by) REFERENCES `system_user(id)`; +ALTER TABLE valid ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE valid ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_priority ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_priority ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_type ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_type ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_type ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE ticket_lock_type ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_lock_type ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_lock_type ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE system_user ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE system_user ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE system_user ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE user_preferences ADD FOREIGN KEY (user_id) REFERENCES `system_user`(`id`); +ALTER TABLE groups ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE groups ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE groups ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE group_user ADD FOREIGN KEY (group_id) REFERENCES `groups`(`id`); +ALTER TABLE group_user ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE group_user ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE group_user ADD FOREIGN KEY (user_id) REFERENCES `system_user`(`id`); +ALTER TABLE group_role ADD FOREIGN KEY (role_id) REFERENCES `roles`(`id`); +ALTER TABLE group_role ADD FOREIGN KEY (group_id) REFERENCES `groups`(`id`); +ALTER TABLE group_role ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE group_role ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE group_customer_user ADD FOREIGN KEY (group_id) REFERENCES `groups`(`id`); +ALTER TABLE group_customer_user ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE group_customer_user ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE roles ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE roles ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE roles ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE role_user ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE role_user ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE role_user ADD FOREIGN KEY (user_id) REFERENCES `system_user`(`id`); +ALTER TABLE personal_queues ADD FOREIGN KEY (queue_id) REFERENCES `queue`(`id`); +ALTER TABLE personal_queues ADD FOREIGN KEY (user_id) REFERENCES `system_user`(`id`); +ALTER TABLE theme ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE theme ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE theme ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE ticket_state ADD FOREIGN KEY (type_id) REFERENCES `ticket_state_type`(`id`); +ALTER TABLE ticket_state ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_state ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_state ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE ticket_state_type ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_state_type ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE salutation ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE salutation ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE salutation ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE signature ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE signature ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE signature ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE system_address ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE system_address ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE system_address ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE follow_up_possible ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE follow_up_possible ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE follow_up_possible ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE queue ADD FOREIGN KEY (salutation_id) REFERENCES `salutation`(`id`); +ALTER TABLE queue ADD FOREIGN KEY (signature_id) REFERENCES `signature`(`id`); +ALTER TABLE queue ADD FOREIGN KEY (group_id) REFERENCES `groups`(`id`); +ALTER TABLE queue ADD FOREIGN KEY (follow_up_id) REFERENCES `follow_up_possible`(`id`); +ALTER TABLE queue ADD FOREIGN KEY (system_address_id) REFERENCES `system_address`(`id`); +ALTER TABLE queue ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE queue ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE queue ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (ticket_lock_id) REFERENCES `ticket_lock_type`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (ticket_priority_id) REFERENCES `ticket_priority`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (user_id) REFERENCES `system_user`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (responsible_user_id) REFERENCES `system_user`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (service_id) REFERENCES `service`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (sla_id) REFERENCES `sla`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (ticket_state_id) REFERENCES `ticket_state`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (queue_id) REFERENCES `queue`(`id`); +ALTER TABLE ticket ADD FOREIGN KEY (type_id) REFERENCES `ticket_type`(`id`); +ALTER TABLE ticket_history ADD FOREIGN KEY (priority_id) REFERENCES `ticket_priority`(`id`); +ALTER TABLE ticket_history ADD FOREIGN KEY (owner_id) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_history ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_history ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_history ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE ticket_history ADD FOREIGN KEY (state_id) REFERENCES `ticket_state`(`id`); +ALTER TABLE ticket_history ADD FOREIGN KEY (history_type_id) REFERENCES `ticket_history_type`(`id`); +ALTER TABLE ticket_history ADD FOREIGN KEY (article_id) REFERENCES `article`(`id`); +ALTER TABLE ticket_history ADD FOREIGN KEY (queue_id) REFERENCES `queue`(`id`); +ALTER TABLE ticket_history ADD FOREIGN KEY (type_id) REFERENCES `ticket_type`(`id`); +ALTER TABLE ticket_history ADD FOREIGN KEY (ticket_id) REFERENCES `ticket`(`id`); +ALTER TABLE ticket_history_type ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_history_type ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE ticket_history_type ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE article_type ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE article_type ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE article_type ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE article_sender_type ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE article_sender_type ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE article_sender_type ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE article_flag ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE article ADD FOREIGN KEY (article_sender_type_id) REFERENCES `article_sender_type`(`id`); +ALTER TABLE article ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE article ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE article ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE article ADD FOREIGN KEY (article_type_id) REFERENCES `article_type`(`id`); +ALTER TABLE article ADD FOREIGN KEY (ticket_id) REFERENCES `ticket`(`id`); +ALTER TABLE article_plain ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE article_plain ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE article_plain ADD FOREIGN KEY (article_id) REFERENCES `article`(`id`); +ALTER TABLE article_attachment ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE article_attachment ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE article_attachment ADD FOREIGN KEY (article_id) REFERENCES `article`(`id`); +ALTER TABLE standard_response ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE standard_response ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE standard_response ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE queue_standard_response ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE queue_standard_response ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE queue_standard_response ADD FOREIGN KEY (standard_response_id) REFERENCES `standard_response`(`id`); +ALTER TABLE queue_standard_response ADD FOREIGN KEY (queue_id) REFERENCES `queue`(`id`); +ALTER TABLE standard_attachment ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE standard_attachment ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE standard_attachment ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE standard_response_attachment ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE standard_response_attachment ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE standard_response_attachment ADD FOREIGN KEY (standard_response_id) REFERENCES `standard_response`(`id`); +ALTER TABLE standard_response_attachment ADD FOREIGN KEY (standard_attachment_id) REFERENCES `standard_attachment`(`id`); +ALTER TABLE auto_response_type ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE auto_response_type ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE auto_response_type ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE auto_response ADD FOREIGN KEY (type_id) REFERENCES `auto_response_type`(`id`); +ALTER TABLE auto_response ADD FOREIGN KEY (system_address_id) REFERENCES `system_address`(`id`); +ALTER TABLE auto_response ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE auto_response ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE auto_response ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE queue_auto_response ADD FOREIGN KEY (auto_response_id) REFERENCES `auto_response`(`id`); +ALTER TABLE queue_auto_response ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE queue_auto_response ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE queue_auto_response ADD FOREIGN KEY (queue_id) REFERENCES `queue`(`id`); +ALTER TABLE time_accounting ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE time_accounting ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE time_accounting ADD FOREIGN KEY (article_id) REFERENCES `article`(`id`); +ALTER TABLE time_accounting ADD FOREIGN KEY (ticket_id) REFERENCES `ticket`(`id`); +ALTER TABLE service ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE service ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE service_customer_user ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE sla ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE sla ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE sla ADD FOREIGN KEY (service_id) REFERENCES `service`(`id`); +ALTER TABLE customer_user ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE customer_user ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE customer_user ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE pop3_account ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE pop3_account ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE pop3_account ADD FOREIGN KEY (valid_id) REFERENCES `valid`(`id`); +ALTER TABLE notifications ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE notifications ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`); +ALTER TABLE package_repository ADD FOREIGN KEY (create_by) REFERENCES `system_user`(`id`); +ALTER TABLE package_repository ADD FOREIGN KEY (change_by) REFERENCES `system_user`(`id`);
_______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
