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
 328         UNIQUE KEY optionName (optionName)
 329 );
 330
 331 DROP TABLE IF EXISTS wcf1_option_category;
 332 CREATE TABLE wcf1_option_category (
 333         categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 334         packageID INT(10) NOT NULL,
 335         categoryName VARCHAR(255) NOT NULL DEFAULT '',
 336         parentCategoryName VARCHAR(255) NOT NULL DEFAULT '',
 337         showOrder INT(10) NOT NULL DEFAULT 0,
 338         permissions TEXT,
 339         options TEXT,
 340         UNIQUE KEY categoryName (categoryName, packageID)
 341 );
 342
 343 DROP TABLE IF EXISTS wcf1_package;
 344 CREATE TABLE wcf1_package (
 345         packageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 346         package VARCHAR(255) NOT NULL DEFAULT '',
 347         packageDir VARCHAR(255) NOT NULL DEFAULT '',
 348         packageName VARCHAR(255) NOT NULL DEFAULT '',
 349         packageDescription VARCHAR(255) NOT NULL DEFAULT '',
 350         packageVersion VARCHAR(255) NOT NULL DEFAULT '',
 351         packageDate INT(10) NOT NULL DEFAULT 0,
 352         installDate INT(10) NOT NULL DEFAULT 0,
 353         updateDate INT(10) NOT NULL DEFAULT 0,
 354         packageURL VARCHAR(255) NOT NULL DEFAULT '',
 355         isApplication TINYINT(1) NOT NULL DEFAULT 0,
 356         author VARCHAR(255) NOT NULL DEFAULT '',
 357         authorURL VARCHAR(255) NOT NULL DEFAULT '',
 358         packageIcon VARCHAR(30) NOT NULL DEFAULT '',
 359         KEY package (package)
 360 );
 361
 362 DROP TABLE IF EXISTS wcf1_package_exclusion;
 363 CREATE TABLE wcf1_package_exclusion (
 364         packageID INT(10) NOT NULL,
 365         excludedPackage VARCHAR(255) NOT NULL DEFAULT '',
 366         excludedPackageVersion VARCHAR(255) NOT NULL DEFAULT '',
 367         UNIQUE KEY packageID (packageID, excludedPackage)
 368 );
 369
 370 DROP TABLE IF EXISTS wcf1_package_installation_file_log;
 371 CREATE TABLE wcf1_package_installation_file_log (
 372         packageID INT(10),
 373         filename VARCHAR(255) NOT NULL DEFAULT '',
 374         UNIQUE KEY packageID (packageID, filename)
 375 );
 376
 377 DROP TABLE IF EXISTS wcf1_package_installation_form;
 378 CREATE TABLE wcf1_package_installation_form (
 379         queueID INT(10) NOT NULL,
 380         formName VARCHAR(80) NOT NULL DEFAULT '',
 381         document TEXT NOT NULL,
 382         UNIQUE KEY formDocument (queueID, formName)
 383 );
 384
 385 DROP TABLE IF EXISTS wcf1_package_installation_node;
 386 CREATE TABLE wcf1_package_installation_node (
 387         queueID INT(10) NOT NULL,
 388         processNo INT(10) NOT NULL DEFAULT 0,
 389         sequenceNo SMALLINT(4) NOT NULL DEFAULT 0,
 390         node CHAR(8) NOT NULL DEFAULT '',
 391         parentNode CHAR(8) NOT NULL DEFAULT '',
 392         nodeType ENUM('optionalPackages','package', 'pip') NOT NULL DEFAULT 'package',
 393         nodeData TEXT NOT NULL,
 394         done TINYINT(1) NOT NULL DEFAULT 0
 395 );
 396
 397 DROP TABLE IF EXISTS wcf1_package_installation_plugin;
 398 CREATE TABLE wcf1_package_installation_plugin (
 399         pluginName VARCHAR(255) NOT NULL PRIMARY KEY,
 400         packageID INT(10),
 401         priority TINYINT(1) NOT NULL DEFAULT 0,
 402         className VARCHAR(255) NOT NULL
 403 );
 404
 405 DROP TABLE IF EXISTS wcf1_package_installation_queue;
 406 CREATE TABLE wcf1_package_installation_queue (
 407         queueID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 408         parentQueueID INT(10) NOT NULL DEFAULT 0,
 409         processNo INT(10) NOT NULL DEFAULT 0,
 410         userID INT(10) NOT NULL,
 411         package VARCHAR(255) NOT NULL DEFAULT '',
 412         packageName VARCHAR(255) NOT NULL DEFAULT '',
 413         packageID INT(10),
 414         archive VARCHAR(255) NOT NULL DEFAULT '',
 415         action ENUM('install', 'update', 'uninstall') NOT NULL DEFAULT 'install',
 416         done TINYINT(1) NOT NULL DEFAULT 0,
 417         confirmInstallation TINYINT(1) NOT NULL DEFAULT 0,
 418         packageType ENUM('default', 'requirement', 'optional') NOT NULL DEFAULT 'default'
 419 );
 420
 421 DROP TABLE IF EXISTS wcf1_package_installation_sql_log;
 422 CREATE TABLE wcf1_package_installation_sql_log (
 423         packageID INT(10),
 424         sqlTable VARCHAR(100) NOT NULL DEFAULT '',
 425         sqlColumn VARCHAR(100) NOT NULL DEFAULT '',
 426         sqlIndex VARCHAR(100) NOT NULL DEFAULT '',
 427         UNIQUE KEY packageID (packageID, sqlTable, sqlColumn, sqlIndex)
 428 );
 429
 430 DROP TABLE IF EXISTS wcf1_package_requirement;
 431 CREATE TABLE wcf1_package_requirement (
 432         packageID INT(10) NOT NULL,
 433         requirement INT(10) NOT NULL,
 434         UNIQUE KEY packageID (packageID, requirement)
 435 );
 436
 437 DROP TABLE IF EXISTS wcf1_package_update;
 438 CREATE TABLE wcf1_package_update (
 439         packageUpdateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 440         packageUpdateServerID INT(10) NOT NULL,
 441         package VARCHAR(255) NOT NULL DEFAULT '',
 442         packageName VARCHAR(255) NOT NULL DEFAULT '',
 443         packageDescription VARCHAR(255) NOT NULL DEFAULT '',
 444         author VARCHAR(255) NOT NULL DEFAULT '',
 445         authorURL VARCHAR(255) NOT NULL DEFAULT '',
 446         isApplication TINYINT(1) NOT NULL DEFAULT 0
 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_optional;
 466 CREATE TABLE wcf1_package_update_optional (
 467         packageUpdateVersionID INT(10) NOT NULL DEFAULT 0,
 468         package VARCHAR(255) NOT NULL DEFAULT ''
 469 );
 470
 471 DROP TABLE IF EXISTS wcf1_package_update_requirement;
 472 CREATE TABLE wcf1_package_update_requirement (
 473         packageUpdateVersionID INT(10) NOT NULL,
 474         package VARCHAR(255) NOT NULL DEFAULT '',
 475         minversion VARCHAR(50) NOT NULL DEFAULT '',
 476         UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, package)
 477 );
 478
 479 DROP TABLE IF EXISTS wcf1_package_update_server;
 480 CREATE TABLE wcf1_package_update_server (
 481         packageUpdateServerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 482         serverURL VARCHAR(255) NOT NULL DEFAULT '',
 483         loginUsername VARCHAR(255) NOT NULL DEFAULT '',
 484         loginPassword VARCHAR(255) NOT NULL DEFAULT '',
 485         isDisabled TINYINT(1) NOT NULL DEFAULT 0,
 486         lastUpdateTime INT(10) NOT NULL DEFAULT 0,
 487         status ENUM('online', 'offline') NOT NULL DEFAULT 'online',
 488         errorMessage TEXT
 489 );
 490
 491 DROP TABLE IF EXISTS wcf1_package_update_version;
 492 CREATE TABLE wcf1_package_update_version (
 493         packageUpdateVersionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 494         packageUpdateID INT(10) NOT NULL,
 495         packageVersion VARCHAR(50) NOT NULL DEFAULT '',
 496         packageDate INT(10) NOT NULL DEFAULT 0,
 497         filename VARCHAR(255) NOT NULL DEFAULT '',
 498         license VARCHAR(255) NOT NULL DEFAULT '',
 499         licenseURL VARCHAR(255) NOT NULL DEFAULT '',
 500         isAccessible TINYINT(1) NOT NULL DEFAULT 1,
 501         isCritical TINYINT(1) NOT NULL DEFAULT 0,
 502         UNIQUE KEY packageUpdateID (packageUpdateID, packageVersion)
 503 );
 504
 505 DROP TABLE IF EXISTS wcf1_page_menu_item;
 506 CREATE TABLE wcf1_page_menu_item (
 507         menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 508         packageID INT(10) NOT NULL,
 509         menuItem VARCHAR(255) NOT NULL DEFAULT '',
 510         parentMenuItem VARCHAR(255) NOT NULL DEFAULT '',
 511         menuItemController VARCHAR(255) NOT NULL DEFAULT '',
 512         menuItemLink VARCHAR(255) NOT NULL DEFAULT '',
 513         menuPosition ENUM('header', 'footer') NOT NULL DEFAULT 'header',
 514         showOrder INT(10) NOT NULL DEFAULT 0,
 515         permissions TEXT NULL,
 516         options TEXT NULL,
 517         isDisabled TINYINT(1) NOT NULL DEFAULT 0,
 518         className VARCHAR(255) NOT NULL DEFAULT '',
 519         isLandingPage TINYINT(1) NOT NULL DEFAULT 0,
 520         UNIQUE KEY (packageID, menuItem)
 521 );
 522
 523 DROP TABLE IF EXISTS wcf1_search;
 524 CREATE TABLE wcf1_search (
 525         searchID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 526         userID INT(10),
 527         searchData MEDIUMTEXT NOT NULL,
 528         searchTime INT(10) NOT NULL DEFAULT 0,
 529         searchType VARCHAR(255) NOT NULL DEFAULT '',
 530         searchHash CHAR(40) NOT NULL DEFAULT '',
 531         KEY searchHash (searchHash)
 532 );
 533
 534 DROP TABLE IF EXISTS wcf1_session;
 535 CREATE TABLE wcf1_session (
 536         sessionID CHAR(40) NOT NULL PRIMARY KEY,
 537         userID INT(10),
 538         ipAddress VARCHAR(39) NOT NULL DEFAULT '',
 539         userAgent VARCHAR(255) NOT NULL DEFAULT '',
 540         lastActivityTime INT(10) NOT NULL DEFAULT 0,
 541         requestURI VARCHAR(255) NOT NULL DEFAULT '',
 542         requestMethod VARCHAR(4) NOT NULL DEFAULT '',
 543         controller VARCHAR(255) NOT NULL DEFAULT '',
 544         parentObjectType VARCHAR(255) NOT NULL DEFAULT '',
 545         parentObjectID INT(10) NOT NULL DEFAULT 0,
 546         objectType VARCHAR(255) NOT NULL DEFAULT '',
 547         objectID INT(10) NOT NULL DEFAULT 0,
 548         sessionVariables MEDIUMTEXT,
 549         spiderID INT(10) NOT NULL DEFAULT 0,
 550         KEY packageID (lastActivityTime, spiderID)
 551 );
 552
 553 DROP TABLE IF EXISTS wcf1_sitemap;
 554 CREATE TABLE wcf1_sitemap (
 555         sitemapID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 556         packageID INT(10) NOT NULL,
 557         sitemapName VARCHAR(80) NOT NULL DEFAULT '',
 558         className VARCHAR(255) NOT NULL DEFAULT '',
 559         showOrder INT(10) NOT NULL DEFAULT 0,
 560         UNIQUE KEY sitemapName (packageID, sitemapName)
 561 );
 562
 563 DROP TABLE IF EXISTS wcf1_spider;
 564 CREATE TABLE wcf1_spider (
 565         spiderID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 566         spiderIdentifier VARCHAR(255) DEFAULT '',
 567         spiderName VARCHAR(255) DEFAULT '',
 568         spiderURL VARCHAR(255) DEFAULT '',
 569         UNIQUE KEY spiderIdentifier (spiderIdentifier)
 570 );
 571
 572 DROP TABLE IF EXISTS wcf1_style;
 573 CREATE TABLE wcf1_style (
 574         styleID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 575         packageID INT(10) NOT NULL,
 576         styleName VARCHAR(255) NOT NULL DEFAULT '',
 577         templateGroupID INT(10) NOT NULL DEFAULT 0,
 578         isDefault TINYINT(1) NOT NULL DEFAULT 0,
 579         isDisabled TINYINT(1) NOT NULL DEFAULT 0,
 580         styleDescription VARCHAR(30) NOT NULL DEFAULT '',
 581         styleVersion VARCHAR(255) NOT NULL DEFAULT '',
 582         styleDate CHAR(10) NOT NULL DEFAULT '0000-00-00',
 583         image VARCHAR(255) NOT NULL DEFAULT '',
 584         copyright VARCHAR(255) NOT NULL DEFAULT '',
 585         license VARCHAR(255) NOT NULL DEFAULT '',
 586         authorName VARCHAR(255) NOT NULL DEFAULT '',
 587         authorURL VARCHAR(255) NOT NULL DEFAULT '',
 588         iconPath VARCHAR(255) NOT NULL DEFAULT '',
 589         imagePath VARCHAR(255) NOT NULL DEFAULT ''
 590 );
 591
 592 DROP TABLE IF EXISTS wcf1_style_variable;
 593 CREATE TABLE wcf1_style_variable (
 594         variableID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 595         variableName VARCHAR(50) NOT NULL,
 596         defaultValue MEDIUMTEXT,
 597         UNIQUE KEY variableName (variableName)
 598 );
 599
 600 DROP TABLE IF EXISTS wcf1_style_variable_value;
 601 CREATE TABLE wcf1_style_variable_value (
 602         styleID INT(10) NOT NULL,
 603         variableID INT(10) NOT NULL,
 604         variableValue MEDIUMTEXT,
 605         UNIQUE KEY (styleID, variableID)
 606 );
 607
 608 DROP TABLE IF EXISTS wcf1_template;
 609 CREATE TABLE wcf1_template (
 610         templateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 611         packageID INT(10) NOT NULL,
 612         templateName VARCHAR(255) NOT NULL DEFAULT '',
 613         templateGroupID INT(10),
 614         obsolete TINYINT(1) NOT NULL DEFAULT 0,
 615         KEY packageID (packageID, templateName),
 616         KEY templateGroupID (packageID, templateGroupID, templateName)
 617 );
 618
 619 DROP TABLE IF EXISTS wcf1_template_group;
 620 CREATE TABLE wcf1_template_group (
 621         templateGroupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 622         parentTemplateGroupID INT(10) NOT NULL DEFAULT 0,
 623         templateGroupName VARCHAR(255) NOT NULL DEFAULT '',
 624         templateGroupFolderName VARCHAR(255) NOT NULL DEFAULT ''
 625 );
 626
 627 DROP TABLE IF EXISTS wcf1_template_listener;
 628 CREATE TABLE wcf1_template_listener (
 629         listenerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 630         packageID INT(10) NOT NULL,
 631         name VARCHAR(80) NOT NULL DEFAULT '',
 632         environment ENUM('user','admin') NOT NULL DEFAULT 'user',
 633         templateName VARCHAR(80) NOT NULL DEFAULT '',
 634         eventName VARCHAR(50) NOT NULL DEFAULT '',
 635         templateCode TEXT NOT NULL,
 636         KEY templateName (environment, templateName)
 637 );
 638
 639 DROP TABLE IF EXISTS wcf1_user;
 640 CREATE TABLE wcf1_user (
 641         userID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 642         username VARCHAR(255) NOT NULL DEFAULT '',
 643         email VARCHAR(255) NOT NULL DEFAULT '',
 644         password VARCHAR(100) NOT NULL DEFAULT '',
 645         accessToken CHAR(40) NOT NULL DEFAULT '',
 646         languageID INT(10) NOT NULL DEFAULT 0,
 647         registrationDate INT(10) NOT NULL DEFAULT 0,
 648         styleID INT(10) NOT NULL DEFAULT 0,
 649
 650         KEY username (username),
 651         KEY registrationDate (registrationDate),
 652         KEY styleID (styleID)
 653 );
 654
 655 DROP TABLE IF EXISTS wcf1_user_collapsible_content;
 656 CREATE TABLE wcf1_user_collapsible_content (
 657         objectTypeID INT(10) NOT NULL,
 658         objectID VARCHAR(50) NOT NULL,
 659         userID INT(10) NOT NULL,
 660         UNIQUE KEY (objectTypeID, objectID, userID)
 661 );
 662
 663 DROP TABLE IF EXISTS wcf1_user_group;
 664 CREATE TABLE wcf1_user_group (
 665         groupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 666         groupName VARCHAR(255) NOT NULL DEFAULT '',
 667         groupType TINYINT(1) NOT NULL DEFAULT 4
 668 );
 669
 670 DROP TABLE IF EXISTS wcf1_user_group_option;
 671 CREATE TABLE wcf1_user_group_option (
 672         optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 673         packageID INT(10),
 674         optionName VARCHAR(255) NOT NULL DEFAULT '',
 675         categoryName VARCHAR(255) NOT NULL DEFAULT '',
 676         optionType VARCHAR(255) NOT NULL DEFAULT '',
 677         defaultValue MEDIUMTEXT,
 678         adminDefaultValue MEDIUMTEXT,
 679         validationPattern TEXT,
 680         enableOptions MEDIUMTEXT,
 681         showOrder INT(10) NOT NULL DEFAULT 0,
 682         permissions TEXT,
 683         options TEXT,
 684         additionalData MEDIUMTEXT,
 685         UNIQUE KEY optionName (optionName, packageID)
 686 );
 687
 688 DROP TABLE IF EXISTS wcf1_user_group_option_category;
 689 CREATE TABLE wcf1_user_group_option_category (
 690         categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 691         packageID INT(10) NOT NULL,
 692         categoryName VARCHAR(255) NOT NULL DEFAULT '',
 693         parentCategoryName VARCHAR(255) NOT NULL DEFAULT '',
 694         showOrder INT(10) NOT NULL DEFAULT 0,
 695         permissions TEXT,
 696         options TEXT,
 697         UNIQUE KEY categoryName (categoryName, packageID)
 698 );
 699
 700 DROP TABLE IF EXISTS wcf1_user_group_option_value;
 701 CREATE TABLE wcf1_user_group_option_value (
 702         groupID INT(10) NOT NULL,
 703         optionID INT(10) NOT NULL,
 704         optionValue MEDIUMTEXT NOT NULL,
 705         UNIQUE KEY groupID (groupID, optionID)
 706 );
 707
 708 DROP TABLE IF EXISTS wcf1_user_option;
 709 CREATE TABLE wcf1_user_option (
 710         optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 711         packageID INT(10) NOT NULL,
 712         optionName VARCHAR(255) NOT NULL DEFAULT '',
 713         categoryName VARCHAR(255) NOT NULL DEFAULT '',
 714         optionType VARCHAR(255) NOT NULL DEFAULT '',
 715         defaultValue MEDIUMTEXT,
 716         validationPattern TEXT,
 717         selectOptions MEDIUMTEXT,
 718         enableOptions MEDIUMTEXT,
 719         required TINYINT(1) NOT NULL DEFAULT 0,
 720         askDuringRegistration TINYINT(1) NOT NULL DEFAULT 0,
 721         editable TINYINT(1) NOT NULL DEFAULT 0,
 722         visible TINYINT(1) NOT NULL DEFAULT 0,
 723         outputClass VARCHAR(255) NOT NULL DEFAULT '',
 724         searchable TINYINT(1) NOT NULL DEFAULT 0,
 725         showOrder INT(10) NOT NULL DEFAULT 0,
 726         isDisabled TINYINT(1) NOT NULL DEFAULT 0,
 727         permissions TEXT,
 728         options TEXT,
 729         additionalData MEDIUMTEXT,
 730         UNIQUE KEY optionName (optionName, packageID),
 731         KEY categoryName (categoryName)
 732 );
 733
 734 DROP TABLE IF EXISTS wcf1_user_option_category;
 735 CREATE TABLE wcf1_user_option_category (
 736         categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 737         packageID INT(10) NOT NULL,
 738         categoryName VARCHAR(255) NOT NULL DEFAULT '',
 739         parentCategoryName VARCHAR(255) NOT NULL DEFAULT '',
 740         showOrder INT(10) NOT NULL DEFAULT 0,
 741         permissions TEXT,
 742         options TEXT,
 743         UNIQUE KEY categoryName (categoryName, packageID)
 744 );
 745
 746 DROP TABLE IF EXISTS wcf1_user_option_value;
 747 CREATE TABLE wcf1_user_option_value (
 748         userID INT(10) NOT NULL PRIMARY KEY
 749 );
 750
 751 DROP TABLE IF EXISTS wcf1_user_storage;
 752 CREATE TABLE wcf1_user_storage (
 753         userID INT(10) NOT NULL,
 754         field VARCHAR(80) NOT NULL DEFAULT '',
 755         fieldValue TEXT,
 756         UNIQUE KEY userStorageData (userID, field)
 757 );
 758
 759 DROP TABLE IF EXISTS wcf1_user_to_group;
 760 CREATE TABLE wcf1_user_to_group (
 761         userID INT(10) NOT NULL,
 762         groupID INT(10) NOT NULL,
 763         UNIQUE KEY userID (userID, groupID)
 764 );
 765
 766 DROP TABLE IF EXISTS wcf1_user_to_language;
 767 CREATE TABLE wcf1_user_to_language (
 768         userID INT(10) NOT NULL,
 769         languageID INT(10) NOT NULL,
 770         UNIQUE KEY userID (userID, languageID)
 771 );
 772
 773 /* foreign keys */
 774 ALTER TABLE wcf1_acl_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 775 ALTER TABLE wcf1_acl_option ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
 776
 777 ALTER TABLE wcf1_acl_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 778 ALTER TABLE wcf1_acl_option_category ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
 779
 780 ALTER TABLE wcf1_acl_option_to_user ADD FOREIGN KEY (optionID) REFERENCES wcf1_acl_option (optionID) ON DELETE CASCADE;
 781 ALTER TABLE wcf1_acl_option_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 782
 783 ALTER TABLE wcf1_acl_option_to_group ADD FOREIGN KEY (optionID) REFERENCES wcf1_acl_option (optionID) ON DELETE CASCADE;
 784 ALTER TABLE wcf1_acl_option_to_group ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
 785
 786 ALTER TABLE wcf1_acp_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 787
 788 ALTER TABLE wcf1_acp_search_provider ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 789
 790 ALTER TABLE wcf1_acp_session ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 791
 792 ALTER TABLE wcf1_acp_session_access_log ADD FOREIGN KEY (sessionLogID) REFERENCES wcf1_acp_session_log (sessionLogID) ON DELETE CASCADE;
 793
 794 ALTER TABLE wcf1_acp_session_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
 795
 796 ALTER TABLE wcf1_acp_template ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 797
 798 ALTER TABLE wcf1_application ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 799
 800 ALTER TABLE wcf1_category ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
 801
 802 ALTER TABLE wcf1_cleanup_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 803
 804 ALTER TABLE wcf1_cleanup_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 805
 806 ALTER TABLE wcf1_clipboard_action ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 807
 808 ALTER TABLE wcf1_clipboard_item ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
 809
 810 ALTER TABLE wcf1_clipboard_page ADD FOREIGN KEY (actionID) REFERENCES wcf1_clipboard_action (actionID) ON DELETE CASCADE;
 811 ALTER TABLE wcf1_clipboard_page ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 812
 813 ALTER TABLE wcf1_core_object ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 814
 815 ALTER TABLE wcf1_cronjob ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 816
 817 ALTER TABLE wcf1_cronjob_log ADD FOREIGN KEY (cronjobID) REFERENCES wcf1_cronjob (cronjobID) ON DELETE CASCADE;
 818
 819 ALTER TABLE wcf1_event_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 820
 821 ALTER TABLE wcf1_language_item ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
 822 ALTER TABLE wcf1_language_item ADD FOREIGN KEY (languageCategoryID) REFERENCES wcf1_language_category (languageCategoryID) ON DELETE CASCADE;
 823 ALTER TABLE wcf1_language_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 824
 825 ALTER TABLE wcf1_modification_log ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
 826 ALTER TABLE wcf1_modification_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
 827
 828 ALTER TABLE wcf1_object_type ADD FOREIGN KEY (definitionID) REFERENCES wcf1_object_type_definition (definitionID) ON DELETE CASCADE;
 829 ALTER TABLE wcf1_object_type ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 830
 831 ALTER TABLE wcf1_object_type_definition ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 832
 833 ALTER TABLE wcf1_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 834
 835 ALTER TABLE wcf1_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 836
 837 ALTER TABLE wcf1_package_exclusion ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 838
 839 ALTER TABLE wcf1_package_installation_file_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 840
 841 ALTER TABLE wcf1_package_installation_form ADD FOREIGN KEY (queueID) REFERENCES wcf1_package_installation_queue (queueID) ON DELETE CASCADE;
 842
 843 ALTER TABLE wcf1_package_installation_node ADD FOREIGN KEY (queueID) REFERENCES wcf1_package_installation_queue (queueID) ON DELETE CASCADE;
 844
 845 ALTER TABLE wcf1_package_installation_plugin ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 846
 847 ALTER TABLE wcf1_package_installation_queue ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 848 ALTER TABLE wcf1_package_installation_queue ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE SET NULL;
 849
 850 ALTER TABLE wcf1_package_installation_sql_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 851
 852 ALTER TABLE wcf1_package_requirement ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 853 ALTER TABLE wcf1_package_requirement ADD FOREIGN KEY (requirement) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 854
 855 ALTER TABLE wcf1_package_update ADD FOREIGN KEY (packageUpdateServerID) REFERENCES wcf1_package_update_server (packageUpdateServerID) ON DELETE CASCADE;
 856
 857 ALTER TABLE wcf1_package_update_exclusion ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
 858
 859 ALTER TABLE wcf1_package_update_fromversion ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
 860
 861 ALTER TABLE wcf1_package_update_requirement ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
 862
 863 ALTER TABLE wcf1_package_update_optional ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
 864
 865 ALTER TABLE wcf1_package_update_version ADD FOREIGN KEY (packageUpdateID) REFERENCES wcf1_package_update (packageUpdateID) ON DELETE CASCADE;
 866
 867 ALTER TABLE wcf1_page_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 868
 869 ALTER TABLE wcf1_search ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 870
 871 ALTER TABLE wcf1_session ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 872
 873 ALTER TABLE wcf1_sitemap ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 874
 875 ALTER TABLE wcf1_user_storage ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 876
 877 ALTER TABLE wcf1_style ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 878
 879 ALTER TABLE wcf1_style_variable_value ADD FOREIGN KEY (styleID) REFERENCES wcf1_style (styleID) ON DELETE CASCADE;
 880 ALTER TABLE wcf1_style_variable_value ADD FOREIGN KEY (variableID) REFERENCES wcf1_style_variable (variableID) ON DELETE CASCADE;
 881
 882 ALTER TABLE wcf1_template ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 883 ALTER TABLE wcf1_template ADD FOREIGN KEY (templateGroupID) REFERENCES wcf1_template_group (templateGroupID) ON DELETE CASCADE;
 884
 885 ALTER TABLE wcf1_template_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 886
 887 ALTER TABLE wcf1_user_collapsible_content ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
 888 ALTER TABLE wcf1_user_collapsible_content ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 889
 890 ALTER TABLE wcf1_user_group_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 891
 892 ALTER TABLE wcf1_user_group_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 893
 894 ALTER TABLE wcf1_user_group_option_value ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
 895 ALTER TABLE wcf1_user_group_option_value ADD FOREIGN KEY (optionID) REFERENCES wcf1_user_group_option (optionID) ON DELETE CASCADE;
 896
 897 ALTER TABLE wcf1_user_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 898
 899 ALTER TABLE wcf1_user_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 900
 901 ALTER TABLE wcf1_user_option_value ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 902
 903 ALTER TABLE wcf1_user_to_group ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 904 ALTER TABLE wcf1_user_to_group ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
 905
 906 ALTER TABLE wcf1_user_to_language ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 907 ALTER TABLE wcf1_user_to_language ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
 908
 909 /* default inserts */
 910 -- default user groups
 911 INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group1', 1);
 912 INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group2', 2);
 913 INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group3', 3);
 914 INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group4', 4);
 915 INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group5', 4);
 916 INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group6', 4);
 917
 918 -- default user group options
 919 INSERT INTO wcf1_user_group_option (optionName, categoryName, optionType, defaultValue, adminDefaultValue, showOrder) VALUES ('admin.general.canUseAcp', 'admin.general', 'boolean', '0', '1', 1);
 920 INSERT INTO wcf1_user_group_option (optionName, categoryName, optionType, defaultValue, adminDefaultValue, showOrder) VALUES ('admin.system.package.canInstallPackage', 'admin.system.package', 'boolean', '0', '1', 1);
 921 INSERT INTO wcf1_user_group_option (optionName, categoryName, optionType, defaultValue, adminDefaultValue, showOrder) VALUES ('admin.user.canEditGroup', 'admin.user.group', 'boolean', '0', '1', 1);
 922
 923 -- default user group option values
 924 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 1, '0');   -- Everyone
 925 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 2, '0');   -- Everyone
 926 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 3, '0');   -- Everyone
 927 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 1, '1');   -- Administrators
 928 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 2, '1');   -- Administrators
 929 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 3, '1');   -- Administrators
 930
 931 -- default update servers
 932 INSERT INTO wcf1_package_update_server (serverURL, status, isDisabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://update.woltlab.com/maelstrom/', 'online', 0, NULL, 0, '', '');
 933 INSERT INTO wcf1_package_update_server (serverURL, status, isDisabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://store.woltlab.com/maelstrom/', 'online', 0, NULL, 0, '', '');
 934
 935 -- style default values
 936 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentBackgroundColor', 'rgba(255, 255, 255, 1)');
 937 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfColor', 'rgba(102, 102, 102, 1)');
 938 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLinkColor', 'rgba(63, 127, 191, 1)');
 939 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLinkHoverColor', 'rgba(15, 79, 143, 1)');
 940 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerBackgroundColor', 'rgba(255, 255, 255, 1)');
 941 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerAccentBackgroundColor', 'rgba(249, 249, 249, 1)');
 942 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerHoverBackgroundColor', 'rgba(244, 244, 244, 1)');
 943 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerBorderColor', 'rgba(221, 221, 221, 1)');
 944 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerBorderRadius', '0');
 945 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxBackgroundColor', 'rgba(63, 127, 191, 1)');
 946 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxColor', 'rgba(255, 255, 255, 1)');
 947 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxHoverColor', 'rgba(255, 255, 255, 1)');
 948 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelBackgroundColor', 'rgba(45, 45, 45, 1)');
 949 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelColor', 'rgba(255, 255, 255, 1)');
 950 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelHoverColor', 'rgba(255, 255, 255, 1)');
 951 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBackgroundColor', 'rgba(249, 249, 249, 1)');
 952 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBorderColor', 'rgba(221, 221, 221, 1)');
 953 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonColor', 'rgba(102, 102, 102, 1)');
 954 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryBackgroundColor', 'rgba(211, 232, 254, 1)');
 955 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryBorderColor', 'rgba(136, 194, 255, 1)');
 956 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryColor', 'rgba(102, 153, 204, 1)');
 957 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryHoverBackgroundColor', 'darken(@wcfButtonPrimaryBackgroundColor, 3%)');
 958 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryHoverBorderColor', 'darken(@wcfButtonPrimaryBorderColor, 10%)');
 959 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryHoverColor', '@wcfButtonPrimaryColor');
 960 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonHoverBackgroundColor', 'rgba(241, 241, 241, 1)');
 961 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonHoverBorderColor', 'rgba(224, 224, 224, 1)');
 962 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonHoverColor', 'rgba(102, 102, 102, 1)');
 963 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBackgroundColor', 'rgba(255, 255, 255, 1)');
 964 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputColor', 'rgba(102, 102, 102, 1)');
 965 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBorderColor', 'rgba(204, 204, 204, 1)');
 966 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputHoverBackgroundColor', 'rgba(239, 247, 255, 1)');
 967 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputHoverBorderColor', 'rgba(198, 222, 248, 1)');
 968 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfBaseFontSize', '13px');
 969 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfBaseFontFamily', '"Trebuchet MS", Arial, sans-serif');
 970 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutFluidGap', '30px');
 971 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutFixedWidth', '1200px');
 972 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageBackgroundColor', 'rgba(224, 224, 224, 1)');
 973 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageColor', 'rgba(102, 102, 102, 1)');
 974 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageLinkColor', 'rgba(63, 127, 191, 1)');
 975 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageLinkHoverColor', 'rgba(15, 79, 143, 1)');
 976 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarBackgroundColor', '@wcfContainerHoverBackgroundColor');
 977 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDimmedColor', 'rgba(136, 136, 136, 1)');
 978 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLabelColor', '@wcfColor');
 979 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeadlineColor', '@wcfColor');
 980 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeadlineFontFamily', '"Trebuchet MS", Arial, sans-serif');
 981 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBackgroundColor', '@wcfContentBackgroundColor');
 982 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownColor', '@wcfColor');
 983 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBorderColor', '@wcfContainerBorderColor');
 984 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownHoverBackgroundColor', '@wcfContainerHoverBackgroundColor');
 985 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfBaseLineHeight', '1.27');
 986 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeadlineFontSize', '170%');
 987 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSubHeadlineFontSize', '140%');
 988 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTitleFontSize', '120%');
 989 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSmallFontSize', '85%');
 990 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfWarningColor', 'rgba(153, 153, 0, 1)');
 991 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfWarningBackgroundColor', 'rgba(255, 255, 221, 1)');
 992 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfWarningBorderColor', 'rgba(204, 204, 0, 1)');
 993 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfErrorColor', 'rgba(204, 0, 0, 1)');
 994 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfErrorBackgroundColor', 'rgba(255, 238, 238, 1)');
 995 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfErrorBorderColor', 'rgba(255, 153, 153, 1)');
 996 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSuccessColor', 'rgba(0, 153, 0, 1)');
 997 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSuccessBackgroundColor', 'rgba(238, 255, 238, 1)');
 998 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSuccessBorderColor', 'rgba(0, 204, 0, 1)');
 999 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInfoColor', 'rgba(102, 136, 187, 1)');
1000 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInfoBackgroundColor', 'rgba(221, 238, 255, 1)');
1001 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInfoBorderColor', 'rgba(153, 187, 238, 1)');
1002 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTooltipBackgroundColor', 'rgba(0, 0, 0, .8)');
1003 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTooltipColor', 'rgba(255, 255, 255, 1)');
1004 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapTiny', '4px');
1005 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapSmall', '7px');
1006 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapMedium', '14px');
1007 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapLarge', '21px');
1008 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationHeaderBackgroundColor', '@wcfContentBackgroundColor');
1009 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationFooterBackgroundColor', '@wcfContainerAccentBackgroundColor');
1010 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuBackgroundColor', '@wcfContainerAccentBackgroundColor');
1011 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuHoverBackgroundColor', '@wcfContainerAccentBackgroundColor');
1012 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuColor', '@wcfColor');
1013 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuActiveColor', '@wcfLinkColor');
1014 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelHoverBackgroundColor', 'rgba(60, 60, 60, 1)');
1015 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMarkedBackgroundColor', 'rgba(255, 255, 200, 1)');
1016 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('useFluidLayout', '1');
1017 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogo', '');
1018 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogoHeight', 'auto');
1019 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogoWidth', 'auto');
1020 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('individualLess', '');
1021 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('overrideLess', '');