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