- update to 3.8.10 [1]

- make rt-setup-database work with mysql 5.5 [2]

Security:	bf171509-68dd-11e0-afe6-0003ba02bf30 [1]
Submitted by:	n j nino80@gmail.com [2]

4 files changed, 193 insertions, 3 deletions

diff --git a/www/rt38/Makefile b/www/rt38/Makefile
index c9763ae6ace6..302025fe32d7 100644
--- a/www/rt38/Makefile
+++ b/www/rt38/Makefile
@@ -12,7 +12,7 @@
 #   o install a sample into etc/apache22/Includes
 
 PORTNAME=	rt
-PORTVERSION=	3.8.9
+PORTVERSION=	3.8.10
 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 33df4fbd46bc..3f4feada4066 100644
--- a/www/rt38/distinfo
+++ b/www/rt38/distinfo
@@ -1,2 +1,2 @@
-SHA256 (rt-3.8.9.tar.gz) = 8ba7e7d79e025ed20d25aa126059cccd6a7875ff56f6f7be18fb5f3e67a41e11
-SIZE (rt-3.8.9.tar.gz) = 5212874
+SHA256 (rt-3.8.10.tar.gz) = d121ec6463ce919cef74c3ce3ab7e7213cb235726d05abd26c717a7eab6c1448
+SIZE (rt-3.8.10.tar.gz) = 5642566
diff --git a/www/rt38/files/patch-etc__schema.mysql-4.1 b/www/rt38/files/patch-etc__schema.mysql-4.1
new file mode 100644
index 000000000000..b9d7ff4e27a9
--- /dev/null
+++ b/www/rt38/files/patch-etc__schema.mysql-4.1
@@ -0,0 +1,182 @@
+--- ./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);
diff --git a/www/rt38/pkg-plist b/www/rt38/pkg-plist
index c14aee6a7e54..09edf3b988cb 100644
--- a/www/rt38/pkg-plist
+++ b/www/rt38/pkg-plist
@@ -113,8 +113,11 @@ etc/rt38/schema.mysql-4.1
 %%SITE_PERL%%/RT/I18N/cs.po
 %%SITE_PERL%%/RT/I18N/da.po
 %%SITE_PERL%%/RT/I18N/de.po
+%%SITE_PERL%%/RT/I18N/el.po
 %%SITE_PERL%%/RT/I18N/en.po
+%%SITE_PERL%%/RT/I18N/en_GB.po
 %%SITE_PERL%%/RT/I18N/es.po
+%%SITE_PERL%%/RT/I18N/et.po
 %%SITE_PERL%%/RT/I18N/fi.po
 %%SITE_PERL%%/RT/I18N/fr.po
 %%SITE_PERL%%/RT/I18N/he.po
@@ -125,6 +128,9 @@ etc/rt38/schema.mysql-4.1
 %%SITE_PERL%%/RT/I18N/is.po
 %%SITE_PERL%%/RT/I18N/it.po
 %%SITE_PERL%%/RT/I18N/ja.po
+%%SITE_PERL%%/RT/I18N/lt.po
+%%SITE_PERL%%/RT/I18N/lv.po
+%%SITE_PERL%%/RT/I18N/mk.po
 %%SITE_PERL%%/RT/I18N/nb.po
 %%SITE_PERL%%/RT/I18N/nl.po
 %%SITE_PERL%%/RT/I18N/nn.po
@@ -135,6 +141,7 @@ etc/rt38/schema.mysql-4.1
 %%SITE_PERL%%/RT/I18N/rt.pot
 %%SITE_PERL%%/RT/I18N/ru.pm
 %%SITE_PERL%%/RT/I18N/ru.po
+%%SITE_PERL%%/RT/I18N/sl.po
 %%SITE_PERL%%/RT/I18N/sv.po
 %%SITE_PERL%%/RT/I18N/tr.po
 %%SITE_PERL%%/RT/I18N/zh_CN.po
@@ -889,6 +896,7 @@ share/rt38/html/NoAuth/RichText/FCKeditor/fckpackager.xml
 share/rt38/html/NoAuth/RichText/FCKeditor/fckstyles.xml
 share/rt38/html/NoAuth/RichText/FCKeditor/fcktemplates.xml
 share/rt38/html/NoAuth/RichText/FCKeditor/license.txt
+share/rt38/html/NoAuth/RichText/autohandler
 share/rt38/html/NoAuth/RichText/dhandler
 share/rt38/html/NoAuth/css/3.4-compat/body.css
 share/rt38/html/NoAuth/css/3.4-compat/footer.css