From d78617821a61d01d6e2bdebd71a2b099ee153221 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Tim=20D=C3=BCsterhus?= Date: Fri, 17 Jun 2016 19:22:07 +0200 Subject: [PATCH] Change type of wcf1_background_job.job to MEDIUMBLOB When developing naturally some jobs tend to fail due to a bug, usually one wants to reset the time to allow an immediate execution once the bug is fixed. With a MEDIUMTEXT column however it is too easy to accidentally destroy the whole job, as the serialized data structure contains null bytes that will get mangled when not paying attention. --- wcfsetup/setup/db/install.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/wcfsetup/setup/db/install.sql b/wcfsetup/setup/db/install.sql index 8c39f85dd1..7927e2168e 100644 --- a/wcfsetup/setup/db/install.sql +++ b/wcfsetup/setup/db/install.sql @@ -206,7 +206,7 @@ CREATE TABLE wcf1_attachment ( DROP TABLE IF EXISTS wcf1_background_job; CREATE TABLE wcf1_background_job ( jobID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, - job MEDIUMTEXT NOT NULL, + job MEDIUMBLOB NOT NULL, status ENUM('ready', 'processing') NOT NULL DEFAULT 'ready', time INT(10) NOT NULL, KEY (status, time) -- 2.20.1