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