diff options
Diffstat (limited to 'www/rt40/files')
| -rw-r--r-- | www/rt40/files/patch-etc__schema.mysql-4.1 | 182 |
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); |