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