wcfsetup/setup/db/install.sql

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