Insert new `identifier` column for background jobs

[GitHub/WoltLab/WCF.git] / wcfsetup / setup / db / install.sql

diff --git a/wcfsetup/setup/db/install.sql b/wcfsetup/setup/db/install.sql
index 80631ae6dfd3f856bc06c00dfd7f3c07fc30c5ca..59aecbe0ebcfae15586accb48d44dbfe869b9f51 100644 (file)
--- a/wcfsetup/setup/db/install.sql
+++ b/wcfsetup/setup/db/install.sql
@@ -67,6 +67,15 @@ CREATE TABLE wcf1_acl_simple_to_group (
        UNIQUE KEY groupKey (objectTypeID, objectID, groupID)
 );
 
+DROP TABLE IF EXISTS wcf1_acp_dashboard_box_to_user;
+CREATE TABLE wcf1_acp_dashboard_box_to_user (
+       boxName VARCHAR(191) NOT NULL,
+       userID INT(10) NOT NULL,
+       enabled TINYINT(1) NOT NULL DEFAULT 0,
+       showOrder INT(10) NOT NULL DEFAULT 0,
+       UNIQUE KEY boxToUser (boxName, userID)
+);
+
 DROP TABLE IF EXISTS wcf1_acp_menu_item;
 CREATE TABLE wcf1_acp_menu_item (
        menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
@@ -225,6 +234,9 @@ CREATE TABLE wcf1_background_job (
        job MEDIUMBLOB NOT NULL,
        status ENUM('ready', 'processing') NOT NULL DEFAULT 'ready',
        time INT(10) NOT NULL,
+       identifier VARCHAR(191) NULL,
+
+       KEY identifier (identifier),
        KEY (status, time)
 );
 
@@ -790,7 +802,8 @@ CREATE TABLE wcf1_message_embedded_object (
        embeddedObjectTypeID INT(10) NOT NULL,
        embeddedObjectID INT(10) NOT NULL,
 
-       KEY (messageObjectTypeID, messageID)
+       KEY (messageObjectTypeID, messageID),
+       UNIQUE KEY messageEmbeddedObject (messageObjectTypeID, messageID, embeddedObjectTypeID, embeddedObjectID)
 );
 
 DROP TABLE IF EXISTS wcf1_moderation_queue;
@@ -1949,6 +1962,8 @@ ALTER TABLE wcf1_acl_simple_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_use
 ALTER TABLE wcf1_acl_simple_to_group ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
 ALTER TABLE wcf1_acl_simple_to_group ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
 
+ALTER TABLE wcf1_acp_dashboard_box_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
+
 ALTER TABLE wcf1_acp_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
 
 ALTER TABLE wcf1_acp_search_provider ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
@@ -2478,8 +2493,9 @@ INSERT INTO wcf1_style_variable (variableName, defaultValue, defaultValueDarkMod
 INSERT INTO wcf1_style_variable (variableName, defaultValue, defaultValueDarkMode) VALUES('individualScssDarkMode', '', '');
 INSERT INTO wcf1_style_variable (variableName, defaultValue, defaultValueDarkMode) VALUES('wcfHeaderMenuDropdownBorder', 'rgba(36, 66, 95, 1)', 'rgba(36, 66, 95, 1)');
 
--- Email template group
+-- System template groups
 INSERT INTO wcf1_template_group (parentTemplateGroupID, templateGroupName, templateGroupFolderName) VALUES (NULL, 'wcf.acp.template.group.email', '_wcf_email/');
+INSERT INTO wcf1_template_group (parentTemplateGroupID, templateGroupName, templateGroupFolderName) VALUES (NULL, 'wcf.acp.template.group.shared', '_wcf_shared/');
 
 -- default options: subject and message
 INSERT INTO wcf1_contact_option (optionID, optionTitle, optionDescription, optionType, required, showOrder, originIsSystem) VALUES (1, 'wcf.contact.option1', 'wcf.contact.optionDescription1', 'text', 1, 1, 1);