3 files changed, 3 insertions, 186 deletions

diff --git a/www/rt38/Makefile b/www/rt38/Makefile
index d275fb672ad0..1901006896a3 100644
--- a/www/rt38/Makefile
+++ b/www/rt38/Makefile
@@ -12,8 +12,7 @@
 #   o install a sample into etc/apache22/Includes
 
 PORTNAME=	rt
-PORTVERSION=	3.8.10
-PORTREVISION=	3
+PORTVERSION=	3.8.11
 CATEGORIES=	www
 MASTER_SITES=	http://download.bestpractical.com/pub/rt/release/ \
 		ftp://ftp.eu.uu.net/pub/unix/ticketing/rt/release/
diff --git a/www/rt38/distinfo b/www/rt38/distinfo
index 3f4feada4066..f6a07a40bf91 100644
--- a/www/rt38/distinfo
+++ b/www/rt38/distinfo
@@ -1,2 +1,2 @@
-SHA256 (rt-3.8.10.tar.gz) = d121ec6463ce919cef74c3ce3ab7e7213cb235726d05abd26c717a7eab6c1448
-SIZE (rt-3.8.10.tar.gz) = 5642566
+SHA256 (rt-3.8.11.tar.gz) = 76b5b631ef6fb5f2c3f94cc1a1774046998ef157d83f68c274a2dfa8e71f89a8
+SIZE (rt-3.8.11.tar.gz) = 5734246
diff --git a/www/rt38/files/patch-etc__schema.mysql-4.1 b/www/rt38/files/patch-etc__schema.mysql-4.1
deleted file mode 100644
index b9d7ff4e27a9..000000000000
--- a/www/rt38/files/patch-etc__schema.mysql-4.1
+++ /dev/null
@@ -1,182 +0,0 @@
---- ./etc/schema.mysql-4.1.orig	2011-04-18 01:15:20.000000000 +0200
-+++ ./etc/schema.mysql-4.1	2011-04-18 01:15:41.000000000 +0200
-@@ -14,7 +14,7 @@
-   Creator integer NOT NULL DEFAULT 0  ,
-   Created DATETIME NULL  ,
-   PRIMARY KEY (id)
--) TYPE=InnoDB  CHARACTER SET utf8;
-+) ENGINE=InnoDB  CHARACTER SET utf8;
- 
- CREATE INDEX Attachments2 ON Attachments (TransactionId) ;
- CREATE INDEX Attachments3 ON Attachments (Parent, TransactionId) ;
-@@ -36,7 +36,7 @@
-   LastUpdated DATETIME NULL  ,
-   Disabled int2 NOT NULL DEFAULT 0 ,
-   PRIMARY KEY (id)
--) TYPE=InnoDB CHARACTER SET utf8;
-+) ENGINE=InnoDB CHARACTER SET utf8;
- 
- CREATE UNIQUE INDEX Queues1 ON Queues (Name) ;
- CREATE INDEX Queues2 ON Queues (Disabled) ;
-@@ -57,7 +57,7 @@
-   Creator integer NOT NULL DEFAULT 0  ,
-   Created DATETIME NULL  ,
-   PRIMARY KEY (id)
--) TYPE=InnoDB CHARACTER SET ascii;
-+) ENGINE=InnoDB CHARACTER SET ascii;
- 
- CREATE INDEX Links2 ON Links (Base,  Type) ;
- CREATE INDEX Links3 ON Links (Target,  Type) ;
-@@ -73,7 +73,7 @@
-         ObjectId integer, # foreign key to Users or Groups, depending
-         Disabled int2 NOT NULL DEFAULT 0 ,
-         PRIMARY KEY (id)
--) TYPE=InnoDB CHARACTER SET ascii;
-+) ENGINE=InnoDB CHARACTER SET ascii;
- 
- CREATE INDEX Principals2 ON Principals (ObjectId);
- 
-@@ -89,7 +89,7 @@
-   Type varchar(64) CHARACTER SET ascii NULL,
-   Instance integer,
-   PRIMARY KEY (id)
--) TYPE=InnoDB CHARACTER SET utf8;
-+) ENGINE=InnoDB CHARACTER SET utf8;
- 
- CREATE INDEX Groups1 ON Groups (Domain,Instance,Type,id);
- CREATE INDEX Groups2 On Groups (Type, Instance);   
-@@ -111,7 +111,7 @@
-   LastUpdatedBy integer NOT NULL DEFAULT 0  ,
-   LastUpdated DATETIME NULL  ,
-   PRIMARY KEY (id)
--) TYPE=InnoDB CHARACTER SET utf8;
-+) ENGINE=InnoDB CHARACTER SET utf8;
- 
- # }}}
- 
-@@ -133,7 +133,7 @@
-   Creator integer NOT NULL DEFAULT 0  ,
-   Created DATETIME NULL  ,
-   PRIMARY KEY (id)
--) TYPE=InnoDB CHARACTER SET utf8;
-+) ENGINE=InnoDB CHARACTER SET utf8;
- 
- CREATE INDEX Transactions1 ON Transactions (ObjectType, ObjectId);
- 
-@@ -159,7 +159,7 @@
-   LastUpdatedBy integer NOT NULL DEFAULT 0  ,
-   LastUpdated DATETIME NULL  ,
-   PRIMARY KEY (id)
--) TYPE=InnoDB CHARACTER SET utf8;
-+) ENGINE=InnoDB CHARACTER SET utf8;
- 
- # }}}
- 
-@@ -175,7 +175,7 @@
-   DelegatedBy integer NOT NULL default 0, #foreign key to principals with a userid
-   DelegatedFrom integer NOT NULL default 0, #foreign key to ACL
-   PRIMARY KEY (id)
--) TYPE=InnoDB CHARACTER SET utf8;
-+) ENGINE=InnoDB CHARACTER SET utf8;
- 
- CREATE INDEX  ACL1 on ACL(RightName, ObjectType, ObjectId,PrincipalType,PrincipalId);
- 
-@@ -188,7 +188,7 @@
-   GroupId integer NOT NULL DEFAULT 0,
-   MemberId integer NOT NULL DEFAULT 0,  #Foreign key to Principals
-   PRIMARY KEY (id)
--) TYPE=InnoDB CHARACTER SET utf8;
-+) ENGINE=InnoDB CHARACTER SET utf8;
- CREATE UNIQUE INDEX GroupMembers1 on GroupMembers (GroupId, MemberId);
- 
- 
-@@ -210,7 +210,7 @@
-                                            # group members recursively.
-                                            # Also, this allows us to have the ACL system elide members of disabled groups
-         PRIMARY KEY (id)
--) TYPE=InnoDB CHARACTER SET utf8;
-+) ENGINE=InnoDB CHARACTER SET utf8;
- 
- CREATE INDEX DisGrouMem  on CachedGroupMembers (GroupId,MemberId,Disabled);
- CREATE INDEX CachedGroupMembers3 on CachedGroupMembers (MemberId, ImmediateParentId);
-@@ -256,7 +256,7 @@
-   LastUpdatedBy integer NOT NULL DEFAULT 0  ,
-   LastUpdated DATETIME NULL  ,
-   PRIMARY KEY (id)
--) TYPE=InnoDB CHARACTER SET utf8;
-+) ENGINE=InnoDB CHARACTER SET utf8;
- 
- 
- CREATE UNIQUE INDEX Users1 ON Users (Name) ;
-@@ -296,7 +296,7 @@
-   Created DATETIME NULL  ,
-   Disabled int2 NOT NULL DEFAULT 0 ,
-   PRIMARY KEY (id)
--) TYPE=InnoDB CHARACTER SET utf8;
-+) ENGINE=InnoDB CHARACTER SET utf8;
- 
- CREATE INDEX Tickets1 ON Tickets (Queue, Status) ;
- CREATE INDEX Tickets2 ON Tickets (Owner) ;
-@@ -317,7 +317,7 @@
-   LastUpdatedBy integer NOT NULL DEFAULT 0  ,
-   LastUpdated DATETIME NULL  ,
-   PRIMARY KEY (id)
--) TYPE=InnoDB CHARACTER SET utf8;
-+) ENGINE=InnoDB CHARACTER SET utf8;
- 
- # }}}
- 
-@@ -337,7 +337,7 @@
-   Creator integer NOT NULL DEFAULT 0  ,
-   Created DATETIME NULL  ,
-   PRIMARY KEY (id)
--) TYPE=InnoDB CHARACTER SET utf8;
-+) ENGINE=InnoDB CHARACTER SET utf8;
- 
- # }}}
- 
-@@ -361,7 +361,7 @@
-   LastUpdated DATETIME NULL  ,
-   Disabled int2 NOT NULL DEFAULT 0 ,        # New -- whether the value was current
-   PRIMARY KEY (id)
--) TYPE=InnoDB CHARACTER SET utf8;
-+) ENGINE=InnoDB CHARACTER SET utf8;
- 
- CREATE INDEX ObjectCustomFieldValues1 ON ObjectCustomFieldValues (Content); 
- CREATE INDEX ObjectCustomFieldValues2 ON ObjectCustomFieldValues (CustomField,ObjectType,ObjectId); 
-@@ -387,7 +387,7 @@
-   LastUpdated DATETIME NULL  ,
-   Disabled int2 NOT NULL DEFAULT 0 ,
-   PRIMARY KEY (id)
--) TYPE=InnoDB CHARACTER SET utf8;
-+) ENGINE=InnoDB CHARACTER SET utf8;
- 
- # }}}
- 
-@@ -404,7 +404,7 @@
-   LastUpdatedBy integer NOT NULL DEFAULT 0  ,
-   LastUpdated DATETIME NULL  ,
-   PRIMARY KEY (id)
--) TYPE=InnoDB CHARACTER SET utf8;
-+) ENGINE=InnoDB CHARACTER SET utf8;
- 
- # }}}
- 
-@@ -422,7 +422,7 @@
-   LastUpdatedBy integer NOT NULL DEFAULT 0  ,
-   LastUpdated DATETIME NULL  ,
-   PRIMARY KEY (id)
--) TYPE=InnoDB CHARACTER SET utf8;
-+) ENGINE=InnoDB CHARACTER SET utf8;
- 
- CREATE INDEX CustomFieldValues1 ON CustomFieldValues (CustomField);
-  
-@@ -444,7 +444,7 @@
-   LastUpdatedBy integer NOT NULL DEFAULT 0  ,
-   LastUpdated DATETIME NULL  ,
-   PRIMARY KEY (id)
--) TYPE=InnoDB CHARACTER SET utf8;
-+) ENGINE=InnoDB CHARACTER SET utf8;
- 
- CREATE INDEX Attributes1 on Attributes(Name);
- CREATE INDEX Attributes2 on Attributes(ObjectType, ObjectId);