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(255) NOT NULL,
   8         categoryName VARCHAR(255) 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(255) 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_acp_menu_item;
  40 CREATE TABLE wcf1_acp_menu_item (
  41         menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  42         packageID INT(10) NOT NULL,
  43         menuItem VARCHAR(255) NOT NULL DEFAULT '',
  44         parentMenuItem VARCHAR(255) NOT NULL DEFAULT '',
  45         menuItemController VARCHAR(255) NOT NULL DEFAULT '',
  46         menuItemLink VARCHAR(255) NOT NULL DEFAULT '',
  47         showOrder INT(10) NOT NULL DEFAULT 0,
  48         permissions TEXT,
  49         options TEXT,
  50         UNIQUE KEY menuItem (menuItem, packageID)
  51 );
  52
  53 DROP TABLE IF EXISTS wcf1_acp_search_provider;
  54 CREATE TABLE wcf1_acp_search_provider (
  55         providerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  56         packageID INT(10) NOT NULL,
  57         providerName VARCHAR(255) NOT NULL DEFAULT '',
  58         className VARCHAR(255) NOT NULL DEFAULT '',
  59         showOrder INT(10) NOT NULL DEFAULT 0,
  60         UNIQUE KEY providerName (providerName, packageID)
  61 );
  62
  63 DROP TABLE IF EXISTS wcf1_acp_session;
  64 CREATE TABLE wcf1_acp_session (
  65         sessionID CHAR(40) NOT NULL PRIMARY KEY,
  66         userID INT(10),
  67         ipAddress VARCHAR(39) NOT NULL DEFAULT '',
  68         userAgent VARCHAR(255) NOT NULL DEFAULT '',
  69         lastActivityTime INT(10) NOT NULL DEFAULT 0,
  70         requestURI VARCHAR(255) NOT NULL DEFAULT '',
  71         requestMethod VARCHAR(7) NOT NULL DEFAULT '',
  72         controller VARCHAR(255) NOT NULL DEFAULT '',
  73         parentObjectType VARCHAR(255) NOT NULL DEFAULT '',
  74         parentObjectID INT(10) NOT NULL DEFAULT 0,
  75         objectType VARCHAR(255) NOT NULL DEFAULT '',
  76         objectID INT(10) NOT NULL DEFAULT 0,
  77         sessionVariables MEDIUMTEXT
  78 );
  79
  80 DROP TABLE IF EXISTS wcf1_acp_session_access_log;
  81 CREATE TABLE wcf1_acp_session_access_log (
  82         sessionAccessLogID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  83         sessionLogID INT(10) NOT NULL,
  84         ipAddress VARCHAR(39) NOT NULL DEFAULT '',
  85         time INT(10) NOT NULL DEFAULT 0,
  86         requestURI VARCHAR(255) NOT NULL DEFAULT '',
  87         requestMethod VARCHAR(7) NOT NULL DEFAULT '',
  88         className VARCHAR(255) NOT NULL DEFAULT '',
  89         KEY sessionLogID (sessionLogID)
  90 );
  91
  92 DROP TABLE IF EXISTS wcf1_acp_session_log;
  93 CREATE TABLE wcf1_acp_session_log (
  94         sessionLogID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  95         sessionID CHAR(40) NOT NULL DEFAULT '',
  96         userID INT(10),
  97         ipAddress VARCHAR(39) NOT NULL DEFAULT '',
  98         hostname VARCHAR(255) NOT NULL DEFAULT '',
  99         userAgent VARCHAR(255) NOT NULL DEFAULT '',
 100         time INT(10) NOT NULL DEFAULT 0,
 101         lastActivityTime INT(10) NOT NULL DEFAULT 0,
 102         KEY sessionID (sessionID)
 103 );
 104
 105 DROP TABLE IF EXISTS wcf1_acp_template;
 106 CREATE TABLE wcf1_acp_template (
 107         templateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 108         packageID INT(10),
 109         templateName VARCHAR(255) NOT NULL,
 110         application VARCHAR(20) NOT NULL,
 111         UNIQUE KEY applicationTemplate (application, templateName)
 112 );
 113
 114 DROP TABLE IF EXISTS wcf1_application;
 115 CREATE TABLE wcf1_application (
 116         packageID INT(10) NOT NULL PRIMARY KEY,
 117         domainName VARCHAR(255) NOT NULL,
 118         domainPath VARCHAR(255) NOT NULL DEFAULT '/',
 119         cookieDomain VARCHAR(255) NOT NULL,
 120         cookiePath VARCHAR(255) NOT NULL DEFAULT '/',
 121         isPrimary TINYINT(1) NOT NULL DEFAULT 0
 122 );
 123
 124 DROP TABLE IF EXISTS wcf1_attachment;
 125 CREATE TABLE wcf1_attachment (
 126         attachmentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 127         objectTypeID INT(10) NOT NULL,
 128         objectID INT(10),
 129         userID INT(10),
 130         tmpHash VARCHAR(40) NOT NULL DEFAULT '',
 131         filename VARCHAR(255) NOT NULL DEFAULT '',
 132         filesize INT(10) NOT NULL DEFAULT 0,
 133         fileType VARCHAR(255) NOT NULL DEFAULT '',
 134         fileHash VARCHAR(40) NOT NULL DEFAULT '',
 135
 136         isImage TINYINT(1) NOT NULL DEFAULT 0,
 137         width SMALLINT(5) NOT NULL DEFAULT 0,
 138         height SMALLINT(5) NOT NULL DEFAULT 0,
 139
 140         tinyThumbnailType VARCHAR(255) NOT NULL DEFAULT '',
 141         tinyThumbnailSize INT(10) NOT NULL DEFAULT 0,
 142         tinyThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0,
 143         tinyThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0,
 144
 145         thumbnailType VARCHAR(255) NOT NULL DEFAULT '',
 146         thumbnailSize INT(10) NOT NULL DEFAULT 0,
 147         thumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0,
 148         thumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0,
 149
 150         downloads INT(10) NOT NULL DEFAULT 0,
 151         lastDownloadTime INT(10) NOT NULL DEFAULT 0,
 152         uploadTime INT(10) NOT NULL DEFAULT 0,
 153         showOrder SMALLINT(5) NOT NULL DEFAULT 0,
 154         KEY (objectTypeID, objectID),
 155         KEY (objectTypeID, tmpHash),
 156         KEY (objectID, uploadTime)
 157 );
 158
 159 DROP TABLE IF EXISTS wcf1_bbcode;
 160 CREATE TABLE wcf1_bbcode (
 161         bbcodeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 162         bbcodeTag VARCHAR(255) NOT NULL,
 163         packageID INT(10) NOT NULL,
 164         htmlOpen VARCHAR(255) NOT NULL DEFAULT '',
 165         htmlClose VARCHAR(255) NOT NULL DEFAULT '',
 166         allowedChildren VARCHAR(255) NOT NULL DEFAULT 'all',
 167         className VARCHAR(255) NOT NULL DEFAULT '',
 168         wysiwygIcon varchar(255) NOT NULL DEFAULT '',
 169         buttonLabel VARCHAR(255) NOT NULL DEFAULT '',
 170         isSourceCode TINYINT(1) NOT NULL DEFAULT 0,
 171         isDisabled TINYINT(1) NOT NULL DEFAULT 0,
 172         showButton TINYINT(1) NOT NULL DEFAULT 0,
 173         UNIQUE KEY bbcodeTag (bbcodeTag)
 174 );
 175
 176 DROP TABLE IF EXISTS wcf1_bbcode_attribute;
 177 CREATE TABLE wcf1_bbcode_attribute (
 178         attributeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 179         bbcodeID INT(10) NOT NULL,
 180         attributeNo TINYINT(3) NOT NULL DEFAULT 0,
 181         attributeHtml VARCHAR(255) NOT NULL DEFAULT '',
 182         validationPattern VARCHAR(255) NOT NULL DEFAULT '',
 183         required TINYINT(1) NOT NULL DEFAULT 0,
 184         useText TINYINT(1) NOT NULL DEFAULT 0,
 185         UNIQUE KEY attributeNo (bbcodeID, attributeNo)
 186 );
 187
 188 DROP TABLE IF EXISTS wcf1_bbcode_media_provider;
 189 CREATE TABLE wcf1_bbcode_media_provider (
 190         providerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 191         title VARCHAR(255) NOT NULL,
 192         regex TEXT NOT NULL,
 193         html TEXT NOT NULL
 194 );
 195
 196 DROP TABLE IF EXISTS wcf1_category;
 197 CREATE TABLE wcf1_category (
 198         categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 199         objectTypeID INT(10) NOT NULL,
 200         parentCategoryID INT(10) NOT NULL DEFAULT 0,
 201         title VARCHAR(255) NOT NULL,
 202         description TEXT,
 203         showOrder INT(10) NOT NULL DEFAULT 0,
 204         time INT(10) NOT NULL DEFAULT 0,
 205         isDisabled TINYINT(1) NOT NULL DEFAULT 0,
 206         additionalData TEXT
 207 );
 208
 209 DROP TABLE IF EXISTS wcf1_cli_history;
 210 CREATE TABLE wcf1_cli_history (
 211         historyItem INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 212         userID INT(10) NOT NULL,
 213         command VARCHAR(255) NOT NULL,
 214         KEY (userID)
 215 );
 216
 217 DROP TABLE IF EXISTS wcf1_clipboard_action;
 218 CREATE TABLE wcf1_clipboard_action (
 219         actionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 220         packageID INT(10) NOT NULL DEFAULT 0,
 221         actionName VARCHAR(50) NOT NULL DEFAULT '',
 222         actionClassName VARCHAR(200) NOT NULL DEFAULT '',
 223         showOrder INT(10) NOT NULL DEFAULT 0,
 224         UNIQUE KEY actionName (packageID, actionName, actionClassName)
 225 );
 226
 227 DROP TABLE IF EXISTS wcf1_clipboard_item;
 228 CREATE TABLE wcf1_clipboard_item (
 229         objectTypeID INT(10) NOT NULL DEFAULT 0,
 230         userID INT(10) NOT NULL DEFAULT 0,
 231         objectID INT(10) NOT NULL DEFAULT 0,
 232         UNIQUE KEY (objectTypeID, userID, objectID)
 233 );
 234
 235 DROP TABLE IF EXISTS wcf1_clipboard_page;
 236 CREATE TABLE wcf1_clipboard_page (
 237         pageClassName VARCHAR(80) NOT NULL DEFAULT '',
 238         packageID INT(10) NOT NULL DEFAULT 0,
 239         actionID INT(10) NOT NULL DEFAULT 0
 240 );
 241
 242 DROP TABLE IF EXISTS wcf1_comment;
 243 CREATE TABLE wcf1_comment (
 244         commentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 245         objectTypeID INT(10) NOT NULL,
 246         objectID INT(10) NOT NULL,
 247         time INT(10) NOT NULL DEFAULT '0',
 248         userID INT(10),
 249         username VARCHAR(255) NOT NULL,
 250         message TEXT NOT NULL,
 251         responses MEDIUMINT(7) NOT NULL DEFAULT '0',
 252         responseIDs VARCHAR(255) NOT NULL DEFAULT '',
 253
 254         KEY (objectTypeID, objectID, time),
 255         KEY lastCommentTime (userID, time)
 256 );
 257
 258 DROP TABLE IF EXISTS wcf1_comment_response;
 259 CREATE TABLE wcf1_comment_response (
 260         responseID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 261         commentID INT(10) NOT NULL,
 262         time INT(10) NOT NULL DEFAULT '0',
 263         userID INT(10),
 264         username VARCHAR(255) NOT NULL,
 265         message TEXT NOT NULL,
 266
 267         KEY (commentID, time),
 268         KEY lastResponseTime (userID, time)
 269 );
 270
 271 DROP TABLE IF EXISTS wcf1_core_object;
 272 CREATE TABLE wcf1_core_object (
 273         objectID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 274         packageID INT(10) NOT NULL,
 275         objectName VARCHAR(255) NOT NULL DEFAULT '',
 276         UNIQUE KEY object (packageID, objectName)
 277 );
 278
 279 DROP TABLE IF EXISTS wcf1_cronjob;
 280 CREATE TABLE wcf1_cronjob (
 281         cronjobID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 282         className varchar(255) NOT NULL DEFAULT '',
 283         packageID INT(10) NOT NULL,
 284         description varchar(255) NOT NULL DEFAULT '',
 285         startMinute varchar(255) NOT NULL DEFAULT '*',
 286         startHour varchar(255) NOT NULL DEFAULT '*',
 287         startDom varchar(255) NOT NULL DEFAULT '*',
 288         startMonth varchar(255) NOT NULL DEFAULT '*',
 289         startDow varchar(255) NOT NULL DEFAULT '*',
 290         lastExec INT(10) NOT NULL DEFAULT 0,
 291         nextExec INT(10) NOT NULL DEFAULT 0,
 292         afterNextExec INT(10) NOT NULL DEFAULT 0,
 293         isDisabled TINYINT(1) NOT NULL DEFAULT 0,
 294         canBeEdited TINYINT(1) NOT NULL DEFAULT 1,
 295         canBeDisabled TINYINT(1) NOT NULL DEFAULT 1,
 296         state TINYINT(1) NOT NULL DEFAULT 0,
 297         failCount TINYINT(1) NOT NULL DEFAULT 0
 298 );
 299
 300 DROP TABLE IF EXISTS wcf1_cronjob_log;
 301 CREATE TABLE wcf1_cronjob_log (
 302         cronjobLogID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 303         cronjobID INT(10) NOT NULL,
 304         execTime INT(10) NOT NULL DEFAULT 0,
 305         success TINYINT(1) NOT NULL DEFAULT 0,
 306         error TEXT
 307 );
 308
 309 DROP TABLE IF EXISTS wcf1_dashboard_box;
 310 CREATE TABLE wcf1_dashboard_box (
 311         boxID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 312         packageID INT(10) NOT NULL,
 313         boxName VARCHAR(255) NOT NULL DEFAULT '',
 314         boxType VARCHAR(30) NOT NULL DEFAULT 'sidebar', -- can be 'content' or 'sidebar'
 315         className VARCHAR(255) NOT NULL DEFAULT ''
 316 );
 317
 318 DROP TABLE IF EXISTS wcf1_dashboard_option;
 319 CREATE TABLE wcf1_dashboard_option (
 320         objectTypeID INT(10) NOT NULL,
 321         boxID INT(10) NOT NULL,
 322         showOrder INT(10) NOT NULL,
 323         UNIQUE KEY dashboardOption (objectTypeID, boxID)
 324 );
 325
 326 DROP TABLE IF EXISTS wcf1_event_listener;
 327 CREATE TABLE wcf1_event_listener (
 328         listenerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 329         packageID INT(10) NOT NULL,
 330         environment ENUM('user', 'admin') NOT NULL DEFAULT 'user',
 331         eventClassName VARCHAR(80) NOT NULL DEFAULT '',
 332         eventName VARCHAR(50) NOT NULL DEFAULT '',
 333         listenerClassName VARCHAR(200) NOT NULL DEFAULT '',
 334         inherit TINYINT(1) NOT NULL DEFAULT 0,
 335         niceValue TINYINT(3) NOT NULL DEFAULT 0,
 336         UNIQUE KEY packageID (packageID, environment, eventClassName, eventName, listenerClassName)
 337 );
 338
 339 DROP TABLE IF EXISTS wcf1_import_mapping;
 340 CREATE TABLE wcf1_import_mapping (
 341         importHash CHAR(8) NOT NULL,
 342         objectTypeID INT(10) NOT NULL,
 343         oldID VARCHAR(255) NOT NULL,
 344         newID INT(10) NOT NULL,
 345         UNIQUE KEY (importHash, objectTypeID, oldID)
 346 );
 347
 348 DROP TABLE IF EXISTS wcf1_label;
 349 CREATE TABLE wcf1_label (
 350         labelID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 351         groupID INT(10) NOT NULL,
 352         label VARCHAR(80) NOT NULL,
 353         cssClassName VARCHAR(255) NOT NULL DEFAULT ''
 354 );
 355
 356 DROP TABLE IF EXISTS wcf1_label_group;
 357 CREATE TABLE wcf1_label_group (
 358         groupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 359         groupName VARCHAR(80) NOT NULL,
 360         forceSelection TINYINT(1) NOT NULL DEFAULT 0
 361 );
 362
 363 DROP TABLE IF EXISTS wcf1_label_group_to_object;
 364 CREATE TABLE wcf1_label_group_to_object (
 365         groupID INT(10) NOT NULL,
 366         objectTypeID INT(10) NOT NULL,
 367         objectID INT(10) NULL
 368 );
 369
 370 DROP TABLE IF EXISTS wcf1_label_object;
 371 CREATE TABLE wcf1_label_object (
 372         labelID INT(10) NOT NULL,
 373         objectTypeID INT(10) NOT NULL,
 374         objectID INT(10) NOT NULL,
 375
 376         KEY (objectTypeID, labelID),
 377         KEY (objectTypeID, objectID)
 378 );
 379
 380 DROP TABLE IF EXISTS wcf1_language;
 381 CREATE TABLE wcf1_language (
 382         languageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 383         languageCode VARCHAR(20) NOT NULL DEFAULT '',
 384         languageName VARCHAR(255) NOT NULL DEFAULT '',
 385         countryCode VARCHAR(10) NOT NULL DEFAULT '',
 386         isDefault TINYINT(1) NOT NULL DEFAULT 0,
 387         hasContent TINYINT(1) NOT NULL DEFAULT 0,
 388         UNIQUE KEY languageCode (languageCode)
 389 );
 390
 391 DROP TABLE IF EXISTS wcf1_language_category;
 392 CREATE TABLE wcf1_language_category (
 393         languageCategoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 394         languageCategory VARCHAR(255) NOT NULL DEFAULT '',
 395         UNIQUE KEY languageCategory (languageCategory)
 396 );
 397
 398 DROP TABLE IF EXISTS wcf1_language_item;
 399 CREATE TABLE wcf1_language_item (
 400         languageItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 401         languageID INT(10) NOT NULL,
 402         languageItem VARCHAR(255) NOT NULL DEFAULT '',
 403         languageItemValue MEDIUMTEXT NOT NULL,
 404         languageCustomItemValue MEDIUMTEXT,
 405         languageUseCustomValue TINYINT(1) NOT NULL DEFAULT 0,
 406         languageItemOriginIsSystem TINYINT(1) NOT NULL DEFAULT 1,
 407         languageCategoryID INT(10) NOT NULL,
 408         packageID INT(10),
 409         UNIQUE KEY languageItem (languageItem, languageID),
 410         KEY languageItemOriginIsSystem (languageItemOriginIsSystem)
 411 );
 412
 413 DROP TABLE IF EXISTS wcf1_language_server;
 414 CREATE TABLE wcf1_language_server (
 415         languageServerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 416         serverURL VARCHAR(255) NOT NULL DEFAULT '',
 417         isDisabled TINYINT(1) NOT NULL DEFAULT 0
 418 );
 419
 420 DROP TABLE IF EXISTS wcf1_like;
 421 CREATE TABLE wcf1_like (
 422         likeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 423         objectID INT(10) NOT NULL DEFAULT 0,
 424         objectTypeID INT(10) NOT NULL,
 425         objectUserID INT(10),
 426         userID INT(10) NOT NULL,
 427         time INT(10) NOT NULL DEFAULT 0,
 428         likeValue TINYINT(1) NOT NULL DEFAULT 1,
 429         UNIQUE KEY (objectTypeID, objectID, userID)
 430 );
 431
 432 DROP TABLE IF EXISTS wcf1_like_object;
 433 CREATE TABLE wcf1_like_object (
 434         likeObjectID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 435         objectTypeID INT(10) NOT NULL,
 436         objectID INT(10) NOT NULL DEFAULT 0,
 437         objectUserID INT(10),
 438         likes MEDIUMINT(7) NOT NULL DEFAULT 0,
 439         dislikes MEDIUMINT(7) NOT NULL DEFAULT 0,
 440         cumulativeLikes MEDIUMINT(7) NOT NULL DEFAULT 0,
 441         cachedUsers TEXT,
 442         UNIQUE KEY (objectTypeID, objectID)
 443 );
 444
 445 DROP TABLE IF EXISTS wcf1_moderation_queue;
 446 CREATE TABLE wcf1_moderation_queue (
 447         queueID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 448         objectTypeID INT(10) NOT NULL,
 449         objectID INT(10) NOT NULL,
 450         containerID INT(10) NOT NULL DEFAULT 0,
 451         userID INT(10) NULL,
 452         time INT(10) NOT NULL DEFAULT 0,
 453
 454         -- internal
 455         assignedUserID INT(10) NULL,
 456         status TINYINT(1) NOT NULL DEFAULT 0,
 457         comment TEXT,
 458         lastChangeTime INT(10) NOT NULL DEFAULT 0,
 459
 460         -- additional data, e.g. message if reporting content
 461         additionalData TEXT,
 462
 463         UNIQUE KEY affectedObject (objectTypeID, objectID)
 464 );
 465
 466 DROP TABLE IF EXISTS wcf1_moderation_queue_to_user;
 467 CREATE TABLE wcf1_moderation_queue_to_user (
 468         queueID INT(10) NOT NULL,
 469         userID INT(10) NOT NULL,
 470         isAffected TINYINT(1) NOT NULL DEFAULT 0,
 471
 472         UNIQUE KEY queue (queueID, userID),
 473         KEY affected (queueID, userID, isAffected)
 474 );
 475
 476 DROP TABLE IF EXISTS wcf1_modification_log;
 477 CREATE TABLE wcf1_modification_log (
 478         logID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 479         objectTypeID INT(10) NOT NULL,
 480         objectID INT(10) NOT NULL,
 481         userID INT(10),
 482         username VARCHAR(255) NOT NULL DEFAULT '',
 483         time INT(10) NOT NULL DEFAULT 0,
 484         action VARCHAR(80) NOT NULL,
 485         additionalData MEDIUMTEXT
 486 );
 487
 488 DROP TABLE IF EXISTS wcf1_object_type;
 489 CREATE TABLE wcf1_object_type (
 490         objectTypeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 491         definitionID INT(10) NOT NULL,
 492         packageID INT(10) NOT NULL,
 493         objectType VARCHAR(255) NOT NULL,
 494         className VARCHAR(255) NOT NULL DEFAULT '',
 495         additionalData MEDIUMTEXT,
 496         UNIQUE KEY objectType (objectType, definitionID, packageID)
 497 );
 498
 499 DROP TABLE IF EXISTS wcf1_object_type_definition;
 500 CREATE TABLE wcf1_object_type_definition (
 501         definitionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 502         definitionName VARCHAR(255) NOT NULL,
 503         packageID INT(10) NOT NULL,
 504         interfaceName VARCHAR(255) NOT NULL DEFAULT '',
 505         categoryName VARCHAR(80) NOT NULL DEFAULT '',
 506         UNIQUE KEY definitionName (definitionName)
 507 );
 508
 509 DROP TABLE IF EXISTS wcf1_option;
 510 CREATE TABLE wcf1_option (
 511         optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 512         packageID INT(10) NOT NULL,
 513         optionName VARCHAR(255) NOT NULL DEFAULT '',
 514         categoryName VARCHAR(255) NOT NULL DEFAULT '',
 515         optionType VARCHAR(255) NOT NULL DEFAULT '',
 516         optionValue MEDIUMTEXT,
 517         validationPattern TEXT,
 518         selectOptions MEDIUMTEXT,
 519         enableOptions MEDIUMTEXT,
 520         showOrder INT(10) NOT NULL DEFAULT 0,
 521         hidden TINYINT(1) NOT NULL DEFAULT 0,
 522         permissions TEXT,
 523         options TEXT,
 524         supportI18n TINYINT(1) NOT NULL DEFAULT 0,
 525         requireI18n TINYINT(1) NOT NULL DEFAULT 0,
 526         additionalData MEDIUMTEXT,
 527
 528         UNIQUE KEY optionName (optionName)
 529 );
 530
 531 DROP TABLE IF EXISTS wcf1_option_category;
 532 CREATE TABLE wcf1_option_category (
 533         categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 534         packageID INT(10) NOT NULL,
 535         categoryName VARCHAR(255) NOT NULL DEFAULT '',
 536         parentCategoryName VARCHAR(255) NOT NULL DEFAULT '',
 537         showOrder INT(10) NOT NULL DEFAULT 0,
 538         permissions TEXT,
 539         options TEXT,
 540         UNIQUE KEY categoryName (categoryName)
 541 );
 542
 543 DROP TABLE IF EXISTS wcf1_package;
 544 CREATE TABLE wcf1_package (
 545         packageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 546         package VARCHAR(255) NOT NULL DEFAULT '',
 547         packageDir VARCHAR(255) NOT NULL DEFAULT '',
 548         packageName VARCHAR(255) NOT NULL DEFAULT '',
 549         packageDescription VARCHAR(255) NOT NULL DEFAULT '',
 550         packageVersion VARCHAR(255) NOT NULL DEFAULT '',
 551         packageDate INT(10) NOT NULL DEFAULT 0,
 552         installDate INT(10) NOT NULL DEFAULT 0,
 553         updateDate INT(10) NOT NULL DEFAULT 0,
 554         packageURL VARCHAR(255) NOT NULL DEFAULT '',
 555         isApplication TINYINT(1) NOT NULL DEFAULT 0,
 556         author VARCHAR(255) NOT NULL DEFAULT '',
 557         authorURL VARCHAR(255) NOT NULL DEFAULT '',
 558         KEY package (package)
 559 );
 560
 561 DROP TABLE IF EXISTS wcf1_package_exclusion;
 562 CREATE TABLE wcf1_package_exclusion (
 563         packageID INT(10) NOT NULL,
 564         excludedPackage VARCHAR(255) NOT NULL DEFAULT '',
 565         excludedPackageVersion VARCHAR(255) NOT NULL DEFAULT '',
 566         UNIQUE KEY packageID (packageID, excludedPackage)
 567 );
 568
 569 DROP TABLE IF EXISTS wcf1_package_installation_file_log;
 570 CREATE TABLE wcf1_package_installation_file_log (
 571         packageID INT(10),
 572         filename VARCHAR(255) NOT NULL,
 573         application VARCHAR(20) NOT NULL,
 574         UNIQUE KEY applicationFile (application, filename)
 575 );
 576
 577 DROP TABLE IF EXISTS wcf1_package_installation_form;
 578 CREATE TABLE wcf1_package_installation_form (
 579         queueID INT(10) NOT NULL,
 580         formName VARCHAR(80) NOT NULL DEFAULT '',
 581         document TEXT NOT NULL,
 582         UNIQUE KEY formDocument (queueID, formName)
 583 );
 584
 585 DROP TABLE IF EXISTS wcf1_package_installation_node;
 586 CREATE TABLE wcf1_package_installation_node (
 587         queueID INT(10) NOT NULL,
 588         processNo INT(10) NOT NULL DEFAULT 0,
 589         sequenceNo SMALLINT(4) NOT NULL DEFAULT 0,
 590         node CHAR(8) NOT NULL DEFAULT '',
 591         parentNode CHAR(8) NOT NULL DEFAULT '',
 592         nodeType ENUM('optionalPackages','package', 'pip') NOT NULL DEFAULT 'package',
 593         nodeData TEXT NOT NULL,
 594         done TINYINT(1) NOT NULL DEFAULT 0
 595 );
 596
 597 DROP TABLE IF EXISTS wcf1_package_installation_plugin;
 598 CREATE TABLE wcf1_package_installation_plugin (
 599         pluginName VARCHAR(255) NOT NULL PRIMARY KEY,
 600         packageID INT(10),
 601         priority TINYINT(1) NOT NULL DEFAULT 0,
 602         className VARCHAR(255) NOT NULL
 603 );
 604
 605 DROP TABLE IF EXISTS wcf1_package_installation_queue;
 606 CREATE TABLE wcf1_package_installation_queue (
 607         queueID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 608         parentQueueID INT(10) NOT NULL DEFAULT 0,
 609         processNo INT(10) NOT NULL DEFAULT 0,
 610         userID INT(10) NOT NULL,
 611         package VARCHAR(255) NOT NULL DEFAULT '',
 612         packageName VARCHAR(255) NOT NULL DEFAULT '',
 613         packageID INT(10),
 614         archive VARCHAR(255) NOT NULL DEFAULT '',
 615         action ENUM('install', 'update', 'uninstall') NOT NULL DEFAULT 'install',
 616         done TINYINT(1) NOT NULL DEFAULT 0,
 617         isApplication TINYINT(1) NOT NULL DEFAULT 0
 618 );
 619
 620 DROP TABLE IF EXISTS wcf1_package_installation_sql_log;
 621 CREATE TABLE wcf1_package_installation_sql_log (
 622         packageID INT(10),
 623         sqlTable VARCHAR(100) NOT NULL DEFAULT '',
 624         sqlColumn VARCHAR(100) NOT NULL DEFAULT '',
 625         sqlIndex VARCHAR(100) NOT NULL DEFAULT '',
 626         UNIQUE KEY packageID (packageID, sqlTable, sqlColumn, sqlIndex)
 627 );
 628
 629 /* SQL_PARSER_OFFSET */
 630
 631 DROP TABLE IF EXISTS wcf1_package_requirement;
 632 CREATE TABLE wcf1_package_requirement (
 633         packageID INT(10) NOT NULL,
 634         requirement INT(10) NOT NULL,
 635         UNIQUE KEY packageID (packageID, requirement)
 636 );
 637
 638 DROP TABLE IF EXISTS wcf1_package_update;
 639 CREATE TABLE wcf1_package_update (
 640         packageUpdateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 641         packageUpdateServerID INT(10) NOT NULL,
 642         package VARCHAR(255) NOT NULL DEFAULT '',
 643         packageName VARCHAR(255) NOT NULL DEFAULT '',
 644         packageDescription VARCHAR(255) NOT NULL DEFAULT '',
 645         author VARCHAR(255) NOT NULL DEFAULT '',
 646         authorURL VARCHAR(255) NOT NULL DEFAULT '',
 647         isApplication TINYINT(1) NOT NULL DEFAULT 0,
 648         UNIQUE KEY packageUpdateServerID (packageUpdateServerID, package)
 649 );
 650
 651 DROP TABLE IF EXISTS wcf1_package_update_exclusion;
 652 CREATE TABLE wcf1_package_update_exclusion (
 653         packageUpdateVersionID INT(10) NOT NULL,
 654         excludedPackage VARCHAR(255) NOT NULL DEFAULT '',
 655         excludedPackageVersion VARCHAR(255) NOT NULL DEFAULT '',
 656         UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, excludedPackage)
 657 );
 658
 659 DROP TABLE IF EXISTS wcf1_package_update_fromversion;
 660 CREATE TABLE wcf1_package_update_fromversion (
 661         packageUpdateVersionID INT(10) NOT NULL DEFAULT 0,
 662         fromversion VARCHAR(50) NOT NULL DEFAULT '',
 663         UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, fromversion)
 664 );
 665
 666 DROP TABLE IF EXISTS wcf1_package_update_optional;
 667 CREATE TABLE wcf1_package_update_optional (
 668         packageUpdateVersionID INT(10) NOT NULL DEFAULT 0,
 669         package VARCHAR(255) NOT NULL DEFAULT ''
 670 );
 671
 672 DROP TABLE IF EXISTS wcf1_package_update_requirement;
 673 CREATE TABLE wcf1_package_update_requirement (
 674         packageUpdateVersionID INT(10) NOT NULL,
 675         package VARCHAR(255) NOT NULL DEFAULT '',
 676         minversion VARCHAR(50) NOT NULL DEFAULT '',
 677         UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, package)
 678 );
 679
 680 DROP TABLE IF EXISTS wcf1_package_update_server;
 681 CREATE TABLE wcf1_package_update_server (
 682         packageUpdateServerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 683         serverURL VARCHAR(255) NOT NULL DEFAULT '',
 684         loginUsername VARCHAR(255) NOT NULL DEFAULT '',
 685         loginPassword VARCHAR(255) NOT NULL DEFAULT '',
 686         isDisabled TINYINT(1) NOT NULL DEFAULT 0,
 687         lastUpdateTime INT(10) NOT NULL DEFAULT 0,
 688         status ENUM('online', 'offline') NOT NULL DEFAULT 'online',
 689         errorMessage TEXT
 690 );
 691
 692 DROP TABLE IF EXISTS wcf1_package_update_version;
 693 CREATE TABLE wcf1_package_update_version (
 694         packageUpdateVersionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 695         packageUpdateID INT(10) NOT NULL,
 696         packageVersion VARCHAR(50) NOT NULL DEFAULT '',
 697         packageDate INT(10) NOT NULL DEFAULT 0,
 698         filename VARCHAR(255) NOT NULL DEFAULT '',
 699         license VARCHAR(255) NOT NULL DEFAULT '',
 700         licenseURL VARCHAR(255) NOT NULL DEFAULT '',
 701         isAccessible TINYINT(1) NOT NULL DEFAULT 1,
 702         isCritical TINYINT(1) NOT NULL DEFAULT 0,
 703         UNIQUE KEY packageUpdateID (packageUpdateID, packageVersion)
 704 );
 705
 706 DROP TABLE IF EXISTS wcf1_page_menu_item;
 707 CREATE TABLE wcf1_page_menu_item (
 708         menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 709         packageID INT(10) NOT NULL,
 710         menuItem VARCHAR(255) NOT NULL DEFAULT '',
 711         parentMenuItem VARCHAR(255) NOT NULL DEFAULT '',
 712         menuItemController VARCHAR(255) NOT NULL DEFAULT '',
 713         menuItemLink VARCHAR(255) NOT NULL DEFAULT '',
 714         menuPosition ENUM('header', 'footer') NOT NULL DEFAULT 'header',
 715         showOrder INT(10) NOT NULL DEFAULT 0,
 716         permissions TEXT NULL,
 717         options TEXT NULL,
 718         isDisabled TINYINT(1) NOT NULL DEFAULT 0,
 719         className VARCHAR(255) NOT NULL DEFAULT '',
 720         isLandingPage TINYINT(1) NOT NULL DEFAULT 0,
 721         UNIQUE KEY (packageID, menuItem)
 722 );
 723
 724 DROP TABLE IF EXISTS wcf1_poll;
 725 CREATE TABLE wcf1_poll (
 726         pollID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 727         objectTypeID INT(10) NOT NULL,
 728         objectID INT(10) NOT NULL DEFAULT 0,
 729         question VARCHAR(255) DEFAULT '',
 730         time INT(10) NOT NULL DEFAULT 0,
 731         endTime INT(10) NOT NULL DEFAULT 0,
 732         isChangeable TINYINT(1) NOT NULL DEFAULT 0,
 733         isPublic TINYINT(1) NOT NULL DEFAULT 0,
 734         sortByVotes TINYINT(1) NOT NULL DEFAULT 0,
 735         resultsRequireVote TINYINT(1) NOT NULL DEFAULT 0,
 736         maxVotes INT(10) NOT NULL DEFAULT 1,
 737         votes INT(10) NOT NULL DEFAULT 0
 738 );
 739
 740 DROP TABLE IF EXISTS wcf1_poll_option;
 741 CREATE TABLE wcf1_poll_option (
 742         optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 743         pollID INT(10) NOT NULL,
 744         optionValue VARCHAR(255) NOT NULL DEFAULT '',
 745         votes INT(10) NOT NULL DEFAULT 0,
 746         showOrder INT(10) NOT NULL DEFAULT 0
 747 );
 748
 749 DROP TABLE IF EXISTS wcf1_poll_option_vote;
 750 CREATE TABLE wcf1_poll_option_vote (
 751         pollID INT(10) NOT NULL,
 752         optionID INT(10) NOT NULL,
 753         userID INT(10) NOT NULL,
 754
 755         KEY (optionID, userID),
 756         UNIQUE KEY vote (pollID, optionID, userID)
 757 );
 758
 759 DROP TABLE IF EXISTS wcf1_search;
 760 CREATE TABLE wcf1_search (
 761         searchID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 762         userID INT(10),
 763         searchData MEDIUMTEXT NOT NULL,
 764         searchTime INT(10) NOT NULL DEFAULT 0,
 765         searchType VARCHAR(255) NOT NULL DEFAULT '',
 766         searchHash CHAR(40) NOT NULL DEFAULT '',
 767         KEY searchHash (searchHash)
 768 );
 769
 770 DROP TABLE IF EXISTS wcf1_search_index;
 771 CREATE TABLE wcf1_search_index (
 772         objectTypeID INT(10) NOT NULL,
 773         objectID INT(10) NOT NULL,
 774         subject VARCHAR(255) NOT NULL DEFAULT '',
 775         message MEDIUMTEXT,
 776         metaData MEDIUMTEXT,
 777         time INT(10) NOT NULL DEFAULT 0,
 778         userID INT(10),
 779         username VARCHAR(255) NOT NULL DEFAULT '',
 780         languageID INT(10) NOT NULL DEFAULT 0,
 781         UNIQUE KEY (objectTypeID, objectID, languageID),
 782         FULLTEXT INDEX fulltextIndex (subject, message, metaData),
 783         FULLTEXT INDEX fulltextIndexSubjectOnly (subject),
 784         KEY (userID, objectTypeID, time),
 785         KEY (objectTypeID)
 786 );
 787
 788 DROP TABLE IF EXISTS wcf1_search_keyword;
 789 CREATE TABLE wcf1_search_keyword (
 790         keywordID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 791         keyword VARCHAR(255) NOT NULL,
 792         searches INT(10) NOT NULL DEFAULT 0,
 793         lastSearchTime INT(10) NOT NULL DEFAULT 0,
 794         UNIQUE KEY (keyword),
 795         KEY (searches, lastSearchTime)
 796 );
 797
 798 DROP TABLE IF EXISTS wcf1_session;
 799 CREATE TABLE wcf1_session (
 800         sessionID CHAR(40) NOT NULL PRIMARY KEY,
 801         userID INT(10),
 802         ipAddress VARCHAR(39) NOT NULL DEFAULT '',
 803         userAgent VARCHAR(255) NOT NULL DEFAULT '',
 804         lastActivityTime INT(10) NOT NULL DEFAULT 0,
 805         requestURI VARCHAR(255) NOT NULL DEFAULT '',
 806         requestMethod VARCHAR(7) NOT NULL DEFAULT '',
 807         controller VARCHAR(255) NOT NULL DEFAULT '',
 808         parentObjectType VARCHAR(255) NOT NULL DEFAULT '',
 809         parentObjectID INT(10) NOT NULL DEFAULT 0,
 810         objectType VARCHAR(255) NOT NULL DEFAULT '',
 811         objectID INT(10) NOT NULL DEFAULT 0,
 812         sessionVariables MEDIUMTEXT,
 813         spiderID INT(10),
 814         KEY packageID (lastActivityTime, spiderID)
 815 );
 816
 817 DROP TABLE IF EXISTS wcf1_sitemap;
 818 CREATE TABLE wcf1_sitemap (
 819         sitemapID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 820         packageID INT(10) NOT NULL,
 821         sitemapName VARCHAR(80) NOT NULL DEFAULT '',
 822         className VARCHAR(255) NOT NULL DEFAULT '',
 823         showOrder INT(10) NOT NULL DEFAULT 0,
 824         UNIQUE KEY sitemapName (packageID, sitemapName)
 825 );
 826
 827 DROP TABLE IF EXISTS wcf1_smiley;
 828 CREATE TABLE wcf1_smiley (
 829         smileyID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 830         packageID INT(10) NOT NULL,
 831         categoryID INT(10),
 832         smileyPath VARCHAR(255) NOT NULL DEFAULT '',
 833         smileyTitle VARCHAR(255) NOT NULL DEFAULT '',
 834         smileyCode VARCHAR(255) NOT NULL DEFAULT '',
 835         aliases TEXT NOT NULL,
 836         showOrder INT(10) NOT NULL DEFAULT 0,
 837         UNIQUE KEY smileyCode (smileyCode)
 838 );
 839
 840 DROP TABLE IF EXISTS wcf1_spider;
 841 CREATE TABLE wcf1_spider (
 842         spiderID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 843         spiderIdentifier VARCHAR(255) DEFAULT '',
 844         spiderName VARCHAR(255) DEFAULT '',
 845         spiderURL VARCHAR(255) DEFAULT '',
 846         UNIQUE KEY spiderIdentifier (spiderIdentifier)
 847 );
 848
 849 DROP TABLE IF EXISTS wcf1_style;
 850 CREATE TABLE wcf1_style (
 851         styleID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 852         packageID INT(10) NOT NULL,
 853         styleName VARCHAR(255) NOT NULL DEFAULT '',
 854         templateGroupID INT(10) NOT NULL DEFAULT 0,
 855         isDefault TINYINT(1) NOT NULL DEFAULT 0,
 856         isDisabled TINYINT(1) NOT NULL DEFAULT 0,
 857         styleDescription VARCHAR(30) NOT NULL DEFAULT '',
 858         styleVersion VARCHAR(255) NOT NULL DEFAULT '',
 859         styleDate CHAR(10) NOT NULL DEFAULT '0000-00-00',
 860         image VARCHAR(255) NOT NULL DEFAULT '',
 861         copyright VARCHAR(255) NOT NULL DEFAULT '',
 862         license VARCHAR(255) NOT NULL DEFAULT '',
 863         authorName VARCHAR(255) NOT NULL DEFAULT '',
 864         authorURL VARCHAR(255) NOT NULL DEFAULT '',
 865         imagePath VARCHAR(255) NOT NULL DEFAULT ''
 866 );
 867
 868 DROP TABLE IF EXISTS wcf1_style_variable;
 869 CREATE TABLE wcf1_style_variable (
 870         variableID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 871         variableName VARCHAR(50) NOT NULL,
 872         defaultValue MEDIUMTEXT,
 873         UNIQUE KEY variableName (variableName)
 874 );
 875
 876 DROP TABLE IF EXISTS wcf1_style_variable_value;
 877 CREATE TABLE wcf1_style_variable_value (
 878         styleID INT(10) NOT NULL,
 879         variableID INT(10) NOT NULL,
 880         variableValue MEDIUMTEXT,
 881         UNIQUE KEY (styleID, variableID)
 882 );
 883
 884 DROP TABLE IF EXISTS wcf1_tag;
 885 CREATE TABLE wcf1_tag (
 886         tagID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 887         languageID INT(10) NOT NULL DEFAULT 0,
 888         name VARCHAR(255) NOT NULL,
 889         synonymFor INT(10),
 890         UNIQUE KEY (languageID, name)
 891 );
 892
 893 DROP TABLE IF EXISTS wcf1_tag_to_object;
 894 CREATE TABLE wcf1_tag_to_object (
 895         objectID INT(10) NOT NULL,
 896         tagID INT(10) NOT NULL,
 897         objectTypeID INT(10) NOT NULL,
 898         languageID INT(10) NOT NULL,
 899         UNIQUE KEY (objectTypeID, languageID, objectID, tagID),
 900         KEY (objectTypeID, languageID, tagID),
 901         KEY (tagID, objectTypeID)
 902 );
 903
 904 DROP TABLE IF EXISTS wcf1_template;
 905 CREATE TABLE wcf1_template (
 906         templateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 907         packageID INT(10) NOT NULL,
 908         templateName VARCHAR(255) NOT NULL,
 909         application VARCHAR(20) NOT NULL,
 910         templateGroupID INT(10),
 911         lastModificationTime INT(10) NOT NULL DEFAULT 0,
 912         UNIQUE KEY applicationTemplate (application, templateGroupID, templateName),
 913         KEY templateGroupID (packageID, templateGroupID, templateName)
 914 );
 915
 916 DROP TABLE IF EXISTS wcf1_template_group;
 917 CREATE TABLE wcf1_template_group (
 918         templateGroupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 919         parentTemplateGroupID INT(10),
 920         templateGroupName VARCHAR(255) NOT NULL DEFAULT '',
 921         templateGroupFolderName VARCHAR(255) NOT NULL DEFAULT ''
 922 );
 923
 924 DROP TABLE IF EXISTS wcf1_template_listener;
 925 CREATE TABLE wcf1_template_listener (
 926         listenerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 927         packageID INT(10) NOT NULL,
 928         name VARCHAR(80) NOT NULL DEFAULT '',
 929         environment ENUM('user','admin') NOT NULL DEFAULT 'user',
 930         templateName VARCHAR(80) NOT NULL DEFAULT '',
 931         eventName VARCHAR(50) NOT NULL DEFAULT '',
 932         templateCode TEXT NOT NULL,
 933         KEY templateName (environment, templateName)
 934 );
 935
 936 DROP TABLE IF EXISTS wcf1_tracked_visit;
 937 CREATE TABLE wcf1_tracked_visit (
 938         objectTypeID INT(10) NOT NULL,
 939         objectID INT(10) NOT NULL,
 940         userID INT(10) NOT NULL,
 941         visitTime INT(10) NOT NULL DEFAULT 0,
 942         UNIQUE KEY (objectTypeID, objectID, userID),
 943         KEY (userID, visitTime)
 944 );
 945
 946 DROP TABLE IF EXISTS wcf1_tracked_visit_type;
 947 CREATE TABLE wcf1_tracked_visit_type (
 948         objectTypeID INT(10) NOT NULL,
 949         userID INT(10) NOT NULL,
 950         visitTime INT(10) NOT NULL DEFAULT 0,
 951         UNIQUE KEY (objectTypeID, userID),
 952         KEY (userID, visitTime)
 953 );
 954
 955 DROP TABLE IF EXISTS wcf1_user;
 956 CREATE TABLE wcf1_user (
 957         userID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 958         username VARCHAR(255) NOT NULL DEFAULT '',
 959         email VARCHAR(255) NOT NULL DEFAULT '',
 960         password VARCHAR(100) NOT NULL DEFAULT '',
 961         accessToken CHAR(40) NOT NULL DEFAULT '',
 962         languageID INT(10) NOT NULL DEFAULT 0,
 963         registrationDate INT(10) NOT NULL DEFAULT 0,
 964         styleID INT(10) NOT NULL DEFAULT 0,
 965         banned TINYINT(1) NOT NULL DEFAULT 0,
 966         banReason MEDIUMTEXT NULL,
 967         activationCode INT(10) NOT NULL DEFAULT 0,
 968         lastLostPasswordRequestTime INT(10) NOT NULL DEFAULT 0,
 969         lostPasswordKey VARCHAR(40) NOT NULL DEFAULT '',
 970         lastUsernameChange INT(10) NOT NULL DEFAULT 0,
 971         newEmail VARCHAR(255) NOT NULL DEFAULT '',
 972         oldUsername VARCHAR(255) NOT NULL DEFAULT '',
 973         quitStarted INT(10) NOT NULL DEFAULT 0,
 974         reactivationCode INT(10) NOT NULL DEFAULT 0,
 975         registrationIpAddress VARCHAR(39) NOT NULL DEFAULT '',
 976         avatarID INT(10),
 977         disableAvatar TINYINT(1) NOT NULL DEFAULT 0,
 978         disableAvatarReason TEXT,
 979         enableGravatar TINYINT(1) NOT NULL DEFAULT 0,
 980         signature TEXT,
 981         signatureEnableBBCodes TINYINT(1) NOT NULL DEFAULT 1,
 982         signatureEnableHtml TINYINT(1) NOT NULL DEFAULT 0,
 983         signatureEnableSmilies TINYINT(1) NOT NULL DEFAULT 1,
 984         disableSignature TINYINT(1) NOT NULL DEFAULT 0,
 985         disableSignatureReason TEXT,
 986         lastActivityTime INT(10) NOT NULL DEFAULT 0,
 987         profileHits INT(10) NOT NULL DEFAULT 0,
 988         rankID INT(10),
 989         userTitle VARCHAR(255) NOT NULL DEFAULT '',
 990         userOnlineGroupID INT(10),
 991         activityPoints INT(10) NOT NULL DEFAULT 0,
 992         notificationMailToken VARCHAR(20) NOT NULL DEFAULT '',
 993         authData VARCHAR(255) NOT NULL DEFAULT '',
 994         likesReceived MEDIUMINT(7) NOT NULL DEFAULT 0,
 995
 996         KEY username (username),
 997         KEY registrationDate (registrationDate),
 998         KEY styleID (styleID),
 999         KEY activationCode (activationCode),
1000         KEY registrationData (registrationIpAddress, registrationDate),
1001         KEY activityPoints (activityPoints),
1002         KEY likesReceived (likesReceived)
1003 );
1004
1005 DROP TABLE IF EXISTS wcf1_user_activity_event;
1006 CREATE TABLE wcf1_user_activity_event (
1007         eventID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1008         objectTypeID INT(10) NOT NULL,
1009         objectID INT(10) NOT NULL,
1010         languageID INT(10),
1011         userID INT(10) NOT NULL,
1012         time INT(10) NOT NULL,
1013         additionalData TEXT,
1014
1015         KEY (time),
1016         KEY (userID, time),
1017         KEY (objectTypeID, objectID)
1018 );
1019
1020 DROP TABLE IF EXISTS wcf1_user_activity_point;
1021 CREATE TABLE wcf1_user_activity_point (
1022         userID INT(10) NOT NULL,
1023         objectTypeID INT(10) NOT NULL,
1024         activityPoints INT(10) NOT NULL DEFAULT 0,
1025         items INT(10) NOT NULL DEFAULT 0,
1026         PRIMARY KEY (userID, objectTypeID),
1027         KEY (objectTypeID)
1028 );
1029
1030 DROP TABLE IF EXISTS wcf1_user_avatar;
1031 CREATE TABLE wcf1_user_avatar (
1032         avatarID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1033         avatarName VARCHAR(255) NOT NULL DEFAULT '',
1034         avatarExtension VARCHAR(7) NOT NULL DEFAULT '',
1035         width SMALLINT(5) NOT NULL DEFAULT 0,
1036         height SMALLINT(5) NOT NULL DEFAULT 0,
1037         userID INT(10),
1038         fileHash VARCHAR(40) NOT NULL DEFAULT '',
1039         cropX SMALLINT(5) NOT NULL DEFAULT 0,
1040         cropY SMALLINT(5) NOT NULL DEFAULT 0
1041 );
1042
1043 DROP TABLE IF EXISTS wcf1_user_collapsible_content;
1044 CREATE TABLE wcf1_user_collapsible_content (
1045         objectTypeID INT(10) NOT NULL,
1046         objectID VARCHAR(255) NOT NULL,
1047         userID INT(10) NOT NULL,
1048         UNIQUE KEY (objectTypeID, objectID, userID)
1049 );
1050
1051 DROP TABLE IF EXISTS wcf1_user_follow;
1052 CREATE TABLE wcf1_user_follow (
1053         followID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1054         userID INT(10) NOT NULL,
1055         followUserID INT(10) NOT NULL,
1056         time INT(10) NOT NULL DEFAULT 0,
1057         UNIQUE KEY (userID, followUserID)
1058 );
1059
1060 DROP TABLE IF EXISTS wcf1_user_group;
1061 CREATE TABLE wcf1_user_group (
1062         groupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1063         groupName VARCHAR(255) NOT NULL DEFAULT '',
1064         groupDescription TEXT,
1065         groupType TINYINT(1) NOT NULL DEFAULT 4,
1066         priority MEDIUMINT(8) NOT NULL DEFAULT 0,
1067         userOnlineMarking VARCHAR(255) NOT NULL DEFAULT '%s',
1068         showOnTeamPage TINYINT(1) NOT NULL DEFAULT 0
1069 );
1070
1071 DROP TABLE IF EXISTS wcf1_user_group_option;
1072 CREATE TABLE wcf1_user_group_option (
1073         optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1074         packageID INT(10),
1075         optionName VARCHAR(255) NOT NULL DEFAULT '',
1076         categoryName VARCHAR(255) NOT NULL DEFAULT '',
1077         optionType VARCHAR(255) NOT NULL DEFAULT '',
1078         defaultValue MEDIUMTEXT,
1079         validationPattern TEXT,
1080         enableOptions MEDIUMTEXT,
1081         showOrder INT(10) NOT NULL DEFAULT 0,
1082         permissions TEXT,
1083         options TEXT,
1084         additionalData MEDIUMTEXT,
1085         UNIQUE KEY optionName (optionName, packageID)
1086 );
1087
1088 DROP TABLE IF EXISTS wcf1_user_group_option_category;
1089 CREATE TABLE wcf1_user_group_option_category (
1090         categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1091         packageID INT(10) NOT NULL,
1092         categoryName VARCHAR(255) NOT NULL DEFAULT '',
1093         parentCategoryName VARCHAR(255) NOT NULL DEFAULT '',
1094         showOrder INT(10) NOT NULL DEFAULT 0,
1095         permissions TEXT,
1096         options TEXT,
1097         UNIQUE KEY categoryName (categoryName)
1098 );
1099
1100 DROP TABLE IF EXISTS wcf1_user_group_option_value;
1101 CREATE TABLE wcf1_user_group_option_value (
1102         groupID INT(10) NOT NULL,
1103         optionID INT(10) NOT NULL,
1104         optionValue MEDIUMTEXT NOT NULL,
1105         UNIQUE KEY groupID (groupID, optionID)
1106 );
1107
1108 DROP TABLE IF EXISTS wcf1_user_ignore;
1109 CREATE TABLE wcf1_user_ignore (
1110         ignoreID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1111         userID INT(10) NOT NULL,
1112         ignoreUserID INT(10) NOT NULL,
1113         time INT(10) NOT NULL DEFAULT 0,
1114         UNIQUE KEY (userID, ignoreUserID)
1115 );
1116
1117 DROP TABLE IF EXISTS wcf1_user_menu_item;
1118 CREATE TABLE wcf1_user_menu_item (
1119         menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1120         packageID INT(10) NOT NULL,
1121         menuItem VARCHAR(255) NOT NULL DEFAULT '',
1122         parentMenuItem VARCHAR(255) NOT NULL DEFAULT '',
1123         menuItemController VARCHAR(255) NOT NULL DEFAULT '',
1124         menuItemLink VARCHAR(255) NOT NULL DEFAULT '',
1125         showOrder INT(10) NOT NULL DEFAULT 0,
1126         permissions TEXT,
1127         options TEXT,
1128         className VARCHAR(255) NOT NULL DEFAULT '',
1129         UNIQUE KEY menuItem (menuItem, packageID)
1130 );
1131
1132 -- notifications
1133 DROP TABLE IF EXISTS wcf1_user_notification;
1134 CREATE TABLE wcf1_user_notification (
1135         notificationID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1136         packageID INT(10) NOT NULL,
1137         eventID INT(10) NOT NULL,
1138         objectID INT(10) NOT NULL DEFAULT 0,
1139         eventHash VARCHAR(40) NOT NULL DEFAULT '',
1140         authorID INT(10),
1141         time INT(10) NOT NULL DEFAULT 0,
1142         additionalData TEXT,
1143         KEY (eventHash),
1144         UNIQUE KEY (packageID, eventID, objectID)
1145 );
1146
1147 -- notification recipients
1148 DROP TABLE IF EXISTS wcf1_user_notification_to_user;
1149 CREATE TABLE wcf1_user_notification_to_user (
1150         notificationID INT(10) NOT NULL,
1151         userID INT(10) NOT NULL,
1152         mailNotified TINYINT(1) NOT NULL DEFAULT 0,
1153         UNIQUE KEY notificationID (notificationID, userID)
1154 );
1155
1156 -- events that create notifications
1157 DROP TABLE IF EXISTS wcf1_user_notification_event;
1158 CREATE TABLE wcf1_user_notification_event (
1159         eventID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1160         packageID INT(10) NOT NULL,
1161         eventName VARCHAR(255) NOT NULL DEFAULT '',
1162         objectTypeID INT(10) NOT NULL,
1163         className VARCHAR(255) NOT NULL DEFAULT '',
1164         permissions TEXT,
1165         options TEXT,
1166         preset TINYINT(1) NOT NULL DEFAULT 0,
1167         UNIQUE KEY eventName (eventName, objectTypeID)
1168 );
1169
1170 -- user configuration for events
1171 DROP TABLE IF EXISTS wcf1_user_notification_event_to_user;
1172 CREATE TABLE wcf1_user_notification_event_to_user (
1173         userID INT(10) NOT NULL,
1174         eventID INT(10) NOT NULL,
1175         mailNotificationType ENUM('none', 'instant', 'daily') NOT NULL DEFAULT 'none',
1176         UNIQUE KEY (eventID, userID)
1177 );
1178
1179 DROP TABLE IF EXISTS wcf1_user_object_watch;
1180 CREATE TABLE wcf1_user_object_watch (
1181         watchID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1182         objectTypeID INT(10) NOT NULL,
1183         objectID INT(10) NOT NULL,
1184         userID INT(10) NOT NULL,
1185         notification TINYINT(1) NOT NULL DEFAULT 0,
1186
1187         UNIQUE KEY (objectTypeID, userID, objectID),
1188         KEY (objectTypeID, objectID)
1189 );
1190
1191 DROP TABLE IF EXISTS wcf1_user_option;
1192 CREATE TABLE wcf1_user_option (
1193         optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1194         packageID INT(10) NOT NULL,
1195         optionName VARCHAR(255) NOT NULL DEFAULT '',
1196         categoryName VARCHAR(255) NOT NULL DEFAULT '',
1197         optionType VARCHAR(255) NOT NULL DEFAULT '',
1198         defaultValue MEDIUMTEXT,
1199         validationPattern TEXT,
1200         selectOptions MEDIUMTEXT,
1201         enableOptions MEDIUMTEXT,
1202         required TINYINT(1) NOT NULL DEFAULT 0,
1203         askDuringRegistration TINYINT(1) NOT NULL DEFAULT 0,
1204         editable TINYINT(1) NOT NULL DEFAULT 0,
1205         visible TINYINT(1) NOT NULL DEFAULT 0,
1206         outputClass VARCHAR(255) NOT NULL DEFAULT '',
1207         searchable TINYINT(1) NOT NULL DEFAULT 0,
1208         showOrder INT(10) NOT NULL DEFAULT 0,
1209         isDisabled TINYINT(1) NOT NULL DEFAULT 0,
1210         permissions TEXT,
1211         options TEXT,
1212         additionalData MEDIUMTEXT,
1213         UNIQUE KEY optionName (optionName, packageID),
1214         KEY categoryName (categoryName)
1215 );
1216
1217 DROP TABLE IF EXISTS wcf1_user_option_category;
1218 CREATE TABLE wcf1_user_option_category (
1219         categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1220         packageID INT(10) NOT NULL,
1221         categoryName VARCHAR(255) NOT NULL DEFAULT '',
1222         parentCategoryName VARCHAR(255) NOT NULL DEFAULT '',
1223         showOrder INT(10) NOT NULL DEFAULT 0,
1224         permissions TEXT,
1225         options TEXT,
1226         UNIQUE KEY categoryName (categoryName)
1227 );
1228
1229 DROP TABLE IF EXISTS wcf1_user_option_value;
1230 CREATE TABLE wcf1_user_option_value (
1231         userID INT(10) NOT NULL PRIMARY KEY
1232 );
1233
1234 DROP TABLE IF EXISTS wcf1_user_profile_menu_item;
1235 CREATE TABLE wcf1_user_profile_menu_item (
1236         menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1237         packageID INT(10) NOT NULL,
1238         menuItem VARCHAR(255) NOT NULL,
1239         showOrder INT(10) NOT NULL DEFAULT 0,
1240         permissions TEXT NULL,
1241         options TEXT NULL,
1242         className VARCHAR(255) NOT NULL,
1243         UNIQUE KEY (packageID, menuItem)
1244 );
1245
1246 DROP TABLE IF EXISTS wcf1_user_profile_visitor;
1247 CREATE TABLE wcf1_user_profile_visitor (
1248         visitorID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1249         ownerID INT(10),
1250         userID INT(10),
1251         time INT(10) NOT NULL DEFAULT 0,
1252         UNIQUE KEY (ownerID, userID),
1253         KEY (time)
1254 );
1255
1256 DROP TABLE IF EXISTS wcf1_user_rank;
1257 CREATE TABLE wcf1_user_rank (
1258         rankID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
1259         groupID INT(10) NOT NULL,
1260         requiredPoints INT(10) NOT NULL DEFAULT 0,
1261         rankTitle VARCHAR(255) NOT NULL DEFAULT '',
1262         cssClassName VARCHAR(255) NOT NULL DEFAULT '',
1263         rankImage VARCHAR(255) NOT NULL DEFAULT '',
1264         repeatImage TINYINT(3) NOT NULL DEFAULT 1,
1265         requiredGender TINYINT(1) NOT NULL DEFAULT 0
1266 );
1267
1268 DROP TABLE IF EXISTS wcf1_user_storage;
1269 CREATE TABLE wcf1_user_storage (
1270         userID INT(10) NOT NULL,
1271         field VARCHAR(80) NOT NULL DEFAULT '',
1272         fieldValue MEDIUMTEXT,
1273         UNIQUE KEY userStorageData (userID, field)
1274 );
1275
1276 DROP TABLE IF EXISTS wcf1_user_to_group;
1277 CREATE TABLE wcf1_user_to_group (
1278         userID INT(10) NOT NULL,
1279         groupID INT(10) NOT NULL,
1280         UNIQUE KEY userID (userID, groupID)
1281 );
1282
1283 DROP TABLE IF EXISTS wcf1_user_to_language;
1284 CREATE TABLE wcf1_user_to_language (
1285         userID INT(10) NOT NULL,
1286         languageID INT(10) NOT NULL,
1287         UNIQUE KEY userID (userID, languageID)
1288 );
1289
1290 /* SQL_PARSER_OFFSET */
1291
1292 /* foreign keys */
1293 ALTER TABLE wcf1_acl_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1294 ALTER TABLE wcf1_acl_option ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1295
1296 ALTER TABLE wcf1_acl_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1297 ALTER TABLE wcf1_acl_option_category ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1298
1299 ALTER TABLE wcf1_acl_option_to_user ADD FOREIGN KEY (optionID) REFERENCES wcf1_acl_option (optionID) ON DELETE CASCADE;
1300 ALTER TABLE wcf1_acl_option_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1301
1302 ALTER TABLE wcf1_acl_option_to_group ADD FOREIGN KEY (optionID) REFERENCES wcf1_acl_option (optionID) ON DELETE CASCADE;
1303 ALTER TABLE wcf1_acl_option_to_group ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
1304
1305 ALTER TABLE wcf1_acp_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1306
1307 ALTER TABLE wcf1_acp_search_provider ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1308
1309 ALTER TABLE wcf1_acp_session ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1310
1311 ALTER TABLE wcf1_acp_session_access_log ADD FOREIGN KEY (sessionLogID) REFERENCES wcf1_acp_session_log (sessionLogID) ON DELETE CASCADE;
1312
1313 ALTER TABLE wcf1_acp_session_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1314
1315 ALTER TABLE wcf1_acp_template ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1316
1317 ALTER TABLE wcf1_application ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1318
1319 ALTER TABLE wcf1_attachment ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1320 ALTER TABLE wcf1_attachment ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1321
1322 ALTER TABLE wcf1_bbcode ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1323
1324 ALTER TABLE wcf1_bbcode_attribute ADD FOREIGN KEY (bbcodeID) REFERENCES wcf1_bbcode (bbcodeID) ON DELETE CASCADE;
1325
1326 ALTER TABLE wcf1_category ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1327
1328 ALTER TABLE wcf1_cli_history ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1329
1330 ALTER TABLE wcf1_clipboard_action ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1331
1332 ALTER TABLE wcf1_clipboard_item ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1333
1334 ALTER TABLE wcf1_clipboard_page ADD FOREIGN KEY (actionID) REFERENCES wcf1_clipboard_action (actionID) ON DELETE CASCADE;
1335 ALTER TABLE wcf1_clipboard_page ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1336
1337 ALTER TABLE wcf1_core_object ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1338
1339 ALTER TABLE wcf1_cronjob ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1340
1341 ALTER TABLE wcf1_cronjob_log ADD FOREIGN KEY (cronjobID) REFERENCES wcf1_cronjob (cronjobID) ON DELETE CASCADE;
1342
1343 ALTER TABLE wcf1_event_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1344
1345 ALTER TABLE wcf1_language_item ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
1346 ALTER TABLE wcf1_language_item ADD FOREIGN KEY (languageCategoryID) REFERENCES wcf1_language_category (languageCategoryID) ON DELETE CASCADE;
1347 ALTER TABLE wcf1_language_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1348
1349 ALTER TABLE wcf1_modification_log ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1350 ALTER TABLE wcf1_modification_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1351
1352 ALTER TABLE wcf1_object_type ADD FOREIGN KEY (definitionID) REFERENCES wcf1_object_type_definition (definitionID) ON DELETE CASCADE;
1353 ALTER TABLE wcf1_object_type ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1354
1355 ALTER TABLE wcf1_object_type_definition ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1356
1357 ALTER TABLE wcf1_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1358
1359 ALTER TABLE wcf1_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1360
1361 ALTER TABLE wcf1_package_exclusion ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1362
1363 ALTER TABLE wcf1_package_installation_file_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1364
1365 ALTER TABLE wcf1_package_installation_form ADD FOREIGN KEY (queueID) REFERENCES wcf1_package_installation_queue (queueID) ON DELETE CASCADE;
1366
1367 ALTER TABLE wcf1_package_installation_node ADD FOREIGN KEY (queueID) REFERENCES wcf1_package_installation_queue (queueID) ON DELETE CASCADE;
1368
1369 ALTER TABLE wcf1_package_installation_plugin ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1370
1371 ALTER TABLE wcf1_package_installation_queue ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1372 ALTER TABLE wcf1_package_installation_queue ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE SET NULL;
1373
1374 ALTER TABLE wcf1_package_installation_sql_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1375
1376 /* SQL_PARSER_OFFSET */
1377
1378 ALTER TABLE wcf1_package_requirement ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1379 ALTER TABLE wcf1_package_requirement ADD FOREIGN KEY (requirement) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1380
1381 ALTER TABLE wcf1_package_update ADD FOREIGN KEY (packageUpdateServerID) REFERENCES wcf1_package_update_server (packageUpdateServerID) ON DELETE CASCADE;
1382
1383 ALTER TABLE wcf1_package_update_exclusion ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
1384
1385 ALTER TABLE wcf1_package_update_fromversion ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
1386
1387 ALTER TABLE wcf1_package_update_requirement ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
1388
1389 ALTER TABLE wcf1_package_update_optional ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
1390
1391 ALTER TABLE wcf1_package_update_version ADD FOREIGN KEY (packageUpdateID) REFERENCES wcf1_package_update (packageUpdateID) ON DELETE CASCADE;
1392
1393 ALTER TABLE wcf1_page_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1394
1395 ALTER TABLE wcf1_search ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1396
1397 ALTER TABLE wcf1_session ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1398 ALTER TABLE wcf1_session ADD FOREIGN KEY (spiderID) REFERENCES wcf1_spider (spiderID) ON DELETE CASCADE;
1399
1400 ALTER TABLE wcf1_sitemap ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1401
1402 ALTER TABLE wcf1_smiley ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1403 ALTER TABLE wcf1_smiley ADD FOREIGN KEY (categoryID) REFERENCES wcf1_category (categoryID) ON DELETE SET NULL;
1404
1405 ALTER TABLE wcf1_user_storage ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1406
1407 ALTER TABLE wcf1_style ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1408
1409 ALTER TABLE wcf1_style_variable_value ADD FOREIGN KEY (styleID) REFERENCES wcf1_style (styleID) ON DELETE CASCADE;
1410 ALTER TABLE wcf1_style_variable_value ADD FOREIGN KEY (variableID) REFERENCES wcf1_style_variable (variableID) ON DELETE CASCADE;
1411
1412 ALTER TABLE wcf1_template ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1413 ALTER TABLE wcf1_template ADD FOREIGN KEY (templateGroupID) REFERENCES wcf1_template_group (templateGroupID) ON DELETE CASCADE;
1414
1415 ALTER TABLE wcf1_template_group ADD FOREIGN KEY (parentTemplateGroupID) REFERENCES wcf1_template_group (templateGroupID) ON DELETE SET NULL;
1416
1417 ALTER TABLE wcf1_template_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1418
1419 ALTER TABLE wcf1_user_collapsible_content ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1420 ALTER TABLE wcf1_user_collapsible_content ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1421
1422 ALTER TABLE wcf1_user_group_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1423
1424 ALTER TABLE wcf1_user_group_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1425
1426 ALTER TABLE wcf1_user_group_option_value ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
1427 ALTER TABLE wcf1_user_group_option_value ADD FOREIGN KEY (optionID) REFERENCES wcf1_user_group_option (optionID) ON DELETE CASCADE;
1428
1429 /* SQL_PARSER_OFFSET */
1430
1431 ALTER TABLE wcf1_user_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1432
1433 ALTER TABLE wcf1_user_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1434
1435 ALTER TABLE wcf1_user_option_value ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1436
1437 ALTER TABLE wcf1_user_to_group ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1438 ALTER TABLE wcf1_user_to_group ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
1439
1440 ALTER TABLE wcf1_user_to_language ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1441 ALTER TABLE wcf1_user_to_language ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
1442
1443 ALTER TABLE wcf1_dashboard_box ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1444
1445 ALTER TABLE wcf1_dashboard_option ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1446 ALTER TABLE wcf1_dashboard_option ADD FOREIGN KEY (boxID) REFERENCES wcf1_dashboard_box (boxID) ON DELETE CASCADE;
1447
1448 ALTER TABLE wcf1_import_mapping ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1449
1450 ALTER TABLE wcf1_tracked_visit ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1451 ALTER TABLE wcf1_tracked_visit ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1452
1453 ALTER TABLE wcf1_tracked_visit_type ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1454 ALTER TABLE wcf1_tracked_visit_type ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1455
1456 ALTER TABLE wcf1_user ADD FOREIGN KEY (avatarID) REFERENCES wcf1_user_avatar (avatarID) ON DELETE SET NULL;
1457 ALTER TABLE wcf1_user ADD FOREIGN KEY (rankID) REFERENCES wcf1_user_rank (rankID) ON DELETE SET NULL;
1458 ALTER TABLE wcf1_user ADD FOREIGN KEY (userOnlineGroupID) REFERENCES wcf1_user_group (groupID) ON DELETE SET NULL;
1459
1460 ALTER TABLE wcf1_user_avatar ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1461
1462 ALTER TABLE wcf1_user_follow ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1463 ALTER TABLE wcf1_user_follow ADD FOREIGN KEY (followUserID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1464
1465 ALTER TABLE wcf1_user_ignore ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1466 ALTER TABLE wcf1_user_ignore ADD FOREIGN KEY (ignoreUserID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1467
1468 ALTER TABLE wcf1_user_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1469
1470 ALTER TABLE wcf1_user_notification ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1471 ALTER TABLE wcf1_user_notification ADD FOREIGN KEY (eventID) REFERENCES wcf1_user_notification_event (eventID) ON DELETE CASCADE;
1472 ALTER TABLE wcf1_user_notification ADD FOREIGN KEY (authorID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1473
1474 ALTER TABLE wcf1_user_notification_to_user ADD FOREIGN KEY (notificationID) REFERENCES wcf1_user_notification (notificationID) ON DELETE CASCADE;
1475 ALTER TABLE wcf1_user_notification_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1476
1477 ALTER TABLE wcf1_user_notification_event ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1478 ALTER TABLE wcf1_user_notification_event ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1479
1480 ALTER TABLE wcf1_user_notification_event_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1481 ALTER TABLE wcf1_user_notification_event_to_user ADD FOREIGN KEY (eventID) REFERENCES wcf1_user_notification_event (eventID) ON DELETE CASCADE;
1482
1483 ALTER TABLE wcf1_user_profile_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
1484
1485 /* SQL_PARSER_OFFSET */
1486
1487 ALTER TABLE wcf1_user_rank ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
1488
1489 ALTER TABLE wcf1_user_activity_event ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1490 ALTER TABLE wcf1_user_activity_event ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1491 ALTER TABLE wcf1_user_activity_event ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE SET NULL;
1492
1493 ALTER TABLE wcf1_user_activity_point ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1494 ALTER TABLE wcf1_user_activity_point ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1495
1496 ALTER TABLE wcf1_user_profile_visitor ADD FOREIGN KEY (ownerID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1497 ALTER TABLE wcf1_user_profile_visitor ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1498
1499 ALTER TABLE wcf1_user_object_watch ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1500 ALTER TABLE wcf1_user_object_watch ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1501
1502 ALTER TABLE wcf1_moderation_queue ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1503 ALTER TABLE wcf1_moderation_queue ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1504 ALTER TABLE wcf1_moderation_queue ADD FOREIGN KEY (assignedUserID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1505
1506 ALTER TABLE wcf1_moderation_queue_to_user ADD FOREIGN KEY (queueID) REFERENCES wcf1_moderation_queue (queueID) ON DELETE CASCADE;
1507 ALTER TABLE wcf1_moderation_queue_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1508
1509 ALTER TABLE wcf1_like ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1510 ALTER TABLE wcf1_like ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1511 ALTER TABLE wcf1_like ADD FOREIGN KEY (objectUserID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1512
1513 ALTER TABLE wcf1_like_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1514 ALTER TABLE wcf1_like_object ADD FOREIGN KEY (objectUserID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1515
1516 ALTER TABLE wcf1_comment ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1517 ALTER TABLE wcf1_comment ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1518
1519 ALTER TABLE wcf1_comment_response ADD FOREIGN KEY (commentID) REFERENCES wcf1_comment (commentID) ON DELETE CASCADE;
1520 ALTER TABLE wcf1_comment_response ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
1521
1522 ALTER TABLE wcf1_label ADD FOREIGN KEY (groupID) REFERENCES wcf1_label_group (groupID) ON DELETE CASCADE;
1523
1524 ALTER TABLE wcf1_label_group_to_object ADD FOREIGN KEY (groupID) REFERENCES wcf1_label_group (groupID) ON DELETE CASCADE;
1525 ALTER TABLE wcf1_label_group_to_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1526
1527 ALTER TABLE wcf1_label_object ADD FOREIGN KEY (labelID) REFERENCES wcf1_label (labelID) ON DELETE CASCADE;
1528 ALTER TABLE wcf1_label_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1529
1530 ALTER TABLE wcf1_tag ADD FOREIGN KEY (synonymFor) REFERENCES wcf1_tag (tagID) ON DELETE CASCADE;
1531
1532 ALTER TABLE wcf1_tag_to_object ADD FOREIGN KEY (tagID) REFERENCES wcf1_tag (tagID) ON DELETE CASCADE;
1533 ALTER TABLE wcf1_tag_to_object ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
1534 ALTER TABLE wcf1_tag_to_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1535
1536 ALTER TABLE wcf1_search_index ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1537 ALTER TABLE wcf1_search_index ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE SET NULL;
1538
1539 ALTER TABLE wcf1_poll ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
1540
1541 ALTER TABLE wcf1_poll_option ADD FOREIGN KEY (pollID) REFERENCES wcf1_poll (pollID) ON DELETE CASCADE;
1542
1543 ALTER TABLE wcf1_poll_option_vote ADD FOREIGN KEY (pollID) REFERENCES wcf1_poll (pollID) ON DELETE CASCADE;
1544 ALTER TABLE wcf1_poll_option_vote ADD FOREIGN KEY (optionID) REFERENCES wcf1_poll_option (optionID) ON DELETE CASCADE;
1545 ALTER TABLE wcf1_poll_option_vote ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
1546
1547 /* SQL_PARSER_OFFSET */
1548
1549 /* default inserts */
1550 -- default user groups
1551 INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (1, 'wcf.acp.group.group1', 1); -- Everyone
1552 INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (2, 'wcf.acp.group.group2', 2); -- Guests
1553 INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (3, 'wcf.acp.group.group3', 3); -- Registered Users
1554 INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (4, 'wcf.acp.group.group4', 4); -- Administrators
1555 INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (5, 'wcf.acp.group.group5', 4); -- Moderators
1556 INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (6, 'wcf.acp.group.group6', 4); -- Super-Moderators
1557
1558 -- default user group options
1559 INSERT INTO wcf1_user_group_option (optionID, optionName, categoryName, optionType, defaultValue, showOrder) VALUES (1, 'admin.general.canUseAcp', 'admin.general', 'boolean', '0', 1);
1560 INSERT INTO wcf1_user_group_option (optionID, optionName, categoryName, optionType, defaultValue, showOrder) VALUES (2, 'admin.system.package.canInstallPackage', 'admin.system.package', 'boolean', '0', 1);
1561 INSERT INTO wcf1_user_group_option (optionID, optionName, categoryName, optionType, defaultValue, showOrder) VALUES (3, 'admin.user.canEditGroup', 'admin.user.group', 'boolean', '0', 1);
1562
1563 -- default user group option values
1564 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 1, '0');   -- Everyone
1565 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 2, '0');   -- Everyone
1566 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 3, '0');   -- Everyone
1567 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 1, '1');   -- Administrators
1568 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 2, '1');   -- Administrators
1569 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 3, '1');   -- Administrators
1570
1571 -- default update servers
1572 INSERT INTO wcf1_package_update_server (serverURL, status, isDisabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://update.woltlab.com/maelstrom/', 'online', 0, NULL, 0, '', '');
1573 INSERT INTO wcf1_package_update_server (serverURL, status, isDisabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://store.woltlab.com/maelstrom/', 'online', 0, NULL, 0, '', '');
1574
1575 -- style default values
1576 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentBackgroundColor', 'rgba(255, 255, 255, 1)');
1577 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfColor', 'rgba(102, 102, 102, 1)');
1578 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLinkColor', 'rgba(63, 127, 191, 1)');
1579 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLinkHoverColor', 'rgba(15, 79, 143, 1)');
1580 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerBackgroundColor', 'rgba(255, 255, 255, 1)');
1581 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerAccentBackgroundColor', 'rgba(249, 249, 249, 1)');
1582 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerHoverBackgroundColor', 'rgba(244, 244, 244, 1)');
1583 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerBorderColor', 'rgba(221, 221, 221, 1)');
1584 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerBorderRadius', '0');
1585 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxBackgroundColor', 'rgba(63, 127, 191, 1)');
1586 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxColor', 'rgba(255, 255, 255, 1)');
1587 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxHoverColor', 'rgba(255, 255, 255, 1)');
1588 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelBackgroundColor', 'rgba(45, 45, 45, 1)');
1589 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelColor', 'rgba(255, 255, 255, 1)');
1590 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelHoverColor', 'rgba(255, 255, 255, 1)');
1591 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBackgroundColor', 'rgba(249, 249, 249, 1)');
1592 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBorderColor', 'rgba(221, 221, 221, 1)');
1593 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBorderRadius', '15px');
1594 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSmallButtonBorderRadius', '3px');
1595 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonColor', 'rgba(102, 102, 102, 1)');
1596 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryBackgroundColor', 'rgba(211, 232, 254, 1)');
1597 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryBorderColor', 'rgba(136, 194, 255, 1)');
1598 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryColor', 'rgba(102, 153, 204, 1)');
1599 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryHoverBackgroundColor', 'darken(@wcfButtonPrimaryBackgroundColor, 3%)');
1600 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryHoverBorderColor', 'darken(@wcfButtonPrimaryBorderColor, 10%)');
1601 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryHoverColor', '@wcfButtonPrimaryColor');
1602 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonHoverBackgroundColor', 'rgba(241, 241, 241, 1)');
1603 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonHoverBorderColor', 'rgba(224, 224, 224, 1)');
1604 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonHoverColor', 'rgba(102, 102, 102, 1)');
1605 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBackgroundColor', 'rgba(255, 255, 255, 1)');
1606 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputColor', 'rgba(102, 102, 102, 1)');
1607 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBorderColor', 'rgba(204, 204, 204, 1)');
1608 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputHoverBackgroundColor', 'rgba(239, 247, 255, 1)');
1609 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputHoverBorderColor', 'rgba(198, 222, 248, 1)');
1610 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBorderRadius', '0');
1611 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfBaseFontSize', '13px');
1612 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfBaseFontFamily', '"Trebuchet MS", Arial, sans-serif');
1613 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutMinWidth', '980px');
1614 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutMaxWidth', '90%');
1615 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutFixedWidth', '1200px');
1616 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageBackgroundColor', 'rgba(224, 224, 224, 1)');
1617 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageColor', 'rgba(102, 102, 102, 1)');
1618 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageLinkColor', 'rgba(63, 127, 191, 1)');
1619 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageLinkHoverColor', 'rgba(15, 79, 143, 1)');
1620 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarBackgroundColor', '@wcfContainerHoverBackgroundColor');
1621 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDimmedColor', 'rgba(136, 136, 136, 1)');
1622 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfExtraDimmedColor', 'lighten(@wcfDimmedColor, 20%)');
1623 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLabelColor', '@wcfColor');
1624 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeadlineColor', '@wcfColor');
1625 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeadlineFontFamily', '"Trebuchet MS", Arial, sans-serif');
1626 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBackgroundColor', '@wcfContentBackgroundColor');
1627 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownColor', '@wcfColor');
1628 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBorderColor', '@wcfContainerBorderColor');
1629 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownHoverBackgroundColor', '@wcfContainerHoverBackgroundColor');
1630 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfBaseLineHeight', '1.28');
1631 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeadlineFontSize', '1.7rem');
1632 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSubHeadlineFontSize', '1.4rem');
1633 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTitleFontSize', '1.2rem');
1634 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSmallFontSize', '.85rem');
1635 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfWarningColor', 'rgba(153, 153, 0, 1)');
1636 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfWarningBackgroundColor', 'rgba(255, 255, 221, 1)');
1637 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfWarningBorderColor', 'rgba(204, 204, 0, 1)');
1638 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfErrorColor', 'rgba(204, 0, 0, 1)');
1639 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfErrorBackgroundColor', 'rgba(255, 238, 238, 1)');
1640 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfErrorBorderColor', 'rgba(255, 153, 153, 1)');
1641 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSuccessColor', 'rgba(0, 153, 0, 1)');
1642 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSuccessBackgroundColor', 'rgba(238, 255, 238, 1)');
1643 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSuccessBorderColor', 'rgba(0, 204, 0, 1)');
1644 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInfoColor', 'rgba(102, 136, 187, 1)');
1645 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInfoBackgroundColor', 'rgba(221, 238, 255, 1)');
1646 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInfoBorderColor', 'rgba(153, 187, 238, 1)');
1647 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTooltipBackgroundColor', 'rgba(0, 0, 0, .8)');
1648 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTooltipColor', 'rgba(255, 255, 255, 1)');
1649 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHighlightBackgroundColor', 'rgba(255, 255, 102, 1)');
1650 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapTiny', '4px');
1651 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapSmall', '7px');
1652 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapMedium', '14px');
1653 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapLarge', '21px');
1654 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationHeaderBackgroundColor', '@wcfContentBackgroundColor');
1655 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationFooterBackgroundColor', '@wcfContainerAccentBackgroundColor');
1656 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuBackgroundColor', '@wcfContainerAccentBackgroundColor');
1657 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuHoverBackgroundColor', '@wcfContainerAccentBackgroundColor');
1658 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuColor', '@wcfColor');
1659 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuActiveColor', '@wcfLinkColor');
1660 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelHoverBackgroundColor', 'rgba(60, 60, 60, 1)');
1661 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSelectedBackgroundColor', 'rgba(255, 255, 200, 1)');
1662 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSelectedColor', '@wcfColor');
1663 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDeletedBackgroundColor', 'rgba(255, 238, 238, 1)');
1664 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDeletedColor', 'rgba(204, 0, 0, 1)');
1665 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDisabledBackgroundColor', 'rgba(238, 255, 238, 1)');
1666 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDisabledColor', 'rgba(0, 153, 0, 1)');
1667 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTextShadowLightColor', 'transparent');
1668 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTextShadowDarkColor', 'transparent');
1669 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('useFluidLayout', '1');
1670 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogo', '');
1671 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('individualLess', '');
1672 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('overrideLess', '');
1673 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('messageSidebarOrientation', 'left');
1674
1675 -- media providers
1676 -- Videos
1677         -- Youtube
1678         INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('YouTube', 'https?://(?:.+?\\.)?youtu(?:\\.be/|be\\.com/watch\\?(?:.*?&)?v=)(?P<ID>[a-zA-Z0-9_-]+)(?P<start>(?:#a?t=(?:\\d+|(?:\\d+h(?:\\d+m)?(?:\\d+s)?)|(?:\\d+m(?:\\d+s)?)|(?:\\d+s))$)?)', '<iframe width="560" height="315" src="https://www.youtube-nocookie.com/embed/{$ID}?wmode=transparent{$start}" allowfullscreen></iframe>');
1679         -- Vimeo
1680         INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('Vimeo', 'http://vimeo\\.com/(?P<ID>\\d+)', '<iframe src="http://player.vimeo.com/video/{$ID}" width="400" height="225" webkitAllowFullScreen mozallowfullscreen allowFullScreen></iframe>');
1681         -- MyVideo
1682         INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('MyVideo', 'http://(?:www\\.)?myvideo\\.de/watch/(?P<ID>\\d+)', '<object width="611" height="383" type="application/x-shockwave-flash" data="http://www.myvideo.de/movie/{$ID}"><param name="movie" value="http://www.myvideo.de/movie/{$ID}" /><param name="AllowFullscreen" value="true" /><param name="AllowScriptAccess" value="always" /><param name="wmode" value="transparent" /></object>');
1683         -- Clipfish
1684         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>');
1685         -- Veoh
1686         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>');
1687         -- DailyMotion
1688         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="208" src="http://www.dailymotion.com/embed/video/{$ID}"></iframe>');
1689 -- Misc
1690         -- github gist
1691         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>');
1692         -- soundcloud
1693         INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('Soundcloud', 'https?://soundcloud.com/(?P<artist>[a-zA-Z0-9_-]+)/(?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>');
1694
1695 -- default priorities
1696 UPDATE wcf1_user_group SET priority = 10 WHERE groupID = 3;
1697 UPDATE wcf1_user_group SET priority = 1000 WHERE groupID = 4;
1698 UPDATE wcf1_user_group SET priority = 50 WHERE groupID = 5;
1699 UPDATE wcf1_user_group SET priority = 100 WHERE groupID = 6;
1700
1701 -- default 'showOnTeamPage' setting
1702 UPDATE wcf1_user_group SET showOnTeamPage = 1 WHERE groupID IN (4, 5, 6);
1703
1704 -- default ranks
1705 INSERT INTO wcf1_user_rank (groupID, requiredPoints, rankTitle, cssClassName) VALUES
1706         (4, 0, 'wcf.user.rank.administrator', 'blue'),
1707         (5, 0, 'wcf.user.rank.moderator', 'blue'),
1708         (6, 0, 'wcf.user.rank.superModerator', 'blue'),
1709         (3, 0, 'wcf.user.rank.user0', ''),
1710         (3, 300, 'wcf.user.rank.user1', ''),
1711         (3, 900, 'wcf.user.rank.user2', ''),
1712         (3, 3000, 'wcf.user.rank.user3', ''),
1713         (3, 9000, 'wcf.user.rank.user4', ''),
1714         (3, 15000, 'wcf.user.rank.user5', '');