From ae03c54e52dcc54d3ce870d856366180572735c2 Mon Sep 17 00:00:00 2001 From: Alexander Ebert Date: Sun, 20 Nov 2016 16:15:26 +0100 Subject: [PATCH] Split update.sql into 5 chunks --- com.woltlab.wcf/package.xml | 6 +- com.woltlab.wcf/update_1.sql | 145 ++++++++++ com.woltlab.wcf/update_2.sql | 107 ++++++++ com.woltlab.wcf/update_3.sql | 3 + com.woltlab.wcf/update_4.sql | 10 + com.woltlab.wcf/{update.sql => update_5.sql} | 269 ------------------- 6 files changed, 270 insertions(+), 270 deletions(-) create mode 100644 com.woltlab.wcf/update_1.sql create mode 100644 com.woltlab.wcf/update_2.sql create mode 100644 com.woltlab.wcf/update_3.sql create mode 100644 com.woltlab.wcf/update_4.sql rename com.woltlab.wcf/{update.sql => update_5.sql} (69%) diff --git a/com.woltlab.wcf/package.xml b/com.woltlab.wcf/package.xml index 04b5f4254b..bf79a4b854 100644 --- a/com.woltlab.wcf/package.xml +++ b/com.woltlab.wcf/package.xml @@ -58,7 +58,11 @@ files.tar acp/update_com.woltlab.wcf_3.0_columnLength.php - update.sql + update_1.sql + update_2.sql + update_3.sql + update_4.sql + update_5.sql acptemplates.tar templates.tar diff --git a/com.woltlab.wcf/update_1.sql b/com.woltlab.wcf/update_1.sql new file mode 100644 index 0000000000..abc6b00050 --- /dev/null +++ b/com.woltlab.wcf/update_1.sql @@ -0,0 +1,145 @@ +DROP TABLE IF EXISTS wcf1_acl_simple_to_user; +CREATE TABLE wcf1_acl_simple_to_user ( + objectTypeID INT(10) NOT NULL, + objectID INT(10) NOT NULL, + userID INT(10) NOT NULL, + UNIQUE KEY userKey (objectTypeID, objectID, userID) +); + +DROP TABLE IF EXISTS wcf1_acl_simple_to_group; +CREATE TABLE wcf1_acl_simple_to_group ( + objectTypeID INT(10) NOT NULL, + objectID INT(10) NOT NULL, + groupID INT(10) NOT NULL, + UNIQUE KEY groupKey (objectTypeID, objectID, groupID) +); + +ALTER TABLE wcf1_acp_menu_item ADD icon VARCHAR(255) NOT NULL DEFAULT ''; + +ALTER TABLE wcf1_acp_session DROP COLUMN controller; +ALTER TABLE wcf1_acp_session DROP COLUMN parentObjectType; +ALTER TABLE wcf1_acp_session DROP COLUMN parentObjectID; +ALTER TABLE wcf1_acp_session DROP COLUMN objectType; +ALTER TABLE wcf1_acp_session DROP COLUMN objectID; +ALTER TABLE wcf1_acp_session DROP COLUMN sessionVariables; + +ALTER TABLE wcf1_application DROP COLUMN cookiePath; +ALTER TABLE wcf1_application DROP COLUMN isPrimary; +ALTER TABLE wcf1_application ADD isTainted TINYINT(1) NOT NULL DEFAULT 0; + +DROP TABLE IF EXISTS wcf1_article; +CREATE TABLE wcf1_article ( + articleID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, + userID INT(10), + username VARCHAR(255) NOT NULL DEFAULT '', + time INT(10) NOT NULL DEFAULT 0, + categoryID INT(10), + isMultilingual TINYINT(1) NOT NULL DEFAULT 0, + publicationStatus TINYINT(1) NOT NULL DEFAULT 1, + publicationDate INT(10) NOT NULL DEFAULT 0, + enableComments TINYINT(1) NOT NULL DEFAULT 1, + comments SMALLINT(5) NOT NULL DEFAULT 0, + views MEDIUMINT(7) NOT NULL DEFAULT 0, + cumulativeLikes MEDIUMINT(7) NOT NULL DEFAULT 0, + + KEY (time) +); + +DROP TABLE IF EXISTS wcf1_article_content; +CREATE TABLE wcf1_article_content ( + articleContentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, + articleID INT(10) NOT NULL, + languageID INT(10), + title VARCHAR(255) NOT NULL, + teaser TEXT, + content MEDIUMTEXT, + imageID INT(10), + hasEmbeddedObjects TINYINT(1) NOT NULL DEFAULT 0, + + UNIQUE KEY (articleID, languageID) +); + +DROP TABLE IF EXISTS wcf1_background_job; +CREATE TABLE wcf1_background_job ( + jobID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, + job MEDIUMBLOB NOT NULL, + status ENUM('ready', 'processing') NOT NULL DEFAULT 'ready', + time INT(10) NOT NULL, + KEY (status, time) +); + +ALTER TABLE wcf1_bbcode DROP COLUMN allowedChildren; +ALTER TABLE wcf1_bbcode DROP COLUMN isDisabled; +ALTER TABLE wcf1_bbcode ADD isBlockElement TINYINT(1) NOT NULL DEFAULT 0; + +DROP TABLE IF EXISTS wcf1_box; +CREATE TABLE wcf1_box ( + boxID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, + objectTypeID INT(10), + identifier VARCHAR(255) NOT NULL, + name VARCHAR(255) NOT NULL, + boxType VARCHAR(255) NOT NULL, + position VARCHAR(255) NOT NULL, + showOrder INT(10) NOT NULL DEFAULT 0, + visibleEverywhere TINYINT(1) NOT NULL DEFAULT 1, + isMultilingual TINYINT(1) NOT NULL DEFAULT 0, + cssClassName VARCHAR(255) NOT NULL DEFAULT '', + showHeader TINYINT(1) NOT NULL DEFAULT 1, + originIsSystem TINYINT(1) NOT NULL DEFAULT 0, + packageID INT(10) NOT NULL, + menuID INT(10) NULL, + linkPageID INT(10), + linkPageObjectID INT(10) NOT NULL DEFAULT 0, + externalURL VARCHAR(255) NOT NULL DEFAULT '', + additionalData TEXT +); + +DROP TABLE IF EXISTS wcf1_box_content; +CREATE TABLE wcf1_box_content ( + boxContentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, + boxID INT(10) NOT NULL, + languageID INT(10), + title VARCHAR(255) NOT NULL, + content MEDIUMTEXT, + imageID INT(10), + hasEmbeddedObjects TINYINT(1) NOT NULL DEFAULT 0, + + UNIQUE KEY (boxID, languageID) +); + +DROP TABLE IF EXISTS wcf1_box_to_page; +CREATE TABLE wcf1_box_to_page ( + boxID INT(10) NOT NULL, + pageID INT(10) NOT NULL, + visible TINYINT(1) NOT NULL DEFAULT 1, + + UNIQUE KEY (pageID, boxID), + KEY (pageID, visible) +); + +ALTER TABLE wcf1_clipboard_item ADD KEY (userID); + +ALTER TABLE wcf1_cronjob ADD cronjobName VARCHAR(191) NOT NULL; +ALTER TABLE wcf1_cronjob ADD options TEXT; +UPDATE wcf1_cronjob SET cronjobName = CONCAT('com.woltlab.wcf.generic', cronjobID); +ALTER TABLE wcf1_cronjob ADD UNIQUE KEY cronjobName (cronjobName, packageID); + +DROP TABLE IF EXISTS wcf1_dashboard_option; +DROP TABLE IF EXISTS wcf1_dashboard_box; + +-- we have to drop the foreign key first to drop the normal key +ALTER TABLE wcf1_event_listener DROP FOREIGN KEY packageID; +ALTER TABLE wcf1_event_listener DROP KEY packageID; +ALTER TABLE wcf1_event_listener ADD listenerName VARCHAR(191) NOT NULL; +ALTER TABLE wcf1_event_listener CHANGE eventName eventName TEXT; +ALTER TABLE wcf1_event_listener ADD permissions TEXT; +ALTER TABLE wcf1_event_listener ADD options TEXT; + +UPDATE wcf1_event_listener SET listenerName = CONCAT('com.woltlab.wcf.generic', listenerID); +ALTER TABLE wcf1_event_listener ADD UNIQUE KEY listenerName (listenerName, packageID); + +ALTER TABLE wcf1_label ADD showOrder INT(10) NOT NULL DEFAULT 0; + +ALTER TABLE wcf1_language ADD isDisabled TINYINT(1) NOT NULL DEFAULT 0; + +DROP TABLE IF EXISTS wcf1_language_server; diff --git a/com.woltlab.wcf/update_2.sql b/com.woltlab.wcf/update_2.sql new file mode 100644 index 0000000000..45175cf428 --- /dev/null +++ b/com.woltlab.wcf/update_2.sql @@ -0,0 +1,107 @@ +DROP TABLE IF EXISTS wcf1_media; +CREATE TABLE wcf1_media ( + mediaID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, + + filename VARCHAR(255) NOT NULL DEFAULT '', + filesize INT(10) NOT NULL DEFAULT 0, + fileType VARCHAR(255) NOT NULL DEFAULT '', + fileHash VARCHAR(255) NOT NULL DEFAULT '', + uploadTime INT(10) NOT NULL DEFAULT 0, + userID INT(10), + username VARCHAR(255) NOT NULL, + languageID INT(10), + isMultilingual TINYINT(1) NOT NULL DEFAULT 0, + + isImage TINYINT(1) NOT NULL DEFAULT 0, + width SMALLINT(5) NOT NULL DEFAULT 0, + height SMALLINT(5) NOT NULL DEFAULT 0, + + tinyThumbnailType VARCHAR(255) NOT NULL DEFAULT '', + tinyThumbnailSize INT(10) NOT NULL DEFAULT 0, + tinyThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0, + tinyThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0, + + smallThumbnailType VARCHAR(255) NOT NULL DEFAULT '', + smallThumbnailSize INT(10) NOT NULL DEFAULT 0, + smallThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0, + smallThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0, + + mediumThumbnailType VARCHAR(255) NOT NULL DEFAULT '', + mediumThumbnailSize INT(10) NOT NULL DEFAULT 0, + mediumThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0, + mediumThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0, + + largeThumbnailType VARCHAR(255) NOT NULL DEFAULT '', + largeThumbnailSize INT(10) NOT NULL DEFAULT 0, + largeThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0, + largeThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0 +); + +DROP TABLE IF EXISTS wcf1_media_content; +CREATE TABLE wcf1_media_content ( + mediaID INT(10) NOT NULL, + languageID INT(10), + title VARCHAR(255) NOT NULL, + caption TEXT, + altText VARCHAR(255) NOT NULL DEFAULT '', + UNIQUE KEY (mediaID, languageID) +); + +DROP TABLE IF EXISTS wcf1_menu; +CREATE TABLE wcf1_menu ( + menuID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, + identifier VARCHAR(255) NOT NULL, + title VARCHAR(255) NOT NULL, + originIsSystem TINYINT(1) NOT NULL DEFAULT 0, + packageID INT(10) NOT NULL +); + +DROP TABLE IF EXISTS wcf1_menu_item; +CREATE TABLE wcf1_menu_item ( + itemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, + menuID INT(10) NOT NULL, + parentItemID INT(10), + identifier VARCHAR(255) NOT NULL, + title VARCHAR(255) NOT NULL, + pageID INT(10), + pageObjectID INT(10) NOT NULL DEFAULT 0, + externalURL VARCHAR(255) NOT NULL DEFAULT '', + showOrder INT(10) NOT NULL DEFAULT 0, + isDisabled TINYINT(1) NOT NULL DEFAULT 0, + originIsSystem TINYINT(1) NOT NULL DEFAULT 0, + packageID INT(10) NOT NULL +); + +ALTER TABLE wcf1_modification_log ADD parentObjectID INT(10); + +ALTER TABLE wcf1_package_update_version DROP COLUMN isCritical; + +DROP TABLE IF EXISTS wcf1_page_menu_item; + +ALTER TABLE wcf1_session DROP COLUMN controller; +ALTER TABLE wcf1_session DROP COLUMN parentObjectType; +ALTER TABLE wcf1_session DROP COLUMN parentObjectID; +ALTER TABLE wcf1_session DROP COLUMN objectType; +ALTER TABLE wcf1_session DROP COLUMN objectID; +ALTER TABLE wcf1_session DROP COLUMN sessionVariables; + +ALTER TABLE wcf1_session ADD pageID INT(10); +ALTER TABLE wcf1_session ADD pageObjectID INT(10); +ALTER TABLE wcf1_session ADD parentPageID INT(10); +ALTER TABLE wcf1_session ADD parentPageObjectID INT(10); +ALTER TABLE wcf1_session ADD KEY pageID (pageID, pageObjectID); +ALTER TABLE wcf1_session ADD KEY parentPageID (parentPageID, parentPageObjectID); + +ALTER TABLE wcf1_session_virtual ADD sessionVariables MEDIUMTEXT; + +DROP TABLE IF EXISTS wcf1_sitemap; + +ALTER TABLE wcf1_smiley ADD smileyPath2x VARCHAR(255) NOT NULL DEFAULT ''; + +ALTER TABLE wcf1_style ADD packageName VARCHAR(255) NOT NULL DEFAULT ''; +ALTER TABLE wcf1_style ADD isTainted TINYINT(1) NOT NULL DEFAULT 0; + +ALTER TABLE wcf1_template_listener ADD permissions TEXT; +ALTER TABLE wcf1_template_listener ADD options TEXT; + +ALTER TABLE wcf1_user CHANGE lostPasswordKey lostPasswordKey CHAR(40) DEFAULT NULL; \ No newline at end of file diff --git a/com.woltlab.wcf/update_3.sql b/com.woltlab.wcf/update_3.sql new file mode 100644 index 0000000000..0d6ddcc823 --- /dev/null +++ b/com.woltlab.wcf/update_3.sql @@ -0,0 +1,3 @@ +ALTER TABLE wcf1_user DROP COLUMN signatureEnableBBCodes; +ALTER TABLE wcf1_user DROP COLUMN signatureEnableSmilies; +ALTER TABLE wcf1_user DROP COLUMN socialNetworkPrivacySettings; diff --git a/com.woltlab.wcf/update_4.sql b/com.woltlab.wcf/update_4.sql new file mode 100644 index 0000000000..c48729f004 --- /dev/null +++ b/com.woltlab.wcf/update_4.sql @@ -0,0 +1,10 @@ +ALTER TABLE wcf1_user_avatar DROP COLUMN cropX; +ALTER TABLE wcf1_user_avatar DROP COLUMN cropY; + +ALTER TABLE wcf1_user_notification ADD KEY (confirmTime); + +DELETE FROM wcf1_user_profile_visitor WHERE userID IS NULL OR ownerID IS NULL; +ALTER TABLE wcf1_user_profile_visitor CHANGE ownerID ownerID INT(10) NOT NULL; +ALTER TABLE wcf1_user_profile_visitor CHANGE userID userID INT(10) NOT NULL; + +ALTER TABLE wcf1_user_storage ADD KEY (field); diff --git a/com.woltlab.wcf/update.sql b/com.woltlab.wcf/update_5.sql similarity index 69% rename from com.woltlab.wcf/update.sql rename to com.woltlab.wcf/update_5.sql index b74b3dc79e..0e8a309283 100644 --- a/com.woltlab.wcf/update.sql +++ b/com.woltlab.wcf/update_5.sql @@ -1,272 +1,3 @@ --- other changes -DROP TABLE IF EXISTS wcf1_acl_simple_to_user; -CREATE TABLE wcf1_acl_simple_to_user ( - objectTypeID INT(10) NOT NULL, - objectID INT(10) NOT NULL, - userID INT(10) NOT NULL, - UNIQUE KEY userKey (objectTypeID, objectID, userID) -); - -DROP TABLE IF EXISTS wcf1_acl_simple_to_group; -CREATE TABLE wcf1_acl_simple_to_group ( - objectTypeID INT(10) NOT NULL, - objectID INT(10) NOT NULL, - groupID INT(10) NOT NULL, - UNIQUE KEY groupKey (objectTypeID, objectID, groupID) -); - -ALTER TABLE wcf1_acp_menu_item ADD icon VARCHAR(255) NOT NULL DEFAULT ''; - -ALTER TABLE wcf1_acp_session DROP COLUMN controller; -ALTER TABLE wcf1_acp_session DROP COLUMN parentObjectType; -ALTER TABLE wcf1_acp_session DROP COLUMN parentObjectID; -ALTER TABLE wcf1_acp_session DROP COLUMN objectType; -ALTER TABLE wcf1_acp_session DROP COLUMN objectID; -ALTER TABLE wcf1_acp_session DROP COLUMN sessionVariables; - -ALTER TABLE wcf1_application DROP COLUMN cookiePath; -ALTER TABLE wcf1_application DROP COLUMN isPrimary; -ALTER TABLE wcf1_application ADD isTainted TINYINT(1) NOT NULL DEFAULT 0; - -DROP TABLE IF EXISTS wcf1_article; -CREATE TABLE wcf1_article ( - articleID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, - userID INT(10), - username VARCHAR(255) NOT NULL DEFAULT '', - time INT(10) NOT NULL DEFAULT 0, - categoryID INT(10), - isMultilingual TINYINT(1) NOT NULL DEFAULT 0, - publicationStatus TINYINT(1) NOT NULL DEFAULT 1, - publicationDate INT(10) NOT NULL DEFAULT 0, - enableComments TINYINT(1) NOT NULL DEFAULT 1, - comments SMALLINT(5) NOT NULL DEFAULT 0, - views MEDIUMINT(7) NOT NULL DEFAULT 0, - cumulativeLikes MEDIUMINT(7) NOT NULL DEFAULT 0, - - KEY (time) -); - -DROP TABLE IF EXISTS wcf1_article_content; -CREATE TABLE wcf1_article_content ( - articleContentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, - articleID INT(10) NOT NULL, - languageID INT(10), - title VARCHAR(255) NOT NULL, - teaser TEXT, - content MEDIUMTEXT, - imageID INT(10), - hasEmbeddedObjects TINYINT(1) NOT NULL DEFAULT 0, - - UNIQUE KEY (articleID, languageID) -); - -DROP TABLE IF EXISTS wcf1_background_job; -CREATE TABLE wcf1_background_job ( - jobID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, - job MEDIUMBLOB NOT NULL, - status ENUM('ready', 'processing') NOT NULL DEFAULT 'ready', - time INT(10) NOT NULL, - KEY (status, time) -); - -ALTER TABLE wcf1_bbcode DROP COLUMN allowedChildren; -ALTER TABLE wcf1_bbcode DROP COLUMN isDisabled; -ALTER TABLE wcf1_bbcode ADD isBlockElement TINYINT(1) NOT NULL DEFAULT 0; - -DROP TABLE IF EXISTS wcf1_box; -CREATE TABLE wcf1_box ( - boxID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, - objectTypeID INT(10), - identifier VARCHAR(255) NOT NULL, - name VARCHAR(255) NOT NULL, - boxType VARCHAR(255) NOT NULL, - position VARCHAR(255) NOT NULL, - showOrder INT(10) NOT NULL DEFAULT 0, - visibleEverywhere TINYINT(1) NOT NULL DEFAULT 1, - isMultilingual TINYINT(1) NOT NULL DEFAULT 0, - cssClassName VARCHAR(255) NOT NULL DEFAULT '', - showHeader TINYINT(1) NOT NULL DEFAULT 1, - originIsSystem TINYINT(1) NOT NULL DEFAULT 0, - packageID INT(10) NOT NULL, - menuID INT(10) NULL, - linkPageID INT(10), - linkPageObjectID INT(10) NOT NULL DEFAULT 0, - externalURL VARCHAR(255) NOT NULL DEFAULT '', - additionalData TEXT -); - -DROP TABLE IF EXISTS wcf1_box_content; -CREATE TABLE wcf1_box_content ( - boxContentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, - boxID INT(10) NOT NULL, - languageID INT(10), - title VARCHAR(255) NOT NULL, - content MEDIUMTEXT, - imageID INT(10), - hasEmbeddedObjects TINYINT(1) NOT NULL DEFAULT 0, - - UNIQUE KEY (boxID, languageID) -); - -DROP TABLE IF EXISTS wcf1_box_to_page; -CREATE TABLE wcf1_box_to_page ( - boxID INT(10) NOT NULL, - pageID INT(10) NOT NULL, - visible TINYINT(1) NOT NULL DEFAULT 1, - - UNIQUE KEY (pageID, boxID), - KEY (pageID, visible) -); - -ALTER TABLE wcf1_clipboard_item ADD KEY (userID); - -ALTER TABLE wcf1_cronjob ADD cronjobName VARCHAR(191) NOT NULL; -ALTER TABLE wcf1_cronjob ADD options TEXT; -UPDATE wcf1_cronjob SET cronjobName = CONCAT('com.woltlab.wcf.generic', cronjobID); -ALTER TABLE wcf1_cronjob ADD UNIQUE KEY cronjobName (cronjobName, packageID); - -DROP TABLE IF EXISTS wcf1_dashboard_option; -DROP TABLE IF EXISTS wcf1_dashboard_box; - --- we have to drop the foreign key first to drop the normal key -ALTER TABLE wcf1_event_listener DROP FOREIGN KEY packageID; -ALTER TABLE wcf1_event_listener DROP KEY packageID; -ALTER TABLE wcf1_event_listener ADD listenerName VARCHAR(191) NOT NULL; -ALTER TABLE wcf1_event_listener CHANGE eventName eventName TEXT; -ALTER TABLE wcf1_event_listener ADD permissions TEXT; -ALTER TABLE wcf1_event_listener ADD options TEXT; - -UPDATE wcf1_event_listener SET listenerName = CONCAT('com.woltlab.wcf.generic', listenerID); -ALTER TABLE wcf1_event_listener ADD UNIQUE KEY listenerName (listenerName, packageID); - -ALTER TABLE wcf1_label ADD showOrder INT(10) NOT NULL DEFAULT 0; - -ALTER TABLE wcf1_language ADD isDisabled TINYINT(1) NOT NULL DEFAULT 0; - -DROP TABLE IF EXISTS wcf1_language_server; - -DROP TABLE IF EXISTS wcf1_media; -CREATE TABLE wcf1_media ( - mediaID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, - - filename VARCHAR(255) NOT NULL DEFAULT '', - filesize INT(10) NOT NULL DEFAULT 0, - fileType VARCHAR(255) NOT NULL DEFAULT '', - fileHash VARCHAR(255) NOT NULL DEFAULT '', - uploadTime INT(10) NOT NULL DEFAULT 0, - userID INT(10), - username VARCHAR(255) NOT NULL, - languageID INT(10), - isMultilingual TINYINT(1) NOT NULL DEFAULT 0, - - isImage TINYINT(1) NOT NULL DEFAULT 0, - width SMALLINT(5) NOT NULL DEFAULT 0, - height SMALLINT(5) NOT NULL DEFAULT 0, - - tinyThumbnailType VARCHAR(255) NOT NULL DEFAULT '', - tinyThumbnailSize INT(10) NOT NULL DEFAULT 0, - tinyThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0, - tinyThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0, - - smallThumbnailType VARCHAR(255) NOT NULL DEFAULT '', - smallThumbnailSize INT(10) NOT NULL DEFAULT 0, - smallThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0, - smallThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0, - - mediumThumbnailType VARCHAR(255) NOT NULL DEFAULT '', - mediumThumbnailSize INT(10) NOT NULL DEFAULT 0, - mediumThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0, - mediumThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0, - - largeThumbnailType VARCHAR(255) NOT NULL DEFAULT '', - largeThumbnailSize INT(10) NOT NULL DEFAULT 0, - largeThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0, - largeThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0 -); - -DROP TABLE IF EXISTS wcf1_media_content; -CREATE TABLE wcf1_media_content ( - mediaID INT(10) NOT NULL, - languageID INT(10), - title VARCHAR(255) NOT NULL, - caption TEXT, - altText VARCHAR(255) NOT NULL DEFAULT '', - UNIQUE KEY (mediaID, languageID) -); - -DROP TABLE IF EXISTS wcf1_menu; -CREATE TABLE wcf1_menu ( - menuID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, - identifier VARCHAR(255) NOT NULL, - title VARCHAR(255) NOT NULL, - originIsSystem TINYINT(1) NOT NULL DEFAULT 0, - packageID INT(10) NOT NULL -); - -DROP TABLE IF EXISTS wcf1_menu_item; -CREATE TABLE wcf1_menu_item ( - itemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, - menuID INT(10) NOT NULL, - parentItemID INT(10), - identifier VARCHAR(255) NOT NULL, - title VARCHAR(255) NOT NULL, - pageID INT(10), - pageObjectID INT(10) NOT NULL DEFAULT 0, - externalURL VARCHAR(255) NOT NULL DEFAULT '', - showOrder INT(10) NOT NULL DEFAULT 0, - isDisabled TINYINT(1) NOT NULL DEFAULT 0, - originIsSystem TINYINT(1) NOT NULL DEFAULT 0, - packageID INT(10) NOT NULL -); - -ALTER TABLE wcf1_modification_log ADD parentObjectID INT(10); - -ALTER TABLE wcf1_package_update_version DROP COLUMN isCritical; - -DROP TABLE IF EXISTS wcf1_page_menu_item; - -ALTER TABLE wcf1_session DROP COLUMN controller; -ALTER TABLE wcf1_session DROP COLUMN parentObjectType; -ALTER TABLE wcf1_session DROP COLUMN parentObjectID; -ALTER TABLE wcf1_session DROP COLUMN objectType; -ALTER TABLE wcf1_session DROP COLUMN objectID; -ALTER TABLE wcf1_session DROP COLUMN sessionVariables; - -ALTER TABLE wcf1_session ADD pageID INT(10); -ALTER TABLE wcf1_session ADD pageObjectID INT(10); -ALTER TABLE wcf1_session ADD parentPageID INT(10); -ALTER TABLE wcf1_session ADD parentPageObjectID INT(10); -ALTER TABLE wcf1_session ADD KEY pageID (pageID, pageObjectID); -ALTER TABLE wcf1_session ADD KEY parentPageID (parentPageID, parentPageObjectID); - -ALTER TABLE wcf1_session_virtual ADD sessionVariables MEDIUMTEXT; - -DROP TABLE IF EXISTS wcf1_sitemap; - -ALTER TABLE wcf1_smiley ADD smileyPath2x VARCHAR(255) NOT NULL DEFAULT ''; - -ALTER TABLE wcf1_style ADD packageName VARCHAR(255) NOT NULL DEFAULT ''; -ALTER TABLE wcf1_style ADD isTainted TINYINT(1) NOT NULL DEFAULT 0; - -ALTER TABLE wcf1_template_listener ADD permissions TEXT; -ALTER TABLE wcf1_template_listener ADD options TEXT; - -ALTER TABLE wcf1_user CHANGE lostPasswordKey lostPasswordKey CHAR(40) DEFAULT NULL; -ALTER TABLE wcf1_user DROP COLUMN signatureEnableBBCodes; -ALTER TABLE wcf1_user DROP COLUMN signatureEnableSmilies; -ALTER TABLE wcf1_user DROP COLUMN socialNetworkPrivacySettings; - -ALTER TABLE wcf1_user_avatar DROP COLUMN cropX; -ALTER TABLE wcf1_user_avatar DROP COLUMN cropY; - -ALTER TABLE wcf1_user_notification ADD KEY (confirmTime); - -DELETE FROM wcf1_user_profile_visitor WHERE userID IS NULL OR ownerID IS NULL; -ALTER TABLE wcf1_user_profile_visitor CHANGE ownerID ownerID INT(10) NOT NULL; -ALTER TABLE wcf1_user_profile_visitor CHANGE userID userID INT(10) NOT NULL; - -ALTER TABLE wcf1_user_storage ADD KEY (field); - /* foreign keys */ ALTER TABLE wcf1_acl_simple_to_user ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; ALTER TABLE wcf1_acl_simple_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; -- 2.20.1