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