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