com.woltlab.wcf/update_1.sql

   1 DROP TABLE IF EXISTS wcf1_acl_simple_to_user;
   2 CREATE TABLE wcf1_acl_simple_to_user (
   3         objectTypeID INT(10) NOT NULL,
   4         objectID INT(10) NOT NULL,
   5         userID INT(10) NOT NULL,
   6         UNIQUE KEY userKey (objectTypeID, objectID, userID)
   7 );
   8
   9 DROP TABLE IF EXISTS wcf1_acl_simple_to_group;
  10 CREATE TABLE wcf1_acl_simple_to_group (
  11         objectTypeID INT(10) NOT NULL,
  12         objectID INT(10) NOT NULL,
  13         groupID INT(10) NOT NULL,
  14         UNIQUE KEY groupKey (objectTypeID, objectID, groupID)
  15 );
  16
  17 ALTER TABLE wcf1_acp_menu_item ADD icon VARCHAR(255) NOT NULL DEFAULT '';
  18
  19 ALTER TABLE wcf1_acp_session DROP COLUMN controller;
  20 ALTER TABLE wcf1_acp_session DROP COLUMN parentObjectType;
  21 ALTER TABLE wcf1_acp_session DROP COLUMN parentObjectID;
  22 ALTER TABLE wcf1_acp_session DROP COLUMN objectType;
  23 ALTER TABLE wcf1_acp_session DROP COLUMN objectID;
  24
  25 ALTER TABLE wcf1_application DROP COLUMN cookiePath;
  26 ALTER TABLE wcf1_application DROP COLUMN isPrimary;
  27 ALTER TABLE wcf1_application ADD isTainted TINYINT(1) NOT NULL DEFAULT 0;
  28 ALTER TABLE wcf1_application ADD landingPageID INT(10) NULL;
  29
  30 DROP TABLE IF EXISTS wcf1_article;
  31 CREATE TABLE wcf1_article (
  32         articleID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  33         userID INT(10),
  34         username VARCHAR(255) NOT NULL DEFAULT '',
  35         time INT(10) NOT NULL DEFAULT 0,
  36         categoryID INT(10),
  37         isMultilingual TINYINT(1) NOT NULL DEFAULT 0,
  38         publicationStatus TINYINT(1) NOT NULL DEFAULT 1,
  39         publicationDate INT(10) NOT NULL DEFAULT 0,
  40         enableComments TINYINT(1) NOT NULL DEFAULT 1,
  41         comments SMALLINT(5) NOT NULL DEFAULT 0,
  42         views MEDIUMINT(7) NOT NULL DEFAULT 0,
  43         cumulativeLikes MEDIUMINT(7) NOT NULL DEFAULT 0,
  44
  45         KEY (time)
  46 );
  47
  48 DROP TABLE IF EXISTS wcf1_article_content;
  49 CREATE TABLE wcf1_article_content (
  50         articleContentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  51         articleID INT(10) NOT NULL,
  52         languageID INT(10),
  53         title VARCHAR(255) NOT NULL,
  54         teaser TEXT,
  55         content MEDIUMTEXT,
  56         imageID INT(10),
  57         hasEmbeddedObjects TINYINT(1) NOT NULL DEFAULT 0,
  58
  59         UNIQUE KEY (articleID, languageID)
  60 );
  61
  62 DROP TABLE IF EXISTS wcf1_background_job;
  63 CREATE TABLE wcf1_background_job (
  64         jobID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  65         job MEDIUMBLOB NOT NULL,
  66         status ENUM('ready', 'processing') NOT NULL DEFAULT 'ready',
  67         time INT(10) NOT NULL,
  68         KEY (status, time)
  69 );
  70
  71 ALTER TABLE wcf1_bbcode DROP COLUMN allowedChildren;
  72 ALTER TABLE wcf1_bbcode DROP COLUMN isDisabled;
  73 ALTER TABLE wcf1_bbcode ADD isBlockElement TINYINT(1) NOT NULL DEFAULT 0;
  74
  75 DROP TABLE IF EXISTS wcf1_box;
  76 CREATE TABLE wcf1_box (
  77         boxID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  78         objectTypeID INT(10),
  79         identifier VARCHAR(255) NOT NULL,
  80         name VARCHAR(255) NOT NULL,
  81         boxType VARCHAR(255) NOT NULL,
  82         position VARCHAR(255) NOT NULL,
  83         showOrder INT(10) NOT NULL DEFAULT 0,
  84         visibleEverywhere TINYINT(1) NOT NULL DEFAULT 1,
  85         isMultilingual TINYINT(1) NOT NULL DEFAULT 0,
  86         cssClassName VARCHAR(255) NOT NULL DEFAULT '',
  87         showHeader TINYINT(1) NOT NULL DEFAULT 1,
  88         originIsSystem TINYINT(1) NOT NULL DEFAULT 0,
  89         packageID INT(10) NOT NULL,
  90         menuID INT(10) NULL,
  91         linkPageID INT(10),
  92         linkPageObjectID INT(10) NOT NULL DEFAULT 0,
  93         externalURL VARCHAR(255) NOT NULL DEFAULT '',
  94         additionalData TEXT
  95 );
  96
  97 DROP TABLE IF EXISTS wcf1_box_content;
  98 CREATE TABLE wcf1_box_content (
  99         boxContentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 100         boxID INT(10) NOT NULL,
 101         languageID INT(10),
 102         title VARCHAR(255) NOT NULL,
 103         content MEDIUMTEXT,
 104         imageID INT(10),
 105         hasEmbeddedObjects TINYINT(1) NOT NULL DEFAULT 0,
 106
 107         UNIQUE KEY (boxID, languageID)
 108 );
 109
 110 DROP TABLE IF EXISTS wcf1_box_to_page;
 111 CREATE TABLE wcf1_box_to_page (
 112         boxID INT(10) NOT NULL,
 113         pageID INT(10) NOT NULL,
 114         visible TINYINT(1) NOT NULL DEFAULT 1,
 115
 116         UNIQUE KEY (pageID, boxID),
 117         KEY (pageID, visible)
 118 );
 119
 120 ALTER TABLE wcf1_clipboard_item ADD KEY (userID);
 121
 122 ALTER TABLE wcf1_cronjob ADD cronjobName VARCHAR(191) NOT NULL;
 123 ALTER TABLE wcf1_cronjob ADD options TEXT;
 124 UPDATE wcf1_cronjob SET cronjobName = CONCAT('com.woltlab.wcf.generic', cronjobID);
 125 ALTER TABLE wcf1_cronjob ADD UNIQUE KEY cronjobName (cronjobName, packageID);
 126
 127 DROP TABLE IF EXISTS wcf1_dashboard_option;
 128 DROP TABLE IF EXISTS wcf1_dashboard_box;
 129
 130 -- we have to drop the foreign key first to drop the normal key
 131 ALTER TABLE wcf1_event_listener DROP FOREIGN KEY packageID;
 132 ALTER TABLE wcf1_event_listener DROP KEY packageID;
 133 ALTER TABLE wcf1_event_listener ADD listenerName VARCHAR(191) NOT NULL;
 134 ALTER TABLE wcf1_event_listener CHANGE eventName eventName TEXT;
 135 ALTER TABLE wcf1_event_listener ADD permissions TEXT;
 136 ALTER TABLE wcf1_event_listener ADD options TEXT;
 137
 138 UPDATE wcf1_event_listener SET listenerName = CONCAT('com.woltlab.wcf.generic', listenerID);
 139 ALTER TABLE wcf1_event_listener ADD UNIQUE KEY listenerName (listenerName, packageID);
 140
 141 ALTER TABLE wcf1_label ADD showOrder INT(10) NOT NULL DEFAULT 0;
 142
 143 ALTER TABLE wcf1_language ADD isDisabled TINYINT(1) NOT NULL DEFAULT 0;
 144
 145 DROP TABLE IF EXISTS wcf1_language_server;