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