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