aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/79_characters.sql2
-rw-r--r--sql/updates/79_world.sql6
2 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/79_characters.sql b/sql/updates/79_characters.sql
new file mode 100644
index 00000000000..d2f29d734d6
--- /dev/null
+++ b/sql/updates/79_characters.sql
@@ -0,0 +1,2 @@
+ALTER TABLE characters
+ CHANGE COLUMN gmstate extra_flags int(11) unsigned NOT NULL default '0'; \ No newline at end of file
diff --git a/sql/updates/79_world.sql b/sql/updates/79_world.sql
new file mode 100644
index 00000000000..2a61c2f6a09
--- /dev/null
+++ b/sql/updates/79_world.sql
@@ -0,0 +1,6 @@
+DELETE FROM spell_proc_event where entry = 42083;
+INSERT INTO spell_proc_event (entry, SchoolMask, Category, SkillID, SpellFamilyName, SpellFamilyMask, procFlags, ppmRate, cooldown) VALUES
+(42083,0,0,0,0,0x0000000000000000,0x00401000,0,45);
+
+ALTER TABLE characters
+ CHANGE COLUMN gmstate extra_flags int(11) unsigned NOT NULL default '0'; \ No newline at end of file