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