projects / GitHub / WoltLab / WCF.git / blame
? search:
summary | shortlog | log | commit | commitdiff | tree
blob | blame (incremental) | history | HEAD
Fixed typo
[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,
a2bdc5f8
AE		 7 optionName VARCHAR(191) NOT NULL,
8 categoryName VARCHAR(191) NOT NULL,
1e895431 9 UNIQUE KEY (packageID, objectTypeID, optionName)
092bdf82
AE		 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,
a2bdc5f8 17 categoryName VARCHAR(191) NOT NULL,
1e895431 18 UNIQUE KEY (packageID, objectTypeID, categoryName)
092bdf82
AE		 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
2441de47
AE		 39DROP TABLE IF EXISTS wcf1_acl_simple_to_user;
40CREATE TABLE wcf1_acl_simple_to_user (
41 objectTypeID INT(10) NOT NULL,
42 objectID INT(10) NOT NULL,
43 userID INT(10) NOT NULL,
44 UNIQUE KEY userKey (objectTypeID, objectID, userID)
45);
46
47DROP TABLE IF EXISTS wcf1_acl_simple_to_group;
48CREATE TABLE wcf1_acl_simple_to_group (
49 objectTypeID INT(10) NOT NULL,
50 objectID INT(10) NOT NULL,
51 groupID INT(10) NOT NULL,
52 UNIQUE KEY groupKey (objectTypeID, objectID, groupID)
53);
54
158bd3ca
TD		 55DROP TABLE IF EXISTS wcf1_acp_menu_item;
56CREATE TABLE wcf1_acp_menu_item (
57 menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
58 packageID INT(10) NOT NULL,
a2bdc5f8
AE		 59 menuItem VARCHAR(191) NOT NULL DEFAULT '',
60 parentMenuItem VARCHAR(191) NOT NULL DEFAULT '',
b6169da5 61 menuItemController VARCHAR(255) NOT NULL DEFAULT '',
158bd3ca
TD		 62 menuItemLink VARCHAR(255) NOT NULL DEFAULT '',
63 showOrder INT(10) NOT NULL DEFAULT 0,
64 permissions TEXT,
65 options TEXT,
1e895431
AE		 66 icon VARCHAR(255) NOT NULL DEFAULT '',
67 UNIQUE KEY menuItem (menuItem, packageID)
158bd3ca
TD		 68);
69
e9311b98
AE		 70DROP TABLE IF EXISTS wcf1_acp_search_provider;
71CREATE TABLE wcf1_acp_search_provider (
72 providerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
73 packageID INT(10) NOT NULL,
a2bdc5f8 74 providerName VARCHAR(191) NOT NULL DEFAULT '',
e9311b98 75 className VARCHAR(255) NOT NULL DEFAULT '',
1e895431
AE		 76 showOrder INT(10) NOT NULL DEFAULT 0,
77 UNIQUE KEY providerName (providerName, packageID)
e9311b98
AE		 78);
79
158bd3ca
TD		 80DROP TABLE IF EXISTS wcf1_acp_session;
81CREATE TABLE wcf1_acp_session (
82 sessionID CHAR(40) NOT NULL PRIMARY KEY,
158bd3ca
TD		 83 userID INT(10),
84 ipAddress VARCHAR(39) NOT NULL DEFAULT '',
85 userAgent VARCHAR(255) NOT NULL DEFAULT '',
86 lastActivityTime INT(10) NOT NULL DEFAULT 0,
87 requestURI VARCHAR(255) NOT NULL DEFAULT '',
36c2ea0f
AE		 88 requestMethod VARCHAR(7) NOT NULL DEFAULT '',
89 sessionVariables MEDIUMTEXT
158bd3ca
TD		 90);
91
158bd3ca
TD		 92DROP TABLE IF EXISTS wcf1_acp_session_access_log;
93CREATE TABLE wcf1_acp_session_access_log (
94 sessionAccessLogID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
95 sessionLogID INT(10) NOT NULL,
158bd3ca
TD		 96 ipAddress VARCHAR(39) NOT NULL DEFAULT '',
97 time INT(10) NOT NULL DEFAULT 0,
98 requestURI VARCHAR(255) NOT NULL DEFAULT '',
98f447b0 99 requestMethod VARCHAR(7) NOT NULL DEFAULT '',
158bd3ca
TD		 100 className VARCHAR(255) NOT NULL DEFAULT '',
101 KEY sessionLogID (sessionLogID)
102);
103
104DROP TABLE IF EXISTS wcf1_acp_session_log;
105CREATE TABLE wcf1_acp_session_log (
106 sessionLogID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
107 sessionID CHAR(40) NOT NULL DEFAULT '',
108 userID INT(10),
109 ipAddress VARCHAR(39) NOT NULL DEFAULT '',
110 hostname VARCHAR(255) NOT NULL DEFAULT '',
111 userAgent VARCHAR(255) NOT NULL DEFAULT '',
112 time INT(10) NOT NULL DEFAULT 0,
113 lastActivityTime INT(10) NOT NULL DEFAULT 0,
114 KEY sessionID (sessionID)
115);
116
e1622bfa
TD		 117DROP TABLE IF EXISTS wcf1_acp_session_virtual;
118CREATE TABLE wcf1_acp_session_virtual (
119 virtualSessionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
120 sessionID CHAR(40) NOT NULL,
121 ipAddress VARCHAR(39) NOT NULL DEFAULT '',
a2bdc5f8 122 userAgent VARCHAR(191) NOT NULL DEFAULT '',
e1622bfa
TD		 123 lastActivityTime INT(10) NOT NULL DEFAULT 0,
124 UNIQUE KEY (sessionID, ipAddress, userAgent)
125);
126
158bd3ca
TD		 127DROP TABLE IF EXISTS wcf1_acp_template;
128CREATE TABLE wcf1_acp_template (
129 templateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
130 packageID INT(10),
a2bdc5f8 131 templateName VARCHAR(191) NOT NULL,
1e895431
AE		 132 application VARCHAR(20) NOT NULL,
133 UNIQUE KEY applicationTemplate (application, templateName)
158bd3ca
TD		 134);
135
e866b80e
MS		 136DROP TABLE IF EXISTS wcf1_ad;
137CREATE TABLE wcf1_ad (
138 adID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
139 objectTypeID INT(10) NOT NULL,
140 adName VARCHAR(255) NOT NULL,
141 ad MEDIUMTEXT,
142 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
143 showOrder INT(10) NOT NULL DEFAULT 0
144);
145
158bd3ca
TD		 146DROP TABLE IF EXISTS wcf1_application;
147CREATE TABLE wcf1_application (
148 packageID INT(10) NOT NULL PRIMARY KEY,
149 domainName VARCHAR(255) NOT NULL,
150 domainPath VARCHAR(255) NOT NULL DEFAULT '/',
668cf125 151 cookieDomain VARCHAR(255) NOT NULL,
124dcf73
AE		 152 isTainted TINYINT(1) NOT NULL DEFAULT 0,
153 landingPageID INT(10) NULL
158bd3ca
TD		 154);
155
a5a4f02d
MW		 156DROP TABLE IF EXISTS wcf1_article;
157CREATE TABLE wcf1_article (
158 articleID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
159 userID INT(10),
160 username VARCHAR(255) NOT NULL DEFAULT '',
161 time INT(10) NOT NULL DEFAULT 0,
162 categoryID INT(10),
163 isMultilingual TINYINT(1) NOT NULL DEFAULT 0,
164 publicationStatus TINYINT(1) NOT NULL DEFAULT 1,
165 publicationDate INT(10) NOT NULL DEFAULT 0,
166 enableComments TINYINT(1) NOT NULL DEFAULT 1,
167 comments SMALLINT(5) NOT NULL DEFAULT 0,
168 views MEDIUMINT(7) NOT NULL DEFAULT 0,
169 cumulativeLikes MEDIUMINT(7) NOT NULL DEFAULT 0,
a5a4f02d
MW		 170
171 KEY (time)
172);
173
174DROP TABLE IF EXISTS wcf1_article_content;
175CREATE TABLE wcf1_article_content (
176 articleContentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
177 articleID INT(10) NOT NULL,
178 languageID INT(10),
179 title VARCHAR(255) NOT NULL,
180 teaser TEXT,
181 content MEDIUMTEXT,
182 imageID INT(10),
79305986 183 teaserImageID INT(10),
ef17c746 184 hasEmbeddedObjects TINYINT(1) NOT NULL DEFAULT 0,
a5a4f02d
MW		 185
186 UNIQUE KEY (articleID, languageID)
187);
188
f0bc263f
MW		 189DROP TABLE IF EXISTS wcf1_attachment;
190CREATE TABLE wcf1_attachment (
191 attachmentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
192 objectTypeID INT(10) NOT NULL,
193 objectID INT(10),
194 userID INT(10),
195 tmpHash VARCHAR(40) NOT NULL DEFAULT '',
196 filename VARCHAR(255) NOT NULL DEFAULT '',
197 filesize INT(10) NOT NULL DEFAULT 0,
198 fileType VARCHAR(255) NOT NULL DEFAULT '',
199 fileHash VARCHAR(40) NOT NULL DEFAULT '',
200
201 isImage TINYINT(1) NOT NULL DEFAULT 0,
202 width SMALLINT(5) NOT NULL DEFAULT 0,
59ab4d0f 203 height SMALLINT(5) NOT NULL DEFAULT 0,
f0bc263f
MW		 204
205 tinyThumbnailType VARCHAR(255) NOT NULL DEFAULT '',
206 tinyThumbnailSize INT(10) NOT NULL DEFAULT 0,
207 tinyThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0,
208 tinyThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0,
209
210 thumbnailType VARCHAR(255) NOT NULL DEFAULT '',
211 thumbnailSize INT(10) NOT NULL DEFAULT 0,
212 thumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0,
213 thumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0,
214
215 downloads INT(10) NOT NULL DEFAULT 0,
216 lastDownloadTime INT(10) NOT NULL DEFAULT 0,
217 uploadTime INT(10) NOT NULL DEFAULT 0,
218 showOrder SMALLINT(5) NOT NULL DEFAULT 0,
219 KEY (objectTypeID, objectID),
220 KEY (objectTypeID, tmpHash),
221 KEY (objectID, uploadTime)
222);
223
db6698ad
TD		 224DROP TABLE IF EXISTS wcf1_background_job;
225CREATE TABLE wcf1_background_job (
226 jobID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
d7861782 227 job MEDIUMBLOB NOT NULL,
db6698ad
TD		 228 status ENUM('ready', 'processing') NOT NULL DEFAULT 'ready',
229 time INT(10) NOT NULL,
230 KEY (status, time)
231);
232
dcc2332d
MW		 233DROP TABLE IF EXISTS wcf1_bbcode;
234CREATE TABLE wcf1_bbcode (
235 bbcodeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
a2bdc5f8 236 bbcodeTag VARCHAR(191) NOT NULL,
dcc2332d
MW		 237 packageID INT(10) NOT NULL,
238 htmlOpen VARCHAR(255) NOT NULL DEFAULT '',
239 htmlClose VARCHAR(255) NOT NULL DEFAULT '',
dcc2332d
MW		 240 className VARCHAR(255) NOT NULL DEFAULT '',
241 wysiwygIcon varchar(255) NOT NULL DEFAULT '',
242 buttonLabel VARCHAR(255) NOT NULL DEFAULT '',
ece28c21 243 isBlockElement TINYINT(1) NOT NULL DEFAULT 0,
dcc2332d 244 isSourceCode TINYINT(1) NOT NULL DEFAULT 0,
dcc2332d 245 showButton TINYINT(1) NOT NULL DEFAULT 0,
1e895431
AE		 246 originIsSystem TINYINT(1) NOT NULL DEFAULT 0,
247 UNIQUE KEY bbcodeTag (bbcodeTag)
dcc2332d
MW		 248);
249
250DROP TABLE IF EXISTS wcf1_bbcode_attribute;
251CREATE TABLE wcf1_bbcode_attribute (
252 attributeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
253 bbcodeID INT(10) NOT NULL,
254 attributeNo TINYINT(3) NOT NULL DEFAULT 0,
255 attributeHtml VARCHAR(255) NOT NULL DEFAULT '',
256 validationPattern VARCHAR(255) NOT NULL DEFAULT '',
257 required TINYINT(1) NOT NULL DEFAULT 0,
258 useText TINYINT(1) NOT NULL DEFAULT 0,
259 UNIQUE KEY attributeNo (bbcodeID, attributeNo)
260);
261
262DROP TABLE IF EXISTS wcf1_bbcode_media_provider;
263CREATE TABLE wcf1_bbcode_media_provider (
264 providerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
265 title VARCHAR(255) NOT NULL,
266 regex TEXT NOT NULL,
cba8f591
MW		 267 html TEXT NOT NULL,
268 className varchar(255) NOT NULL DEFAULT ''
dcc2332d
MW		 269);
270
11fd4618
MW		 271DROP TABLE IF EXISTS wcf1_box;
272CREATE TABLE wcf1_box (
273 boxID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
91317611 274 objectTypeID INT(10),
11fd4618
MW		 275 identifier VARCHAR(255) NOT NULL,
276 name VARCHAR(255) NOT NULL,
277 boxType VARCHAR(255) NOT NULL,
278 position VARCHAR(255) NOT NULL,
279 showOrder INT(10) NOT NULL DEFAULT 0,
280 visibleEverywhere TINYINT(1) NOT NULL DEFAULT 1,
281 isMultilingual TINYINT(1) NOT NULL DEFAULT 0,
282 cssClassName VARCHAR(255) NOT NULL DEFAULT '',
283 showHeader TINYINT(1) NOT NULL DEFAULT 1,
284 originIsSystem TINYINT(1) NOT NULL DEFAULT 0,
285 packageID INT(10) NOT NULL,
91317611 286 menuID INT(10) NULL,
5636588a
MW		 287 linkPageID INT(10),
288 linkPageObjectID INT(10) NOT NULL DEFAULT 0,
91317611
MS		 289 externalURL VARCHAR(255) NOT NULL DEFAULT '',
290 additionalData TEXT
11fd4618
MW		 291);
292
293DROP TABLE IF EXISTS wcf1_box_content;
294CREATE TABLE wcf1_box_content (
2f273839 295 boxContentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
11fd4618
MW		 296 boxID INT(10) NOT NULL,
297 languageID INT(10),
298 title VARCHAR(255) NOT NULL,
299 content MEDIUMTEXT,
56eb7314 300 imageID INT(10),
2f273839 301 hasEmbeddedObjects TINYINT(1) NOT NULL DEFAULT 0,
11fd4618 302
2f273839 303 UNIQUE KEY (boxID, languageID)
11fd4618
MW		 304);
305
53cf1c00
MW		 306DROP TABLE IF EXISTS wcf1_box_to_page;
307CREATE TABLE wcf1_box_to_page (
308 boxID INT(10) NOT NULL,
309 pageID INT(10) NOT NULL,
310 visible TINYINT(1) NOT NULL DEFAULT 1,
311
312 UNIQUE KEY (pageID, boxID),
313 KEY (pageID, visible)
314);
315
96714cab
MS		 316DROP TABLE IF EXISTS wcf1_captcha_question;
317CREATE TABLE wcf1_captcha_question (
318 questionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
319 question VARCHAR(255) NOT NULL,
320 answers MEDIUMTEXT,
321 isDisabled TINYINT(1) NOT NULL DEFAULT 0
322);
323
13d8b49b
MS		 324DROP TABLE IF EXISTS wcf1_category;
325CREATE TABLE wcf1_category (
326 categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
327 objectTypeID INT(10) NOT NULL,
da06d70c 328 parentCategoryID INT(10) NOT NULL DEFAULT 0,
13d8b49b
MS		 329 title VARCHAR(255) NOT NULL,
330 description TEXT,
da06d70c
MW		 331 showOrder INT(10) NOT NULL DEFAULT 0,
332 time INT(10) NOT NULL DEFAULT 0,
13d8b49b 333 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
045f075b 334 additionalData TEXT
13d8b49b
MS		 335);
336
054db725
TD		 337DROP TABLE IF EXISTS wcf1_cli_history;
338CREATE TABLE wcf1_cli_history (
339 historyItem INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
340 userID INT(10) NOT NULL,
341 command VARCHAR(255) NOT NULL,
342 KEY (userID)
343);
344
0d6ea23f
AE		 345DROP TABLE IF EXISTS wcf1_clipboard_action;
346CREATE TABLE wcf1_clipboard_action (
347 actionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
348 packageID INT(10) NOT NULL DEFAULT 0,
349 actionName VARCHAR(50) NOT NULL DEFAULT '',
a2bdc5f8 350 actionClassName VARCHAR(191) NOT NULL DEFAULT '',
1e895431
AE		 351 showOrder INT(10) NOT NULL DEFAULT 0,
352 UNIQUE KEY actionName (packageID, actionName, actionClassName)
0d6ea23f
AE		 353);
354
355DROP TABLE IF EXISTS wcf1_clipboard_item;
356CREATE TABLE wcf1_clipboard_item (
25cf4d11 357 objectTypeID INT(10) NOT NULL DEFAULT 0,
0d6ea23f 358 userID INT(10) NOT NULL DEFAULT 0,
25cf4d11 359 objectID INT(10) NOT NULL DEFAULT 0,
62312370
TD		 360 UNIQUE KEY (objectTypeID, userID, objectID),
361 KEY (userID)
0d6ea23f
AE		 362);
363
364DROP TABLE IF EXISTS wcf1_clipboard_page;
365CREATE TABLE wcf1_clipboard_page (
366 pageClassName VARCHAR(80) NOT NULL DEFAULT '',
367 packageID INT(10) NOT NULL DEFAULT 0,
368 actionID INT(10) NOT NULL DEFAULT 0
369);
370
285b1d92
MW		 371DROP TABLE IF EXISTS wcf1_comment;
372CREATE TABLE wcf1_comment (
373 commentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
374 objectTypeID INT(10) NOT NULL,
375 objectID INT(10) NOT NULL,
376 time INT(10) NOT NULL DEFAULT '0',
377 userID INT(10),
378 username VARCHAR(255) NOT NULL,
379 message TEXT NOT NULL,
380 responses MEDIUMINT(7) NOT NULL DEFAULT '0',
6f874ba8 381 responseIDs VARCHAR(255) NOT NULL DEFAULT '',
c1687129
AE		 382 unfilteredResponses MEDIUMINT(7) NOT NULL DEFAULT '0',
383 unfilteredResponseIDs VARCHAR(255) NOT NULL DEFAULT '',
53e22ab9 384 enableHtml TINYINT(1) NOT NULL DEFAULT 0,
3e84029c 385 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
285b1d92 386
3e84029c 387 KEY (objectTypeID, objectID, isDisabled, time),
e36dbd69 388 KEY lastCommentTime (userID, time)
285b1d92
MW		 389);
390
391DROP TABLE IF EXISTS wcf1_comment_response;
392CREATE TABLE wcf1_comment_response (
393 responseID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
394 commentID INT(10) NOT NULL,
395 time INT(10) NOT NULL DEFAULT '0',
396 userID INT(10),
397 username VARCHAR(255) NOT NULL,
398 message TEXT NOT NULL,
3e84029c 399 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
285b1d92 400
3e84029c 401 KEY (commentID, isDisabled, time),
e36dbd69 402 KEY lastResponseTime (userID, time)
285b1d92
MW		 403);
404
87d3a054
MS		 405DROP TABLE IF EXISTS wcf1_condition;
406CREATE TABLE wcf1_condition (
407 conditionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
408 objectTypeID INT(10) NOT NULL,
409 objectID INT(10) NOT NULL,
410 conditionData MEDIUMTEXT
411);
412
158bd3ca
TD		 413DROP TABLE IF EXISTS wcf1_core_object;
414CREATE TABLE wcf1_core_object (
415 objectID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
416 packageID INT(10) NOT NULL,
a2bdc5f8 417 objectName VARCHAR(191) NOT NULL DEFAULT '',
1e895431 418 UNIQUE KEY object (packageID, objectName)
158bd3ca
TD		 419);
420
421DROP TABLE IF EXISTS wcf1_cronjob;
422CREATE TABLE wcf1_cronjob (
423 cronjobID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
424 className varchar(255) NOT NULL DEFAULT '',
425 packageID INT(10) NOT NULL,
a2bdc5f8 426 cronjobName VARCHAR(191) NOT NULL,
158bd3ca
TD		 427 description varchar(255) NOT NULL DEFAULT '',
428 startMinute varchar(255) NOT NULL DEFAULT '*',
429 startHour varchar(255) NOT NULL DEFAULT '*',
430 startDom varchar(255) NOT NULL DEFAULT '*',
431 startMonth varchar(255) NOT NULL DEFAULT '*',
432 startDow varchar(255) NOT NULL DEFAULT '*',
433 lastExec INT(10) NOT NULL DEFAULT 0,
434 nextExec INT(10) NOT NULL DEFAULT 0,
435 afterNextExec INT(10) NOT NULL DEFAULT 0,
8f08c7d0 436 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
c9117aad
MS		 437 canBeEdited TINYINT(1) NOT NULL DEFAULT 1,
438 canBeDisabled TINYINT(1) NOT NULL DEFAULT 1,
439 state TINYINT(1) NOT NULL DEFAULT 0,
0fb52d6b 440 failCount TINYINT(1) NOT NULL DEFAULT 0,
1e895431
AE		 441 options TEXT,
442
443 UNIQUE KEY cronjobName (cronjobName, packageID)
158bd3ca
TD		 444);
445
446DROP TABLE IF EXISTS wcf1_cronjob_log;
447CREATE TABLE wcf1_cronjob_log (
448 cronjobLogID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
449 cronjobID INT(10) NOT NULL,
450 execTime INT(10) NOT NULL DEFAULT 0,
c9117aad 451 success TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 452 error TEXT
453);
454
81aa6374
TD		 455DROP TABLE IF EXISTS wcf1_edit_history_entry;
456CREATE TABLE wcf1_edit_history_entry (
457 entryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
458 objectTypeID INT(10) NOT NULL,
459 objectID INT(10) NOT NULL,
460 userID INT(10),
461 username VARCHAR(255) NOT NULL DEFAULT '',
ed6a4e42
MS		 462 time INT(10) NOT NULL DEFAULT 0,
463 obsoletedAt INT(10) NOT NULL DEFAULT 0,
f86d7ff7 464 obsoletedByUserID INT(10),
81aa6374
TD		 465 message MEDIUMTEXT,
466 editReason TEXT,
467
f86d7ff7
TD		 468 KEY (objectTypeID, objectID),
469 KEY (obsoletedAt, obsoletedByUserID)
81aa6374
TD		 470);
471
158bd3ca
TD		 472DROP TABLE IF EXISTS wcf1_event_listener;
473CREATE TABLE wcf1_event_listener (
474 listenerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
475 packageID INT(10) NOT NULL,
7e6405f8 476 environment ENUM('user', 'admin') NOT NULL DEFAULT 'user',
a2bdc5f8 477 listenerName VARCHAR(191) NOT NULL,
158bd3ca 478 eventClassName VARCHAR(80) NOT NULL DEFAULT '',
c9ebc679 479 eventName TEXT,
158bd3ca
TD		 480 listenerClassName VARCHAR(200) NOT NULL DEFAULT '',
481 inherit TINYINT(1) NOT NULL DEFAULT 0,
482 niceValue TINYINT(3) NOT NULL DEFAULT 0,
ffdebe9c 483 permissions TEXT,
1e895431
AE		 484 options TEXT,
485
486 UNIQUE KEY listenerName (listenerName, packageID)
158bd3ca
TD		 487);
488
78db8ddf
MW		 489DROP TABLE IF EXISTS wcf1_import_mapping;
490CREATE TABLE wcf1_import_mapping (
8d8368ee 491 importHash CHAR(8) NOT NULL,
78db8ddf 492 objectTypeID INT(10) NOT NULL,
a2bdc5f8 493 oldID VARCHAR(191) NOT NULL,
78db8ddf 494 newID INT(10) NOT NULL,
8d8368ee 495 UNIQUE KEY (importHash, objectTypeID, oldID)
78db8ddf
MW		 496);
497
3b75466f
MW		 498DROP TABLE IF EXISTS wcf1_label;
499CREATE TABLE wcf1_label (
500 labelID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
501 groupID INT(10) NOT NULL,
502 label VARCHAR(80) NOT NULL,
d8475f48
MS		 503 cssClassName VARCHAR(255) NOT NULL DEFAULT '',
504 showOrder INT(10) NOT NULL DEFAULT 0
3b75466f
MW		 505);
506
507DROP TABLE IF EXISTS wcf1_label_group;
508CREATE TABLE wcf1_label_group (
509 groupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
510 groupName VARCHAR(80) NOT NULL,
f3db386c 511 groupDescription VARCHAR(255) NOT NULL DEFAULT '',
e76c454b
AE		 512 forceSelection TINYINT(1) NOT NULL DEFAULT 0,
513 showOrder INT(10) NOT NULL DEFAULT 0
3b75466f
MW		 514);
515
516DROP TABLE IF EXISTS wcf1_label_group_to_object;
517CREATE TABLE wcf1_label_group_to_object (
518 groupID INT(10) NOT NULL,
519 objectTypeID INT(10) NOT NULL,
520 objectID INT(10) NULL
521);
522
523DROP TABLE IF EXISTS wcf1_label_object;
524CREATE TABLE wcf1_label_object (
525 labelID INT(10) NOT NULL,
526 objectTypeID INT(10) NOT NULL,
527 objectID INT(10) NOT NULL,
528
529 KEY (objectTypeID, labelID),
530 KEY (objectTypeID, objectID)
531);
532
158bd3ca
TD		 533DROP TABLE IF EXISTS wcf1_language;
534CREATE TABLE wcf1_language (
535 languageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
536 languageCode VARCHAR(20) NOT NULL DEFAULT '',
a74df36b 537 languageName VARCHAR(255) NOT NULL DEFAULT '',
6675b340 538 countryCode VARCHAR(10) NOT NULL DEFAULT '',
158bd3ca
TD		 539 isDefault TINYINT(1) NOT NULL DEFAULT 0,
540 hasContent TINYINT(1) NOT NULL DEFAULT 0,
408effbc 541 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 542 UNIQUE KEY languageCode (languageCode)
543);
544
545DROP TABLE IF EXISTS wcf1_language_category;
546CREATE TABLE wcf1_language_category (
547 languageCategoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
a2bdc5f8 548 languageCategory VARCHAR(191) NOT NULL DEFAULT '',
1e895431 549 UNIQUE KEY languageCategory (languageCategory)
158bd3ca
TD		 550);
551
552DROP TABLE IF EXISTS wcf1_language_item;
553CREATE TABLE wcf1_language_item (
554 languageItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
555 languageID INT(10) NOT NULL,
a2bdc5f8 556 languageItem VARCHAR(191) NOT NULL DEFAULT '',
158bd3ca
TD		 557 languageItemValue MEDIUMTEXT NOT NULL,
558 languageCustomItemValue MEDIUMTEXT,
559 languageUseCustomValue TINYINT(1) NOT NULL DEFAULT 0,
560 languageItemOriginIsSystem TINYINT(1) NOT NULL DEFAULT 1,
561 languageCategoryID INT(10) NOT NULL,
562 packageID INT(10),
f52faf33
AE		 563 languageItemOldValue MEDIUMTEXT,
564 languageCustomItemDisableTime INT(10),
f1c1fc65 565 UNIQUE KEY languageItem (languageItem, languageID),
158bd3ca
TD		 566 KEY languageItemOriginIsSystem (languageItemOriginIsSystem)
567);
568
00b6f956
MW		 569DROP TABLE IF EXISTS wcf1_like;
570CREATE TABLE wcf1_like (
571 likeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
572 objectID INT(10) NOT NULL DEFAULT 0,
573 objectTypeID INT(10) NOT NULL,
574 objectUserID INT(10),
575 userID INT(10) NOT NULL,
1ba3f564 576 time INT(10) NOT NULL DEFAULT 1,
00b6f956
MW		 577 likeValue TINYINT(1) NOT NULL DEFAULT 1,
578 UNIQUE KEY (objectTypeID, objectID, userID)
579);
580
581DROP TABLE IF EXISTS wcf1_like_object;
582CREATE TABLE wcf1_like_object (
583 likeObjectID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
584 objectTypeID INT(10) NOT NULL,
585 objectID INT(10) NOT NULL DEFAULT 0,
586 objectUserID INT(10),
587 likes MEDIUMINT(7) NOT NULL DEFAULT 0,
588 dislikes MEDIUMINT(7) NOT NULL DEFAULT 0,
589 cumulativeLikes MEDIUMINT(7) NOT NULL DEFAULT 0,
590 cachedUsers TEXT,
591 UNIQUE KEY (objectTypeID, objectID)
592);
593
59ab4d0f
MS		 594DROP TABLE IF EXISTS wcf1_media;
595CREATE TABLE wcf1_media (
596 mediaID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
cf4e950c 597 categoryID INT(10),
59ab4d0f
MS		 598
599 filename VARCHAR(255) NOT NULL DEFAULT '',
600 filesize INT(10) NOT NULL DEFAULT 0,
601 fileType VARCHAR(255) NOT NULL DEFAULT '',
602 fileHash VARCHAR(255) NOT NULL DEFAULT '',
603 uploadTime INT(10) NOT NULL DEFAULT 0,
604 userID INT(10),
605 username VARCHAR(255) NOT NULL,
606 languageID INT(10),
607 isMultilingual TINYINT(1) NOT NULL DEFAULT 0,
608
609 isImage TINYINT(1) NOT NULL DEFAULT 0,
610 width SMALLINT(5) NOT NULL DEFAULT 0,
611 height SMALLINT(5) NOT NULL DEFAULT 0,
612
613 tinyThumbnailType VARCHAR(255) NOT NULL DEFAULT '',
614 tinyThumbnailSize INT(10) NOT NULL DEFAULT 0,
615 tinyThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0,
616 tinyThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0,
617
618 smallThumbnailType VARCHAR(255) NOT NULL DEFAULT '',
619 smallThumbnailSize INT(10) NOT NULL DEFAULT 0,
620 smallThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0,
621 smallThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0,
622
623 mediumThumbnailType VARCHAR(255) NOT NULL DEFAULT '',
624 mediumThumbnailSize INT(10) NOT NULL DEFAULT 0,
625 mediumThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0,
626 mediumThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0,
627
628 largeThumbnailType VARCHAR(255) NOT NULL DEFAULT '',
629 largeThumbnailSize INT(10) NOT NULL DEFAULT 0,
630 largeThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0,
631 largeThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0
632);
633
634DROP TABLE IF EXISTS wcf1_media_content;
635CREATE TABLE wcf1_media_content (
636 mediaID INT(10) NOT NULL,
637 languageID INT(10),
638 title VARCHAR(255) NOT NULL,
639 caption TEXT,
640 altText VARCHAR(255) NOT NULL DEFAULT '',
641 UNIQUE KEY (mediaID, languageID)
642);
643
e7fb3339
MW		 644DROP TABLE IF EXISTS wcf1_menu;
645CREATE TABLE wcf1_menu (
646 menuID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
647 identifier VARCHAR(255) NOT NULL,
648 title VARCHAR(255) NOT NULL,
649 originIsSystem TINYINT(1) NOT NULL DEFAULT 0,
650 packageID INT(10) NOT NULL
651);
652
653DROP TABLE IF EXISTS wcf1_menu_item;
654CREATE TABLE wcf1_menu_item (
655 itemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
656 menuID INT(10) NOT NULL,
657 parentItemID INT(10),
658 identifier VARCHAR(255) NOT NULL,
659 title VARCHAR(255) NOT NULL,
660 pageID INT(10),
86dbae33 661 pageObjectID INT(10) NOT NULL DEFAULT 0,
e7fb3339
MW		 662 externalURL VARCHAR(255) NOT NULL DEFAULT '',
663 showOrder INT(10) NOT NULL DEFAULT 0,
664 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
effc9389
AE		 665 originIsSystem TINYINT(1) NOT NULL DEFAULT 0,
666 packageID INT(10) NOT NULL
e7fb3339
MW		 667);
668
0a2b09a2
MW		 669DROP TABLE IF EXISTS wcf1_message_embedded_object;
670CREATE TABLE wcf1_message_embedded_object (
671 messageObjectTypeID INT(10) NOT NULL,
672 messageID INT(10) NOT NULL,
673 embeddedObjectTypeID INT(10) NOT NULL,
674 embeddedObjectID INT(10) NOT NULL,
675
676 KEY (messageObjectTypeID, messageID)
677);
678
fc69b61d
MW		 679DROP TABLE IF EXISTS wcf1_moderation_queue;
680CREATE TABLE wcf1_moderation_queue (
681 queueID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
682 objectTypeID INT(10) NOT NULL,
683 objectID INT(10) NOT NULL,
684 containerID INT(10) NOT NULL DEFAULT 0,
685 userID INT(10) NULL,
686 time INT(10) NOT NULL DEFAULT 0,
687
688 -- internal
689 assignedUserID INT(10) NULL,
690 status TINYINT(1) NOT NULL DEFAULT 0,
166d2b91 691 comments SMALLINT(5) NOT NULL DEFAULT 0,
fc69b61d
MW		 692 lastChangeTime INT(10) NOT NULL DEFAULT 0,
693
694 -- additional data, e.g. message if reporting content
6123473d
AE		 695 additionalData TEXT,
696
697 KEY objectTypeAndID (objectTypeID, objectID)
fc69b61d
MW		 698);
699
700DROP TABLE IF EXISTS wcf1_moderation_queue_to_user;
701CREATE TABLE wcf1_moderation_queue_to_user (
702 queueID INT(10) NOT NULL,
703 userID INT(10) NOT NULL,
704 isAffected TINYINT(1) NOT NULL DEFAULT 0,
705
706 UNIQUE KEY queue (queueID, userID),
707 KEY affected (queueID, userID, isAffected)
708);
709
3a2de7fd
AE		 710DROP TABLE IF EXISTS wcf1_modification_log;
711CREATE TABLE wcf1_modification_log (
712 logID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
713 objectTypeID INT(10) NOT NULL,
714 objectID INT(10) NOT NULL,
34e6993d 715 parentObjectID INT(10),
3a2de7fd
AE		 716 userID INT(10),
717 username VARCHAR(255) NOT NULL DEFAULT '',
718 time INT(10) NOT NULL DEFAULT 0,
719 action VARCHAR(80) NOT NULL,
bc4f07e7
AE		 720 additionalData MEDIUMTEXT,
721
722 KEY objectTypeAndID (objectTypeID, objectID)
3a2de7fd
AE		 723);
724
20933e61
MS		 725DROP TABLE IF EXISTS wcf1_notice;
726CREATE TABLE wcf1_notice (
727 noticeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
728 noticeName VARCHAR(255) NOT NULL,
729 notice MEDIUMTEXT,
730 noticeUseHtml TINYINT(1) NOT NULL DEFAULT 0,
e70b5175 731 cssClassName VARCHAR(255) NOT NULL DEFAULT 'info',
20933e61
MS		 732 showOrder INT(10) NOT NULL DEFAULT 0,
733 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
734 isDismissible TINYINT(1) NOT NULL DEFAULT 0
735);
736
737DROP TABLE IF EXISTS wcf1_notice_dismissed;
738CREATE TABLE wcf1_notice_dismissed (
739 noticeID INT(10) NOT NULL,
740 userID INT(10) NOT NULL,
741 PRIMARY KEY (noticeID, userID)
742);
743
7fcc7676
MW		 744DROP TABLE IF EXISTS wcf1_object_type;
745CREATE TABLE wcf1_object_type (
746 objectTypeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
747 definitionID INT(10) NOT NULL,
748 packageID INT(10) NOT NULL,
a2bdc5f8 749 objectType VARCHAR(191) NOT NULL,
7fcc7676
MW		 750 className VARCHAR(255) NOT NULL DEFAULT '',
751 additionalData MEDIUMTEXT,
752 UNIQUE KEY objectType (objectType, definitionID, packageID)
753);
754
755DROP TABLE IF EXISTS wcf1_object_type_definition;
756CREATE TABLE wcf1_object_type_definition (
757 definitionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
a2bdc5f8 758 definitionName VARCHAR(191) NOT NULL,
7fcc7676
MW		 759 packageID INT(10) NOT NULL,
760 interfaceName VARCHAR(255) NOT NULL DEFAULT '',
1e895431
AE		 761 categoryName VARCHAR(80) NOT NULL DEFAULT '',
762 UNIQUE KEY definitionName (definitionName)
7fcc7676
MW		 763);
764
158bd3ca
TD		 765DROP TABLE IF EXISTS wcf1_option;
766CREATE TABLE wcf1_option (
767 optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
768 packageID INT(10) NOT NULL,
a2bdc5f8
AE		 769 optionName VARCHAR(191) NOT NULL DEFAULT '',
770 categoryName VARCHAR(191) NOT NULL DEFAULT '',
158bd3ca
TD		 771 optionType VARCHAR(255) NOT NULL DEFAULT '',
772 optionValue MEDIUMTEXT,
773 validationPattern TEXT,
774 selectOptions MEDIUMTEXT,
775 enableOptions MEDIUMTEXT,
776 showOrder INT(10) NOT NULL DEFAULT 0,
777 hidden TINYINT(1) NOT NULL DEFAULT 0,
778 permissions TEXT,
779 options TEXT,
cd6220f2 780 supportI18n TINYINT(1) NOT NULL DEFAULT 0,
6b45d041 781 requireI18n TINYINT(1) NOT NULL DEFAULT 0,
1e895431
AE		 782 additionalData MEDIUMTEXT,
783
784 UNIQUE KEY optionName (optionName)
158bd3ca
TD		 785);
786
787DROP TABLE IF EXISTS wcf1_option_category;
788CREATE TABLE wcf1_option_category (
789 categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
790 packageID INT(10) NOT NULL,
a2bdc5f8
AE		 791 categoryName VARCHAR(191) NOT NULL DEFAULT '',
792 parentCategoryName VARCHAR(191) NOT NULL DEFAULT '',
158bd3ca
TD		 793 showOrder INT(10) NOT NULL DEFAULT 0,
794 permissions TEXT,
1e895431
AE		 795 options TEXT,
796 UNIQUE KEY categoryName (categoryName)
158bd3ca
TD		 797);
798
799DROP TABLE IF EXISTS wcf1_package;
800CREATE TABLE wcf1_package (
801 packageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
746ffe3b 802 package VARCHAR(191) NOT NULL DEFAULT '',
158bd3ca
TD		 803 packageDir VARCHAR(255) NOT NULL DEFAULT '',
804 packageName VARCHAR(255) NOT NULL DEFAULT '',
158bd3ca
TD		 805 packageDescription VARCHAR(255) NOT NULL DEFAULT '',
806 packageVersion VARCHAR(255) NOT NULL DEFAULT '',
807 packageDate INT(10) NOT NULL DEFAULT 0,
808 installDate INT(10) NOT NULL DEFAULT 0,
809 updateDate INT(10) NOT NULL DEFAULT 0,
810 packageURL VARCHAR(255) NOT NULL DEFAULT '',
aac1247e 811 isApplication TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 812 author VARCHAR(255) NOT NULL DEFAULT '',
813 authorURL VARCHAR(255) NOT NULL DEFAULT '',
814 KEY package (package)
815);
816
158bd3ca
TD		 817DROP TABLE IF EXISTS wcf1_package_exclusion;
818CREATE TABLE wcf1_package_exclusion (
819 packageID INT(10) NOT NULL,
a2bdc5f8 820 excludedPackage VARCHAR(191) NOT NULL DEFAULT '',
1e895431
AE		 821 excludedPackageVersion VARCHAR(255) NOT NULL DEFAULT '',
822 UNIQUE KEY packageID (packageID, excludedPackage)
158bd3ca
TD		 823);
824
825DROP TABLE IF EXISTS wcf1_package_installation_file_log;
826CREATE TABLE wcf1_package_installation_file_log (
827 packageID INT(10),
a2bdc5f8 828 filename VARBINARY(765) NOT NULL, -- VARBINARY(765) roughly equals VARCHAR(255)
1e895431
AE		 829 application VARCHAR(20) NOT NULL,
830 UNIQUE KEY applicationFile (application, filename)
158bd3ca
TD		 831);
832
833DROP TABLE IF EXISTS wcf1_package_installation_form;
834CREATE TABLE wcf1_package_installation_form (
835 queueID INT(10) NOT NULL,
836 formName VARCHAR(80) NOT NULL DEFAULT '',
1e895431
AE		 837 document TEXT NOT NULL,
838 UNIQUE KEY formDocument (queueID, formName)
158bd3ca
TD		 839);
840
841DROP TABLE IF EXISTS wcf1_package_installation_node;
842CREATE TABLE wcf1_package_installation_node (
843 queueID INT(10) NOT NULL,
844 processNo INT(10) NOT NULL DEFAULT 0,
845 sequenceNo SMALLINT(4) NOT NULL DEFAULT 0,
846 node CHAR(8) NOT NULL DEFAULT '',
847 parentNode CHAR(8) NOT NULL DEFAULT '',
456008db 848 nodeType ENUM('optionalPackages','package', 'pip') NOT NULL DEFAULT 'package',
158bd3ca
TD		 849 nodeData TEXT NOT NULL,
850 done TINYINT(1) NOT NULL DEFAULT 0
851);
852
853DROP TABLE IF EXISTS wcf1_package_installation_plugin;
854CREATE TABLE wcf1_package_installation_plugin (
a2bdc5f8 855 pluginName VARCHAR(191) NOT NULL PRIMARY KEY,
158bd3ca
TD		 856 packageID INT(10),
857 priority TINYINT(1) NOT NULL DEFAULT 0,
858 className VARCHAR(255) NOT NULL
859);
860
861DROP TABLE IF EXISTS wcf1_package_installation_queue;
862CREATE TABLE wcf1_package_installation_queue (
863 queueID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
864 parentQueueID INT(10) NOT NULL DEFAULT 0,
865 processNo INT(10) NOT NULL DEFAULT 0,
866 userID INT(10) NOT NULL,
867 package VARCHAR(255) NOT NULL DEFAULT '',
868 packageName VARCHAR(255) NOT NULL DEFAULT '',
869 packageID INT(10),
870 archive VARCHAR(255) NOT NULL DEFAULT '',
17221357 871 action ENUM('install', 'update', 'uninstall') NOT NULL DEFAULT 'install',
158bd3ca 872 done TINYINT(1) NOT NULL DEFAULT 0,
b33c97d2 873 isApplication TINYINT(1) NOT NULL DEFAULT 0
158bd3ca
TD		 874);
875
876DROP TABLE IF EXISTS wcf1_package_installation_sql_log;
877CREATE TABLE wcf1_package_installation_sql_log (
878 packageID INT(10),
879 sqlTable VARCHAR(100) NOT NULL DEFAULT '',
880 sqlColumn VARCHAR(100) NOT NULL DEFAULT '',
1e895431
AE		 881 sqlIndex VARCHAR(100) NOT NULL DEFAULT '',
882 UNIQUE KEY packageID (packageID, sqlTable, sqlColumn, sqlIndex)
158bd3ca
TD		 883);
884
1b4f5112
AE		 885/* SQL_PARSER_OFFSET */
886
158bd3ca
TD		 887DROP TABLE IF EXISTS wcf1_package_requirement;
888CREATE TABLE wcf1_package_requirement (
889 packageID INT(10) NOT NULL,
1e895431
AE		 890 requirement INT(10) NOT NULL,
891 UNIQUE KEY packageID (packageID, requirement)
158bd3ca
TD		 892);
893
158bd3ca
TD		 894DROP TABLE IF EXISTS wcf1_package_update;
895CREATE TABLE wcf1_package_update (
896 packageUpdateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
897 packageUpdateServerID INT(10) NOT NULL,
a2bdc5f8 898 package VARCHAR(191) NOT NULL DEFAULT '',
158bd3ca
TD		 899 packageName VARCHAR(255) NOT NULL DEFAULT '',
900 packageDescription VARCHAR(255) NOT NULL DEFAULT '',
901 author VARCHAR(255) NOT NULL DEFAULT '',
902 authorURL VARCHAR(255) NOT NULL DEFAULT '',
1e895431
AE		 903 isApplication TINYINT(1) NOT NULL DEFAULT 0,
904 UNIQUE KEY packageUpdateServerID (packageUpdateServerID, package)
158bd3ca
TD		 905);
906
907DROP TABLE IF EXISTS wcf1_package_update_exclusion;
908CREATE TABLE wcf1_package_update_exclusion (
909 packageUpdateVersionID INT(10) NOT NULL,
a2bdc5f8 910 excludedPackage VARCHAR(191) NOT NULL DEFAULT '',
1e895431
AE		 911 excludedPackageVersion VARCHAR(255) NOT NULL DEFAULT '',
912 UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, excludedPackage)
158bd3ca
TD		 913);
914
915DROP TABLE IF EXISTS wcf1_package_update_fromversion;
916CREATE TABLE wcf1_package_update_fromversion (
917 packageUpdateVersionID INT(10) NOT NULL DEFAULT 0,
1e895431
AE		 918 fromversion VARCHAR(50) NOT NULL DEFAULT '',
919 UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, fromversion)
158bd3ca
TD		 920);
921
411d6f1a
AE		 922DROP TABLE IF EXISTS wcf1_package_update_optional;
923CREATE TABLE wcf1_package_update_optional (
924 packageUpdateVersionID INT(10) NOT NULL DEFAULT 0,
925 package VARCHAR(255) NOT NULL DEFAULT ''
926);
927
158bd3ca
TD		 928DROP TABLE IF EXISTS wcf1_package_update_requirement;
929CREATE TABLE wcf1_package_update_requirement (
930 packageUpdateVersionID INT(10) NOT NULL,
a2bdc5f8 931 package VARCHAR(191) NOT NULL DEFAULT '',
1e895431
AE		 932 minversion VARCHAR(50) NOT NULL DEFAULT '',
933 UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, package)
158bd3ca
TD		 934);
935
936DROP TABLE IF EXISTS wcf1_package_update_server;
937CREATE TABLE wcf1_package_update_server (
938 packageUpdateServerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
939 serverURL VARCHAR(255) NOT NULL DEFAULT '',
940 loginUsername VARCHAR(255) NOT NULL DEFAULT '',
941 loginPassword VARCHAR(255) NOT NULL DEFAULT '',
8f08c7d0 942 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 943 lastUpdateTime INT(10) NOT NULL DEFAULT 0,
944 status ENUM('online', 'offline') NOT NULL DEFAULT 'online',
2c49099b 945 errorMessage TEXT,
b1701dd0
AE		 946 apiVersion ENUM('2.0', '2.1') NOT NULL DEFAULT '2.0',
947 metaData TEXT
158bd3ca
TD		 948);
949
950DROP TABLE IF EXISTS wcf1_package_update_version;
951CREATE TABLE wcf1_package_update_version (
952 packageUpdateVersionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
953 packageUpdateID INT(10) NOT NULL,
954 packageVersion VARCHAR(50) NOT NULL DEFAULT '',
158bd3ca
TD		 955 packageDate INT(10) NOT NULL DEFAULT 0,
956 filename VARCHAR(255) NOT NULL DEFAULT '',
411d6f1a
AE		 957 license VARCHAR(255) NOT NULL DEFAULT '',
958 licenseURL VARCHAR(255) NOT NULL DEFAULT '',
b4f1ea02 959 isAccessible TINYINT(1) NOT NULL DEFAULT 1,
1e895431 960 UNIQUE KEY packageUpdateID (packageUpdateID, packageVersion)
158bd3ca
TD		 961);
962
0bdb3cdf
MW		 963DROP TABLE IF EXISTS wcf1_page;
964CREATE TABLE wcf1_page (
965 pageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
966 parentPageID INT(10),
a0fdb136 967 identifier VARCHAR(255) NOT NULL,
c8b05efe 968 name VARCHAR(255) NOT NULL,
3fd6b125 969 pageType VARCHAR(255) NOT NULL,
0bdb3cdf
MW		 970 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
971 isLandingPage TINYINT(1) NOT NULL DEFAULT 0,
972 isMultilingual TINYINT(1) NOT NULL DEFAULT 0,
973 originIsSystem TINYINT(1) NOT NULL DEFAULT 0,
974 packageID INT(10) NOT NULL,
19dadfda 975 applicationPackageID INT(10),
0bdb3cdf 976 controller VARCHAR(255) NOT NULL DEFAULT '',
72604b0d 977 handler VARCHAR(255) NOT NULL DEFAULT '',
0bdb3cdf 978 controllerCustomURL VARCHAR(255) NOT NULL DEFAULT '',
86dbae33 979 requireObjectID TINYINT(1) NOT NULL DEFAULT 0,
c80a99d3 980 hasFixedParent TINYINT(1) NOT NULL DEFAULT 0,
afba9daf 981 lastUpdateTime INT(10) NOT NULL DEFAULT 0,
15a7795e 982 cssClassName VARCHAR(255) NOT NULL DEFAULT '',
110ca2e7 983 availableDuringOfflineMode TINYINT(1) NOT NULL DEFAULT 0,
92608257 984 allowSpidersToIndex TINYINT(1) NOT NULL DEFAULT 0,
afba9daf
MW		 985 permissions TEXT NULL,
986 options TEXT NULL
0bdb3cdf
MW		 987);
988
989DROP TABLE IF EXISTS wcf1_page_content;
990CREATE TABLE wcf1_page_content (
2f273839 991 pageContentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
0bdb3cdf
MW		 992 pageID INT(10) NOT NULL,
993 languageID INT(10),
994 title VARCHAR(255) NOT NULL,
995 content MEDIUMTEXT,
996 metaDescription TEXT,
997 metaKeywords TEXT,
998 customURL VARCHAR(255) NOT NULL,
2f273839
MW		 999 hasEmbeddedObjects TINYINT(1) NOT NULL DEFAULT 0,
1000
fe851d2a 1001 UNIQUE KEY (pageID, languageID)
0bdb3cdf
MW		 1002);
1003
4d8036f5
MW		 1004DROP TABLE IF EXISTS wcf1_paid_subscription;
1005CREATE TABLE wcf1_paid_subscription (
1006 subscriptionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1007 title VARCHAR(255) NOT NULL DEFAULT '',
1008 description TEXT,
1009 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
1010 showOrder INT(10) NOT NULL DEFAULT 0,
1011 cost DECIMAL(10,2) NOT NULL DEFAULT 0,
1012 currency VARCHAR(3) NOT NULL DEFAULT 'EUR',
1013 subscriptionLength SMALLINT(3) NOT NULL DEFAULT 0,
1014 subscriptionLengthUnit ENUM('', 'D', 'M', 'Y') NOT NULL DEFAULT '',
1015 isRecurring TINYINT(1) NOT NULL DEFAULT 0,
1016 groupIDs TEXT,
1017 excludedSubscriptionIDs TEXT
1018);
1019
1020DROP TABLE IF EXISTS wcf1_paid_subscription_user;
1021CREATE TABLE wcf1_paid_subscription_user (
1022 subscriptionUserID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1023 subscriptionID INT(10) NOT NULL,
1024 userID INT(10) NOT NULL,
1025 startDate INT(10) NOT NULL DEFAULT 0,
1026 endDate INT(10) NOT NULL DEFAULT 0,
1027 isActive TINYINT(1) NOT NULL DEFAULT 1,
1028
1029 UNIQUE KEY (subscriptionID, userID),
1030 KEY (isActive)
1031);
1032
1033DROP TABLE IF EXISTS wcf1_paid_subscription_transaction_log;
1034CREATE TABLE wcf1_paid_subscription_transaction_log (
1035 logID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1036 subscriptionUserID INT(10),
1037 userID INT(10),
1038 subscriptionID INT(10),
1039 paymentMethodObjectTypeID INT(10) NOT NULL,
1040 logTime INT(10) NOT NULL DEFAULT 0,
1041 transactionID VARCHAR(255) NOT NULL DEFAULT '',
1042 transactionDetails MEDIUMTEXT,
1043 logMessage VARCHAR(255) NOT NULL DEFAULT ''
1044);
1045
e25b7b61
MW		 1046DROP TABLE IF EXISTS wcf1_poll;
1047CREATE TABLE wcf1_poll (
1048 pollID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1049 objectTypeID INT(10) NOT NULL,
1050 objectID INT(10) NOT NULL DEFAULT 0,
1051 question VARCHAR(255) DEFAULT '',
1052 time INT(10) NOT NULL DEFAULT 0,
1053 endTime INT(10) NOT NULL DEFAULT 0,
1054 isChangeable TINYINT(1) NOT NULL DEFAULT 0,
1055 isPublic TINYINT(1) NOT NULL DEFAULT 0,
1056 sortByVotes TINYINT(1) NOT NULL DEFAULT 0,
1057 resultsRequireVote TINYINT(1) NOT NULL DEFAULT 0,
1058 maxVotes INT(10) NOT NULL DEFAULT 1,
1059 votes INT(10) NOT NULL DEFAULT 0
1060);
1061
1062DROP TABLE IF EXISTS wcf1_poll_option;
1063CREATE TABLE wcf1_poll_option (
1064 optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1065 pollID INT(10) NOT NULL,
1066 optionValue VARCHAR(255) NOT NULL DEFAULT '',
1067 votes INT(10) NOT NULL DEFAULT 0,
1068 showOrder INT(10) NOT NULL DEFAULT 0
1069);
1070
1071DROP TABLE IF EXISTS wcf1_poll_option_vote;
1072CREATE TABLE wcf1_poll_option_vote (
1073 pollID INT(10) NOT NULL,
1074 optionID INT(10) NOT NULL,
1075 userID INT(10) NOT NULL,
1076
1077 KEY (optionID, userID),
1078 UNIQUE KEY vote (pollID, optionID, userID)
1079);
1080
158bd3ca
TD		 1081DROP TABLE IF EXISTS wcf1_search;
1082CREATE TABLE wcf1_search (
1083 searchID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1084 userID INT(10),
1085 searchData MEDIUMTEXT NOT NULL,
1086 searchTime INT(10) NOT NULL DEFAULT 0,
1087 searchType VARCHAR(255) NOT NULL DEFAULT '',
1088 searchHash CHAR(40) NOT NULL DEFAULT '',
1089 KEY searchHash (searchHash)
1090);
1091
749cca08
MW		 1092DROP TABLE IF EXISTS wcf1_search_keyword;
1093CREATE TABLE wcf1_search_keyword (
1094 keywordID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
a2bdc5f8 1095 keyword VARCHAR(191) NOT NULL,
749cca08
MW		 1096 searches INT(10) NOT NULL DEFAULT 0,
1097 lastSearchTime INT(10) NOT NULL DEFAULT 0,
1e895431 1098 UNIQUE KEY (keyword),
749cca08
MW		 1099 KEY (searches, lastSearchTime)
1100);
1101
158bd3ca
TD		 1102DROP TABLE IF EXISTS wcf1_session;
1103CREATE TABLE wcf1_session (
1104 sessionID CHAR(40) NOT NULL PRIMARY KEY,
158bd3ca
TD		 1105 userID INT(10),
1106 ipAddress VARCHAR(39) NOT NULL DEFAULT '',
a2bdc5f8 1107 userAgent VARCHAR(191) NOT NULL DEFAULT '',
158bd3ca
TD		 1108 lastActivityTime INT(10) NOT NULL DEFAULT 0,
1109 requestURI VARCHAR(255) NOT NULL DEFAULT '',
98f447b0 1110 requestMethod VARCHAR(7) NOT NULL DEFAULT '',
da5a61fb
MW		 1111 pageID INT(10),
1112 pageObjectID INT(10),
1113 parentPageID INT(10),
1114 parentPageObjectID INT(10),
e8d26212 1115 spiderID INT(10),
5c4282aa 1116 sessionVariables MEDIUMTEXT,
46dd7463 1117 KEY packageID (lastActivityTime, spiderID),
da5a61fb
MW		 1118 KEY pageID (pageID, pageObjectID),
1119 KEY parentPageID (parentPageID, parentPageObjectID),
6a0a959c 1120 UNIQUE KEY uniqueUserID (userID)
158bd3ca
TD		 1121);
1122
5a05fde9
AE		 1123DROP TABLE IF EXISTS wcf1_session_virtual;
1124CREATE TABLE wcf1_session_virtual (
d905faf6 1125 virtualSessionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
5a05fde9
AE		 1126 sessionID CHAR(40) NOT NULL,
1127 ipAddress VARCHAR(39) NOT NULL DEFAULT '',
a2bdc5f8 1128 userAgent VARCHAR(191) NOT NULL DEFAULT '',
5a05fde9
AE		 1129 lastActivityTime INT(10) NOT NULL DEFAULT 0,
1130 UNIQUE KEY (sessionID, ipAddress, userAgent)
1131);
1132
dcc2332d
MW		 1133DROP TABLE IF EXISTS wcf1_smiley;
1134CREATE TABLE wcf1_smiley (
1135 smileyID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1136 packageID INT(10) NOT NULL,
1137 categoryID INT(10),
1138 smileyPath VARCHAR(255) NOT NULL DEFAULT '',
d4da0d92 1139 smileyPath2x VARCHAR(255) NOT NULL DEFAULT '',
dcc2332d 1140 smileyTitle VARCHAR(255) NOT NULL DEFAULT '',
a2bdc5f8 1141 smileyCode VARCHAR(191) NOT NULL DEFAULT '',
dcc2332d 1142 aliases TEXT NOT NULL,
1e895431
AE		 1143 showOrder INT(10) NOT NULL DEFAULT 0,
1144 UNIQUE KEY smileyCode (smileyCode)
dcc2332d
MW		 1145);
1146
158bd3ca
TD		 1147DROP TABLE IF EXISTS wcf1_spider;
1148CREATE TABLE wcf1_spider (
1149 spiderID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
a2bdc5f8 1150 spiderIdentifier VARCHAR(191) DEFAULT '',
158bd3ca
TD		 1151 spiderName VARCHAR(255) DEFAULT '',
1152 spiderURL VARCHAR(255) DEFAULT '',
1153 UNIQUE KEY spiderIdentifier (spiderIdentifier)
1154);
1155
891de7a0
MW		 1156DROP TABLE IF EXISTS wcf1_stat_daily;
1157CREATE TABLE wcf1_stat_daily (
e1fe9453 1158 statID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
891de7a0
MW		 1159 objectTypeID INT(10) NOT NULL,
1160 date DATE NOT NULL,
1161 counter INT(10) NOT NULL DEFAULT 0,
1162 total INT(10) NOT NULL DEFAULT 0,
1163
1164 UNIQUE KEY (objectTypeID, date)
1165);
1166
158bd3ca
TD		 1167DROP TABLE IF EXISTS wcf1_style;
1168CREATE TABLE wcf1_style (
1169 styleID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1170 packageID INT(10) NOT NULL,
1171 styleName VARCHAR(255) NOT NULL DEFAULT '',
1172 templateGroupID INT(10) NOT NULL DEFAULT 0,
1173 isDefault TINYINT(1) NOT NULL DEFAULT 0,
8f08c7d0 1174 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
d3478df7 1175 styleDescription VARCHAR(30) NOT NULL DEFAULT '',
158bd3ca
TD		 1176 styleVersion VARCHAR(255) NOT NULL DEFAULT '',
1177 styleDate CHAR(10) NOT NULL DEFAULT '0000-00-00',
1178 image VARCHAR(255) NOT NULL DEFAULT '',
1179 copyright VARCHAR(255) NOT NULL DEFAULT '',
1180 license VARCHAR(255) NOT NULL DEFAULT '',
1181 authorName VARCHAR(255) NOT NULL DEFAULT '',
fa83e8f7 1182 authorURL VARCHAR(255) NOT NULL DEFAULT '',
90b4b964
AE		 1183 imagePath VARCHAR(255) NOT NULL DEFAULT '',
1184 packageName VARCHAR(255) NOT NULL DEFAULT '',
1185 isTainted TINYINT(1) NOT NULL DEFAULT 0
158bd3ca
TD		 1186);
1187
158bd3ca
TD		 1188DROP TABLE IF EXISTS wcf1_style_variable;
1189CREATE TABLE wcf1_style_variable (
4d9f6058
AE		 1190 variableID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1191 variableName VARCHAR(50) NOT NULL,
1e895431
AE		 1192 defaultValue MEDIUMTEXT,
1193 UNIQUE KEY variableName (variableName)
158bd3ca
TD		 1194);
1195
4d9f6058
AE		 1196DROP TABLE IF EXISTS wcf1_style_variable_value;
1197CREATE TABLE wcf1_style_variable_value (
158bd3ca 1198 styleID INT(10) NOT NULL,
4d9f6058 1199 variableID INT(10) NOT NULL,
158bd3ca 1200 variableValue MEDIUMTEXT,
4d9f6058 1201 UNIQUE KEY (styleID, variableID)
158bd3ca
TD		 1202);
1203
04c06e85
MW		 1204DROP TABLE IF EXISTS wcf1_tag;
1205CREATE TABLE wcf1_tag (
1206 tagID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1207 languageID INT(10) NOT NULL DEFAULT 0,
a2bdc5f8 1208 name VARCHAR(191) NOT NULL,
1e895431
AE		 1209 synonymFor INT(10),
1210 UNIQUE KEY (languageID, name)
04c06e85
MW		 1211);
1212
1213DROP TABLE IF EXISTS wcf1_tag_to_object;
1214CREATE TABLE wcf1_tag_to_object (
1215 objectID INT(10) NOT NULL,
1216 tagID INT(10) NOT NULL,
1217 objectTypeID INT(10) NOT NULL,
1218 languageID INT(10) NOT NULL,
1219 UNIQUE KEY (objectTypeID, languageID, objectID, tagID),
1220 KEY (objectTypeID, languageID, tagID),
1221 KEY (tagID, objectTypeID)
1222);
1223
158bd3ca
TD		 1224DROP TABLE IF EXISTS wcf1_template;
1225CREATE TABLE wcf1_template (
1226 templateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1227 packageID INT(10) NOT NULL,
a2bdc5f8 1228 templateName VARCHAR(191) NOT NULL,
567fa8b8 1229 application VARCHAR(20) NOT NULL,
158bd3ca 1230 templateGroupID INT(10),
6570e38e 1231 lastModificationTime INT(10) NOT NULL DEFAULT 0,
1e895431 1232 UNIQUE KEY applicationTemplate (application, templateGroupID, templateName),
158bd3ca
TD		 1233 KEY templateGroupID (packageID, templateGroupID, templateName)
1234);
1235
1236DROP TABLE IF EXISTS wcf1_template_group;
1237CREATE TABLE wcf1_template_group (
1238 templateGroupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
6570e38e 1239 parentTemplateGroupID INT(10),
158bd3ca
TD		 1240 templateGroupName VARCHAR(255) NOT NULL DEFAULT '',
1241 templateGroupFolderName VARCHAR(255) NOT NULL DEFAULT ''
1242);
1243
0a67f96c
MS		 1244DROP TABLE IF EXISTS wcf1_template_listener;
1245CREATE TABLE wcf1_template_listener (
1246 listenerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1247 packageID INT(10) NOT NULL,
1248 name VARCHAR(80) NOT NULL DEFAULT '',
1249 environment ENUM('user','admin') NOT NULL DEFAULT 'user',
1250 templateName VARCHAR(80) NOT NULL DEFAULT '',
1251 eventName VARCHAR(50) NOT NULL DEFAULT '',
1252 templateCode TEXT NOT NULL,
da84cf75 1253 niceValue TINYINT(3) NOT NULL DEFAULT 0,
512b7176
MS		 1254 permissions TEXT,
1255 options TEXT,
1256
0a67f96c
MS		 1257 KEY templateName (environment, templateName)
1258);
1259
320f4a6d
MW		 1260DROP TABLE IF EXISTS wcf1_tracked_visit;
1261CREATE TABLE wcf1_tracked_visit (
1262 objectTypeID INT(10) NOT NULL,
1263 objectID INT(10) NOT NULL,
1264 userID INT(10) NOT NULL,
1265 visitTime INT(10) NOT NULL DEFAULT 0,
1266 UNIQUE KEY (objectTypeID, objectID, userID),
1267 KEY (userID, visitTime)
1268);
1269
1270DROP TABLE IF EXISTS wcf1_tracked_visit_type;
1271CREATE TABLE wcf1_tracked_visit_type (
1272 objectTypeID INT(10) NOT NULL,
1273 userID INT(10) NOT NULL,
1274 visitTime INT(10) NOT NULL DEFAULT 0,
1275 UNIQUE KEY (objectTypeID, userID),
1276 KEY (userID, visitTime)
1277);
1278
158bd3ca
TD		 1279DROP TABLE IF EXISTS wcf1_user;
1280CREATE TABLE wcf1_user (
1281 userID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
692a0b49 1282 username VARCHAR(100) NOT NULL DEFAULT '',
746ffe3b 1283 email VARCHAR(191) NOT NULL DEFAULT '',
4e273b1f 1284 password VARCHAR(100) NOT NULL DEFAULT '',
6a41a21e 1285 accessToken CHAR(40) NOT NULL DEFAULT '',
158bd3ca
TD		 1286 languageID INT(10) NOT NULL DEFAULT 0,
1287 registrationDate INT(10) NOT NULL DEFAULT 0,
1288 styleID INT(10) NOT NULL DEFAULT 0,
b1356a27
MW		 1289 banned TINYINT(1) NOT NULL DEFAULT 0,
1290 banReason MEDIUMTEXT NULL,
f034d0ec 1291 banExpires INT(10) NOT NULL DEFAULT 0,
320f4a6d
MW		 1292 activationCode INT(10) NOT NULL DEFAULT 0,
1293 lastLostPasswordRequestTime INT(10) NOT NULL DEFAULT 0,
5f6542f1 1294 lostPasswordKey CHAR(40) DEFAULT NULL,
320f4a6d
MW		 1295 lastUsernameChange INT(10) NOT NULL DEFAULT 0,
1296 newEmail VARCHAR(255) NOT NULL DEFAULT '',
1297 oldUsername VARCHAR(255) NOT NULL DEFAULT '',
1298 quitStarted INT(10) NOT NULL DEFAULT 0,
1299 reactivationCode INT(10) NOT NULL DEFAULT 0,
1300 registrationIpAddress VARCHAR(39) NOT NULL DEFAULT '',
1301 avatarID INT(10),
1302 disableAvatar TINYINT(1) NOT NULL DEFAULT 0,
1303 disableAvatarReason TEXT,
f034d0ec 1304 disableAvatarExpires INT(10) NOT NULL DEFAULT 0,
320f4a6d 1305 enableGravatar TINYINT(1) NOT NULL DEFAULT 0,
4ae7fdc1 1306 gravatarFileExtension VARCHAR(3) NOT NULL DEFAULT '',
320f4a6d 1307 signature TEXT,
320f4a6d 1308 signatureEnableHtml TINYINT(1) NOT NULL DEFAULT 0,
320f4a6d
MW		 1309 disableSignature TINYINT(1) NOT NULL DEFAULT 0,
1310 disableSignatureReason TEXT,
f034d0ec 1311 disableSignatureExpires INT(10) NOT NULL DEFAULT 0,
320f4a6d
MW		 1312 lastActivityTime INT(10) NOT NULL DEFAULT 0,
1313 profileHits INT(10) NOT NULL DEFAULT 0,
1314 rankID INT(10),
1315 userTitle VARCHAR(255) NOT NULL DEFAULT '',
1316 userOnlineGroupID INT(10),
1317 activityPoints INT(10) NOT NULL DEFAULT 0,
1318 notificationMailToken VARCHAR(20) NOT NULL DEFAULT '',
746ffe3b 1319 authData VARCHAR(191) NOT NULL DEFAULT '',
00b6f956 1320 likesReceived MEDIUMINT(7) NOT NULL DEFAULT 0,
158bd3ca
TD		 1321
1322 KEY username (username),
718bdb12 1323 KEY email (email),
158bd3ca 1324 KEY registrationDate (registrationDate),
320f4a6d
MW		 1325 KEY styleID (styleID),
1326 KEY activationCode (activationCode),
1327 KEY registrationData (registrationIpAddress, registrationDate),
00b6f956 1328 KEY activityPoints (activityPoints),
e80b96ef
SF		 1329 KEY likesReceived (likesReceived),
1330 KEY authData (authData)
320f4a6d
MW		 1331);
1332
1333DROP TABLE IF EXISTS wcf1_user_activity_event;
1334CREATE TABLE wcf1_user_activity_event (
1335 eventID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1336 objectTypeID INT(10) NOT NULL,
1337 objectID INT(10) NOT NULL,
1338 languageID INT(10),
1339 userID INT(10) NOT NULL,
1340 time INT(10) NOT NULL,
1341 additionalData TEXT,
1342
1343 KEY (time),
1344 KEY (userID, time),
1345 KEY (objectTypeID, objectID)
1346);
1347
1348DROP TABLE IF EXISTS wcf1_user_activity_point;
1349CREATE TABLE wcf1_user_activity_point (
1350 userID INT(10) NOT NULL,
1351 objectTypeID INT(10) NOT NULL,
1352 activityPoints INT(10) NOT NULL DEFAULT 0,
a16ee110 1353 items INT(10) NOT NULL DEFAULT 0,
320f4a6d
MW		 1354 PRIMARY KEY (userID, objectTypeID),
1355 KEY (objectTypeID)
1356);
1357
359f3c53
MW		 1358DROP TABLE IF EXISTS wcf1_user_authentication_failure;
1359CREATE TABLE wcf1_user_authentication_failure (
1360 failureID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1361 environment ENUM('user', 'admin') NOT NULL DEFAULT 'user',
1362 userID INT(10),
1363 username VARCHAR(255) NOT NULL DEFAULT '',
1364 time INT(10) NOT NULL DEFAULT 0,
1365 ipAddress VARCHAR(39) NOT NULL DEFAULT '',
1366 userAgent VARCHAR(255) NOT NULL DEFAULT '',
1367 KEY (ipAddress, time),
1368 KEY (time)
1369);
1370
320f4a6d
MW		 1371DROP TABLE IF EXISTS wcf1_user_avatar;
1372CREATE TABLE wcf1_user_avatar (
1373 avatarID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1374 avatarName VARCHAR(255) NOT NULL DEFAULT '',
1375 avatarExtension VARCHAR(7) NOT NULL DEFAULT '',
1376 width SMALLINT(5) NOT NULL DEFAULT 0,
1377 height SMALLINT(5) NOT NULL DEFAULT 0,
1378 userID INT(10),
2772d4eb 1379 fileHash VARCHAR(40) NOT NULL DEFAULT ''
158bd3ca
TD		 1380);
1381
a8e8aa21
AE		 1382DROP TABLE IF EXISTS wcf1_user_collapsible_content;
1383CREATE TABLE wcf1_user_collapsible_content (
1384 objectTypeID INT(10) NOT NULL,
a2bdc5f8 1385 objectID VARCHAR(191) NOT NULL,
a8e8aa21
AE		 1386 userID INT(10) NOT NULL,
1387 UNIQUE KEY (objectTypeID, objectID, userID)
1388);
1389
320f4a6d
MW		 1390DROP TABLE IF EXISTS wcf1_user_follow;
1391CREATE TABLE wcf1_user_follow (
1392 followID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1393 userID INT(10) NOT NULL,
1394 followUserID INT(10) NOT NULL,
1395 time INT(10) NOT NULL DEFAULT 0,
1396 UNIQUE KEY (userID, followUserID)
1397);
1398
158bd3ca
TD		 1399DROP TABLE IF EXISTS wcf1_user_group;
1400CREATE TABLE wcf1_user_group (
1401 groupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1402 groupName VARCHAR(255) NOT NULL DEFAULT '',
005f6926 1403 groupDescription TEXT,
320f4a6d
MW		 1404 groupType TINYINT(1) NOT NULL DEFAULT 4,
1405 priority MEDIUMINT(8) NOT NULL DEFAULT 0,
1406 userOnlineMarking VARCHAR(255) NOT NULL DEFAULT '%s',
1407 showOnTeamPage TINYINT(1) NOT NULL DEFAULT 0
158bd3ca
TD		 1408);
1409
87d3a054
MS		 1410DROP TABLE IF EXISTS wcf1_user_group_assignment;
1411CREATE TABLE wcf1_user_group_assignment (
1412 assignmentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1413 groupID INT(10) NOT NULL,
1414 title VARCHAR(255) NOT NULL,
1415 isDisabled TINYINT(1) NOT NULL DEFAULT 0
1416);
1417
158bd3ca 1418DROP TABLE IF EXISTS wcf1_user_group_option;
01bd2eff 1419CREATE TABLE wcf1_user_group_option (
158bd3ca
TD		 1420 optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1421 packageID INT(10),
a2bdc5f8
AE		 1422 optionName VARCHAR(191) NOT NULL DEFAULT '',
1423 categoryName VARCHAR(191) NOT NULL DEFAULT '',
158bd3ca
TD		 1424 optionType VARCHAR(255) NOT NULL DEFAULT '',
1425 defaultValue MEDIUMTEXT,
158bd3ca
TD		 1426 validationPattern TEXT,
1427 enableOptions MEDIUMTEXT,
1428 showOrder INT(10) NOT NULL DEFAULT 0,
1429 permissions TEXT,
1430 options TEXT,
ae6b590f 1431 usersOnly TINYINT(1) NOT NULL DEFAULT 0,
1e895431
AE		 1432 additionalData MEDIUMTEXT,
1433 UNIQUE KEY optionName (optionName, packageID)
158bd3ca
TD		 1434);
1435
1436DROP TABLE IF EXISTS wcf1_user_group_option_category;
1437CREATE TABLE wcf1_user_group_option_category (
1438 categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1439 packageID INT(10) NOT NULL,
a2bdc5f8
AE		 1440 categoryName VARCHAR(191) NOT NULL DEFAULT '',
1441 parentCategoryName VARCHAR(191) NOT NULL DEFAULT '',
158bd3ca
TD		 1442 showOrder INT(10) NOT NULL DEFAULT 0,
1443 permissions TEXT,
1e895431
AE		 1444 options TEXT,
1445 UNIQUE KEY categoryName (categoryName)
158bd3ca
TD		 1446);
1447
1448DROP TABLE IF EXISTS wcf1_user_group_option_value;
01bd2eff 1449CREATE TABLE wcf1_user_group_option_value (
158bd3ca
TD		 1450 groupID INT(10) NOT NULL,
1451 optionID INT(10) NOT NULL,
1452 optionValue MEDIUMTEXT NOT NULL,
1453 UNIQUE KEY groupID (groupID, optionID)
1454);
1455
320f4a6d
MW		 1456DROP TABLE IF EXISTS wcf1_user_ignore;
1457CREATE TABLE wcf1_user_ignore (
1458 ignoreID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1459 userID INT(10) NOT NULL,
1460 ignoreUserID INT(10) NOT NULL,
1461 time INT(10) NOT NULL DEFAULT 0,
1462 UNIQUE KEY (userID, ignoreUserID)
1463);
1464
1465DROP TABLE IF EXISTS wcf1_user_menu_item;
1466CREATE TABLE wcf1_user_menu_item (
1467 menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1468 packageID INT(10) NOT NULL,
a2bdc5f8
AE		 1469 menuItem VARCHAR(191) NOT NULL DEFAULT '',
1470 parentMenuItem VARCHAR(191) NOT NULL DEFAULT '',
320f4a6d
MW		 1471 menuItemController VARCHAR(255) NOT NULL DEFAULT '',
1472 menuItemLink VARCHAR(255) NOT NULL DEFAULT '',
1473 showOrder INT(10) NOT NULL DEFAULT 0,
1474 permissions TEXT,
1475 options TEXT,
1476 className VARCHAR(255) NOT NULL DEFAULT '',
1e895431
AE		 1477 iconClassName VARCHAR(255) NOT NULL DEFAULT '',
1478 UNIQUE KEY menuItem (menuItem, packageID)
320f4a6d
MW		 1479);
1480
1481-- notifications
1482DROP TABLE IF EXISTS wcf1_user_notification;
1483CREATE TABLE wcf1_user_notification (
1484 notificationID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
ed6a4e42 1485 packageID INT(10) NOT NULL,
320f4a6d
MW		 1486 eventID INT(10) NOT NULL,
1487 objectID INT(10) NOT NULL DEFAULT 0,
ed6a4e42 1488 baseObjectID INT(10) NOT NULL DEFAULT 0,
68206b3f 1489 eventHash VARCHAR(40) NOT NULL DEFAULT '',
4341fcab 1490 authorID INT(10) NULL,
68206b3f 1491 timesTriggered INT(10) NOT NULL DEFAULT 0,
afb18fa2 1492 guestTimesTriggered INT(10) NOT NULL DEFAULT 0,
4341fcab 1493 userID INT(10) NOT NULL,
320f4a6d 1494 time INT(10) NOT NULL DEFAULT 0,
4341fcab 1495 mailNotified TINYINT(1) NOT NULL DEFAULT 0,
078256b5 1496 confirmTime INT(10) NOT NULL DEFAULT 0,
320f4a6d 1497 additionalData TEXT,
078256b5 1498 KEY (userID, eventID, objectID, confirmTime),
6efc4645
TD		 1499 KEY (userID, confirmTime),
1500 KEY (confirmTime)
4341fcab
AE		 1501);
1502
1503-- notification authors (stacking)
1504DROP TABLE IF EXISTS wcf1_user_notification_author;
1505CREATE TABLE wcf1_user_notification_author (
1506 notificationID INT(10) NOT NULL,
afb18fa2 1507 authorID INT(10),
4341fcab 1508 time INT(10) NOT NULL DEFAULT 0,
4341fcab 1509 UNIQUE KEY (notificationID, authorID)
320f4a6d
MW		 1510);
1511
1512-- notification recipients
4341fcab 1513-- DEPRECATED
320f4a6d
MW		 1514DROP TABLE IF EXISTS wcf1_user_notification_to_user;
1515CREATE TABLE wcf1_user_notification_to_user (
1516 notificationID INT(10) NOT NULL,
1517 userID INT(10) NOT NULL,
320f4a6d
MW		 1518 UNIQUE KEY notificationID (notificationID, userID)
1519);
1520
1521-- events that create notifications
1522DROP TABLE IF EXISTS wcf1_user_notification_event;
1523CREATE TABLE wcf1_user_notification_event (
1524 eventID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1525 packageID INT(10) NOT NULL,
a2bdc5f8 1526 eventName VARCHAR(191) NOT NULL DEFAULT '',
320f4a6d
MW		 1527 objectTypeID INT(10) NOT NULL,
1528 className VARCHAR(255) NOT NULL DEFAULT '',
1529 permissions TEXT,
1530 options TEXT,
2d7c568a 1531 preset TINYINT(1) NOT NULL DEFAULT 0,
1e895431
AE		 1532 presetMailNotificationType ENUM('none', 'instant', 'daily') NOT NULL DEFAULT 'none',
1533 UNIQUE KEY eventName (eventName, objectTypeID)
320f4a6d
MW		 1534);
1535
1536-- user configuration for events
1537DROP TABLE IF EXISTS wcf1_user_notification_event_to_user;
1538CREATE TABLE wcf1_user_notification_event_to_user (
1539 userID INT(10) NOT NULL,
1540 eventID INT(10) NOT NULL,
1541 mailNotificationType ENUM('none', 'instant', 'daily') NOT NULL DEFAULT 'none',
1542 UNIQUE KEY (eventID, userID)
1543);
1544
1545DROP TABLE IF EXISTS wcf1_user_object_watch;
1546CREATE TABLE wcf1_user_object_watch (
1547 watchID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1548 objectTypeID INT(10) NOT NULL,
1549 objectID INT(10) NOT NULL,
1550 userID INT(10) NOT NULL,
1551 notification TINYINT(1) NOT NULL DEFAULT 0,
1552
1553 UNIQUE KEY (objectTypeID, userID, objectID),
1554 KEY (objectTypeID, objectID)
1555);
1556
158bd3ca
TD		 1557DROP TABLE IF EXISTS wcf1_user_option;
1558CREATE TABLE wcf1_user_option (
1559 optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1560 packageID INT(10) NOT NULL,
a2bdc5f8
AE		 1561 optionName VARCHAR(191) NOT NULL DEFAULT '',
1562 categoryName VARCHAR(191) NOT NULL DEFAULT '',
158bd3ca
TD		 1563 optionType VARCHAR(255) NOT NULL DEFAULT '',
1564 defaultValue MEDIUMTEXT,
1565 validationPattern TEXT,
1566 selectOptions MEDIUMTEXT,
1567 enableOptions MEDIUMTEXT,
1568 required TINYINT(1) NOT NULL DEFAULT 0,
1569 askDuringRegistration TINYINT(1) NOT NULL DEFAULT 0,
1570 editable TINYINT(1) NOT NULL DEFAULT 0,
1571 visible TINYINT(1) NOT NULL DEFAULT 0,
1572 outputClass VARCHAR(255) NOT NULL DEFAULT '',
1573 searchable TINYINT(1) NOT NULL DEFAULT 0,
1574 showOrder INT(10) NOT NULL DEFAULT 0,
8f08c7d0 1575 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 1576 permissions TEXT,
1577 options TEXT,
1578 additionalData MEDIUMTEXT,
31378fd1 1579 originIsSystem TINYINT(1) NOT NULL DEFAULT 0,
1e895431 1580 UNIQUE KEY optionName (optionName, packageID),
158bd3ca
TD		 1581 KEY categoryName (categoryName)
1582);
1583
1584DROP TABLE IF EXISTS wcf1_user_option_category;
1585CREATE TABLE wcf1_user_option_category (
1586 categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1587 packageID INT(10) NOT NULL,
a2bdc5f8
AE		 1588 categoryName VARCHAR(191) NOT NULL DEFAULT '',
1589 parentCategoryName VARCHAR(191) NOT NULL DEFAULT '',
158bd3ca
TD		 1590 showOrder INT(10) NOT NULL DEFAULT 0,
1591 permissions TEXT,
1e895431
AE		 1592 options TEXT,
1593 UNIQUE KEY categoryName (categoryName)
158bd3ca
TD		 1594);
1595
1596DROP TABLE IF EXISTS wcf1_user_option_value;
1597CREATE TABLE wcf1_user_option_value (
1598 userID INT(10) NOT NULL PRIMARY KEY
1599);
1600
320f4a6d
MW		 1601DROP TABLE IF EXISTS wcf1_user_profile_menu_item;
1602CREATE TABLE wcf1_user_profile_menu_item (
1603 menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1604 packageID INT(10) NOT NULL,
a2bdc5f8 1605 menuItem VARCHAR(191) NOT NULL,
320f4a6d
MW		 1606 showOrder INT(10) NOT NULL DEFAULT 0,
1607 permissions TEXT NULL,
1608 options TEXT NULL,
1e895431
AE		 1609 className VARCHAR(255) NOT NULL,
1610 UNIQUE KEY (packageID, menuItem)
320f4a6d
MW		 1611);
1612
1613DROP TABLE IF EXISTS wcf1_user_profile_visitor;
1614CREATE TABLE wcf1_user_profile_visitor (
1615 visitorID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
85a3822b
MS		 1616 ownerID INT(10) NOT NULL,
1617 userID INT(10) NOT NULL,
320f4a6d
MW		 1618 time INT(10) NOT NULL DEFAULT 0,
1619 UNIQUE KEY (ownerID, userID),
1620 KEY (time)
1621);
1622
1623DROP TABLE IF EXISTS wcf1_user_rank;
1624CREATE TABLE wcf1_user_rank (
1625 rankID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
d2fbb3b5 1626 groupID INT(10) NOT NULL,
320f4a6d
MW		 1627 requiredPoints INT(10) NOT NULL DEFAULT 0,
1628 rankTitle VARCHAR(255) NOT NULL DEFAULT '',
1629 cssClassName VARCHAR(255) NOT NULL DEFAULT '',
1630 rankImage VARCHAR(255) NOT NULL DEFAULT '',
1631 repeatImage TINYINT(3) NOT NULL DEFAULT 1,
1632 requiredGender TINYINT(1) NOT NULL DEFAULT 0
1633);
1634
0a67f96c
MS		 1635DROP TABLE IF EXISTS wcf1_user_storage;
1636CREATE TABLE wcf1_user_storage (
1637 userID INT(10) NOT NULL,
1638 field VARCHAR(80) NOT NULL DEFAULT '',
1e895431 1639 fieldValue MEDIUMTEXT,
16de8cc5
TD		 1640 UNIQUE KEY (userID, field),
1641 KEY (field)
0a67f96c
MS		 1642);
1643
158bd3ca
TD		 1644DROP TABLE IF EXISTS wcf1_user_to_group;
1645CREATE TABLE wcf1_user_to_group (
1646 userID INT(10) NOT NULL,
1647 groupID INT(10) NOT NULL,
1648 UNIQUE KEY userID (userID, groupID)
1649);
1650
1651DROP TABLE IF EXISTS wcf1_user_to_language;
1652CREATE TABLE wcf1_user_to_language (
1653 userID INT(10) NOT NULL,
1654 languageID INT(10) NOT NULL,
1655 UNIQUE KEY userID (userID, languageID)
1656);
1657
2fbf5046
AE		 1658/* SQL_PARSER_OFFSET */
1659
9f959ced 1660/* foreign keys */
092bdf82
AE		 1661ALTER TABLE wcf1_acl_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1662ALTER TABLE wcf1_acl_option ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1663
1664ALTER TABLE wcf1_acl_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1665ALTER TABLE wcf1_acl_option_category ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1666
1667ALTER TABLE wcf1_acl_option_to_user ADD FOREIGN KEY (optionID) REFERENCES wcf1_acl_option (optionID) ON DELETE CASCADE;
1668ALTER TABLE wcf1_acl_option_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1669
1670ALTER TABLE wcf1_acl_option_to_group ADD FOREIGN KEY (optionID) REFERENCES wcf1_acl_option (optionID) ON DELETE CASCADE;
1671ALTER TABLE wcf1_acl_option_to_group ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
1672
2441de47
AE		 1673ALTER TABLE wcf1_acl_simple_to_user ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1674ALTER TABLE wcf1_acl_simple_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1675
1676ALTER TABLE wcf1_acl_simple_to_group ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1677ALTER TABLE wcf1_acl_simple_to_group ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
1678
158bd3ca
TD		 1679ALTER TABLE wcf1_acp_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1680
e9311b98
AE		 1681ALTER TABLE wcf1_acp_search_provider ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1682
158bd3ca 1683ALTER TABLE wcf1_acp_session ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
158bd3ca
TD		 1684
1685ALTER TABLE wcf1_acp_session_access_log ADD FOREIGN KEY (sessionLogID) REFERENCES wcf1_acp_session_log (sessionLogID) ON DELETE CASCADE;
158bd3ca 1686
158bd3ca
TD		 1687ALTER TABLE wcf1_acp_session_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1688
e1622bfa
TD		 1689ALTER TABLE wcf1_acp_session_virtual ADD FOREIGN KEY (sessionID) REFERENCES wcf1_acp_session (sessionID) ON DELETE CASCADE ON UPDATE CASCADE;
1690
158bd3ca
TD		 1691ALTER TABLE wcf1_acp_template ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1692
e866b80e
MS		 1693ALTER TABLE wcf1_ad ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1694
158bd3ca 1695ALTER TABLE wcf1_application ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
124dcf73 1696ALTER TABLE wcf1_application ADD FOREIGN KEY (landingPageID) REFERENCES wcf1_page (pageID) ON DELETE SET NULL;
158bd3ca 1697
a5a4f02d
MW		 1698ALTER TABLE wcf1_article ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1699ALTER TABLE wcf1_article ADD FOREIGN KEY (categoryID) REFERENCES wcf1_category (categoryID) ON DELETE SET NULL;
1700
1701ALTER TABLE wcf1_article_content ADD FOREIGN KEY (articleID) REFERENCES wcf1_article (articleID) ON DELETE CASCADE;
1702ALTER TABLE wcf1_article_content ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE SET NULL;
1703ALTER TABLE wcf1_article_content ADD FOREIGN KEY (imageID) REFERENCES wcf1_media (mediaID) ON DELETE SET NULL;
79305986 1704ALTER TABLE wcf1_article_content ADD FOREIGN KEY (teaserImageID) REFERENCES wcf1_media (mediaID) ON DELETE SET NULL;
a5a4f02d 1705
f0bc263f
MW		 1706ALTER TABLE wcf1_attachment ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1707ALTER TABLE wcf1_attachment ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1708
dcc2332d
MW		 1709ALTER TABLE wcf1_bbcode ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1710
1711ALTER TABLE wcf1_bbcode_attribute ADD FOREIGN KEY (bbcodeID) REFERENCES wcf1_bbcode (bbcodeID) ON DELETE CASCADE;
1712
91317611 1713ALTER TABLE wcf1_box ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
11fd4618 1714ALTER TABLE wcf1_box ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
39abe192 1715ALTER TABLE wcf1_box ADD FOREIGN KEY (menuID) REFERENCES wcf1_menu (menuID) ON DELETE CASCADE;
5636588a 1716ALTER TABLE wcf1_box ADD FOREIGN KEY (linkPageID) REFERENCES wcf1_page (pageID) ON DELETE SET NULL;
11fd4618
MW		 1717
1718ALTER TABLE wcf1_box_content ADD FOREIGN KEY (boxID) REFERENCES wcf1_box (boxID) ON DELETE CASCADE;
56eb7314
MS		 1719ALTER TABLE wcf1_box_content ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
1720ALTER TABLE wcf1_box_content ADD FOREIGN KEY (imageID) REFERENCES wcf1_media (mediaID) ON DELETE SET NULL;
11fd4618 1721
53cf1c00
MW		 1722ALTER TABLE wcf1_box_to_page ADD FOREIGN KEY (boxID) REFERENCES wcf1_box (boxID) ON DELETE CASCADE;
1723ALTER TABLE wcf1_box_to_page ADD FOREIGN KEY (pageID) REFERENCES wcf1_page (pageID) ON DELETE CASCADE;
1724
13d8b49b
MS		 1725ALTER TABLE wcf1_category ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1726
054db725
TD		 1727ALTER TABLE wcf1_cli_history ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1728
0e6741f8
AE		 1729ALTER TABLE wcf1_clipboard_action ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1730
25cf4d11 1731ALTER TABLE wcf1_clipboard_item ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
0e6741f8
AE		 1732
1733ALTER TABLE wcf1_clipboard_page ADD FOREIGN KEY (actionID) REFERENCES wcf1_clipboard_action (actionID) ON DELETE CASCADE;
1734ALTER TABLE wcf1_clipboard_page ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1735
87d3a054
MS		 1736ALTER TABLE wcf1_condition ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1737
158bd3ca
TD		 1738ALTER TABLE wcf1_core_object ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1739
1740ALTER TABLE wcf1_cronjob ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1741
1742ALTER TABLE wcf1_cronjob_log ADD FOREIGN KEY (cronjobID) REFERENCES wcf1_cronjob (cronjobID) ON DELETE CASCADE;
1743
81aa6374
TD		 1744ALTER TABLE wcf1_edit_history_entry ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1745ALTER TABLE wcf1_edit_history_entry ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
f86d7ff7 1746ALTER TABLE wcf1_edit_history_entry ADD FOREIGN KEY (obsoletedByUserID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
81aa6374 1747
158bd3ca
TD		 1748ALTER TABLE wcf1_event_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1749
1750ALTER TABLE wcf1_language_item ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
1751ALTER TABLE wcf1_language_item ADD FOREIGN KEY (languageCategoryID) REFERENCES wcf1_language_category (languageCategoryID) ON DELETE CASCADE;
1752ALTER TABLE wcf1_language_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1753
cf4e950c 1754ALTER TABLE wcf1_media ADD FOREIGN KEY (categoryID) REFERENCES wcf1_category (categoryID) ON DELETE SET NULL;
59ab4d0f
MS		 1755ALTER TABLE wcf1_media ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1756ALTER TABLE wcf1_media ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE SET NULL;
1757
1758ALTER TABLE wcf1_media_content ADD FOREIGN KEY (mediaID) REFERENCES wcf1_media (mediaID) ON DELETE CASCADE;
1759ALTER TABLE wcf1_media_content ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
1760
c5dd767e 1761ALTER TABLE wcf1_menu ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
e7fb3339
MW		 1762
1763ALTER TABLE wcf1_menu_item ADD FOREIGN KEY (menuID) REFERENCES wcf1_menu (menuID) ON DELETE CASCADE;
1764ALTER TABLE wcf1_menu_item ADD FOREIGN KEY (parentItemID) REFERENCES wcf1_menu_item (itemID) ON DELETE SET NULL;
effc9389
AE		 1765ALTER TABLE wcf1_menu_item ADD FOREIGN KEY (pageID) REFERENCES wcf1_page (pageID) ON DELETE CASCADE;
1766ALTER TABLE wcf1_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
e7fb3339 1767
3a2de7fd
AE		 1768ALTER TABLE wcf1_modification_log ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1769ALTER TABLE wcf1_modification_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1770
7fcc7676
MW		 1771ALTER TABLE wcf1_object_type ADD FOREIGN KEY (definitionID) REFERENCES wcf1_object_type_definition (definitionID) ON DELETE CASCADE;
1772ALTER TABLE wcf1_object_type ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1773
1774ALTER TABLE wcf1_object_type_definition ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1775
158bd3ca
TD		 1776ALTER TABLE wcf1_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1777
1778ALTER TABLE wcf1_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1779
158bd3ca
TD		 1780ALTER TABLE wcf1_package_exclusion ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1781
1782ALTER TABLE wcf1_package_installation_file_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1783
1784ALTER TABLE wcf1_package_installation_form ADD FOREIGN KEY (queueID) REFERENCES wcf1_package_installation_queue (queueID) ON DELETE CASCADE;
1785
1786ALTER TABLE wcf1_package_installation_node ADD FOREIGN KEY (queueID) REFERENCES wcf1_package_installation_queue (queueID) ON DELETE CASCADE;
1787
1788ALTER TABLE wcf1_package_installation_plugin ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1789
1790ALTER TABLE wcf1_package_installation_queue ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1791ALTER TABLE wcf1_package_installation_queue ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE SET NULL;
1792
1793ALTER TABLE wcf1_package_installation_sql_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1794
1b4f5112
AE		 1795/* SQL_PARSER_OFFSET */
1796
158bd3ca
TD		 1797ALTER TABLE wcf1_package_requirement ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1798ALTER TABLE wcf1_package_requirement ADD FOREIGN KEY (requirement) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1799
158bd3ca
TD		 1800ALTER TABLE wcf1_package_update ADD FOREIGN KEY (packageUpdateServerID) REFERENCES wcf1_package_update_server (packageUpdateServerID) ON DELETE CASCADE;
1801
1802ALTER TABLE wcf1_package_update_exclusion ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
1803
1804ALTER TABLE wcf1_package_update_fromversion ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
1805
1806ALTER TABLE wcf1_package_update_requirement ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
1807
b4f1ea02 1808ALTER TABLE wcf1_package_update_optional ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
158bd3ca
TD		 1809
1810ALTER TABLE wcf1_package_update_version ADD FOREIGN KEY (packageUpdateID) REFERENCES wcf1_package_update (packageUpdateID) ON DELETE CASCADE;
1811
4d8036f5
MW		 1812ALTER TABLE wcf1_paid_subscription_user ADD FOREIGN KEY (subscriptionID) REFERENCES wcf1_paid_subscription (subscriptionID) ON DELETE CASCADE;
1813ALTER TABLE wcf1_paid_subscription_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1814
1815ALTER TABLE wcf1_paid_subscription_transaction_log ADD FOREIGN KEY (subscriptionUserID) REFERENCES wcf1_paid_subscription_user (subscriptionUserID) ON DELETE SET NULL;
1816ALTER TABLE wcf1_paid_subscription_transaction_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1817ALTER TABLE wcf1_paid_subscription_transaction_log ADD FOREIGN KEY (subscriptionID) REFERENCES wcf1_paid_subscription (subscriptionID) ON DELETE SET NULL;
1818ALTER TABLE wcf1_paid_subscription_transaction_log ADD FOREIGN KEY (paymentMethodObjectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1819
0bdb3cdf
MW		 1820ALTER TABLE wcf1_page ADD FOREIGN KEY (parentPageID) REFERENCES wcf1_page (pageID) ON DELETE SET NULL;
1821ALTER TABLE wcf1_page ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
19dadfda 1822ALTER TABLE wcf1_page ADD FOREIGN KEY (applicationPackageID) REFERENCES wcf1_package (packageID) ON DELETE SET NULL;
0bdb3cdf
MW		 1823
1824ALTER TABLE wcf1_page_content ADD FOREIGN KEY (pageID) REFERENCES wcf1_page (pageID) ON DELETE CASCADE;
1825ALTER TABLE wcf1_page_content ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
1826
158bd3ca
TD		 1827ALTER TABLE wcf1_search ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1828
158bd3ca 1829ALTER TABLE wcf1_session ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
e8d26212 1830ALTER TABLE wcf1_session ADD FOREIGN KEY (spiderID) REFERENCES wcf1_spider (spiderID) ON DELETE CASCADE;
da5a61fb
MW		 1831ALTER TABLE wcf1_session ADD FOREIGN KEY (pageID) REFERENCES wcf1_page (pageID) ON DELETE SET NULL;
1832ALTER TABLE wcf1_session ADD FOREIGN KEY (parentPageID) REFERENCES wcf1_page (pageID) ON DELETE SET NULL;
158bd3ca 1833
281ac362 1834ALTER TABLE wcf1_session_virtual ADD FOREIGN KEY (sessionID) REFERENCES wcf1_session (sessionID) ON DELETE CASCADE ON UPDATE CASCADE;
5a05fde9 1835
dcc2332d
MW		 1836ALTER TABLE wcf1_smiley ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1837ALTER TABLE wcf1_smiley ADD FOREIGN KEY (categoryID) REFERENCES wcf1_category (categoryID) ON DELETE SET NULL;
1838
461a69ea 1839ALTER TABLE wcf1_user_storage ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
158bd3ca
TD		 1840
1841ALTER TABLE wcf1_style ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1842
4d9f6058
AE		 1843ALTER TABLE wcf1_style_variable_value ADD FOREIGN KEY (styleID) REFERENCES wcf1_style (styleID) ON DELETE CASCADE;
1844ALTER TABLE wcf1_style_variable_value ADD FOREIGN KEY (variableID) REFERENCES wcf1_style_variable (variableID) ON DELETE CASCADE;
158bd3ca
TD		 1845
1846ALTER TABLE wcf1_template ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1847ALTER TABLE wcf1_template ADD FOREIGN KEY (templateGroupID) REFERENCES wcf1_template_group (templateGroupID) ON DELETE CASCADE;
1848
6570e38e
MW		 1849ALTER TABLE wcf1_template_group ADD FOREIGN KEY (parentTemplateGroupID) REFERENCES wcf1_template_group (templateGroupID) ON DELETE SET NULL;
1850
158bd3ca
TD		 1851ALTER TABLE wcf1_template_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1852
a8e8aa21
AE		 1853ALTER TABLE wcf1_user_collapsible_content ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1854ALTER TABLE wcf1_user_collapsible_content ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1855
87d3a054
MS		 1856ALTER TABLE wcf1_user_group_assignment ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
1857
158bd3ca
TD		 1858ALTER TABLE wcf1_user_group_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1859
1860ALTER TABLE wcf1_user_group_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1861
1862ALTER TABLE wcf1_user_group_option_value ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
1863ALTER TABLE wcf1_user_group_option_value ADD FOREIGN KEY (optionID) REFERENCES wcf1_user_group_option (optionID) ON DELETE CASCADE;
1864
2fbf5046
AE		 1865/* SQL_PARSER_OFFSET */
1866
158bd3ca
TD		 1867ALTER TABLE wcf1_user_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1868
1869ALTER TABLE wcf1_user_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1870
1871ALTER TABLE wcf1_user_option_value ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1872
1873ALTER TABLE wcf1_user_to_group ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1874ALTER TABLE wcf1_user_to_group ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
1875
1876ALTER TABLE wcf1_user_to_language ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1877ALTER TABLE wcf1_user_to_language ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
1878
78db8ddf
MW		 1879ALTER TABLE wcf1_import_mapping ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1880
320f4a6d
MW		 1881ALTER TABLE wcf1_tracked_visit ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1882ALTER TABLE wcf1_tracked_visit ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1883
1884ALTER TABLE wcf1_tracked_visit_type ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1885ALTER TABLE wcf1_tracked_visit_type ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1886
1887ALTER TABLE wcf1_user ADD FOREIGN KEY (avatarID) REFERENCES wcf1_user_avatar (avatarID) ON DELETE SET NULL;
1888ALTER TABLE wcf1_user ADD FOREIGN KEY (rankID) REFERENCES wcf1_user_rank (rankID) ON DELETE SET NULL;
1889ALTER TABLE wcf1_user ADD FOREIGN KEY (userOnlineGroupID) REFERENCES wcf1_user_group (groupID) ON DELETE SET NULL;
1890
1891ALTER TABLE wcf1_user_avatar ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1892
1893ALTER TABLE wcf1_user_follow ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1894ALTER TABLE wcf1_user_follow ADD FOREIGN KEY (followUserID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1895
1896ALTER TABLE wcf1_user_ignore ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1897ALTER TABLE wcf1_user_ignore ADD FOREIGN KEY (ignoreUserID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1898
1899ALTER TABLE wcf1_user_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1900
320f4a6d
MW		 1901ALTER TABLE wcf1_user_notification ADD FOREIGN KEY (eventID) REFERENCES wcf1_user_notification_event (eventID) ON DELETE CASCADE;
1902ALTER TABLE wcf1_user_notification ADD FOREIGN KEY (authorID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
4341fcab
AE		 1903ALTER TABLE wcf1_user_notification ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1904
1905ALTER TABLE wcf1_user_notification_author ADD FOREIGN KEY (notificationID) REFERENCES wcf1_user_notification (notificationID) ON DELETE CASCADE;
1906ALTER TABLE wcf1_user_notification_author ADD FOREIGN KEY (authorID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
320f4a6d
MW		 1907
1908ALTER TABLE wcf1_user_notification_to_user ADD FOREIGN KEY (notificationID) REFERENCES wcf1_user_notification (notificationID) ON DELETE CASCADE;
1909ALTER TABLE wcf1_user_notification_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1910
1911ALTER TABLE wcf1_user_notification_event ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1912ALTER TABLE wcf1_user_notification_event ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1913
1914ALTER TABLE wcf1_user_notification_event_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1915ALTER TABLE wcf1_user_notification_event_to_user ADD FOREIGN KEY (eventID) REFERENCES wcf1_user_notification_event (eventID) ON DELETE CASCADE;
1916
1917ALTER TABLE wcf1_user_profile_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1918
1b4f5112
AE		 1919/* SQL_PARSER_OFFSET */
1920
d2fbb3b5 1921ALTER TABLE wcf1_user_rank ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
320f4a6d
MW		 1922
1923ALTER TABLE wcf1_user_activity_event ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1924ALTER TABLE wcf1_user_activity_event ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1925ALTER TABLE wcf1_user_activity_event ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE SET NULL;
1926
1927ALTER TABLE wcf1_user_activity_point ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1928ALTER TABLE wcf1_user_activity_point ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1929
359f3c53
MW		 1930ALTER TABLE wcf1_user_authentication_failure ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1931
320f4a6d
MW		 1932ALTER TABLE wcf1_user_profile_visitor ADD FOREIGN KEY (ownerID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1933ALTER TABLE wcf1_user_profile_visitor ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1934
1935ALTER TABLE wcf1_user_object_watch ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1936ALTER TABLE wcf1_user_object_watch ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1937
0a2b09a2
MW		 1938ALTER TABLE wcf1_message_embedded_object ADD FOREIGN KEY (messageObjectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1939ALTER TABLE wcf1_message_embedded_object ADD FOREIGN KEY (embeddedObjectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1940
fc69b61d
MW		 1941ALTER TABLE wcf1_moderation_queue ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1942ALTER TABLE wcf1_moderation_queue ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1943ALTER TABLE wcf1_moderation_queue ADD FOREIGN KEY (assignedUserID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1944
1945ALTER TABLE wcf1_moderation_queue_to_user ADD FOREIGN KEY (queueID) REFERENCES wcf1_moderation_queue (queueID) ON DELETE CASCADE;
1946ALTER TABLE wcf1_moderation_queue_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1947
00b6f956
MW		 1948ALTER TABLE wcf1_like ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1949ALTER TABLE wcf1_like ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1950ALTER TABLE wcf1_like ADD FOREIGN KEY (objectUserID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1951
1952ALTER TABLE wcf1_like_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1953ALTER TABLE wcf1_like_object ADD FOREIGN KEY (objectUserID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1954
285b1d92
MW		 1955ALTER TABLE wcf1_comment ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1956ALTER TABLE wcf1_comment ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1957
1958ALTER TABLE wcf1_comment_response ADD FOREIGN KEY (commentID) REFERENCES wcf1_comment (commentID) ON DELETE CASCADE;
1959ALTER TABLE wcf1_comment_response ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1960
3b75466f
MW		 1961ALTER TABLE wcf1_label ADD FOREIGN KEY (groupID) REFERENCES wcf1_label_group (groupID) ON DELETE CASCADE;
1962
1963ALTER TABLE wcf1_label_group_to_object ADD FOREIGN KEY (groupID) REFERENCES wcf1_label_group (groupID) ON DELETE CASCADE;
1964ALTER TABLE wcf1_label_group_to_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1965
1966ALTER TABLE wcf1_label_object ADD FOREIGN KEY (labelID) REFERENCES wcf1_label (labelID) ON DELETE CASCADE;
1967ALTER TABLE wcf1_label_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1968
04c06e85
MW		 1969ALTER TABLE wcf1_tag ADD FOREIGN KEY (synonymFor) REFERENCES wcf1_tag (tagID) ON DELETE CASCADE;
1970
1971ALTER TABLE wcf1_tag_to_object ADD FOREIGN KEY (tagID) REFERENCES wcf1_tag (tagID) ON DELETE CASCADE;
1972ALTER TABLE wcf1_tag_to_object ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
1973ALTER TABLE wcf1_tag_to_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1974
891de7a0
MW		 1975ALTER TABLE wcf1_stat_daily ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1976
e25b7b61
MW		 1977ALTER TABLE wcf1_poll ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1978
1979ALTER TABLE wcf1_poll_option ADD FOREIGN KEY (pollID) REFERENCES wcf1_poll (pollID) ON DELETE CASCADE;
1980
1981ALTER TABLE wcf1_poll_option_vote ADD FOREIGN KEY (pollID) REFERENCES wcf1_poll (pollID) ON DELETE CASCADE;
1982ALTER TABLE wcf1_poll_option_vote ADD FOREIGN KEY (optionID) REFERENCES wcf1_poll_option (optionID) ON DELETE CASCADE;
1983ALTER TABLE wcf1_poll_option_vote ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1984
20933e61
MS		 1985ALTER TABLE wcf1_notice_dismissed ADD FOREIGN KEY (noticeID) REFERENCES wcf1_notice (noticeID) ON DELETE CASCADE;
1986ALTER TABLE wcf1_notice_dismissed ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1987
2fbf5046
AE		 1988/* SQL_PARSER_OFFSET */
1989
9f959ced 1990/* default inserts */
158bd3ca 1991-- default user groups
3f69fee7
AE		 1992INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (1, 'wcf.acp.group.group1', 1); -- Everyone
1993INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (2, 'wcf.acp.group.group2', 2); -- Guests
1994INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (3, 'wcf.acp.group.group3', 3); -- Registered Users
1995INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (4, 'wcf.acp.group.group4', 4); -- Administrators
1996INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (5, 'wcf.acp.group.group5', 4); -- Moderators
47459aed 1997
158bd3ca 1998-- default user group options
ae6b590f 1999INSERT INTO wcf1_user_group_option (optionID, optionName, categoryName, optionType, defaultValue, showOrder, usersOnly) VALUES (1, 'admin.general.canUseAcp', 'admin.general', 'boolean', '0', 1, 1);
6476e7a1 2000INSERT INTO wcf1_user_group_option (optionID, optionName, categoryName, optionType, defaultValue, showOrder, usersOnly) VALUES (2, 'admin.configuration.package.canInstallPackage', 'admin.configuration.package', 'boolean', '0', 1, 1);
ae6b590f 2001INSERT 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		 2002
2003-- default user group option values
2004INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 1, '0'); -- Everyone
2005INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 2, '0'); -- Everyone
2006INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 3, '0'); -- Everyone
2007INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 1, '1'); -- Administrators
2008INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 2, '1'); -- Administrators
2009INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 3, '1'); -- Administrators
47459aed 2010
158bd3ca 2011-- default update servers
ba9a2bda
AE		 2012INSERT INTO wcf1_package_update_server (serverURL, status, isDisabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://update.woltlab.com/vortex/', 'online', 0, NULL, 0, '', '');
2013INSERT INTO wcf1_package_update_server (serverURL, status, isDisabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://store.woltlab.com/vortex/', 'online', 0, NULL, 0, '', '');
4d9f6058
AE		 2014
2015-- style default values
97ec0367 2016INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('individualScss', '');
3321b9c6 2017INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('messageSidebarOrientation', 'left');
97ec0367 2018INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('overrideScss', '');
ed8c9052 2019INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogo', '');
07937b16 2020INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogoWidth', '281');
4a292263
MW		 2021INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogoHeight', '40');
2022INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogoMobile', '');
ed8c9052
AE		 2023INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('useFluidLayout', '1');
2024INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('useGoogleFont', '1');
5d1c2d79
AE		 2025INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBackground', 'rgba(207, 216, 220, 1)');
2026INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBackgroundActive', 'rgba(120, 144, 156, 1)');
95cc4d01 2027INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonDisabledBackground', 'rgba(223, 223, 223, 1)');
95cc4d01
AE		 2028INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonDisabledText', 'rgba(165, 165, 165, 1)');
2029INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryBackground', 'rgba(33, 150, 243, 1)');
2030INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryBackgroundActive', 'rgba(26, 119, 201, 1)');
95cc4d01 2031INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryText', 'rgba(255, 255, 255, 1)');
ed8c9052 2032INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryTextActive', 'rgba(255, 255, 255, 1)');
95cc4d01 2033INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonText', 'rgba(33, 33, 33, 1)');
5d1c2d79 2034INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonTextActive', 'rgba(255, 255, 255, 1)');
002297c1 2035INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentBackground', 'rgba(250, 250, 250, 1)');
4e359429 2036INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentBorder', 'rgba(65, 121, 173, 1)');
002297c1 2037INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentBorderInner', 'rgba(224, 224, 224, 1)');
962f1164
AE		 2038INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentDimmedLink', 'rgba(52, 73, 94, 1)');
2039INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentDimmedLinkActive', 'rgba(52, 73, 94, 1)');
487db634 2040INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentDimmedText', 'rgba(125, 130, 135, 1)');
962f1164
AE		 2041INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentHeadlineBorder', 'rgba(238, 238, 238, 1)');
2042INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentHeadlineLink', 'rgba(44, 62, 80, 1)');
2043INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentHeadlineLinkActive', 'rgba(44, 62, 80, 1)');
2044INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentHeadlineText', 'rgba(44, 62, 80, 1)');
002297c1
AE		 2045INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentLink', 'rgba(230, 81, 0, 1)');
2046INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentLinkActive', 'rgba(191, 54, 12, 1)');
ed8c9052
AE		 2047INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentText', 'rgba(44, 62, 80, 1)');
2048INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBackground', 'rgba(255, 255, 255, 1)');
c1956b1c 2049INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBackgroundActive', 'rgba(238, 238, 238, 1)');
962f1164 2050INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBorderInner', 'rgba(238, 238, 238, 1)');
c1956b1c
AE		 2051INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownLink', 'rgba(33, 33, 33, 1)');
2052INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownLinkActive', 'rgba(33, 33, 33, 1)');
2053INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownText', 'rgba(33, 33, 33, 1)');
219eb1ae 2054INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontFamilyFallback', '"Segoe UI", "DejaVu Sans", "Lucida Grande", "Helvetica", sans-serif');
ed8c9052 2055INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontFamilyGoogle', 'Open Sans');
852e099f 2056INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontLineHeight', '1.48');
962f1164 2057INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontSizeDefault', '14px');
ed8c9052 2058INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontSizeHeadline', '18px');
f6fc939a 2059INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontSizeSection', '23px');
ed8c9052 2060INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontSizeSmall', '12px');
487db634 2061INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontSizeTitle', '28px');
4e359429 2062INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBackground', 'rgba(58, 109, 156, 1)');
5d1c2d79 2063INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBoxBackground', 'rgba(236, 239, 241, 1)');
6063a7ec
AE		 2064INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBoxHeadlineLink', 'rgba(44, 62, 80, 1)');
2065INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBoxHeadlineLinkActive', 'rgba(44, 62, 80, 1)');
2066INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBoxHeadlineText', 'rgba(44, 62, 80, 1)');
002297c1
AE		 2067INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBoxLink', 'rgba(230, 81, 0, 1)');
2068INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBoxLinkActive', 'rgba(191, 54, 12, 1)');
6063a7ec 2069INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBoxText', 'rgba(44, 62, 80, 1)');
4e359429 2070INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterCopyrightBackground', 'rgba(50, 92, 132, 1)');
d3925b67 2071INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterCopyrightLink', 'rgba(217, 220, 222, 1)');
6063a7ec 2072INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterCopyrightLinkActive', 'rgba(255, 255, 255, 1)');
4e359429 2073INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterCopyrightText', 'rgba(217, 220, 222, 1)');
f6fc939a
AE		 2074INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterHeadlineLink', 'rgba(255, 255, 255, 1)');
2075INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterHeadlineLinkActive', 'rgba(255, 255, 255, 1)');
2076INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterHeadlineText', 'rgba(189, 195, 199, 1)');
ed8c9052
AE		 2077INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterLink', 'rgba(255, 255, 255, 1)');
2078INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterLinkActive', 'rgba(255, 255, 255, 1)');
4e359429
AE		 2079INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterText', 'rgba(217, 220, 222, 1)');
2080INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderBackground', 'rgba(58, 109, 156, 1)');
55b402a0 2081INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderText', 'rgba(255, 255, 255, 1)');
453b84d5 2082INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderLink', 'rgba(255, 255, 255, 1)');
ed8c9052 2083INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderLinkActive', 'rgba(255, 255, 255, 1)');
4e359429
AE		 2084INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuBackground', 'rgba(50, 92, 132, 1)');
2085INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuLinkBackground', 'rgba(43, 79, 113, 1)');
2086INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuLinkBackgroundActive', 'rgba(36, 66, 95, 1)');
f6fc939a 2087INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuLink', 'rgba(255, 255, 255, 1)');
ed8c9052 2088INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuLinkActive', 'rgba(255, 255, 255, 1)');
4df658a4
AE		 2089INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuDropdownBackground', 'rgba(36, 66, 95, 1)');
2090INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuDropdownBackgroundActive', 'rgba(65, 121, 173, 1)');
a9e43634 2091INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuDropdownLink', 'rgba(255, 255, 255, 1)');
f6fc939a 2092INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuDropdownLinkActive', 'rgba(255, 255, 255, 1)');
4e359429
AE		 2093INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderSearchBoxBackground', 'rgba(50, 92, 132, 1)');
2094INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderSearchBoxBackgroundActive', 'rgba(50, 92, 132, 1)');
70318665
AE		 2095INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderSearchBoxText', 'rgba(255, 255, 255, 1)');
2096INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderSearchBoxTextActive', 'rgba(255, 255, 255, 1)');
6388408b
AE		 2097INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderSearchBoxPlaceholder', 'rgba(207, 207, 207, 1)');
2098INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderSearchBoxPlaceholderActive', 'rgba(207, 207, 207, 1)');
487db634
MW		 2099INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBackground', 'rgba(241, 246, 251, 1)');
2100INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBackgroundActive', 'rgba(241, 246, 251, 1)');
2101INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBorder', 'rgba(176, 200, 224, 1)');
962f1164 2102INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBorderActive', 'rgba(41, 128, 185, 1)');
487db634
MW		 2103INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputDisabledBackground', 'rgba(245, 245, 245, 1)');
2104INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputDisabledBorder', 'rgba(174, 176, 179, 1)');
2105INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputDisabledText', 'rgba(125, 130, 100, 1)');
b4f2a6be 2106INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputLabel', 'rgba(59, 109, 169, 1)');
487db634
MW		 2107INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputText', 'rgba(44, 62, 80, 1)');
2108INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputTextActive', 'rgba(44, 62, 80, 1)');
6e6b849f 2109INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputPlaceholder', 'rgba(169, 169, 169, 1)');
5d0e8b3f 2110INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputPlaceholderActive', 'rgba(204, 204, 204, 1)');
ed8c9052 2111INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutFixedWidth', '1200px');
962f1164 2112INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutMaxWidth', '1400px');
df400238 2113INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutMinWidth', '1000px');
5d1c2d79 2114INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationBackground', 'rgba(236, 239, 241, 1)');
80786168
AE		 2115INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationLink', 'rgba(44, 62, 80, 1)');
2116INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationLinkActive', 'rgba(44, 62, 80, 1)');
962f1164 2117INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationText', 'rgba(170, 170, 170, 1)');
efb111c4 2118INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarBackground', 'rgba(236, 241, 247, 1)');
962f1164
AE		 2119INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarDimmedLink', 'rgba(44, 62, 80, 1)');
2120INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarDimmedLinkActive', 'rgba(44, 62, 80, 1)');
2121INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarDimmedText', 'rgba(127, 140, 141, 1)');
487db634
MW		 2122INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarHeadlineLink', 'rgba(44, 62, 80, 1)');
2123INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarHeadlineLinkActive', 'rgba(44, 62, 80, 1)');
2124INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarHeadlineText', 'rgba(44, 62, 80, 1)');
002297c1
AE		 2125INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarLink', 'rgba(230, 81, 0, 1)');
2126INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarLinkActive', 'rgba(191, 54, 12, 1)');
487db634 2127INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarText', 'rgba(44, 62, 80, 1)');
962f1164
AE		 2128INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusErrorBackground', 'rgba(242, 222, 222, 1)');
2129INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusErrorBorder', 'rgba(235, 204, 204, 1)');
0c163e25
MW		 2130INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusErrorLink', 'rgba(132, 53, 52, 1)');
2131INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusErrorLinkActive', 'rgba(132, 53, 52, 1)');
962f1164
AE		 2132INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusErrorText', 'rgba(169, 68, 66, 1)');
2133INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusInfoBackground', 'rgba(217, 237, 247, 1)');
2134INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusInfoBorder', 'rgba(188, 223, 241, 1)');
0c163e25
MW		 2135INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusInfoLink', 'rgba(36, 82, 105, 1)');
2136INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusInfoLinkActive', 'rgba(36, 82, 105, 1)');
962f1164
AE		 2137INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusInfoText', 'rgba(49, 112, 143, 1)');
2138INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusSuccessBackground', 'rgba(223, 240, 216, 1)');
2139INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusSuccessBorder', 'rgba(208, 233, 198, 1)');
0c163e25
MW		 2140INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusSuccessLink', 'rgba(43, 84, 44, 1)');
2141INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusSuccessLinkActive', 'rgba(43, 84, 44, 1)');
962f1164
AE		 2142INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusSuccessText', 'rgba(60, 118, 61, 1)');
2143INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusWarningBackground', 'rgba(252, 248, 227, 1)');
2144INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusWarningBorder', 'rgba(250, 242, 204, 1)');
0c163e25
MW		 2145INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusWarningLink', 'rgba(102, 81, 44, 1)');
2146INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusWarningLinkActive', 'rgba(102, 81, 44, 1)');
962f1164
AE		 2147INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusWarningText', 'rgba(138, 109, 59, 1)');
2148INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxBackgroundActive', 'rgba(242, 242, 242, 1)');
2149INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxBorderInner', 'rgba(238, 238, 238, 1)');
4e359429 2150INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxHeadline', 'rgba(65, 121, 173, 1)');
002297c1 2151INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxHeadlineActive', 'rgba(230, 81, 0, 1)');
ed8c9052
AE		 2152INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTextShadowDark', 'rgba(0, 0, 0, .8)');
2153INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTextShadowLight', 'rgba(255, 255, 255, .8)');
2154INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTooltipBackground', 'rgba(0, 0, 0, .8)');
2155INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTooltipText', 'rgba(255, 255, 255, 1)');
dcc2332d 2156
76eee28f
TD		 2157-- Email template group
2158INSERT INTO wcf1_template_group (parentTemplateGroupID, templateGroupName, templateGroupFolderName) VALUES (NULL, 'wcf.acp.template.group.email', '_wcf_email/');
2159
dcc2332d
MW		 2160-- media providers
2161-- Videos
2162 -- Youtube
cba8f591 2163 INSERT INTO wcf1_bbcode_media_provider (title, regex, html, className) VALUES ('YouTube', 'https?://(?:.+?\\.)?youtu(?:\\.be/|be\\.com/(?:#/)?watch\\?(?:.*?&)?v=)(?P<ID>[a-zA-Z0-9_-]+)(?:(?:\\?|&)t=(?P<start>[0-9hms]+)$)?', '', 'wcf\\system\\bbcode\\media\\provider\\YouTubeBBCodeMediaProvider');
e258a4fb 2164 -- Youtube playlist
9512054b 2165 INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('YouTube Playlist', 'https?://(?:.+?\\.)?youtu(?:\\.be/|be\\.com/)playlist\\?(?:.*?&)?list=(?P<ID>[a-zA-Z0-9_-]+)', '<div class="videoContainer"><iframe src="https://www.youtube.com/embed/videoseries?list={$ID}" allowfullscreen></iframe></div>');
dcc2332d 2166 -- Vimeo
cba8f591 2167 INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('Vimeo', 'https?://vimeo\\.com/(?:channels/[^/]+/)?(?P<ID>\\d+)\nhttps?://vimeo\\.com/groups/[^/]+/videos/(?P<ID>\\d+)', '<div class="videoContainer"><iframe src="https://player.vimeo.com/video/{$ID}" allowfullscreen></iframe></div>');
dcc2332d 2168 -- Clipfish
eab82f4c 2169 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 2170 -- Veoh
fc9a1748 2171 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 2172 -- DailyMotion
8449a7c7 2173 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="270" src="//www.dailymotion.com/embed/video/{$ID}"></iframe>');
dcc2332d
MW		 2174-- Misc
2175 -- github gist
eab82f4c 2176 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 2177 -- soundcloud
c0587328
MW		 2178 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>');
2179 -- soundcloud set
2180 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>');
2181
320f4a6d
MW		 2182-- default priorities
2183UPDATE wcf1_user_group SET priority = 10 WHERE groupID = 3;
2184UPDATE wcf1_user_group SET priority = 1000 WHERE groupID = 4;
c3ab3fe0 2185UPDATE wcf1_user_group SET priority = 100 WHERE groupID = 5;
320f4a6d
MW		 2186
2187-- default 'showOnTeamPage' setting
c3ab3fe0 2188UPDATE wcf1_user_group SET showOnTeamPage = 1 WHERE groupID IN (4, 5);
320f4a6d
MW		 2189
2190-- default ranks
2191INSERT INTO wcf1_user_rank (groupID, requiredPoints, rankTitle, cssClassName) VALUES
2192 (4, 0, 'wcf.user.rank.administrator', 'blue'),
2193 (5, 0, 'wcf.user.rank.moderator', 'blue'),
320f4a6d
MW		 2194 (3, 0, 'wcf.user.rank.user0', ''),
2195 (3, 300, 'wcf.user.rank.user1', ''),
2196 (3, 900, 'wcf.user.rank.user2', ''),
2197 (3, 3000, 'wcf.user.rank.user3', ''),
2198 (3, 9000, 'wcf.user.rank.user4', ''),
861451f4 2199 (3, 15000, 'wcf.user.rank.user5', '');
WoltLab Suite Core (previously WoltLab Community Framework)