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