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