1 CREATE SEQUENCE KEYWORDSELECTS_seq;
2 CREATE TABLE KeywordSelects (
3 id NUMBER(11, 0) PRIMARY KEY,
7 Depth NUMBER(11, 0) DEFAULT 0,
8 ObjectType VARCHAR2(32) NOT NULL,
9 ObjectField VARCHAR2(32),
10 ObjectValue VARCHAR2(255),
11 Disabled NUMBER(11, 0) DEFAULT 0
14 CREATE INDEX KeywordSelects1 ON KeywordSelects (Keyword);
15 CREATE INDEX KeywordSelects2 ON
16 KeywordSelects(ObjectType, ObjectField, ObjectValue);
19 CREATE SEQUENCE ATTACHMENTS_seq;
20 CREATE TABLE Attachments (
21 id NUMBER(11,0) PRIMARY KEY,
22 TransactionId NUMBER(11,0) NOT NULL,
24 MessageId VARCHAR2(160),
25 Subject VARCHAR2(255),
26 Filename VARCHAR2(255),
27 ContentType VARCHAR2(80),
28 ContentEncoding VARCHAR2(80),
33 Disabled NUMBER(11,0) DEFAULT 0
36 CREATE SEQUENCE QUEUES_seq;
38 id NUMBER(11, 0) PRIMARY KEY,
39 Name VARCHAR2(40) NOT NULL UNIQUE,
40 Description VARCHAR2(120),
41 CorrespondAddress VARCHAR2(40),
42 CommentAddress VARCHAR2(40),
43 InitialPriority NUMBER(11, 0),
44 FinalPriority NUMBER(11, 0),
45 DefaultDueIn NUMBER(11, 0),
46 Creator NUMBER(11, 0),
48 LastUpdatedBy NUMBER(11, 0),
50 Disabled NUMBER(11,0) DEFAULT 0
53 CREATE SEQUENCE LINKS_seq;
55 id NUMBER(11,0) PRIMARY KEY,
58 Type VARCHAR2(20) NOT NULL,
59 LocalTarget NUMBER(11,0),
60 LocalBase NUMBER(11,0),
61 LastUpdatedBy NUMBER(11,0),
67 CREATE UNIQUE INDEX Links1 ON Links (Base, Target, Type);
71 CREATE SEQUENCE GROUPS_seq;
73 id NUMBER(11,0) PRIMARY KEY,
74 Name VARCHAR2(16) UNIQUE,
75 Description VARCHAR(64),
76 Pseudo NUMBER(11,0) DEFAULT 0
79 CREATE SEQUENCE WATCHERS_seq;
80 CREATE TABLE Watchers (
81 id NUMBER(11,0) PRIMARY KEY,
90 LastUpdatedBy NUMBER(11,0),
96 CREATE SEQUENCE SCRIPCONDITIONS_seq;
97 CREATE TABLE ScripConditions (
98 id NUMBER(11, 0) PRIMARY KEY,
100 Description VARCHAR2(255),
101 ExecModule VARCHAR2(60),
102 Argument VARCHAR2(255),
103 ApplicableTransTypes VARCHAR2(60),
104 Creator NUMBER(11, 0),
106 LastUpdatedBy NUMBER(11, 0),
111 CREATE SEQUENCE TRANSACTIONS_seq;
112 CREATE TABLE Transactions (
113 id NUMBER(11,0) PRIMARY KEY,
114 EffectiveTicket NUMBER(11,0),
116 TimeTaken NUMBER(11,0),
119 OldValue VARCHAR2(255),
120 NewValue VARCHAR2(255),
122 Creator NUMBER(11,0),
124 Disabled NUMBER(11,0) DEFAULT 0
127 CREATE SEQUENCE SCRIPS_seq;
128 CREATE TABLE Scrips (
129 id NUMBER(11,0) PRIMARY KEY,
130 ScripCondition NUMBER(11,0),
131 ScripAction NUMBER(11,0),
134 Template NUMBER(11,0),
135 Creator NUMBER(11,0),
137 LastUpdatedBy NUMBER(11,0),
144 CREATE SEQUENCE ACL_seq;
146 id NUMBER(11,0) PRIMARY KEY,
147 PrincipalId NUMBER(11,0),
148 PrincipalType VARCHAR2(25),
149 RightName VARCHAR2(25),
150 RightScope VARCHAR2(25),
151 RightAppliesTo NUMBER(11,0)
154 CREATE SEQUENCE GROUPMEMBERS_seq;
155 CREATE TABLE GroupMembers (
156 id NUMBER(11,0) PRIMARY KEY,
157 GroupId NUMBER(11,0),
161 CREATE UNIQUE INDEX GroupMembers1 ON GroupMembers (GroupId, UserId);
164 CREATE SEQUENCE OBJECTKEYWORDS_seq;
165 CREATE TABLE ObjectKeywords (
166 id NUMBER(11,0) PRIMARY KEY,
167 Keyword NUMBER(11,0) NOT NULL,
168 KeywordSelect NUMBER(11,0) NOT NULL,
169 ObjectType VARCHAR2(32) NOT NULL,
170 ObjectId NUMBER(11,0) NOT NULL
173 CREATE UNIQUE INDEX ObjectKeywords1 ON ObjectKeywords
174 (ObjectId, ObjectType, KeywordSelect, Keyword);
175 CREATE INDEX ObjectKeywords3 ON ObjectKeywords (Keyword);
177 CREATE SEQUENCE KEYWORDS_seq;
178 CREATE TABLE Keywords (
179 id NUMBER(11, 0) PRIMARY KEY,
180 Name VARCHAR2(255) NOT NULL,
181 Description VARCHAR2(255),
182 Parent NUMBER(11, 0),
183 Disabled NUMBER(11, 0) DEFAULT 0
186 CREATE UNIQUE INDEX Keywords1 ON Keywords (Name, Parent);
187 CREATE INDEX Keywords3 ON Keywords (Parent);
189 CREATE SEQUENCE USERS_seq;
191 id NUMBER(11,0) PRIMARY KEY,
192 Name VARCHAR2(120) NOT NULL UNIQUE,
193 Password VARCHAR2(40),
196 EmailAddress VARCHAR2(120),
197 FreeFormContactInfo CLOB,
198 Organization VARCHAR2(200),
199 Privileged NUMBER(11,0),
200 RealName VARCHAR2(120),
201 NickName VARCHAR2(16),
203 EmailEncoding VARCHAR2(16),
204 WebEncoding VARCHAR2(16),
205 ExternalContactInfoId VARCHAR2(100),
206 ContactInfoSystem VARCHAR2(30),
207 ExternalAuthId VARCHAR2(100),
208 AuthSystem VARCHAR2(30),
210 HomePhone VARCHAR2(30),
211 WorkPhone VARCHAR2(30),
212 MobilePhone VARCHAR2(30),
213 PagerPhone VARCHAR2(30),
214 Address1 VARCHAR2(200),
215 Address2 VARCHAR2(200),
219 Country VARCHAR2(50),
220 Creator NUMBER(11,0),
222 LastUpdatedBy NUMBER(11,0),
224 Disabled NUMBER(11,0) DEFAULT 0
230 CREATE SEQUENCE TICKETS_seq;
231 CREATE TABLE Tickets (
232 id NUMBER(11, 0) PRIMARY KEY,
233 EffectiveId NUMBER(11, 0),
236 IssueStatement NUMBER(11,0),
237 Resolution NUMBER(11,0),
239 Subject VARCHAR2(200) DEFAULT '',
240 InitialPriority NUMBER(11,0) DEFAULT 0,
241 FinalPriority NUMBER(11,0) DEFAULT 0,
242 Priority NUMBER(11,0) DEFAULT 0,
244 TimeWorked NUMBER(11,0) DEFAULT 0,
245 TimeLeft NUMBER(11,0) DEFAULT 0,
251 LastUpdatedBy NUMBER(11,0),
253 Creator NUMBER(11,0),
255 Disabled NUMBER(11,0) DEFAULT 0
258 CREATE SEQUENCE SCRIPACTIONS_seq;
259 CREATE TABLE ScripActions (
260 id NUMBER(11,0) PRIMARY KEY,
262 Description VARCHAR2(255),
263 ExecModule VARCHAR2(60),
264 Argument VARCHAR2(255),
265 Creator NUMBER(11,0),
267 LastUpdatedBy NUMBER(11,0),
272 CREATE SEQUENCE TEMPLATES_seq;
273 CREATE TABLE Templates (
274 id NUMBER(11,0) PRIMARY KEY,
275 Queue NUMBER(11,0) DEFAULT 0 NOT NULL,
276 Name VARCHAR2(40) NOT NULL UNIQUE,
277 Description VARCHAR2(120),
279 Language VARCHAR2(16),
280 TranslationOf NUMBER(11,0),
283 LastUpdatedBy NUMBER(11,0),
284 Creator NUMBER(11,0),