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