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