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