From c86cffe5ef95d87929d954abe36d96fe9edb68e3 Mon Sep 17 00:00:00 2001 From: Shauren Date: Sun, 28 Feb 2021 01:14:33 +0100 Subject: Core/DataStores: Support all new hotfix status values --- sql/updates/hotfixes/master/2021_02_28_00_hotfixes.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/hotfixes/master/2021_02_28_00_hotfixes.sql (limited to 'sql') diff --git a/sql/updates/hotfixes/master/2021_02_28_00_hotfixes.sql b/sql/updates/hotfixes/master/2021_02_28_00_hotfixes.sql new file mode 100644 index 00000000000..c34d9d05b85 --- /dev/null +++ b/sql/updates/hotfixes/master/2021_02_28_00_hotfixes.sql @@ -0,0 +1,6 @@ +ALTER TABLE `hotfix_data` ADD `Status` tinyint(3) unsigned NOT NULL DEFAULT '3' AFTER `Deleted`; + +UPDATE `hotfix_data` SET `Status`=1 WHERE `Deleted`=0; +UPDATE `hotfix_data` SET `Status`=2 WHERE `Deleted`=1; + +ALTER TABLE `hotfix_data` DROP `Deleted`; -- cgit v1.2.3