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