diff options
Diffstat (limited to 'rt/etc/schema.Pg')
| -rwxr-xr-x | rt/etc/schema.Pg | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/rt/etc/schema.Pg b/rt/etc/schema.Pg index 48525c8d7..2d45a946a 100755 --- a/rt/etc/schema.Pg +++ b/rt/etc/schema.Pg @@ -283,8 +283,6 @@ CREATE TABLE GroupMembers ( ); -CREATE UNIQUE INDEX GroupMembers1 ON GroupMembers(GroupId, MemberId); - -- }}} -- {{{ GroupMembersCache @@ -366,6 +364,7 @@ CREATE TABLE Users ( CREATE UNIQUE INDEX Users1 ON Users (Name) ; +CREATE INDEX Users2 ON Users (Name); CREATE INDEX Users3 ON Users (id, EmailAddress); CREATE INDEX Users4 ON Users (EmailAddress); @@ -529,7 +528,7 @@ CREATE TABLE CustomFields ( Type varchar(200) NULL , MaxValues integer NOT NULL DEFAULT 0 , Repeated integer NOT NULL DEFAULT 0 , - Pattern varchar(65536) NULL , + Pattern varchar(255) NULL , LookupType varchar(255) NOT NULL , Description varchar(255) NULL , SortOrder integer NOT NULL DEFAULT 0 , |