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