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