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