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