1 CREATE TABLE KeywordSelects (
6 Depth integer NOT NULL DEFAULT 0 ,
7 ObjectType varchar(32) NOT NULL ,
8 ObjectField varchar(32) ,
9 ObjectValue varchar(255) ,
10 Disabled int2 NOT NULL DEFAULT 0 ,
13 CREATE INDEX KeywordSelects1 ON KeywordSelects (Keyword);
14 CREATE INDEX KeywordSelects2 ON KeywordSelects (ObjectType, ObjectField, ObjectValue);
15 CREATE TABLE Attachments (
17 TransactionId integer NOT NULL ,
19 MessageId varchar(160) ,
20 Subject varchar(255) ,
21 Filename varchar(255) ,
22 ContentType varchar(80) ,
23 ContentEncoding varchar(80) ,
30 CREATE INDEX Attachments1 ON Attachments (Parent);
31 CREATE INDEX Attachments2 ON Attachments (TransactionId);
32 CREATE INDEX Attachments3 ON Attachments (Parent, TransactionId);
35 Name varchar(120) NOT NULL ,
36 Description varchar(120) ,
37 CorrespondAddress varchar(120) ,
38 CommentAddress varchar(120) ,
39 InitialPriority integer ,
40 FinalPriority integer ,
41 DefaultDueIn integer ,
44 LastUpdatedBy integer ,
45 LastUpdated timestamp ,
46 Disabled int2 NOT NULL DEFAULT 0 ,
49 CREATE UNIQUE INDEX Queues1 ON Queues (Name);
54 Type varchar(20) NOT NULL ,
57 LastUpdatedBy integer ,
58 LastUpdated timestamp ,
63 CREATE UNIQUE INDEX Links1 ON Links (Base, Target, Type);
67 Description varchar(64) ,
68 Pseudo integer NOT NULL DEFAULT 0 ,
71 CREATE UNIQUE INDEX Groups1 ON Groups (Name);
72 CREATE TABLE Watchers (
82 LastUpdatedBy integer ,
83 LastUpdated timestamp ,
86 CREATE INDEX Watchers1 ON Watchers (Scope, Value, Type, Owner);
87 CREATE TABLE ScripConditions (
90 Description varchar(255) ,
91 ExecModule varchar(60) ,
92 Argument varchar(255) ,
93 ApplicableTransTypes varchar(60) ,
96 LastUpdatedBy integer ,
97 LastUpdated timestamp ,
100 CREATE TABLE Transactions (
102 EffectiveTicket integer ,
107 OldValue varchar(255) ,
108 NewValue varchar(255) ,
114 CREATE INDEX Transactions1 ON Transactions (Ticket);
115 CREATE INDEX Transactions2 ON Transactions (EffectiveTicket);
116 CREATE TABLE Scrips (
118 ScripCondition integer ,
119 ScripAction integer ,
125 LastUpdatedBy integer ,
126 LastUpdated timestamp ,
131 PrincipalId integer ,
132 PrincipalType varchar(25) ,
133 RightName varchar(25) ,
134 RightScope varchar(25) ,
135 RightAppliesTo integer ,
138 CREATE INDEX ACL1 ON ACL (RightScope, PrincipalId);
139 CREATE INDEX ACL2 ON ACL (RightScope, RightAppliesTo, RightName, PrincipalType, PrincipalId);
140 CREATE TABLE GroupMembers (
146 CREATE UNIQUE INDEX GroupMembers1 ON GroupMembers (GroupId, UserId);
147 CREATE TABLE ObjectKeywords (
149 Keyword integer NOT NULL ,
150 KeywordSelect integer NOT NULL ,
151 ObjectType varchar(32) NOT NULL ,
152 ObjectId integer NOT NULL ,
155 CREATE UNIQUE INDEX ObjectKeywords1 ON ObjectKeywords (ObjectId, ObjectType, KeywordSelect, Keyword);
156 CREATE INDEX ObjectKeywords2 ON ObjectKeywords (ObjectId, ObjectType);
157 CREATE INDEX ObjectKeywords3 ON ObjectKeywords (Keyword);
158 CREATE TABLE Keywords (
160 Name varchar(255) NOT NULL ,
161 Description varchar(255) ,
163 Disabled int2 NOT NULL DEFAULT 0 ,
166 CREATE UNIQUE INDEX Keywords1 ON Keywords (Name, Parent);
167 CREATE INDEX Keywords2 ON Keywords (Name);
168 CREATE INDEX Keywords3 ON Keywords (Parent);
171 Name varchar(120) NOT NULL ,
172 Password varchar(40) ,
175 EmailAddress varchar(120) ,
176 FreeformContactInfo TEXT ,
177 Organization varchar(200) ,
179 RealName varchar(120) ,
180 Nickname varchar(16) ,
182 EmailEncoding varchar(16) ,
183 WebEncoding varchar(16) ,
184 ExternalContactInfoId varchar(100) ,
185 ContactInfoSystem varchar(30) ,
186 ExternalAuthId varchar(100) ,
187 AuthSystem varchar(30) ,
189 HomePhone varchar(30) ,
190 WorkPhone varchar(30) ,
191 MobilePhone varchar(30) ,
192 PagerPhone varchar(30) ,
193 Address1 varchar(200) ,
194 Address2 varchar(200) ,
198 Country varchar(50) ,
201 LastUpdatedBy integer ,
202 LastUpdated timestamp ,
203 Disabled int2 NOT NULL DEFAULT 0 ,
206 CREATE UNIQUE INDEX Users1 ON Users (Name);
207 CREATE INDEX Users3 ON Users (id, EmailAddress);
208 CREATE INDEX Users4 ON Users (EmailAddress);
209 CREATE TABLE Tickets (
211 EffectiveId integer ,
214 IssueStatement integer ,
217 Subject varchar(200) DEFAULT '[no subject]' ,
218 InitialPriority integer ,
219 FinalPriority integer ,
229 LastUpdatedBy integer ,
230 LastUpdated timestamp ,
233 Disabled int2 NOT NULL DEFAULT 0 ,
236 CREATE INDEX Tickets1 ON Tickets (Queue, Status);
237 CREATE INDEX Tickets2 ON Tickets (Owner);
238 CREATE INDEX Tickets3 ON Tickets (EffectiveId);
239 CREATE INDEX Tickets4 ON Tickets (id, Status);
240 CREATE INDEX Tickets5 ON Tickets (id, EffectiveId);
241 CREATE TABLE ScripActions (
244 Description varchar(255) ,
245 ExecModule varchar(60) ,
246 Argument varchar(255) ,
249 LastUpdatedBy integer ,
250 LastUpdated timestamp ,
253 CREATE TABLE Templates (
255 Queue integer NOT NULL DEFAULT 0 ,
256 Name varchar(40) NOT NULL ,
257 Description varchar(120) ,
259 Language varchar(16) ,
260 TranslationOf integer ,
262 LastUpdated timestamp ,
263 LastUpdatedBy integer ,