com.woltlab.wcf/update_part1.sql

   1 DROP TABLE IF EXISTS wcf1_page;
   2 CREATE TABLE wcf1_page (
   3         pageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
   4         parentPageID INT(10),
   5         identifier VARCHAR(255) NOT NULL,
   6         name VARCHAR(255) NOT NULL,
   7         pageType VARCHAR(255) NOT NULL,
   8         isDisabled TINYINT(1) NOT NULL DEFAULT 0,
   9         isLandingPage TINYINT(1) NOT NULL DEFAULT 0,
  10         isMultilingual TINYINT(1) NOT NULL DEFAULT 0,
  11         originIsSystem TINYINT(1) NOT NULL DEFAULT 0,
  12         packageID INT(10) NOT NULL,
  13         applicationPackageID INT(10),
  14         controller VARCHAR(255) NOT NULL DEFAULT '',
  15         handler VARCHAR(255) NOT NULL DEFAULT '',
  16         controllerCustomURL VARCHAR(255) NOT NULL DEFAULT '',
  17         requireObjectID TINYINT(1) NOT NULL DEFAULT 0,
  18         hasFixedParent TINYINT(1) NOT NULL DEFAULT 0,
  19         lastUpdateTime INT(10) NOT NULL DEFAULT 0,
  20         permissions TEXT NULL,
  21         options TEXT NULL
  22 );
  23
  24 DROP TABLE IF EXISTS wcf1_page_content;
  25 CREATE TABLE wcf1_page_content (
  26         pageContentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  27         pageID INT(10) NOT NULL,
  28         languageID INT(10),
  29         title VARCHAR(255) NOT NULL,
  30         content MEDIUMTEXT,
  31         metaDescription TEXT,
  32         metaKeywords TEXT,
  33         customURL VARCHAR(255) NOT NULL,
  34         hasEmbeddedObjects TINYINT(1) NOT NULL DEFAULT 0,
  35
  36         UNIQUE KEY (pageID, languageID)
  37 );
  38
  39 UPDATE wcf1_user_group_option SET optionName = 'admin.configuration.package.canInstallPackage', categoryName = 'admin.configuration.package' WHERE optionName = 'admin.system.package.canInstallPackage';