diff options
Diffstat (limited to 'rt/etc/schema.mysql-4.1')
| -rwxr-xr-x | rt/etc/schema.mysql-4.1 | 40 |
1 files changed, 20 insertions, 20 deletions
diff --git a/rt/etc/schema.mysql-4.1 b/rt/etc/schema.mysql-4.1 index edd3deda7..bfa8516b2 100755 --- a/rt/etc/schema.mysql-4.1 +++ b/rt/etc/schema.mysql-4.1 @@ -14,7 +14,7 @@ CREATE TABLE Attachments ( 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 @@ CREATE TABLE Queues ( 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 @@ CREATE TABLE Links ( 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 @@ CREATE TABLE Principals ( 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 @@ CREATE TABLE Groups ( 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 @@ CREATE TABLE ScripConditions ( 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 @@ CREATE TABLE Transactions ( 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 @@ CREATE TABLE Scrips ( 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 @@ CREATE TABLE ACL ( 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 @@ CREATE TABLE GroupMembers ( 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 @@ create table CachedGroupMembers ( # 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 @@ CREATE TABLE Users ( 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) ; @@ -297,7 +297,7 @@ CREATE TABLE Tickets ( 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) ; @@ -318,7 +318,7 @@ CREATE TABLE ScripActions ( LastUpdatedBy integer NOT NULL DEFAULT 0 , LastUpdated DATETIME NULL , PRIMARY KEY (id) -) TYPE=InnoDB CHARACTER SET utf8; +) ENGINE=InnoDB CHARACTER SET utf8; # }}} @@ -338,7 +338,7 @@ CREATE TABLE Templates ( Creator integer NOT NULL DEFAULT 0 , Created DATETIME NULL , PRIMARY KEY (id) -) TYPE=InnoDB CHARACTER SET utf8; +) ENGINE=InnoDB CHARACTER SET utf8; # }}} @@ -362,7 +362,7 @@ CREATE TABLE ObjectCustomFieldValues ( 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); @@ -389,7 +389,7 @@ CREATE TABLE CustomFields ( Disabled int2 NOT NULL DEFAULT 0 , Required int2 NOT NULL DEFAULT 0 , PRIMARY KEY (id) -) TYPE=InnoDB CHARACTER SET utf8; +) ENGINE=InnoDB CHARACTER SET utf8; # }}} @@ -406,7 +406,7 @@ CREATE TABLE ObjectCustomFields ( LastUpdatedBy integer NOT NULL DEFAULT 0 , LastUpdated DATETIME NULL , PRIMARY KEY (id) -) TYPE=InnoDB CHARACTER SET utf8; +) ENGINE=InnoDB CHARACTER SET utf8; # }}} @@ -424,7 +424,7 @@ CREATE TABLE CustomFieldValues ( 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); @@ -446,7 +446,7 @@ CREATE TABLE Attributes ( 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); |