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