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