wcfsetup/setup/db/install.sql

   1 /* tables */
   2 DROP TABLE IF EXISTS wcf1_acp_menu_item;
   3 CREATE TABLE wcf1_acp_menu_item (
   4         menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
   5         packageID INT(10) NOT NULL,
   6         menuItem VARCHAR(255) NOT NULL DEFAULT '',
   7         parentMenuItem VARCHAR(255) NOT NULL DEFAULT '',
   8         menuItemLink VARCHAR(255) NOT NULL DEFAULT '',
   9         showOrder INT(10) NOT NULL DEFAULT 0,
  10         permissions TEXT,
  11         options TEXT,
  12         UNIQUE KEY menuItem (menuItem, packageID)
  13 );
  14
  15 DROP TABLE IF EXISTS wcf1_acp_search_provider;
  16 CREATE TABLE wcf1_acp_search_provider (
  17         providerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  18         packageID INT(10) NOT NULL,
  19         providerName VARCHAR(255) NOT NULL DEFAULT '',
  20         className VARCHAR(255) NOT NULL DEFAULT '',
  21         showOrder INT(10) NOT NULL DEFAULT 0,
  22         UNIQUE KEY providerName (providerName, packageID)
  23 );
  24
  25 DROP TABLE IF EXISTS wcf1_acp_session;
  26 CREATE TABLE wcf1_acp_session (
  27         sessionID CHAR(40) NOT NULL PRIMARY KEY,
  28         packageID INT(10),
  29         userID INT(10),
  30         ipAddress VARCHAR(39) NOT NULL DEFAULT '',
  31         userAgent VARCHAR(255) NOT NULL DEFAULT '',
  32         lastActivityTime INT(10) NOT NULL DEFAULT 0,
  33         requestURI VARCHAR(255) NOT NULL DEFAULT '',
  34         requestMethod VARCHAR(4) NOT NULL DEFAULT '',
  35         controller VARCHAR(255) NOT NULL DEFAULT '',
  36         parentObjectType VARCHAR(255) NOT NULL DEFAULT '',
  37         parentObjectID INT(10) NOT NULL DEFAULT 0,
  38         objectType VARCHAR(255) NOT NULL DEFAULT '',
  39         objectID INT(10) NOT NULL DEFAULT 0,
  40         sessionVariables MEDIUMTEXT,
  41         KEY sessionID (sessionID, packageID)
  42 );
  43
  44 DROP TABLE IF EXISTS wcf1_acp_session_access_log;
  45 CREATE TABLE wcf1_acp_session_access_log (
  46         sessionAccessLogID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  47         sessionLogID INT(10) NOT NULL,
  48         packageID INT(10),
  49         ipAddress VARCHAR(39) NOT NULL DEFAULT '',
  50         time INT(10) NOT NULL DEFAULT 0,
  51         requestURI VARCHAR(255) NOT NULL DEFAULT '',
  52         requestMethod VARCHAR(4) NOT NULL DEFAULT '',
  53         className VARCHAR(255) NOT NULL DEFAULT '',
  54         KEY sessionLogID (sessionLogID)
  55 );
  56
  57 DROP TABLE IF EXISTS wcf1_acp_session_log;
  58 CREATE TABLE wcf1_acp_session_log (
  59         sessionLogID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  60         sessionID CHAR(40) NOT NULL DEFAULT '',
  61         userID INT(10),
  62         ipAddress VARCHAR(39) NOT NULL DEFAULT '',
  63         hostname VARCHAR(255) NOT NULL DEFAULT '',
  64         userAgent VARCHAR(255) NOT NULL DEFAULT '',
  65         time INT(10) NOT NULL DEFAULT 0,
  66         lastActivityTime INT(10) NOT NULL DEFAULT 0,
  67         KEY sessionID (sessionID)
  68 );
  69
  70 DROP TABLE IF EXISTS wcf1_acp_template;
  71 CREATE TABLE wcf1_acp_template (
  72         templateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  73         packageID INT(10),
  74         templateName VARCHAR(255) NOT NULL DEFAULT '',
  75         UNIQUE KEY (packageID, templateName)
  76 );
  77
  78 DROP TABLE IF EXISTS wcf1_application;
  79 CREATE TABLE wcf1_application (
  80         packageID INT(10) NOT NULL PRIMARY KEY,
  81         domainName VARCHAR(255) NOT NULL,
  82         domainPath VARCHAR(255) NOT NULL DEFAULT '/',
  83         cookieDomain VARCHAR(255) NOT NULL,
  84         cookiePath VARCHAR(255) NOT NULL DEFAULT '/',
  85         groupID INT(10),
  86         isPrimary TINYINT(1) NOT NULL DEFAULT 0
  87 );
  88
  89 DROP TABLE IF EXISTS wcf1_application_group;
  90 CREATE TABLE wcf1_application_group (
  91         groupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  92         groupName VARCHAR(255) NOT NULL
  93 );
  94
  95 DROP TABLE IF EXISTS wcf1_cache_resource;
  96 CREATE TABLE wcf1_cache_resource (
  97         cacheResource VARCHAR(255) NOT NULL PRIMARY KEY
  98 );
  99
 100 DROP TABLE IF EXISTS wcf1_category;
 101 CREATE TABLE wcf1_category (
 102         categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 103         objectTypeID INT(10) NOT NULL,
 104         parentCategoryID INT(10) NOT NULL,
 105         title VARCHAR(255) NOT NULL,
 106         description TEXT,
 107         showOrder INT(10) NOT NULL,
 108         time INT(10) NOT NULL,
 109         isDisabled TINYINT(1) NOT NULL DEFAULT 0,
 110         additionalData TEXT
 111 );
 112
 113 DROP TABLE IF EXISTS wcf1_cleanup_listener;
 114 CREATE TABLE wcf1_cleanup_listener (
 115         listenerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 116         packageID INT(10) NOT NULL,
 117         className VARCHAR(255) NOT NULL DEFAULT '',
 118         objectType VARCHAR(255) NOT NULL DEFAULT '',
 119         lastUpdateTime INT(10) NOT NULL DEFAULT 0,
 120         UNIQUE KEY (className, packageID)
 121 );
 122
 123 DROP TABLE IF EXISTS wcf1_cleanup_log;
 124 CREATE TABLE wcf1_cleanup_log (
 125         packageID INT(10) NOT NULL DEFAULT 0,
 126         objectType VARCHAR(255) NOT NULL DEFAULT '',
 127         objectID INT(10) NOT NULL DEFAULT 0,
 128         deleteTime INT(10) NOT NULL DEFAULT 0,
 129         KEY objectType (objectType)
 130 );
 131
 132 DROP TABLE IF EXISTS wcf1_clipboard_action;
 133 CREATE TABLE wcf1_clipboard_action (
 134         actionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 135         packageID INT(10) NOT NULL DEFAULT 0,
 136         actionName VARCHAR(50) NOT NULL DEFAULT '',
 137         actionClassName VARCHAR(200) NOT NULL DEFAULT '',
 138         showOrder INT(10) NOT NULL DEFAULT 0,
 139         UNIQUE KEY actionName (packageID, actionName, actionClassName)
 140 );
 141
 142 DROP TABLE IF EXISTS wcf1_clipboard_item;
 143 CREATE TABLE wcf1_clipboard_item (
 144         objectTypeID INT(10) NOT NULL DEFAULT 0,
 145         userID INT(10) NOT NULL DEFAULT 0,
 146         objectID INT(10) NOT NULL DEFAULT 0,
 147         UNIQUE KEY (objectTypeID, userID, objectID)
 148 );
 149
 150 DROP TABLE IF EXISTS wcf1_clipboard_page;
 151 CREATE TABLE wcf1_clipboard_page (
 152         pageClassName VARCHAR(80) NOT NULL DEFAULT '',
 153         packageID INT(10) NOT NULL DEFAULT 0,
 154         actionID INT(10) NOT NULL DEFAULT 0
 155 );
 156
 157 DROP TABLE IF EXISTS wcf1_core_object;
 158 CREATE TABLE wcf1_core_object (
 159         objectID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 160         packageID INT(10) NOT NULL,
 161         objectName VARCHAR(255) NOT NULL DEFAULT '',
 162         UNIQUE KEY object (packageID, objectName)
 163 );
 164
 165 DROP TABLE IF EXISTS wcf1_cronjob;
 166 CREATE TABLE wcf1_cronjob (
 167         cronjobID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 168         className varchar(255) NOT NULL DEFAULT '',
 169         packageID INT(10) NOT NULL,
 170         description varchar(255) NOT NULL DEFAULT '',
 171         startMinute varchar(255) NOT NULL DEFAULT '*',
 172         startHour varchar(255) NOT NULL DEFAULT '*',
 173         startDom varchar(255) NOT NULL DEFAULT '*',
 174         startMonth varchar(255) NOT NULL DEFAULT '*',
 175         startDow varchar(255) NOT NULL DEFAULT '*',
 176         lastExec INT(10) NOT NULL DEFAULT 0,
 177         nextExec INT(10) NOT NULL DEFAULT 0,
 178         afterNextExec INT(10) NOT NULL DEFAULT 0,
 179         active TINYINT(1) NOT NULL DEFAULT 1,
 180         canBeEdited TINYINT(1) NOT NULL DEFAULT 1,
 181         canBeDisabled TINYINT(1) NOT NULL DEFAULT 1,
 182         state TINYINT(1) NOT NULL DEFAULT 0,
 183         failCount TINYINT(1) NOT NULL DEFAULT 0
 184 );
 185
 186 DROP TABLE IF EXISTS wcf1_cronjob_log;
 187 CREATE TABLE wcf1_cronjob_log (
 188         cronjobLogID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 189         cronjobID INT(10) NOT NULL,
 190         execTime INT(10) NOT NULL DEFAULT 0,
 191         success TINYINT(1) NOT NULL DEFAULT 0,
 192         error TEXT
 193 );
 194
 195 DROP TABLE IF EXISTS wcf1_event_listener;
 196 CREATE TABLE wcf1_event_listener (
 197         listenerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 198         packageID INT(10) NOT NULL,
 199         environment ENUM('user', 'admin') NOT NULL DEFAULT 'user',
 200         eventClassName VARCHAR(80) NOT NULL DEFAULT '',
 201         eventName VARCHAR(50) NOT NULL DEFAULT '',
 202         listenerClassName VARCHAR(200) NOT NULL DEFAULT '',
 203         inherit TINYINT(1) NOT NULL DEFAULT 0,
 204         niceValue TINYINT(3) NOT NULL DEFAULT 0,
 205         UNIQUE KEY packageID (packageID, environment, eventClassName, eventName, listenerClassName)
 206 );
 207
 208 DROP TABLE IF EXISTS wcf1_language;
 209 CREATE TABLE wcf1_language (
 210         languageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 211         languageCode VARCHAR(20) NOT NULL DEFAULT '',
 212         languageName VARCHAR(255) NOT NULL DEFAULT '',
 213         countryCode VARCHAR(10) NOT NULL DEFAULT '',
 214         isDefault TINYINT(1) NOT NULL DEFAULT 0,
 215         hasContent TINYINT(1) NOT NULL DEFAULT 0,
 216         UNIQUE KEY languageCode (languageCode)
 217 );
 218
 219 DROP TABLE IF EXISTS wcf1_language_category;
 220 CREATE TABLE wcf1_language_category (
 221         languageCategoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 222         languageCategory VARCHAR(255) NOT NULL DEFAULT '',
 223         UNIQUE KEY languageCategory (languageCategory)
 224 );
 225
 226 DROP TABLE IF EXISTS wcf1_language_item;
 227 CREATE TABLE wcf1_language_item (
 228         languageItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 229         languageID INT(10) NOT NULL,
 230         languageItem VARCHAR(255) NOT NULL DEFAULT '',
 231         languageItemValue MEDIUMTEXT NOT NULL,
 232         languageCustomItemValue MEDIUMTEXT,
 233         languageUseCustomValue TINYINT(1) NOT NULL DEFAULT 0,
 234         languageItemOriginIsSystem TINYINT(1) NOT NULL DEFAULT 1,
 235         languageCategoryID INT(10) NOT NULL,
 236         packageID INT(10),
 237         UNIQUE KEY languageItem (languageItem, packageID, languageID),
 238         KEY languageItemOriginIsSystem (languageItemOriginIsSystem)
 239 );
 240
 241 DROP TABLE IF EXISTS wcf1_language_server;
 242 CREATE TABLE wcf1_language_server (
 243         languageServerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 244         serverURL VARCHAR(255) NOT NULL DEFAULT '',
 245         disabled TINYINT(1) NOT NULL DEFAULT 0
 246 );
 247
 248 DROP TABLE IF EXISTS wcf1_language_to_package;
 249 CREATE TABLE wcf1_language_to_package (
 250         languageID INT(10) NOT NULL,
 251         packageID INT(10),
 252         UNIQUE KEY languageID (languageID, packageID)
 253 );
 254
 255 DROP TABLE IF EXISTS wcf1_modification_log;
 256 CREATE TABLE wcf1_modification_log (
 257         logID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 258         objectTypeID INT(10) NOT NULL,
 259         objectID INT(10) NOT NULL,
 260         userID INT(10),
 261         username VARCHAR(255) NOT NULL DEFAULT '',
 262         time INT(10) NOT NULL DEFAULT 0,
 263         action VARCHAR(80) NOT NULL,
 264         additionalData MEDIUMTEXT
 265 );
 266
 267 DROP TABLE IF EXISTS wcf1_object_type;
 268 CREATE TABLE wcf1_object_type (
 269         objectTypeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 270         definitionID INT(10) NOT NULL,
 271         packageID INT(10) NOT NULL,
 272         objectType VARCHAR(255) NOT NULL,
 273         className VARCHAR(255) NOT NULL DEFAULT '',
 274         additionalData MEDIUMTEXT,
 275         UNIQUE KEY objectType (objectType, definitionID, packageID)
 276 );
 277
 278 DROP TABLE IF EXISTS wcf1_object_type_definition;
 279 CREATE TABLE wcf1_object_type_definition (
 280         definitionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 281         definitionName VARCHAR(255) NOT NULL,
 282         packageID INT(10) NOT NULL,
 283         interfaceName VARCHAR(255) NOT NULL DEFAULT '',
 284         categoryName VARCHAR(80) NOT NULL DEFAULT '',
 285         UNIQUE KEY definitionName (definitionName, packageID)
 286 );
 287
 288 DROP TABLE IF EXISTS wcf1_option;
 289 CREATE TABLE wcf1_option (
 290         optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 291         packageID INT(10) NOT NULL,
 292         optionName VARCHAR(255) NOT NULL DEFAULT '',
 293         categoryName VARCHAR(255) NOT NULL DEFAULT '',
 294         optionType VARCHAR(255) NOT NULL DEFAULT '',
 295         optionValue MEDIUMTEXT,
 296         validationPattern TEXT,
 297         selectOptions MEDIUMTEXT,
 298         enableOptions MEDIUMTEXT,
 299         showOrder INT(10) NOT NULL DEFAULT 0,
 300         hidden TINYINT(1) NOT NULL DEFAULT 0,
 301         permissions TEXT,
 302         options TEXT,
 303         supportI18n TINYINT(1) NOT NULL DEFAULT 0,
 304         requireI18n TINYINT(1) NOT NULL DEFAULT 0,
 305         additionalData MEDIUMTEXT,
 306         UNIQUE KEY optionName (optionName, packageID)
 307 );
 308
 309 DROP TABLE IF EXISTS wcf1_option_category;
 310 CREATE TABLE wcf1_option_category (
 311         categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 312         packageID INT(10) NOT NULL,
 313         categoryName VARCHAR(255) NOT NULL DEFAULT '',
 314         parentCategoryName VARCHAR(255) NOT NULL DEFAULT '',
 315         showOrder INT(10) NOT NULL DEFAULT 0,
 316         permissions TEXT,
 317         options TEXT,
 318         UNIQUE KEY categoryName (categoryName, packageID)
 319 );
 320
 321 DROP TABLE IF EXISTS wcf1_package;
 322 CREATE TABLE wcf1_package (
 323         packageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 324         package VARCHAR(255) NOT NULL DEFAULT '',
 325         packageDir VARCHAR(255) NOT NULL DEFAULT '',
 326         packageName VARCHAR(255) NOT NULL DEFAULT '',
 327         instanceName VARCHAR(255) NOT NULL DEFAULT '',
 328         instanceNo INT(10) NOT NULL DEFAULT 1,
 329         packageDescription VARCHAR(255) NOT NULL DEFAULT '',
 330         packageVersion VARCHAR(255) NOT NULL DEFAULT '',
 331         packageDate INT(10) NOT NULL DEFAULT 0,
 332         installDate INT(10) NOT NULL DEFAULT 0,
 333         updateDate INT(10) NOT NULL DEFAULT 0,
 334         packageURL VARCHAR(255) NOT NULL DEFAULT '',
 335         parentPackageID INT(10) NOT NULL DEFAULT 0,
 336         isUnique TINYINT(1) NOT NULL DEFAULT 0,
 337         isApplication TINYINT(1) NOT NULL DEFAULT 0,
 338         author VARCHAR(255) NOT NULL DEFAULT '',
 339         authorURL VARCHAR(255) NOT NULL DEFAULT '',
 340         packageIcon VARCHAR(30) NOT NULL DEFAULT '',
 341         KEY package (package)
 342 );
 343
 344 DROP TABLE IF EXISTS wcf1_package_dependency;
 345 CREATE TABLE wcf1_package_dependency (
 346         packageID INT(10) NOT NULL,
 347         dependency INT(10) NOT NULL,
 348         priority INT(10) NOT NULL DEFAULT 0,
 349         UNIQUE KEY packageID (packageID, dependency)
 350 );
 351
 352 DROP TABLE IF EXISTS wcf1_package_exclusion;
 353 CREATE TABLE wcf1_package_exclusion (
 354         packageID INT(10) NOT NULL,
 355         excludedPackage VARCHAR(255) NOT NULL DEFAULT '',
 356         excludedPackageVersion VARCHAR(255) NOT NULL DEFAULT '',
 357         UNIQUE KEY packageID (packageID, excludedPackage)
 358 );
 359
 360 DROP TABLE IF EXISTS wcf1_package_installation_file_log;
 361 CREATE TABLE wcf1_package_installation_file_log (
 362         packageID INT(10),
 363         filename VARCHAR(255) NOT NULL DEFAULT '',
 364         UNIQUE KEY packageID (packageID, filename)
 365 );
 366
 367 DROP TABLE IF EXISTS wcf1_package_installation_form;
 368 CREATE TABLE wcf1_package_installation_form (
 369         queueID INT(10) NOT NULL,
 370         formName VARCHAR(80) NOT NULL DEFAULT '',
 371         document TEXT NOT NULL,
 372         UNIQUE KEY formDocument (queueID, formName)
 373 );
 374
 375 DROP TABLE IF EXISTS wcf1_package_installation_node;
 376 CREATE TABLE wcf1_package_installation_node (
 377         queueID INT(10) NOT NULL,
 378         processNo INT(10) NOT NULL DEFAULT 0,
 379         sequenceNo SMALLINT(4) NOT NULL DEFAULT 0,
 380         node CHAR(8) NOT NULL DEFAULT '',
 381         parentNode CHAR(8) NOT NULL DEFAULT '',
 382         nodeType ENUM('optionalPackages','package', 'pip') NOT NULL DEFAULT 'package',
 383         nodeData TEXT NOT NULL,
 384         done TINYINT(1) NOT NULL DEFAULT 0
 385 );
 386
 387 DROP TABLE IF EXISTS wcf1_package_installation_plugin;
 388 CREATE TABLE wcf1_package_installation_plugin (
 389         pluginName VARCHAR(255) NOT NULL PRIMARY KEY,
 390         packageID INT(10),
 391         priority TINYINT(1) NOT NULL DEFAULT 0,
 392         className VARCHAR(255) NOT NULL
 393 );
 394
 395 DROP TABLE IF EXISTS wcf1_package_installation_queue;
 396 CREATE TABLE wcf1_package_installation_queue (
 397         queueID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 398         parentQueueID INT(10) NOT NULL DEFAULT 0,
 399         processNo INT(10) NOT NULL DEFAULT 0,
 400         userID INT(10) NOT NULL,
 401         package VARCHAR(255) NOT NULL DEFAULT '',
 402         packageName VARCHAR(255) NOT NULL DEFAULT '',
 403         packageID INT(10),
 404         archive VARCHAR(255) NOT NULL DEFAULT '',
 405         action ENUM('install', 'update', 'uninstall', 'rollback') NOT NULL DEFAULT 'install',
 406         cancelable TINYINT(1) NOT NULL DEFAULT 1,
 407         done TINYINT(1) NOT NULL DEFAULT 0,
 408         confirmInstallation TINYINT(1) NOT NULL DEFAULT 0,
 409         packageType ENUM('default', 'requirement', 'optional') NOT NULL DEFAULT 'default'
 410 );
 411
 412 DROP TABLE IF EXISTS wcf1_package_installation_sql_log;
 413 CREATE TABLE wcf1_package_installation_sql_log (
 414         packageID INT(10),
 415         sqlTable VARCHAR(100) NOT NULL DEFAULT '',
 416         sqlColumn VARCHAR(100) NOT NULL DEFAULT '',
 417         sqlIndex VARCHAR(100) NOT NULL DEFAULT '',
 418         UNIQUE KEY packageID (packageID, sqlTable, sqlColumn, sqlIndex)
 419 );
 420
 421 DROP TABLE IF EXISTS wcf1_package_requirement;
 422 CREATE TABLE wcf1_package_requirement (
 423         packageID INT(10) NOT NULL,
 424         requirement INT(10) NOT NULL,
 425         UNIQUE KEY packageID (packageID, requirement)
 426 );
 427
 428 DROP TABLE IF EXISTS wcf1_package_requirement_map;
 429 CREATE TABLE wcf1_package_requirement_map (
 430         packageID INT(10) NOT NULL,
 431         requirement INT(10) NOT NULL,
 432         level INT(10) NOT NULL DEFAULT 0,
 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         disabled 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         menuItemLink VARCHAR(255) NOT NULL DEFAULT '',
 503         menuPosition ENUM('header', 'footer') NOT NULL DEFAULT 'header',
 504         showOrder INT(10) NOT NULL DEFAULT 0,
 505         permissions TEXT NULL,
 506         options TEXT NULL,
 507         isDisabled TINYINT(1) NOT NULL DEFAULT 0,
 508         className VARCHAR(255) NOT NULL DEFAULT '',
 509         isLandingPage TINYINT(1) NOT NULL DEFAULT 0,
 510         UNIQUE KEY (packageID, menuItem)
 511 );
 512
 513 DROP TABLE IF EXISTS wcf1_search;
 514 CREATE TABLE wcf1_search (
 515         searchID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 516         userID INT(10),
 517         searchData MEDIUMTEXT NOT NULL,
 518         searchTime INT(10) NOT NULL DEFAULT 0,
 519         searchType VARCHAR(255) NOT NULL DEFAULT '',
 520         searchHash CHAR(40) NOT NULL DEFAULT '',
 521         KEY searchHash (searchHash)
 522 );
 523
 524 DROP TABLE IF EXISTS wcf1_session;
 525 CREATE TABLE wcf1_session (
 526         sessionID CHAR(40) NOT NULL PRIMARY KEY,
 527         packageID INT(10) NOT NULL,
 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 (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         disabled TINYINT(1) NOT NULL DEFAULT 0,
 571         styleDescription TEXT,
 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_to_package;
 584 CREATE TABLE wcf1_style_to_package (
 585         styleID INT(10) NOT NULL,
 586         packageID INT(10) NOT NULL,
 587         isDefault TINYINT(1) NOT NULL DEFAULT 0,
 588         disabled TINYINT(1) NOT NULL DEFAULT 0,
 589         UNIQUE KEY (styleID, packageID)
 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(40) NOT NULL DEFAULT '',
 645         salt VARCHAR(40) NOT NULL DEFAULT '',
 646         accessToken CHAR(40) NOT NULL DEFAULT '',
 647         languageID INT(10) NOT NULL DEFAULT 0,
 648         registrationDate INT(10) NOT NULL DEFAULT 0,
 649         styleID INT(10) NOT NULL DEFAULT 0,
 650
 651         KEY username (username),
 652         KEY registrationDate (registrationDate),
 653         KEY styleID (styleID)
 654 );
 655
 656 DROP TABLE IF EXISTS wcf1_user_collapsible_content;
 657 CREATE TABLE wcf1_user_collapsible_content (
 658         objectTypeID INT(10) NOT NULL,
 659         objectID VARCHAR(50) NOT NULL,
 660         userID INT(10) NOT NULL,
 661         UNIQUE KEY (objectTypeID, objectID, userID)
 662 );
 663
 664 DROP TABLE IF EXISTS wcf1_user_group;
 665 CREATE TABLE wcf1_user_group (
 666         groupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 667         groupName VARCHAR(255) NOT NULL DEFAULT '',
 668         groupType TINYINT(1) NOT NULL DEFAULT 4
 669 );
 670
 671 DROP TABLE IF EXISTS wcf1_user_group_option;
 672 CREATE TABLE wcf1_user_group_option (
 673         optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 674         packageID INT(10),
 675         optionName VARCHAR(255) NOT NULL DEFAULT '',
 676         categoryName VARCHAR(255) NOT NULL DEFAULT '',
 677         optionType VARCHAR(255) NOT NULL DEFAULT '',
 678         defaultValue MEDIUMTEXT,
 679         adminDefaultValue MEDIUMTEXT,
 680         validationPattern TEXT,
 681         enableOptions MEDIUMTEXT,
 682         showOrder INT(10) NOT NULL DEFAULT 0,
 683         permissions TEXT,
 684         options TEXT,
 685         additionalData MEDIUMTEXT,
 686         UNIQUE KEY optionName (optionName, packageID)
 687 );
 688
 689 DROP TABLE IF EXISTS wcf1_user_group_option_category;
 690 CREATE TABLE wcf1_user_group_option_category (
 691         categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 692         packageID INT(10) NOT NULL,
 693         categoryName VARCHAR(255) NOT NULL DEFAULT '',
 694         parentCategoryName VARCHAR(255) NOT NULL DEFAULT '',
 695         showOrder INT(10) NOT NULL DEFAULT 0,
 696         permissions TEXT,
 697         options TEXT,
 698         UNIQUE KEY categoryName (categoryName, packageID)
 699 );
 700
 701 DROP TABLE IF EXISTS wcf1_user_group_option_value;
 702 CREATE TABLE wcf1_user_group_option_value (
 703         groupID INT(10) NOT NULL,
 704         optionID INT(10) NOT NULL,
 705         optionValue MEDIUMTEXT NOT NULL,
 706         UNIQUE KEY groupID (groupID, optionID)
 707 );
 708
 709 DROP TABLE IF EXISTS wcf1_user_option;
 710 CREATE TABLE wcf1_user_option (
 711         optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 712         packageID INT(10) NOT NULL,
 713         optionName VARCHAR(255) NOT NULL DEFAULT '',
 714         categoryName VARCHAR(255) NOT NULL DEFAULT '',
 715         optionType VARCHAR(255) NOT NULL DEFAULT '',
 716         defaultValue MEDIUMTEXT,
 717         validationPattern TEXT,
 718         selectOptions MEDIUMTEXT,
 719         enableOptions MEDIUMTEXT,
 720         required TINYINT(1) NOT NULL DEFAULT 0,
 721         askDuringRegistration TINYINT(1) NOT NULL DEFAULT 0,
 722         editable TINYINT(1) NOT NULL DEFAULT 0,
 723         visible TINYINT(1) NOT NULL DEFAULT 0,
 724         outputClass VARCHAR(255) NOT NULL DEFAULT '',
 725         searchable TINYINT(1) NOT NULL DEFAULT 0,
 726         showOrder INT(10) NOT NULL DEFAULT 0,
 727         disabled TINYINT(1) NOT NULL DEFAULT 0,
 728         permissions TEXT,
 729         options TEXT,
 730         additionalData MEDIUMTEXT,
 731         UNIQUE KEY optionName (optionName, packageID),
 732         KEY categoryName (categoryName)
 733 );
 734
 735 DROP TABLE IF EXISTS wcf1_user_option_category;
 736 CREATE TABLE wcf1_user_option_category (
 737         categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 738         packageID INT(10) NOT NULL,
 739         categoryName VARCHAR(255) NOT NULL DEFAULT '',
 740         parentCategoryName VARCHAR(255) NOT NULL DEFAULT '',
 741         showOrder INT(10) NOT NULL DEFAULT 0,
 742         permissions TEXT,
 743         options TEXT,
 744         UNIQUE KEY categoryName (categoryName, packageID)
 745 );
 746
 747 DROP TABLE IF EXISTS wcf1_user_option_value;
 748 CREATE TABLE wcf1_user_option_value (
 749         userID INT(10) NOT NULL PRIMARY KEY
 750 );
 751
 752 DROP TABLE IF EXISTS wcf1_user_storage;
 753 CREATE TABLE wcf1_user_storage (
 754         userID INT(10) NOT NULL,
 755         field VARCHAR(80) NOT NULL DEFAULT '',
 756         fieldValue TEXT,
 757         packageID INT(10),
 758         UNIQUE KEY userStorageData (userID, field, packageID)
 759 );
 760
 761 DROP TABLE IF EXISTS wcf1_user_to_group;
 762 CREATE TABLE wcf1_user_to_group (
 763         userID INT(10) NOT NULL,
 764         groupID INT(10) NOT NULL,
 765         UNIQUE KEY userID (userID, groupID)
 766 );
 767
 768 DROP TABLE IF EXISTS wcf1_user_to_language;
 769 CREATE TABLE wcf1_user_to_language (
 770         userID INT(10) NOT NULL,
 771         languageID INT(10) NOT NULL,
 772         UNIQUE KEY userID (userID, languageID)
 773 );
 774
 775 /* foreign keys */
 776 ALTER TABLE wcf1_acp_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 777
 778 ALTER TABLE wcf1_acp_search_provider ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 779
 780 ALTER TABLE wcf1_acp_session ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 781 ALTER TABLE wcf1_acp_session ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) 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 ALTER TABLE wcf1_acp_session_access_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE SET NULL;
 785
 786 ALTER TABLE wcf1_acp_session_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
 787
 788 ALTER TABLE wcf1_acp_template ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 789
 790 ALTER TABLE wcf1_application ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 791 ALTER TABLE wcf1_application ADD FOREIGN KEY (groupID) REFERENCES wcf1_application_group (groupID) ON DELETE SET NULL;
 792
 793 ALTER TABLE wcf1_category ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
 794
 795 ALTER TABLE wcf1_cleanup_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 796
 797 ALTER TABLE wcf1_cleanup_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 798
 799 ALTER TABLE wcf1_clipboard_action ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 800
 801 ALTER TABLE wcf1_clipboard_item ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
 802
 803 ALTER TABLE wcf1_clipboard_page ADD FOREIGN KEY (actionID) REFERENCES wcf1_clipboard_action (actionID) ON DELETE CASCADE;
 804 ALTER TABLE wcf1_clipboard_page ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 805
 806 ALTER TABLE wcf1_core_object ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 807
 808 ALTER TABLE wcf1_cronjob ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 809
 810 ALTER TABLE wcf1_cronjob_log ADD FOREIGN KEY (cronjobID) REFERENCES wcf1_cronjob (cronjobID) ON DELETE CASCADE;
 811
 812 ALTER TABLE wcf1_event_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 813
 814 ALTER TABLE wcf1_language_item ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
 815 ALTER TABLE wcf1_language_item ADD FOREIGN KEY (languageCategoryID) REFERENCES wcf1_language_category (languageCategoryID) ON DELETE CASCADE;
 816 ALTER TABLE wcf1_language_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 817
 818 ALTER TABLE wcf1_language_to_package ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
 819 ALTER TABLE wcf1_language_to_package ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 820
 821 ALTER TABLE wcf1_modification_log ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
 822 ALTER TABLE wcf1_modification_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
 823
 824 ALTER TABLE wcf1_object_type ADD FOREIGN KEY (definitionID) REFERENCES wcf1_object_type_definition (definitionID) ON DELETE CASCADE;
 825 ALTER TABLE wcf1_object_type ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 826
 827 ALTER TABLE wcf1_object_type_definition ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 828
 829 ALTER TABLE wcf1_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 830
 831 ALTER TABLE wcf1_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 832
 833 ALTER TABLE wcf1_package_dependency ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 834 ALTER TABLE wcf1_package_dependency ADD FOREIGN KEY (dependency) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 835
 836 ALTER TABLE wcf1_package_exclusion ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 837
 838 ALTER TABLE wcf1_package_installation_file_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 839
 840 ALTER TABLE wcf1_package_installation_form ADD FOREIGN KEY (queueID) REFERENCES wcf1_package_installation_queue (queueID) ON DELETE CASCADE;
 841
 842 ALTER TABLE wcf1_package_installation_node ADD FOREIGN KEY (queueID) REFERENCES wcf1_package_installation_queue (queueID) ON DELETE CASCADE;
 843
 844 ALTER TABLE wcf1_package_installation_plugin ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 845
 846 ALTER TABLE wcf1_package_installation_queue ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 847 ALTER TABLE wcf1_package_installation_queue ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE SET NULL;
 848
 849 ALTER TABLE wcf1_package_installation_sql_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 850
 851 ALTER TABLE wcf1_package_requirement ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 852 ALTER TABLE wcf1_package_requirement ADD FOREIGN KEY (requirement) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 853
 854 ALTER TABLE wcf1_package_requirement_map ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 855 ALTER TABLE wcf1_package_requirement_map ADD FOREIGN KEY (requirement) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 856
 857 ALTER TABLE wcf1_package_update ADD FOREIGN KEY (packageUpdateServerID) REFERENCES wcf1_package_update_server (packageUpdateServerID) ON DELETE CASCADE;
 858
 859 ALTER TABLE wcf1_package_update_exclusion ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
 860
 861 ALTER TABLE wcf1_package_update_fromversion ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
 862
 863 ALTER TABLE wcf1_package_update_requirement 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 (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 872 ALTER TABLE wcf1_session ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 873
 874 ALTER TABLE wcf1_sitemap ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 875
 876 ALTER TABLE wcf1_user_storage ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 877 ALTER TABLE wcf1_user_storage ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 878
 879 ALTER TABLE wcf1_style ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 880
 881 ALTER TABLE wcf1_style_to_package ADD FOREIGN KEY (styleID) REFERENCES wcf1_style (styleID) ON DELETE CASCADE;
 882 ALTER TABLE wcf1_style_to_package ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 883
 884 ALTER TABLE wcf1_style_variable_value ADD FOREIGN KEY (styleID) REFERENCES wcf1_style (styleID) ON DELETE CASCADE;
 885 ALTER TABLE wcf1_style_variable_value ADD FOREIGN KEY (variableID) REFERENCES wcf1_style_variable (variableID) ON DELETE CASCADE;
 886
 887 ALTER TABLE wcf1_template ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 888 ALTER TABLE wcf1_template ADD FOREIGN KEY (templateGroupID) REFERENCES wcf1_template_group (templateGroupID) ON DELETE CASCADE;
 889
 890 ALTER TABLE wcf1_template_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 891
 892 ALTER TABLE wcf1_user_collapsible_content ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
 893 ALTER TABLE wcf1_user_collapsible_content ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 894
 895 ALTER TABLE wcf1_user_group_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 896
 897 ALTER TABLE wcf1_user_group_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 898
 899 ALTER TABLE wcf1_user_group_option_value ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
 900 ALTER TABLE wcf1_user_group_option_value ADD FOREIGN KEY (optionID) REFERENCES wcf1_user_group_option (optionID) ON DELETE CASCADE;
 901
 902 ALTER TABLE wcf1_user_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 903
 904 ALTER TABLE wcf1_user_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 905
 906 ALTER TABLE wcf1_user_option_value ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 907
 908 ALTER TABLE wcf1_user_to_group ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 909 ALTER TABLE wcf1_user_to_group ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
 910
 911 ALTER TABLE wcf1_user_to_language ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
 912 ALTER TABLE wcf1_user_to_language ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
 913
 914 /* default inserts */
 915 -- default user groups
 916 INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group1', 1);
 917 INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group2', 2);
 918 INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group3', 3);
 919 INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group4', 4);
 920 INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group5', 4);
 921 INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group6', 4);
 922
 923 -- default user group options
 924 INSERT INTO wcf1_user_group_option (optionName, categoryName, optionType, defaultValue, adminDefaultValue, showOrder) VALUES ('admin.general.canUseAcp', 'admin.general', 'boolean', '0', '1', 1);
 925 INSERT INTO wcf1_user_group_option (optionName, categoryName, optionType, defaultValue, adminDefaultValue, showOrder) VALUES ('admin.system.package.canInstallPackage', 'admin.system.package', 'boolean', '0', '1', 1);
 926 INSERT INTO wcf1_user_group_option (optionName, categoryName, optionType, defaultValue, adminDefaultValue, showOrder) VALUES ('admin.user.canEditGroup', 'admin.user.group', 'boolean', '0', '1', 1);
 927
 928 -- default user group option values
 929 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 1, '0');   -- Everyone
 930 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 2, '0');   -- Everyone
 931 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 3, '0');   -- Everyone
 932 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 1, '1');   -- Administrators
 933 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 2, '1');   -- Administrators
 934 INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 3, '1');   -- Administrators
 935
 936 -- default update servers
 937 INSERT INTO wcf1_package_update_server (serverURL, status, disabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://update.woltlab.com/maelstrom/', 'online', 0, NULL, 0, '', '');
 938 INSERT INTO wcf1_package_update_server (serverURL, status, disabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://store.woltlab.com/maelstrom/', 'online', 0, NULL, 0, '', '');
 939
 940 -- style default values
 941 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentBackgroundColor', 'rgba(255, 255, 255, 1)');
 942 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfColor', 'rgba(102, 102, 102, 1)');
 943 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLinkColor', 'rgba(63, 127, 191, 1)');
 944 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLinkHoverColor', 'rgba(15, 79, 143, 1)');
 945 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerBackgroundColor', 'rgba(255, 255, 255, 1)');
 946 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerAccentBackgroundColor', 'rgba(249, 249, 249, 1)');
 947 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerHoverBackgroundColor', 'rgba(244, 244, 244, 1)');
 948 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerBorderColor', 'rgba(221, 221, 221, 1)');
 949 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerBorderRadius', '0');
 950 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxBackgroundColor', 'rgba(63, 127, 191, 1)');
 951 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxColor', 'rgba(255, 255, 255, 1)');
 952 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxHoverColor', 'rgba(255, 255, 255, 1)');
 953 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelBackgroundColor', 'rgba(45, 45, 45, 1)');
 954 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelColor', 'rgba(255, 255, 255, 1)');
 955 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelHoverColor', 'rgba(255, 255, 255, 1)');
 956 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBackgroundColor', 'rgba(249, 249, 249, 1)');
 957 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBorderColor', 'rgba(221, 221, 221, 1)');
 958 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonColor', 'rgba(102, 102, 102, 1)');
 959 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryBackgroundColor', 'rgba(211, 232, 254, 1)');
 960 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryBorderColor', 'rgba(136, 194, 255, 1)');
 961 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryColor', 'rgba(102, 153, 204, 1)');
 962 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryHoverBackgroundColor', 'darken(@wcfButtonPrimaryBackgroundColor, 3%)');
 963 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryHoverBorderColor', 'darken(@wcfButtonPrimaryBorderColor, 10%)');
 964 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryHoverColor', '@wcfButtonPrimaryColor');
 965 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonHoverBackgroundColor', 'rgba(241, 241, 241, 1)');
 966 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonHoverBorderColor', 'rgba(224, 224, 224, 1)');
 967 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonHoverColor', 'rgba(102, 102, 102, 1)');
 968 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBackgroundColor', 'rgba(255, 255, 255, 1)');
 969 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputColor', 'rgba(102, 102, 102, 1)');
 970 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBorderColor', 'rgba(204, 204, 204, 1)');
 971 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputHoverBackgroundColor', 'rgba(239, 247, 255, 1)');
 972 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputHoverBorderColor', 'rgba(198, 222, 248, 1)');
 973 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfBaseFontSize', '13px');
 974 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfBaseFontFamily', '"Trebuchet MS", Arial, sans-serif');
 975 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutFluidGap', '30px');
 976 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutFixedWidth', '1200px');
 977 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageBackgroundColor', 'rgba(224, 224, 224, 1)');
 978 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageColor', 'rgba(102, 102, 102, 1)');
 979 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageLinkColor', 'rgba(63, 127, 191, 1)');
 980 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageLinkHoverColor', 'rgba(15, 79, 143, 1)');
 981 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarBackgroundColor', '@wcfContainerHoverBackgroundColor');
 982 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDimmedColor', 'rgba(136, 136, 136, 1)');
 983 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLabelColor', '@wcfColor');
 984 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeadlineColor', '@wcfColor');
 985 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeadlineFontFamily', '"Trebuchet MS", Arial, sans-serif');
 986 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBackgroundColor', '@wcfContentBackgroundColor');
 987 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownColor', '@wcfColor');
 988 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBorderColor', '@wcfContainerBorderColor');
 989 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownHoverBackgroundColor', '@wcfContainerHoverBackgroundColor');
 990 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfBaseLineHeight', '1.27');
 991 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeadlineFontSize', '170%');
 992 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSubHeadlineFontSize', '140%');
 993 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTitleFontSize', '120%');
 994 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSmallFontSize', '85%');
 995 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfWarningColor', 'rgba(153, 153, 0, 1)');
 996 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfWarningBackgroundColor', 'rgba(255, 255, 221, 1)');
 997 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfWarningBorderColor', 'rgba(204, 204, 0, 1)');
 998 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfErrorColor', 'rgba(204, 0, 0, 1)');
 999 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfErrorBackgroundColor', 'rgba(255, 238, 238, 1)');
1000 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfErrorBorderColor', 'rgba(255, 153, 153, 1)');
1001 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSuccessColor', 'rgba(0, 153, 0, 1)');
1002 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSuccessBackgroundColor', 'rgba(238, 255, 238, 1)');
1003 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSuccessBorderColor', 'rgba(0, 204, 0, 1)');
1004 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInfoColor', 'rgba(102, 136, 187, 1)');
1005 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInfoBackgroundColor', 'rgba(221, 238, 255, 1)');
1006 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInfoBorderColor', 'rgba(153, 187, 238, 1)');
1007 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTooltipBackgroundColor', 'rgba(0, 0, 0, .8)');
1008 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTooltipColor', 'rgba(255, 255, 255, 1)');
1009 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapTiny', '4px');
1010 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapSmall', '7px');
1011 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapMedium', '14px');
1012 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapLarge', '21px');
1013 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationHeaderBackgroundColor', '@wcfContentBackgroundColor');
1014 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationFooterBackgroundColor', '@wcfContainerAccentBackgroundColor');
1015 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuBackgroundColor', '@wcfContainerAccentBackgroundColor');
1016 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuHoverBackgroundColor', '@wcfContainerAccentBackgroundColor');
1017 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuColor', '@wcfColor');
1018 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuActiveColor', '@wcfLinkColor');
1019 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelHoverBackgroundColor', 'rgba(60, 60, 60, 1)');
1020 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMarkedBackgroundColor', 'rgba(255, 255, 200, 1)');
1021 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('useFluidLayout', '1');
1022 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogo', '');
1023 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogoHeight', 'auto');
1024 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogoWidth', 'auto');
1025 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('individualLess', '');
1026 INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('overrideLess', '');