From 09ff6e15bd4007f96d0e542546bb272b1a04cad1 Mon Sep 17 00:00:00 2001 From: Alexander Ebert Date: Wed, 6 Sep 2017 14:50:12 +0200 Subject: [PATCH] Increase column length of `eventClassName` Closes #2413 --- com.woltlab.wcf/update_3.1.0_alpha_1.sql | 4 ---- com.woltlab.wcf/update_3.1.0_alpha_2.sql | 1 + com.woltlab.wcf/update_3.1_3.sql | 2 ++ wcfsetup/setup/db/install.sql | 2 +- 4 files changed, 4 insertions(+), 5 deletions(-) delete mode 100644 com.woltlab.wcf/update_3.1.0_alpha_1.sql create mode 100644 com.woltlab.wcf/update_3.1.0_alpha_2.sql diff --git a/com.woltlab.wcf/update_3.1.0_alpha_1.sql b/com.woltlab.wcf/update_3.1.0_alpha_1.sql deleted file mode 100644 index 583dddfa9b..0000000000 --- a/com.woltlab.wcf/update_3.1.0_alpha_1.sql +++ /dev/null @@ -1,4 +0,0 @@ -ALTER TABLE wcf1_style ADD COLUMN apiVersion ENUM('3.0', '3.1') NOT NULL DEFAULT '3.0'; - -INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentContainerBackground', 'rgba(255, 255, 255, 1)'); -INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentContainerBorder', 'rgba(236, 241, 247, 1)'); diff --git a/com.woltlab.wcf/update_3.1.0_alpha_2.sql b/com.woltlab.wcf/update_3.1.0_alpha_2.sql new file mode 100644 index 0000000000..e5a28a5f80 --- /dev/null +++ b/com.woltlab.wcf/update_3.1.0_alpha_2.sql @@ -0,0 +1 @@ +ALTER TABLE wcf1_event_listener CHANGE eventClassName eventClassName VARCHAR(255) NOT NULL DEFAULT ''; diff --git a/com.woltlab.wcf/update_3.1_3.sql b/com.woltlab.wcf/update_3.1_3.sql index cbd0b9eb03..3d40036a5d 100644 --- a/com.woltlab.wcf/update_3.1_3.sql +++ b/com.woltlab.wcf/update_3.1_3.sql @@ -38,6 +38,8 @@ CREATE TABLE wcf1_devtools_project ( UNIQUE KEY name (name) ); +ALTER TABLE wcf1_event_listener CHANGE eventClassName eventClassName VARCHAR(255) NOT NULL DEFAULT ''; + ALTER TABLE wcf1_package_update_server CHANGE COLUMN apiVersion apiVersion ENUM('2.0', '2.1', '3.1') NOT NULL DEFAULT '2.0'; DROP TABLE IF EXISTS wcf1_page_box_order; diff --git a/wcfsetup/setup/db/install.sql b/wcfsetup/setup/db/install.sql index 255b38ae81..4c86bcaaa4 100644 --- a/wcfsetup/setup/db/install.sql +++ b/wcfsetup/setup/db/install.sql @@ -532,7 +532,7 @@ CREATE TABLE wcf1_event_listener ( packageID INT(10) NOT NULL, environment ENUM('user', 'admin') NOT NULL DEFAULT 'user', listenerName VARCHAR(191) NOT NULL, - eventClassName VARCHAR(80) NOT NULL DEFAULT '', + eventClassName VARCHAR(255) NOT NULL DEFAULT '', eventName TEXT, listenerClassName VARCHAR(200) NOT NULL DEFAULT '', inherit TINYINT(1) NOT NULL DEFAULT 0, -- 2.20.1