projects / GitHub / WoltLab / WCF.git / blame
? search:
summary | shortlog | log | commit | commitdiff | tree
blob | blame (incremental) | history | HEAD
Remove unused requirement from extra/compiler.js
[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
879d975f 1449DROP TABLE IF EXISTS wcf1_unfurl_url;
1450CREATE TABLE wcf1_unfurl_url (
1451 urlID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1452 url TEXT NOT NULL,
286dbaf8 1453 urlHash VARCHAR(40) NOT NULL,
879d975f 1454 title VARCHAR(255) NOT NULL DEFAULT '',
64e3e6c0 1455 description TEXT,
286dbaf8 1456 imageID INT(10),
d6619724 1457 status VARCHAR(255) NOT NULL DEFAULT 'PENDING',
286dbaf8 1458 lastFetch INT(10) NOT NULL DEFAULT 0,
1459
1460 UNIQUE KEY urlHash (urlHash)
1461);
1462
1463DROP TABLE IF EXISTS wcf1_unfurl_url_image;
1464CREATE TABLE wcf1_unfurl_url_image (
1465 imageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1466 imageUrl TEXT NOT NULL,
e404a3a9 1467 imageUrlHash VARCHAR(40) DEFAULT NULL,
286dbaf8 1468 width INT(10) NOT NULL,
1469 height INT(10) NOT NULL,
1470 imageExtension VARCHAR(4) DEFAULT NULL,
e404a3a9 1471 isStored TINYINT(1) NOT NULL DEFAULT 0,
286dbaf8 1472
e404a3a9 1473 UNIQUE KEY imageUrlHash (imageUrlHash)
879d975f 1474);
1475
158bd3ca
TD		 1476DROP TABLE IF EXISTS wcf1_user;
1477CREATE TABLE wcf1_user (
1478 userID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
692a0b49 1479 username VARCHAR(100) NOT NULL DEFAULT '',
746ffe3b 1480 email VARCHAR(191) NOT NULL DEFAULT '',
622bdbfe 1481 password VARCHAR(255) NOT NULL DEFAULT 'invalid:',
6a41a21e 1482 accessToken CHAR(40) NOT NULL DEFAULT '',
2924e931 1483 multifactorActive TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 1484 languageID INT(10) NOT NULL DEFAULT 0,
1485 registrationDate INT(10) NOT NULL DEFAULT 0,
1486 styleID INT(10) NOT NULL DEFAULT 0,
b1356a27
MW		 1487 banned TINYINT(1) NOT NULL DEFAULT 0,
1488 banReason MEDIUMTEXT NULL,
f034d0ec 1489 banExpires INT(10) NOT NULL DEFAULT 0,
320f4a6d 1490 activationCode INT(10) NOT NULL DEFAULT 0,
783b8dda 1491 emailConfirmed CHAR(40) DEFAULT NULL,
320f4a6d 1492 lastLostPasswordRequestTime INT(10) NOT NULL DEFAULT 0,
5f6542f1 1493 lostPasswordKey CHAR(40) DEFAULT NULL,
320f4a6d
MW		 1494 lastUsernameChange INT(10) NOT NULL DEFAULT 0,
1495 newEmail VARCHAR(255) NOT NULL DEFAULT '',
1496 oldUsername VARCHAR(255) NOT NULL DEFAULT '',
1497 quitStarted INT(10) NOT NULL DEFAULT 0,
1498 reactivationCode INT(10) NOT NULL DEFAULT 0,
1499 registrationIpAddress VARCHAR(39) NOT NULL DEFAULT '',
1500 avatarID INT(10),
1501 disableAvatar TINYINT(1) NOT NULL DEFAULT 0,
1502 disableAvatarReason TEXT,
f034d0ec 1503 disableAvatarExpires INT(10) NOT NULL DEFAULT 0,
320f4a6d 1504 enableGravatar TINYINT(1) NOT NULL DEFAULT 0,
4ae7fdc1 1505 gravatarFileExtension VARCHAR(3) NOT NULL DEFAULT '',
320f4a6d 1506 signature TEXT,
320f4a6d 1507 signatureEnableHtml TINYINT(1) NOT NULL DEFAULT 0,
320f4a6d
MW		 1508 disableSignature TINYINT(1) NOT NULL DEFAULT 0,
1509 disableSignatureReason TEXT,
f034d0ec 1510 disableSignatureExpires INT(10) NOT NULL DEFAULT 0,
320f4a6d
MW		 1511 lastActivityTime INT(10) NOT NULL DEFAULT 0,
1512 profileHits INT(10) NOT NULL DEFAULT 0,
1513 rankID INT(10),
1514 userTitle VARCHAR(255) NOT NULL DEFAULT '',
1515 userOnlineGroupID INT(10),
1516 activityPoints INT(10) NOT NULL DEFAULT 0,
1517 notificationMailToken VARCHAR(20) NOT NULL DEFAULT '',
746ffe3b 1518 authData VARCHAR(191) NOT NULL DEFAULT '',
00b6f956 1519 likesReceived MEDIUMINT(7) NOT NULL DEFAULT 0,
16977ca6 1520 trophyPoints INT(10) NOT NULL DEFAULT 0,
e26331e1
AE		 1521 coverPhotoHash CHAR(40) DEFAULT NULL,
1522 coverPhotoExtension VARCHAR(4) NOT NULL DEFAULT '',
d4cf0997 1523 coverPhotoHasWebP TINYINT(1) NOT NULL DEFAULT 0,
e26331e1 1524 disableCoverPhoto TINYINT(1) NOT NULL DEFAULT 0,
9fdd2995 1525 disableCoverPhotoReason TEXT,
e26331e1 1526 disableCoverPhotoExpires INT(10) NOT NULL DEFAULT 0,
bd1067ab 1527 articles INT(10) NOT NULL DEFAULT 0,
41be0d84 1528 blacklistMatches VARCHAR(255) NOT NULL DEFAULT '',
e8d9d90e 1529
ec8265ed 1530 UNIQUE KEY username (username),
718bdb12 1531 KEY email (email),
158bd3ca 1532 KEY registrationDate (registrationDate),
320f4a6d
MW		 1533 KEY styleID (styleID),
1534 KEY activationCode (activationCode),
1535 KEY registrationData (registrationIpAddress, registrationDate),
00b6f956 1536 KEY activityPoints (activityPoints),
e80b96ef 1537 KEY likesReceived (likesReceived),
16977ca6
JR		 1538 KEY authData (authData),
1539 KEY trophyPoints (trophyPoints)
320f4a6d
MW		 1540);
1541
1542DROP TABLE IF EXISTS wcf1_user_activity_event;
1543CREATE TABLE wcf1_user_activity_event (
1544 eventID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1545 objectTypeID INT(10) NOT NULL,
1546 objectID INT(10) NOT NULL,
1547 languageID INT(10),
1548 userID INT(10) NOT NULL,
1549 time INT(10) NOT NULL,
1550 additionalData TEXT,
e8d9d90e 1551
320f4a6d
MW		 1552 KEY (time),
1553 KEY (userID, time),
1554 KEY (objectTypeID, objectID)
1555);
1556
1557DROP TABLE IF EXISTS wcf1_user_activity_point;
1558CREATE TABLE wcf1_user_activity_point (
1559 userID INT(10) NOT NULL,
1560 objectTypeID INT(10) NOT NULL,
1561 activityPoints INT(10) NOT NULL DEFAULT 0,
a16ee110 1562 items INT(10) NOT NULL DEFAULT 0,
320f4a6d
MW		 1563 PRIMARY KEY (userID, objectTypeID),
1564 KEY (objectTypeID)
1565);
1566
359f3c53
MW		 1567DROP TABLE IF EXISTS wcf1_user_authentication_failure;
1568CREATE TABLE wcf1_user_authentication_failure (
1569 failureID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1570 environment ENUM('user', 'admin') NOT NULL DEFAULT 'user',
1571 userID INT(10),
1572 username VARCHAR(255) NOT NULL DEFAULT '',
1573 time INT(10) NOT NULL DEFAULT 0,
1574 ipAddress VARCHAR(39) NOT NULL DEFAULT '',
1575 userAgent VARCHAR(255) NOT NULL DEFAULT '',
8494a7cb 1576 validationError VARCHAR(255) NOT NULL DEFAULT '',
359f3c53
MW		 1577 KEY (ipAddress, time),
1578 KEY (time)
1579);
1580
320f4a6d
MW		 1581DROP TABLE IF EXISTS wcf1_user_avatar;
1582CREATE TABLE wcf1_user_avatar (
1583 avatarID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1584 avatarName VARCHAR(255) NOT NULL DEFAULT '',
1585 avatarExtension VARCHAR(7) NOT NULL DEFAULT '',
1586 width SMALLINT(5) NOT NULL DEFAULT 0,
1587 height SMALLINT(5) NOT NULL DEFAULT 0,
1588 userID INT(10),
71a3289c
AE		 1589 fileHash VARCHAR(40) NOT NULL DEFAULT '',
1590 hasWebP TINYINT(1) NOT NULL DEFAULT 0
158bd3ca
TD		 1591);
1592
a8e8aa21
AE		 1593DROP TABLE IF EXISTS wcf1_user_collapsible_content;
1594CREATE TABLE wcf1_user_collapsible_content (
1595 objectTypeID INT(10) NOT NULL,
a2bdc5f8 1596 objectID VARCHAR(191) NOT NULL,
a8e8aa21
AE		 1597 userID INT(10) NOT NULL,
1598 UNIQUE KEY (objectTypeID, objectID, userID)
1599);
1600
320f4a6d
MW		 1601DROP TABLE IF EXISTS wcf1_user_follow;
1602CREATE TABLE wcf1_user_follow (
1603 followID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1604 userID INT(10) NOT NULL,
1605 followUserID INT(10) NOT NULL,
1606 time INT(10) NOT NULL DEFAULT 0,
1607 UNIQUE KEY (userID, followUserID)
1608);
1609
158bd3ca
TD		 1610DROP TABLE IF EXISTS wcf1_user_group;
1611CREATE TABLE wcf1_user_group (
1612 groupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1613 groupName VARCHAR(255) NOT NULL DEFAULT '',
005f6926 1614 groupDescription TEXT,
320f4a6d
MW		 1615 groupType TINYINT(1) NOT NULL DEFAULT 4,
1616 priority MEDIUMINT(8) NOT NULL DEFAULT 0,
1617 userOnlineMarking VARCHAR(255) NOT NULL DEFAULT '%s',
36c198f8 1618 showOnTeamPage TINYINT(1) NOT NULL DEFAULT 0,
96fde138
TD		 1619 allowMention TINYINT(1) NOT NULL DEFAULT 0,
1620 requireMultifactor TINYINT(1) NOT NULL DEFAULT 0
158bd3ca
TD		 1621);
1622
87d3a054
MS		 1623DROP TABLE IF EXISTS wcf1_user_group_assignment;
1624CREATE TABLE wcf1_user_group_assignment (
1625 assignmentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1626 groupID INT(10) NOT NULL,
1627 title VARCHAR(255) NOT NULL,
1628 isDisabled TINYINT(1) NOT NULL DEFAULT 0
1629);
1630
158bd3ca 1631DROP TABLE IF EXISTS wcf1_user_group_option;
01bd2eff 1632CREATE TABLE wcf1_user_group_option (
158bd3ca
TD		 1633 optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1634 packageID INT(10),
a2bdc5f8
AE		 1635 optionName VARCHAR(191) NOT NULL DEFAULT '',
1636 categoryName VARCHAR(191) NOT NULL DEFAULT '',
158bd3ca
TD		 1637 optionType VARCHAR(255) NOT NULL DEFAULT '',
1638 defaultValue MEDIUMTEXT,
158bd3ca
TD		 1639 validationPattern TEXT,
1640 enableOptions MEDIUMTEXT,
1641 showOrder INT(10) NOT NULL DEFAULT 0,
1642 permissions TEXT,
1643 options TEXT,
ae6b590f 1644 usersOnly TINYINT(1) NOT NULL DEFAULT 0,
1e895431
AE		 1645 additionalData MEDIUMTEXT,
1646 UNIQUE KEY optionName (optionName, packageID)
158bd3ca
TD		 1647);
1648
1649DROP TABLE IF EXISTS wcf1_user_group_option_category;
1650CREATE TABLE wcf1_user_group_option_category (
1651 categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1652 packageID INT(10) NOT NULL,
a2bdc5f8
AE		 1653 categoryName VARCHAR(191) NOT NULL DEFAULT '',
1654 parentCategoryName VARCHAR(191) NOT NULL DEFAULT '',
158bd3ca
TD		 1655 showOrder INT(10) NOT NULL DEFAULT 0,
1656 permissions TEXT,
1e895431
AE		 1657 options TEXT,
1658 UNIQUE KEY categoryName (categoryName)
158bd3ca
TD		 1659);
1660
1661DROP TABLE IF EXISTS wcf1_user_group_option_value;
01bd2eff 1662CREATE TABLE wcf1_user_group_option_value (
158bd3ca
TD		 1663 groupID INT(10) NOT NULL,
1664 optionID INT(10) NOT NULL,
1665 optionValue MEDIUMTEXT NOT NULL,
1666 UNIQUE KEY groupID (groupID, optionID)
1667);
1668
320f4a6d
MW		 1669DROP TABLE IF EXISTS wcf1_user_ignore;
1670CREATE TABLE wcf1_user_ignore (
1671 ignoreID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1672 userID INT(10) NOT NULL,
1673 ignoreUserID INT(10) NOT NULL,
1674 time INT(10) NOT NULL DEFAULT 0,
10bc76ec 1675 type TINYINT(1) NOT NULL DEFAULT 1,
320f4a6d
MW		 1676 UNIQUE KEY (userID, ignoreUserID)
1677);
1678
a83d788a
JR		 1679DROP TABLE IF EXISTS wcf1_user_special_trophy;
1680CREATE TABLE wcf1_user_special_trophy(
1681 trophyID INT(10) NOT NULL,
1682 userID INT(10) NOT NULL,
1683 UNIQUE KEY (trophyID, userID)
1684);
1685
16977ca6
JR		 1686DROP TABLE IF EXISTS wcf1_user_trophy;
1687CREATE TABLE wcf1_user_trophy(
1688 userTrophyID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1689 trophyID INT(10) NOT NULL,
1690 userID INT(10) NOT NULL,
1691 time INT(10) NOT NULL DEFAULT 0,
1692 description MEDIUMTEXT,
1693 useCustomDescription TINYINT(1) NOT NULL DEFAULT 0,
b5be45d7 1694 trophyUseHtml TINYINT(1) NOT NULL DEFAULT 0,
16977ca6
JR		 1695 KEY(trophyID, time)
1696);
1697
320f4a6d
MW		 1698DROP TABLE IF EXISTS wcf1_user_menu_item;
1699CREATE TABLE wcf1_user_menu_item (
1700 menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1701 packageID INT(10) NOT NULL,
a2bdc5f8
AE		 1702 menuItem VARCHAR(191) NOT NULL DEFAULT '',
1703 parentMenuItem VARCHAR(191) NOT NULL DEFAULT '',
320f4a6d
MW		 1704 menuItemController VARCHAR(255) NOT NULL DEFAULT '',
1705 menuItemLink VARCHAR(255) NOT NULL DEFAULT '',
1706 showOrder INT(10) NOT NULL DEFAULT 0,
1707 permissions TEXT,
1708 options TEXT,
1709 className VARCHAR(255) NOT NULL DEFAULT '',
1e895431
AE		 1710 iconClassName VARCHAR(255) NOT NULL DEFAULT '',
1711 UNIQUE KEY menuItem (menuItem, packageID)
320f4a6d
MW		 1712);
1713
534b8640
TD		 1714DROP TABLE IF EXISTS wcf1_user_multifactor;
1715CREATE TABLE wcf1_user_multifactor (
1716 setupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1717 userID INT(10) NOT NULL,
1718 objectTypeID INT(10) NOT NULL,
1719 UNIQUE KEY (userID, objectTypeID)
1720);
1721
2e781ff3
TD		 1722DROP TABLE IF EXISTS wcf1_user_multifactor_backup;
1723CREATE TABLE wcf1_user_multifactor_backup (
1724 setupID INT(10) NOT NULL,
1725 identifier VARCHAR(255) NOT NULL,
1726 code VARCHAR(255) NOT NULL,
1727 createTime INT(10) NOT NULL,
1728 useTime INT(10) DEFAULT NULL,
e8d9d90e 1729
2e781ff3
TD		 1730 UNIQUE KEY (setupID, identifier)
1731);
1732
afbc4e21
TD		 1733DROP TABLE IF EXISTS wcf1_user_multifactor_email;
1734CREATE TABLE wcf1_user_multifactor_email (
1735 setupID INT(10) NOT NULL,
1736 code VARCHAR(255) NOT NULL,
1737 createTime INT(10) NOT NULL,
e8d9d90e 1738
afbc4e21
TD		 1739 UNIQUE KEY (setupID, code)
1740);
1741
b4a0d5c6
TD		 1742DROP TABLE IF EXISTS wcf1_user_multifactor_totp;
1743CREATE TABLE wcf1_user_multifactor_totp (
1744 setupID INT(10) NOT NULL,
1745 deviceID VARCHAR(255) NOT NULL,
1746 deviceName VARCHAR(255) NOT NULL,
1747 secret VARBINARY(255) NOT NULL,
1748 minCounter INT(10) NOT NULL,
1749 createTime INT(10) NOT NULL,
1750 useTime INT(10) DEFAULT NULL,
e8d9d90e 1751
b4a0d5c6
TD		 1752 UNIQUE KEY (setupID, deviceID)
1753);
1754
320f4a6d
MW		 1755-- notifications
1756DROP TABLE IF EXISTS wcf1_user_notification;
1757CREATE TABLE wcf1_user_notification (
1758 notificationID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
ed6a4e42 1759 packageID INT(10) NOT NULL,
320f4a6d
MW		 1760 eventID INT(10) NOT NULL,
1761 objectID INT(10) NOT NULL DEFAULT 0,
ed6a4e42 1762 baseObjectID INT(10) NOT NULL DEFAULT 0,
68206b3f 1763 eventHash VARCHAR(40) NOT NULL DEFAULT '',
4341fcab 1764 authorID INT(10) NULL,
68206b3f 1765 timesTriggered INT(10) NOT NULL DEFAULT 0,
afb18fa2 1766 guestTimesTriggered INT(10) NOT NULL DEFAULT 0,
4341fcab 1767 userID INT(10) NOT NULL,
320f4a6d 1768 time INT(10) NOT NULL DEFAULT 0,
4341fcab 1769 mailNotified TINYINT(1) NOT NULL DEFAULT 0,
078256b5 1770 confirmTime INT(10) NOT NULL DEFAULT 0,
320f4a6d 1771 additionalData TEXT,
078256b5 1772 KEY (userID, eventID, objectID, confirmTime),
6efc4645
TD		 1773 KEY (userID, confirmTime),
1774 KEY (confirmTime)
4341fcab
AE		 1775);
1776
1777-- notification authors (stacking)
1778DROP TABLE IF EXISTS wcf1_user_notification_author;
1779CREATE TABLE wcf1_user_notification_author (
1780 notificationID INT(10) NOT NULL,
afb18fa2 1781 authorID INT(10),
4341fcab 1782 time INT(10) NOT NULL DEFAULT 0,
4341fcab 1783 UNIQUE KEY (notificationID, authorID)
320f4a6d
MW		 1784);
1785
1786-- notification recipients
4341fcab 1787-- DEPRECATED
320f4a6d
MW		 1788DROP TABLE IF EXISTS wcf1_user_notification_to_user;
1789CREATE TABLE wcf1_user_notification_to_user (
1790 notificationID INT(10) NOT NULL,
1791 userID INT(10) NOT NULL,
320f4a6d
MW		 1792 UNIQUE KEY notificationID (notificationID, userID)
1793);
1794
1795-- events that create notifications
1796DROP TABLE IF EXISTS wcf1_user_notification_event;
1797CREATE TABLE wcf1_user_notification_event (
1798 eventID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1799 packageID INT(10) NOT NULL,
a2bdc5f8 1800 eventName VARCHAR(191) NOT NULL DEFAULT '',
320f4a6d
MW		 1801 objectTypeID INT(10) NOT NULL,
1802 className VARCHAR(255) NOT NULL DEFAULT '',
1803 permissions TEXT,
1804 options TEXT,
2d7c568a 1805 preset TINYINT(1) NOT NULL DEFAULT 0,
1e895431
AE		 1806 presetMailNotificationType ENUM('none', 'instant', 'daily') NOT NULL DEFAULT 'none',
1807 UNIQUE KEY eventName (eventName, objectTypeID)
320f4a6d
MW		 1808);
1809
1810-- user configuration for events
1811DROP TABLE IF EXISTS wcf1_user_notification_event_to_user;
1812CREATE TABLE wcf1_user_notification_event_to_user (
1813 userID INT(10) NOT NULL,
1814 eventID INT(10) NOT NULL,
1815 mailNotificationType ENUM('none', 'instant', 'daily') NOT NULL DEFAULT 'none',
1816 UNIQUE KEY (eventID, userID)
1817);
1818
1819DROP TABLE IF EXISTS wcf1_user_object_watch;
1820CREATE TABLE wcf1_user_object_watch (
1821 watchID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1822 objectTypeID INT(10) NOT NULL,
1823 objectID INT(10) NOT NULL,
1824 userID INT(10) NOT NULL,
1825 notification TINYINT(1) NOT NULL DEFAULT 0,
e8d9d90e 1826
320f4a6d
MW		 1827 UNIQUE KEY (objectTypeID, userID, objectID),
1828 KEY (objectTypeID, objectID)
1829);
1830
158bd3ca
TD		 1831DROP TABLE IF EXISTS wcf1_user_option;
1832CREATE TABLE wcf1_user_option (
1833 optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1834 packageID INT(10) NOT NULL,
a2bdc5f8
AE		 1835 optionName VARCHAR(191) NOT NULL DEFAULT '',
1836 categoryName VARCHAR(191) NOT NULL DEFAULT '',
158bd3ca
TD		 1837 optionType VARCHAR(255) NOT NULL DEFAULT '',
1838 defaultValue MEDIUMTEXT,
1839 validationPattern TEXT,
1840 selectOptions MEDIUMTEXT,
1841 enableOptions MEDIUMTEXT,
b1ffe40c 1842 labeledUrl MEDIUMTEXT,
158bd3ca
TD		 1843 required TINYINT(1) NOT NULL DEFAULT 0,
1844 askDuringRegistration TINYINT(1) NOT NULL DEFAULT 0,
e8d9d90e 1845 editable TINYINT(1) NOT NULL DEFAULT 0,
1846 visible TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 1847 outputClass VARCHAR(255) NOT NULL DEFAULT '',
1848 searchable TINYINT(1) NOT NULL DEFAULT 0,
1849 showOrder INT(10) NOT NULL DEFAULT 0,
8f08c7d0 1850 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 1851 permissions TEXT,
1852 options TEXT,
1853 additionalData MEDIUMTEXT,
31378fd1 1854 originIsSystem TINYINT(1) NOT NULL DEFAULT 0,
1e895431 1855 UNIQUE KEY optionName (optionName, packageID),
158bd3ca
TD		 1856 KEY categoryName (categoryName)
1857);
1858
1859DROP TABLE IF EXISTS wcf1_user_option_category;
1860CREATE TABLE wcf1_user_option_category (
1861 categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1862 packageID INT(10) NOT NULL,
a2bdc5f8
AE		 1863 categoryName VARCHAR(191) NOT NULL DEFAULT '',
1864 parentCategoryName VARCHAR(191) NOT NULL DEFAULT '',
158bd3ca
TD		 1865 showOrder INT(10) NOT NULL DEFAULT 0,
1866 permissions TEXT,
1e895431
AE		 1867 options TEXT,
1868 UNIQUE KEY categoryName (categoryName)
158bd3ca
TD		 1869);
1870
1871DROP TABLE IF EXISTS wcf1_user_option_value;
1872CREATE TABLE wcf1_user_option_value (
1873 userID INT(10) NOT NULL PRIMARY KEY
1874);
1875
320f4a6d
MW		 1876DROP TABLE IF EXISTS wcf1_user_profile_menu_item;
1877CREATE TABLE wcf1_user_profile_menu_item (
1878 menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1879 packageID INT(10) NOT NULL,
a2bdc5f8 1880 menuItem VARCHAR(191) NOT NULL,
320f4a6d
MW		 1881 showOrder INT(10) NOT NULL DEFAULT 0,
1882 permissions TEXT NULL,
1883 options TEXT NULL,
1e895431
AE		 1884 className VARCHAR(255) NOT NULL,
1885 UNIQUE KEY (packageID, menuItem)
320f4a6d
MW		 1886);
1887
1888DROP TABLE IF EXISTS wcf1_user_profile_visitor;
1889CREATE TABLE wcf1_user_profile_visitor (
1890 visitorID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
85a3822b
MS		 1891 ownerID INT(10) NOT NULL,
1892 userID INT(10) NOT NULL,
320f4a6d
MW		 1893 time INT(10) NOT NULL DEFAULT 0,
1894 UNIQUE KEY (ownerID, userID),
1895 KEY (time)
1896);
1897
1898DROP TABLE IF EXISTS wcf1_user_rank;
1899CREATE TABLE wcf1_user_rank (
1900 rankID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
d2fbb3b5 1901 groupID INT(10) NOT NULL,
320f4a6d
MW		 1902 requiredPoints INT(10) NOT NULL DEFAULT 0,
1903 rankTitle VARCHAR(255) NOT NULL DEFAULT '',
1904 cssClassName VARCHAR(255) NOT NULL DEFAULT '',
1905 rankImage VARCHAR(255) NOT NULL DEFAULT '',
1906 repeatImage TINYINT(3) NOT NULL DEFAULT 1,
2a379b2d
AE		 1907 requiredGender TINYINT(1) NOT NULL DEFAULT 0,
1908 hideTitle TINYINT(1) NOT NULL DEFAULT 0
320f4a6d
MW		 1909);
1910
269aa924
TD		 1911DROP TABLE IF EXISTS wcf1_user_session;
1912CREATE TABLE wcf1_user_session (
1913 sessionID CHAR(40) NOT NULL PRIMARY KEY,
1914 userID INT(10),
1915 ipAddress VARCHAR(39) NOT NULL DEFAULT '',
1916 userAgent VARCHAR(255) NOT NULL DEFAULT '',
f8f8fc90 1917 creationTime INT(10) NOT NULL,
269aa924
TD		 1918 lastActivityTime INT(10) NOT NULL DEFAULT 0,
1919 sessionVariables MEDIUMBLOB,
1920 KEY (userID),
1921 KEY (lastActivityTime)
1922);
1923
0a67f96c
MS		 1924DROP TABLE IF EXISTS wcf1_user_storage;
1925CREATE TABLE wcf1_user_storage (
1926 userID INT(10) NOT NULL,
1927 field VARCHAR(80) NOT NULL DEFAULT '',
1e895431 1928 fieldValue MEDIUMTEXT,
16de8cc5
TD		 1929 UNIQUE KEY (userID, field),
1930 KEY (field)
0a67f96c
MS		 1931);
1932
158bd3ca
TD		 1933DROP TABLE IF EXISTS wcf1_user_to_group;
1934CREATE TABLE wcf1_user_to_group (
1935 userID INT(10) NOT NULL,
1936 groupID INT(10) NOT NULL,
1937 UNIQUE KEY userID (userID, groupID)
1938);
1939
1940DROP TABLE IF EXISTS wcf1_user_to_language;
1941CREATE TABLE wcf1_user_to_language (
1942 userID INT(10) NOT NULL,
1943 languageID INT(10) NOT NULL,
1944 UNIQUE KEY userID (userID, languageID)
1945);
1946
2fbf5046
AE		 1947/* SQL_PARSER_OFFSET */
1948
9f959ced 1949/* foreign keys */
092bdf82
AE		 1950ALTER TABLE wcf1_acl_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1951ALTER TABLE wcf1_acl_option ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1952
1953ALTER TABLE wcf1_acl_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1954ALTER TABLE wcf1_acl_option_category ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1955
1956ALTER TABLE wcf1_acl_option_to_user ADD FOREIGN KEY (optionID) REFERENCES wcf1_acl_option (optionID) ON DELETE CASCADE;
1957ALTER TABLE wcf1_acl_option_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1958
1959ALTER TABLE wcf1_acl_option_to_group ADD FOREIGN KEY (optionID) REFERENCES wcf1_acl_option (optionID) ON DELETE CASCADE;
1960ALTER TABLE wcf1_acl_option_to_group ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
1961
2441de47
AE		 1962ALTER TABLE wcf1_acl_simple_to_user ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1963ALTER TABLE wcf1_acl_simple_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1964
1965ALTER TABLE wcf1_acl_simple_to_group ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1966ALTER TABLE wcf1_acl_simple_to_group ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
1967
158bd3ca
TD		 1968ALTER TABLE wcf1_acp_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1969
e9311b98
AE		 1970ALTER TABLE wcf1_acp_search_provider ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1971
158bd3ca 1972ALTER TABLE wcf1_acp_session_access_log ADD FOREIGN KEY (sessionLogID) REFERENCES wcf1_acp_session_log (sessionLogID) ON DELETE CASCADE;
158bd3ca 1973
158bd3ca
TD		 1974ALTER TABLE wcf1_acp_session_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1975
1976ALTER TABLE wcf1_acp_template ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1977
e866b80e
MS		 1978ALTER TABLE wcf1_ad ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1979
158bd3ca 1980ALTER TABLE wcf1_application ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
124dcf73 1981ALTER TABLE wcf1_application ADD FOREIGN KEY (landingPageID) REFERENCES wcf1_page (pageID) ON DELETE SET NULL;
158bd3ca 1982
a5a4f02d
MW		 1983ALTER TABLE wcf1_article ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1984ALTER TABLE wcf1_article ADD FOREIGN KEY (categoryID) REFERENCES wcf1_category (categoryID) ON DELETE SET NULL;
1985
1986ALTER TABLE wcf1_article_content ADD FOREIGN KEY (articleID) REFERENCES wcf1_article (articleID) ON DELETE CASCADE;
1987ALTER TABLE wcf1_article_content ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE SET NULL;
1988ALTER TABLE wcf1_article_content ADD FOREIGN KEY (imageID) REFERENCES wcf1_media (mediaID) ON DELETE SET NULL;
79305986 1989ALTER TABLE wcf1_article_content ADD FOREIGN KEY (teaserImageID) REFERENCES wcf1_media (mediaID) ON DELETE SET NULL;
a5a4f02d 1990
f0bc263f
MW		 1991ALTER TABLE wcf1_attachment ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1992ALTER TABLE wcf1_attachment ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1993
dcc2332d
MW		 1994ALTER TABLE wcf1_bbcode ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1995
1996ALTER TABLE wcf1_bbcode_attribute ADD FOREIGN KEY (bbcodeID) REFERENCES wcf1_bbcode (bbcodeID) ON DELETE CASCADE;
1997
7d346d2a
MW		 1998ALTER TABLE wcf1_bbcode_media_provider ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1999
91317611 2000ALTER TABLE wcf1_box ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
11fd4618 2001ALTER TABLE wcf1_box ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
39abe192 2002ALTER TABLE wcf1_box ADD FOREIGN KEY (menuID) REFERENCES wcf1_menu (menuID) ON DELETE CASCADE;
5636588a 2003ALTER TABLE wcf1_box ADD FOREIGN KEY (linkPageID) REFERENCES wcf1_page (pageID) ON DELETE SET NULL;
11fd4618 2004
059bcdba
AE		 2005/* SQL_PARSER_OFFSET */
2006
11fd4618 2007ALTER TABLE wcf1_box_content ADD FOREIGN KEY (boxID) REFERENCES wcf1_box (boxID) ON DELETE CASCADE;
56eb7314
MS		 2008ALTER TABLE wcf1_box_content ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
2009ALTER TABLE wcf1_box_content ADD FOREIGN KEY (imageID) REFERENCES wcf1_media (mediaID) ON DELETE SET NULL;
11fd4618 2010
53cf1c00
MW		 2011ALTER TABLE wcf1_box_to_page ADD FOREIGN KEY (boxID) REFERENCES wcf1_box (boxID) ON DELETE CASCADE;
2012ALTER TABLE wcf1_box_to_page ADD FOREIGN KEY (pageID) REFERENCES wcf1_page (pageID) ON DELETE CASCADE;
2013
13d8b49b
MS		 2014ALTER TABLE wcf1_category ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2015
054db725
TD		 2016ALTER TABLE wcf1_cli_history ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2017
0e6741f8
AE		 2018ALTER TABLE wcf1_clipboard_action ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2019
25cf4d11 2020ALTER TABLE wcf1_clipboard_item ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
0e6741f8
AE		 2021
2022ALTER TABLE wcf1_clipboard_page ADD FOREIGN KEY (actionID) REFERENCES wcf1_clipboard_action (actionID) ON DELETE CASCADE;
2023ALTER TABLE wcf1_clipboard_page ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2024
87d3a054
MS		 2025ALTER TABLE wcf1_condition ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2026
db32ea8f
AE		 2027ALTER TABLE wcf1_contact_attachment ADD FOREIGN KEY (attachmentID) REFERENCES wcf1_attachment (attachmentID) ON DELETE CASCADE;
2028
158bd3ca
TD		 2029ALTER TABLE wcf1_core_object ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2030
2031ALTER TABLE wcf1_cronjob ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2032
2033ALTER TABLE wcf1_cronjob_log ADD FOREIGN KEY (cronjobID) REFERENCES wcf1_cronjob (cronjobID) ON DELETE CASCADE;
2034
42aa9860
MS		 2035ALTER TABLE wcf1_devtools_missing_language_item ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE SET NULL;
2036
81aa6374
TD		 2037ALTER TABLE wcf1_edit_history_entry ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2038ALTER TABLE wcf1_edit_history_entry ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
f86d7ff7 2039ALTER TABLE wcf1_edit_history_entry ADD FOREIGN KEY (obsoletedByUserID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
81aa6374 2040
1483324c
TD		 2041ALTER TABLE wcf1_email_log_entry ADD FOREIGN KEY (recipientID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
2042
158bd3ca
TD		 2043ALTER TABLE wcf1_event_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2044
2045ALTER TABLE wcf1_language_item ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
2046ALTER TABLE wcf1_language_item ADD FOREIGN KEY (languageCategoryID) REFERENCES wcf1_language_category (languageCategoryID) ON DELETE CASCADE;
2047ALTER TABLE wcf1_language_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2048
059bcdba
AE		 2049/* SQL_PARSER_OFFSET */
2050
cf4e950c 2051ALTER TABLE wcf1_media ADD FOREIGN KEY (categoryID) REFERENCES wcf1_category (categoryID) ON DELETE SET NULL;
59ab4d0f
MS		 2052ALTER TABLE wcf1_media ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
2053ALTER TABLE wcf1_media ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE SET NULL;
2054
2055ALTER TABLE wcf1_media_content ADD FOREIGN KEY (mediaID) REFERENCES wcf1_media (mediaID) ON DELETE CASCADE;
2056ALTER TABLE wcf1_media_content ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
2057
c5dd767e 2058ALTER TABLE wcf1_menu ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
e7fb3339
MW		 2059
2060ALTER TABLE wcf1_menu_item ADD FOREIGN KEY (menuID) REFERENCES wcf1_menu (menuID) ON DELETE CASCADE;
2061ALTER TABLE wcf1_menu_item ADD FOREIGN KEY (parentItemID) REFERENCES wcf1_menu_item (itemID) ON DELETE SET NULL;
effc9389
AE		 2062ALTER TABLE wcf1_menu_item ADD FOREIGN KEY (pageID) REFERENCES wcf1_page (pageID) ON DELETE CASCADE;
2063ALTER TABLE wcf1_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
e7fb3339 2064
3a2de7fd
AE		 2065ALTER TABLE wcf1_modification_log ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2066ALTER TABLE wcf1_modification_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
2067
7fcc7676
MW		 2068ALTER TABLE wcf1_object_type ADD FOREIGN KEY (definitionID) REFERENCES wcf1_object_type_definition (definitionID) ON DELETE CASCADE;
2069ALTER TABLE wcf1_object_type ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2070
2071ALTER TABLE wcf1_object_type_definition ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2072
158bd3ca
TD		 2073ALTER TABLE wcf1_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2074
2075ALTER TABLE wcf1_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2076
89484ba0
AE		 2077ALTER TABLE wcf1_package_compatibility ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2078
158bd3ca
TD		 2079ALTER TABLE wcf1_package_exclusion ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2080
2081ALTER TABLE wcf1_package_installation_file_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2082
2083ALTER TABLE wcf1_package_installation_form ADD FOREIGN KEY (queueID) REFERENCES wcf1_package_installation_queue (queueID) ON DELETE CASCADE;
2084
2085ALTER TABLE wcf1_package_installation_node ADD FOREIGN KEY (queueID) REFERENCES wcf1_package_installation_queue (queueID) ON DELETE CASCADE;
2086
2087ALTER TABLE wcf1_package_installation_plugin ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2088
2089ALTER TABLE wcf1_package_installation_queue ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2090ALTER TABLE wcf1_package_installation_queue ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE SET NULL;
2091
2092ALTER TABLE wcf1_package_installation_sql_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2093
1b4f5112
AE		 2094/* SQL_PARSER_OFFSET */
2095
158bd3ca
TD		 2096ALTER TABLE wcf1_package_requirement ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2097ALTER TABLE wcf1_package_requirement ADD FOREIGN KEY (requirement) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2098
158bd3ca
TD		 2099ALTER TABLE wcf1_package_update ADD FOREIGN KEY (packageUpdateServerID) REFERENCES wcf1_package_update_server (packageUpdateServerID) ON DELETE CASCADE;
2100
89484ba0
AE		 2101ALTER TABLE wcf1_package_update_compatibility ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
2102
158bd3ca
TD		 2103ALTER TABLE wcf1_package_update_exclusion ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
2104
2105ALTER TABLE wcf1_package_update_fromversion ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
2106
2107ALTER TABLE wcf1_package_update_requirement ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
2108
b4f1ea02 2109ALTER TABLE wcf1_package_update_optional ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
158bd3ca
TD		 2110
2111ALTER TABLE wcf1_package_update_version ADD FOREIGN KEY (packageUpdateID) REFERENCES wcf1_package_update (packageUpdateID) ON DELETE CASCADE;
2112
4d8036f5
MW		 2113ALTER TABLE wcf1_paid_subscription_user ADD FOREIGN KEY (subscriptionID) REFERENCES wcf1_paid_subscription (subscriptionID) ON DELETE CASCADE;
2114ALTER TABLE wcf1_paid_subscription_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2115
2116ALTER TABLE wcf1_paid_subscription_transaction_log ADD FOREIGN KEY (subscriptionUserID) REFERENCES wcf1_paid_subscription_user (subscriptionUserID) ON DELETE SET NULL;
2117ALTER TABLE wcf1_paid_subscription_transaction_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
2118ALTER TABLE wcf1_paid_subscription_transaction_log ADD FOREIGN KEY (subscriptionID) REFERENCES wcf1_paid_subscription (subscriptionID) ON DELETE SET NULL;
2119ALTER TABLE wcf1_paid_subscription_transaction_log ADD FOREIGN KEY (paymentMethodObjectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2120
0bdb3cdf
MW		 2121ALTER TABLE wcf1_page ADD FOREIGN KEY (parentPageID) REFERENCES wcf1_page (pageID) ON DELETE SET NULL;
2122ALTER TABLE wcf1_page ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
19dadfda 2123ALTER TABLE wcf1_page ADD FOREIGN KEY (applicationPackageID) REFERENCES wcf1_package (packageID) ON DELETE SET NULL;
2b63c6d2 2124ALTER TABLE wcf1_page ADD FOREIGN KEY (overrideApplicationPackageID) REFERENCES wcf1_package (packageID) ON DELETE SET NULL;
0bdb3cdf 2125
5b85fc64
AE		 2126ALTER TABLE wcf1_page_box_order ADD FOREIGN KEY (pageID) REFERENCES wcf1_page (pageID) ON DELETE CASCADE;
2127ALTER TABLE wcf1_page_box_order ADD FOREIGN KEY (boxID) REFERENCES wcf1_box (boxID) ON DELETE CASCADE;
2128
0bdb3cdf
MW		 2129ALTER TABLE wcf1_page_content ADD FOREIGN KEY (pageID) REFERENCES wcf1_page (pageID) ON DELETE CASCADE;
2130ALTER TABLE wcf1_page_content ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
2131
11117cd5
AE		 2132ALTER TABLE wcf1_registry ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2133
158bd3ca
TD		 2134ALTER TABLE wcf1_search ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2135
059bcdba
AE		 2136/* SQL_PARSER_OFFSET */
2137
158bd3ca 2138ALTER TABLE wcf1_session ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
e8d26212 2139ALTER TABLE wcf1_session ADD FOREIGN KEY (spiderID) REFERENCES wcf1_spider (spiderID) ON DELETE CASCADE;
da5a61fb
MW		 2140ALTER TABLE wcf1_session ADD FOREIGN KEY (pageID) REFERENCES wcf1_page (pageID) ON DELETE SET NULL;
2141ALTER TABLE wcf1_session ADD FOREIGN KEY (parentPageID) REFERENCES wcf1_page (pageID) ON DELETE SET NULL;
158bd3ca 2142
dcc2332d
MW		 2143ALTER TABLE wcf1_smiley ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2144ALTER TABLE wcf1_smiley ADD FOREIGN KEY (categoryID) REFERENCES wcf1_category (categoryID) ON DELETE SET NULL;
2145
461a69ea 2146ALTER TABLE wcf1_user_storage ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
158bd3ca
TD		 2147
2148ALTER TABLE wcf1_style ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2149
4d9f6058
AE		 2150ALTER TABLE wcf1_style_variable_value ADD FOREIGN KEY (styleID) REFERENCES wcf1_style (styleID) ON DELETE CASCADE;
2151ALTER TABLE wcf1_style_variable_value ADD FOREIGN KEY (variableID) REFERENCES wcf1_style_variable (variableID) ON DELETE CASCADE;
158bd3ca
TD		 2152
2153ALTER TABLE wcf1_template ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2154ALTER TABLE wcf1_template ADD FOREIGN KEY (templateGroupID) REFERENCES wcf1_template_group (templateGroupID) ON DELETE CASCADE;
2155
6570e38e
MW		 2156ALTER TABLE wcf1_template_group ADD FOREIGN KEY (parentTemplateGroupID) REFERENCES wcf1_template_group (templateGroupID) ON DELETE SET NULL;
2157
158bd3ca
TD		 2158ALTER TABLE wcf1_template_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2159
704e0423
JR		 2160ALTER TABLE wcf1_trophy ADD FOREIGN KEY (categoryID) REFERENCES wcf1_category (categoryID) ON DELETE CASCADE;
2161
a8e8aa21
AE		 2162ALTER TABLE wcf1_user_collapsible_content ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2163ALTER TABLE wcf1_user_collapsible_content ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2164
87d3a054
MS		 2165ALTER TABLE wcf1_user_group_assignment ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
2166
158bd3ca
TD		 2167ALTER TABLE wcf1_user_group_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2168
2169ALTER TABLE wcf1_user_group_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2170
2171ALTER TABLE wcf1_user_group_option_value ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
2172ALTER TABLE wcf1_user_group_option_value ADD FOREIGN KEY (optionID) REFERENCES wcf1_user_group_option (optionID) ON DELETE CASCADE;
2173
2fbf5046
AE		 2174/* SQL_PARSER_OFFSET */
2175
158bd3ca
TD		 2176ALTER TABLE wcf1_user_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2177
2178ALTER TABLE wcf1_user_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2179
2180ALTER TABLE wcf1_user_option_value ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2181
2182ALTER TABLE wcf1_user_to_group ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2183ALTER TABLE wcf1_user_to_group ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
2184
2185ALTER TABLE wcf1_user_to_language ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2186ALTER TABLE wcf1_user_to_language ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
2187
16977ca6
JR		 2188ALTER TABLE wcf1_user_trophy ADD FOREIGN KEY (trophyID) REFERENCES wcf1_trophy (trophyID) ON DELETE CASCADE;
2189ALTER TABLE wcf1_user_trophy ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2190
78db8ddf
MW		 2191ALTER TABLE wcf1_import_mapping ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2192
320f4a6d
MW		 2193ALTER TABLE wcf1_tracked_visit ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2194ALTER TABLE wcf1_tracked_visit ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2195
2196ALTER TABLE wcf1_tracked_visit_type ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2197ALTER TABLE wcf1_tracked_visit_type ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2198
286dbaf8 2199ALTER TABLE wcf1_unfurl_url ADD FOREIGN KEY (imageID) REFERENCES wcf1_unfurl_url_image (imageID) ON DELETE SET NULL;
2200
320f4a6d
MW		 2201ALTER TABLE wcf1_user ADD FOREIGN KEY (avatarID) REFERENCES wcf1_user_avatar (avatarID) ON DELETE SET NULL;
2202ALTER TABLE wcf1_user ADD FOREIGN KEY (rankID) REFERENCES wcf1_user_rank (rankID) ON DELETE SET NULL;
2203ALTER TABLE wcf1_user ADD FOREIGN KEY (userOnlineGroupID) REFERENCES wcf1_user_group (groupID) ON DELETE SET NULL;
2204
059bcdba
AE		 2205/* SQL_PARSER_OFFSET */
2206
320f4a6d
MW		 2207ALTER TABLE wcf1_user_avatar ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2208
2209ALTER TABLE wcf1_user_follow ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2210ALTER TABLE wcf1_user_follow ADD FOREIGN KEY (followUserID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2211
2212ALTER TABLE wcf1_user_ignore ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2213ALTER TABLE wcf1_user_ignore ADD FOREIGN KEY (ignoreUserID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2214
2215ALTER TABLE wcf1_user_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2216
320f4a6d
MW		 2217ALTER TABLE wcf1_user_notification ADD FOREIGN KEY (eventID) REFERENCES wcf1_user_notification_event (eventID) ON DELETE CASCADE;
2218ALTER TABLE wcf1_user_notification ADD FOREIGN KEY (authorID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
4341fcab
AE		 2219ALTER TABLE wcf1_user_notification ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2220
2221ALTER TABLE wcf1_user_notification_author ADD FOREIGN KEY (notificationID) REFERENCES wcf1_user_notification (notificationID) ON DELETE CASCADE;
2222ALTER TABLE wcf1_user_notification_author ADD FOREIGN KEY (authorID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
320f4a6d
MW		 2223
2224ALTER TABLE wcf1_user_notification_to_user ADD FOREIGN KEY (notificationID) REFERENCES wcf1_user_notification (notificationID) ON DELETE CASCADE;
2225ALTER TABLE wcf1_user_notification_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2226
2227ALTER TABLE wcf1_user_notification_event ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2228ALTER TABLE wcf1_user_notification_event ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2229
2230ALTER TABLE wcf1_user_notification_event_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2231ALTER TABLE wcf1_user_notification_event_to_user ADD FOREIGN KEY (eventID) REFERENCES wcf1_user_notification_event (eventID) ON DELETE CASCADE;
2232
2233ALTER TABLE wcf1_user_profile_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
2234
1b4f5112
AE		 2235/* SQL_PARSER_OFFSET */
2236
d2fbb3b5 2237ALTER TABLE wcf1_user_rank ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
320f4a6d
MW		 2238
2239ALTER TABLE wcf1_user_activity_event ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2240ALTER TABLE wcf1_user_activity_event ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2241ALTER TABLE wcf1_user_activity_event ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE SET NULL;
2242
2243ALTER TABLE wcf1_user_activity_point ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2244ALTER TABLE wcf1_user_activity_point ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2245
359f3c53
MW		 2246ALTER TABLE wcf1_user_authentication_failure ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
2247
534b8640
TD		 2248ALTER TABLE wcf1_user_multifactor ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2249ALTER TABLE wcf1_user_multifactor ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
320f4a6d 2250
2e781ff3 2251ALTER TABLE wcf1_user_multifactor_backup ADD FOREIGN KEY (setupID) REFERENCES wcf1_user_multifactor (setupID) ON DELETE CASCADE;
afbc4e21
TD		 2252
2253ALTER TABLE wcf1_user_multifactor_email ADD FOREIGN KEY (setupID) REFERENCES wcf1_user_multifactor (setupID) ON DELETE CASCADE;
2254
b4a0d5c6 2255ALTER TABLE wcf1_user_multifactor_totp ADD FOREIGN KEY (setupID) REFERENCES wcf1_user_multifactor (setupID) ON DELETE CASCADE;
2e781ff3 2256
320f4a6d
MW		 2257ALTER TABLE wcf1_user_object_watch ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2258ALTER TABLE wcf1_user_object_watch ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2259
534b8640
TD		 2260ALTER TABLE wcf1_user_profile_visitor ADD FOREIGN KEY (ownerID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2261ALTER TABLE wcf1_user_profile_visitor ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2262
269aa924
TD		 2263ALTER TABLE wcf1_user_session ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2264
a83d788a
JR		 2265ALTER TABLE wcf1_user_special_trophy ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2266ALTER TABLE wcf1_user_special_trophy ADD FOREIGN KEY (trophyID) REFERENCES wcf1_trophy (trophyID) ON DELETE CASCADE;
2267
0a2b09a2
MW		 2268ALTER TABLE wcf1_message_embedded_object ADD FOREIGN KEY (messageObjectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2269ALTER TABLE wcf1_message_embedded_object ADD FOREIGN KEY (embeddedObjectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2270
fc69b61d
MW		 2271ALTER TABLE wcf1_moderation_queue ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2272ALTER TABLE wcf1_moderation_queue ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
2273ALTER TABLE wcf1_moderation_queue ADD FOREIGN KEY (assignedUserID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
2274
2275ALTER TABLE wcf1_moderation_queue_to_user ADD FOREIGN KEY (queueID) REFERENCES wcf1_moderation_queue (queueID) ON DELETE CASCADE;
2276ALTER TABLE wcf1_moderation_queue_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2277
00b6f956
MW		 2278ALTER TABLE wcf1_like ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2279ALTER TABLE wcf1_like ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2280ALTER TABLE wcf1_like ADD FOREIGN KEY (objectUserID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
e8d9d90e 2281ALTER TABLE wcf1_like ADD FOREIGN KEY (reactionTypeID) REFERENCES wcf1_reaction_type (reactionTypeID) ON DELETE CASCADE;
00b6f956
MW		 2282
2283ALTER TABLE wcf1_like_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2284ALTER TABLE wcf1_like_object ADD FOREIGN KEY (objectUserID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
2285
059bcdba
AE		 2286/* SQL_PARSER_OFFSET */
2287
285b1d92
MW		 2288ALTER TABLE wcf1_comment ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2289ALTER TABLE wcf1_comment ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
2290
2291ALTER TABLE wcf1_comment_response ADD FOREIGN KEY (commentID) REFERENCES wcf1_comment (commentID) ON DELETE CASCADE;
2292ALTER TABLE wcf1_comment_response ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
2293
3b75466f
MW		 2294ALTER TABLE wcf1_label ADD FOREIGN KEY (groupID) REFERENCES wcf1_label_group (groupID) ON DELETE CASCADE;
2295
2296ALTER TABLE wcf1_label_group_to_object ADD FOREIGN KEY (groupID) REFERENCES wcf1_label_group (groupID) ON DELETE CASCADE;
2297ALTER TABLE wcf1_label_group_to_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2298
2299ALTER TABLE wcf1_label_object ADD FOREIGN KEY (labelID) REFERENCES wcf1_label (labelID) ON DELETE CASCADE;
2300ALTER TABLE wcf1_label_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2301
04c06e85
MW		 2302ALTER TABLE wcf1_tag ADD FOREIGN KEY (synonymFor) REFERENCES wcf1_tag (tagID) ON DELETE CASCADE;
2303
2304ALTER TABLE wcf1_tag_to_object ADD FOREIGN KEY (tagID) REFERENCES wcf1_tag (tagID) ON DELETE CASCADE;
2305ALTER TABLE wcf1_tag_to_object ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
2306ALTER TABLE wcf1_tag_to_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2307
891de7a0
MW		 2308ALTER TABLE wcf1_stat_daily ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2309
e25b7b61
MW		 2310ALTER TABLE wcf1_poll ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
2311
2312ALTER TABLE wcf1_poll_option ADD FOREIGN KEY (pollID) REFERENCES wcf1_poll (pollID) ON DELETE CASCADE;
2313
2314ALTER TABLE wcf1_poll_option_vote ADD FOREIGN KEY (pollID) REFERENCES wcf1_poll (pollID) ON DELETE CASCADE;
2315ALTER TABLE wcf1_poll_option_vote ADD FOREIGN KEY (optionID) REFERENCES wcf1_poll_option (optionID) ON DELETE CASCADE;
2316ALTER TABLE wcf1_poll_option_vote ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2317
20933e61
MS		 2318ALTER TABLE wcf1_notice_dismissed ADD FOREIGN KEY (noticeID) REFERENCES wcf1_notice (noticeID) ON DELETE CASCADE;
2319ALTER TABLE wcf1_notice_dismissed ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
2320
2fbf5046
AE		 2321/* SQL_PARSER_OFFSET */
2322
9f959ced 2323/* default inserts */
158bd3ca 2324-- default user groups
3f69fee7
AE		 2325INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (1, 'wcf.acp.group.group1', 1); -- Everyone
2326INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (2, 'wcf.acp.group.group2', 2); -- Guests
2327INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (3, 'wcf.acp.group.group3', 3); -- Registered Users
f6c48827 2328INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (4, 'wcf.acp.group.group4', 9); -- Administrators
3f69fee7 2329INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (5, 'wcf.acp.group.group5', 4); -- Moderators
47459aed 2330
158bd3ca 2331-- default user group options
ae6b590f 2332INSERT INTO wcf1_user_group_option (optionID, optionName, categoryName, optionType, defaultValue, showOrder, usersOnly) VALUES (1, 'admin.general.canUseAcp', 'admin.general', 'boolean', '0', 1, 1);
6476e7a1 2333INSERT 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 2334INSERT 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		 2335
2336-- default user group option values
2337INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 1, '0'); -- Everyone
2338INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 2, '0'); -- Everyone
2339INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 3, '0'); -- Everyone
2340INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 1, '1'); -- Administrators
2341INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 2, '1'); -- Administrators
2342INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 3, '1'); -- Administrators
47459aed 2343
158bd3ca 2344-- default update servers
a9293ea7
AE		 2345INSERT INTO wcf1_package_update_server (serverURL, status, isDisabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://update.woltlab.com/5.3/', 'online', 0, NULL, 0, '', '');
2346INSERT 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		 2347
2348-- style default values
97ec0367 2349INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('individualScss', '');
3321b9c6 2350INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('messageSidebarOrientation', 'left');
97ec0367 2351INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('overrideScss', '');
ed8c9052 2352INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogo', '');
07937b16 2353INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogoWidth', '281');
4a292263
MW		 2354INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogoHeight', '40');
2355INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogoMobile', '');
ed8c9052 2356INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('useFluidLayout', '1');
5d1c2d79
AE		 2357INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBackground', 'rgba(207, 216, 220, 1)');
2358INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBackgroundActive', 'rgba(120, 144, 156, 1)');
95cc4d01 2359INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonDisabledBackground', 'rgba(223, 223, 223, 1)');
95cc4d01
AE		 2360INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonDisabledText', 'rgba(165, 165, 165, 1)');
2361INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryBackground', 'rgba(33, 150, 243, 1)');
2362INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryBackgroundActive', 'rgba(26, 119, 201, 1)');
95cc4d01 2363INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryText', 'rgba(255, 255, 255, 1)');
ed8c9052 2364INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryTextActive', 'rgba(255, 255, 255, 1)');
95cc4d01 2365INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonText', 'rgba(33, 33, 33, 1)');
5d1c2d79 2366INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonTextActive', 'rgba(255, 255, 255, 1)');
002297c1 2367INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentBackground', 'rgba(250, 250, 250, 1)');
4e359429 2368INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentBorder', 'rgba(65, 121, 173, 1)');
002297c1 2369INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentBorderInner', 'rgba(224, 224, 224, 1)');
811f5a93
AE		 2370INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentContainerBackground', 'rgba(255, 255, 255, 1)');
2371INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentContainerBorder', 'rgba(236, 241, 247, 1)');
962f1164
AE		 2372INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentDimmedLink', 'rgba(52, 73, 94, 1)');
2373INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentDimmedLinkActive', 'rgba(52, 73, 94, 1)');
487db634 2374INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentDimmedText', 'rgba(125, 130, 135, 1)');
962f1164
AE		 2375INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentHeadlineBorder', 'rgba(238, 238, 238, 1)');
2376INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentHeadlineLink', 'rgba(44, 62, 80, 1)');
2377INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentHeadlineLinkActive', 'rgba(44, 62, 80, 1)');
2378INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentHeadlineText', 'rgba(44, 62, 80, 1)');
002297c1
AE		 2379INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentLink', 'rgba(230, 81, 0, 1)');
2380INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentLinkActive', 'rgba(191, 54, 12, 1)');
ed8c9052
AE		 2381INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentText', 'rgba(44, 62, 80, 1)');
2382INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBackground', 'rgba(255, 255, 255, 1)');
c1956b1c 2383INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBackgroundActive', 'rgba(238, 238, 238, 1)');
962f1164 2384INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBorderInner', 'rgba(238, 238, 238, 1)');
c1956b1c
AE		 2385INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownLink', 'rgba(33, 33, 33, 1)');
2386INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownLinkActive', 'rgba(33, 33, 33, 1)');
2387INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownText', 'rgba(33, 33, 33, 1)');
aa893dd8
AE		 2388INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfEditorButtonBackground', 'rgba(58, 109, 156, 1)');
2389INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfEditorButtonBackgroundActive', 'rgba(36, 66, 95, 1)');
2390INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfEditorButtonText', 'rgba(255, 255, 255, 1)');
2391INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfEditorButtonTextActive', 'rgba(255, 255, 255, 1)');
2392INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfEditorButtonTextDisabled', 'rgba(165, 165, 165, 1)');
e8defa30 2393INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfEditorTableBorder', 'rgba(221, 221, 221, 1)');
cf12aedd
AE		 2394INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontFamilyFallback', 'system');
2395INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontFamilyGoogle', '');
852e099f 2396INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontLineHeight', '1.48');
962f1164 2397INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontSizeDefault', '14px');
ed8c9052 2398INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontSizeHeadline', '18px');
f6fc939a 2399INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontSizeSection', '23px');
ed8c9052 2400INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontSizeSmall', '12px');
487db634 2401INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontSizeTitle', '28px');
4e359429 2402INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBackground', 'rgba(58, 109, 156, 1)');
5d1c2d79 2403INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBoxBackground', 'rgba(236, 239, 241, 1)');
6063a7ec
AE		 2404INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBoxHeadlineLink', 'rgba(44, 62, 80, 1)');
2405INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBoxHeadlineLinkActive', 'rgba(44, 62, 80, 1)');
2406INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBoxHeadlineText', 'rgba(44, 62, 80, 1)');
002297c1
AE		 2407INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBoxLink', 'rgba(230, 81, 0, 1)');
2408INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBoxLinkActive', 'rgba(191, 54, 12, 1)');
6063a7ec 2409INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBoxText', 'rgba(44, 62, 80, 1)');
4e359429 2410INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterCopyrightBackground', 'rgba(50, 92, 132, 1)');
d3925b67 2411INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterCopyrightLink', 'rgba(217, 220, 222, 1)');
6063a7ec 2412INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterCopyrightLinkActive', 'rgba(255, 255, 255, 1)');
4e359429 2413INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterCopyrightText', 'rgba(217, 220, 222, 1)');
f6fc939a
AE		 2414INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterHeadlineLink', 'rgba(255, 255, 255, 1)');
2415INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterHeadlineLinkActive', 'rgba(255, 255, 255, 1)');
2416INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterHeadlineText', 'rgba(189, 195, 199, 1)');
ed8c9052
AE		 2417INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterLink', 'rgba(255, 255, 255, 1)');
2418INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterLinkActive', 'rgba(255, 255, 255, 1)');
4e359429
AE		 2419INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterText', 'rgba(217, 220, 222, 1)');
2420INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderBackground', 'rgba(58, 109, 156, 1)');
55b402a0 2421INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderText', 'rgba(255, 255, 255, 1)');
453b84d5 2422INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderLink', 'rgba(255, 255, 255, 1)');
ed8c9052 2423INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderLinkActive', 'rgba(255, 255, 255, 1)');
4e359429
AE		 2424INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuBackground', 'rgba(50, 92, 132, 1)');
2425INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuLinkBackground', 'rgba(43, 79, 113, 1)');
2426INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuLinkBackgroundActive', 'rgba(36, 66, 95, 1)');
f6fc939a 2427INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuLink', 'rgba(255, 255, 255, 1)');
ed8c9052 2428INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuLinkActive', 'rgba(255, 255, 255, 1)');
4df658a4
AE		 2429INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuDropdownBackground', 'rgba(36, 66, 95, 1)');
2430INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuDropdownBackgroundActive', 'rgba(65, 121, 173, 1)');
a9e43634 2431INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuDropdownLink', 'rgba(255, 255, 255, 1)');
f6fc939a 2432INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuDropdownLinkActive', 'rgba(255, 255, 255, 1)');
4e359429
AE		 2433INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderSearchBoxBackground', 'rgba(50, 92, 132, 1)');
2434INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderSearchBoxBackgroundActive', 'rgba(50, 92, 132, 1)');
70318665
AE		 2435INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderSearchBoxText', 'rgba(255, 255, 255, 1)');
2436INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderSearchBoxTextActive', 'rgba(255, 255, 255, 1)');
6388408b
AE		 2437INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderSearchBoxPlaceholder', 'rgba(207, 207, 207, 1)');
2438INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderSearchBoxPlaceholderActive', 'rgba(207, 207, 207, 1)');
487db634
MW		 2439INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBackground', 'rgba(241, 246, 251, 1)');
2440INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBackgroundActive', 'rgba(241, 246, 251, 1)');
2441INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBorder', 'rgba(176, 200, 224, 1)');
962f1164 2442INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBorderActive', 'rgba(41, 128, 185, 1)');
487db634
MW		 2443INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputDisabledBackground', 'rgba(245, 245, 245, 1)');
2444INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputDisabledBorder', 'rgba(174, 176, 179, 1)');
2445INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputDisabledText', 'rgba(125, 130, 100, 1)');
b4f2a6be 2446INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputLabel', 'rgba(59, 109, 169, 1)');
487db634
MW		 2447INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputText', 'rgba(44, 62, 80, 1)');
2448INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputTextActive', 'rgba(44, 62, 80, 1)');
6e6b849f 2449INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputPlaceholder', 'rgba(169, 169, 169, 1)');
5d0e8b3f 2450INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputPlaceholderActive', 'rgba(204, 204, 204, 1)');
ed8c9052 2451INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutFixedWidth', '1200px');
962f1164 2452INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutMaxWidth', '1400px');
df400238 2453INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutMinWidth', '1000px');
5d1c2d79 2454INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationBackground', 'rgba(236, 239, 241, 1)');
80786168
AE		 2455INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationLink', 'rgba(44, 62, 80, 1)');
2456INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationLinkActive', 'rgba(44, 62, 80, 1)');
962f1164 2457INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationText', 'rgba(170, 170, 170, 1)');
f1f729e9 2458INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageThemeColor', ''); -- uses `$wcfHeaderBackground` if left empty
efb111c4 2459INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarBackground', 'rgba(236, 241, 247, 1)');
962f1164
AE		 2460INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarDimmedLink', 'rgba(44, 62, 80, 1)');
2461INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarDimmedLinkActive', 'rgba(44, 62, 80, 1)');
2462INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarDimmedText', 'rgba(127, 140, 141, 1)');
487db634
MW		 2463INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarHeadlineLink', 'rgba(44, 62, 80, 1)');
2464INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarHeadlineLinkActive', 'rgba(44, 62, 80, 1)');
2465INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarHeadlineText', 'rgba(44, 62, 80, 1)');
002297c1
AE		 2466INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarLink', 'rgba(230, 81, 0, 1)');
2467INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarLinkActive', 'rgba(191, 54, 12, 1)');
487db634 2468INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarText', 'rgba(44, 62, 80, 1)');
962f1164
AE		 2469INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusErrorBackground', 'rgba(242, 222, 222, 1)');
2470INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusErrorBorder', 'rgba(235, 204, 204, 1)');
0c163e25
MW		 2471INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusErrorLink', 'rgba(132, 53, 52, 1)');
2472INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusErrorLinkActive', 'rgba(132, 53, 52, 1)');
962f1164
AE		 2473INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusErrorText', 'rgba(169, 68, 66, 1)');
2474INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusInfoBackground', 'rgba(217, 237, 247, 1)');
2475INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusInfoBorder', 'rgba(188, 223, 241, 1)');
0c163e25
MW		 2476INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusInfoLink', 'rgba(36, 82, 105, 1)');
2477INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusInfoLinkActive', 'rgba(36, 82, 105, 1)');
962f1164
AE		 2478INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusInfoText', 'rgba(49, 112, 143, 1)');
2479INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusSuccessBackground', 'rgba(223, 240, 216, 1)');
2480INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusSuccessBorder', 'rgba(208, 233, 198, 1)');
0c163e25
MW		 2481INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusSuccessLink', 'rgba(43, 84, 44, 1)');
2482INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusSuccessLinkActive', 'rgba(43, 84, 44, 1)');
962f1164
AE		 2483INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusSuccessText', 'rgba(60, 118, 61, 1)');
2484INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusWarningBackground', 'rgba(252, 248, 227, 1)');
2485INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusWarningBorder', 'rgba(250, 242, 204, 1)');
0c163e25
MW		 2486INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusWarningLink', 'rgba(102, 81, 44, 1)');
2487INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusWarningLinkActive', 'rgba(102, 81, 44, 1)');
962f1164
AE		 2488INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusWarningText', 'rgba(138, 109, 59, 1)');
2489INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxBackgroundActive', 'rgba(242, 242, 242, 1)');
2490INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxBorderInner', 'rgba(238, 238, 238, 1)');
4e359429 2491INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxHeadline', 'rgba(65, 121, 173, 1)');
002297c1 2492INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxHeadlineActive', 'rgba(230, 81, 0, 1)');
ed8c9052
AE		 2493INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTextShadowDark', 'rgba(0, 0, 0, .8)');
2494INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTextShadowLight', 'rgba(255, 255, 255, .8)');
2495INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTooltipBackground', 'rgba(0, 0, 0, .8)');
2496INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTooltipText', 'rgba(255, 255, 255, 1)');
dcc2332d 2497
76eee28f
TD		 2498-- Email template group
2499INSERT INTO wcf1_template_group (parentTemplateGroupID, templateGroupName, templateGroupFolderName) VALUES (NULL, 'wcf.acp.template.group.email', '_wcf_email/');
e8d9d90e 2500
320f4a6d
MW		 2501-- default priorities
2502UPDATE wcf1_user_group SET priority = 10 WHERE groupID = 3;
2503UPDATE wcf1_user_group SET priority = 1000 WHERE groupID = 4;
c3ab3fe0 2504UPDATE wcf1_user_group SET priority = 100 WHERE groupID = 5;
320f4a6d
MW		 2505
2506-- default 'showOnTeamPage' setting
c3ab3fe0 2507UPDATE wcf1_user_group SET showOnTeamPage = 1 WHERE groupID IN (4, 5);
320f4a6d
MW		 2508
2509-- default ranks
2510INSERT INTO wcf1_user_rank (groupID, requiredPoints, rankTitle, cssClassName) VALUES
2511 (4, 0, 'wcf.user.rank.administrator', 'blue'),
2512 (5, 0, 'wcf.user.rank.moderator', 'blue'),
320f4a6d
MW		 2513 (3, 0, 'wcf.user.rank.user0', ''),
2514 (3, 300, 'wcf.user.rank.user1', ''),
2515 (3, 900, 'wcf.user.rank.user2', ''),
2516 (3, 3000, 'wcf.user.rank.user3', ''),
2517 (3, 9000, 'wcf.user.rank.user4', ''),
861451f4 2518 (3, 15000, 'wcf.user.rank.user5', '');
d486ae88 2519
c308c947
AE		 2520-- default options: subject and message
2521INSERT INTO wcf1_contact_option (optionID, optionTitle, optionDescription, optionType, required, showOrder, originIsSystem) VALUES (1, 'wcf.contact.option1', 'wcf.contact.optionDescription1', 'text', 1, 1, 1);
2522INSERT INTO wcf1_contact_option (optionID, optionTitle, optionDescription, optionType, required, showOrder, originIsSystem) VALUES (2, 'wcf.contact.option2', '', 'textarea', 1, 1, 1);
2523
d486ae88
AE		 2524-- default recipient: site administrator
2525INSERT INTO wcf1_contact_recipient (recipientID, name, email, isAdministrator, originIsSystem) VALUES (1, 'wcf.contact.recipient.name1', '', 1, 1);
736ac5c2
JR		 2526
2527-- default reaction type
3b27fefe 2528INSERT INTO wcf1_reaction_type (reactionTypeID, title, showOrder, iconFile) VALUES (1, 'wcf.reactionType.title1', 1, 'like.svg');
06e68736
AE		 2529INSERT INTO wcf1_reaction_type (reactionTypeID, title, showOrder, iconFile) VALUES (2, 'wcf.reactionType.title2', 2, 'thanks.svg');
2530INSERT INTO wcf1_reaction_type (reactionTypeID, title, showOrder, iconFile) VALUES (3, 'wcf.reactionType.title3', 3, 'haha.svg');
3b27fefe 2531INSERT INTO wcf1_reaction_type (reactionTypeID, title, showOrder, iconFile) VALUES (4, 'wcf.reactionType.title4', 4, 'confused.svg');
06e68736 2532INSERT INTO wcf1_reaction_type (reactionTypeID, title, showOrder, iconFile) VALUES (5, 'wcf.reactionType.title5', 5, 'sad.svg');
WoltLab Suite Core (previously WoltLab Community Framework)