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