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