5 <title>WebCalendar Database Documentation</title>
9 <body style="background-color: #FFFFFF;">
11 <h2>WebCalendar Database Documentation</h2>
13 <table style="border-width: 0px;">
17 <td><a href="http://webcalendar.sourceforge.net/">http://webcalendar.sourceforge.net/</a>
22 <td><a href="http://www.cknudsen.com">Craig Knudsen</a>, <a
23 href="mailto:cknudsen@cknudsen.com">cknudsen@cknudsen.com</a></td>
26 <td style="vertical-align: top;">Version:</td>
30 <td style="vertical-align: top;">Last updated:</td>
31 <td>2005/05/17 13:06:04<br />
37 <blockquote>This file is generated from <tt>tables-mysql.sql</tt>.
38 Below are the definitions of all WebCalendar tables along with some
39 descriptions of how each table is used. Column names shown in red are
40 the primary keys for that table. <br />
42 If you update the SQL for WebCalendar, use the sql2html.pl script to
43 regenerate this file.</blockquote>
47 <h2>List of Tables</h2>
49 <li><a href="#webcal_asst">webcal_asst</a></li>
50 <li><a href="#webcal_categories">webcal_categories</a></li>
51 <li><a href="#webcal_config">webcal_config</a></li>
52 <li><a href="#webcal_entry">webcal_entry</a></li>
53 <li><a href="#webcal_entry_ext_user">webcal_entry_ext_user</a></li>
54 <li><a href="#webcal_entry_log">webcal_entry_log</a></li>
55 <li><a href="#webcal_entry_repeats">webcal_entry_repeats</a></li>
56 <li><a href="#webcal_entry_repeats_not">webcal_entry_repeats_not</a></li>
57 <li><a href="#webcal_entry_user">webcal_entry_user</a></li>
58 <li><a href="#webcal_group">webcal_group</a></li>
59 <li><a href="#webcal_group_user">webcal_group_user</a></li>
60 <li><a href="#webcal_import">webcal_import</a></li>
61 <li><a href="#webcal_import_data">webcal_import_data</a></li>
62 <li><a href="#webcal_nonuser_cals">webcal_nonuser_cals</a></li>
63 <li><a href="#webcal_reminder_log">webcal_reminder_log</a></li>
64 <li><a href="#webcal_report">webcal_report</a></li>
65 <li><a href="#webcal_report_template">webcal_report_template</a></li>
66 <li><a href="#webcal_site_extras">webcal_site_extras</a></li>
67 <li><a href="#webcal_user">webcal_user</a></li>
68 <li><a href="#webcal_user_layers">webcal_user_layers</a></li>
69 <li><a href="#webcal_user_pref">webcal_user_pref</a></li>
70 <li><a href="#webcal_view">webcal_view</a></li>
71 <li><a href="#webcal_view_user">webcal_view_user</a></li>
76 <h3><a name="webcal_asst">webcal_asst</a></h3>
77 <blockquote>Define assitant/boss relationship. <br />
79 <table style="border-width: 0px;">
81 <th style="vertical-align: top; background-color: #C0C0C0;">Column
83 <th style="vertical-align: top; background-color: #C0C0C0;">Type</th>
84 <th style="vertical-align: top; background-color: #C0C0C0;">Length</th>
85 <th style="vertical-align: top; background-color: #C0C0C0;">Null</th>
86 <th style="vertical-align: top; background-color: #C0C0C0;">Default</th>
87 <th style="vertical-align: top; background-color: #C0C0C0;">Description</th>
90 <td style="vertical-align: top; background-color: #E0E0E0;"><span
91 style="font-weight: bold; color: #A00000;">cal_boss</span></td>
92 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
93 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
94 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
95 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
96 <td style="vertical-align: top; background-color: #E0E0E0;">user
99 <td style="vertical-align: top; background-color: #E0E0E0;"><span
100 style="font-weight: bold; color: #A00000;">cal_assistant</span></td>
101 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
102 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
103 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
104 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
105 <td style="vertical-align: top; background-color: #E0E0E0;">user
106 login of assistant</td>
111 <h3><a name="webcal_categories">webcal_categories</a></h3>
112 <blockquote>Defines user categories. Categories can be
113 specific to a user or global. When a category is global, the cat_owner
114 field will be NULL. (Only an admin user can create a global category.) <br />
116 <table style="border-width: 0px;">
118 <th style="vertical-align: top; background-color: #C0C0C0;">Column
120 <th style="vertical-align: top; background-color: #C0C0C0;">Type</th>
121 <th style="vertical-align: top; background-color: #C0C0C0;">Length</th>
122 <th style="vertical-align: top; background-color: #C0C0C0;">Null</th>
123 <th style="vertical-align: top; background-color: #C0C0C0;">Default</th>
124 <th style="vertical-align: top; background-color: #C0C0C0;">Description</th>
127 <td style="vertical-align: top; background-color: #E0E0E0;"><span
128 style="font-weight: bold; color: #A00000;">cat_id</span></td>
129 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
130 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
131 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
132 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
133 <td style="vertical-align: top; background-color: #E0E0E0;">
134 unique category id</td>
136 <td style="vertical-align: top; background-color: #E0E0E0;">cat_owner</td>
137 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
138 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
139 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
140 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
141 <td style="vertical-align: top; background-color: #E0E0E0;">user
142 login of category owner. If this is NULL, then it is a global category
145 <td style="vertical-align: top; background-color: #E0E0E0;">cat_name</td>
146 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
147 <td style="vertical-align: top; background-color: #E0E0E0;">80</td>
148 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
149 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
150 <td style="vertical-align: top; background-color: #E0E0E0;">
156 <h3><a name="webcal_config">webcal_config</a></h3>
157 <blockquote>System settings (set by the admin interface in
160 <table style="border-width: 0px;">
162 <th style="vertical-align: top; background-color: #C0C0C0;">Column
164 <th style="vertical-align: top; background-color: #C0C0C0;">Type</th>
165 <th style="vertical-align: top; background-color: #C0C0C0;">Length</th>
166 <th style="vertical-align: top; background-color: #C0C0C0;">Null</th>
167 <th style="vertical-align: top; background-color: #C0C0C0;">Default</th>
168 <th style="vertical-align: top; background-color: #C0C0C0;">Description</th>
171 <td style="vertical-align: top; background-color: #E0E0E0;"><span
172 style="font-weight: bold; color: #A00000;">cal_setting</span></td>
173 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
174 <td style="vertical-align: top; background-color: #E0E0E0;">50</td>
175 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
176 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
177 <td style="vertical-align: top; background-color: #E0E0E0;">
180 <td style="vertical-align: top; background-color: #E0E0E0;">cal_value</td>
181 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
182 <td style="vertical-align: top; background-color: #E0E0E0;">100</td>
183 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
184 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
185 <td style="vertical-align: top; background-color: #E0E0E0;">
191 <h3><a name="webcal_entry">webcal_entry</a></h3>
192 <blockquote>Defines a calendar event. Each event in the
193 system has one entry in this table unless the event starts before
194 midnight and ends after midnight. In that case a secondary event will be
195 created with cal_ext_for_id set to the cal_id of the original entry. The
196 following tables contain additional information about each event:
198 <li><a href="#webcal_entry_user">webcal_entry_user</a> - lists
199 participants in the event and specifies the status (accepted, rejected)
200 and category of each participant.</li>
201 <li><a href="#webcal_entry_repeats">webcal_entry_repeats</a> -
202 contains information if the event repeats.</li>
203 <li><a href="#webcal_entry_repeats_not">webcal_entry_repeats_not</a>
204 - specifies which dates the repeating event does not repeat (because
205 they were deleted or modified for just that date by the user)</li>
206 <li><a href="#webcal_entry_log">webcal_entry_log</a> - provides a
207 history of changes to this event.</li>
208 <li><a href="#webcal_site_extras">webcal_site_extras</a> - stores
209 event data as defined in site_extras.php (such as reminders and other
210 custom event fields).</li>
214 <table style="border-width: 0px;">
216 <th style="vertical-align: top; background-color: #C0C0C0;">Column
218 <th style="vertical-align: top; background-color: #C0C0C0;">Type</th>
219 <th style="vertical-align: top; background-color: #C0C0C0;">Length</th>
220 <th style="vertical-align: top; background-color: #C0C0C0;">Null</th>
221 <th style="vertical-align: top; background-color: #C0C0C0;">Default</th>
222 <th style="vertical-align: top; background-color: #C0C0C0;">Description</th>
225 <td style="vertical-align: top; background-color: #E0E0E0;"><span
226 style="font-weight: bold; color: #A00000;">cal_id</span></td>
227 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
228 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
229 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
230 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
231 <td style="vertical-align: top; background-color: #E0E0E0;">
232 cal_id is unique integer id for event</td>
234 <td style="vertical-align: top; background-color: #E0E0E0;">cal_group_id</td>
235 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
236 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
237 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
238 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
239 <td style="vertical-align: top; background-color: #E0E0E0;">
240 cal_group_id: the parent event id if this event is overriding an
241 occurrence of a repeating event</td>
243 <td style="vertical-align: top; background-color: #E0E0E0;">cal_ext_for_id</td>
244 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
245 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
246 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
247 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
248 <td style="vertical-align: top; background-color: #E0E0E0;">used
249 when an event goes past midnight into the next day, in which case an
250 additional entry in this table will use this field to indicate the
251 original event cal_id</td>
253 <td style="vertical-align: top; background-color: #E0E0E0;">cal_create_by</td>
254 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
255 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
256 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
257 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
258 <td style="vertical-align: top; background-color: #E0E0E0;">user
259 login of user that created the event</td>
261 <td style="vertical-align: top; background-color: #E0E0E0;">cal_date</td>
262 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
263 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
264 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
265 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
266 <td style="vertical-align: top; background-color: #E0E0E0;">date
267 of event (in YYYYMMDD format)</td>
269 <td style="vertical-align: top; background-color: #E0E0E0;">cal_time</td>
270 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
271 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
272 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
273 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
274 <td style="vertical-align: top; background-color: #E0E0E0;">
275 event time (in HHMMSS format)</td>
277 <td style="vertical-align: top; background-color: #E0E0E0;">cal_mod_date</td>
278 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
279 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
280 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
281 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
282 <td style="vertical-align: top; background-color: #E0E0E0;">date
283 the event was last modified (in YYYYMMDD format)</td>
285 <td style="vertical-align: top; background-color: #E0E0E0;">cal_mod_time</td>
286 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
287 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
288 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
289 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
290 <td style="vertical-align: top; background-color: #E0E0E0;">time
291 the event was last modified (in HHMMSS format)</td>
293 <td style="vertical-align: top; background-color: #E0E0E0;">cal_duration</td>
294 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
295 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
296 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
297 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
298 <td style="vertical-align: top; background-color: #E0E0E0;">
299 duration of event in minutes</td>
301 <td style="vertical-align: top; background-color: #E0E0E0;">cal_priority</td>
302 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
303 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
304 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
305 <td style="vertical-align: top; background-color: #E0E0E0;">2</td>
306 <td style="vertical-align: top; background-color: #E0E0E0;">
307 event priority: 1=Low, 2=Med, 3=High</td>
309 <td style="vertical-align: top; background-color: #E0E0E0;">cal_type</td>
310 <td style="vertical-align: top; background-color: #E0E0E0;">CHAR</td>
311 <td style="vertical-align: top; background-color: #E0E0E0;">1</td>
312 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
313 <td style="vertical-align: top; background-color: #E0E0E0;">'E'</td>
314 <td style="vertical-align: top; background-color: #E0E0E0;">'E' =
315 Event, 'M' = Repeating event</td>
317 <td style="vertical-align: top; background-color: #E0E0E0;">cal_access</td>
318 <td style="vertical-align: top; background-color: #E0E0E0;">CHAR</td>
319 <td style="vertical-align: top; background-color: #E0E0E0;">1</td>
320 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
321 <td style="vertical-align: top; background-color: #E0E0E0;">'P'</td>
322 <td style="vertical-align: top; background-color: #E0E0E0;">'P' =
323 Public, 'R' = Confidential (others can see time allocated but not what
326 <td style="vertical-align: top; background-color: #E0E0E0;">cal_name</td>
327 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
328 <td style="vertical-align: top; background-color: #E0E0E0;">80</td>
329 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
330 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
331 <td style="vertical-align: top; background-color: #E0E0E0;">
332 brief description of event</td>
334 <td style="vertical-align: top; background-color: #E0E0E0;">cal_description</td>
335 <td style="vertical-align: top; background-color: #E0E0E0;">TEXT</td>
336 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
337 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
338 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
339 <td style="vertical-align: top; background-color: #E0E0E0;">full
340 description of event</td>
345 <h3><a name="webcal_entry_ext_user">webcal_entry_ext_user</a></h3>
346 <blockquote>This table associates one or more external
347 users (people who do not have a WebCalendar login) with an event by the
348 event id. An event must still have at least one WebCalendar user
349 associated with it. This table is not used unless external users are
350 enabled in system settings. The event can be found in <a
351 href="#webcal_entry">webcal_entry</a>. <br />
353 <table style="border-width: 0px;">
355 <th style="vertical-align: top; background-color: #C0C0C0;">Column
357 <th style="vertical-align: top; background-color: #C0C0C0;">Type</th>
358 <th style="vertical-align: top; background-color: #C0C0C0;">Length</th>
359 <th style="vertical-align: top; background-color: #C0C0C0;">Null</th>
360 <th style="vertical-align: top; background-color: #C0C0C0;">Default</th>
361 <th style="vertical-align: top; background-color: #C0C0C0;">Description</th>
364 <td style="vertical-align: top; background-color: #E0E0E0;"><span
365 style="font-weight: bold; color: #A00000;">cal_id</span></td>
366 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
367 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
368 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
369 <td style="vertical-align: top; background-color: #E0E0E0;">0</td>
370 <td style="vertical-align: top; background-color: #E0E0E0;">
373 <td style="vertical-align: top; background-color: #E0E0E0;"><span
374 style="font-weight: bold; color: #A00000;">cal_fullname</span></td>
375 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
376 <td style="vertical-align: top; background-color: #E0E0E0;">50</td>
377 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
378 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
379 <td style="vertical-align: top; background-color: #E0E0E0;">
380 external user fill name</td>
382 <td style="vertical-align: top; background-color: #E0E0E0;">cal_email</td>
383 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
384 <td style="vertical-align: top; background-color: #E0E0E0;">75</td>
385 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
386 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
387 <td style="vertical-align: top; background-color: #E0E0E0;">
388 external user email (for sending a reminder)</td>
393 <h3><a name="webcal_entry_log">webcal_entry_log</a></h3>
394 <blockquote>Activity log for an event. <br />
396 <table style="border-width: 0px;">
398 <th style="vertical-align: top; background-color: #C0C0C0;">Column
400 <th style="vertical-align: top; background-color: #C0C0C0;">Type</th>
401 <th style="vertical-align: top; background-color: #C0C0C0;">Length</th>
402 <th style="vertical-align: top; background-color: #C0C0C0;">Null</th>
403 <th style="vertical-align: top; background-color: #C0C0C0;">Default</th>
404 <th style="vertical-align: top; background-color: #C0C0C0;">Description</th>
407 <td style="vertical-align: top; background-color: #E0E0E0;"><span
408 style="font-weight: bold; color: #A00000;">cal_log_id</span></td>
409 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
410 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
411 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
412 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
413 <td style="vertical-align: top; background-color: #E0E0E0;">
414 unique id of this log entry</td>
416 <td style="vertical-align: top; background-color: #E0E0E0;">cal_entry_id</td>
417 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
418 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
419 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
420 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
421 <td style="vertical-align: top; background-color: #E0E0E0;">
424 <td style="vertical-align: top; background-color: #E0E0E0;">cal_login</td>
425 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
426 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
427 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
428 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
429 <td style="vertical-align: top; background-color: #E0E0E0;">user
430 who performed this action</td>
432 <td style="vertical-align: top; background-color: #E0E0E0;">cal_user_cal</td>
433 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
434 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
435 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
436 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
437 <td style="vertical-align: top; background-color: #E0E0E0;">user
438 of calendar affected</td>
440 <td style="vertical-align: top; background-color: #E0E0E0;">cal_type</td>
441 <td style="vertical-align: top; background-color: #E0E0E0;">CHAR</td>
442 <td style="vertical-align: top; background-color: #E0E0E0;">1</td>
443 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
444 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
445 <td style="vertical-align: top; background-color: #E0E0E0;">log
449 <li>A: Approved/Confirmed by user</li>
450 <li>R: Rejected by user</li>
451 <li>U: Updated by user</li>
452 <li>M: Mail Notification sent</li>
453 <li>E: Reminder sent</li>
457 <td style="vertical-align: top; background-color: #E0E0E0;">cal_date</td>
458 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
459 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
460 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
461 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
462 <td style="vertical-align: top; background-color: #E0E0E0;">date
463 in YYYYMMDD format</td>
465 <td style="vertical-align: top; background-color: #E0E0E0;">cal_time</td>
466 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
467 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
468 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
469 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
470 <td style="vertical-align: top; background-color: #E0E0E0;">time
471 in HHMMSS format</td>
473 <td style="vertical-align: top; background-color: #E0E0E0;">cal_text</td>
474 <td style="vertical-align: top; background-color: #E0E0E0;">TEXT</td>
475 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
476 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
477 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
478 <td style="vertical-align: top; background-color: #E0E0E0;">
484 <h3><a name="webcal_entry_repeats">webcal_entry_repeats</a></h3>
485 <blockquote>Defines repeating info about an event. The
486 event is defined in <a href="#webcal_entry">webcal_entry</a>. <br />
488 <table style="border-width: 0px;">
490 <th style="vertical-align: top; background-color: #C0C0C0;">Column
492 <th style="vertical-align: top; background-color: #C0C0C0;">Type</th>
493 <th style="vertical-align: top; background-color: #C0C0C0;">Length</th>
494 <th style="vertical-align: top; background-color: #C0C0C0;">Null</th>
495 <th style="vertical-align: top; background-color: #C0C0C0;">Default</th>
496 <th style="vertical-align: top; background-color: #C0C0C0;">Description</th>
499 <td style="vertical-align: top; background-color: #E0E0E0;"><span
500 style="font-weight: bold; color: #A00000;">cal_id</span></td>
501 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
502 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
503 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
504 <td style="vertical-align: top; background-color: #E0E0E0;">0</td>
505 <td style="vertical-align: top; background-color: #E0E0E0;">
508 <td style="vertical-align: top; background-color: #E0E0E0;">cal_type</td>
509 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
510 <td style="vertical-align: top; background-color: #E0E0E0;">20</td>
511 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
512 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
513 <td style="vertical-align: top; background-color: #E0E0E0;">type
516 <li>daily - repeats daily</li>
517 <li>monthlyByDate - repeats on same day of the month</li>
518 <li>monthlyByDayR - repeats on same weekday of the month
519 (counting weeks from the end of the month is in last Monday)</li>
520 <li>monthlyByDay - repeats on specified weekday (2nd Monday, for
522 <li>weekly - repeats every week</li>
523 <li>yearly - repeats on same date every year</li>
527 <td style="vertical-align: top; background-color: #E0E0E0;">cal_end</td>
528 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
529 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
530 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
531 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
532 <td style="vertical-align: top; background-color: #E0E0E0;">end
533 date for repeating event (in YYYYMMDD format)</td>
535 <td style="vertical-align: top; background-color: #E0E0E0;">cal_frequency</td>
536 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
537 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
538 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
539 <td style="vertical-align: top; background-color: #E0E0E0;">1</td>
540 <td style="vertical-align: top; background-color: #E0E0E0;">
541 frequency of repeat: 1 = every, 2 = every other, 3 = every 3rd, etc.</td>
543 <td style="vertical-align: top; background-color: #E0E0E0;">cal_days</td>
544 <td style="vertical-align: top; background-color: #E0E0E0;">CHAR</td>
545 <td style="vertical-align: top; background-color: #E0E0E0;">7</td>
546 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
547 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
548 <td style="vertical-align: top; background-color: #E0E0E0;">
549 which days of the week does it repeat on (only applies when cal_type =
555 <h3><a name="webcal_entry_repeats_not">webcal_entry_repeats_not</a></h3>
556 <blockquote>This table specifies which dates in a repeating
557 event have either been deleted or replaced with a replacement event for
558 that day. When replaced, the cal_group_id (I know... not the best name,
559 but it was not being used) column will be set to the original event.
560 That way the user can delete the original event and (at the same time)
561 delete any exception events. <br />
563 <table style="border-width: 0px;">
565 <th style="vertical-align: top; background-color: #C0C0C0;">Column
567 <th style="vertical-align: top; background-color: #C0C0C0;">Type</th>
568 <th style="vertical-align: top; background-color: #C0C0C0;">Length</th>
569 <th style="vertical-align: top; background-color: #C0C0C0;">Null</th>
570 <th style="vertical-align: top; background-color: #C0C0C0;">Default</th>
571 <th style="vertical-align: top; background-color: #C0C0C0;">Description</th>
574 <td style="vertical-align: top; background-color: #E0E0E0;"><span
575 style="font-weight: bold; color: #A00000;">cal_id</span></td>
576 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
577 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
578 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
579 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
580 <td style="vertical-align: top; background-color: #E0E0E0;">
581 event id of repeating event</td>
583 <td style="vertical-align: top; background-color: #E0E0E0;"><span
584 style="font-weight: bold; color: #A00000;">cal_date</span></td>
585 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
586 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
587 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
588 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
589 <td style="vertical-align: top; background-color: #E0E0E0;">
590 cal_date: date event should not repeat (in YYYYMMDD format)</td>
595 <h3><a name="webcal_entry_user">webcal_entry_user</a></h3>
596 <blockquote>This table associates one or more users with an
597 event by the event id. The event can be found in <a href="#webcal_entry">webcal_entry</a>.
600 <table style="border-width: 0px;">
602 <th style="vertical-align: top; background-color: #C0C0C0;">Column
604 <th style="vertical-align: top; background-color: #C0C0C0;">Type</th>
605 <th style="vertical-align: top; background-color: #C0C0C0;">Length</th>
606 <th style="vertical-align: top; background-color: #C0C0C0;">Null</th>
607 <th style="vertical-align: top; background-color: #C0C0C0;">Default</th>
608 <th style="vertical-align: top; background-color: #C0C0C0;">Description</th>
611 <td style="vertical-align: top; background-color: #E0E0E0;"><span
612 style="font-weight: bold; color: #A00000;">cal_id</span></td>
613 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
614 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
615 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
616 <td style="vertical-align: top; background-color: #E0E0E0;">0</td>
617 <td style="vertical-align: top; background-color: #E0E0E0;">
620 <td style="vertical-align: top; background-color: #E0E0E0;"><span
621 style="font-weight: bold; color: #A00000;">cal_login</span></td>
622 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
623 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
624 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
625 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
626 <td style="vertical-align: top; background-color: #E0E0E0;">
627 participant in the event</td>
629 <td style="vertical-align: top; background-color: #E0E0E0;">cal_status</td>
630 <td style="vertical-align: top; background-color: #E0E0E0;">CHAR</td>
631 <td style="vertical-align: top; background-color: #E0E0E0;">1</td>
632 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
633 <td style="vertical-align: top; background-color: #E0E0E0;">'A'</td>
634 <td style="vertical-align: top; background-color: #E0E0E0;">
635 status of event for this user:
643 <td style="vertical-align: top; background-color: #E0E0E0;">cal_category</td>
644 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
645 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
646 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
647 <td style="vertical-align: top; background-color: #E0E0E0;">NULL</td>
648 <td style="vertical-align: top; background-color: #E0E0E0;">
649 category of the event for this user</td>
654 <h3><a name="webcal_group">webcal_group</a></h3>
655 <blockquote>Define a group. Group members can be found in <a
656 href="#webcal_group_user">webcal_group_user</a>. <br />
658 <table style="border-width: 0px;">
660 <th style="vertical-align: top; background-color: #C0C0C0;">Column
662 <th style="vertical-align: top; background-color: #C0C0C0;">Type</th>
663 <th style="vertical-align: top; background-color: #C0C0C0;">Length</th>
664 <th style="vertical-align: top; background-color: #C0C0C0;">Null</th>
665 <th style="vertical-align: top; background-color: #C0C0C0;">Default</th>
666 <th style="vertical-align: top; background-color: #C0C0C0;">Description</th>
669 <td style="vertical-align: top; background-color: #E0E0E0;"><span
670 style="font-weight: bold; color: #A00000;">cal_group_id</span></td>
671 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
672 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
673 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
674 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
675 <td style="vertical-align: top; background-color: #E0E0E0;">
678 <td style="vertical-align: top; background-color: #E0E0E0;">cal_owner</td>
679 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
680 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
681 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
682 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
683 <td style="vertical-align: top; background-color: #E0E0E0;">user
684 login of user that created this group</td>
686 <td style="vertical-align: top; background-color: #E0E0E0;">cal_name</td>
687 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
688 <td style="vertical-align: top; background-color: #E0E0E0;">50</td>
689 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
690 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
691 <td style="vertical-align: top; background-color: #E0E0E0;">name
694 <td style="vertical-align: top; background-color: #E0E0E0;">cal_last_update</td>
695 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
696 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
697 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
698 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
699 <td style="vertical-align: top; background-color: #E0E0E0;">date
700 last updated (in YYYYMMDD format)</td>
705 <h3><a name="webcal_group_user">webcal_group_user</a></h3>
706 <blockquote>Specify users in a group. The group is defined
707 in <a href="#webcal_group">webcal_group</a>. <br />
709 <table style="border-width: 0px;">
711 <th style="vertical-align: top; background-color: #C0C0C0;">Column
713 <th style="vertical-align: top; background-color: #C0C0C0;">Type</th>
714 <th style="vertical-align: top; background-color: #C0C0C0;">Length</th>
715 <th style="vertical-align: top; background-color: #C0C0C0;">Null</th>
716 <th style="vertical-align: top; background-color: #C0C0C0;">Default</th>
717 <th style="vertical-align: top; background-color: #C0C0C0;">Description</th>
720 <td style="vertical-align: top; background-color: #E0E0E0;"><span
721 style="font-weight: bold; color: #A00000;">cal_group_id</span></td>
722 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
723 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
724 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
725 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
726 <td style="vertical-align: top; background-color: #E0E0E0;">
729 <td style="vertical-align: top; background-color: #E0E0E0;"><span
730 style="font-weight: bold; color: #A00000;">cal_login</span></td>
731 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
732 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
733 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
734 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
735 <td style="vertical-align: top; background-color: #E0E0E0;">user
741 <h3><a name="webcal_import">webcal_import</a></h3>
742 <blockquote>Used to track import data (one row per import)
745 <table style="border-width: 0px;">
747 <th style="vertical-align: top; background-color: #C0C0C0;">Column
749 <th style="vertical-align: top; background-color: #C0C0C0;">Type</th>
750 <th style="vertical-align: top; background-color: #C0C0C0;">Length</th>
751 <th style="vertical-align: top; background-color: #C0C0C0;">Null</th>
752 <th style="vertical-align: top; background-color: #C0C0C0;">Default</th>
753 <th style="vertical-align: top; background-color: #C0C0C0;">Description</th>
756 <td style="vertical-align: top; background-color: #E0E0E0;"><span
757 style="font-weight: bold; color: #A00000;">cal_import_id</span></td>
758 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
759 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
760 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
761 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
762 <td style="vertical-align: top; background-color: #E0E0E0;">
763 unique id for import</td>
765 <td style="vertical-align: top; background-color: #E0E0E0;">cal_name</td>
766 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
767 <td style="vertical-align: top; background-color: #E0E0E0;">50</td>
768 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
769 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
770 <td style="vertical-align: top; background-color: #E0E0E0;">name
771 of import (optional)</td>
773 <td style="vertical-align: top; background-color: #E0E0E0;">cal_date</td>
774 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
775 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
776 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
777 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
778 <td style="vertical-align: top; background-color: #E0E0E0;">date
779 of import (YYYYMMDD format)</td>
781 <td style="vertical-align: top; background-color: #E0E0E0;">cal_type</td>
782 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
783 <td style="vertical-align: top; background-color: #E0E0E0;">10</td>
784 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
785 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
786 <td style="vertical-align: top; background-color: #E0E0E0;">type
787 of import (ical, vcal, palm)</td>
789 <td style="vertical-align: top; background-color: #E0E0E0;">cal_login</td>
790 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
791 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
792 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
793 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
794 <td style="vertical-align: top; background-color: #E0E0E0;">user
795 who performed the import</td>
800 <h3><a name="webcal_import_data">webcal_import_data</a></h3>
801 <blockquote>Used to track import data (one row per event) <br />
803 <table style="border-width: 0px;">
805 <th style="vertical-align: top; background-color: #C0C0C0;">Column
807 <th style="vertical-align: top; background-color: #C0C0C0;">Type</th>
808 <th style="vertical-align: top; background-color: #C0C0C0;">Length</th>
809 <th style="vertical-align: top; background-color: #C0C0C0;">Null</th>
810 <th style="vertical-align: top; background-color: #C0C0C0;">Default</th>
811 <th style="vertical-align: top; background-color: #C0C0C0;">Description</th>
814 <td style="vertical-align: top; background-color: #E0E0E0;">cal_import_id</td>
815 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
816 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
817 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
818 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
819 <td style="vertical-align: top; background-color: #E0E0E0;">
820 import id (from webcal_import table)</td>
822 <td style="vertical-align: top; background-color: #E0E0E0;"><span
823 style="font-weight: bold; color: #A00000;">cal_id</span></td>
824 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
825 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
826 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
827 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
828 <td style="vertical-align: top; background-color: #E0E0E0;">
829 event id in WebCalendar</td>
831 <td style="vertical-align: top; background-color: #E0E0E0;"><span
832 style="font-weight: bold; color: #A00000;">cal_login</span></td>
833 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
834 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
835 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
836 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
837 <td style="vertical-align: top; background-color: #E0E0E0;">user
840 <td style="vertical-align: top; background-color: #E0E0E0;">cal_import_type</td>
841 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
842 <td style="vertical-align: top; background-color: #E0E0E0;">15</td>
843 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
844 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
845 <td style="vertical-align: top; background-color: #E0E0E0;">type
846 of import: 'palm', 'vcal', 'ical' or 'publish'</td>
848 <td style="vertical-align: top; background-color: #E0E0E0;">cal_external_id</td>
849 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
850 <td style="vertical-align: top; background-color: #E0E0E0;">200</td>
851 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
852 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
853 <td style="vertical-align: top; background-color: #E0E0E0;">
854 external id used in external calendar system (for example, UID in
860 <h3><a name="webcal_nonuser_cals">webcal_nonuser_cals</a></h3>
861 <blockquote>Defines non-user calendars. <br />
863 <table style="border-width: 0px;">
865 <th style="vertical-align: top; background-color: #C0C0C0;">Column
867 <th style="vertical-align: top; background-color: #C0C0C0;">Type</th>
868 <th style="vertical-align: top; background-color: #C0C0C0;">Length</th>
869 <th style="vertical-align: top; background-color: #C0C0C0;">Null</th>
870 <th style="vertical-align: top; background-color: #C0C0C0;">Default</th>
871 <th style="vertical-align: top; background-color: #C0C0C0;">Description</th>
874 <td style="vertical-align: top; background-color: #E0E0E0;"><span
875 style="font-weight: bold; color: #A00000;">cal_login</span></td>
876 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
877 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
878 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
879 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
880 <td style="vertical-align: top; background-color: #E0E0E0;">the
881 unique id for the calendar</td>
883 <td style="vertical-align: top; background-color: #E0E0E0;">cal_lastname</td>
884 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
885 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
886 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
887 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
888 <td style="vertical-align: top; background-color: #E0E0E0;">
889 calendar's last name</td>
891 <td style="vertical-align: top; background-color: #E0E0E0;">cal_firstname</td>
892 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
893 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
894 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
895 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
896 <td style="vertical-align: top; background-color: #E0E0E0;">
897 calendar's first name</td>
899 <td style="vertical-align: top; background-color: #E0E0E0;">cal_admin</td>
900 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
901 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
902 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
903 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
904 <td style="vertical-align: top; background-color: #E0E0E0;">who
905 is the calendar administrator</td>
910 <h3><a name="webcal_reminder_log">webcal_reminder_log</a></h3>
911 <blockquote>This table keeps a history of when reminders
914 <table style="border-width: 0px;">
916 <th style="vertical-align: top; background-color: #C0C0C0;">Column
918 <th style="vertical-align: top; background-color: #C0C0C0;">Type</th>
919 <th style="vertical-align: top; background-color: #C0C0C0;">Length</th>
920 <th style="vertical-align: top; background-color: #C0C0C0;">Null</th>
921 <th style="vertical-align: top; background-color: #C0C0C0;">Default</th>
922 <th style="vertical-align: top; background-color: #C0C0C0;">Description</th>
925 <td style="vertical-align: top; background-color: #E0E0E0;"><span
926 style="font-weight: bold; color: #A00000;">cal_id</span></td>
927 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
928 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
929 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
930 <td style="vertical-align: top; background-color: #E0E0E0;">0</td>
931 <td style="vertical-align: top; background-color: #E0E0E0;">
934 <td style="vertical-align: top; background-color: #E0E0E0;"><span
935 style="font-weight: bold; color: #A00000;">cal_name</span></td>
936 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
937 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
938 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
939 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
940 <td style="vertical-align: top; background-color: #E0E0E0;">
941 extra type (see site_extras.php)</td>
943 <td style="vertical-align: top; background-color: #E0E0E0;"><span
944 style="font-weight: bold; color: #A00000;">cal_event_date</span></td>
945 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
946 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
947 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
948 <td style="vertical-align: top; background-color: #E0E0E0;">0</td>
949 <td style="vertical-align: top; background-color: #E0E0E0;">the
950 event date we are sending reminder for (in YYYYMMDD format)</td>
952 <td style="vertical-align: top; background-color: #E0E0E0;">cal_last_sent</td>
953 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
954 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
955 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
956 <td style="vertical-align: top; background-color: #E0E0E0;">0</td>
957 <td style="vertical-align: top; background-color: #E0E0E0;">the
958 date/time we last sent a reminder (in UNIX time format)</td>
963 <h3><a name="webcal_report">webcal_report</a></h3>
964 <blockquote>Defines a custom report created by a user. <br />
966 <table style="border-width: 0px;">
968 <th style="vertical-align: top; background-color: #C0C0C0;">Column
970 <th style="vertical-align: top; background-color: #C0C0C0;">Type</th>
971 <th style="vertical-align: top; background-color: #C0C0C0;">Length</th>
972 <th style="vertical-align: top; background-color: #C0C0C0;">Null</th>
973 <th style="vertical-align: top; background-color: #C0C0C0;">Default</th>
974 <th style="vertical-align: top; background-color: #C0C0C0;">Description</th>
977 <td style="vertical-align: top; background-color: #E0E0E0;">cal_login</td>
978 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
979 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
980 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
981 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
982 <td style="vertical-align: top; background-color: #E0E0E0;">
983 creator of report</td>
985 <td style="vertical-align: top; background-color: #E0E0E0;"><span
986 style="font-weight: bold; color: #A00000;">cal_report_id</span></td>
987 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
988 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
989 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
990 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
991 <td style="vertical-align: top; background-color: #E0E0E0;">
992 unique id of this report</td>
994 <td style="vertical-align: top; background-color: #E0E0E0;">cal_is_global</td>
995 <td style="vertical-align: top; background-color: #E0E0E0;">CHAR</td>
996 <td style="vertical-align: top; background-color: #E0E0E0;">1</td>
997 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
998 <td style="vertical-align: top; background-color: #E0E0E0;">'N'</td>
999 <td style="vertical-align: top; background-color: #E0E0E0;">is
1000 this a global report (can it be accessed by other users) ('Y' or 'N')
1003 <td style="vertical-align: top; background-color: #E0E0E0;">cal_report_type</td>
1004 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
1005 <td style="vertical-align: top; background-color: #E0E0E0;">20</td>
1006 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
1007 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1008 <td style="vertical-align: top; background-color: #E0E0E0;">
1009 format of report (html, plain or csv)</td>
1011 <td style="vertical-align: top; background-color: #E0E0E0;">cal_include_header</td>
1012 <td style="vertical-align: top; background-color: #E0E0E0;">CHAR</td>
1013 <td style="vertical-align: top; background-color: #E0E0E0;">1</td>
1014 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
1015 <td style="vertical-align: top; background-color: #E0E0E0;">'Y'</td>
1016 <td style="vertical-align: top; background-color: #E0E0E0;">if
1017 cal_report_type is 'html', should the default HTML header and trailer
1018 be included? ('Y' or 'N')</td>
1020 <td style="vertical-align: top; background-color: #E0E0E0;">cal_report_name</td>
1021 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
1022 <td style="vertical-align: top; background-color: #E0E0E0;">50</td>
1023 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
1024 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1025 <td style="vertical-align: top; background-color: #E0E0E0;">name
1028 <td style="vertical-align: top; background-color: #E0E0E0;">cal_time_range</td>
1029 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
1030 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1031 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
1032 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1033 <td style="vertical-align: top; background-color: #E0E0E0;">time
1036 <li>0 = tomorrow</li>
1038 <li>2 = yesterday</li>
1039 <li>3 = day before yesterday</li>
1040 <li>10 = next week</li>
1041 <li>11 = current week</li>
1042 <li>12 = last week</li>
1043 <li>13 = week before last</li>
1044 <li>20 = next week and week after</li>
1045 <li>21 = current week and next week</li>
1046 <li>22 = last week and this week</li>
1047 <li>23 = last two weeks</li>
1048 <li>30 = next month</li>
1049 <li>31 = current month</li>
1050 <li>32 = last month</li>
1051 <li>33 = month before last</li>
1052 <li>40 = next year</li>
1053 <li>41 = current year</li>
1054 <li>42 = last year</li>
1055 <li>43 = year before last</li>
1059 <td style="vertical-align: top; background-color: #E0E0E0;">cal_user</td>
1060 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
1061 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
1062 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
1063 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1064 <td style="vertical-align: top; background-color: #E0E0E0;">user
1065 calendar to display (NULL indicates current user)</td>
1067 <td style="vertical-align: top; background-color: #E0E0E0;">cal_allow_nav</td>
1068 <td style="vertical-align: top; background-color: #E0E0E0;">CHAR</td>
1069 <td style="vertical-align: top; background-color: #E0E0E0;">1</td>
1070 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
1071 <td style="vertical-align: top; background-color: #E0E0E0;">'Y'</td>
1072 <td style="vertical-align: top; background-color: #E0E0E0;">
1073 allow user to navigate to different dates with next/previous ('Y' or
1076 <td style="vertical-align: top; background-color: #E0E0E0;">cal_cat_id</td>
1077 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
1078 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1079 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
1080 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1081 <td style="vertical-align: top; background-color: #E0E0E0;">
1082 category to filter on (optional)</td>
1084 <td style="vertical-align: top; background-color: #E0E0E0;">cal_include_empty</td>
1085 <td style="vertical-align: top; background-color: #E0E0E0;">CHAR</td>
1086 <td style="vertical-align: top; background-color: #E0E0E0;">1</td>
1087 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
1088 <td style="vertical-align: top; background-color: #E0E0E0;">'N'</td>
1089 <td style="vertical-align: top; background-color: #E0E0E0;">
1090 include empty dates in report ('Y' or 'N')</td>
1092 <td style="vertical-align: top; background-color: #E0E0E0;">cal_show_in_trailer</td>
1093 <td style="vertical-align: top; background-color: #E0E0E0;">CHAR</td>
1094 <td style="vertical-align: top; background-color: #E0E0E0;">1</td>
1095 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
1096 <td style="vertical-align: top; background-color: #E0E0E0;">'N'</td>
1097 <td style="vertical-align: top; background-color: #E0E0E0;">
1098 include a link for this report in the "Go to" section of the
1099 navigation in the page trailer ('Y' or 'N')</td>
1101 <td style="vertical-align: top; background-color: #E0E0E0;">cal_update_date</td>
1102 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
1103 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1104 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
1105 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1106 <td style="vertical-align: top; background-color: #E0E0E0;">date
1107 created or last updated (in YYYYMMDD format)</td>
1112 <h3><a name="webcal_report_template">webcal_report_template</a></h3>
1113 <blockquote>Defines one of the templates used for a report.
1114 Each report has three templates:
1116 <li>Page template - Defines the entire page (except for header and
1117 footer). The following variables can be defined:
1119 <li>${days}<sup>*</sup> - the HTML of all dates (generated from
1120 the Date template)</li>
1123 <li>Date template - Defines events for one day. If the report is
1124 for a week or month, then the results of each day will be concatenated
1125 and used as the ${days} variable in the Page template. The following
1126 variables can be defined:
1128 <li>${events}<sup>*</sup> - the HTML of all events for the data
1129 (generated from the Event template)</li>
1130 <li>${date} - the date</li>
1131 <li>${fulldate} - date (includes weekday)</li>
1134 <li>Event template - Defines a single event. The following
1135 variables can be defined:
1137 <li>${name}<sup>*</sup> - Brief Description of event</li>
1138 <li>${description} - Full Description of event</li>
1139 <li>${date} - Date of event</li>
1140 <li>${fulldate} - Date of event (includes weekday)</li>
1141 <li>${time} - Time of event (4:00pm - 4:30pm)</li>
1142 <li>${starttime} - Start time of event</li>
1143 <li>${endtime} - End time of event</li>
1144 <li>${duration} - Duration of event (in minutes)</li>
1145 <li>${priority} - Priority of event</li>
1146 <li>${href} - URL to view event details</li>
1150 <sup>*</sup> denotes a required template variable <br />
1152 <table style="border-width: 0px;">
1154 <th style="vertical-align: top; background-color: #C0C0C0;">Column
1156 <th style="vertical-align: top; background-color: #C0C0C0;">Type</th>
1157 <th style="vertical-align: top; background-color: #C0C0C0;">Length</th>
1158 <th style="vertical-align: top; background-color: #C0C0C0;">Null</th>
1159 <th style="vertical-align: top; background-color: #C0C0C0;">Default</th>
1160 <th style="vertical-align: top; background-color: #C0C0C0;">Description</th>
1163 <td style="vertical-align: top; background-color: #E0E0E0;"><span
1164 style="font-weight: bold; color: #A00000;">cal_report_id</span></td>
1165 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
1166 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1167 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
1168 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1169 <td style="vertical-align: top; background-color: #E0E0E0;">
1170 report id (in webcal_report table)</td>
1172 <td style="vertical-align: top; background-color: #E0E0E0;"><span
1173 style="font-weight: bold; color: #A00000;">cal_template_type</span></td>
1174 <td style="vertical-align: top; background-color: #E0E0E0;">CHAR</td>
1175 <td style="vertical-align: top; background-color: #E0E0E0;">1</td>
1176 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
1177 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1178 <td style="vertical-align: top; background-color: #E0E0E0;">type
1181 <li>'P': page template represents entire document</li>
1182 <li>'D': date template represents a single day of events</li>
1183 <li>'E': event template represents a single event</li>
1187 <td style="vertical-align: top; background-color: #E0E0E0;">cal_template_text</td>
1188 <td style="vertical-align: top; background-color: #E0E0E0;">TEXT</td>
1189 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1190 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
1191 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1192 <td style="vertical-align: top; background-color: #E0E0E0;">text
1198 <h3><a name="webcal_site_extras">webcal_site_extras</a></h3>
1199 <blockquote>This table holds data for site extra fields
1200 (customized in site_extra.php). <br />
1202 <table style="border-width: 0px;">
1204 <th style="vertical-align: top; background-color: #C0C0C0;">Column
1206 <th style="vertical-align: top; background-color: #C0C0C0;">Type</th>
1207 <th style="vertical-align: top; background-color: #C0C0C0;">Length</th>
1208 <th style="vertical-align: top; background-color: #C0C0C0;">Null</th>
1209 <th style="vertical-align: top; background-color: #C0C0C0;">Default</th>
1210 <th style="vertical-align: top; background-color: #C0C0C0;">Description</th>
1213 <td style="vertical-align: top; background-color: #E0E0E0;"><span
1214 style="font-weight: bold; color: #A00000;">cal_id</span></td>
1215 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
1216 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1217 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
1218 <td style="vertical-align: top; background-color: #E0E0E0;">0</td>
1219 <td style="vertical-align: top; background-color: #E0E0E0;">
1222 <td style="vertical-align: top; background-color: #E0E0E0;"><span
1223 style="font-weight: bold; color: #A00000;">cal_name</span></td>
1224 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
1225 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
1226 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
1227 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1228 <td style="vertical-align: top; background-color: #E0E0E0;">the
1229 brief name of this type (first field in $site_extra array)</td>
1231 <td style="vertical-align: top; background-color: #E0E0E0;"><span
1232 style="font-weight: bold; color: #A00000;">cal_type</span></td>
1233 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
1234 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1235 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
1236 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1237 <td style="vertical-align: top; background-color: #E0E0E0;">
1238 $EXTRA_URL, $EXTRA_DATE, etc.</td>
1240 <td style="vertical-align: top; background-color: #E0E0E0;">cal_date</td>
1241 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
1242 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1243 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
1244 <td style="vertical-align: top; background-color: #E0E0E0;">0</td>
1245 <td style="vertical-align: top; background-color: #E0E0E0;">only
1246 used for $EXTRA_DATE type fields (in YYYYMMDD format)</td>
1248 <td style="vertical-align: top; background-color: #E0E0E0;">cal_remind</td>
1249 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
1250 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1251 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
1252 <td style="vertical-align: top; background-color: #E0E0E0;">0</td>
1253 <td style="vertical-align: top; background-color: #E0E0E0;">how
1254 many minutes before event should a reminder be sent</td>
1256 <td style="vertical-align: top; background-color: #E0E0E0;">cal_data</td>
1257 <td style="vertical-align: top; background-color: #E0E0E0;">TEXT</td>
1258 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1259 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
1260 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1261 <td style="vertical-align: top; background-color: #E0E0E0;">used
1262 to store text data</td>
1267 <h3><a name="webcal_user">webcal_user</a></h3>
1268 <blockquote>Defines a WebCalendar user. <br />
1270 <table style="border-width: 0px;">
1272 <th style="vertical-align: top; background-color: #C0C0C0;">Column
1274 <th style="vertical-align: top; background-color: #C0C0C0;">Type</th>
1275 <th style="vertical-align: top; background-color: #C0C0C0;">Length</th>
1276 <th style="vertical-align: top; background-color: #C0C0C0;">Null</th>
1277 <th style="vertical-align: top; background-color: #C0C0C0;">Default</th>
1278 <th style="vertical-align: top; background-color: #C0C0C0;">Description</th>
1281 <td style="vertical-align: top; background-color: #E0E0E0;"><span
1282 style="font-weight: bold; color: #A00000;">cal_login</span></td>
1283 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
1284 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
1285 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
1286 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1287 <td style="vertical-align: top; background-color: #E0E0E0;">the
1288 unique user login</td>
1290 <td style="vertical-align: top; background-color: #E0E0E0;">cal_passwd</td>
1291 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
1292 <td style="vertical-align: top; background-color: #E0E0E0;">32</td>
1293 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
1294 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1295 <td style="vertical-align: top; background-color: #E0E0E0;">the
1296 user's password. (not used for http or ldap authentication)</td>
1298 <td style="vertical-align: top; background-color: #E0E0E0;">cal_lastname</td>
1299 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
1300 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
1301 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
1302 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1303 <td style="vertical-align: top; background-color: #E0E0E0;">
1304 user's last name</td>
1306 <td style="vertical-align: top; background-color: #E0E0E0;">cal_firstname</td>
1307 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
1308 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
1309 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
1310 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1311 <td style="vertical-align: top; background-color: #E0E0E0;">
1312 user's first name</td>
1314 <td style="vertical-align: top; background-color: #E0E0E0;">cal_is_admin</td>
1315 <td style="vertical-align: top; background-color: #E0E0E0;">CHAR</td>
1316 <td style="vertical-align: top; background-color: #E0E0E0;">1</td>
1317 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
1318 <td style="vertical-align: top; background-color: #E0E0E0;">'N'</td>
1319 <td style="vertical-align: top; background-color: #E0E0E0;">is
1320 the user a WebCalendar administrator ('Y' = yes, 'N' = no)</td>
1322 <td style="vertical-align: top; background-color: #E0E0E0;">cal_email</td>
1323 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
1324 <td style="vertical-align: top; background-color: #E0E0E0;">75</td>
1325 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
1326 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1327 <td style="vertical-align: top; background-color: #E0E0E0;">
1328 user's email address</td>
1333 <h3><a name="webcal_user_layers">webcal_user_layers</a></h3>
1334 <blockquote>Define layers for a user. <br />
1336 <table style="border-width: 0px;">
1338 <th style="vertical-align: top; background-color: #C0C0C0;">Column
1340 <th style="vertical-align: top; background-color: #C0C0C0;">Type</th>
1341 <th style="vertical-align: top; background-color: #C0C0C0;">Length</th>
1342 <th style="vertical-align: top; background-color: #C0C0C0;">Null</th>
1343 <th style="vertical-align: top; background-color: #C0C0C0;">Default</th>
1344 <th style="vertical-align: top; background-color: #C0C0C0;">Description</th>
1347 <td style="vertical-align: top; background-color: #E0E0E0;">cal_layerid</td>
1348 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
1349 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1350 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
1351 <td style="vertical-align: top; background-color: #E0E0E0;">0</td>
1352 <td style="vertical-align: top; background-color: #E0E0E0;">
1353 unique layer id</td>
1355 <td style="vertical-align: top; background-color: #E0E0E0;"><span
1356 style="font-weight: bold; color: #A00000;">cal_login</span></td>
1357 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
1358 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
1359 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
1360 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1361 <td style="vertical-align: top; background-color: #E0E0E0;">
1362 login of owner of this layer</td>
1364 <td style="vertical-align: top; background-color: #E0E0E0;"><span
1365 style="font-weight: bold; color: #A00000;">cal_layeruser</span></td>
1366 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
1367 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
1368 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
1369 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1370 <td style="vertical-align: top; background-color: #E0E0E0;">
1371 login name of user that this layer represents</td>
1373 <td style="vertical-align: top; background-color: #E0E0E0;">cal_color</td>
1374 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
1375 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
1376 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
1377 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1378 <td style="vertical-align: top; background-color: #E0E0E0;">
1379 color to display this layer in</td>
1381 <td style="vertical-align: top; background-color: #E0E0E0;">cal_dups</td>
1382 <td style="vertical-align: top; background-color: #E0E0E0;">CHAR</td>
1383 <td style="vertical-align: top; background-color: #E0E0E0;">1</td>
1384 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
1385 <td style="vertical-align: top; background-color: #E0E0E0;">'N'</td>
1386 <td style="vertical-align: top; background-color: #E0E0E0;">show
1387 duplicates ('N' or 'Y')</td>
1392 <h3><a name="webcal_user_pref">webcal_user_pref</a></h3>
1393 <blockquote>Specify preferences for a user. Most
1394 preferences are set via pref.php. Values in this table are loaded after
1395 system settings found in <a href="#webcal_config">webcal_config</a>. <br />
1397 <table style="border-width: 0px;">
1399 <th style="vertical-align: top; background-color: #C0C0C0;">Column
1401 <th style="vertical-align: top; background-color: #C0C0C0;">Type</th>
1402 <th style="vertical-align: top; background-color: #C0C0C0;">Length</th>
1403 <th style="vertical-align: top; background-color: #C0C0C0;">Null</th>
1404 <th style="vertical-align: top; background-color: #C0C0C0;">Default</th>
1405 <th style="vertical-align: top; background-color: #C0C0C0;">Description</th>
1408 <td style="vertical-align: top; background-color: #E0E0E0;"><span
1409 style="font-weight: bold; color: #A00000;">cal_login</span></td>
1410 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
1411 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
1412 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
1413 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1414 <td style="vertical-align: top; background-color: #E0E0E0;">user
1417 <td style="vertical-align: top; background-color: #E0E0E0;"><span
1418 style="font-weight: bold; color: #A00000;">cal_setting</span></td>
1419 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
1420 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
1421 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
1422 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1423 <td style="vertical-align: top; background-color: #E0E0E0;">
1426 <td style="vertical-align: top; background-color: #E0E0E0;">cal_value</td>
1427 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
1428 <td style="vertical-align: top; background-color: #E0E0E0;">100</td>
1429 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
1430 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1431 <td style="vertical-align: top; background-color: #E0E0E0;">
1437 <h3><a name="webcal_view">webcal_view</a></h3>
1438 <blockquote>A "view" allows a user to put the calendars of
1439 multiple users all on one page. A "view" is valid only for the owner
1440 (cal_owner) of the view. Users for the view are in <a
1441 href="#webcal_view_user">webcal_view_user</a>. <br />
1443 <table style="border-width: 0px;">
1445 <th style="vertical-align: top; background-color: #C0C0C0;">Column
1447 <th style="vertical-align: top; background-color: #C0C0C0;">Type</th>
1448 <th style="vertical-align: top; background-color: #C0C0C0;">Length</th>
1449 <th style="vertical-align: top; background-color: #C0C0C0;">Null</th>
1450 <th style="vertical-align: top; background-color: #C0C0C0;">Default</th>
1451 <th style="vertical-align: top; background-color: #C0C0C0;">Description</th>
1454 <td style="vertical-align: top; background-color: #E0E0E0;"><span
1455 style="font-weight: bold; color: #A00000;">cal_view_id</span></td>
1456 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
1457 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1458 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
1459 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1460 <td style="vertical-align: top; background-color: #E0E0E0;">
1463 <td style="vertical-align: top; background-color: #E0E0E0;">cal_owner</td>
1464 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
1465 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
1466 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
1467 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1468 <td style="vertical-align: top; background-color: #E0E0E0;">
1469 login name of owner of this view</td>
1471 <td style="vertical-align: top; background-color: #E0E0E0;">cal_name</td>
1472 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
1473 <td style="vertical-align: top; background-color: #E0E0E0;">50</td>
1474 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
1475 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1476 <td style="vertical-align: top; background-color: #E0E0E0;">name
1479 <td style="vertical-align: top; background-color: #E0E0E0;">cal_view_type</td>
1480 <td style="vertical-align: top; background-color: #E0E0E0;">CHAR</td>
1481 <td style="vertical-align: top; background-color: #E0E0E0;">1</td>
1482 <td style="vertical-align: top; background-color: #E0E0E0;">Y</td>
1483 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1484 <td style="vertical-align: top; background-color: #E0E0E0;">"W"
1485 for week view, "D" for day view, "M" for month view</td>
1487 <td style="vertical-align: top; background-color: #E0E0E0;">cal_is_global</td>
1488 <td style="vertical-align: top; background-color: #E0E0E0;">CHAR</td>
1489 <td style="vertical-align: top; background-color: #E0E0E0;">1</td>
1490 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
1491 <td style="vertical-align: top; background-color: #E0E0E0;">'N'</td>
1492 <td style="vertical-align: top; background-color: #E0E0E0;">is
1493 this a global view (can it be accessed by other users) ('Y' or 'N')</td>
1498 <h3><a name="webcal_view_user">webcal_view_user</a></h3>
1499 <blockquote>Specify users in a view. See <a
1500 href="#webcal_view">webcal_view</a>. <br />
1502 <table style="border-width: 0px;">
1504 <th style="vertical-align: top; background-color: #C0C0C0;">Column
1506 <th style="vertical-align: top; background-color: #C0C0C0;">Type</th>
1507 <th style="vertical-align: top; background-color: #C0C0C0;">Length</th>
1508 <th style="vertical-align: top; background-color: #C0C0C0;">Null</th>
1509 <th style="vertical-align: top; background-color: #C0C0C0;">Default</th>
1510 <th style="vertical-align: top; background-color: #C0C0C0;">Description</th>
1513 <td style="vertical-align: top; background-color: #E0E0E0;"><span
1514 style="font-weight: bold; color: #A00000;">cal_view_id</span></td>
1515 <td style="vertical-align: top; background-color: #E0E0E0;">INT</td>
1516 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1517 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
1518 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1519 <td style="vertical-align: top; background-color: #E0E0E0;">view
1522 <td style="vertical-align: top; background-color: #E0E0E0;"><span
1523 style="font-weight: bold; color: #A00000;">cal_login</span></td>
1524 <td style="vertical-align: top; background-color: #E0E0E0;">VARCHAR</td>
1525 <td style="vertical-align: top; background-color: #E0E0E0;">25</td>
1526 <td style="vertical-align: top; background-color: #E0E0E0;">N</td>
1527 <td style="vertical-align: top; background-color: #E0E0E0;"> </td>
1528 <td style="vertical-align: top; background-color: #E0E0E0;">a
1529 user in the view</td>