From 5cbf5fd9ac4382a467d351133899c11a1a41ef3e Mon Sep 17 00:00:00 2001 From: Alexander Ebert Date: Sat, 27 Jul 2013 16:54:44 +0200 Subject: [PATCH] Added missing import mapping in update Beta 5 --- com.woltlab.wcf/update_b5.sql | 12 +++++++++++- 1 file changed, 11 insertions(+), 1 deletion(-) diff --git a/com.woltlab.wcf/update_b5.sql b/com.woltlab.wcf/update_b5.sql index e9c36426cd..e6e30ee6b4 100644 --- a/com.woltlab.wcf/update_b5.sql +++ b/com.woltlab.wcf/update_b5.sql @@ -8,4 +8,14 @@ ALTER TABLE wcf1_user_activity_point ADD items INT(10) NOT NULL DEFAULT '0'; /* b33c97d */ ALTER TABLE wcf1_package_installation_queue DROP COLUMN confirmInstallation; ALTER TABLE wcf1_package_installation_queue DROP COLUMN packageType; -ALTER TABLE wcf1_package_installation_queue ADD isApplication TINYINT(1) NOT NULL DEFAULT '0'; \ No newline at end of file +ALTER TABLE wcf1_package_installation_queue ADD isApplication TINYINT(1) NOT NULL DEFAULT '0'; + +DROP TABLE IF EXISTS wcf1_import_mapping; +CREATE TABLE wcf1_import_mapping ( + objectTypeID INT(10) NOT NULL, + oldID VARCHAR(255) NOT NULL, + newID INT(10) NOT NULL, + UNIQUE KEY (objectTypeID, oldID) +); + +ALTER TABLE wcf1_import_mapping ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; \ No newline at end of file -- 2.20.1