1 CREATE VIEW webcal_user AS
2 SELECT user_name AS cal_login, user_pw AS cal_passwd, lastname AS cal_lastname, firstname AS cal_firstname, status AS cal_is_admin, email AS cal_email FROM users;
3 -- CREATE TABLE webcal_user (
4 -- cal_login VARCHAR(25) NOT NULL,
5 -- cal_passwd VARCHAR(32),
6 -- cal_lastname VARCHAR(25),
7 -- cal_firstname VARCHAR(25),
8 -- cal_is_admin CHAR(1) DEFAULT 'N',
9 -- cal_email VARCHAR(75),
10 -- PRIMARY KEY ( cal_login )
13 CREATE TABLE webcal_entry (
16 cal_ext_for_id INT NULL,
17 cal_create_by VARCHAR(25) NOT NULL,
18 cal_date INT NOT NULL,
22 cal_duration INT NOT NULL,
23 cal_priority INT DEFAULT 2,
24 cal_type CHAR(1) DEFAULT 'E',
25 cal_access CHAR(1) DEFAULT 'P',
26 cal_name VARCHAR(80) NOT NULL,
28 PRIMARY KEY ( cal_id )
32 CREATE TABLE webcal_entry_repeats (
33 cal_id INT DEFAULT '0' NOT NULL,
36 cal_frequency INT DEFAULT '1',
42 CREATE TABLE webcal_entry_repeats_not (
44 cal_date INT NOT NULL,
45 PRIMARY KEY ( cal_id, cal_date )
49 CREATE TABLE webcal_entry_user (
50 cal_id int DEFAULT '0' NOT NULL,
51 cal_login varchar(25) DEFAULT '' NOT NULL,
52 cal_status char(1) DEFAULT 'A' NOT NULL,
53 cal_category INT DEFAULT NULL,
54 PRIMARY KEY ( cal_id,cal_login )
58 CREATE TABLE webcal_entry_ext_user (
59 cal_id INT DEFAULT 0 NOT NULL,
60 cal_fullname VARCHAR(50) NOT NULL,
61 cal_email VARCHAR(75) NOT NULL,
62 PRIMARY KEY ( cal_id, cal_fullname )
66 CREATE TABLE webcal_user_pref (
67 cal_login varchar(25) NOT NULL,
68 cal_setting varchar(25) NOT NULL,
69 cal_value varchar(100),
70 PRIMARY KEY ( cal_login, cal_setting )
75 CREATE TABLE webcal_user_layers (
76 cal_layerid INT DEFAULT '0' NOT NULL,
77 cal_login varchar(25) NOT NULL,
78 cal_layeruser varchar(25) NOT NULL,
79 cal_color varchar(25),
80 cal_dups CHAR(1) DEFAULT 'N',
81 PRIMARY KEY ( cal_login, cal_layeruser )
86 CREATE TABLE webcal_site_extras (
87 cal_id INT DEFAULT '0' NOT NULL,
88 cal_name VARCHAR(25) NOT NULL,
89 cal_type INT NOT NULL,
90 cal_date INT DEFAULT '0',
91 cal_remind INT DEFAULT '0',
93 PRIMARY KEY ( cal_id, cal_name, cal_type )
97 CREATE TABLE webcal_reminder_log (
98 cal_id INT DEFAULT '0' NOT NULL,
99 cal_name VARCHAR(25) NOT NULL,
100 cal_event_date INT NOT NULL DEFAULT 0,
101 cal_last_sent INT NOT NULL DEFAULT 0,
102 PRIMARY KEY ( cal_id, cal_name, cal_event_date )
105 CREATE VIEW webcal_group AS
106 SELECT group_id AS cal_group_id, 'admin' AS cal_owner, unix_group_name AS cal_name, register_time AS cal_last_update FROM groups;
107 --CREATE TABLE webcal_group (
108 -- cal_group_id INT NOT NULL,
109 -- cal_owner VARCHAR(25) NOT NULL,
110 -- cal_name VARCHAR(50) NOT NULL,
111 -- cal_last_update INT NOT NULL,
112 -- PRIMARY KEY ( cal_group_id )
115 DROP TABLE webcal_group_user;
116 CREATE VIEW webcal_group_user AS
117 SELECT group_id AS cal_group_id, users.user_name AS cal_login FROM users,user_group
118 WHERE users.user_id = user_group.user_id;
119 --CREATE TABLE webcal_group_user (
120 -- cal_group_id INT NOT NULL,
121 -- cal_login VARCHAR(25) NOT NULL,
122 -- PRIMARY KEY ( cal_group_id, cal_login )
125 CREATE TABLE webcal_view (
126 cal_view_id INT NOT NULL,
127 cal_owner VARCHAR(25) NOT NULL,
128 cal_name VARCHAR(50) NOT NULL,
129 cal_view_type CHAR(1),
130 cal_is_global CHAR(1) DEFAULT 'N' NOT NULL,
131 PRIMARY KEY ( cal_view_id )
134 CREATE TABLE webcal_view_user (
135 cal_view_id INT NOT NULL,
136 cal_login VARCHAR(25) NOT NULL,
137 PRIMARY KEY ( cal_view_id, cal_login )
140 CREATE TABLE webcal_config (
141 cal_setting VARCHAR(50) NOT NULL,
142 cal_value VARCHAR(100) NOT NULL,
143 PRIMARY KEY ( cal_setting )
147 INSERT INTO webcal_config ( cal_setting, cal_value )
148 VALUES ( 'application_name', 'WebCalendar' );
149 INSERT INTO webcal_config ( cal_setting, cal_value )
150 VALUES ( 'LANGUAGE', 'Browser-defined' );
151 INSERT INTO webcal_config ( cal_setting, cal_value )
152 VALUES ( 'demo_mode', 'N' );
153 INSERT INTO webcal_config ( cal_setting, cal_value )
154 VALUES ( 'require_approvals', 'Y' );
155 INSERT INTO webcal_config ( cal_setting, cal_value )
156 VALUES ( 'groups_enabled', 'N' );
157 INSERT INTO webcal_config ( cal_setting, cal_value )
158 VALUES ( 'user_sees_only_his_groups', 'N' );
159 INSERT INTO webcal_config ( cal_setting, cal_value )
160 VALUES ( 'categories_enabled', 'N' );
161 INSERT INTO webcal_config ( cal_setting, cal_value )
162 VALUES ( 'allow_conflicts', 'N' );
163 INSERT INTO webcal_config ( cal_setting, cal_value )
164 VALUES ( 'conflict_repeat_months', '6' );
165 INSERT INTO webcal_config ( cal_setting, cal_value )
166 VALUES ( 'disable_priority_field', 'N' );
167 INSERT INTO webcal_config ( cal_setting, cal_value )
168 VALUES ( 'disable_access_field', 'N' );
169 INSERT INTO webcal_config ( cal_setting, cal_value )
170 VALUES ( 'disable_participants_field', 'N' );
171 INSERT INTO webcal_config ( cal_setting, cal_value )
172 VALUES ( 'disable_repeating_field', 'N' );
173 INSERT INTO webcal_config ( cal_setting, cal_value )
174 VALUES ( 'allow_view_other', 'Y' );
175 INSERT INTO webcal_config ( cal_setting, cal_value )
176 VALUES ( 'email_fallback_from', 'youremailhere' );
177 INSERT INTO webcal_config ( cal_setting, cal_value )
178 VALUES ( 'remember_last_login', 'Y' );
179 INSERT INTO webcal_config ( cal_setting, cal_value )
180 VALUES ( 'allow_color_customization', 'Y' );
181 INSERT INTO webcal_config ( cal_setting, cal_value )
182 VALUES ('BGCOLOR','#FFFFFF');
183 INSERT INTO webcal_config ( cal_setting, cal_value )
184 VALUES ('TEXTCOLOR','#000000');
185 INSERT INTO webcal_config ( cal_setting, cal_value )
186 VALUES ('H2COLOR','#000000');
187 INSERT INTO webcal_config ( cal_setting, cal_value )
188 VALUES ('CELLBG','#C0C0C0');
189 INSERT INTO webcal_config ( cal_setting, cal_value )
190 VALUES ('WEEKENDBG','#D0D0D0');
191 INSERT INTO webcal_config ( cal_setting, cal_value )
192 VALUES ('TABLEBG','#000000');
193 INSERT INTO webcal_config ( cal_setting, cal_value )
194 VALUES ('THBG','#FFFFFF');
195 INSERT INTO webcal_config ( cal_setting, cal_value )
196 VALUES ('THFG','#000000');
197 INSERT INTO webcal_config ( cal_setting, cal_value )
198 VALUES ('POPUP_FG','#000000');
199 INSERT INTO webcal_config ( cal_setting, cal_value )
200 VALUES ('POPUP_BG','#FFFFFF');
201 INSERT INTO webcal_config ( cal_setting, cal_value )
202 VALUES ('TODAYCELLBG','#FFFF33');
203 INSERT INTO webcal_config ( cal_setting, cal_value )
204 VALUES ( 'STARTVIEW', 'week.php' );
205 INSERT INTO webcal_config ( cal_setting, cal_value )
206 VALUES ( 'WEEK_START', '0' );
207 INSERT INTO webcal_config ( cal_setting, cal_value )
208 VALUES ( 'TIME_FORMAT', '12' );
209 INSERT INTO webcal_config ( cal_setting, cal_value )
210 VALUES ( 'DISPLAY_UNAPPROVED', 'Y' );
211 INSERT INTO webcal_config ( cal_setting, cal_value )
212 VALUES ( 'DISPLAY_WEEKNUMBER', 'Y' );
213 INSERT INTO webcal_config ( cal_setting, cal_value )
214 VALUES ( 'WORK_DAY_START_HOUR', '8' );
215 INSERT INTO webcal_config ( cal_setting, cal_value )
216 VALUES ( 'WORK_DAY_END_HOUR', '17' );
217 INSERT INTO webcal_config ( cal_setting, cal_value )
218 VALUES ( 'send_email', 'N' );
219 INSERT INTO webcal_config ( cal_setting, cal_value )
220 VALUES ( 'EMAIL_REMINDER', 'Y' );
221 INSERT INTO webcal_config ( cal_setting, cal_value )
222 VALUES ( 'EMAIL_EVENT_ADDED', 'Y' );
223 INSERT INTO webcal_config ( cal_setting, cal_value )
224 VALUES ( 'EMAIL_EVENT_UPDATED', 'Y' );
225 INSERT INTO webcal_config ( cal_setting, cal_value )
226 VALUES ( 'EMAIL_EVENT_DELETED', 'Y' );
227 INSERT INTO webcal_config ( cal_setting, cal_value )
228 VALUES ( 'EMAIL_EVENT_REJECTED', 'Y' );
229 INSERT INTO webcal_config ( cal_setting, cal_value )
230 VALUES ('auto_refresh', 'N');
231 INSERT INTO webcal_config ( cal_setting, cal_value )
232 VALUES ('nonuser_enabled', 'N');
233 INSERT INTO webcal_config ( cal_setting, cal_value )
234 VALUES ('allow_html_description', 'N');
235 INSERT INTO webcal_config ( cal_setting, cal_value )
236 VALUES ('reports_enabled', 'N');
237 INSERT INTO webcal_config ( cal_setting, cal_value )
238 VALUES ('DISPLAY_WEEKENDS', 'Y');
239 INSERT INTO webcal_config ( cal_setting, cal_value )
240 VALUES ('DISPLAY_DESC_PRINT_DAY', 'N');
241 INSERT INTO webcal_config ( cal_setting, cal_value )
242 VALUES ('DATE_FORMAT', '__month__ __dd__, __yyyy__');
243 INSERT INTO webcal_config ( cal_setting, cal_value )
244 VALUES ('TIME_SLOTS', '12');
245 INSERT INTO webcal_config ( cal_setting, cal_value )
246 VALUES ('TIMED_EVT_LEN', 'D');
247 INSERT INTO webcal_config ( cal_setting, cal_value )
248 VALUES ('PUBLISH_ENABLED', 'N');
249 INSERT INTO webcal_config ( cal_setting, cal_value )
250 VALUES ('DATE_FORMAT_MY', '__month__ __yyyy__');
251 INSERT INTO webcal_config ( cal_setting, cal_value )
252 VALUES ('DATE_FORMAT_MD', '__month__ __dd__');
253 INSERT INTO webcal_config ( cal_setting, cal_value )
254 VALUES ('CUSTOM_SCRIPT', 'N');
255 INSERT INTO webcal_config ( cal_setting, cal_value )
256 VALUES ('CUSTOM_HEADER', 'N');
257 INSERT INTO webcal_config ( cal_setting, cal_value )
258 VALUES ('CUSTOM_TRAILER', 'N');
259 INSERT INTO webcal_config ( cal_setting, cal_value )
260 VALUES ('bold_days_in_year', 'Y');
261 INSERT INTO webcal_config ( cal_setting, cal_value )
262 VALUES ('site_extras_in_popup', 'N');
263 INSERT INTO webcal_config ( cal_setting, cal_value )
264 VALUES ('add_link_in_views', 'Y');
265 INSERT INTO webcal_config ( cal_setting, cal_value )
266 VALUES ('allow_conflict_override', 'Y');
267 INSERT INTO webcal_config ( cal_setting, cal_value )
268 VALUES ('limit_appts', 'N');
269 INSERT INTO webcal_config ( cal_setting, cal_value )
270 VALUES ('limit_appts_number', '6');
271 INSERT INTO webcal_config ( cal_setting, cal_value )
272 VALUES ('public_access', 'N');
273 INSERT INTO webcal_config ( cal_setting, cal_value )
274 VALUES ('public_access_default_visible', 'N');
275 INSERT INTO webcal_config ( cal_setting, cal_value )
276 VALUES ('public_access_default_selected', 'N');
277 INSERT INTO webcal_config ( cal_setting, cal_value )
278 VALUES ('public_access_others', 'N');
279 INSERT INTO webcal_config ( cal_setting, cal_value )
280 VALUES ('public_access_can_add', 'N');
281 INSERT INTO webcal_config ( cal_setting, cal_value )
282 VALUES ('public_access_add_needs_approval', 'Y');
283 INSERT INTO webcal_config ( cal_setting, cal_value )
284 VALUES ('public_access_view_part', 'N');
285 INSERT INTO webcal_config ( cal_setting, cal_value )
286 VALUES ('nonuser_at_top', 'Y');
287 INSERT INTO webcal_config ( cal_setting, cal_value )
288 VALUES ('allow_external_users', 'N');
289 INSERT INTO webcal_config ( cal_setting, cal_value )
290 VALUES ('external_notifications', 'N');
291 INSERT INTO webcal_config ( cal_setting, cal_value )
292 VALUES ('external_reminders', 'N');
293 INSERT INTO webcal_config ( cal_setting, cal_value )
294 VALUES ('enable_gradients', 'N');
298 CREATE TABLE webcal_entry_log (
299 cal_log_id INT NOT NULL,
300 cal_entry_id INT NOT NULL,
301 cal_login VARCHAR(25) NOT NULL,
302 cal_user_cal VARCHAR(25) NOT NULL,
303 cal_type CHAR(1) NOT NULL,
304 cal_date INT NOT NULL,
305 cal_time INT NOT NULL,
307 PRIMARY KEY ( cal_log_id )
311 CREATE TABLE webcal_categories (
313 cat_owner VARCHAR(25),
314 cat_name VARCHAR(80) NOT NULL,
315 PRIMARY KEY ( cat_id )
318 CREATE TABLE webcal_asst (
319 cal_boss VARCHAR(25) NOT NULL,
320 cal_assistant VARCHAR(25) NOT NULL,
321 PRIMARY KEY ( cal_boss, cal_assistant )
324 CREATE TABLE webcal_nonuser_cals (
325 cal_login VARCHAR(25) NOT NULL,
326 cal_lastname VARCHAR(25) NULL,
327 cal_firstname VARCHAR(25) NULL,
328 cal_admin VARCHAR(25) NOT NULL,
329 PRIMARY KEY ( cal_login )
332 CREATE TABLE webcal_import (
333 cal_import_id INT NOT NULL,
334 cal_name VARCHAR(50) NULL,
335 cal_date INT NOT NULL,
336 cal_type VARCHAR(10) NOT NULL,
337 cal_login VARCHAR(25) NULL,
338 PRIMARY KEY ( cal_import_id )
341 CREATE TABLE webcal_import_data (
342 cal_import_id INT NOT NULL,
344 cal_login VARCHAR(25) NOT NULL,
345 cal_import_type VARCHAR(15) NOT NULL,
346 cal_external_id VARCHAR(200) NULL,
347 PRIMARY KEY ( cal_id, cal_login )
351 CREATE TABLE webcal_report (
352 cal_login VARCHAR(25) NOT NULL,
353 cal_report_id INT NOT NULL,
354 cal_is_global CHAR(1) DEFAULT 'N' NOT NULL,
355 cal_report_type VARCHAR(20) NOT NULL,
356 cal_include_header CHAR(1) DEFAULT 'Y' NOT NULL,
357 cal_report_name VARCHAR(50) NOT NULL,
358 cal_time_range INT NOT NULL,
359 cal_user VARCHAR(25) NULL,
360 cal_allow_nav CHAR(1) DEFAULT 'Y',
362 cal_include_empty CHAR(1) DEFAULT 'N',
363 cal_show_in_trailer CHAR(1) DEFAULT 'N',
364 cal_update_date INT NOT NULL,
365 PRIMARY KEY ( cal_report_id )
368 CREATE TABLE webcal_report_template (
369 cal_report_id INT NOT NULL,
370 cal_template_type CHAR(1) NOT NULL,
371 cal_template_text TEXT,
372 PRIMARY KEY ( cal_report_id, cal_template_type )