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