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