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 ( cal_login, cal_passwd, cal_lastname, cal_firstname, cal_is_admin ) VALUES ( 'admin', '21232f297a57a5a743894a0e4a801fc3', 'Administrator', 'Default', 'Y' );
14 CREATE TABLE webcal_entry (
17 cal_ext_for_id INT NULL,
18 cal_create_by VARCHAR(25) NOT NULL,
19 cal_date INT NOT NULL,
23 cal_duration INT NOT NULL,
24 cal_priority INT DEFAULT 2,
25 cal_type CHAR(1) DEFAULT 'E',
26 cal_access CHAR(1) DEFAULT 'P',
27 cal_name VARCHAR(80) NOT NULL,
29 PRIMARY KEY ( cal_id )
33 CREATE TABLE webcal_entry_repeats (
34 cal_id INT DEFAULT '0' NOT NULL,
37 cal_frequency INT DEFAULT '1',
43 CREATE TABLE webcal_entry_repeats_not (
45 cal_date INT NOT NULL,
46 PRIMARY KEY ( cal_id, cal_date )
50 CREATE TABLE webcal_entry_user (
51 cal_id int DEFAULT '0' NOT NULL,
52 cal_login varchar(25) DEFAULT '' NOT NULL,
53 cal_status char(1) DEFAULT 'A' NOT NULL,
54 cal_category INT DEFAULT NULL,
55 PRIMARY KEY ( cal_id,cal_login )
59 CREATE TABLE webcal_entry_ext_user (
60 cal_id INT DEFAULT 0 NOT NULL,
61 cal_fullname VARCHAR(50) NOT NULL,
62 cal_email VARCHAR(75) NOT NULL,
63 PRIMARY KEY ( cal_id, cal_fullname )
67 CREATE TABLE webcal_user_pref (
68 cal_login varchar(25) NOT NULL,
69 cal_setting varchar(25) NOT NULL,
70 cal_value varchar(100),
71 PRIMARY KEY ( cal_login, cal_setting )
76 CREATE TABLE webcal_user_layers (
77 cal_layerid INT DEFAULT '0' NOT NULL,
78 cal_login varchar(25) NOT NULL,
79 cal_layeruser varchar(25) NOT NULL,
80 cal_color varchar(25),
81 cal_dups CHAR(1) DEFAULT 'N',
82 PRIMARY KEY ( cal_login, cal_layeruser )
87 CREATE TABLE webcal_site_extras (
88 cal_id INT DEFAULT '0' NOT NULL,
89 cal_name VARCHAR(25) NOT NULL,
90 cal_type INT NOT NULL,
91 cal_date INT DEFAULT '0',
92 cal_remind INT DEFAULT '0',
94 PRIMARY KEY ( cal_id, cal_name, cal_type )
98 CREATE TABLE webcal_reminder_log (
99 cal_id INT DEFAULT '0' NOT NULL,
100 cal_name VARCHAR(25) NOT NULL,
101 cal_event_date INT NOT NULL DEFAULT 0,
102 cal_last_sent INT NOT NULL DEFAULT 0,
103 PRIMARY KEY ( cal_id, cal_name, cal_event_date )
106 CREATE TABLE webcal_group (
107 cal_group_id INT NOT NULL,
108 cal_owner VARCHAR(25) NOT NULL,
109 cal_name VARCHAR(50) NOT NULL,
110 cal_last_update INT NOT NULL,
111 PRIMARY KEY ( cal_group_id )
114 CREATE TABLE webcal_group_user (
115 cal_group_id INT NOT NULL,
116 cal_login VARCHAR(25) NOT NULL,
117 PRIMARY KEY ( cal_group_id, cal_login )
120 CREATE TABLE webcal_view (
121 cal_view_id INT NOT NULL,
122 cal_owner VARCHAR(25) NOT NULL,
123 cal_name VARCHAR(50) NOT NULL,
124 cal_view_type CHAR(1),
125 cal_is_global CHAR(1) DEFAULT 'N' NOT NULL,
126 PRIMARY KEY ( cal_view_id )
129 CREATE TABLE webcal_view_user (
130 cal_view_id INT NOT NULL,
131 cal_login VARCHAR(25) NOT NULL,
132 PRIMARY KEY ( cal_view_id, cal_login )
135 CREATE TABLE webcal_config (
136 cal_setting VARCHAR(50) NOT NULL,
137 cal_value VARCHAR(100) NOT NULL,
138 PRIMARY KEY ( cal_setting )
142 INSERT INTO webcal_config ( cal_setting, cal_value )
143 VALUES ( 'application_name', 'WebCalendar' );
144 INSERT INTO webcal_config ( cal_setting, cal_value )
145 VALUES ( 'LANGUAGE', 'Browser-defined' );
146 INSERT INTO webcal_config ( cal_setting, cal_value )
147 VALUES ( 'demo_mode', 'N' );
148 INSERT INTO webcal_config ( cal_setting, cal_value )
149 VALUES ( 'require_approvals', 'Y' );
150 INSERT INTO webcal_config ( cal_setting, cal_value )
151 VALUES ( 'groups_enabled', 'N' );
152 INSERT INTO webcal_config ( cal_setting, cal_value )
153 VALUES ( 'user_sees_only_his_groups', 'N' );
154 INSERT INTO webcal_config ( cal_setting, cal_value )
155 VALUES ( 'categories_enabled', 'N' );
156 INSERT INTO webcal_config ( cal_setting, cal_value )
157 VALUES ( 'allow_conflicts', 'N' );
158 INSERT INTO webcal_config ( cal_setting, cal_value )
159 VALUES ( 'conflict_repeat_months', '6' );
160 INSERT INTO webcal_config ( cal_setting, cal_value )
161 VALUES ( 'disable_priority_field', 'N' );
162 INSERT INTO webcal_config ( cal_setting, cal_value )
163 VALUES ( 'disable_access_field', 'N' );
164 INSERT INTO webcal_config ( cal_setting, cal_value )
165 VALUES ( 'disable_participants_field', 'N' );
166 INSERT INTO webcal_config ( cal_setting, cal_value )
167 VALUES ( 'disable_repeating_field', 'N' );
168 INSERT INTO webcal_config ( cal_setting, cal_value )
169 VALUES ( 'allow_view_other', 'Y' );
170 INSERT INTO webcal_config ( cal_setting, cal_value )
171 VALUES ( 'email_fallback_from', 'youremailhere' );
172 INSERT INTO webcal_config ( cal_setting, cal_value )
173 VALUES ( 'remember_last_login', 'Y' );
174 INSERT INTO webcal_config ( cal_setting, cal_value )
175 VALUES ( 'allow_color_customization', 'Y' );
176 INSERT INTO webcal_config ( cal_setting, cal_value )
177 VALUES ('BGCOLOR','#FFFFFF');
178 INSERT INTO webcal_config ( cal_setting, cal_value )
179 VALUES ('TEXTCOLOR','#000000');
180 INSERT INTO webcal_config ( cal_setting, cal_value )
181 VALUES ('H2COLOR','#000000');
182 INSERT INTO webcal_config ( cal_setting, cal_value )
183 VALUES ('CELLBG','#C0C0C0');
184 INSERT INTO webcal_config ( cal_setting, cal_value )
185 VALUES ('WEEKENDBG','#D0D0D0');
186 INSERT INTO webcal_config ( cal_setting, cal_value )
187 VALUES ('TABLEBG','#000000');
188 INSERT INTO webcal_config ( cal_setting, cal_value )
189 VALUES ('THBG','#FFFFFF');
190 INSERT INTO webcal_config ( cal_setting, cal_value )
191 VALUES ('THFG','#000000');
192 INSERT INTO webcal_config ( cal_setting, cal_value )
193 VALUES ('POPUP_FG','#000000');
194 INSERT INTO webcal_config ( cal_setting, cal_value )
195 VALUES ('POPUP_BG','#FFFFFF');
196 INSERT INTO webcal_config ( cal_setting, cal_value )
197 VALUES ('TODAYCELLBG','#FFFF33');
198 INSERT INTO webcal_config ( cal_setting, cal_value )
199 VALUES ( 'STARTVIEW', 'week.php' );
200 INSERT INTO webcal_config ( cal_setting, cal_value )
201 VALUES ( 'WEEK_START', '0' );
202 INSERT INTO webcal_config ( cal_setting, cal_value )
203 VALUES ( 'TIME_FORMAT', '12' );
204 INSERT INTO webcal_config ( cal_setting, cal_value )
205 VALUES ( 'DISPLAY_UNAPPROVED', 'Y' );
206 INSERT INTO webcal_config ( cal_setting, cal_value )
207 VALUES ( 'DISPLAY_WEEKNUMBER', 'Y' );
208 INSERT INTO webcal_config ( cal_setting, cal_value )
209 VALUES ( 'WORK_DAY_START_HOUR', '8' );
210 INSERT INTO webcal_config ( cal_setting, cal_value )
211 VALUES ( 'WORK_DAY_END_HOUR', '17' );
212 INSERT INTO webcal_config ( cal_setting, cal_value )
213 VALUES ( 'send_email', 'N' );
214 INSERT INTO webcal_config ( cal_setting, cal_value )
215 VALUES ( 'EMAIL_REMINDER', 'Y' );
216 INSERT INTO webcal_config ( cal_setting, cal_value )
217 VALUES ( 'EMAIL_EVENT_ADDED', 'Y' );
218 INSERT INTO webcal_config ( cal_setting, cal_value )
219 VALUES ( 'EMAIL_EVENT_UPDATED', 'Y' );
220 INSERT INTO webcal_config ( cal_setting, cal_value )
221 VALUES ( 'EMAIL_EVENT_DELETED', 'Y' );
222 INSERT INTO webcal_config ( cal_setting, cal_value )
223 VALUES ( 'EMAIL_EVENT_REJECTED', 'Y' );
224 INSERT INTO webcal_config ( cal_setting, cal_value )
225 VALUES ('auto_refresh', 'N');
226 INSERT INTO webcal_config ( cal_setting, cal_value )
227 VALUES ('nonuser_enabled', 'N');
228 INSERT INTO webcal_config ( cal_setting, cal_value )
229 VALUES ('allow_html_description', 'N');
230 INSERT INTO webcal_config ( cal_setting, cal_value )
231 VALUES ('reports_enabled', 'N');
232 INSERT INTO webcal_config ( cal_setting, cal_value )
233 VALUES ('DISPLAY_WEEKENDS', 'Y');
234 INSERT INTO webcal_config ( cal_setting, cal_value )
235 VALUES ('DISPLAY_DESC_PRINT_DAY', 'N');
236 INSERT INTO webcal_config ( cal_setting, cal_value )
237 VALUES ('DATE_FORMAT', '__month__ __dd__, __yyyy__');
238 INSERT INTO webcal_config ( cal_setting, cal_value )
239 VALUES ('TIME_SLOTS', '12');
240 INSERT INTO webcal_config ( cal_setting, cal_value )
241 VALUES ('TIMED_EVT_LEN', 'D');
242 INSERT INTO webcal_config ( cal_setting, cal_value )
243 VALUES ('PUBLISH_ENABLED', 'N');
244 INSERT INTO webcal_config ( cal_setting, cal_value )
245 VALUES ('DATE_FORMAT_MY', '__month__ __yyyy__');
246 INSERT INTO webcal_config ( cal_setting, cal_value )
247 VALUES ('DATE_FORMAT_MD', '__month__ __dd__');
248 INSERT INTO webcal_config ( cal_setting, cal_value )
249 VALUES ('CUSTOM_SCRIPT', 'N');
250 INSERT INTO webcal_config ( cal_setting, cal_value )
251 VALUES ('CUSTOM_HEADER', 'N');
252 INSERT INTO webcal_config ( cal_setting, cal_value )
253 VALUES ('CUSTOM_TRAILER', 'N');
254 INSERT INTO webcal_config ( cal_setting, cal_value )
255 VALUES ('bold_days_in_year', 'Y');
256 INSERT INTO webcal_config ( cal_setting, cal_value )
257 VALUES ('site_extras_in_popup', 'N');
258 INSERT INTO webcal_config ( cal_setting, cal_value )
259 VALUES ('add_link_in_views', 'Y');
260 INSERT INTO webcal_config ( cal_setting, cal_value )
261 VALUES ('allow_conflict_override', 'Y');
262 INSERT INTO webcal_config ( cal_setting, cal_value )
263 VALUES ('limit_appts', 'N');
264 INSERT INTO webcal_config ( cal_setting, cal_value )
265 VALUES ('limit_appts_number', '6');
266 INSERT INTO webcal_config ( cal_setting, cal_value )
267 VALUES ('public_access', 'N');
268 INSERT INTO webcal_config ( cal_setting, cal_value )
269 VALUES ('public_access_default_visible', 'N');
270 INSERT INTO webcal_config ( cal_setting, cal_value )
271 VALUES ('public_access_default_selected', 'N');
272 INSERT INTO webcal_config ( cal_setting, cal_value )
273 VALUES ('public_access_others', 'N');
274 INSERT INTO webcal_config ( cal_setting, cal_value )
275 VALUES ('public_access_can_add', 'N');
276 INSERT INTO webcal_config ( cal_setting, cal_value )
277 VALUES ('public_access_add_needs_approval', 'Y');
278 INSERT INTO webcal_config ( cal_setting, cal_value )
279 VALUES ('public_access_view_part', 'N');
280 INSERT INTO webcal_config ( cal_setting, cal_value )
281 VALUES ('nonuser_at_top', 'Y');
282 INSERT INTO webcal_config ( cal_setting, cal_value )
283 VALUES ('allow_external_users', 'N');
284 INSERT INTO webcal_config ( cal_setting, cal_value )
285 VALUES ('external_notifications', 'N');
286 INSERT INTO webcal_config ( cal_setting, cal_value )
287 VALUES ('external_reminders', 'N');
288 INSERT INTO webcal_config ( cal_setting, cal_value )
289 VALUES ('enable_gradients', 'N');
293 CREATE TABLE webcal_entry_log (
294 cal_log_id INT NOT NULL,
295 cal_entry_id INT NOT NULL,
296 cal_login VARCHAR(25) NOT NULL,
297 cal_user_cal VARCHAR(25) NOT NULL,
298 cal_type CHAR(1) NOT NULL,
299 cal_date INT NOT NULL,
300 cal_time INT NOT NULL,
302 PRIMARY KEY ( cal_log_id )
306 CREATE TABLE webcal_categories (
308 cat_owner VARCHAR(25),
309 cat_name VARCHAR(80) NOT NULL,
310 PRIMARY KEY ( cat_id )
313 CREATE TABLE webcal_asst (
314 cal_boss VARCHAR(25) NOT NULL,
315 cal_assistant VARCHAR(25) NOT NULL,
316 PRIMARY KEY ( cal_boss, cal_assistant )
319 CREATE TABLE webcal_nonuser_cals (
320 cal_login VARCHAR(25) NOT NULL,
321 cal_lastname VARCHAR(25) NULL,
322 cal_firstname VARCHAR(25) NULL,
323 cal_admin VARCHAR(25) NOT NULL,
324 PRIMARY KEY ( cal_login )
327 CREATE TABLE webcal_import (
328 cal_import_id INT NOT NULL,
329 cal_name VARCHAR(50) NULL,
330 cal_date INT NOT NULL,
331 cal_type VARCHAR(10) NOT NULL,
332 cal_login VARCHAR(25) NULL,
333 PRIMARY KEY ( cal_import_id )
336 CREATE TABLE webcal_import_data (
337 cal_import_id INT NOT NULL,
339 cal_login VARCHAR(25) NOT NULL,
340 cal_import_type VARCHAR(15) NOT NULL,
341 cal_external_id VARCHAR(200) NULL,
342 PRIMARY KEY ( cal_id, cal_login )
346 CREATE TABLE webcal_report (
347 cal_login VARCHAR(25) NOT NULL,
348 cal_report_id INT NOT NULL,
349 cal_is_global CHAR(1) DEFAULT 'N' NOT NULL,
350 cal_report_type VARCHAR(20) NOT NULL,
351 cal_include_header CHAR(1) DEFAULT 'Y' NOT NULL,
352 cal_report_name VARCHAR(50) NOT NULL,
353 cal_time_range INT NOT NULL,
354 cal_user VARCHAR(25) NULL,
355 cal_allow_nav CHAR(1) DEFAULT 'Y',
357 cal_include_empty CHAR(1) DEFAULT 'N',
358 cal_show_in_trailer CHAR(1) DEFAULT 'N',
359 cal_update_date INT NOT NULL,
360 PRIMARY KEY ( cal_report_id )
363 CREATE TABLE webcal_report_template (
364 cal_report_id INT NOT NULL,
365 cal_template_type CHAR(1) NOT NULL,
366 cal_template_text TEXT,
367 PRIMARY KEY ( cal_report_id, cal_template_type )