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