diff options
| author | Shauren <shauren.trinity@gmail.com> | 2021-02-28 01:14:33 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2021-02-28 01:14:33 +0100 |
| commit | c86cffe5ef95d87929d954abe36d96fe9edb68e3 (patch) | |
| tree | e2d358c0b30f4987e73c339e0a4bbd1db9679f55 /sql/updates | |
| parent | 3e3b93b509b7546894dd098ae68d4f416f572a4e (diff) | |
Core/DataStores: Support all new hotfix status values
Diffstat (limited to 'sql/updates')
| -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`; |