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 DEFAULT '',
 110         UNIQUE KEY (packageID, templateName)
 111 );
 112
 113 DROP TABLE IF EXISTS wcf1_application;
 114 CREATE TABLE wcf1_application (
 115         packageID INT(10) NOT NULL PRIMARY KEY,
 116         domainName VARCHAR(255) NOT NULL,
 117         domainPath VARCHAR(255) NOT NULL DEFAULT '/',
 118         cookieDomain VARCHAR(255) NOT NULL,
 119         cookiePath VARCHAR(255) NOT NULL DEFAULT '/',
 120         isPrimary TINYINT(1) NOT NULL DEFAULT 0
 121 );
 122
 123 DROP TABLE IF EXISTS wcf1_cache_resource;
 124 CREATE TABLE wcf1_cache_resource (
 125         cacheResource VARCHAR(255) NOT NULL PRIMARY KEY
 126 );
 127
 128 DROP TABLE IF EXISTS wcf1_category;
 129 CREATE TABLE wcf1_category (
 130         categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 131         objectTypeID INT(10) NOT NULL,
 132         parentCategoryID INT(10) NOT NULL,
 133         title VARCHAR(255) NOT NULL,
 134         description TEXT,
 135         showOrder INT(10) NOT NULL,
 136         time INT(10) NOT NULL,
 137         isDisabled TINYINT(1) NOT NULL DEFAULT 0,
 138         additionalData TEXT
 139 );
 140
 141 DROP TABLE IF EXISTS wcf1_cleanup_listener;
 142 CREATE TABLE wcf1_cleanup_listener (
 143         listenerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 144         packageID INT(10) NOT NULL,
 145         className VARCHAR(255) NOT NULL DEFAULT '',
 146         objectType VARCHAR(255) NOT NULL DEFAULT '',
 147         lastUpdateTime INT(10) NOT NULL DEFAULT 0,
 148         UNIQUE KEY (className, packageID)
 149 );
 150
 151 DROP TABLE IF EXISTS wcf1_cleanup_log;
 152 CREATE TABLE wcf1_cleanup_log (
 153         packageID INT(10) NOT NULL DEFAULT 0,
 154         objectType VARCHAR(255) NOT NULL DEFAULT '',
 155         objectID INT(10) NOT NULL DEFAULT 0,
 156         deleteTime INT(10) NOT NULL DEFAULT 0,
 157         KEY objectType (objectType)
 158 );
 159
 160 DROP TABLE IF EXISTS wcf1_clipboard_action;
 161 CREATE TABLE wcf1_clipboard_action (
 162         actionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 163         packageID INT(10) NOT NULL DEFAULT 0,
 164         actionName VARCHAR(50) NOT NULL DEFAULT '',
 165         actionClassName VARCHAR(200) NOT NULL DEFAULT '',
 166         showOrder INT(10) NOT NULL DEFAULT 0,
 167         UNIQUE KEY actionName (packageID, actionName, actionClassName)
 168 );
 169
 170 DROP TABLE IF EXISTS wcf1_clipboard_item;
 171 CREATE TABLE wcf1_clipboard_item (
 172         objectTypeID INT(10) NOT NULL DEFAULT 0,
 173         userID INT(10) NOT NULL DEFAULT 0,
 174         objectID INT(10) NOT NULL DEFAULT 0,
 175         UNIQUE KEY (objectTypeID, userID, objectID)
 176 );
 177
 178 DROP TABLE IF EXISTS wcf1_clipboard_page;
 179 CREATE TABLE wcf1_clipboard_page (
 180         pageClassName VARCHAR(80) NOT NULL DEFAULT '',
 181         packageID INT(10) NOT NULL DEFAULT 0,
 182         actionID INT(10) NOT NULL DEFAULT 0
 183 );
 184
 185 DROP TABLE IF EXISTS wcf1_core_object;
 186 CREATE TABLE wcf1_core_object (
 187         objectID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 188         packageID INT(10) NOT NULL,
 189         objectName VARCHAR(255) NOT NULL DEFAULT '',
 190         UNIQUE KEY object (packageID, objectName)
 191 );
 192
 193 DROP TABLE IF EXISTS wcf1_cronjob;
 194 CREATE TABLE wcf1_cronjob (
 195         cronjobID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 196         className varchar(255) NOT NULL DEFAULT '',
 197         packageID INT(10) NOT NULL,
 198         description varchar(255) NOT NULL DEFAULT '',
 199         startMinute varchar(255) NOT NULL DEFAULT '*',
 200         startHour varchar(255) NOT NULL DEFAULT '*',
 201         startDom varchar(255) NOT NULL DEFAULT '*',
 202         startMonth varchar(255) NOT NULL DEFAULT '*',
 203         startDow varchar(255) NOT NULL DEFAULT '*',
 204         lastExec INT(10) NOT NULL DEFAULT 0,
 205         nextExec INT(10) NOT NULL DEFAULT 0,
 206         afterNextExec INT(10) NOT NULL DEFAULT 0,
 207         isDisabled TINYINT(1) NOT NULL DEFAULT 0,
 208         canBeEdited TINYINT(1) NOT NULL DEFAULT 1,
 209         canBeDisabled TINYINT(1) NOT NULL DEFAULT 1,
 210         state TINYINT(1) NOT NULL DEFAULT 0,
 211         failCount TINYINT(1) NOT NULL DEFAULT 0
 212 );
 213
 214 DROP TABLE IF EXISTS wcf1_cronjob_log;
 215 CREATE TABLE wcf1_cronjob_log (
 216         cronjobLogID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 217         cronjobID INT(10) NOT NULL,
 218         execTime INT(10) NOT NULL DEFAULT 0,
 219         success TINYINT(1) NOT NULL DEFAULT 0,
 220         error TEXT
 221 );
 222
 223 DROP TABLE IF EXISTS wcf1_event_listener;
 224 CREATE TABLE wcf1_event_listener (
 225         listenerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 226         packageID INT(10) NOT NULL,
 227         environment ENUM('user', 'admin') NOT NULL DEFAULT 'user',
 228         eventClassName VARCHAR(80) NOT NULL DEFAULT '',
 229         eventName VARCHAR(50) NOT NULL DEFAULT '',
 230         listenerClassName VARCHAR(200) NOT NULL DEFAULT '',
 231         inherit TINYINT(1) NOT NULL DEFAULT 0,
 232         niceValue TINYINT(3) NOT NULL DEFAULT 0,
 233         UNIQUE KEY packageID (packageID, environment, eventClassName, eventName, listenerClassName)
 234 );
 235
 236 DROP TABLE IF EXISTS wcf1_language;
 237 CREATE TABLE wcf1_language (
 238         languageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 239         languageCode VARCHAR(20) NOT NULL DEFAULT '',
 240         languageName VARCHAR(255) NOT NULL DEFAULT '',
 241         countryCode VARCHAR(10) NOT NULL DEFAULT '',
 242         isDefault TINYINT(1) NOT NULL DEFAULT 0,
 243         hasContent TINYINT(1) NOT NULL DEFAULT 0,
 244         UNIQUE KEY languageCode (languageCode)
 245 );
 246
 247 DROP TABLE IF EXISTS wcf1_language_category;
 248 CREATE TABLE wcf1_language_category (
 249         languageCategoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 250         languageCategory VARCHAR(255) NOT NULL DEFAULT '',
 251         UNIQUE KEY languageCategory (languageCategory)
 252 );
 253
 254 DROP TABLE IF EXISTS wcf1_language_item;
 255 CREATE TABLE wcf1_language_item (
 256         languageItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 257         languageID INT(10) NOT NULL,
 258         languageItem VARCHAR(255) NOT NULL DEFAULT '',
 259         languageItemValue MEDIUMTEXT NOT NULL,
 260         languageCustomItemValue MEDIUMTEXT,
 261         languageUseCustomValue TINYINT(1) NOT NULL DEFAULT 0,
 262         languageItemOriginIsSystem TINYINT(1) NOT NULL DEFAULT 1,
 263         languageCategoryID INT(10) NOT NULL,
 264         packageID INT(10),
 265         UNIQUE KEY languageItem (languageItem, languageID),
 266         KEY languageItemOriginIsSystem (languageItemOriginIsSystem)
 267 );
 268
 269 DROP TABLE IF EXISTS wcf1_language_server;
 270 CREATE TABLE wcf1_language_server (
 271         languageServerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 272         serverURL VARCHAR(255) NOT NULL DEFAULT '',
 273         isDisabled TINYINT(1) NOT NULL DEFAULT 0
 274 );
 275
 276 DROP TABLE IF EXISTS wcf1_modification_log;
 277 CREATE TABLE wcf1_modification_log (
 278         logID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 279         objectTypeID INT(10) NOT NULL,
 280         objectID INT(10) NOT NULL,
 281         userID INT(10),
 282         username VARCHAR(255) NOT NULL DEFAULT '',
 283         time INT(10) NOT NULL DEFAULT 0,
 284         action VARCHAR(80) NOT NULL,
 285         additionalData MEDIUMTEXT
 286 );
 287
 288 DROP TABLE IF EXISTS wcf1_object_type;
 289 CREATE TABLE wcf1_object_type (
 290         objectTypeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 291         definitionID INT(10) NOT NULL,
 292         packageID INT(10) NOT NULL,
 293         objectType VARCHAR(255) NOT NULL,
 294         className VARCHAR(255) NOT NULL DEFAULT '',
 295         additionalData MEDIUMTEXT,
 296         UNIQUE KEY objectType (objectType, definitionID, packageID)
 297 );
 298
 299 DROP TABLE IF EXISTS wcf1_object_type_definition;
 300 CREATE TABLE wcf1_object_type_definition (
 301         definitionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 302         definitionName VARCHAR(255) NOT NULL,
 303         packageID INT(10) NOT NULL,
 304         interfaceName VARCHAR(255) NOT NULL DEFAULT '',
 305         categoryName VARCHAR(80) NOT NULL DEFAULT '',
 306         UNIQUE KEY definitionName (definitionName)
 307 );
 308
 309 DROP TABLE IF EXISTS wcf1_option;
 310 CREATE TABLE wcf1_option (
 311         optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 312         packageID INT(10) NOT NULL,
 313         optionName VARCHAR(255) NOT NULL DEFAULT '',
 314         categoryName VARCHAR(255) NOT NULL DEFAULT '',
 315         optionType VARCHAR(255) NOT NULL DEFAULT '',
 316         optionValue MEDIUMTEXT,
 317         validationPattern TEXT,
 318         selectOptions MEDIUMTEXT,
 319         enableOptions MEDIUMTEXT,
 320         showOrder INT(10) NOT NULL DEFAULT 0,
 321         hidden TINYINT(1) NOT NULL DEFAULT 0,
 322         permissions TEXT,
 323         options TEXT,
 324         supportI18n TINYINT(1) NOT NULL DEFAULT 0,
 325         requireI18n TINYINT(1) NOT NULL DEFAULT 0,
 326         additionalData MEDIUMTEXT,
 327         UNIQUE KEY optionName (optionName, packageID)
 328 );
 329
 330 DROP TABLE IF EXISTS wcf1_option_category;
 331 CREATE TABLE wcf1_option_category (
 332         categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 333         packageID INT(10) NOT NULL,
 334         categoryName VARCHAR(255) NOT NULL DEFAULT '',
 335         parentCategoryName VARCHAR(255) NOT NULL DEFAULT '',
 336         showOrder INT(10) NOT NULL DEFAULT 0,
 337         permissions TEXT,
 338         options TEXT,
 339         UNIQUE KEY categoryName (categoryName, packageID)
 340 );
 341
 342 DROP TABLE IF EXISTS wcf1_package;
 343 CREATE TABLE wcf1_package (
 344         packageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 345         package VARCHAR(255) NOT NULL DEFAULT '',
 346         packageDir VARCHAR(255) NOT NULL DEFAULT '',
 347         packageName VARCHAR(255) NOT NULL DEFAULT '',
 348         packageDescription VARCHAR(255) NOT NULL DEFAULT '',
 349         packageVersion VARCHAR(255) NOT NULL DEFAULT '',
 350         packageDate INT(10) NOT NULL DEFAULT 0,
 351         installDate INT(10) NOT NULL DEFAULT 0,
 352         updateDate INT(10) NOT NULL DEFAULT 0,
 353         packageURL VARCHAR(255) NOT NULL DEFAULT '',
 354         isApplication TINYINT(1) NOT NULL DEFAULT 0,
 355         author VARCHAR(255) NOT NULL DEFAULT '',
 356         authorURL VARCHAR(255) NOT NULL DEFAULT '',
 357         packageIcon VARCHAR(30) NOT NULL DEFAULT '',
 358         KEY package (package)
 359 );
 360
 361 DROP TABLE IF EXISTS wcf1_package_exclusion;
 362 CREATE TABLE wcf1_package_exclusion (
 363         packageID INT(10) NOT NULL,
 364         excludedPackage VARCHAR(255) NOT NULL DEFAULT '',
 365         excludedPackageVersion VARCHAR(255) NOT NULL DEFAULT '',
 366         UNIQUE KEY packageID (packageID, excludedPackage)
 367 );
 368
 369 DROP TABLE IF EXISTS wcf1_package_installation_file_log;
 370 CREATE TABLE wcf1_package_installation_file_log (
 371         packageID INT(10),
 372         filename VARCHAR(255) NOT NULL DEFAULT '',
 373         UNIQUE KEY packageID (packageID, filename)
 374 );
 375
 376 DROP TABLE IF EXISTS wcf1_package_installation_form;
 377 CREATE TABLE wcf1_package_installation_form (
 378         queueID INT(10) NOT NULL,
 379         formName VARCHAR(80) NOT NULL DEFAULT '',
 380         document TEXT NOT NULL,
 381         UNIQUE KEY formDocument (queueID, formName)
 382 );
 383
 384 DROP TABLE IF EXISTS wcf1_package_installation_node;
 385 CREATE TABLE wcf1_package_installation_node (
 386         queueID INT(10) NOT NULL,
 387         processNo INT(10) NOT NULL DEFAULT 0,
 388         sequenceNo SMALLINT(4) NOT NULL DEFAULT 0,
 389         node CHAR(8) NOT NULL DEFAULT '',
 390         parentNode CHAR(8) NOT NULL DEFAULT '',
 391         nodeType ENUM('optionalPackages','package', 'pip') NOT NULL DEFAULT 'package',
 392         nodeData TEXT NOT NULL,
 393         done TINYINT(1) NOT NULL DEFAULT 0
 394 );
 395
 396 DROP TABLE IF EXISTS wcf1_package_installation_plugin;
 397 CREATE TABLE wcf1_package_installation_plugin (
 398         pluginName VARCHAR(255) NOT NULL PRIMARY KEY,
 399         packageID INT(10),
 400         priority TINYINT(1) NOT NULL DEFAULT 0,
 401         className VARCHAR(255) NOT NULL
 402 );
 403
 404 DROP TABLE IF EXISTS wcf1_package_installation_queue;
 405 CREATE TABLE wcf1_package_installation_queue (
 406         queueID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 407         parentQueueID INT(10) NOT NULL DEFAULT 0,
 408         processNo INT(10) NOT NULL DEFAULT 0,
 409         userID INT(10) NOT NULL,
 410         package VARCHAR(255) NOT NULL DEFAULT '',
 411         packageName VARCHAR(255) NOT NULL DEFAULT '',
 412         packageID INT(10),
 413         archive VARCHAR(255) NOT NULL DEFAULT '',
 414         action ENUM('install', 'update', 'uninstall') NOT NULL DEFAULT 'install',
 415         done TINYINT(1) NOT NULL DEFAULT 0,
 416         confirmInstallation TINYINT(1) NOT NULL DEFAULT 0,
 417         packageType ENUM('default', 'requirement', 'optional') NOT NULL DEFAULT 'default'
 418 );
 419
 420 DROP TABLE IF EXISTS wcf1_package_installation_sql_log;
 421 CREATE TABLE wcf1_package_installation_sql_log (
 422         packageID INT(10),
 423         sqlTable VARCHAR(100) NOT NULL DEFAULT '',
 424         sqlColumn VARCHAR(100) NOT NULL DEFAULT '',
 425         sqlIndex VARCHAR(100) NOT NULL DEFAULT '',
 426         UNIQUE KEY packageID (packageID, sqlTable, sqlColumn, sqlIndex)
 427 );
 428
 429 DROP TABLE IF EXISTS wcf1_package_requirement;
 430 CREATE TABLE wcf1_package_requirement (
 431         packageID INT(10) NOT NULL,
 432         requirement INT(10) NOT NULL,
 433         UNIQUE KEY packageID (packageID, requirement)
 434 );
 435
 436 DROP TABLE IF EXISTS wcf1_package_update;
 437 CREATE TABLE wcf1_package_update (
 438         packageUpdateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 439         packageUpdateServerID INT(10) NOT NULL,
 440         package VARCHAR(255) NOT NULL DEFAULT '',
 441         packageName VARCHAR(255) NOT NULL DEFAULT '',
 442         packageDescription VARCHAR(255) NOT NULL DEFAULT '',
 443         author VARCHAR(255) NOT NULL DEFAULT '',
 444         authorURL VARCHAR(255) NOT NULL DEFAULT '',
 445         isApplication TINYINT(1) NOT NULL DEFAULT 0,
 446         plugin VARCHAR(255) NOT NULL DEFAULT '',
 447         UNIQUE KEY packageUpdateServerID (packageUpdateServerID, package)
 448 );
 449
 450 DROP TABLE IF EXISTS wcf1_package_update_exclusion;
 451 CREATE TABLE wcf1_package_update_exclusion (
 452         packageUpdateVersionID INT(10) NOT NULL,
 453         excludedPackage VARCHAR(255) NOT NULL DEFAULT '',
 454         excludedPackageVersion VARCHAR(255) NOT NULL DEFAULT '',
 455         UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, excludedPackage)
 456 );
 457
 458 DROP TABLE IF EXISTS wcf1_package_update_fromversion;
 459 CREATE TABLE wcf1_package_update_fromversion (
 460         packageUpdateVersionID INT(10) NOT NULL DEFAULT 0,
 461         fromversion VARCHAR(50) NOT NULL DEFAULT '',
 462         UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, fromversion)
 463 );
 464
 465 DROP TABLE IF EXISTS wcf1_package_update_requirement;
 466 CREATE TABLE wcf1_package_update_requirement (
 467         packageUpdateVersionID INT(10) NOT NULL,
 468         package VARCHAR(255) NOT NULL DEFAULT '',
 469         minversion VARCHAR(50) NOT NULL DEFAULT '',
 470         UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, package)
 471 );
 472
 473 DROP TABLE IF EXISTS wcf1_package_update_server;
 474 CREATE TABLE wcf1_package_update_server (
 475         packageUpdateServerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 476         serverURL VARCHAR(255) NOT NULL DEFAULT '',
 477         loginUsername VARCHAR(255) NOT NULL DEFAULT '',
 478         loginPassword VARCHAR(255) NOT NULL DEFAULT '',
 479         isDisabled TINYINT(1) NOT NULL DEFAULT 0,
 480         lastUpdateTime INT(10) NOT NULL DEFAULT 0,
 481         status ENUM('online', 'offline') NOT NULL DEFAULT 'online',
 482         errorMessage TEXT
 483 );
 484
 485 DROP TABLE IF EXISTS wcf1_package_update_version;
 486 CREATE TABLE wcf1_package_update_version (
 487         packageUpdateVersionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 488         packageUpdateID INT(10) NOT NULL,
 489         packageVersion VARCHAR(50) NOT NULL DEFAULT '',
 490         updateType VARCHAR(10) NOT NULL DEFAULT '',
 491         packageDate INT(10) NOT NULL DEFAULT 0,
 492         filename VARCHAR(255) NOT NULL DEFAULT '',
 493         UNIQUE KEY packageUpdateID (packageUpdateID, packageVersion)
 494 );
 495
 496 DROP TABLE IF EXISTS wcf1_page_menu_item;
 497 CREATE TABLE wcf1_page_menu_item (
 498         menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 499         packageID INT(10) NOT NULL,
 500         menuItem VARCHAR(255) NOT NULL DEFAULT '',
 501         parentMenuItem VARCHAR(255) NOT NULL DEFAULT '',
 502         menuItemController VARCHAR(255) NOT NULL DEFAULT '',
 503         menuItemLink VARCHAR(255) NOT NULL DEFAULT '',
 504         menuPosition ENUM('header', 'footer') NOT NULL DEFAULT 'header',
 505         showOrder INT(10) NOT NULL DEFAULT 0,
 506         permissions TEXT NULL,
 507         options TEXT NULL,
 508         isDisabled TINYINT(1) NOT NULL DEFAULT 0,
 509         className VARCHAR(255) NOT NULL DEFAULT '',
 510         isLandingPage TINYINT(1) NOT NULL DEFAULT 0,
 511         UNIQUE KEY (packageID, menuItem)
 512 );
 513
 514 DROP TABLE IF EXISTS wcf1_search;
 515 CREATE TABLE wcf1_search (
 516         searchID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 517         userID INT(10),
 518         searchData MEDIUMTEXT NOT NULL,
 519         searchTime INT(10) NOT NULL DEFAULT 0,
 520         searchType VARCHAR(255) NOT NULL DEFAULT '',
 521         searchHash CHAR(40) NOT NULL DEFAULT '',
 522         KEY searchHash (searchHash)
 523 );
 524
 525 DROP TABLE IF EXISTS wcf1_session;
 526 CREATE TABLE wcf1_session (
 527         sessionID CHAR(40) NOT NULL PRIMARY KEY,
 528         userID INT(10),
 529         ipAddress VARCHAR(39) NOT NULL DEFAULT '',
 530         userAgent VARCHAR(255) NOT NULL DEFAULT '',
 531         lastActivityTime INT(10) NOT NULL DEFAULT 0,
 532         requestURI VARCHAR(255) NOT NULL DEFAULT '',
 533         requestMethod VARCHAR(4) NOT NULL DEFAULT '',
 534         controller VARCHAR(255) NOT NULL DEFAULT '',
 535         parentObjectType VARCHAR(255) NOT NULL DEFAULT '',
 536         parentObjectID INT(10) NOT NULL DEFAULT 0,
 537         objectType VARCHAR(255) NOT NULL DEFAULT '',
 538         objectID INT(10) NOT NULL DEFAULT 0,
 539         sessionVariables MEDIUMTEXT,
 540         spiderID INT(10) NOT NULL DEFAULT 0,
 541         KEY packageID (lastActivityTime, spiderID)
 542 );
 543
 544 DROP TABLE IF EXISTS wcf1_sitemap;
 545 CREATE TABLE wcf1_sitemap (
 546         sitemapID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 547         packageID INT(10) NOT NULL,
 548         sitemapName VARCHAR(80) NOT NULL DEFAULT '',
 549         className VARCHAR(255) NOT NULL DEFAULT '',
 550         showOrder INT(10) NOT NULL DEFAULT 0,
 551         UNIQUE KEY sitemapName (packageID, sitemapName)
 552 );
 553
 554 DROP TABLE IF EXISTS wcf1_spider;
 555 CREATE TABLE wcf1_spider (
 556         spiderID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 557         spiderIdentifier VARCHAR(255) DEFAULT '',
 558         spiderName VARCHAR(255) DEFAULT '',
 559         spiderURL VARCHAR(255) DEFAULT '',
 560         UNIQUE KEY spiderIdentifier (spiderIdentifier)
 561 );
 562
 563 DROP TABLE IF EXISTS wcf1_style;
 564 CREATE TABLE wcf1_style (
 565         styleID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 566         packageID INT(10) NOT NULL,
 567         styleName VARCHAR(255) NOT NULL DEFAULT '',
 568         templateGroupID INT(10) NOT NULL DEFAULT 0,
 569         isDefault TINYINT(1) NOT NULL DEFAULT 0,
 570         isDisabled TINYINT(1) NOT NULL DEFAULT 0,
 571         styleDescription VARCHAR(30) NOT NULL DEFAULT '',
 572         styleVersion VARCHAR(255) NOT NULL DEFAULT '',
 573         styleDate CHAR(10) NOT NULL DEFAULT '0000-00-00',
 574         image VARCHAR(255) NOT NULL DEFAULT '',
 575         copyright VARCHAR(255) NOT NULL DEFAULT '',
 576         license VARCHAR(255) NOT NULL DEFAULT '',
 577         authorName VARCHAR(255) NOT NULL DEFAULT '',
 578         authorURL VARCHAR(255) NOT NULL DEFAULT '',
 579         iconPath VARCHAR(255) NOT NULL DEFAULT '',
 580         imagePath VARCHAR(255) NOT NULL DEFAULT ''
 581 );
 582
 583 DROP TABLE IF EXISTS wcf1_style_variable;
 584 CREATE TABLE wcf1_style_variable (
 585         variableID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 586         variableName VARCHAR(50) NOT NULL,
 587         defaultValue MEDIUMTEXT,
 588         UNIQUE KEY variableName (variableName)
 589 );
 590
 591 DROP TABLE IF EXISTS wcf1_style_variable_value;
 592 CREATE TABLE wcf1_style_variable_value (
 593         styleID INT(10) NOT NULL,
 594         variableID INT(10) NOT NULL,
 595         variableValue MEDIUMTEXT,
 596         UNIQUE KEY (styleID, variableID)
 597 );
 598
 599 DROP TABLE IF EXISTS wcf1_template;
 600 CREATE TABLE wcf1_template (
 601         templateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 602         packageID INT(10) NOT NULL,
 603         templateName VARCHAR(255) NOT NULL DEFAULT '',
 604         templateGroupID INT(10),
 605         obsolete TINYINT(1) NOT NULL DEFAULT 0,
 606         KEY packageID (packageID, templateName),
 607         KEY templateGroupID (packageID, templateGroupID, templateName)
 608 );
 609
 610 DROP TABLE IF EXISTS wcf1_template_group;
 611 CREATE TABLE wcf1_template_group (
 612         templateGroupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 613         parentTemplateGroupID INT(10) NOT NULL DEFAULT 0,
 614         templateGroupName VARCHAR(255) NOT NULL DEFAULT '',
 615         templateGroupFolderName VARCHAR(255) NOT NULL DEFAULT ''
 616 );
 617
 618 DROP TABLE IF EXISTS wcf1_template_listener;
 619 CREATE TABLE wcf1_template_listener (
 620         listenerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 621         packageID INT(10) NOT NULL,
 622         name VARCHAR(80) NOT NULL DEFAULT '',
 623         environment ENUM('user','admin') NOT NULL DEFAULT 'user',
 624         templateName VARCHAR(80) NOT NULL DEFAULT '',
 625         eventName VARCHAR(50) NOT NULL DEFAULT '',
 626         templateCode TEXT NOT NULL,
 627         KEY templateName (environment, templateName)
 628 );
 629
 630 DROP TABLE IF EXISTS wcf1_user;
 631 CREATE TABLE wcf1_user (
 632         userID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 633         username VARCHAR(255) NOT NULL DEFAULT '',
 634         email VARCHAR(255) NOT NULL DEFAULT '',
 635         password VARCHAR(100) NOT NULL DEFAULT '',
 636         accessToken CHAR(40) NOT NULL DEFAULT '',
 637         languageID INT(10) NOT NULL DEFAULT 0,
 638         registrationDate INT(10) NOT NULL DEFAULT 0,
 639         styleID INT(10) NOT NULL DEFAULT 0,
 640
 641         KEY username (username),
 642         KEY registrationDate (registrationDate),
 643         KEY styleID (styleID)
 644 );
 645
 646 DROP TABLE IF EXISTS wcf1_user_collapsible_content;
 647 CREATE TABLE wcf1_user_collapsible_content (
 648         objectTypeID INT(10) NOT NULL,
 649         objectID VARCHAR(50) NOT NULL,
 650         userID INT(10) NOT NULL,
 651         UNIQUE KEY (objectTypeID, objectID, userID)
 652 );
 653
 654 DROP TABLE IF EXISTS wcf1_user_group;
 655 CREATE TABLE wcf1_user_group (
 656         groupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 657         groupName VARCHAR(255) NOT NULL DEFAULT '',
 658         groupType TINYINT(1) NOT NULL DEFAULT 4
 659 );
 660
 661 DROP TABLE IF EXISTS wcf1_user_group_option;
 662 CREATE TABLE wcf1_user_group_option (
 663         optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 664         packageID INT(10),
 665         optionName VARCHAR(255) NOT NULL DEFAULT '',
 666         categoryName VARCHAR(255) NOT NULL DEFAULT '',
 667         optionType VARCHAR(255) NOT NULL DEFAULT '',
 668         defaultValue MEDIUMTEXT,
 669         adminDefaultValue MEDIUMTEXT,
 670         validationPattern TEXT,
 671         enableOptions MEDIUMTEXT,
 672         showOrder INT(10) NOT NULL DEFAULT 0,
 673         permissions TEXT,
 674         options TEXT,
 675         additionalData MEDIUMTEXT,
 676         UNIQUE KEY optionName (optionName, packageID)
 677 );
 678
 679 DROP TABLE IF EXISTS wcf1_user_group_option_category;
 680 CREATE TABLE wcf1_user_group_option_category (
 681         categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 682         packageID INT(10) NOT NULL,
 683         categoryName VARCHAR(255) NOT NULL DEFAULT '',
 684         parentCategoryName VARCHAR(255) NOT NULL DEFAULT '',
 685         showOrder INT(10) NOT NULL DEFAULT 0,
 686         permissions TEXT,
 687         options TEXT,
 688         UNIQUE KEY categoryName (categoryName, packageID)
 689 );
 690
 691 DROP TABLE IF EXISTS wcf1_user_group_option_value;
 692 CREATE TABLE wcf1_user_group_option_value (
 693         groupID INT(10) NOT NULL,
 694         optionID INT(10) NOT NULL,
 695         optionValue MEDIUMTEXT NOT NULL,
 696         UNIQUE KEY groupID (groupID, optionID)
 697 );
 698
 699 DROP TABLE IF EXISTS wcf1_user_option;
 700 CREATE TABLE wcf1_user_option (
 701         optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 702         packageID INT(10) NOT NULL,
 703         optionName VARCHAR(255) NOT NULL DEFAULT '',
 704         categoryName VARCHAR(255) NOT NULL DEFAULT '',
 705         optionType VARCHAR(255) NOT NULL DEFAULT '',
 706         defaultValue MEDIUMTEXT,
 707         validationPattern TEXT,
 708         selectOptions MEDIUMTEXT,
 709         enableOptions MEDIUMTEXT,
 710         required TINYINT(1) NOT NULL DEFAULT 0,
 711         askDuringRegistration TINYINT(1) NOT NULL DEFAULT 0,
 712         editable TINYINT(1) NOT NULL DEFAULT 0,
 713         visible TINYINT(1) NOT NULL DEFAULT 0,
 714         outputClass VARCHAR(255) NOT NULL DEFAULT '',
 715         searchable TINYINT(1) NOT NULL DEFAULT 0,
 716         showOrder INT(10) NOT NULL DEFAULT 0,
 717         isDisabled TINYINT(1) NOT NULL DEFAULT 0,
 718         permissions TEXT,
 719         options TEXT,
 720         additionalData MEDIUMTEXT,
 721         UNIQUE KEY optionName (optionName, packageID),
 722         KEY categoryName (categoryName)
 723 );
 724
 725 DROP TABLE IF EXISTS wcf1_user_option_category;
 726 CREATE TABLE wcf1_user_option_category (
 727         categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 728         packageID INT(10) NOT NULL,
 729         categoryName VARCHAR(255) NOT NULL DEFAULT '',
 730         parentCategoryName VARCHAR(255) NOT NULL DEFAULT '',
 731         showOrder INT(10) NOT NULL DEFAULT 0,
 732         permissions TEXT,
 733         options TEXT,
 734         UNIQUE KEY categoryName (categoryName, packageID)
 735 );
 736
 737 DROP TABLE IF EXISTS wcf1_user_option_value;
 738 CREATE TABLE wcf1_user_option_value (
 739         userID INT(10) NOT NULL PRIMARY KEY
 740 );
 741
 742 DROP TABLE IF EXISTS wcf1_user_storage;
 743 CREATE TABLE wcf1_user_storage (
 744         userID INT(10) NOT NULL,
 745         field VARCHAR(80) NOT NULL DEFAULT '',
 746         fieldValue TEXT,
 747         UNIQUE KEY userStorageData (userID, field)
 748 );
 749
 750 DROP TABLE IF EXISTS wcf1_user_to_group;
 751 CREATE TABLE wcf1_user_to_group (
 752         userID INT(10) NOT NULL,
 753         groupID INT(10) NOT NULL,
 754         UNIQUE KEY userID (userID, groupID)
 755 );
 756
 757 DROP TABLE IF EXISTS wcf1_user_to_language;
 758 CREATE TABLE wcf1_user_to_language (
 759         userID INT(10) NOT NULL,
 760         languageID INT(10) NOT NULL,
 761         UNIQUE KEY userID (userID, languageID)
 762 );
 763
 764 /* foreign keys */
 765 ALTER TABLE wcf1_acl_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 766 ALTER TABLE wcf1_acl_option ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
 767
 768 ALTER TABLE wcf1_acl_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 769 ALTER TABLE wcf1_acl_option_category ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
 770
 771 ALTER TABLE wcf1_acl_option_to_user ADD FOREIGN KEY (optionID) REFERENCES wcf1_acl_option (optionID) ON DELETE CASCADE;
 772 ALTER TABLE wcf1_acl_option_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 773
 774 ALTER TABLE wcf1_acl_option_to_group ADD FOREIGN KEY (optionID) REFERENCES wcf1_acl_option (optionID) ON DELETE CASCADE;
 775 ALTER TABLE wcf1_acl_option_to_group ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
 776
 777 ALTER TABLE wcf1_acp_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 778
 779 ALTER TABLE wcf1_acp_search_provider ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 780
 781 ALTER TABLE wcf1_acp_session ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 782
 783 ALTER TABLE wcf1_acp_session_access_log ADD FOREIGN KEY (sessionLogID) REFERENCES wcf1_acp_session_log (sessionLogID) ON DELETE CASCADE;
 784
 785 ALTER TABLE wcf1_acp_session_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
 786
 787 ALTER TABLE wcf1_acp_template ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 788
 789 ALTER TABLE wcf1_application ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 790
 791 ALTER TABLE wcf1_category ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
 792
 793 ALTER TABLE wcf1_cleanup_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 794
 795 ALTER TABLE wcf1_cleanup_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 796
 797 ALTER TABLE wcf1_clipboard_action ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 798
 799 ALTER TABLE wcf1_clipboard_item ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
 800
 801 ALTER TABLE wcf1_clipboard_page ADD FOREIGN KEY (actionID) REFERENCES wcf1_clipboard_action (actionID) ON DELETE CASCADE;
 802 ALTER TABLE wcf1_clipboard_page ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 803
 804 ALTER TABLE wcf1_core_object ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 805
 806 ALTER TABLE wcf1_cronjob ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 807
 808 ALTER TABLE wcf1_cronjob_log ADD FOREIGN KEY (cronjobID) REFERENCES wcf1_cronjob (cronjobID) ON DELETE CASCADE;
 809
 810 ALTER TABLE wcf1_event_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 811
 812 ALTER TABLE wcf1_language_item ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
 813 ALTER TABLE wcf1_language_item ADD FOREIGN KEY (languageCategoryID) REFERENCES wcf1_language_category (languageCategoryID) ON DELETE CASCADE;
 814 ALTER TABLE wcf1_language_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 815
 816 ALTER TABLE wcf1_modification_log ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
 817 ALTER TABLE wcf1_modification_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
 818
 819 ALTER TABLE wcf1_object_type ADD FOREIGN KEY (definitionID) REFERENCES wcf1_object_type_definition (definitionID) ON DELETE CASCADE;
 820 ALTER TABLE wcf1_object_type ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 821
 822 ALTER TABLE wcf1_object_type_definition ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 823
 824 ALTER TABLE wcf1_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 825
 826 ALTER TABLE wcf1_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 827
 828 ALTER TABLE wcf1_package_exclusion ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 829
 830 ALTER TABLE wcf1_package_installation_file_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 831
 832 ALTER TABLE wcf1_package_installation_form ADD FOREIGN KEY (queueID) REFERENCES wcf1_package_installation_queue (queueID) ON DELETE CASCADE;
 833
 834 ALTER TABLE wcf1_package_installation_node ADD FOREIGN KEY (queueID) REFERENCES wcf1_package_installation_queue (queueID) ON DELETE CASCADE;
 835
 836 ALTER TABLE wcf1_package_installation_plugin ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 837
 838 ALTER TABLE wcf1_package_installation_queue ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 839 ALTER TABLE wcf1_package_installation_queue ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE SET NULL;
 840
 841 ALTER TABLE wcf1_package_installation_sql_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 842
 843 ALTER TABLE wcf1_package_requirement ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 844 ALTER TABLE wcf1_package_requirement ADD FOREIGN KEY (requirement) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 845
 846 ALTER TABLE wcf1_package_update ADD FOREIGN KEY (packageUpdateServerID) REFERENCES wcf1_package_update_server (packageUpdateServerID) ON DELETE CASCADE;
 847
 848 ALTER TABLE wcf1_package_update_exclusion ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
 849
 850 ALTER TABLE wcf1_package_update_fromversion ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
 851
 852 ALTER TABLE wcf1_package_update_requirement ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
 853
 854 ALTER TABLE wcf1_package_update_version ADD FOREIGN KEY (packageUpdateID) REFERENCES wcf1_package_update (packageUpdateID) ON DELETE CASCADE;
 855
 856 ALTER TABLE wcf1_page_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 857
 858 ALTER TABLE wcf1_search ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 859
 860 ALTER TABLE wcf1_session ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 861
 862 ALTER TABLE wcf1_sitemap ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 863
 864 ALTER TABLE wcf1_user_storage ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 865
 866 ALTER TABLE wcf1_style ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 867
 868 ALTER TABLE wcf1_style_variable_value ADD FOREIGN KEY (styleID) REFERENCES wcf1_style (styleID) ON DELETE CASCADE;
 869 ALTER TABLE wcf1_style_variable_value ADD FOREIGN KEY (variableID) REFERENCES wcf1_style_variable (variableID) ON DELETE CASCADE;
 870
 871 ALTER TABLE wcf1_template ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 872 ALTER TABLE wcf1_template ADD FOREIGN KEY (templateGroupID) REFERENCES wcf1_template_group (templateGroupID) ON DELETE CASCADE;
 873
 874 ALTER TABLE wcf1_template_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 875
 876 ALTER TABLE wcf1_user_collapsible_content ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
 877 ALTER TABLE wcf1_user_collapsible_content ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 878
 879 ALTER TABLE wcf1_user_group_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 880
 881 ALTER TABLE wcf1_user_group_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 882
 883 ALTER TABLE wcf1_user_group_option_value ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
 884 ALTER TABLE wcf1_user_group_option_value ADD FOREIGN KEY (optionID) REFERENCES wcf1_user_group_option (optionID) ON DELETE CASCADE;
 885
 886 ALTER TABLE wcf1_user_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 887
 888 ALTER TABLE wcf1_user_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 889
 890 ALTER TABLE wcf1_user_option_value ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 891
 892 ALTER TABLE wcf1_user_to_group ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 893 ALTER TABLE wcf1_user_to_group ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
 894
 895 ALTER TABLE wcf1_user_to_language ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 896 ALTER TABLE wcf1_user_to_language ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
 897
 898 /* default inserts */
 899 -- default user groups
 900 INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group1', 1);
 901 INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group2', 2);
 902 INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group3', 3);
 903 INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group4', 4);
 904 INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group5', 4);
 905 INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group6', 4);
 906
 907 -- default user group options
 908 INSERT INTO wcf1_user_group_option (optionName, categoryName, optionType, defaultValue, adminDefaultValue, showOrder) VALUES ('admin.general.canUseAcp', 'admin.general', 'boolean', '0', '1', 1);
 909 INSERT INTO wcf1_user_group_option (optionName, categoryName, optionType, defaultValue, adminDefaultValue, showOrder) VALUES ('admin.system.package.canInstallPackage', 'admin.system.package', 'boolean', '0', '1', 1);
 910 INSERT INTO wcf1_user_group_option (optionName, categoryName, optionType, defaultValue, adminDefaultValue, showOrder) VALUES ('admin.user.canEditGroup', 'admin.user.group', 'boolean', '0', '1', 1);
 911
 912 -- default user group option values
 913 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 1, '0');   -- Everyone
 914 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 2, '0');   -- Everyone
 915 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 3, '0');   -- Everyone
 916 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 1, '1');   -- Administrators
 917 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 2, '1');   -- Administrators
 918 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 3, '1');   -- Administrators
 919
 920 -- default update servers
 921 INSERT INTO wcf1_package_update_server (serverURL, status, isDisabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://update.woltlab.com/maelstrom/', 'online', 0, NULL, 0, '', '');
 922 INSERT INTO wcf1_package_update_server (serverURL, status, isDisabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://store.woltlab.com/maelstrom/', 'online', 0, NULL, 0, '', '');
 923
 924 -- style default values
 925 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentBackgroundColor', 'rgba(255, 255, 255, 1)');
 926 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfColor', 'rgba(102, 102, 102, 1)');
 927 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLinkColor', 'rgba(63, 127, 191, 1)');
 928 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLinkHoverColor', 'rgba(15, 79, 143, 1)');
 929 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerBackgroundColor', 'rgba(255, 255, 255, 1)');
 930 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerAccentBackgroundColor', 'rgba(249, 249, 249, 1)');
 931 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerHoverBackgroundColor', 'rgba(244, 244, 244, 1)');
 932 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerBorderColor', 'rgba(221, 221, 221, 1)');
 933 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerBorderRadius', '0');
 934 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxBackgroundColor', 'rgba(63, 127, 191, 1)');
 935 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxColor', 'rgba(255, 255, 255, 1)');
 936 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxHoverColor', 'rgba(255, 255, 255, 1)');
 937 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelBackgroundColor', 'rgba(45, 45, 45, 1)');
 938 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelColor', 'rgba(255, 255, 255, 1)');
 939 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelHoverColor', 'rgba(255, 255, 255, 1)');
 940 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBackgroundColor', 'rgba(249, 249, 249, 1)');
 941 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBorderColor', 'rgba(221, 221, 221, 1)');
 942 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonColor', 'rgba(102, 102, 102, 1)');
 943 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryBackgroundColor', 'rgba(211, 232, 254, 1)');
 944 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryBorderColor', 'rgba(136, 194, 255, 1)');
 945 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryColor', 'rgba(102, 153, 204, 1)');
 946 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryHoverBackgroundColor', 'darken(@wcfButtonPrimaryBackgroundColor, 3%)');
 947 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryHoverBorderColor', 'darken(@wcfButtonPrimaryBorderColor, 10%)');
 948 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryHoverColor', '@wcfButtonPrimaryColor');
 949 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonHoverBackgroundColor', 'rgba(241, 241, 241, 1)');
 950 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonHoverBorderColor', 'rgba(224, 224, 224, 1)');
 951 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonHoverColor', 'rgba(102, 102, 102, 1)');
 952 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBackgroundColor', 'rgba(255, 255, 255, 1)');
 953 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputColor', 'rgba(102, 102, 102, 1)');
 954 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBorderColor', 'rgba(204, 204, 204, 1)');
 955 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputHoverBackgroundColor', 'rgba(239, 247, 255, 1)');
 956 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputHoverBorderColor', 'rgba(198, 222, 248, 1)');
 957 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfBaseFontSize', '13px');
 958 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfBaseFontFamily', '"Trebuchet MS", Arial, sans-serif');
 959 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutFluidGap', '30px');
 960 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutFixedWidth', '1200px');
 961 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageBackgroundColor', 'rgba(224, 224, 224, 1)');
 962 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageColor', 'rgba(102, 102, 102, 1)');
 963 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageLinkColor', 'rgba(63, 127, 191, 1)');
 964 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageLinkHoverColor', 'rgba(15, 79, 143, 1)');
 965 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarBackgroundColor', '@wcfContainerHoverBackgroundColor');
 966 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDimmedColor', 'rgba(136, 136, 136, 1)');
 967 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLabelColor', '@wcfColor');
 968 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeadlineColor', '@wcfColor');
 969 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeadlineFontFamily', '"Trebuchet MS", Arial, sans-serif');
 970 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBackgroundColor', '@wcfContentBackgroundColor');
 971 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownColor', '@wcfColor');
 972 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBorderColor', '@wcfContainerBorderColor');
 973 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownHoverBackgroundColor', '@wcfContainerHoverBackgroundColor');
 974 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfBaseLineHeight', '1.27');
 975 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeadlineFontSize', '170%');
 976 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSubHeadlineFontSize', '140%');
 977 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTitleFontSize', '120%');
 978 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSmallFontSize', '85%');
 979 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfWarningColor', 'rgba(153, 153, 0, 1)');
 980 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfWarningBackgroundColor', 'rgba(255, 255, 221, 1)');
 981 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfWarningBorderColor', 'rgba(204, 204, 0, 1)');
 982 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfErrorColor', 'rgba(204, 0, 0, 1)');
 983 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfErrorBackgroundColor', 'rgba(255, 238, 238, 1)');
 984 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfErrorBorderColor', 'rgba(255, 153, 153, 1)');
 985 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSuccessColor', 'rgba(0, 153, 0, 1)');
 986 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSuccessBackgroundColor', 'rgba(238, 255, 238, 1)');
 987 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSuccessBorderColor', 'rgba(0, 204, 0, 1)');
 988 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInfoColor', 'rgba(102, 136, 187, 1)');
 989 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInfoBackgroundColor', 'rgba(221, 238, 255, 1)');
 990 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInfoBorderColor', 'rgba(153, 187, 238, 1)');
 991 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTooltipBackgroundColor', 'rgba(0, 0, 0, .8)');
 992 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTooltipColor', 'rgba(255, 255, 255, 1)');
 993 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapTiny', '4px');
 994 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapSmall', '7px');
 995 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapMedium', '14px');
 996 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapLarge', '21px');
 997 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationHeaderBackgroundColor', '@wcfContentBackgroundColor');
 998 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationFooterBackgroundColor', '@wcfContainerAccentBackgroundColor');
 999 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuBackgroundColor', '@wcfContainerAccentBackgroundColor');
1000 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuHoverBackgroundColor', '@wcfContainerAccentBackgroundColor');
1001 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuColor', '@wcfColor');
1002 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuActiveColor', '@wcfLinkColor');
1003 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelHoverBackgroundColor', 'rgba(60, 60, 60, 1)');
1004 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMarkedBackgroundColor', 'rgba(255, 255, 200, 1)');
1005 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('useFluidLayout', '1');
1006 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogo', '');
1007 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogoHeight', 'auto');
1008 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogoWidth', 'auto');
1009 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('individualLess', '');
1010 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('overrideLess', '');