aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2025-01-21 14:11:54 +0100
committerShauren <shauren.trinity@gmail.com>2025-01-21 14:11:54 +0100
commit2a51a6454912df635099572d07789a1d6789ff4d (patch)
tree5af7415fd0889864fd8721fb048efb2d75d26fee /sql
parent476b8951e1fffc05a01ab04fea6e1134a6f0f95a (diff)
Core/Spells: Reimplemented target type 106 as random point from points predefined in database
Closes #30116
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/world/master/2025_01_21_00_world.sql3
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/master/2025_01_21_00_world.sql b/sql/updates/world/master/2025_01_21_00_world.sql
new file mode 100644
index 00000000000..b3f89ecbbf3
--- /dev/null
+++ b/sql/updates/world/master/2025_01_21_00_world.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `spell_target_position` DROP PRIMARY KEY;
+ALTER TABLE `spell_target_position` ADD `OrderIndex` int NOT NULL DEFAULT '0' AFTER `EffectIndex`;
+ALTER TABLE `spell_target_position` ADD PRIMARY KEY(`ID`,`EffectIndex`,`OrderIndex`);