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