diff options
| author | Shauren <shauren.trinity@gmail.com> | 2022-06-26 21:27:17 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2022-06-26 21:27:17 +0200 |
| commit | 70eacebad531af0a4b5b4ac6be6d90ddc56ed5d4 (patch) | |
| tree | 06d22a98099f3e56aee2d8492427fe3ac63beea0 /sql | |
| parent | 6285033ed5ba8f67330eca40c1ae4840882a98d3 (diff) | |
Core/WorldStates: Add area requirements to world states
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_06_26_02_world.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_06_26_02_world.sql b/sql/updates/world/master/2022_06_26_02_world.sql new file mode 100644 index 00000000000..31f3cdf533f --- /dev/null +++ b/sql/updates/world/master/2022_06_26_02_world.sql @@ -0,0 +1,3 @@ +ALTER TABLE `world_state` ADD `AreaIDs` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL AFTER `MapIDs`; + +UPDATE `world_state` SET `MapIDs`='571,2118',`AreaIDs`='4197,10176' WHERE `ID` IN (3490,3491,3680,3681,3698,3699,3700,3701,3702,3703,3704,3705,3706,3710,3711,3712,3713,3714,3749,3750,3751,3752,3753,3754,3755,3756,3757,3758,3759,3760,3761,3762,3763,3764,3765,3766,3767,3768,3769,3770,3771,3772,3773,3781,3801,3802,3803,4022,4023,4024,4025,4354); |