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