From owner-freebsd-ports-bugs@FreeBSD.ORG Thu May 22 16:10:03 2008 Return-Path: Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 3DEC0106567E for ; Thu, 22 May 2008 16:10:03 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id 104068FC26 for ; Thu, 22 May 2008 16:10:03 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.14.2/8.14.2) with ESMTP id m4MGA2Du003650 for ; Thu, 22 May 2008 16:10:02 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.2/8.14.1/Submit) id m4MGA2kK003649; Thu, 22 May 2008 16:10:02 GMT (envelope-from gnats) Resent-Date: Thu, 22 May 2008 16:10:02 GMT Resent-Message-Id: <200805221610.m4MGA2kK003649@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, "Philip M. Gollucci" Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 3D18E1065678; Thu, 22 May 2008 16:09:29 +0000 (UTC) (envelope-from pgollucci@piccollo.p6m7g8.net) Received: from piccollo.p6m7g8.net (piccollo.p6m7g8.net [70.88.236.19]) by mx1.freebsd.org (Postfix) with ESMTP id BA42E8FC15; Thu, 22 May 2008 16:09:28 +0000 (UTC) (envelope-from pgollucci@piccollo.p6m7g8.net) Received: from piccollo.p6m7g8.net (localhost.p6m7g8.net [127.0.0.1]) by piccollo.p6m7g8.net (8.14.2/8.14.2) with ESMTP id m4MG9G05003781 (version=TLSv1/SSLv3 cipher=DHE-DSS-AES256-SHA bits=256 verify=NO); Thu, 22 May 2008 12:09:17 -0400 (EDT) (envelope-from pgollucci@piccollo.p6m7g8.net) Received: (from pgollucci@localhost) by piccollo.p6m7g8.net (8.14.2/8.14.3/Submit) id m4MG9G52003780; Thu, 22 May 2008 12:09:16 -0400 (EDT) (envelope-from pgollucci) Message-Id: <200805221609.m4MG9G52003780@piccollo.p6m7g8.net> Date: Thu, 22 May 2008 12:09:16 -0400 (EDT) From: "Philip M. Gollucci" To: FreeBSD-gnats-submit@FreeBSD.org X-Send-Pr-Version: 3.113 Cc: skv@FreeBSD.org Subject: ports/123905: [PATCH] devel/otrs: update to 2.2.6 X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 22 May 2008 16:10:03 -0000 >Number: 123905 >Category: ports >Synopsis: [PATCH] devel/otrs: update to 2.2.6 >Confidential: no >Severity: non-critical >Priority: low >Responsible: freebsd-ports-bugs >State: open >Quarter: >Keywords: >Date-Required: >Class: update >Submitter-Id: current-users >Arrival-Date: Thu May 22 16:10:02 UTC 2008 >Closed-Date: >Last-Modified: >Originator: Philip M. Gollucci >Release: FreeBSD 8.0-CURRENT i386 >Organization: Riderway Inc. >Environment: System: FreeBSD piccollo.p6m7g8.net 8.0-CURRENT FreeBSD 8.0-CURRENT #1: Sun Mar 2 09:48:59 EST >Description: - Update to 2.2.6 Added file(s): - files/extra-patch-scripts__database__otrs-schema-post.mysql.sql Port maintainer (skv@FreeBSD.org) is cc'd. OTRS 2.3 will be published in 74 days. I use OTRS for $work, so I can take MAINTAINER if wanted. Generated with FreeBSD Port Tools 0.77 >How-To-Repeat: >Fix: --- otrs-2.2.6.patch begins here --- Index: Makefile =================================================================== RCS file: /home/ncvs/ports/devel/otrs/Makefile,v retrieving revision 1.15 diff -u -u -r1.15 Makefile --- Makefile 29 Jan 2008 06:12:42 -0000 1.15 +++ Makefile 22 May 2008 16:06:44 -0000 @@ -6,7 +6,7 @@ # PORTNAME= otrs -PORTVERSION= 2.2.5 +PORTVERSION= 2.2.6 CATEGORIES= devel MASTER_SITES= http://ftp.otrs.org/pub/otrs/ \ ftp://ftp.samurai.com/pub/otrs/ \ @@ -104,6 +104,11 @@ RUN_DEPENDS+= gpg:${PORTSDIR}/security/gnupg1 .endif +post-patch: +.ifdef WITH_MYSQL + @(cd ${WRKSRC} ; ${PATCH} < ${FILESDIR}/extra-patch-scripts__database__otrs-schema-post.mysql.sql) +.endif + do-build: @${FIND} ${WRKSRC} -name "*.orig" -delete @${FIND} ${WRKSRC}/Kernel -type d | ${XARGS} ${CHMOD} 0755 Index: distinfo =================================================================== RCS file: /home/ncvs/ports/devel/otrs/distinfo,v retrieving revision 1.8 diff -u -u -r1.8 distinfo --- distinfo 29 Jan 2008 06:12:42 -0000 1.8 +++ distinfo 22 May 2008 16:06:44 -0000 @@ -1,3 +1,3 @@ -MD5 (otrs-2.2.5.tar.bz2) = 8cf859e35cd50ee2b65e934a62f64fcd -SHA256 (otrs-2.2.5.tar.bz2) = 50a1df63b6a35bdffa78055a31a45e94fe4ab3956b274200e36e9c697344851b -SIZE (otrs-2.2.5.tar.bz2) = 10354041 +MD5 (otrs-2.2.6.tar.bz2) = a43cae76902a4959d4bbe25002ebba0d +SHA256 (otrs-2.2.6.tar.bz2) = 7ec9520391066ec1156d2659b9c59f14428b379ff2a23dcf02e4df7963659853 +SIZE (otrs-2.2.6.tar.bz2) = 10640789 Index: pkg-plist =================================================================== RCS file: /home/ncvs/ports/devel/otrs/pkg-plist,v retrieving revision 1.8 diff -u -u -r1.8 pkg-plist --- pkg-plist 29 Jan 2008 06:12:42 -0000 1.8 +++ pkg-plist 22 May 2008 16:06:44 -0000 @@ -223,6 +223,7 @@ otrs/Kernel/Language/ru.pm otrs/Kernel/Language/sk_SK.pm otrs/Kernel/Language/sv.pm +otrs/Kernel/Language/tr.pm otrs/Kernel/Language/vi_VN.pm otrs/Kernel/Language/xx_AgentZoom.pm otrs/Kernel/Language/xx_Custom.pm @@ -540,6 +541,7 @@ otrs/Kernel/System/DB/oracle.pm otrs/Kernel/System/DB/postgresql.pm otrs/Kernel/System/Email.pm +otrs/Kernel/System/Email/DoNotSendEmail.pm otrs/Kernel/System/Email/SMTP.pm otrs/Kernel/System/Email/Sendmail.pm otrs/Kernel/System/EmailParser.pm @@ -627,6 +629,10 @@ otrs/Kernel/System/XML.pm otrs/Kernel/System/XMLMaster.pm otrs/Kernel/cpan-lib/HTML/Safe.pm +@dirrm otrs/Kernel/cpan-lib/Net/POP3 +@dirrm otrs/Kernel/cpan-lib/Net/IMAP/Simple +@dirrm otrs/Kernel/cpan-lib/Net/IMAP +@dirrm otrs/Kernel/cpan-lib/Net @dirrm otrs/Kernel/cpan-lib/HTML @dirrm otrs/Kernel/cpan-lib @dirrm otrs/Kernel/System/XMLMaster @@ -639,13 +645,16 @@ @dirrm otrs/Kernel/System/Ticket/IndexAccelerator @dirrm otrs/Kernel/System/Ticket/Event @dirrm otrs/Kernel/System/Ticket/CustomerPermission +@dirrm otrs/Kernel/System/Ticket/Acl @dirrm otrs/Kernel/System/Ticket @dirrm otrs/Kernel/System/Stats/Dynamic @dirrm otrs/Kernel/System/Stats/Static @dirrm otrs/Kernel/System/Stats +@dirrm otrs/Kernel/System/Queue @dirrm otrs/Kernel/System/PostMaster/LoopProtection @dirrm otrs/Kernel/System/PostMaster/Filter @dirrm otrs/Kernel/System/PostMaster +@dirrm otrs/Kernel/System/MailAccount @dirrm otrs/Kernel/System/Log @dirrm otrs/Kernel/System/LinkObject @dirrm otrs/Kernel/System/GenericAgent Index: files/extra-patch-scripts__database__otrs-schema-post.mysql.sql =================================================================== RCS file: files/extra-patch-scripts__database__otrs-schema-post.mysql.sql diff -N files/extra-patch-scripts__database__otrs-schema-post.mysql.sql --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ files/extra-patch-scripts__database__otrs-schema-post.mysql.sql 22 May 2008 16:06:02 -0000 @@ -0,0 +1,318 @@ +--- ./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-2.2.6.patch ends here --- >Release-Note: >Audit-Trail: >Unformatted: