2 /* Table: WEBCAL_ENTRY, Owner: SYSDBA */
4 CREATE TABLE "WEBCAL_ENTRY"
6 "CAL_ID" INTEGER NOT NULL,
7 "CAL_GROUP_ID" INTEGER,
8 "CAL_DATE" INTEGER NOT NULL,
9 "CAL_EXT_FOR_ID" INT NULL,
11 "CAL_MOD_DATE" INTEGER,
12 "CAL_MOD_TIME" INTEGER,
13 "CAL_DURATION" INTEGER NOT NULL,
14 "CAL_PRIORITY" INTEGER DEFAULT 2,
15 "CAL_TYPE" CHAR(1) CHARACTER SET WIN1252 DEFAULT 'E',
16 "CAL_ACCESS" CHAR(1) CHARACTER SET WIN1252 DEFAULT 'P',
17 "CAL_NAME" VARCHAR(80) CHARACTER SET WIN1252 NOT NULL,
18 "CAL_DESCRIPTION" VARCHAR(500) CHARACTER SET WIN1252,
19 "CAL_CREATE_BY" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL
22 /* create a default admin user */
23 INSERT INTO webcal_user ( cal_login, cal_passwd, cal_lastname, cal_firstname, cal_is_admin ) VALUES ( 'admin', '21232f297a57a5a743894a0e4a801fc3', 'Administrator', 'Default', 'Y' );
29 /* Table: WEBCAL_ENTRY_REPEATS, Owner: SYSDBA */
31 CREATE TABLE "WEBCAL_ENTRY_REPEATS"
33 "CAL_ID" INTEGER DEFAULT 0 NOT NULL,
34 "CAL_TYPE" VARCHAR(20) CHARACTER SET WIN1252,
36 "CAL_FREQUENCY" INTEGER DEFAULT 1,
37 "CAL_DAYS" CHAR(7) CHARACTER SET WIN1252
40 /* Table: WEBCAL_ENTRY_REPEATS_NOT, Owner: SYSDBA */
41 CREATE TABLE "WEBCAL_ENTRY_REPEATS_NOT"
42 "CAL_ID" INTEGER DEFAULT 0 NOT NULL,
43 "CAL_DATE" INTEGER NOT NULL
47 /* Table: WEBCAL_ENTRY_USER, Owner: SYSDBA */
49 CREATE TABLE "WEBCAL_ENTRY_USER"
51 "CAL_ID" INTEGER DEFAULT 0 NOT NULL,
52 "CAL_LOGIN" VARCHAR(25) CHARACTER SET WIN1252 DEFAULT '' NOT NULL,
53 "CAL_STATUS" VARCHAR(1) CHARACTER SET WIN1252 DEFAULT 'A',
54 "CAL_CATEGORY" INTEGER NULL
58 /* Table: WEBCAL_ENTRY_EXT_USER, Owner: SYSDBA */
60 CREATE TABLE "WEBCAL_ENTRY_EXT_USER"
62 "CAL_ID" INTEGER DEFAULT 0 NOT NULL,
63 "CAL_FULLNAME" VARCHAR(50) CHARACTER SET WIN1252 DEFAULT '' NOT NULL,
64 "CAL_EMAIL" VARCHAR(75) CHARACTER SET WIN1252
68 /* Table: WEBCAL_REMINDER_LOG, Owner: SYSDBA */
70 CREATE TABLE "WEBCAL_REMINDER_LOG"
72 "CAL_ID" INTEGER DEFAULT 0 NOT NULL,
73 "CAL_NAME" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
74 "CAL_EVENT_DATE" INTEGER DEFAULT 0 NOT NULL,
75 "CAL_LAST_SENT" INTEGER DEFAULT 0 NOT NULL
79 /* Table: WEBCAL_SITE_EXTRAS, Owner: SYSDBA */
81 CREATE TABLE "WEBCAL_SITE_EXTRAS"
83 "CAL_ID" INTEGER DEFAULT 0 NOT NULL,
84 "CAL_NAME" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
85 "CAL_TYPE" INTEGER NOT NULL,
86 "CAL_DATE" INTEGER DEFAULT 0,
87 "CAL_REMIND" INTEGER DEFAULT 0,
88 "CAL_DATA" VARCHAR(500) CHARACTER SET WIN1252
92 /* Table: WEBCAL_USER, Owner: SYSDBA */
94 CREATE TABLE "WEBCAL_USER"
96 "CAL_LOGIN" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
97 "CAL_PASSWD" VARCHAR(32) CHARACTER SET WIN1252,
98 "CAL_LASTNAME" VARCHAR(25) CHARACTER SET WIN1252,
99 "CAL_FIRSTNAME" VARCHAR(25) CHARACTER SET WIN1252,
100 "CAL_IS_ADMIN" CHAR(1) CHARACTER SET WIN1252 DEFAULT 'N',
101 "CAL_EMAIL" VARCHAR(75) CHARACTER SET WIN1252
105 /* Table: WEBCAL_USER_LAYERS, Owner: SYSDBA */
107 CREATE TABLE "WEBCAL_USER_LAYERS"
109 "CAL_LAYERID" INTEGER DEFAULT 0 NOT NULL,
110 "CAL_LOGIN" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
111 "CAL_LAYERUSER" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
112 "CAL_COLOR" VARCHAR(25) CHARACTER SET WIN1252,
113 "CAL_DUPS" CHAR(1) CHARACTER SET WIN1252 DEFAULT 'N'
117 /* Table: WEBCAL_USER_PREF, Owner: SYSDBA */
119 CREATE TABLE "WEBCAL_USER_PREF"
121 "CAL_LOGIN" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
122 "CAL_SETTING" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
123 "CAL_VALUE" VARCHAR(100) CHARACTER SET WIN1252
126 /* Table: WEBCAL_GROUP, Owner: SYSDBA */
128 CREATE TABLE "WEBCAL_GROUP"
130 "CAL_GROUP_ID" INTEGER DEFAULT 0 NOT NULL,
131 "CAL_OWNER" VARCHAR(25) CHARACTER SET WIN1252 NULL,
132 "CAL_NAME" VARCHAR(50) CHARACTER SET WIN1252 NOT NULL,
133 "CAL_LAST_UPDATE" INTEGER DEFAULT 0 NOT NULL
136 /* Table: WEBCAL_GROUP_USER, Owner: SYSDBA */
138 CREATE TABLE "WEBCAL_GROUP_USER"
140 "CAL_GROUP_ID" INTEGER DEFAULT 0 NOT NULL,
141 "CAL_LOGIN" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL
144 /* Table: WEBCAL_VIEW, Owner: SYSDBA */
146 CREATE TABLE "WEBCAL_VIEW"
148 "CAL_VIEW_ID" INTEGER DEFAULT 0 NOT NULL,
149 "CAL_OWNER" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
150 "CAL_NAME" VARCHAR(50) CHARACTER SET WIN1252 NOT NULL,
151 "CAL_VIEW_TYPE" VARCHAR(1) CHARACTER SET WIN1252 NOT NULL,
152 "CAL_IS_GLOBAL" CHAR(1) CHARACTER SET WIN1252 NOT NULL DEFAULT 'N'
155 /* Table: WEBCAL_VIEW_USER, Owner: SYSDBA */
157 CREATE TABLE "WEBCAL_VIEW_USER"
159 "CAL_VIEW_ID" INTEGER DEFAULT 0 NOT NULL,
160 "CAL_LOGIN" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL
163 /* Table: WEBCAL_CONFIG, Owner: SYSDBA */
165 CREATE TABLE "WEBCAL_CONFIG"
167 "CAL_SETTING" VARCHAR(50) CHARACTER SET WIN1252 NOT NULL,
168 "CAL_VALUE" VARCHAR(100) CHARACTER SET WIN1252
173 /* default system settings */
174 INSERT INTO webcal_config ( cal_setting, cal_value )
175 VALUES ( 'application_name', 'WebCalendar' );
176 INSERT INTO webcal_config ( cal_setting, cal_value )
177 VALUES ( 'LANGUAGE', 'Browser-defined' );
178 INSERT INTO webcal_config ( cal_setting, cal_value )
179 VALUES ( 'demo_mode', 'N' );
180 INSERT INTO webcal_config ( cal_setting, cal_value )
181 VALUES ( 'require_approvals', 'Y' );
182 INSERT INTO webcal_config ( cal_setting, cal_value )
183 VALUES ( 'groups_enabled', 'N' );
184 INSERT INTO webcal_config ( cal_setting, cal_value )
185 VALUES ( 'user_sees_only_his_groups', 'N' );
186 INSERT INTO webcal_config ( cal_setting, cal_value )
187 VALUES ( 'categories_enabled', 'N' );
188 INSERT INTO webcal_config ( cal_setting, cal_value )
189 VALUES ( 'allow_conflicts', 'N' );
190 INSERT INTO webcal_config ( cal_setting, cal_value )
191 VALUES ( 'conflict_repeat_months', '6' );
192 INSERT INTO webcal_config ( cal_setting, cal_value )
193 VALUES ( 'disable_priority_field', 'N' );
194 INSERT INTO webcal_config ( cal_setting, cal_value )
195 VALUES ( 'disable_access_field', 'N' );
196 INSERT INTO webcal_config ( cal_setting, cal_value )
197 VALUES ( 'disable_participants_field', 'N' );
198 INSERT INTO webcal_config ( cal_setting, cal_value )
199 VALUES ( 'disable_repeating_field', 'N' );
200 INSERT INTO webcal_config ( cal_setting, cal_value )
201 VALUES ( 'allow_view_other', 'Y' );
202 INSERT INTO webcal_config ( cal_setting, cal_value )
203 VALUES ( 'email_fallback_from', 'youremailhere' );
204 INSERT INTO webcal_config ( cal_setting, cal_value )
205 VALUES ( 'remember_last_login', 'Y' );
206 INSERT INTO webcal_config ( cal_setting, cal_value )
207 VALUES ( 'allow_color_customization', 'Y' );
208 INSERT INTO webcal_config ( cal_setting, cal_value )
209 VALUES ('BGCOLOR','#FFFFFF');
210 INSERT INTO webcal_config ( cal_setting, cal_value )
211 VALUES ('TEXTCOLOR','#000000');
212 INSERT INTO webcal_config ( cal_setting, cal_value )
213 VALUES ('H2COLOR','#000000');
214 INSERT INTO webcal_config ( cal_setting, cal_value )
215 VALUES ('CELLBG','#C0C0C0');
216 INSERT INTO webcal_config ( cal_setting, cal_value )
217 VALUES ('WEEKENDBG','#D0D0D0');
218 INSERT INTO webcal_config ( cal_setting, cal_value )
219 VALUES ('TABLEBG','#000000');
220 INSERT INTO webcal_config ( cal_setting, cal_value )
221 VALUES ('THBG','#FFFFFF');
222 INSERT INTO webcal_config ( cal_setting, cal_value )
223 VALUES ('THFG','#000000');
224 INSERT INTO webcal_config ( cal_setting, cal_value )
225 VALUES ('POPUP_FG','#000000');
226 INSERT INTO webcal_config ( cal_setting, cal_value )
227 VALUES ('POPUP_BG','#FFFFFF');
228 INSERT INTO webcal_config ( cal_setting, cal_value )
229 VALUES ('TODAYCELLBG','#FFFF33');
230 INSERT INTO webcal_config ( cal_setting, cal_value )
231 VALUES ( 'STARTVIEW', 'week.php' );
232 INSERT INTO webcal_config ( cal_setting, cal_value )
233 VALUES ( 'WEEK_START', '0' );
234 INSERT INTO webcal_config ( cal_setting, cal_value )
235 VALUES ( 'TIME_FORMAT', '12' );
236 INSERT INTO webcal_config ( cal_setting, cal_value )
237 VALUES ( 'DISPLAY_UNAPPROVED', 'Y' );
238 INSERT INTO webcal_config ( cal_setting, cal_value )
239 VALUES ( 'DISPLAY_WEEKNUMBER', 'Y' );
240 INSERT INTO webcal_config ( cal_setting, cal_value )
241 VALUES ( 'WORK_DAY_START_HOUR', '8' );
242 INSERT INTO webcal_config ( cal_setting, cal_value )
243 VALUES ( 'WORK_DAY_END_HOUR', '17' );
244 INSERT INTO webcal_config ( cal_setting, cal_value )
245 VALUES ( 'send_email', 'N' );
246 INSERT INTO webcal_config ( cal_setting, cal_value )
247 VALUES ( 'EMAIL_REMINDER', 'Y' );
248 INSERT INTO webcal_config ( cal_setting, cal_value )
249 VALUES ( 'EMAIL_EVENT_ADDED', 'Y' );
250 INSERT INTO webcal_config ( cal_setting, cal_value )
251 VALUES ( 'EMAIL_EVENT_UPDATED', 'Y' );
252 INSERT INTO webcal_config ( cal_setting, cal_value )
253 VALUES ( 'EMAIL_EVENT_DELETED', 'Y' );
254 INSERT INTO webcal_config ( cal_setting, cal_value )
255 VALUES ( 'EMAIL_EVENT_REJECTED', 'Y' );
256 INSERT INTO webcal_config ( cal_setting, cal_value )
257 VALUES ('auto_refresh', 'N');
258 INSERT INTO webcal_config ( cal_setting, cal_value )
259 VALUES ('nonuser_enabled', 'N');
260 INSERT INTO webcal_config ( cal_setting, cal_value )
261 VALUES ('allow_html_description', 'N');
262 INSERT INTO webcal_config ( cal_setting, cal_value )
263 VALUES ('reports_enabled', 'N');
264 INSERT INTO webcal_config ( cal_setting, cal_value )
265 VALUES ('DISPLAY_WEEKENDS', 'Y');
266 INSERT INTO webcal_config ( cal_setting, cal_value )
267 VALUES ('DISPLAY_DESC_PRINT_DAY', 'N');
268 INSERT INTO webcal_config ( cal_setting, cal_value )
269 VALUES ('DATE_FORMAT', '__month__ __dd__, __yyyy__');
270 INSERT INTO webcal_config ( cal_setting, cal_value )
271 VALUES ('TIME_SLOTS', '12');
272 INSERT INTO webcal_config ( cal_setting, cal_value )
273 VALUES ('TIMED_EVT_LEN', 'D');
274 INSERT INTO webcal_config ( cal_setting, cal_value )
275 VALUES ('PUBLISH_ENABLED', 'N');
276 INSERT INTO webcal_config ( cal_setting, cal_value )
277 VALUES ('DATE_FORMAT_MY', '__month__ __yyyy__');
278 INSERT INTO webcal_config ( cal_setting, cal_value )
279 VALUES ('DATE_FORMAT_MD', '__month__ __dd__');
280 INSERT INTO webcal_config ( cal_setting, cal_value )
281 VALUES ('CUSTOM_SCRIPT', 'N');
282 INSERT INTO webcal_config ( cal_setting, cal_value )
283 VALUES ('CUSTOM_HEADER', 'N');
284 INSERT INTO webcal_config ( cal_setting, cal_value )
285 VALUES ('CUSTOM_TRAILER', 'N');
286 INSERT INTO webcal_config ( cal_setting, cal_value )
287 VALUES ('bold_days_in_year', 'Y');
288 INSERT INTO webcal_config ( cal_setting, cal_value )
289 VALUES ('site_extras_in_popup', 'N');
290 INSERT INTO webcal_config ( cal_setting, cal_value )
291 VALUES ('add_link_in_views', 'Y');
292 INSERT INTO webcal_config ( cal_setting, cal_value )
293 VALUES ('allow_conflict_override', 'Y');
294 INSERT INTO webcal_config ( cal_setting, cal_value )
295 VALUES ('limit_appts', 'N');
296 INSERT INTO webcal_config ( cal_setting, cal_value )
297 VALUES ('limit_appts_number', '6');
298 INSERT INTO webcal_config ( cal_setting, cal_value )
299 VALUES ('public_access', 'N');
300 INSERT INTO webcal_config ( cal_setting, cal_value )
301 VALUES ('public_access_default_visible', 'N');
302 INSERT INTO webcal_config ( cal_setting, cal_value )
303 VALUES ('public_access_default_selected', 'N');
304 INSERT INTO webcal_config ( cal_setting, cal_value )
305 VALUES ('public_access_others', 'N');
306 INSERT INTO webcal_config ( cal_setting, cal_value )
307 VALUES ('public_access_can_add', 'N');
308 INSERT INTO webcal_config ( cal_setting, cal_value )
309 VALUES ('public_access_add_needs_approval', 'Y');
310 INSERT INTO webcal_config ( cal_setting, cal_value )
311 VALUES ('public_access_view_part', 'N');
312 INSERT INTO webcal_config ( cal_setting, cal_value )
313 VALUES ('nonuser_at_top', 'Y');
314 INSERT INTO webcal_config ( cal_setting, cal_value )
315 VALUES ('allow_external_users', 'N');
316 INSERT INTO webcal_config ( cal_setting, cal_value )
317 VALUES ('external_notifications', 'N');
318 INSERT INTO webcal_config ( cal_setting, cal_value )
319 VALUES ('external_reminders', 'N');
320 INSERT INTO webcal_config ( cal_setting, cal_value )
321 VALUES ('enable_gradients', 'N');
325 /* Table: WEBCAL_ENTRY_LOG, Owner: SYSDBA */
327 CREATE TABLE "WEBCAL_ENTRY_LOG"
329 "CAL_LOG_ID" INTEGER DEFAULT 0 NOT NULL,
330 "CAL_ENTRY_ID" INTEGER DEFAULT 0 NOT NULL,
331 "CAL_LOGIN" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
332 "CAL_USER_CAL" VARCHAR(25) CHARACTER SET WIN1252 NULL,
333 "CAL_TYPE" VARCHAR(1) CHARACTER SET WIN1252 NOT NULL,
334 "CAL_DATE" INTEGER NULL,
335 "CAL_TIME" INTEGER NULL,
336 "CAL_TEXT" VARCHAR(500) CHARACTER SET WIN1252 NULL
340 /* Table: WEBCAL_CATEGORIES, Owner: SYSDBA */
342 CREATE TABLE "WEBCAL_CATEGORIES"
344 "CAT_ID" INTEGER DEFAULT 0 NOT NULL,
345 "CAT_OWNER" VARCHAR(25) CHARACTER SET WIN1252 NULL,
346 "CAT_NAME" VARCHAR(80) CHARACTER SET WIN1252 NOT NULL
349 /* Table: WEBCAL_ASST, Owner: SYSDBA */
350 CREATE TABLE "WEBCAL_ASST"
352 "CAL_BOSS" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
353 "CAL_ASSISTANT" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL
356 /* Table: "WEBCAL_NONUSER_CALS", Owner: SYSDBA */
357 CREATE TABLE WEBCAL_NONUSER_CALS (
358 "CAL_LOGIN" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
359 "CAL_LASTNAME" VARCHAR(25) CHARACTER SET WIN1252,
360 "CAL_FIRSTNAME" VARCHAR(25) CHARACTER SET WIN1252,
361 "CAL_ADMIN" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL
364 /* Table: "WEBCAL_IMPORT", Owner: SYSDBA */
365 CREATE TABLE WEBCAL_IMPORT (
366 "CAL_IMPORT_ID" INTEGER DEFAULT 0 NOT NULL,
367 "CAL_NAME" VARCHAR(50) CHARACTER SET WIN1252 NULL,
368 "CAL_DATE" INTEGER DEFAULT 0 NOT NULL,
369 "CAL_TYPE" VARCHAR(10) CHARACTER SET WIN1252 NOT NULL,
370 "CAL_LOGIN" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL
373 /* Table: "WEBCAL_IMPORT_DATA", Owner: SYSDBA */
374 CREATE TABLE WEBCAL_IMPORT_DATA (
375 "CAL_IMPORT_ID" INTEGER DEFAULT 0 NOT NULL,
376 "CAL_ID" INTEGER DEFAULT 0 NOT NULL,
377 "CAL_LOGIN" VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
378 "CAL_IMPORT_TYPE" VARCHAR(15) CHARACTER SET WIN1252 NOT NULL,
379 "CAL_EXTERNAL_ID" VARCHAR(200) CHARACTER SET WIN1252 NULL,
380 "CAL_EXTERNAL_ID" VARCHAR(200) NULL
383 /* Table: "WEBCAL_REPORT", Owner: SYSDBA */
384 CREATE TABLE WEBCAL_REPORT (
385 "CAL_LOGIN VARCHAR(25) CHARACTER SET WIN1252 NOT NULL,
386 "CAL_REPORT_ID INTEGER DEFAULT 0 NOT NULL,
387 "CAL_IS_GLOBAL VARCHAR(1) DEFAULT 'N' CHARACTER SET WIN1252 NOT NULL,
388 "CAL_REPORT_TYPE VARCHAR(20) CHARACTER SET WIN1252 NOT NULL,
389 "CAL_INCLUDE_HEADER VARCHAR(1) DEFAULT 'Y' CHARACTER SET WIN1252 NOT NULL,
390 "CAL_REPORT_NAME VARCHAR(50) CHARACTER SET WIN1252 NOT NULL,
391 "CAL_TIME_RANGE INTEGER DEFAULT 0 NOT NULL,
392 "CAL_USER VARCHAR(25) CHARACTER SET WIN1252 NULL,
393 "CAL_ALLOW_NAV VARCHAR(1) DEFAULT 'Y' CHARACTER SET WIN1252 NOT NULL,
394 "CAL_CAT_ID INTEGER NULL,
395 "CAL_INCLUDE_EMPTY VARCHAR(1) DEFAULT 'N' CHARACTER SET WIN1252 NOT NULL,
396 "CAL_SHOW_IN_TRAILER VARCHAR(1) DEFAULT 'N' CHARACTER SET WIN1252 NOT NULL,
397 "CAL_UPDATE_DATE INTEGER DEFAULT 0 NOT NULL
400 /* Table: "WEBCAL_REPORT_TEMPLATE", Owner: SYSDBA */
401 CREATE TABLE WEBCAL_REPORT_TEMPLATE (
402 "CAL_REPORT_ID" INTEGER DEFAULT 0 NOT NULL,
403 "CAL_TEMPLATE_TYPE" VARCHAR(1) CHARACTER SET WIN1252 NOT NULL,
404 "CAL_TEMPLATE_TEXT" VARCHAR(1024) CHARACTER SET WIN1252 NOT NULL
412 /* Index definitions for all user tables */
414 CREATE INDEX "IWEBCAL_ENTRYNEWINDEX" ON "WEBCAL_ENTRY"("CAL_ID");
415 CREATE INDEX "IWEBCAL_ENTRY_REPEATSNEWINDEX" ON "WEBCAL_ENTRY_REPEATS"("CAL_ID");
416 CREATE INDEX "IWEBCAL_ENTRY_REPEATS_NOTNEWINDEX" ON "WEBCAL_ENTRY_REPEATS_NOT"("CAL_ID", "CAL_DATE");
417 CREATE INDEX "IWEBCAL_ENTRY_USERNEWINDEX" ON "WEBCAL_ENTRY_USER"("CAL_ID", "CAL_LOGIN");
418 CREATE INDEX "IWEBCAL_ENTRY_EXTUSERNEWINDEX" ON "WEBCAL_ENTRY_EXT_USER"("CAL_ID", "CAL_FULLNAME");
419 CREATE INDEX "IWEBCAL_REMINDER_LOGNEWINDEX" ON "WEBCAL_REMINDER_LOG"("CAL_ID", "CAL_NAME", "CAL_EVENT_DATE");
420 CREATE INDEX "IWEBCAL_SITE_EXTRASNEWINDEX" ON "WEBCAL_SITE_EXTRAS"("CAL_ID", "CAL_NAME", "CAL_TYPE");
421 CREATE INDEX "IWEBCAL_USERNEWINDEX" ON "WEBCAL_USER"("CAL_LOGIN");
422 CREATE INDEX "IWEBCAL_USER_LAYERSNEWINDEX" ON "WEBCAL_USER_LAYERS"("CAL_LOGIN", "CAL_LAYERUSER");
423 CREATE INDEX "IWEBCAL_USER_PREFNEWINDEX" ON "WEBCAL_USER_PREF"("CAL_LOGIN", "CAL_SETTING");
424 CREATE INDEX "IWEBCAL_GROUPNEWINDEX" ON "WEBCAL_GROUP"("CAL_GROUP_ID");
425 CREATE INDEX "IWEBCAL_GROUPUSERNEWINDEX" ON "WEBCAL_GROUP_USER"("CAL_GROUP_ID", "CAL_LOGIN");
426 CREATE INDEX "IWEBCAL_VIEWNEWINDEX" ON "WEBCAL_VIEW"("CAL_VIEW_ID");
427 CREATE INDEX "IWEBCAL_VIEWUSERNEWINDEX" ON "WEBCAL_VIEW_USER"("CAL_VIEW_ID", "CAL_LOGIN");
428 CREATE INDEX "IWEBCAL_CONFIGNEWINDEX" ON "WEBCAL_CONFIG"("CAL_SETTING");
429 CREATE INDEX "IWEBCAL_ENTRYLOGINDEX" ON "WEBCAL_CONFIG"("CAL_LOG_ID");
430 CREATE INDEX "IWEBCAL_CATEGORIESINDEX" ON "WEBCAL_CATEGORIES"("CAT_ID");
431 CREATE INDEX "IWEBCAL_BOSSINDEX" ON "WEBCAL_ASST"("CAL_BOSS", "CAL_ASSISTANT");
432 CREATE INDEX "IWEBCAL_NONUSERCALSINDEX" ON "WEBCAL_NONUSER_CALS"("CAL_LOGIN");
433 CREATE INDEX "IWEBCAL_IMPORT2INDEX" ON "WEBCAL_IMPORT"("CAL_IMPORT_ID");
434 CREATE INDEX "IWEBCAL_IMPORTINDEX" ON "WEBCAL_IMPORT_DATA"("CAL_LOGIN", "CAL_ID");
435 CREATE INDEX "IWEBCAL_REPORTINDEX" ON "WEBCAL_REPORT"("CAL_REPORT_ID");
436 CREATE INDEX "IWEBCAL_REPORTTEMPLATEINDEX" ON "WEBCAL_REPORT_TEMPLATE"("CAL_REPORT_ID", "CAL_TEMPLATE_TYPE");