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