diff options
| author | ivan <ivan> | 2009-12-31 13:16:41 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2009-12-31 13:16:41 +0000 |
| commit | b4b0c7e72d7eaee2fbfc7022022c9698323203dd (patch) | |
| tree | ba4cd21399e412c32fe3737eaa8478e3271509f9 /rt/etc/schema.Oracle | |
| parent | 2dfda73eeb3eae2d4f894099754794ef07d060dd (diff) | |
import rt 3.8.7
Diffstat (limited to 'rt/etc/schema.Oracle')
| -rw-r--r-- | rt/etc/schema.Oracle | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/rt/etc/schema.Oracle b/rt/etc/schema.Oracle index 77efefadb..693e75ae5 100644 --- a/rt/etc/schema.Oracle +++ b/rt/etc/schema.Oracle @@ -182,6 +182,7 @@ CREATE TABLE CachedGroupMembers ( ); CREATE INDEX DisGrouMem ON CachedGroupMembers (GroupId, MemberId, Disabled); CREATE INDEX GrouMem ON CachedGroupMembers (GroupId, MemberId); +CREATE INDEX CachedGroupMembers3 on CachedGroupMembers (MemberId, ImmediateParentId); CREATE SEQUENCE USERS_seq; @@ -341,7 +342,7 @@ CREATE TABLE CustomFields ( Name VARCHAR2(200), Type VARCHAR2(200), MaxValues NUMBER(11,0) DEFAULT 0 NOT NULL, - Pattern VARCHAR2(255), + Pattern CLOB, Repeated NUMBER(11,0) DEFAULT 0 NOT NULL, Description VARCHAR2(255), SortOrder NUMBER(11,0) DEFAULT 0 NOT NULL, |