aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
Diffstat (limited to 'sql')
-rw-r--r--sql/updates/8049_world_npc_vendor.sql2
-rw-r--r--sql/updates/8049_world_trinity_strings.sql3
2 files changed, 5 insertions, 0 deletions
diff --git a/sql/updates/8049_world_npc_vendor.sql b/sql/updates/8049_world_npc_vendor.sql
new file mode 100644
index 00000000000..c09d579f725
--- /dev/null
+++ b/sql/updates/8049_world_npc_vendor.sql
@@ -0,0 +1,2 @@
+ALTER TABLE npc_vendor DROP PRIMARY KEY,
+ADD PRIMARY KEY (`entry`,`item`,`ExtendedCost`);
diff --git a/sql/updates/8049_world_trinity_strings.sql b/sql/updates/8049_world_trinity_strings.sql
new file mode 100644
index 00000000000..e04e776a3e8
--- /dev/null
+++ b/sql/updates/8049_world_trinity_strings.sql
@@ -0,0 +1,3 @@
+DELETE FROM trinity_string WHERE entry in (210);
+INSERT INTO trinity_string VALUES
+(210,'Item ''%i'' (with extended cost %u) already in vendor list', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);