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