projects / GitHub / WoltLab / WCF.git / blame
? search:
summary | shortlog | log | commit | commitdiff | tree
blob | blame (incremental) | history | HEAD
Fixed instruction order
[GitHub/WoltLab/WCF.git] / wcfsetup / setup / db / install.sql
CommitLineData
9f959ced 1/* tables */
092bdf82
AE		 2DROP TABLE IF EXISTS wcf1_acl_option;
3CREATE TABLE wcf1_acl_option (
4 optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
5 packageID INT(10) NOT NULL,
6 objectTypeID INT(10) NOT NULL,
7 optionName VARCHAR(255) NOT NULL,
8 categoryName VARCHAR(255) NOT NULL,
9 UNIQUE KEY (packageID, objectTypeID, optionName)
10);
11
12DROP TABLE IF EXISTS wcf1_acl_option_category;
13CREATE TABLE wcf1_acl_option_category (
14 categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
15 packageID INT(10) NOT NULL,
16 objectTypeID INT(10) NOT NULL,
17 categoryName VARCHAR(255) NOT NULL,
18 UNIQUE KEY (packageID, objectTypeID, categoryName)
19);
20
21DROP TABLE IF EXISTS wcf1_acl_option_to_user;
22CREATE TABLE wcf1_acl_option_to_user (
23 optionID INT(10) NOT NULL,
24 objectID INT(10) NOT NULL,
25 userID INT(10) NOT NULL,
26 optionValue TINYINT(1) NOT NULL DEFAULT 0,
27 UNIQUE KEY userID (userID, objectID, optionID)
28);
29
30DROP TABLE IF EXISTS wcf1_acl_option_to_group;
31CREATE TABLE wcf1_acl_option_to_group (
32 optionID INT(10) NOT NULL,
33 objectID INT(10) NOT NULL,
34 groupID INT(10) NOT NULL,
35 optionValue TINYINT(1) NOT NULL DEFAULT 0,
36 UNIQUE KEY groupID (groupID, objectID, optionID)
37);
38
158bd3ca
TD		 39DROP TABLE IF EXISTS wcf1_acp_menu_item;
40CREATE TABLE wcf1_acp_menu_item (
41 menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
42 packageID INT(10) NOT NULL,
43 menuItem VARCHAR(255) NOT NULL DEFAULT '',
44 parentMenuItem VARCHAR(255) NOT NULL DEFAULT '',
b6169da5 45 menuItemController VARCHAR(255) NOT NULL DEFAULT '',
158bd3ca
TD		 46 menuItemLink VARCHAR(255) NOT NULL DEFAULT '',
47 showOrder INT(10) NOT NULL DEFAULT 0,
48 permissions TEXT,
49 options TEXT,
50 UNIQUE KEY menuItem (menuItem, packageID)
51);
52
e9311b98
AE		 53DROP TABLE IF EXISTS wcf1_acp_search_provider;
54CREATE TABLE wcf1_acp_search_provider (
55 providerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
56 packageID INT(10) NOT NULL,
57 providerName VARCHAR(255) NOT NULL DEFAULT '',
58 className VARCHAR(255) NOT NULL DEFAULT '',
59 showOrder INT(10) NOT NULL DEFAULT 0,
60 UNIQUE KEY providerName (providerName, packageID)
61);
62
158bd3ca
TD		 63DROP TABLE IF EXISTS wcf1_acp_session;
64CREATE TABLE wcf1_acp_session (
65 sessionID CHAR(40) NOT NULL PRIMARY KEY,
158bd3ca
TD		 66 userID INT(10),
67 ipAddress VARCHAR(39) NOT NULL DEFAULT '',
68 userAgent VARCHAR(255) NOT NULL DEFAULT '',
69 lastActivityTime INT(10) NOT NULL DEFAULT 0,
70 requestURI VARCHAR(255) NOT NULL DEFAULT '',
98f447b0 71 requestMethod VARCHAR(7) NOT NULL DEFAULT '',
7aa1a486 72 controller VARCHAR(255) NOT NULL DEFAULT '',
596e20e2
MW		 73 parentObjectType VARCHAR(255) NOT NULL DEFAULT '',
74 parentObjectID INT(10) NOT NULL DEFAULT 0,
75 objectType VARCHAR(255) NOT NULL DEFAULT '',
76 objectID INT(10) NOT NULL DEFAULT 0,
0b30544a 77 sessionVariables MEDIUMTEXT
158bd3ca
TD		 78);
79
158bd3ca
TD		 80DROP TABLE IF EXISTS wcf1_acp_session_access_log;
81CREATE TABLE wcf1_acp_session_access_log (
82 sessionAccessLogID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
83 sessionLogID INT(10) NOT NULL,
158bd3ca
TD		 84 ipAddress VARCHAR(39) NOT NULL DEFAULT '',
85 time INT(10) NOT NULL DEFAULT 0,
86 requestURI VARCHAR(255) NOT NULL DEFAULT '',
98f447b0 87 requestMethod VARCHAR(7) NOT NULL DEFAULT '',
158bd3ca
TD		 88 className VARCHAR(255) NOT NULL DEFAULT '',
89 KEY sessionLogID (sessionLogID)
90);
91
92DROP TABLE IF EXISTS wcf1_acp_session_log;
93CREATE TABLE wcf1_acp_session_log (
94 sessionLogID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
95 sessionID CHAR(40) NOT NULL DEFAULT '',
96 userID INT(10),
97 ipAddress VARCHAR(39) NOT NULL DEFAULT '',
98 hostname VARCHAR(255) NOT NULL DEFAULT '',
99 userAgent VARCHAR(255) NOT NULL DEFAULT '',
100 time INT(10) NOT NULL DEFAULT 0,
101 lastActivityTime INT(10) NOT NULL DEFAULT 0,
102 KEY sessionID (sessionID)
103);
104
105DROP TABLE IF EXISTS wcf1_acp_template;
106CREATE TABLE wcf1_acp_template (
107 templateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
108 packageID INT(10),
04727c8b 109 templateName VARCHAR(255) NOT NULL,
567fa8b8 110 application VARCHAR(20) NOT NULL,
04727c8b 111 UNIQUE KEY applicationTemplate (application, templateName)
158bd3ca
TD		 112);
113
e866b80e
MS		 114DROP TABLE IF EXISTS wcf1_ad;
115CREATE TABLE wcf1_ad (
116 adID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
117 objectTypeID INT(10) NOT NULL,
118 adName VARCHAR(255) NOT NULL,
119 ad MEDIUMTEXT,
120 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
121 showOrder INT(10) NOT NULL DEFAULT 0
122);
123
158bd3ca
TD		 124DROP TABLE IF EXISTS wcf1_application;
125CREATE TABLE wcf1_application (
126 packageID INT(10) NOT NULL PRIMARY KEY,
127 domainName VARCHAR(255) NOT NULL,
128 domainPath VARCHAR(255) NOT NULL DEFAULT '/',
668cf125 129 cookieDomain VARCHAR(255) NOT NULL,
de44b893 130 cookiePath VARCHAR(255) NOT NULL DEFAULT '/',
158bd3ca
TD		 131 isPrimary TINYINT(1) NOT NULL DEFAULT 0
132);
133
f0bc263f
MW		 134DROP TABLE IF EXISTS wcf1_attachment;
135CREATE TABLE wcf1_attachment (
136 attachmentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
137 objectTypeID INT(10) NOT NULL,
138 objectID INT(10),
139 userID INT(10),
140 tmpHash VARCHAR(40) NOT NULL DEFAULT '',
141 filename VARCHAR(255) NOT NULL DEFAULT '',
142 filesize INT(10) NOT NULL DEFAULT 0,
143 fileType VARCHAR(255) NOT NULL DEFAULT '',
144 fileHash VARCHAR(40) NOT NULL DEFAULT '',
145
146 isImage TINYINT(1) NOT NULL DEFAULT 0,
147 width SMALLINT(5) NOT NULL DEFAULT 0,
148 height SMALLINT(5) NOT NULL DEFAULT 0,
149
150 tinyThumbnailType VARCHAR(255) NOT NULL DEFAULT '',
151 tinyThumbnailSize INT(10) NOT NULL DEFAULT 0,
152 tinyThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0,
153 tinyThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0,
154
155 thumbnailType VARCHAR(255) NOT NULL DEFAULT '',
156 thumbnailSize INT(10) NOT NULL DEFAULT 0,
157 thumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0,
158 thumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0,
159
160 downloads INT(10) NOT NULL DEFAULT 0,
161 lastDownloadTime INT(10) NOT NULL DEFAULT 0,
162 uploadTime INT(10) NOT NULL DEFAULT 0,
163 showOrder SMALLINT(5) NOT NULL DEFAULT 0,
164 KEY (objectTypeID, objectID),
165 KEY (objectTypeID, tmpHash),
166 KEY (objectID, uploadTime)
167);
168
dcc2332d
MW		 169DROP TABLE IF EXISTS wcf1_bbcode;
170CREATE TABLE wcf1_bbcode (
171 bbcodeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
172 bbcodeTag VARCHAR(255) NOT NULL,
173 packageID INT(10) NOT NULL,
174 htmlOpen VARCHAR(255) NOT NULL DEFAULT '',
175 htmlClose VARCHAR(255) NOT NULL DEFAULT '',
176 allowedChildren VARCHAR(255) NOT NULL DEFAULT 'all',
177 className VARCHAR(255) NOT NULL DEFAULT '',
178 wysiwygIcon varchar(255) NOT NULL DEFAULT '',
179 buttonLabel VARCHAR(255) NOT NULL DEFAULT '',
180 isSourceCode TINYINT(1) NOT NULL DEFAULT 0,
181 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
182 showButton TINYINT(1) NOT NULL DEFAULT 0,
31378fd1 183 originIsSystem TINYINT(1) NOT NULL DEFAULT 0,
dcc2332d
MW		 184 UNIQUE KEY bbcodeTag (bbcodeTag)
185);
186
187DROP TABLE IF EXISTS wcf1_bbcode_attribute;
188CREATE TABLE wcf1_bbcode_attribute (
189 attributeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
190 bbcodeID INT(10) NOT NULL,
191 attributeNo TINYINT(3) NOT NULL DEFAULT 0,
192 attributeHtml VARCHAR(255) NOT NULL DEFAULT '',
193 validationPattern VARCHAR(255) NOT NULL DEFAULT '',
194 required TINYINT(1) NOT NULL DEFAULT 0,
195 useText TINYINT(1) NOT NULL DEFAULT 0,
196 UNIQUE KEY attributeNo (bbcodeID, attributeNo)
197);
198
199DROP TABLE IF EXISTS wcf1_bbcode_media_provider;
200CREATE TABLE wcf1_bbcode_media_provider (
201 providerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
202 title VARCHAR(255) NOT NULL,
203 regex TEXT NOT NULL,
204 html TEXT NOT NULL
205);
206
96714cab
MS		 207DROP TABLE IF EXISTS wcf1_captcha_question;
208CREATE TABLE wcf1_captcha_question (
209 questionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
210 question VARCHAR(255) NOT NULL,
211 answers MEDIUMTEXT,
212 isDisabled TINYINT(1) NOT NULL DEFAULT 0
213);
214
13d8b49b
MS		 215DROP TABLE IF EXISTS wcf1_category;
216CREATE TABLE wcf1_category (
217 categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
218 objectTypeID INT(10) NOT NULL,
da06d70c 219 parentCategoryID INT(10) NOT NULL DEFAULT 0,
13d8b49b
MS		 220 title VARCHAR(255) NOT NULL,
221 description TEXT,
da06d70c
MW		 222 showOrder INT(10) NOT NULL DEFAULT 0,
223 time INT(10) NOT NULL DEFAULT 0,
13d8b49b 224 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
045f075b 225 additionalData TEXT
13d8b49b
MS		 226);
227
054db725
TD		 228DROP TABLE IF EXISTS wcf1_cli_history;
229CREATE TABLE wcf1_cli_history (
230 historyItem INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
231 userID INT(10) NOT NULL,
232 command VARCHAR(255) NOT NULL,
233 KEY (userID)
234);
235
0d6ea23f
AE		 236DROP TABLE IF EXISTS wcf1_clipboard_action;
237CREATE TABLE wcf1_clipboard_action (
238 actionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
239 packageID INT(10) NOT NULL DEFAULT 0,
240 actionName VARCHAR(50) NOT NULL DEFAULT '',
241 actionClassName VARCHAR(200) NOT NULL DEFAULT '',
d6bfc90e 242 showOrder INT(10) NOT NULL DEFAULT 0,
656718fc 243 UNIQUE KEY actionName (packageID, actionName, actionClassName)
0d6ea23f
AE		 244);
245
246DROP TABLE IF EXISTS wcf1_clipboard_item;
247CREATE TABLE wcf1_clipboard_item (
25cf4d11 248 objectTypeID INT(10) NOT NULL DEFAULT 0,
0d6ea23f 249 userID INT(10) NOT NULL DEFAULT 0,
25cf4d11
AE		 250 objectID INT(10) NOT NULL DEFAULT 0,
251 UNIQUE KEY (objectTypeID, userID, objectID)
0d6ea23f
AE		 252);
253
254DROP TABLE IF EXISTS wcf1_clipboard_page;
255CREATE TABLE wcf1_clipboard_page (
256 pageClassName VARCHAR(80) NOT NULL DEFAULT '',
257 packageID INT(10) NOT NULL DEFAULT 0,
258 actionID INT(10) NOT NULL DEFAULT 0
259);
260
285b1d92
MW		 261DROP TABLE IF EXISTS wcf1_comment;
262CREATE TABLE wcf1_comment (
263 commentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
264 objectTypeID INT(10) NOT NULL,
265 objectID INT(10) NOT NULL,
266 time INT(10) NOT NULL DEFAULT '0',
267 userID INT(10),
268 username VARCHAR(255) NOT NULL,
269 message TEXT NOT NULL,
270 responses MEDIUMINT(7) NOT NULL DEFAULT '0',
6f874ba8 271 responseIDs VARCHAR(255) NOT NULL DEFAULT '',
285b1d92 272
e36dbd69
AE		 273 KEY (objectTypeID, objectID, time),
274 KEY lastCommentTime (userID, time)
285b1d92
MW		 275);
276
277DROP TABLE IF EXISTS wcf1_comment_response;
278CREATE TABLE wcf1_comment_response (
279 responseID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
280 commentID INT(10) NOT NULL,
281 time INT(10) NOT NULL DEFAULT '0',
282 userID INT(10),
283 username VARCHAR(255) NOT NULL,
284 message TEXT NOT NULL,
285
e36dbd69
AE		 286 KEY (commentID, time),
287 KEY lastResponseTime (userID, time)
285b1d92
MW		 288);
289
87d3a054
MS		 290DROP TABLE IF EXISTS wcf1_condition;
291CREATE TABLE wcf1_condition (
292 conditionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
293 objectTypeID INT(10) NOT NULL,
294 objectID INT(10) NOT NULL,
295 conditionData MEDIUMTEXT
296);
297
158bd3ca
TD		 298DROP TABLE IF EXISTS wcf1_core_object;
299CREATE TABLE wcf1_core_object (
300 objectID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
301 packageID INT(10) NOT NULL,
302 objectName VARCHAR(255) NOT NULL DEFAULT '',
303 UNIQUE KEY object (packageID, objectName)
304);
305
306DROP TABLE IF EXISTS wcf1_cronjob;
307CREATE TABLE wcf1_cronjob (
308 cronjobID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
309 className varchar(255) NOT NULL DEFAULT '',
310 packageID INT(10) NOT NULL,
311 description varchar(255) NOT NULL DEFAULT '',
312 startMinute varchar(255) NOT NULL DEFAULT '*',
313 startHour varchar(255) NOT NULL DEFAULT '*',
314 startDom varchar(255) NOT NULL DEFAULT '*',
315 startMonth varchar(255) NOT NULL DEFAULT '*',
316 startDow varchar(255) NOT NULL DEFAULT '*',
317 lastExec INT(10) NOT NULL DEFAULT 0,
318 nextExec INT(10) NOT NULL DEFAULT 0,
319 afterNextExec INT(10) NOT NULL DEFAULT 0,
8f08c7d0 320 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
c9117aad
MS		 321 canBeEdited TINYINT(1) NOT NULL DEFAULT 1,
322 canBeDisabled TINYINT(1) NOT NULL DEFAULT 1,
323 state TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 324 failCount TINYINT(1) NOT NULL DEFAULT 0
325);
326
327DROP TABLE IF EXISTS wcf1_cronjob_log;
328CREATE TABLE wcf1_cronjob_log (
329 cronjobLogID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
330 cronjobID INT(10) NOT NULL,
331 execTime INT(10) NOT NULL DEFAULT 0,
c9117aad 332 success TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 333 error TEXT
334);
335
320f4a6d
MW		 336DROP TABLE IF EXISTS wcf1_dashboard_box;
337CREATE TABLE wcf1_dashboard_box (
338 boxID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
339 packageID INT(10) NOT NULL,
340 boxName VARCHAR(255) NOT NULL DEFAULT '',
341 boxType VARCHAR(30) NOT NULL DEFAULT 'sidebar', -- can be 'content' or 'sidebar'
342 className VARCHAR(255) NOT NULL DEFAULT ''
343);
344
345DROP TABLE IF EXISTS wcf1_dashboard_option;
346CREATE TABLE wcf1_dashboard_option (
347 objectTypeID INT(10) NOT NULL,
348 boxID INT(10) NOT NULL,
349 showOrder INT(10) NOT NULL,
350 UNIQUE KEY dashboardOption (objectTypeID, boxID)
351);
352
81aa6374
TD		 353DROP TABLE IF EXISTS wcf1_edit_history_entry;
354CREATE TABLE wcf1_edit_history_entry (
355 entryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
356 objectTypeID INT(10) NOT NULL,
357 objectID INT(10) NOT NULL,
358 userID INT(10),
359 username VARCHAR(255) NOT NULL DEFAULT '',
988618d9 360 time INT(10) NOT NULL DEFAULT 0, -- time the version was created, displayed to the user
f86d7ff7
TD		 361 obsoletedAt INT(10) NOT NULL DEFAULT 0, -- time the version was inserted into the edit history, used for clean up
362 obsoletedByUserID INT(10),
81aa6374
TD		 363 message MEDIUMTEXT,
364 editReason TEXT,
365
f86d7ff7
TD		 366 KEY (objectTypeID, objectID),
367 KEY (obsoletedAt, obsoletedByUserID)
81aa6374
TD		 368);
369
158bd3ca
TD		 370DROP TABLE IF EXISTS wcf1_event_listener;
371CREATE TABLE wcf1_event_listener (
372 listenerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
373 packageID INT(10) NOT NULL,
7e6405f8 374 environment ENUM('user', 'admin') NOT NULL DEFAULT 'user',
158bd3ca
TD		 375 eventClassName VARCHAR(80) NOT NULL DEFAULT '',
376 eventName VARCHAR(50) NOT NULL DEFAULT '',
377 listenerClassName VARCHAR(200) NOT NULL DEFAULT '',
378 inherit TINYINT(1) NOT NULL DEFAULT 0,
379 niceValue TINYINT(3) NOT NULL DEFAULT 0,
7e6405f8 380 UNIQUE KEY packageID (packageID, environment, eventClassName, eventName, listenerClassName)
158bd3ca
TD		 381);
382
78db8ddf
MW		 383DROP TABLE IF EXISTS wcf1_import_mapping;
384CREATE TABLE wcf1_import_mapping (
8d8368ee 385 importHash CHAR(8) NOT NULL,
78db8ddf
MW		 386 objectTypeID INT(10) NOT NULL,
387 oldID VARCHAR(255) NOT NULL,
388 newID INT(10) NOT NULL,
8d8368ee 389 UNIQUE KEY (importHash, objectTypeID, oldID)
78db8ddf
MW		 390);
391
3b75466f
MW		 392DROP TABLE IF EXISTS wcf1_label;
393CREATE TABLE wcf1_label (
394 labelID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
395 groupID INT(10) NOT NULL,
396 label VARCHAR(80) NOT NULL,
221eee4b 397 cssClassName VARCHAR(255) NOT NULL DEFAULT ''
3b75466f
MW		 398);
399
400DROP TABLE IF EXISTS wcf1_label_group;
401CREATE TABLE wcf1_label_group (
402 groupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
403 groupName VARCHAR(80) NOT NULL,
e76c454b
AE		 404 forceSelection TINYINT(1) NOT NULL DEFAULT 0,
405 showOrder INT(10) NOT NULL DEFAULT 0
3b75466f
MW		 406);
407
408DROP TABLE IF EXISTS wcf1_label_group_to_object;
409CREATE TABLE wcf1_label_group_to_object (
410 groupID INT(10) NOT NULL,
411 objectTypeID INT(10) NOT NULL,
412 objectID INT(10) NULL
413);
414
415DROP TABLE IF EXISTS wcf1_label_object;
416CREATE TABLE wcf1_label_object (
417 labelID INT(10) NOT NULL,
418 objectTypeID INT(10) NOT NULL,
419 objectID INT(10) NOT NULL,
420
421 KEY (objectTypeID, labelID),
422 KEY (objectTypeID, objectID)
423);
424
158bd3ca
TD		 425DROP TABLE IF EXISTS wcf1_language;
426CREATE TABLE wcf1_language (
427 languageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
428 languageCode VARCHAR(20) NOT NULL DEFAULT '',
a74df36b 429 languageName VARCHAR(255) NOT NULL DEFAULT '',
6675b340 430 countryCode VARCHAR(10) NOT NULL DEFAULT '',
158bd3ca
TD		 431 isDefault TINYINT(1) NOT NULL DEFAULT 0,
432 hasContent TINYINT(1) NOT NULL DEFAULT 0,
433 UNIQUE KEY languageCode (languageCode)
434);
435
436DROP TABLE IF EXISTS wcf1_language_category;
437CREATE TABLE wcf1_language_category (
438 languageCategoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
439 languageCategory VARCHAR(255) NOT NULL DEFAULT '',
440 UNIQUE KEY languageCategory (languageCategory)
441);
442
443DROP TABLE IF EXISTS wcf1_language_item;
444CREATE TABLE wcf1_language_item (
445 languageItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
446 languageID INT(10) NOT NULL,
447 languageItem VARCHAR(255) NOT NULL DEFAULT '',
448 languageItemValue MEDIUMTEXT NOT NULL,
449 languageCustomItemValue MEDIUMTEXT,
450 languageUseCustomValue TINYINT(1) NOT NULL DEFAULT 0,
451 languageItemOriginIsSystem TINYINT(1) NOT NULL DEFAULT 1,
452 languageCategoryID INT(10) NOT NULL,
453 packageID INT(10),
f1c1fc65 454 UNIQUE KEY languageItem (languageItem, languageID),
158bd3ca
TD		 455 KEY languageItemOriginIsSystem (languageItemOriginIsSystem)
456);
457
458DROP TABLE IF EXISTS wcf1_language_server;
459CREATE TABLE wcf1_language_server (
460 languageServerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
461 serverURL VARCHAR(255) NOT NULL DEFAULT '',
8f08c7d0 462 isDisabled TINYINT(1) NOT NULL DEFAULT 0
158bd3ca
TD		 463);
464
00b6f956
MW		 465DROP TABLE IF EXISTS wcf1_like;
466CREATE TABLE wcf1_like (
467 likeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
468 objectID INT(10) NOT NULL DEFAULT 0,
469 objectTypeID INT(10) NOT NULL,
470 objectUserID INT(10),
471 userID INT(10) NOT NULL,
472 time INT(10) NOT NULL DEFAULT 0,
473 likeValue TINYINT(1) NOT NULL DEFAULT 1,
474 UNIQUE KEY (objectTypeID, objectID, userID)
475);
476
477DROP TABLE IF EXISTS wcf1_like_object;
478CREATE TABLE wcf1_like_object (
479 likeObjectID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
480 objectTypeID INT(10) NOT NULL,
481 objectID INT(10) NOT NULL DEFAULT 0,
482 objectUserID INT(10),
483 likes MEDIUMINT(7) NOT NULL DEFAULT 0,
484 dislikes MEDIUMINT(7) NOT NULL DEFAULT 0,
485 cumulativeLikes MEDIUMINT(7) NOT NULL DEFAULT 0,
486 cachedUsers TEXT,
487 UNIQUE KEY (objectTypeID, objectID)
488);
489
0a2b09a2
MW		 490DROP TABLE IF EXISTS wcf1_message_embedded_object;
491CREATE TABLE wcf1_message_embedded_object (
492 messageObjectTypeID INT(10) NOT NULL,
493 messageID INT(10) NOT NULL,
494 embeddedObjectTypeID INT(10) NOT NULL,
495 embeddedObjectID INT(10) NOT NULL,
496
497 KEY (messageObjectTypeID, messageID)
498);
499
fc69b61d
MW		 500DROP TABLE IF EXISTS wcf1_moderation_queue;
501CREATE TABLE wcf1_moderation_queue (
502 queueID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
503 objectTypeID INT(10) NOT NULL,
504 objectID INT(10) NOT NULL,
505 containerID INT(10) NOT NULL DEFAULT 0,
506 userID INT(10) NULL,
507 time INT(10) NOT NULL DEFAULT 0,
508
509 -- internal
510 assignedUserID INT(10) NULL,
511 status TINYINT(1) NOT NULL DEFAULT 0,
166d2b91 512 comments SMALLINT(5) NOT NULL DEFAULT 0,
fc69b61d
MW		 513 lastChangeTime INT(10) NOT NULL DEFAULT 0,
514
515 -- additional data, e.g. message if reporting content
71b3faba 516 additionalData TEXT
fc69b61d
MW		 517);
518
519DROP TABLE IF EXISTS wcf1_moderation_queue_to_user;
520CREATE TABLE wcf1_moderation_queue_to_user (
521 queueID INT(10) NOT NULL,
522 userID INT(10) NOT NULL,
523 isAffected TINYINT(1) NOT NULL DEFAULT 0,
524
525 UNIQUE KEY queue (queueID, userID),
526 KEY affected (queueID, userID, isAffected)
527);
528
3a2de7fd
AE		 529DROP TABLE IF EXISTS wcf1_modification_log;
530CREATE TABLE wcf1_modification_log (
531 logID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
532 objectTypeID INT(10) NOT NULL,
533 objectID INT(10) NOT NULL,
534 userID INT(10),
535 username VARCHAR(255) NOT NULL DEFAULT '',
536 time INT(10) NOT NULL DEFAULT 0,
537 action VARCHAR(80) NOT NULL,
538 additionalData MEDIUMTEXT
539);
540
20933e61
MS		 541DROP TABLE IF EXISTS wcf1_notice;
542CREATE TABLE wcf1_notice (
543 noticeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
544 noticeName VARCHAR(255) NOT NULL,
545 notice MEDIUMTEXT,
546 noticeUseHtml TINYINT(1) NOT NULL DEFAULT 0,
e70b5175 547 cssClassName VARCHAR(255) NOT NULL DEFAULT 'info',
20933e61
MS		 548 showOrder INT(10) NOT NULL DEFAULT 0,
549 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
550 isDismissible TINYINT(1) NOT NULL DEFAULT 0
551);
552
553DROP TABLE IF EXISTS wcf1_notice_dismissed;
554CREATE TABLE wcf1_notice_dismissed (
555 noticeID INT(10) NOT NULL,
556 userID INT(10) NOT NULL,
557 PRIMARY KEY (noticeID, userID)
558);
559
7fcc7676
MW		 560DROP TABLE IF EXISTS wcf1_object_type;
561CREATE TABLE wcf1_object_type (
562 objectTypeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
563 definitionID INT(10) NOT NULL,
564 packageID INT(10) NOT NULL,
565 objectType VARCHAR(255) NOT NULL,
566 className VARCHAR(255) NOT NULL DEFAULT '',
567 additionalData MEDIUMTEXT,
568 UNIQUE KEY objectType (objectType, definitionID, packageID)
569);
570
571DROP TABLE IF EXISTS wcf1_object_type_definition;
572CREATE TABLE wcf1_object_type_definition (
573 definitionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
574 definitionName VARCHAR(255) NOT NULL,
575 packageID INT(10) NOT NULL,
576 interfaceName VARCHAR(255) NOT NULL DEFAULT '',
16bd0d85 577 categoryName VARCHAR(80) NOT NULL DEFAULT '',
c404ff5f 578 UNIQUE KEY definitionName (definitionName)
7fcc7676
MW		 579);
580
158bd3ca
TD		 581DROP TABLE IF EXISTS wcf1_option;
582CREATE TABLE wcf1_option (
583 optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
584 packageID INT(10) NOT NULL,
585 optionName VARCHAR(255) NOT NULL DEFAULT '',
586 categoryName VARCHAR(255) NOT NULL DEFAULT '',
587 optionType VARCHAR(255) NOT NULL DEFAULT '',
588 optionValue MEDIUMTEXT,
589 validationPattern TEXT,
590 selectOptions MEDIUMTEXT,
591 enableOptions MEDIUMTEXT,
592 showOrder INT(10) NOT NULL DEFAULT 0,
593 hidden TINYINT(1) NOT NULL DEFAULT 0,
594 permissions TEXT,
595 options TEXT,
cd6220f2 596 supportI18n TINYINT(1) NOT NULL DEFAULT 0,
6b45d041 597 requireI18n TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca 598 additionalData MEDIUMTEXT,
0eafcb83
AE		 599
600 UNIQUE KEY optionName (optionName)
158bd3ca
TD		 601);
602
603DROP TABLE IF EXISTS wcf1_option_category;
604CREATE TABLE wcf1_option_category (
605 categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
606 packageID INT(10) NOT NULL,
607 categoryName VARCHAR(255) NOT NULL DEFAULT '',
608 parentCategoryName VARCHAR(255) NOT NULL DEFAULT '',
609 showOrder INT(10) NOT NULL DEFAULT 0,
610 permissions TEXT,
611 options TEXT,
0e580f32 612 UNIQUE KEY categoryName (categoryName)
158bd3ca
TD		 613);
614
615DROP TABLE IF EXISTS wcf1_package;
616CREATE TABLE wcf1_package (
617 packageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
618 package VARCHAR(255) NOT NULL DEFAULT '',
619 packageDir VARCHAR(255) NOT NULL DEFAULT '',
620 packageName VARCHAR(255) NOT NULL DEFAULT '',
158bd3ca
TD		 621 packageDescription VARCHAR(255) NOT NULL DEFAULT '',
622 packageVersion VARCHAR(255) NOT NULL DEFAULT '',
623 packageDate INT(10) NOT NULL DEFAULT 0,
624 installDate INT(10) NOT NULL DEFAULT 0,
625 updateDate INT(10) NOT NULL DEFAULT 0,
626 packageURL VARCHAR(255) NOT NULL DEFAULT '',
aac1247e 627 isApplication TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 628 author VARCHAR(255) NOT NULL DEFAULT '',
629 authorURL VARCHAR(255) NOT NULL DEFAULT '',
630 KEY package (package)
631);
632
158bd3ca
TD		 633DROP TABLE IF EXISTS wcf1_package_exclusion;
634CREATE TABLE wcf1_package_exclusion (
635 packageID INT(10) NOT NULL,
636 excludedPackage VARCHAR(255) NOT NULL DEFAULT '',
637 excludedPackageVersion VARCHAR(255) NOT NULL DEFAULT '',
638 UNIQUE KEY packageID (packageID, excludedPackage)
639);
640
641DROP TABLE IF EXISTS wcf1_package_installation_file_log;
642CREATE TABLE wcf1_package_installation_file_log (
643 packageID INT(10),
04727c8b 644 filename VARCHAR(255) NOT NULL,
567fa8b8 645 application VARCHAR(20) NOT NULL,
04727c8b 646 UNIQUE KEY applicationFile (application, filename)
158bd3ca
TD		 647);
648
649DROP TABLE IF EXISTS wcf1_package_installation_form;
650CREATE TABLE wcf1_package_installation_form (
651 queueID INT(10) NOT NULL,
652 formName VARCHAR(80) NOT NULL DEFAULT '',
653 document TEXT NOT NULL,
654 UNIQUE KEY formDocument (queueID, formName)
655);
656
657DROP TABLE IF EXISTS wcf1_package_installation_node;
658CREATE TABLE wcf1_package_installation_node (
659 queueID INT(10) NOT NULL,
660 processNo INT(10) NOT NULL DEFAULT 0,
661 sequenceNo SMALLINT(4) NOT NULL DEFAULT 0,
662 node CHAR(8) NOT NULL DEFAULT '',
663 parentNode CHAR(8) NOT NULL DEFAULT '',
456008db 664 nodeType ENUM('optionalPackages','package', 'pip') NOT NULL DEFAULT 'package',
158bd3ca
TD		 665 nodeData TEXT NOT NULL,
666 done TINYINT(1) NOT NULL DEFAULT 0
667);
668
669DROP TABLE IF EXISTS wcf1_package_installation_plugin;
670CREATE TABLE wcf1_package_installation_plugin (
671 pluginName VARCHAR(255) NOT NULL PRIMARY KEY,
672 packageID INT(10),
673 priority TINYINT(1) NOT NULL DEFAULT 0,
674 className VARCHAR(255) NOT NULL
675);
676
677DROP TABLE IF EXISTS wcf1_package_installation_queue;
678CREATE TABLE wcf1_package_installation_queue (
679 queueID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
680 parentQueueID INT(10) NOT NULL DEFAULT 0,
681 processNo INT(10) NOT NULL DEFAULT 0,
682 userID INT(10) NOT NULL,
683 package VARCHAR(255) NOT NULL DEFAULT '',
684 packageName VARCHAR(255) NOT NULL DEFAULT '',
685 packageID INT(10),
686 archive VARCHAR(255) NOT NULL DEFAULT '',
17221357 687 action ENUM('install', 'update', 'uninstall') NOT NULL DEFAULT 'install',
158bd3ca 688 done TINYINT(1) NOT NULL DEFAULT 0,
b33c97d2 689 isApplication TINYINT(1) NOT NULL DEFAULT 0
158bd3ca
TD		 690);
691
692DROP TABLE IF EXISTS wcf1_package_installation_sql_log;
693CREATE TABLE wcf1_package_installation_sql_log (
694 packageID INT(10),
695 sqlTable VARCHAR(100) NOT NULL DEFAULT '',
696 sqlColumn VARCHAR(100) NOT NULL DEFAULT '',
697 sqlIndex VARCHAR(100) NOT NULL DEFAULT '',
698 UNIQUE KEY packageID (packageID, sqlTable, sqlColumn, sqlIndex)
699);
700
1b4f5112
AE		 701/* SQL_PARSER_OFFSET */
702
158bd3ca
TD		 703DROP TABLE IF EXISTS wcf1_package_requirement;
704CREATE TABLE wcf1_package_requirement (
705 packageID INT(10) NOT NULL,
706 requirement INT(10) NOT NULL,
707 UNIQUE KEY packageID (packageID, requirement)
708);
709
158bd3ca
TD		 710DROP TABLE IF EXISTS wcf1_package_update;
711CREATE TABLE wcf1_package_update (
712 packageUpdateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
713 packageUpdateServerID INT(10) NOT NULL,
714 package VARCHAR(255) NOT NULL DEFAULT '',
715 packageName VARCHAR(255) NOT NULL DEFAULT '',
716 packageDescription VARCHAR(255) NOT NULL DEFAULT '',
717 author VARCHAR(255) NOT NULL DEFAULT '',
718 authorURL VARCHAR(255) NOT NULL DEFAULT '',
29139546 719 isApplication TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 720 UNIQUE KEY packageUpdateServerID (packageUpdateServerID, package)
721);
722
723DROP TABLE IF EXISTS wcf1_package_update_exclusion;
724CREATE TABLE wcf1_package_update_exclusion (
725 packageUpdateVersionID INT(10) NOT NULL,
726 excludedPackage VARCHAR(255) NOT NULL DEFAULT '',
727 excludedPackageVersion VARCHAR(255) NOT NULL DEFAULT '',
728 UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, excludedPackage)
729);
730
731DROP TABLE IF EXISTS wcf1_package_update_fromversion;
732CREATE TABLE wcf1_package_update_fromversion (
733 packageUpdateVersionID INT(10) NOT NULL DEFAULT 0,
734 fromversion VARCHAR(50) NOT NULL DEFAULT '',
735 UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, fromversion)
736);
737
411d6f1a
AE		 738DROP TABLE IF EXISTS wcf1_package_update_optional;
739CREATE TABLE wcf1_package_update_optional (
740 packageUpdateVersionID INT(10) NOT NULL DEFAULT 0,
741 package VARCHAR(255) NOT NULL DEFAULT ''
742);
743
158bd3ca
TD		 744DROP TABLE IF EXISTS wcf1_package_update_requirement;
745CREATE TABLE wcf1_package_update_requirement (
746 packageUpdateVersionID INT(10) NOT NULL,
747 package VARCHAR(255) NOT NULL DEFAULT '',
748 minversion VARCHAR(50) NOT NULL DEFAULT '',
749 UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, package)
750);
751
752DROP TABLE IF EXISTS wcf1_package_update_server;
753CREATE TABLE wcf1_package_update_server (
754 packageUpdateServerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
755 serverURL VARCHAR(255) NOT NULL DEFAULT '',
756 loginUsername VARCHAR(255) NOT NULL DEFAULT '',
757 loginPassword VARCHAR(255) NOT NULL DEFAULT '',
8f08c7d0 758 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 759 lastUpdateTime INT(10) NOT NULL DEFAULT 0,
760 status ENUM('online', 'offline') NOT NULL DEFAULT 'online',
761 errorMessage TEXT
762);
763
764DROP TABLE IF EXISTS wcf1_package_update_version;
765CREATE TABLE wcf1_package_update_version (
766 packageUpdateVersionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
767 packageUpdateID INT(10) NOT NULL,
768 packageVersion VARCHAR(50) NOT NULL DEFAULT '',
158bd3ca
TD		 769 packageDate INT(10) NOT NULL DEFAULT 0,
770 filename VARCHAR(255) NOT NULL DEFAULT '',
411d6f1a
AE		 771 license VARCHAR(255) NOT NULL DEFAULT '',
772 licenseURL VARCHAR(255) NOT NULL DEFAULT '',
b4f1ea02 773 isAccessible TINYINT(1) NOT NULL DEFAULT 1,
507f6f5b 774 isCritical TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 775 UNIQUE KEY packageUpdateID (packageUpdateID, packageVersion)
776);
777
158bd3ca
TD		 778DROP TABLE IF EXISTS wcf1_page_menu_item;
779CREATE TABLE wcf1_page_menu_item (
780 menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
781 packageID INT(10) NOT NULL,
782 menuItem VARCHAR(255) NOT NULL DEFAULT '',
783 parentMenuItem VARCHAR(255) NOT NULL DEFAULT '',
1278b477 784 menuItemController VARCHAR(255) NOT NULL DEFAULT '',
158bd3ca
TD		 785 menuItemLink VARCHAR(255) NOT NULL DEFAULT '',
786 menuPosition ENUM('header', 'footer') NOT NULL DEFAULT 'header',
787 showOrder INT(10) NOT NULL DEFAULT 0,
788 permissions TEXT NULL,
789 options TEXT NULL,
790 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
791 className VARCHAR(255) NOT NULL DEFAULT '',
0b074a0c 792 isLandingPage TINYINT(1) NOT NULL DEFAULT 0,
31378fd1 793 originIsSystem TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 794 UNIQUE KEY (packageID, menuItem)
795);
796
4d8036f5
MW		 797DROP TABLE IF EXISTS wcf1_paid_subscription;
798CREATE TABLE wcf1_paid_subscription (
799 subscriptionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
800 title VARCHAR(255) NOT NULL DEFAULT '',
801 description TEXT,
802 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
803 showOrder INT(10) NOT NULL DEFAULT 0,
804 cost DECIMAL(10,2) NOT NULL DEFAULT 0,
805 currency VARCHAR(3) NOT NULL DEFAULT 'EUR',
806 subscriptionLength SMALLINT(3) NOT NULL DEFAULT 0,
807 subscriptionLengthUnit ENUM('', 'D', 'M', 'Y') NOT NULL DEFAULT '',
808 isRecurring TINYINT(1) NOT NULL DEFAULT 0,
809 groupIDs TEXT,
810 excludedSubscriptionIDs TEXT
811);
812
813DROP TABLE IF EXISTS wcf1_paid_subscription_user;
814CREATE TABLE wcf1_paid_subscription_user (
815 subscriptionUserID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
816 subscriptionID INT(10) NOT NULL,
817 userID INT(10) NOT NULL,
818 startDate INT(10) NOT NULL DEFAULT 0,
819 endDate INT(10) NOT NULL DEFAULT 0,
820 isActive TINYINT(1) NOT NULL DEFAULT 1,
821
822 UNIQUE KEY (subscriptionID, userID),
823 KEY (isActive)
824);
825
826DROP TABLE IF EXISTS wcf1_paid_subscription_transaction_log;
827CREATE TABLE wcf1_paid_subscription_transaction_log (
828 logID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
829 subscriptionUserID INT(10),
830 userID INT(10),
831 subscriptionID INT(10),
832 paymentMethodObjectTypeID INT(10) NOT NULL,
833 logTime INT(10) NOT NULL DEFAULT 0,
834 transactionID VARCHAR(255) NOT NULL DEFAULT '',
835 transactionDetails MEDIUMTEXT,
836 logMessage VARCHAR(255) NOT NULL DEFAULT ''
837);
838
e25b7b61
MW		 839DROP TABLE IF EXISTS wcf1_poll;
840CREATE TABLE wcf1_poll (
841 pollID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
842 objectTypeID INT(10) NOT NULL,
843 objectID INT(10) NOT NULL DEFAULT 0,
844 question VARCHAR(255) DEFAULT '',
845 time INT(10) NOT NULL DEFAULT 0,
846 endTime INT(10) NOT NULL DEFAULT 0,
847 isChangeable TINYINT(1) NOT NULL DEFAULT 0,
848 isPublic TINYINT(1) NOT NULL DEFAULT 0,
849 sortByVotes TINYINT(1) NOT NULL DEFAULT 0,
850 resultsRequireVote TINYINT(1) NOT NULL DEFAULT 0,
851 maxVotes INT(10) NOT NULL DEFAULT 1,
852 votes INT(10) NOT NULL DEFAULT 0
853);
854
855DROP TABLE IF EXISTS wcf1_poll_option;
856CREATE TABLE wcf1_poll_option (
857 optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
858 pollID INT(10) NOT NULL,
859 optionValue VARCHAR(255) NOT NULL DEFAULT '',
860 votes INT(10) NOT NULL DEFAULT 0,
861 showOrder INT(10) NOT NULL DEFAULT 0
862);
863
864DROP TABLE IF EXISTS wcf1_poll_option_vote;
865CREATE TABLE wcf1_poll_option_vote (
866 pollID INT(10) NOT NULL,
867 optionID INT(10) NOT NULL,
868 userID INT(10) NOT NULL,
869
870 KEY (optionID, userID),
871 UNIQUE KEY vote (pollID, optionID, userID)
872);
873
158bd3ca
TD		 874DROP TABLE IF EXISTS wcf1_search;
875CREATE TABLE wcf1_search (
876 searchID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
877 userID INT(10),
878 searchData MEDIUMTEXT NOT NULL,
879 searchTime INT(10) NOT NULL DEFAULT 0,
880 searchType VARCHAR(255) NOT NULL DEFAULT '',
881 searchHash CHAR(40) NOT NULL DEFAULT '',
882 KEY searchHash (searchHash)
883);
884
749cca08
MW		 885DROP TABLE IF EXISTS wcf1_search_keyword;
886CREATE TABLE wcf1_search_keyword (
887 keywordID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
888 keyword VARCHAR(255) NOT NULL,
889 searches INT(10) NOT NULL DEFAULT 0,
890 lastSearchTime INT(10) NOT NULL DEFAULT 0,
891 UNIQUE KEY (keyword),
892 KEY (searches, lastSearchTime)
893);
894
158bd3ca
TD		 895DROP TABLE IF EXISTS wcf1_session;
896CREATE TABLE wcf1_session (
897 sessionID CHAR(40) NOT NULL PRIMARY KEY,
158bd3ca
TD		 898 userID INT(10),
899 ipAddress VARCHAR(39) NOT NULL DEFAULT '',
900 userAgent VARCHAR(255) NOT NULL DEFAULT '',
901 lastActivityTime INT(10) NOT NULL DEFAULT 0,
902 requestURI VARCHAR(255) NOT NULL DEFAULT '',
98f447b0 903 requestMethod VARCHAR(7) NOT NULL DEFAULT '',
7aa1a486 904 controller VARCHAR(255) NOT NULL DEFAULT '',
596e20e2
MW		 905 parentObjectType VARCHAR(255) NOT NULL DEFAULT '',
906 parentObjectID INT(10) NOT NULL DEFAULT 0,
907 objectType VARCHAR(255) NOT NULL DEFAULT '',
908 objectID INT(10) NOT NULL DEFAULT 0,
75cf36c3 909 sessionVariables MEDIUMTEXT,
e8d26212 910 spiderID INT(10),
46dd7463
AE		 911 KEY packageID (lastActivityTime, spiderID),
912 UNIQUE KEY userID (userID)
158bd3ca
TD		 913);
914
5a05fde9
AE		 915DROP TABLE IF EXISTS wcf1_session_virtual;
916CREATE TABLE wcf1_session_virtual (
d905faf6 917 virtualSessionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
5a05fde9
AE		 918 sessionID CHAR(40) NOT NULL,
919 ipAddress VARCHAR(39) NOT NULL DEFAULT '',
920 userAgent VARCHAR(255) NOT NULL DEFAULT '',
921 lastActivityTime INT(10) NOT NULL DEFAULT 0,
922 UNIQUE KEY (sessionID, ipAddress, userAgent)
923);
924
46bd110b
AE		 925DROP TABLE IF EXISTS wcf1_sitemap;
926CREATE TABLE wcf1_sitemap (
927 sitemapID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
928 packageID INT(10) NOT NULL,
929 sitemapName VARCHAR(80) NOT NULL DEFAULT '',
930 className VARCHAR(255) NOT NULL DEFAULT '',
68541bb5 931 showOrder INT(10) NOT NULL DEFAULT 0,
a3e0f4f3
MW		 932 permissions TEXT NULL,
933 options TEXT NULL,
46bd110b
AE		 934 UNIQUE KEY sitemapName (packageID, sitemapName)
935);
936
dcc2332d
MW		 937DROP TABLE IF EXISTS wcf1_smiley;
938CREATE TABLE wcf1_smiley (
939 smileyID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
940 packageID INT(10) NOT NULL,
941 categoryID INT(10),
942 smileyPath VARCHAR(255) NOT NULL DEFAULT '',
943 smileyTitle VARCHAR(255) NOT NULL DEFAULT '',
944 smileyCode VARCHAR(255) NOT NULL DEFAULT '',
945 aliases TEXT NOT NULL,
946 showOrder INT(10) NOT NULL DEFAULT 0,
947 UNIQUE KEY smileyCode (smileyCode)
948);
949
158bd3ca
TD		 950DROP TABLE IF EXISTS wcf1_spider;
951CREATE TABLE wcf1_spider (
952 spiderID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
953 spiderIdentifier VARCHAR(255) DEFAULT '',
954 spiderName VARCHAR(255) DEFAULT '',
955 spiderURL VARCHAR(255) DEFAULT '',
956 UNIQUE KEY spiderIdentifier (spiderIdentifier)
957);
958
891de7a0
MW		 959DROP TABLE IF EXISTS wcf1_stat_daily;
960CREATE TABLE wcf1_stat_daily (
e1fe9453 961 statID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
891de7a0
MW		 962 objectTypeID INT(10) NOT NULL,
963 date DATE NOT NULL,
964 counter INT(10) NOT NULL DEFAULT 0,
965 total INT(10) NOT NULL DEFAULT 0,
966
967 UNIQUE KEY (objectTypeID, date)
968);
969
158bd3ca
TD		 970DROP TABLE IF EXISTS wcf1_style;
971CREATE TABLE wcf1_style (
972 styleID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
973 packageID INT(10) NOT NULL,
974 styleName VARCHAR(255) NOT NULL DEFAULT '',
975 templateGroupID INT(10) NOT NULL DEFAULT 0,
976 isDefault TINYINT(1) NOT NULL DEFAULT 0,
8f08c7d0 977 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
d3478df7 978 styleDescription VARCHAR(30) NOT NULL DEFAULT '',
158bd3ca
TD		 979 styleVersion VARCHAR(255) NOT NULL DEFAULT '',
980 styleDate CHAR(10) NOT NULL DEFAULT '0000-00-00',
981 image VARCHAR(255) NOT NULL DEFAULT '',
982 copyright VARCHAR(255) NOT NULL DEFAULT '',
983 license VARCHAR(255) NOT NULL DEFAULT '',
984 authorName VARCHAR(255) NOT NULL DEFAULT '',
fa83e8f7 985 authorURL VARCHAR(255) NOT NULL DEFAULT '',
ee013cde 986 imagePath VARCHAR(255) NOT NULL DEFAULT ''
158bd3ca
TD		 987);
988
158bd3ca
TD		 989DROP TABLE IF EXISTS wcf1_style_variable;
990CREATE TABLE wcf1_style_variable (
4d9f6058
AE		 991 variableID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
992 variableName VARCHAR(50) NOT NULL,
993 defaultValue MEDIUMTEXT,
994 UNIQUE KEY variableName (variableName)
158bd3ca
TD		 995);
996
4d9f6058
AE		 997DROP TABLE IF EXISTS wcf1_style_variable_value;
998CREATE TABLE wcf1_style_variable_value (
158bd3ca 999 styleID INT(10) NOT NULL,
4d9f6058 1000 variableID INT(10) NOT NULL,
158bd3ca 1001 variableValue MEDIUMTEXT,
4d9f6058 1002 UNIQUE KEY (styleID, variableID)
158bd3ca
TD		 1003);
1004
04c06e85
MW		 1005DROP TABLE IF EXISTS wcf1_tag;
1006CREATE TABLE wcf1_tag (
1007 tagID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1008 languageID INT(10) NOT NULL DEFAULT 0,
1009 name VARCHAR(255) NOT NULL,
1010 synonymFor INT(10),
1011 UNIQUE KEY (languageID, name)
1012);
1013
1014DROP TABLE IF EXISTS wcf1_tag_to_object;
1015CREATE TABLE wcf1_tag_to_object (
1016 objectID INT(10) NOT NULL,
1017 tagID INT(10) NOT NULL,
1018 objectTypeID INT(10) NOT NULL,
1019 languageID INT(10) NOT NULL,
1020 UNIQUE KEY (objectTypeID, languageID, objectID, tagID),
1021 KEY (objectTypeID, languageID, tagID),
1022 KEY (tagID, objectTypeID)
1023);
1024
158bd3ca
TD		 1025DROP TABLE IF EXISTS wcf1_template;
1026CREATE TABLE wcf1_template (
1027 templateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1028 packageID INT(10) NOT NULL,
04727c8b 1029 templateName VARCHAR(255) NOT NULL,
567fa8b8 1030 application VARCHAR(20) NOT NULL,
158bd3ca 1031 templateGroupID INT(10),
6570e38e 1032 lastModificationTime INT(10) NOT NULL DEFAULT 0,
e568316b 1033 UNIQUE KEY applicationTemplate (application, templateGroupID, templateName),
158bd3ca
TD		 1034 KEY templateGroupID (packageID, templateGroupID, templateName)
1035);
1036
1037DROP TABLE IF EXISTS wcf1_template_group;
1038CREATE TABLE wcf1_template_group (
1039 templateGroupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
6570e38e 1040 parentTemplateGroupID INT(10),
158bd3ca
TD		 1041 templateGroupName VARCHAR(255) NOT NULL DEFAULT '',
1042 templateGroupFolderName VARCHAR(255) NOT NULL DEFAULT ''
1043);
1044
0a67f96c
MS		 1045DROP TABLE IF EXISTS wcf1_template_listener;
1046CREATE TABLE wcf1_template_listener (
1047 listenerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1048 packageID INT(10) NOT NULL,
1049 name VARCHAR(80) NOT NULL DEFAULT '',
1050 environment ENUM('user','admin') NOT NULL DEFAULT 'user',
1051 templateName VARCHAR(80) NOT NULL DEFAULT '',
1052 eventName VARCHAR(50) NOT NULL DEFAULT '',
1053 templateCode TEXT NOT NULL,
da84cf75 1054 niceValue TINYINT(3) NOT NULL DEFAULT 0,
0a67f96c
MS		 1055 KEY templateName (environment, templateName)
1056);
1057
320f4a6d
MW		 1058DROP TABLE IF EXISTS wcf1_tracked_visit;
1059CREATE TABLE wcf1_tracked_visit (
1060 objectTypeID INT(10) NOT NULL,
1061 objectID INT(10) NOT NULL,
1062 userID INT(10) NOT NULL,
1063 visitTime INT(10) NOT NULL DEFAULT 0,
1064 UNIQUE KEY (objectTypeID, objectID, userID),
1065 KEY (userID, visitTime)
1066);
1067
1068DROP TABLE IF EXISTS wcf1_tracked_visit_type;
1069CREATE TABLE wcf1_tracked_visit_type (
1070 objectTypeID INT(10) NOT NULL,
1071 userID INT(10) NOT NULL,
1072 visitTime INT(10) NOT NULL DEFAULT 0,
1073 UNIQUE KEY (objectTypeID, userID),
1074 KEY (userID, visitTime)
1075);
1076
158bd3ca
TD		 1077DROP TABLE IF EXISTS wcf1_user;
1078CREATE TABLE wcf1_user (
1079 userID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1080 username VARCHAR(255) NOT NULL DEFAULT '',
1081 email VARCHAR(255) NOT NULL DEFAULT '',
4e273b1f 1082 password VARCHAR(100) NOT NULL DEFAULT '',
6a41a21e 1083 accessToken CHAR(40) NOT NULL DEFAULT '',
158bd3ca
TD		 1084 languageID INT(10) NOT NULL DEFAULT 0,
1085 registrationDate INT(10) NOT NULL DEFAULT 0,
1086 styleID INT(10) NOT NULL DEFAULT 0,
b1356a27
MW		 1087 banned TINYINT(1) NOT NULL DEFAULT 0,
1088 banReason MEDIUMTEXT NULL,
f034d0ec 1089 banExpires INT(10) NOT NULL DEFAULT 0,
320f4a6d
MW		 1090 activationCode INT(10) NOT NULL DEFAULT 0,
1091 lastLostPasswordRequestTime INT(10) NOT NULL DEFAULT 0,
1092 lostPasswordKey VARCHAR(40) NOT NULL DEFAULT '',
1093 lastUsernameChange INT(10) NOT NULL DEFAULT 0,
1094 newEmail VARCHAR(255) NOT NULL DEFAULT '',
1095 oldUsername VARCHAR(255) NOT NULL DEFAULT '',
1096 quitStarted INT(10) NOT NULL DEFAULT 0,
1097 reactivationCode INT(10) NOT NULL DEFAULT 0,
1098 registrationIpAddress VARCHAR(39) NOT NULL DEFAULT '',
1099 avatarID INT(10),
1100 disableAvatar TINYINT(1) NOT NULL DEFAULT 0,
1101 disableAvatarReason TEXT,
f034d0ec 1102 disableAvatarExpires INT(10) NOT NULL DEFAULT 0,
320f4a6d
MW		 1103 enableGravatar TINYINT(1) NOT NULL DEFAULT 0,
1104 signature TEXT,
1105 signatureEnableBBCodes TINYINT(1) NOT NULL DEFAULT 1,
1106 signatureEnableHtml TINYINT(1) NOT NULL DEFAULT 0,
1107 signatureEnableSmilies TINYINT(1) NOT NULL DEFAULT 1,
1108 disableSignature TINYINT(1) NOT NULL DEFAULT 0,
1109 disableSignatureReason TEXT,
f034d0ec 1110 disableSignatureExpires INT(10) NOT NULL DEFAULT 0,
320f4a6d
MW		 1111 lastActivityTime INT(10) NOT NULL DEFAULT 0,
1112 profileHits INT(10) NOT NULL DEFAULT 0,
1113 rankID INT(10),
1114 userTitle VARCHAR(255) NOT NULL DEFAULT '',
1115 userOnlineGroupID INT(10),
1116 activityPoints INT(10) NOT NULL DEFAULT 0,
1117 notificationMailToken VARCHAR(20) NOT NULL DEFAULT '',
1118 authData VARCHAR(255) NOT NULL DEFAULT '',
00b6f956 1119 likesReceived MEDIUMINT(7) NOT NULL DEFAULT 0,
9ed42d00 1120 socialNetworkPrivacySettings TEXT,
158bd3ca
TD		 1121
1122 KEY username (username),
1123 KEY registrationDate (registrationDate),
320f4a6d
MW		 1124 KEY styleID (styleID),
1125 KEY activationCode (activationCode),
1126 KEY registrationData (registrationIpAddress, registrationDate),
00b6f956
MW		 1127 KEY activityPoints (activityPoints),
1128 KEY likesReceived (likesReceived)
320f4a6d
MW		 1129);
1130
1131DROP TABLE IF EXISTS wcf1_user_activity_event;
1132CREATE TABLE wcf1_user_activity_event (
1133 eventID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1134 objectTypeID INT(10) NOT NULL,
1135 objectID INT(10) NOT NULL,
1136 languageID INT(10),
1137 userID INT(10) NOT NULL,
1138 time INT(10) NOT NULL,
1139 additionalData TEXT,
1140
1141 KEY (time),
1142 KEY (userID, time),
1143 KEY (objectTypeID, objectID)
1144);
1145
1146DROP TABLE IF EXISTS wcf1_user_activity_point;
1147CREATE TABLE wcf1_user_activity_point (
1148 userID INT(10) NOT NULL,
1149 objectTypeID INT(10) NOT NULL,
1150 activityPoints INT(10) NOT NULL DEFAULT 0,
a16ee110 1151 items INT(10) NOT NULL DEFAULT 0,
320f4a6d
MW		 1152 PRIMARY KEY (userID, objectTypeID),
1153 KEY (objectTypeID)
1154);
1155
359f3c53
MW		 1156DROP TABLE IF EXISTS wcf1_user_authentication_failure;
1157CREATE TABLE wcf1_user_authentication_failure (
1158 failureID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1159 environment ENUM('user', 'admin') NOT NULL DEFAULT 'user',
1160 userID INT(10),
1161 username VARCHAR(255) NOT NULL DEFAULT '',
1162 time INT(10) NOT NULL DEFAULT 0,
1163 ipAddress VARCHAR(39) NOT NULL DEFAULT '',
1164 userAgent VARCHAR(255) NOT NULL DEFAULT '',
1165 KEY (ipAddress, time),
1166 KEY (time)
1167);
1168
320f4a6d
MW		 1169DROP TABLE IF EXISTS wcf1_user_avatar;
1170CREATE TABLE wcf1_user_avatar (
1171 avatarID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1172 avatarName VARCHAR(255) NOT NULL DEFAULT '',
1173 avatarExtension VARCHAR(7) NOT NULL DEFAULT '',
1174 width SMALLINT(5) NOT NULL DEFAULT 0,
1175 height SMALLINT(5) NOT NULL DEFAULT 0,
1176 userID INT(10),
1177 fileHash VARCHAR(40) NOT NULL DEFAULT '',
1178 cropX SMALLINT(5) NOT NULL DEFAULT 0,
1179 cropY SMALLINT(5) NOT NULL DEFAULT 0
158bd3ca
TD		 1180);
1181
a8e8aa21
AE		 1182DROP TABLE IF EXISTS wcf1_user_collapsible_content;
1183CREATE TABLE wcf1_user_collapsible_content (
1184 objectTypeID INT(10) NOT NULL,
644b0ee3 1185 objectID VARCHAR(255) NOT NULL,
a8e8aa21
AE		 1186 userID INT(10) NOT NULL,
1187 UNIQUE KEY (objectTypeID, objectID, userID)
1188);
1189
320f4a6d
MW		 1190DROP TABLE IF EXISTS wcf1_user_follow;
1191CREATE TABLE wcf1_user_follow (
1192 followID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1193 userID INT(10) NOT NULL,
1194 followUserID INT(10) NOT NULL,
1195 time INT(10) NOT NULL DEFAULT 0,
1196 UNIQUE KEY (userID, followUserID)
1197);
1198
158bd3ca
TD		 1199DROP TABLE IF EXISTS wcf1_user_group;
1200CREATE TABLE wcf1_user_group (
1201 groupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1202 groupName VARCHAR(255) NOT NULL DEFAULT '',
005f6926 1203 groupDescription TEXT,
320f4a6d
MW		 1204 groupType TINYINT(1) NOT NULL DEFAULT 4,
1205 priority MEDIUMINT(8) NOT NULL DEFAULT 0,
1206 userOnlineMarking VARCHAR(255) NOT NULL DEFAULT '%s',
1207 showOnTeamPage TINYINT(1) NOT NULL DEFAULT 0
158bd3ca
TD		 1208);
1209
87d3a054
MS		 1210DROP TABLE IF EXISTS wcf1_user_group_assignment;
1211CREATE TABLE wcf1_user_group_assignment (
1212 assignmentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1213 groupID INT(10) NOT NULL,
1214 title VARCHAR(255) NOT NULL,
1215 isDisabled TINYINT(1) NOT NULL DEFAULT 0
1216);
1217
158bd3ca 1218DROP TABLE IF EXISTS wcf1_user_group_option;
01bd2eff 1219CREATE TABLE wcf1_user_group_option (
158bd3ca
TD		 1220 optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1221 packageID INT(10),
1222 optionName VARCHAR(255) NOT NULL DEFAULT '',
1223 categoryName VARCHAR(255) NOT NULL DEFAULT '',
1224 optionType VARCHAR(255) NOT NULL DEFAULT '',
1225 defaultValue MEDIUMTEXT,
158bd3ca
TD		 1226 validationPattern TEXT,
1227 enableOptions MEDIUMTEXT,
1228 showOrder INT(10) NOT NULL DEFAULT 0,
1229 permissions TEXT,
1230 options TEXT,
ae6b590f 1231 usersOnly TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 1232 additionalData MEDIUMTEXT,
1233 UNIQUE KEY optionName (optionName, packageID)
1234);
1235
1236DROP TABLE IF EXISTS wcf1_user_group_option_category;
1237CREATE TABLE wcf1_user_group_option_category (
1238 categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1239 packageID INT(10) NOT NULL,
1240 categoryName VARCHAR(255) NOT NULL DEFAULT '',
1241 parentCategoryName VARCHAR(255) NOT NULL DEFAULT '',
1242 showOrder INT(10) NOT NULL DEFAULT 0,
1243 permissions TEXT,
1244 options TEXT,
0e580f32 1245 UNIQUE KEY categoryName (categoryName)
158bd3ca
TD		 1246);
1247
1248DROP TABLE IF EXISTS wcf1_user_group_option_value;
01bd2eff 1249CREATE TABLE wcf1_user_group_option_value (
158bd3ca
TD		 1250 groupID INT(10) NOT NULL,
1251 optionID INT(10) NOT NULL,
1252 optionValue MEDIUMTEXT NOT NULL,
1253 UNIQUE KEY groupID (groupID, optionID)
1254);
1255
320f4a6d
MW		 1256DROP TABLE IF EXISTS wcf1_user_ignore;
1257CREATE TABLE wcf1_user_ignore (
1258 ignoreID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1259 userID INT(10) NOT NULL,
1260 ignoreUserID INT(10) NOT NULL,
1261 time INT(10) NOT NULL DEFAULT 0,
1262 UNIQUE KEY (userID, ignoreUserID)
1263);
1264
1265DROP TABLE IF EXISTS wcf1_user_menu_item;
1266CREATE TABLE wcf1_user_menu_item (
1267 menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1268 packageID INT(10) NOT NULL,
1269 menuItem VARCHAR(255) NOT NULL DEFAULT '',
1270 parentMenuItem VARCHAR(255) NOT NULL DEFAULT '',
1271 menuItemController VARCHAR(255) NOT NULL DEFAULT '',
1272 menuItemLink VARCHAR(255) NOT NULL DEFAULT '',
1273 showOrder INT(10) NOT NULL DEFAULT 0,
1274 permissions TEXT,
1275 options TEXT,
1276 className VARCHAR(255) NOT NULL DEFAULT '',
1277 UNIQUE KEY menuItem (menuItem, packageID)
1278);
1279
1280-- notifications
1281DROP TABLE IF EXISTS wcf1_user_notification;
1282CREATE TABLE wcf1_user_notification (
1283 notificationID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
8a4289f5 1284 packageID INT(10) NOT NULL, -- DEPRECATED
320f4a6d
MW		 1285 eventID INT(10) NOT NULL,
1286 objectID INT(10) NOT NULL DEFAULT 0,
6db83ca9 1287 baseObjectID INT(10) NOT NULL DEFAULT 0, -- base object ID for generic implementations referencing the origin, e.g. the object being liked
68206b3f 1288 eventHash VARCHAR(40) NOT NULL DEFAULT '',
4341fcab 1289 authorID INT(10) NULL,
68206b3f 1290 timesTriggered INT(10) NOT NULL DEFAULT 0,
afb18fa2 1291 guestTimesTriggered INT(10) NOT NULL DEFAULT 0,
4341fcab 1292 userID INT(10) NOT NULL,
320f4a6d 1293 time INT(10) NOT NULL DEFAULT 0,
4341fcab
AE		 1294 mailNotified TINYINT(1) NOT NULL DEFAULT 0,
1295 confirmed TINYINT(1) NOT NULL DEFAULT 0,
320f4a6d 1296 additionalData TEXT,
4341fcab
AE		 1297 KEY (userID, eventID, objectID, confirmed)
1298);
1299
1300-- notification authors (stacking)
1301DROP TABLE IF EXISTS wcf1_user_notification_author;
1302CREATE TABLE wcf1_user_notification_author (
1303 notificationID INT(10) NOT NULL,
afb18fa2 1304 authorID INT(10),
4341fcab 1305 time INT(10) NOT NULL DEFAULT 0,
4341fcab 1306 UNIQUE KEY (notificationID, authorID)
320f4a6d
MW		 1307);
1308
1309-- notification recipients
4341fcab 1310-- DEPRECATED
320f4a6d
MW		 1311DROP TABLE IF EXISTS wcf1_user_notification_to_user;
1312CREATE TABLE wcf1_user_notification_to_user (
1313 notificationID INT(10) NOT NULL,
1314 userID INT(10) NOT NULL,
320f4a6d
MW		 1315 UNIQUE KEY notificationID (notificationID, userID)
1316);
1317
1318-- events that create notifications
1319DROP TABLE IF EXISTS wcf1_user_notification_event;
1320CREATE TABLE wcf1_user_notification_event (
1321 eventID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1322 packageID INT(10) NOT NULL,
1323 eventName VARCHAR(255) NOT NULL DEFAULT '',
1324 objectTypeID INT(10) NOT NULL,
1325 className VARCHAR(255) NOT NULL DEFAULT '',
1326 permissions TEXT,
1327 options TEXT,
2d7c568a 1328 preset TINYINT(1) NOT NULL DEFAULT 0,
0ceb9e95 1329 presetMailNotificationType ENUM('none', 'instant', 'daily') NOT NULL DEFAULT 'none',
320f4a6d
MW		 1330 UNIQUE KEY eventName (eventName, objectTypeID)
1331);
1332
1333-- user configuration for events
1334DROP TABLE IF EXISTS wcf1_user_notification_event_to_user;
1335CREATE TABLE wcf1_user_notification_event_to_user (
1336 userID INT(10) NOT NULL,
1337 eventID INT(10) NOT NULL,
1338 mailNotificationType ENUM('none', 'instant', 'daily') NOT NULL DEFAULT 'none',
1339 UNIQUE KEY (eventID, userID)
1340);
1341
1342DROP TABLE IF EXISTS wcf1_user_object_watch;
1343CREATE TABLE wcf1_user_object_watch (
1344 watchID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1345 objectTypeID INT(10) NOT NULL,
1346 objectID INT(10) NOT NULL,
1347 userID INT(10) NOT NULL,
1348 notification TINYINT(1) NOT NULL DEFAULT 0,
1349
1350 UNIQUE KEY (objectTypeID, userID, objectID),
1351 KEY (objectTypeID, objectID)
1352);
1353
158bd3ca
TD		 1354DROP TABLE IF EXISTS wcf1_user_option;
1355CREATE TABLE wcf1_user_option (
1356 optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1357 packageID INT(10) NOT NULL,
1358 optionName VARCHAR(255) NOT NULL DEFAULT '',
1359 categoryName VARCHAR(255) NOT NULL DEFAULT '',
1360 optionType VARCHAR(255) NOT NULL DEFAULT '',
1361 defaultValue MEDIUMTEXT,
1362 validationPattern TEXT,
1363 selectOptions MEDIUMTEXT,
1364 enableOptions MEDIUMTEXT,
1365 required TINYINT(1) NOT NULL DEFAULT 0,
1366 askDuringRegistration TINYINT(1) NOT NULL DEFAULT 0,
1367 editable TINYINT(1) NOT NULL DEFAULT 0,
1368 visible TINYINT(1) NOT NULL DEFAULT 0,
1369 outputClass VARCHAR(255) NOT NULL DEFAULT '',
1370 searchable TINYINT(1) NOT NULL DEFAULT 0,
1371 showOrder INT(10) NOT NULL DEFAULT 0,
8f08c7d0 1372 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 1373 permissions TEXT,
1374 options TEXT,
1375 additionalData MEDIUMTEXT,
31378fd1 1376 originIsSystem TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 1377 UNIQUE KEY optionName (optionName, packageID),
1378 KEY categoryName (categoryName)
1379);
1380
1381DROP TABLE IF EXISTS wcf1_user_option_category;
1382CREATE TABLE wcf1_user_option_category (
1383 categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1384 packageID INT(10) NOT NULL,
1385 categoryName VARCHAR(255) NOT NULL DEFAULT '',
158bd3ca
TD		 1386 parentCategoryName VARCHAR(255) NOT NULL DEFAULT '',
1387 showOrder INT(10) NOT NULL DEFAULT 0,
1388 permissions TEXT,
1389 options TEXT,
0e580f32 1390 UNIQUE KEY categoryName (categoryName)
158bd3ca
TD		 1391);
1392
1393DROP TABLE IF EXISTS wcf1_user_option_value;
1394CREATE TABLE wcf1_user_option_value (
1395 userID INT(10) NOT NULL PRIMARY KEY
1396);
1397
320f4a6d
MW		 1398DROP TABLE IF EXISTS wcf1_user_profile_menu_item;
1399CREATE TABLE wcf1_user_profile_menu_item (
1400 menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1401 packageID INT(10) NOT NULL,
1402 menuItem VARCHAR(255) NOT NULL,
1403 showOrder INT(10) NOT NULL DEFAULT 0,
1404 permissions TEXT NULL,
1405 options TEXT NULL,
1406 className VARCHAR(255) NOT NULL,
1407 UNIQUE KEY (packageID, menuItem)
1408);
1409
1410DROP TABLE IF EXISTS wcf1_user_profile_visitor;
1411CREATE TABLE wcf1_user_profile_visitor (
1412 visitorID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1413 ownerID INT(10),
1414 userID INT(10),
1415 time INT(10) NOT NULL DEFAULT 0,
1416 UNIQUE KEY (ownerID, userID),
1417 KEY (time)
1418);
1419
1420DROP TABLE IF EXISTS wcf1_user_rank;
1421CREATE TABLE wcf1_user_rank (
1422 rankID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
d2fbb3b5 1423 groupID INT(10) NOT NULL,
320f4a6d
MW		 1424 requiredPoints INT(10) NOT NULL DEFAULT 0,
1425 rankTitle VARCHAR(255) NOT NULL DEFAULT '',
1426 cssClassName VARCHAR(255) NOT NULL DEFAULT '',
1427 rankImage VARCHAR(255) NOT NULL DEFAULT '',
1428 repeatImage TINYINT(3) NOT NULL DEFAULT 1,
1429 requiredGender TINYINT(1) NOT NULL DEFAULT 0
1430);
1431
0a67f96c
MS		 1432DROP TABLE IF EXISTS wcf1_user_storage;
1433CREATE TABLE wcf1_user_storage (
1434 userID INT(10) NOT NULL,
1435 field VARCHAR(80) NOT NULL DEFAULT '',
064caa4a 1436 fieldValue MEDIUMTEXT,
0b30544a 1437 UNIQUE KEY userStorageData (userID, field)
0a67f96c
MS		 1438);
1439
158bd3ca
TD		 1440DROP TABLE IF EXISTS wcf1_user_to_group;
1441CREATE TABLE wcf1_user_to_group (
1442 userID INT(10) NOT NULL,
1443 groupID INT(10) NOT NULL,
1444 UNIQUE KEY userID (userID, groupID)
1445);
1446
1447DROP TABLE IF EXISTS wcf1_user_to_language;
1448CREATE TABLE wcf1_user_to_language (
1449 userID INT(10) NOT NULL,
1450 languageID INT(10) NOT NULL,
1451 UNIQUE KEY userID (userID, languageID)
1452);
1453
2fbf5046
AE		 1454/* SQL_PARSER_OFFSET */
1455
9f959ced 1456/* foreign keys */
092bdf82
AE		 1457ALTER TABLE wcf1_acl_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1458ALTER TABLE wcf1_acl_option ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1459
1460ALTER TABLE wcf1_acl_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1461ALTER TABLE wcf1_acl_option_category ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1462
1463ALTER TABLE wcf1_acl_option_to_user ADD FOREIGN KEY (optionID) REFERENCES wcf1_acl_option (optionID) ON DELETE CASCADE;
1464ALTER TABLE wcf1_acl_option_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1465
1466ALTER TABLE wcf1_acl_option_to_group ADD FOREIGN KEY (optionID) REFERENCES wcf1_acl_option (optionID) ON DELETE CASCADE;
1467ALTER TABLE wcf1_acl_option_to_group ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
1468
158bd3ca
TD		 1469ALTER TABLE wcf1_acp_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1470
e9311b98
AE		 1471ALTER TABLE wcf1_acp_search_provider ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1472
158bd3ca 1473ALTER TABLE wcf1_acp_session ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
158bd3ca
TD		 1474
1475ALTER TABLE wcf1_acp_session_access_log ADD FOREIGN KEY (sessionLogID) REFERENCES wcf1_acp_session_log (sessionLogID) ON DELETE CASCADE;
158bd3ca 1476
158bd3ca
TD		 1477ALTER TABLE wcf1_acp_session_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1478
1479ALTER TABLE wcf1_acp_template ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1480
e866b80e
MS		 1481ALTER TABLE wcf1_ad ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1482
158bd3ca 1483ALTER TABLE wcf1_application ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
158bd3ca 1484
f0bc263f
MW		 1485ALTER TABLE wcf1_attachment ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1486ALTER TABLE wcf1_attachment ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1487
dcc2332d
MW		 1488ALTER TABLE wcf1_bbcode ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1489
1490ALTER TABLE wcf1_bbcode_attribute ADD FOREIGN KEY (bbcodeID) REFERENCES wcf1_bbcode (bbcodeID) ON DELETE CASCADE;
1491
13d8b49b
MS		 1492ALTER TABLE wcf1_category ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1493
054db725
TD		 1494ALTER TABLE wcf1_cli_history ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1495
0e6741f8
AE		 1496ALTER TABLE wcf1_clipboard_action ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1497
25cf4d11 1498ALTER TABLE wcf1_clipboard_item ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
0e6741f8
AE		 1499
1500ALTER TABLE wcf1_clipboard_page ADD FOREIGN KEY (actionID) REFERENCES wcf1_clipboard_action (actionID) ON DELETE CASCADE;
1501ALTER TABLE wcf1_clipboard_page ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1502
87d3a054
MS		 1503ALTER TABLE wcf1_condition ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1504
158bd3ca
TD		 1505ALTER TABLE wcf1_core_object ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1506
1507ALTER TABLE wcf1_cronjob ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1508
1509ALTER TABLE wcf1_cronjob_log ADD FOREIGN KEY (cronjobID) REFERENCES wcf1_cronjob (cronjobID) ON DELETE CASCADE;
1510
81aa6374
TD		 1511ALTER TABLE wcf1_edit_history_entry ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1512ALTER TABLE wcf1_edit_history_entry ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
f86d7ff7 1513ALTER TABLE wcf1_edit_history_entry ADD FOREIGN KEY (obsoletedByUserID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
81aa6374 1514
158bd3ca
TD		 1515ALTER TABLE wcf1_event_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1516
1517ALTER TABLE wcf1_language_item ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
1518ALTER TABLE wcf1_language_item ADD FOREIGN KEY (languageCategoryID) REFERENCES wcf1_language_category (languageCategoryID) ON DELETE CASCADE;
1519ALTER TABLE wcf1_language_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1520
3a2de7fd
AE		 1521ALTER TABLE wcf1_modification_log ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1522ALTER TABLE wcf1_modification_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1523
7fcc7676
MW		 1524ALTER TABLE wcf1_object_type ADD FOREIGN KEY (definitionID) REFERENCES wcf1_object_type_definition (definitionID) ON DELETE CASCADE;
1525ALTER TABLE wcf1_object_type ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1526
1527ALTER TABLE wcf1_object_type_definition ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1528
158bd3ca
TD		 1529ALTER TABLE wcf1_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1530
1531ALTER TABLE wcf1_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1532
158bd3ca
TD		 1533ALTER TABLE wcf1_package_exclusion ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1534
1535ALTER TABLE wcf1_package_installation_file_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1536
1537ALTER TABLE wcf1_package_installation_form ADD FOREIGN KEY (queueID) REFERENCES wcf1_package_installation_queue (queueID) ON DELETE CASCADE;
1538
1539ALTER TABLE wcf1_package_installation_node ADD FOREIGN KEY (queueID) REFERENCES wcf1_package_installation_queue (queueID) ON DELETE CASCADE;
1540
1541ALTER TABLE wcf1_package_installation_plugin ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1542
1543ALTER TABLE wcf1_package_installation_queue ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1544ALTER TABLE wcf1_package_installation_queue ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE SET NULL;
1545
1546ALTER TABLE wcf1_package_installation_sql_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1547
1b4f5112
AE		 1548/* SQL_PARSER_OFFSET */
1549
158bd3ca
TD		 1550ALTER TABLE wcf1_package_requirement ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1551ALTER TABLE wcf1_package_requirement ADD FOREIGN KEY (requirement) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1552
158bd3ca
TD		 1553ALTER TABLE wcf1_package_update ADD FOREIGN KEY (packageUpdateServerID) REFERENCES wcf1_package_update_server (packageUpdateServerID) ON DELETE CASCADE;
1554
1555ALTER TABLE wcf1_package_update_exclusion ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
1556
1557ALTER TABLE wcf1_package_update_fromversion ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
1558
1559ALTER TABLE wcf1_package_update_requirement ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
1560
b4f1ea02 1561ALTER TABLE wcf1_package_update_optional ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
158bd3ca
TD		 1562
1563ALTER TABLE wcf1_package_update_version ADD FOREIGN KEY (packageUpdateID) REFERENCES wcf1_package_update (packageUpdateID) ON DELETE CASCADE;
1564
4d8036f5
MW		 1565ALTER TABLE wcf1_paid_subscription_user ADD FOREIGN KEY (subscriptionID) REFERENCES wcf1_paid_subscription (subscriptionID) ON DELETE CASCADE;
1566ALTER TABLE wcf1_paid_subscription_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1567
1568ALTER TABLE wcf1_paid_subscription_transaction_log ADD FOREIGN KEY (subscriptionUserID) REFERENCES wcf1_paid_subscription_user (subscriptionUserID) ON DELETE SET NULL;
1569ALTER TABLE wcf1_paid_subscription_transaction_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1570ALTER TABLE wcf1_paid_subscription_transaction_log ADD FOREIGN KEY (subscriptionID) REFERENCES wcf1_paid_subscription (subscriptionID) ON DELETE SET NULL;
1571ALTER TABLE wcf1_paid_subscription_transaction_log ADD FOREIGN KEY (paymentMethodObjectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1572
158bd3ca
TD		 1573ALTER TABLE wcf1_page_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1574
1575ALTER TABLE wcf1_search ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1576
158bd3ca 1577ALTER TABLE wcf1_session ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
e8d26212 1578ALTER TABLE wcf1_session ADD FOREIGN KEY (spiderID) REFERENCES wcf1_spider (spiderID) ON DELETE CASCADE;
158bd3ca 1579
5a05fde9
AE		 1580ALTER TABLE wcf1_session_virtual ADD FOREIGN KEY (sessionID) REFERENCES wcf1_session (sessionID) ON DELETE CASCADE;
1581
46bd110b
AE		 1582ALTER TABLE wcf1_sitemap ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1583
dcc2332d
MW		 1584ALTER TABLE wcf1_smiley ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1585ALTER TABLE wcf1_smiley ADD FOREIGN KEY (categoryID) REFERENCES wcf1_category (categoryID) ON DELETE SET NULL;
1586
461a69ea 1587ALTER TABLE wcf1_user_storage ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
158bd3ca
TD		 1588
1589ALTER TABLE wcf1_style ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1590
4d9f6058
AE		 1591ALTER TABLE wcf1_style_variable_value ADD FOREIGN KEY (styleID) REFERENCES wcf1_style (styleID) ON DELETE CASCADE;
1592ALTER TABLE wcf1_style_variable_value ADD FOREIGN KEY (variableID) REFERENCES wcf1_style_variable (variableID) ON DELETE CASCADE;
158bd3ca
TD		 1593
1594ALTER TABLE wcf1_template ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1595ALTER TABLE wcf1_template ADD FOREIGN KEY (templateGroupID) REFERENCES wcf1_template_group (templateGroupID) ON DELETE CASCADE;
1596
6570e38e
MW		 1597ALTER TABLE wcf1_template_group ADD FOREIGN KEY (parentTemplateGroupID) REFERENCES wcf1_template_group (templateGroupID) ON DELETE SET NULL;
1598
158bd3ca
TD		 1599ALTER TABLE wcf1_template_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1600
a8e8aa21
AE		 1601ALTER TABLE wcf1_user_collapsible_content ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1602ALTER TABLE wcf1_user_collapsible_content ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1603
87d3a054
MS		 1604ALTER TABLE wcf1_user_group_assignment ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
1605
158bd3ca
TD		 1606ALTER TABLE wcf1_user_group_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1607
1608ALTER TABLE wcf1_user_group_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1609
1610ALTER TABLE wcf1_user_group_option_value ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
1611ALTER TABLE wcf1_user_group_option_value ADD FOREIGN KEY (optionID) REFERENCES wcf1_user_group_option (optionID) ON DELETE CASCADE;
1612
2fbf5046
AE		 1613/* SQL_PARSER_OFFSET */
1614
158bd3ca
TD		 1615ALTER TABLE wcf1_user_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1616
1617ALTER TABLE wcf1_user_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1618
1619ALTER TABLE wcf1_user_option_value ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1620
1621ALTER TABLE wcf1_user_to_group ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1622ALTER TABLE wcf1_user_to_group ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
1623
1624ALTER TABLE wcf1_user_to_language ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1625ALTER TABLE wcf1_user_to_language ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
1626
320f4a6d
MW		 1627ALTER TABLE wcf1_dashboard_box ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1628
1629ALTER TABLE wcf1_dashboard_option ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1630ALTER TABLE wcf1_dashboard_option ADD FOREIGN KEY (boxID) REFERENCES wcf1_dashboard_box (boxID) ON DELETE CASCADE;
1631
78db8ddf
MW		 1632ALTER TABLE wcf1_import_mapping ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1633
320f4a6d
MW		 1634ALTER TABLE wcf1_tracked_visit ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1635ALTER TABLE wcf1_tracked_visit ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1636
1637ALTER TABLE wcf1_tracked_visit_type ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1638ALTER TABLE wcf1_tracked_visit_type ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1639
1640ALTER TABLE wcf1_user ADD FOREIGN KEY (avatarID) REFERENCES wcf1_user_avatar (avatarID) ON DELETE SET NULL;
1641ALTER TABLE wcf1_user ADD FOREIGN KEY (rankID) REFERENCES wcf1_user_rank (rankID) ON DELETE SET NULL;
1642ALTER TABLE wcf1_user ADD FOREIGN KEY (userOnlineGroupID) REFERENCES wcf1_user_group (groupID) ON DELETE SET NULL;
1643
1644ALTER TABLE wcf1_user_avatar ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1645
1646ALTER TABLE wcf1_user_follow ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1647ALTER TABLE wcf1_user_follow ADD FOREIGN KEY (followUserID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1648
1649ALTER TABLE wcf1_user_ignore ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1650ALTER TABLE wcf1_user_ignore ADD FOREIGN KEY (ignoreUserID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1651
1652ALTER TABLE wcf1_user_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1653
320f4a6d
MW		 1654ALTER TABLE wcf1_user_notification ADD FOREIGN KEY (eventID) REFERENCES wcf1_user_notification_event (eventID) ON DELETE CASCADE;
1655ALTER TABLE wcf1_user_notification ADD FOREIGN KEY (authorID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
4341fcab
AE		 1656ALTER TABLE wcf1_user_notification ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1657
1658ALTER TABLE wcf1_user_notification_author ADD FOREIGN KEY (notificationID) REFERENCES wcf1_user_notification (notificationID) ON DELETE CASCADE;
1659ALTER TABLE wcf1_user_notification_author ADD FOREIGN KEY (authorID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
320f4a6d
MW		 1660
1661ALTER TABLE wcf1_user_notification_to_user ADD FOREIGN KEY (notificationID) REFERENCES wcf1_user_notification (notificationID) ON DELETE CASCADE;
1662ALTER TABLE wcf1_user_notification_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1663
1664ALTER TABLE wcf1_user_notification_event ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1665ALTER TABLE wcf1_user_notification_event ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1666
1667ALTER TABLE wcf1_user_notification_event_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1668ALTER TABLE wcf1_user_notification_event_to_user ADD FOREIGN KEY (eventID) REFERENCES wcf1_user_notification_event (eventID) ON DELETE CASCADE;
1669
1670ALTER TABLE wcf1_user_profile_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1671
1b4f5112
AE		 1672/* SQL_PARSER_OFFSET */
1673
d2fbb3b5 1674ALTER TABLE wcf1_user_rank ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
320f4a6d
MW		 1675
1676ALTER TABLE wcf1_user_activity_event ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1677ALTER TABLE wcf1_user_activity_event ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1678ALTER TABLE wcf1_user_activity_event ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE SET NULL;
1679
1680ALTER TABLE wcf1_user_activity_point ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1681ALTER TABLE wcf1_user_activity_point ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1682
359f3c53
MW		 1683ALTER TABLE wcf1_user_authentication_failure ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1684
320f4a6d
MW		 1685ALTER TABLE wcf1_user_profile_visitor ADD FOREIGN KEY (ownerID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1686ALTER TABLE wcf1_user_profile_visitor ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1687
1688ALTER TABLE wcf1_user_object_watch ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1689ALTER TABLE wcf1_user_object_watch ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1690
0a2b09a2
MW		 1691ALTER TABLE wcf1_message_embedded_object ADD FOREIGN KEY (messageObjectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1692ALTER TABLE wcf1_message_embedded_object ADD FOREIGN KEY (embeddedObjectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1693
fc69b61d
MW		 1694ALTER TABLE wcf1_moderation_queue ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1695ALTER TABLE wcf1_moderation_queue ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1696ALTER TABLE wcf1_moderation_queue ADD FOREIGN KEY (assignedUserID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1697
1698ALTER TABLE wcf1_moderation_queue_to_user ADD FOREIGN KEY (queueID) REFERENCES wcf1_moderation_queue (queueID) ON DELETE CASCADE;
1699ALTER TABLE wcf1_moderation_queue_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1700
00b6f956
MW		 1701ALTER TABLE wcf1_like ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1702ALTER TABLE wcf1_like ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1703ALTER TABLE wcf1_like ADD FOREIGN KEY (objectUserID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1704
1705ALTER TABLE wcf1_like_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1706ALTER TABLE wcf1_like_object ADD FOREIGN KEY (objectUserID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1707
285b1d92
MW		 1708ALTER TABLE wcf1_comment ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1709ALTER TABLE wcf1_comment ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1710
1711ALTER TABLE wcf1_comment_response ADD FOREIGN KEY (commentID) REFERENCES wcf1_comment (commentID) ON DELETE CASCADE;
1712ALTER TABLE wcf1_comment_response ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1713
3b75466f
MW		 1714ALTER TABLE wcf1_label ADD FOREIGN KEY (groupID) REFERENCES wcf1_label_group (groupID) ON DELETE CASCADE;
1715
1716ALTER TABLE wcf1_label_group_to_object ADD FOREIGN KEY (groupID) REFERENCES wcf1_label_group (groupID) ON DELETE CASCADE;
1717ALTER TABLE wcf1_label_group_to_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1718
1719ALTER TABLE wcf1_label_object ADD FOREIGN KEY (labelID) REFERENCES wcf1_label (labelID) ON DELETE CASCADE;
1720ALTER TABLE wcf1_label_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1721
04c06e85
MW		 1722ALTER TABLE wcf1_tag ADD FOREIGN KEY (synonymFor) REFERENCES wcf1_tag (tagID) ON DELETE CASCADE;
1723
1724ALTER TABLE wcf1_tag_to_object ADD FOREIGN KEY (tagID) REFERENCES wcf1_tag (tagID) ON DELETE CASCADE;
1725ALTER TABLE wcf1_tag_to_object ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
1726ALTER TABLE wcf1_tag_to_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1727
891de7a0
MW		 1728ALTER TABLE wcf1_stat_daily ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1729
e25b7b61
MW		 1730ALTER TABLE wcf1_poll ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1731
1732ALTER TABLE wcf1_poll_option ADD FOREIGN KEY (pollID) REFERENCES wcf1_poll (pollID) ON DELETE CASCADE;
1733
1734ALTER TABLE wcf1_poll_option_vote ADD FOREIGN KEY (pollID) REFERENCES wcf1_poll (pollID) ON DELETE CASCADE;
1735ALTER TABLE wcf1_poll_option_vote ADD FOREIGN KEY (optionID) REFERENCES wcf1_poll_option (optionID) ON DELETE CASCADE;
1736ALTER TABLE wcf1_poll_option_vote ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1737
20933e61
MS		 1738ALTER TABLE wcf1_notice_dismissed ADD FOREIGN KEY (noticeID) REFERENCES wcf1_notice (noticeID) ON DELETE CASCADE;
1739ALTER TABLE wcf1_notice_dismissed ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1740
2fbf5046
AE		 1741/* SQL_PARSER_OFFSET */
1742
9f959ced 1743/* default inserts */
158bd3ca 1744-- default user groups
3f69fee7
AE		 1745INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (1, 'wcf.acp.group.group1', 1); -- Everyone
1746INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (2, 'wcf.acp.group.group2', 2); -- Guests
1747INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (3, 'wcf.acp.group.group3', 3); -- Registered Users
1748INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (4, 'wcf.acp.group.group4', 4); -- Administrators
1749INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (5, 'wcf.acp.group.group5', 4); -- Moderators
47459aed 1750
158bd3ca 1751-- default user group options
ae6b590f
MS		 1752INSERT INTO wcf1_user_group_option (optionID, optionName, categoryName, optionType, defaultValue, showOrder, usersOnly) VALUES (1, 'admin.general.canUseAcp', 'admin.general', 'boolean', '0', 1, 1);
1753INSERT INTO wcf1_user_group_option (optionID, optionName, categoryName, optionType, defaultValue, showOrder, usersOnly) VALUES (2, 'admin.system.package.canInstallPackage', 'admin.system.package', 'boolean', '0', 1, 1);
1754INSERT INTO wcf1_user_group_option (optionID, optionName, categoryName, optionType, defaultValue, showOrder, usersOnly) VALUES (3, 'admin.user.canEditGroup', 'admin.user.group', 'boolean', '0', 1, 1);
158bd3ca
TD		 1755
1756-- default user group option values
1757INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 1, '0'); -- Everyone
1758INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 2, '0'); -- Everyone
1759INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 3, '0'); -- Everyone
1760INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 1, '1'); -- Administrators
1761INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 2, '1'); -- Administrators
1762INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 3, '1'); -- Administrators
47459aed 1763
158bd3ca 1764-- default update servers
37111120
AE		 1765INSERT INTO wcf1_package_update_server (serverURL, status, isDisabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://update.woltlab.com/typhoon/', 'online', 0, NULL, 0, '', '');
1766INSERT INTO wcf1_package_update_server (serverURL, status, isDisabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://store.woltlab.com/typhoon/', 'online', 0, NULL, 0, '', '');
4d9f6058
AE		 1767
1768-- style default values
baa4743d
AE		 1769INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentBackgroundColor', 'rgba(255, 255, 255, 1)');
1770INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfColor', 'rgba(102, 102, 102, 1)');
1771INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLinkColor', 'rgba(63, 127, 191, 1)');
1772INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLinkHoverColor', 'rgba(15, 79, 143, 1)');
1773INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerBackgroundColor', 'rgba(255, 255, 255, 1)');
1774INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerAccentBackgroundColor', 'rgba(249, 249, 249, 1)');
1775INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerHoverBackgroundColor', 'rgba(244, 244, 244, 1)');
1776INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerBorderColor', 'rgba(221, 221, 221, 1)');
372c77c4 1777INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerBorderRadius', '0px');
baa4743d
AE		 1778INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxBackgroundColor', 'rgba(63, 127, 191, 1)');
1779INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxColor', 'rgba(255, 255, 255, 1)');
1780INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxHoverColor', 'rgba(255, 255, 255, 1)');
1781INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelBackgroundColor', 'rgba(45, 45, 45, 1)');
1782INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelColor', 'rgba(255, 255, 255, 1)');
1783INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelHoverColor', 'rgba(255, 255, 255, 1)');
1784INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBackgroundColor', 'rgba(249, 249, 249, 1)');
1785INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBorderColor', 'rgba(221, 221, 221, 1)');
8ce85e3a
MW		 1786INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBorderRadius', '15px');
1787INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSmallButtonBorderRadius', '3px');
baa4743d 1788INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonColor', 'rgba(102, 102, 102, 1)');
90a67f4f
MW		 1789INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryBackgroundColor', 'rgba(211, 232, 254, 1)');
1790INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryBorderColor', 'rgba(136, 194, 255, 1)');
baa4743d 1791INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryColor', 'rgba(102, 153, 204, 1)');
90a67f4f
MW		 1792INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryHoverBackgroundColor', 'darken(@wcfButtonPrimaryBackgroundColor, 3%)');
1793INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryHoverBorderColor', 'darken(@wcfButtonPrimaryBorderColor, 10%)');
1794INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryHoverColor', '@wcfButtonPrimaryColor');
91143353
MW		 1795INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonHoverBackgroundColor', 'rgba(241, 241, 241, 1)');
1796INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonHoverBorderColor', 'rgba(224, 224, 224, 1)');
cdb161b9 1797INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonHoverColor', 'rgba(102, 102, 102, 1)');
baa4743d
AE		 1798INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBackgroundColor', 'rgba(255, 255, 255, 1)');
1799INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputColor', 'rgba(102, 102, 102, 1)');
1800INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBorderColor', 'rgba(204, 204, 204, 1)');
f9788d30
K		 1801INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputHoverBackgroundColor', 'rgba(239, 247, 255, 1)');
1802INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputHoverBorderColor', 'rgba(198, 222, 248, 1)');
8ce85e3a 1803INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBorderRadius', '0');
4d9f6058
AE		 1804INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfBaseFontSize', '13px');
1805INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfBaseFontFamily', '"Trebuchet MS", Arial, sans-serif');
a78137a1 1806INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutMinWidth', '980px');
f9fa1d11 1807INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutMaxWidth', '90%');
4d9f6058 1808INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutFixedWidth', '1200px');
baa4743d
AE		 1809INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageBackgroundColor', 'rgba(224, 224, 224, 1)');
1810INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageColor', 'rgba(102, 102, 102, 1)');
1811INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageLinkColor', 'rgba(63, 127, 191, 1)');
1812INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageLinkHoverColor', 'rgba(15, 79, 143, 1)');
cdb161b9 1813INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarBackgroundColor', '@wcfContainerHoverBackgroundColor');
90a67f4f 1814INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDimmedColor', 'rgba(136, 136, 136, 1)');
46944117 1815INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfExtraDimmedColor', 'lighten(@wcfDimmedColor, 20%)');
cdb161b9
MW		 1816INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLabelColor', '@wcfColor');
1817INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeadlineColor', '@wcfColor');
baa4743d 1818INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeadlineFontFamily', '"Trebuchet MS", Arial, sans-serif');
cdb161b9
MW		 1819INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBackgroundColor', '@wcfContentBackgroundColor');
1820INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownColor', '@wcfColor');
1821INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBorderColor', '@wcfContainerBorderColor');
1822INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownHoverBackgroundColor', '@wcfContainerHoverBackgroundColor');
9b363755 1823INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfBaseLineHeight', '1.28');
28283ef7
MW		 1824INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeadlineFontSize', '1.7rem');
1825INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSubHeadlineFontSize', '1.4rem');
1826INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTitleFontSize', '1.2rem');
1827INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSmallFontSize', '.85rem');
90a67f4f
MW		 1828INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfWarningColor', 'rgba(153, 153, 0, 1)');
1829INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfWarningBackgroundColor', 'rgba(255, 255, 221, 1)');
1830INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfWarningBorderColor', 'rgba(204, 204, 0, 1)');
1831INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfErrorColor', 'rgba(204, 0, 0, 1)');
1832INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfErrorBackgroundColor', 'rgba(255, 238, 238, 1)');
1833INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfErrorBorderColor', 'rgba(255, 153, 153, 1)');
1834INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSuccessColor', 'rgba(0, 153, 0, 1)');
1835INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSuccessBackgroundColor', 'rgba(238, 255, 238, 1)');
1836INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSuccessBorderColor', 'rgba(0, 204, 0, 1)');
1837INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInfoColor', 'rgba(102, 136, 187, 1)');
1838INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInfoBackgroundColor', 'rgba(221, 238, 255, 1)');
1839INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInfoBorderColor', 'rgba(153, 187, 238, 1)');
4d9f6058 1840INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTooltipBackgroundColor', 'rgba(0, 0, 0, .8)');
baa4743d 1841INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTooltipColor', 'rgba(255, 255, 255, 1)');
79e7fbed 1842INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHighlightBackgroundColor', 'rgba(255, 255, 102, 1)');
4d9f6058
AE		 1843INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapTiny', '4px');
1844INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapSmall', '7px');
1845INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapMedium', '14px');
1846INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapLarge', '21px');
cdb161b9
MW		 1847INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationHeaderBackgroundColor', '@wcfContentBackgroundColor');
1848INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationFooterBackgroundColor', '@wcfContainerAccentBackgroundColor');
1849INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuBackgroundColor', '@wcfContainerAccentBackgroundColor');
cdb161b9
MW		 1850INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuColor', '@wcfColor');
1851INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuActiveColor', '@wcfLinkColor');
baa4743d 1852INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelHoverBackgroundColor', 'rgba(60, 60, 60, 1)');
3a16de9d
MW		 1853INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSelectedBackgroundColor', 'rgba(255, 255, 200, 1)');
1854INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSelectedColor', '@wcfColor');
1855INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDeletedBackgroundColor', 'rgba(255, 238, 238, 1)');
1856INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDeletedColor', 'rgba(204, 0, 0, 1)');
1857INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDisabledBackgroundColor', 'rgba(238, 255, 238, 1)');
1858INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDisabledColor', 'rgba(0, 153, 0, 1)');
a78137a1
MW		 1859INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTextShadowLightColor', 'transparent');
1860INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTextShadowDarkColor', 'transparent');
ee013cde 1861INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('useFluidLayout', '1');
160bfe44
AE		 1862INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogo', '');
1863INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('individualLess', '');
1864INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('overrideLess', '');
1e18b5ed 1865INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('messageSidebarOrientation', 'left');
dcc2332d
MW		 1866
1867-- media providers
1868-- Videos
1869 -- Youtube
795b2102 1870 INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('YouTube', 'https?://(?:.+?\\.)?youtu(?:\\.be/|be\\.com/(?:#/)?watch\\?(?:.*?&)?v=)(?P<ID>[a-zA-Z0-9_-]+)(?P<start>(?:#a?t=(?:\\d+|(?:\\d+h(?:\\d+m)?(?:\\d+s)?)|(?:\\d+m(?:\\d+s)?)|(?:\\d+s))$)?)', '<iframe style="max-width:100%;" width="560" height="315" src="https://www.youtube-nocookie.com/embed/{$ID}?wmode=transparent{$start}" allowfullscreen></iframe>');
dcc2332d 1871 -- Vimeo
eab82f4c 1872 INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('Vimeo', 'http://vimeo\\.com/(?P<ID>\\d+)', '<iframe src="http://player.vimeo.com/video/{$ID}" width="400" height="225" webkitAllowFullScreen mozallowfullscreen allowFullScreen></iframe>');
dcc2332d 1873 -- MyVideo
fc9a1748 1874 INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('MyVideo', 'http://(?:www\\.)?myvideo\\.de/watch/(?P<ID>\\d+)', '<object width="611" height="383" type="application/x-shockwave-flash" data="http://www.myvideo.de/movie/{$ID}"><param name="movie" value="http://www.myvideo.de/movie/{$ID}" /><param name="AllowFullscreen" value="true" /><param name="AllowScriptAccess" value="always" /><param name="wmode" value="transparent" /></object>');
dcc2332d 1875 -- Clipfish
eab82f4c 1876 INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('Clipfish', 'http://(?:www\\.)?clipfish\\.de/(?:.*?/)?video/(?P<ID>\\d+)/', '<div style="width:464px; height:404px;"><div style="width:464px; height:384px;"><iframe src="http://www.clipfish.de/embed_video/?vid={$ID}&amp;as=0&amp;col=990000" name="Clipfish Embedded Video" width="464" height="384" align="left" marginheight="0" marginwidth="0" scrolling="no"></iframe></div></div>');
dcc2332d 1877 -- Veoh
fc9a1748 1878 INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('Veoh', 'http://(?:www\\.)?veoh\\.com/watch/v(?P<ID>\\d+[a-zA-Z0-9]+)', '<object width="410" height="341" id="veohFlashPlayer" name="veohFlashPlayer" type="application/x-shockwave-flash" data="http://www.veoh.com/swf/webplayer/WebPlayer.swf?version=AFrontend.5.7.0.1308&amp;permalinkId=v{$ID}&amp;player=videodetailsembedded&amp;videoAutoPlay=0&amp;id=anonymous"><param name="movie" value="http://www.veoh.com/swf/webplayer/WebPlayer.swf?version=AFrontend.5.7.0.1308&amp;permalinkId=v{$ID}&amp;player=videodetailsembedded&amp;videoAutoPlay=0&amp;id=anonymous" /><param name="allowFullScreen" value="true" /><param name="allowscriptaccess" value="always" /><param name="wmode" value="transparent" /></object>');
dcc2332d 1879 -- DailyMotion
eab82f4c 1880 INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('DailyMotion', 'https?://(?:www\\.)?dailymotion\\.com/video/(?P<ID>[a-zA-Z0-9]+)', '<iframe width="480" height="208" src="http://www.dailymotion.com/embed/video/{$ID}"></iframe>');
dcc2332d
MW		 1881-- Misc
1882 -- github gist
eab82f4c 1883 INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('github gist', 'https://gist.github.com/(?P<ID>[^/]+/[0-9a-zA-Z]+)', '<script src="https://gist.github.com/{$ID}.js"> </script>');
dcc2332d 1884 -- soundcloud
c0587328
MW		 1885 INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('Soundcloud', 'https?://soundcloud.com/(?P<artist>[a-zA-Z0-9_-]+)/(?!sets/)(?P<song>[a-zA-Z0-9_-]+)', '<iframe width="100%" height="166" scrolling="no" src="https://w.soundcloud.com/player/?url=http%3A%2F%2Fsoundcloud.com%2F{$artist}%2F{$song}"></iframe>');
1886 -- soundcloud set
1887 INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('Soundcloud set', 'https?://soundcloud.com/(?P<artist>[a-zA-Z0-9_-]+)/sets/(?P<name>[a-zA-Z0-9_-]+)', '<iframe width="100%" height="450" scrolling="no" src="https://w.soundcloud.com/player/?url=http%3A%2F%2Fsoundcloud.com%2F{$artist}%2Fsets%2F{$name}"></iframe>');
1888
320f4a6d
MW		 1889-- default priorities
1890UPDATE wcf1_user_group SET priority = 10 WHERE groupID = 3;
1891UPDATE wcf1_user_group SET priority = 1000 WHERE groupID = 4;
c3ab3fe0 1892UPDATE wcf1_user_group SET priority = 100 WHERE groupID = 5;
320f4a6d
MW		 1893
1894-- default 'showOnTeamPage' setting
c3ab3fe0 1895UPDATE wcf1_user_group SET showOnTeamPage = 1 WHERE groupID IN (4, 5);
320f4a6d
MW		 1896
1897-- default ranks
1898INSERT INTO wcf1_user_rank (groupID, requiredPoints, rankTitle, cssClassName) VALUES
1899 (4, 0, 'wcf.user.rank.administrator', 'blue'),
1900 (5, 0, 'wcf.user.rank.moderator', 'blue'),
320f4a6d
MW		 1901 (3, 0, 'wcf.user.rank.user0', ''),
1902 (3, 300, 'wcf.user.rank.user1', ''),
1903 (3, 900, 'wcf.user.rank.user2', ''),
1904 (3, 3000, 'wcf.user.rank.user3', ''),
1905 (3, 9000, 'wcf.user.rank.user4', ''),
861451f4 1906 (3, 15000, 'wcf.user.rank.user5', '');
WoltLab Suite Core (previously WoltLab Community Framework)