June 2008 - dev - OTRS mailing lists

MySQL 5.1 fixes
by Philip M. Gollucci 03 Jun '08

03 Jun '08

-----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 (philip(a)ridecharge.com) 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`);

4 9

Time Units - Normal- vs. Overtime
by Sune T. Tougaard 03 Jun '08

03 Jun '08

Hi, Have tried on the user list but it doesn't appear to be an issue over there. Perhaps you can help? I'd like to "expand" the "Time Units" field when handling tickets. My users have a need to distinguish between normal time used on a ticket and overtime used. (for billing and statistical purposes, for example) I'm imagining that it's a fairly simple thing to do, but i have no idea how to, as i'm really not a coder. Just another time field called Overtime, or something. Of course, the values typed in should be "viewable" in reports and stats and so on, just like the time units is today. Is it as simple as i think it is? Have also had a look at the "Time Accounting" module, but... I just didn't get it. And it seems a bit overkill for what i need. Thanks. -- /Sune

1 0

Missing 2.3 branch in bugzilla ?
by Yann Richard 02 Jun '08

02 Jun '08

Hi, I have posted bug for otrs 2.3.0 beta 1 but there is no specific version for this new branch in the bugtracker I have posted it as CVS. it's good for you ? the bug: http://bugs.otrs.org/show_bug.cgi?id=2940 Regards, -- M. Yann Richard yann.richard on gmail.com

2 1