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