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