wcfsetup/setup/db/install.sql

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