- 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]

1 files changed, 182 insertions, 0 deletions

diff --git a/www/rt40/files/patch-etc__schema.mysql-4.1 b/www/rt40/files/patch-etc__schema.mysql-4.1
new file mode 100644
index 000000000000..b9d7ff4e27a9
--- /dev/null
+++ b/www/rt40/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);