diff options
Diffstat (limited to 'sql/updates/hotfixes')
| -rw-r--r-- | sql/updates/hotfixes/master/2021_02_28_00_hotfixes.sql | 6 |
1 files changed, 6 insertions, 0 deletions
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`; |