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