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