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