-----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@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`);
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Philip M. Gollucci wrote: | 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. If would help more if I updated the generated and sent that -- svn diff Index: Kernel/System/DB/mysql.pm =================================================================== - --- Kernel/System/DB/mysql.pm (revision 9224) +++ Kernel/System/DB/mysql.pm (working copy) @@ -397,7 +397,7 @@ ~ } ~ my $SQL = "ALTER TABLE $Param{LocalTableName} ADD FOREIGN KEY ("; ~ $SQL .= "$Param{Local}) REFERENCES "; - - $SQL .= "`$Param{ForeignTableName}`(`$Param{Foreign}`)"; + $SQL .= "`$Param{ForeignTableName}($Param{Foreign})`"; ~ # return SQL ~ return ($SQL); ~ } - -- - ------------------------------------------------------------------------ Philip M. Gollucci (philip@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 iD8DBQFINbiddbiP+9ubjBwRAuE4AJ0UUYjEfrO7ivbBIX1cKb1cDw8ujgCfZInW xAetWwhVQc5leZECDG7Obbw= =zJo9 -----END PGP SIGNATURE-----
Hi Philip, On May 22, 2008, at 20:17 , Philip M. Gollucci wrote:
| 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.
If would help more if I updated the generated and sent that --
Cool! :) Many thanks for feedback. One question. Would it also work on your MySQL 5.1 with my $SQL = "ALTER TABLE $Param{LocalTableName} ADD FOREIGN KEY ("; $SQL .= "$Param{Local}) REFERENCES "; $SQL .= "$Param{ForeignTableName} ($Param{Foreign})"; (without all "`")? Many thanks for feedback! :) -Martin -- ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! Address of record: Bad Homburg Local Court: Bad Homburg, HRB 10751 Tax number: 003/240/97505 Chairman: Burchard Steinbild Chief Executive Officer: André Mindermann
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Martin Edenhofer wrote: | Many thanks for feedback. One question. Would it also work on your MySQL | 5.1 with | | my $SQL =ALTER TABLE $Param{LocalTableName} ADD FOREIGN KEY ("; | $SQL .=$Param{Local}) REFERENCES "; | $SQL .=$Param{ForeignTableName} ($Param{Foreign})"; Of course, the 2 are equivalent. At any rate, I actually tested it too.... You only need the `` if you use characters reserved in SQL, table_names, column_names, etc... - -- - ------------------------------------------------------------------------ Philip M. Gollucci (philip@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 iD8DBQFINb8ddbiP+9ubjBwRArx/AJ492SgIOiUumVLbA6y4KGzuBtK1HQCfb0OK SLbcrQgrNNEGSZS4268uSV0= =Cu9f -----END PGP SIGNATURE-----
Hi Philip, On May 22, 2008, at 20:44 , Philip M. Gollucci wrote:
| Many thanks for feedback. One question. Would it also work on your MySQL | 5.1 with | | my $SQL =ALTER TABLE $Param{LocalTableName} ADD FOREIGN KEY ("; | $SQL .=$Param{Local}) REFERENCES "; | $SQL .=$Param{ForeignTableName} ($Param{Foreign})"; Of course, the 2 are equivalent. At any rate, I actually tested it too.... You only need the `` if you use characters reserved in SQL, table_names, column_names, etc...
Many thanks for feedback! Cool! I also think it's not a good idea to use characters reserved in SQL. :) So we will remove the ` and it will be available in 2.2.7 and higher. Any comments? -Martin -- ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! Address of record: Bad Homburg Local Court: Bad Homburg, HRB 10751 Tax number: 003/240/97505 Chairman: Burchard Steinbild Chief Executive Officer: André Mindermann
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Martin Edenhofer wrote: | I also think it's not a good idea to use characters reserved in SQL. :) | | So we will remove the ` and it will be available in 2.2.7 and higher. Sounds good to me. - -- - ------------------------------------------------------------------------ Philip M. Gollucci (philip@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 iD8DBQFINcD3dbiP+9ubjBwRAu/PAJ9gMreTdwKYp9aKyU84oxRYlApfFwCfVzqK V54bQpOtUUXQMLULcOFV1J4= =ptJj -----END PGP SIGNATURE-----
Hi Philip, I tried to fix it but I saw it's already fixed for upcoming 2.2.7 and higher. :) -> http://bugs.otrs.org/show_bug.cgi?id=2882 Both, .sql and .pm file. PS: http://riderway.com looks really cool. :) Greetings, -Martin On May 22, 2008, at 20:52 , Philip M. Gollucci wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Martin Edenhofer wrote: | I also think it's not a good idea to use characters reserved in SQL. :) | | So we will remove the ` and it will be available in 2.2.7 and higher. Sounds good to me.
- -- - ------------------------------------------------------------------------ Philip M. Gollucci (philip@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
iD8DBQFINcD3dbiP+9ubjBwRAu/PAJ9gMreTdwKYp9aKyU84oxRYlApfFwCfVzqK V54bQpOtUUXQMLULcOFV1J4= =ptJj -----END PGP SIGNATURE----- _______________________________________________ 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
Hello Martin and Philip, If I were you, I'd keep the apostrophes ( ` )... it is simply a matter of prudence and avoiding clashes with possible future MySQL keywords: it's not only reserved characters, but everything that could have a meaning somewhere. BTW, considering that there are already table names with underscores (which is a special character...), you are pretty much obliged to keep them. Additionally readability gets better. On the other I do appreciate the difficulties in handling string delimiters in code :-/. BTW, just fyi: the (wrong) syntax was working so far because the foreign key part was simply ignored by MySQL for MyISAM tables (and the statements produced plain indexes). If you switched to a foreign key aware engine (e.g. like InnoDB), MySQL (5.0) complained. Maybe 5.1 got a little more picky on the syntax... Regards, Gilles Martin Edenhofer wrote:
Hi Philip,
I tried to fix it but I saw it's already fixed for upcoming 2.2.7 and higher. :)
-> http://bugs.otrs.org/show_bug.cgi?id=2882
Both, .sql and .pm file.
Hi Gilles Many thanks for your feedback!
If I were you, I'd keep the apostrophes ( ` )... it is simply a matter of prudence and avoiding clashes with possible future MySQL keywords
You're right. But OTRS doesn't use reserved words of ALL supported databases (MySQL, MSSQL, Oracle, ...). I think, apostrophes are not necessary in the .sql files. BTW: We doesn't use apostrophes in ALL .SQL files. If we implemented the apostrophes in the otrs-schema-post.mysql.sql file, we must also implemented the apostrophes in all other database-SQL-files. Best regards, Manuel Hecht ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0)9421 56818 0 :: Fax: +49 (0)9421 56818 18 http://www.otrs.com/ :: Communication with success! -----Ursprüngliche Nachricht----- Von: dev-bounces@otrs.org [mailto:dev-bounces@otrs.org] Im Auftrag von Gilles Massen Gesendet: Donnerstag, 22. Mai 2008 21:56 An: Development community of OTRS.org Betreff: Re: [dev] MySQL 5.1 fixes Hello Martin and Philip, If I were you, I'd keep the apostrophes ( ` )... it is simply a matter of prudence and avoiding clashes with possible future MySQL keywords: it's not only reserved characters, but everything that could have a meaning somewhere. BTW, considering that there are already table names with underscores (which is a special character...), you are pretty much obliged to keep them. Additionally readability gets better. On the other I do appreciate the difficulties in handling string delimiters in code :-/. BTW, just fyi: the (wrong) syntax was working so far because the foreign key part was simply ignored by MySQL for MyISAM tables (and the statements produced plain indexes). If you switched to a foreign key aware engine (e.g. like InnoDB), MySQL (5.0) complained. Maybe 5.1 got a little more picky on the syntax... Regards, Gilles Martin Edenhofer wrote:
Hi Philip,
I tried to fix it but I saw it's already fixed for upcoming 2.2.7 and higher. :)
-> http://bugs.otrs.org/show_bug.cgi?id=2882
Both, .sql and .pm file.
_______________________________________________ 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
Hi Gilles Many thanks for your feedback!
If I were you, I'd keep the apostrophes ( ` )... it is simply a matter of prudence and avoiding clashes with possible future MySQL keywords
You're right. But OTRS doesn't use reserved words of ALL supported databases (MySQL, MSSQL, Oracle, ...). I think, apostrophes are not necessary in the .sql files. BTW: We doesn't use apostrophes in ALL .SQL files. If we implemented the apostrophes in the otrs-schema-post.mysql.sql file, we must also implemented the apostrophes in all other database-SQL-files. Best regards, Manuel Hecht ((otrs)) :: OTRS AG :: Europaring 4 :: D - 94315 Straubing Fon: +49 (0)9421 56818 0 :: Fax: +49 (0)9421 56818 18 http://www.otrs.com/ :: Communication with success! -----Ursprüngliche Nachricht----- Von: dev-bounces@otrs.org [mailto:dev-bounces@otrs.org] Im Auftrag von Gilles Massen Gesendet: Donnerstag, 22. Mai 2008 21:56 An: Development community of OTRS.org Betreff: Re: [dev] MySQL 5.1 fixes Hello Martin and Philip, If I were you, I'd keep the apostrophes ( ` )... it is simply a matter of prudence and avoiding clashes with possible future MySQL keywords: it's not only reserved characters, but everything that could have a meaning somewhere. BTW, considering that there are already table names with underscores (which is a special character...), you are pretty much obliged to keep them. Additionally readability gets better. On the other I do appreciate the difficulties in handling string delimiters in code :-/. BTW, just fyi: the (wrong) syntax was working so far because the foreign key part was simply ignored by MySQL for MyISAM tables (and the statements produced plain indexes). If you switched to a foreign key aware engine (e.g. like InnoDB), MySQL (5.0) complained. Maybe 5.1 got a little more picky on the syntax... Regards, Gilles Martin Edenhofer wrote:
Hi Philip,
I tried to fix it but I saw it's already fixed for upcoming 2.2.7 and higher. :)
-> http://bugs.otrs.org/show_bug.cgi?id=2882
Both, .sql and .pm file.
_______________________________________________ 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
participants (4)
-
Gilles Massen -
Manuel Hecht - OTRS AG -
Martin Edenhofer -
Philip M. Gollucci