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