1 CREATE TABLE webcal_user (
2 cal_login VARCHAR(25) NOT NULL,
3 cal_passwd VARCHAR(32),
4 cal_lastname VARCHAR(25),
5 cal_firstname VARCHAR(25),
6 cal_is_admin CHAR(1) DEFAULT 'N',
8 PRIMARY KEY ( cal_login )
11 INSERT INTO webcal_user
12 (cal_login, cal_passwd, cal_lastname, cal_firstname, cal_is_admin)
13 VALUES ( 'admin', '21232f297a57a5a743894a0e4a801fc3', 'Administrator', 'Default', 'Y' );
16 CREATE TABLE webcal_entry (
20 cal_create_by VARCHAR(25) NOT NULL,
21 cal_date INT NOT NULL,
25 cal_duration INT NOT NULL,
26 cal_priority INT DEFAULT 2,
27 cal_type CHAR(1) DEFAULT 'E',
28 cal_access CHAR(1) DEFAULT 'P',
29 cal_name VARCHAR(80) NOT NULL,
30 cal_description varchar(1024),
31 PRIMARY KEY ( cal_id )
35 CREATE TABLE webcal_entry_repeats (
36 cal_id INT DEFAULT 0 NOT NULL,
39 cal_frequency INT DEFAULT 1,
45 CREATE TABLE webcal_entry_repeats_not (
47 cal_date INT NOT NULL,
48 PRIMARY KEY ( cal_id, cal_date )
53 CREATE TABLE webcal_entry_user (
54 cal_id int DEFAULT 0 NOT NULL,
55 cal_login varchar(25) DEFAULT '' NOT NULL,
56 cal_status char(1) DEFAULT 'A' NOT NULL,
57 cal_category INT DEFAULT NULL,
58 PRIMARY KEY ( cal_id,cal_login )
62 CREATE TABLE webcal_entry_ext_user (
63 cal_id INT DEFAULT 0 NOT NULL,
64 cal_fullname VARCHAR(50) NOT NULL,
65 cal_email VARCHAR(75) DEFAULT NULL,
66 PRIMARY KEY ( cal_id, cal_fullname )
71 CREATE TABLE webcal_user_pref (
72 cal_login varchar(25) NOT NULL,
73 cal_setting varchar(25) NOT NULL,
74 cal_value varchar(100),
75 PRIMARY KEY ( cal_login, cal_setting )
80 CREATE TABLE webcal_user_layers (
81 cal_layerid INT DEFAULT 0 NOT NULL,
82 cal_login varchar(25) NOT NULL,
83 cal_layeruser varchar(25) NOT NULL,
84 cal_color varchar(25),
85 cal_dups CHAR(1) DEFAULT 'N',
86 PRIMARY KEY ( cal_login, cal_layeruser )
91 CREATE TABLE webcal_site_extras (
92 cal_id INT DEFAULT 0 NOT NULL,
93 cal_name VARCHAR(25) NOT NULL,
94 cal_type INT NOT NULL,
95 cal_date INT DEFAULT 0,
96 cal_remind INT DEFAULT 0,
97 cal_data varchar(1024),
98 PRIMARY KEY ( cal_id, cal_name, cal_type )
102 CREATE TABLE webcal_reminder_log (
103 cal_id INT DEFAULT 0 NOT NULL,
104 cal_name VARCHAR(25) NOT NULL,
105 cal_event_date INT NOT NULL DEFAULT 0,
106 cal_last_sent INT NOT NULL DEFAULT 0,
107 PRIMARY KEY ( cal_id, cal_name, cal_event_date )
110 CREATE TABLE webcal_group (
111 cal_group_id INT NOT NULL,
112 cal_owner VARCHAR(25),
113 cal_name VARCHAR(50) NOT NULL,
114 cal_last_update INT NOT NULL,
115 PRIMARY KEY ( cal_group_id )
118 CREATE TABLE webcal_group_user (
119 cal_group_id INT NOT NULL,
120 cal_login VARCHAR(25) NOT NULL,
121 PRIMARY KEY ( cal_group_id, cal_login )
124 CREATE TABLE webcal_view (
125 cal_view_id INT NOT NULL,
126 cal_owner VARCHAR(25) NOT NULL,
127 cal_name VARCHAR(50) NOT NULL,
128 cal_view_type CHAR(1),
129 cal_is_global CHAR(1) DEFAULT 'N' NOT NULL,
130 PRIMARY KEY ( cal_view_id )
133 CREATE TABLE webcal_view_user (
134 cal_view_id INT NOT NULL,
135 cal_login VARCHAR(25) NOT NULL,
136 PRIMARY KEY ( cal_view_id, cal_login )
139 CREATE TABLE webcal_config (
140 cal_setting VARCHAR(50) NOT NULL,
141 cal_value VARCHAR(100),
142 PRIMARY KEY ( cal_setting )
146 INSERT INTO webcal_config ( cal_setting, cal_value )
147 VALUES ( 'application_name', 'WebCalendar' );
148 INSERT INTO webcal_config ( cal_setting, cal_value )
149 VALUES ( 'LANGUAGE', 'Browser-defined' );
150 INSERT INTO webcal_config ( cal_setting, cal_value )
151 VALUES ( 'demo_mode', 'N' );
152 INSERT INTO webcal_config ( cal_setting, cal_value )
153 VALUES ( 'require_approvals', 'Y' );
154 INSERT INTO webcal_config ( cal_setting, cal_value )
155 VALUES ( 'groups_enabled', 'N' );
156 INSERT INTO webcal_config ( cal_setting, cal_value )
157 VALUES ( 'user_sees_only_his_groups', 'N' );
158 INSERT INTO webcal_config ( cal_setting, cal_value )
159 VALUES ( 'categories_enabled', 'N' );
160 INSERT INTO webcal_config ( cal_setting, cal_value )
161 VALUES ( 'allow_conflicts', 'N' );
162 INSERT INTO webcal_config ( cal_setting, cal_value )
163 VALUES ( 'conflict_repeat_months', '6' );
164 INSERT INTO webcal_config ( cal_setting, cal_value )
165 VALUES ( 'disable_priority_field', 'N' );
166 INSERT INTO webcal_config ( cal_setting, cal_value )
167 VALUES ( 'disable_access_field', 'N' );
168 INSERT INTO webcal_config ( cal_setting, cal_value )
169 VALUES ( 'disable_participants_field', 'N' );
170 INSERT INTO webcal_config ( cal_setting, cal_value )
171 VALUES ( 'disable_repeating_field', 'N' );
172 INSERT INTO webcal_config ( cal_setting, cal_value )
173 VALUES ( 'allow_view_other', 'Y' );
174 INSERT INTO webcal_config ( cal_setting, cal_value )
175 VALUES ( 'email_fallback_from', 'youremailhere' );
176 INSERT INTO webcal_config ( cal_setting, cal_value )
177 VALUES ( 'remember_last_login', 'Y' );
178 INSERT INTO webcal_config ( cal_setting, cal_value )
179 VALUES ( 'allow_color_customization', 'Y' );
180 INSERT INTO webcal_config ( cal_setting, cal_value )
181 VALUES ('BGCOLOR','#FFFFFF');
182 INSERT INTO webcal_config ( cal_setting, cal_value )
183 VALUES ('TEXTCOLOR','#000000');
184 INSERT INTO webcal_config ( cal_setting, cal_value )
185 VALUES ('H2COLOR','#000000');
186 INSERT INTO webcal_config ( cal_setting, cal_value )
187 VALUES ('CELLBG','#C0C0C0');
188 INSERT INTO webcal_config ( cal_setting, cal_value )
189 VALUES ('WEEKENDBG','#D0D0D0');
190 INSERT INTO webcal_config ( cal_setting, cal_value )
191 VALUES ('TABLEBG','#000000');
192 INSERT INTO webcal_config ( cal_setting, cal_value )
193 VALUES ('THBG','#FFFFFF');
194 INSERT INTO webcal_config ( cal_setting, cal_value )
195 VALUES ('THFG','#000000');
196 INSERT INTO webcal_config ( cal_setting, cal_value )
197 VALUES ('POPUP_FG','#000000');
198 INSERT INTO webcal_config ( cal_setting, cal_value )
199 VALUES ('POPUP_BG','#FFFFFF');
200 INSERT INTO webcal_config ( cal_setting, cal_value )
201 VALUES ('TODAYCELLBG','#FFFF33');
202 INSERT INTO webcal_config ( cal_setting, cal_value )
203 VALUES ( 'STARTVIEW', 'week.php' );
204 INSERT INTO webcal_config ( cal_setting, cal_value )
205 VALUES ( 'WEEK_START', '0' );
206 INSERT INTO webcal_config ( cal_setting, cal_value )
207 VALUES ( 'TIME_FORMAT', '12' );
208 INSERT INTO webcal_config ( cal_setting, cal_value )
209 VALUES ( 'DISPLAY_UNAPPROVED', 'Y' );
210 INSERT INTO webcal_config ( cal_setting, cal_value )
211 VALUES ( 'DISPLAY_WEEKNUMBER', 'Y' );
212 INSERT INTO webcal_config ( cal_setting, cal_value )
213 VALUES ( 'WORK_DAY_START_HOUR', '8' );
214 INSERT INTO webcal_config ( cal_setting, cal_value )
215 VALUES ( 'WORK_DAY_END_HOUR', '17' );
216 INSERT INTO webcal_config ( cal_setting, cal_value )
217 VALUES ( 'send_email', 'N' );
218 INSERT INTO webcal_config ( cal_setting, cal_value )
219 VALUES ( 'EMAIL_REMINDER', 'Y' );
220 INSERT INTO webcal_config ( cal_setting, cal_value )
221 VALUES ( 'EMAIL_EVENT_ADDED', 'Y' );
222 INSERT INTO webcal_config ( cal_setting, cal_value )
223 VALUES ( 'EMAIL_EVENT_UPDATED', 'Y' );
224 INSERT INTO webcal_config ( cal_setting, cal_value )
225 VALUES ( 'EMAIL_EVENT_DELETED', 'Y' );
226 INSERT INTO webcal_config ( cal_setting, cal_value )
227 VALUES ( 'EMAIL_EVENT_REJECTED', 'Y' );
228 INSERT INTO webcal_config ( cal_setting, cal_value )
229 VALUES ('auto_refresh', 'N');
230 INSERT INTO webcal_config ( cal_setting, cal_value )
231 VALUES ('nonuser_enabled', 'N');
232 INSERT INTO webcal_config ( cal_setting, cal_value )
233 VALUES ('allow_html_description', 'N');
234 INSERT INTO webcal_config ( cal_setting, cal_value )
235 VALUES ('reports_enabled', 'N');
236 INSERT INTO webcal_config ( cal_setting, cal_value )
237 VALUES ('DISPLAY_WEEKENDS', 'Y');
238 INSERT INTO webcal_config ( cal_setting, cal_value )
239 VALUES ('DISPLAY_DESC_PRINT_DAY', 'N');
240 INSERT INTO webcal_config ( cal_setting, cal_value )
241 VALUES ('DATE_FORMAT', '__month__ __dd__, __yyyy__');
242 INSERT INTO webcal_config ( cal_setting, cal_value )
243 VALUES ('TIME_SLOTS', '12');
244 INSERT INTO webcal_config ( cal_setting, cal_value )
245 VALUES ('TIMED_EVT_LEN', 'D');
246 INSERT INTO webcal_config ( cal_setting, cal_value )
247 VALUES ('PUBLISH_ENABLED', 'N');
248 INSERT INTO webcal_config ( cal_setting, cal_value )
249 VALUES ('DATE_FORMAT_MY', '__month__ __yyyy__');
250 INSERT INTO webcal_config ( cal_setting, cal_value )
251 VALUES ('DATE_FORMAT_MD', '__month__ __dd__');
252 INSERT INTO webcal_config ( cal_setting, cal_value )
253 VALUES ('CUSTOM_SCRIPT', 'N');
254 INSERT INTO webcal_config ( cal_setting, cal_value )
255 VALUES ('CUSTOM_HEADER', 'N');
256 INSERT INTO webcal_config ( cal_setting, cal_value )
257 VALUES ('CUSTOM_TRAILER', 'N');
258 INSERT INTO webcal_config ( cal_setting, cal_value )
259 VALUES ('bold_days_in_year', 'Y');
260 INSERT INTO webcal_config ( cal_setting, cal_value )
261 VALUES ('site_extras_in_popup', 'N');
262 INSERT INTO webcal_config ( cal_setting, cal_value )
263 VALUES ('add_link_in_views', 'Y');
264 INSERT INTO webcal_config ( cal_setting, cal_value )
265 VALUES ('allow_conflict_override', 'Y');
266 INSERT INTO webcal_config ( cal_setting, cal_value )
267 VALUES ('limit_appts', 'N');
268 INSERT INTO webcal_config ( cal_setting, cal_value )
269 VALUES ('limit_appts_number', '6');
270 INSERT INTO webcal_config ( cal_setting, cal_value )
271 VALUES ('public_access', 'N');
272 INSERT INTO webcal_config ( cal_setting, cal_value )
273 VALUES ('public_access_default_visible', 'N');
274 INSERT INTO webcal_config ( cal_setting, cal_value )
275 VALUES ('public_access_default_selected', 'N');
276 INSERT INTO webcal_config ( cal_setting, cal_value )
277 VALUES ('public_access_others', 'N');
278 INSERT INTO webcal_config ( cal_setting, cal_value )
279 VALUES ('public_access_can_add', 'N');
280 INSERT INTO webcal_config ( cal_setting, cal_value )
281 VALUES ('public_access_add_needs_approval', 'Y');
282 INSERT INTO webcal_config ( cal_setting, cal_value )
283 VALUES ('public_access_view_part', 'N');
284 INSERT INTO webcal_config ( cal_setting, cal_value )
285 VALUES ('nonuser_at_top', 'Y');
286 INSERT INTO webcal_config ( cal_setting, cal_value )
287 VALUES ('allow_external_users', 'N');
288 INSERT INTO webcal_config ( cal_setting, cal_value )
289 VALUES ('external_notifications', 'N');
290 INSERT INTO webcal_config ( cal_setting, cal_value )
291 VALUES ('external_reminders', 'N');
292 INSERT INTO webcal_config ( cal_setting, cal_value )
293 VALUES ('enable_gradients', 'N');
297 CREATE TABLE webcal_entry_log (
298 cal_log_id INT NOT NULL,
299 cal_entry_id INT NOT NULL,
300 cal_login VARCHAR(25) NOT NULL,
301 cal_user_cal VARCHAR(25),
302 cal_type CHAR(1) NOT NULL,
303 cal_date INT NOT NULL,
305 cal_text varchar(1024),
306 PRIMARY KEY ( cal_log_id )
310 CREATE TABLE webcal_categories (
312 cat_owner VARCHAR(25),
313 cat_name VARCHAR(80) NOT NULL,
314 PRIMARY KEY ( cat_id )
317 CREATE TABLE webcal_asst (
318 cal_boss VARCHAR(25) NOT NULL,
319 cal_assistant VARCHAR(25) NOT NULL,
320 PRIMARY KEY ( cal_boss, cal_assistant )
323 CREATE TABLE webcal_nonuser_cals (
324 cal_login VARCHAR(25) NOT NULL,
325 cal_lastname VARCHAR(25),
326 cal_firstname VARCHAR(25),
327 cal_admin VARCHAR(25) NOT NULL,
328 PRIMARY KEY ( cal_login )
331 CREATE TABLE webcal_import (
332 cal_import_id INT NOT NULL,
333 cal_name VARCHAR(50) DEFAULT NULL,
334 cal_date INT NOT NULL,
335 cal_type VARCHAR(10) NOT NULL,
336 cal_login VARCHAR(25),
337 PRIMARY KEY ( cal_import_id )
340 CREATE TABLE webcal_import_data (
341 cal_import_id INT NOT NULL,
343 cal_login VARCHAR(25) NOT NULL,
344 cal_import_type VARCHAR(15) NOT NULL,
345 cal_external_id VARCHAR(200) DEFAULT NULL,
346 PRIMARY KEY ( cal_id, cal_login )
349 CREATE TABLE webcal_report (
350 cal_login VARCHAR(25) NOT NULL,
351 cal_report_id INT NOT NULL,
352 cal_is_global CHAR(1) DEFAULT 'N' NOT NULL,
353 cal_report_type VARCHAR(20) NOT NULL,
354 cal_include_header CHAR(1) DEFAULT 'Y' NOT NULL,
355 cal_report_name VARCHAR(50) NOT NULL,
356 cal_time_range INT NOT NULL,
357 cal_user VARCHAR(25) DEFAULT NULL,
358 cal_allow_nav CHAR(1) DEFAULT 'Y',
359 cal_cat_id INT DEFAULT NULL,
360 cal_include_empty CHAR(1) DEFAULT 'N',
361 cal_show_in_trailer CHAR(1) DEFAULT 'N',
362 cal_update_date INT NOT NULL,
363 PRIMARY KEY ( cal_report_id )
366 CREATE TABLE webcal_report_template (
367 cal_report_id INT NOT NULL,
368 cal_template_type CHAR(1) NOT NULL,
369 cal_template_text VARCHAR(1024),
370 PRIMARY KEY ( cal_report_id, cal_template_type )