ports/123905: [PATCH] devel/otrs: update to 2.2.6
Philip M. Gollucci
pgollucci at p6m7g8.com
Thu May 22 16:10:03 UTC 2008
>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 at 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
+ at dirrm otrs/Kernel/cpan-lib/Net/POP3
+ at dirrm otrs/Kernel/cpan-lib/Net/IMAP/Simple
+ at dirrm otrs/Kernel/cpan-lib/Net/IMAP
+ at 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
+ at 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
+ at dirrm otrs/Kernel/System/Queue
@dirrm otrs/Kernel/System/PostMaster/LoopProtection
@dirrm otrs/Kernel/System/PostMaster/Filter
@dirrm otrs/Kernel/System/PostMaster
+ at 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:
More information about the freebsd-ports-bugs
mailing list