From fcde03a03670caa76b0933dbf3e7a1e95bb2b3be Mon Sep 17 00:00:00 2001
From: KingPin <none@none>
Date: Sun, 19 Oct 2008 21:08:34 -0500
Subject: [svn] * Fixed compile from r78 * Fixed: not apply healling bonus to
 spell 40972 heal amount. - Source Mangos * Item 30627 hidden cooldown -
 Source Mangos * Fixed Trinityrealm autopatching system - Source Arrai * Add
 support for autoconf 2.6.2 and newer - Source Derex Some decent sized
 changes, please test before deploying - KP

--HG--
branch : trunk
---
 sql/characters.sql            | 2 +-
 sql/updates/79_characters.sql | 2 ++
 sql/updates/79_world.sql      | 6 ++++++
 3 files changed, 9 insertions(+), 1 deletion(-)
 create mode 100644 sql/updates/79_characters.sql
 create mode 100644 sql/updates/79_world.sql

(limited to 'sql')

diff --git a/sql/characters.sql b/sql/characters.sql
index d25e000ebdc..429b4c0508a 100644
--- a/sql/characters.sql
+++ b/sql/characters.sql
@@ -608,7 +608,7 @@ CREATE TABLE `characters` (
   `trans_z` float NOT NULL default '0',
   `trans_o` float NOT NULL default '0',
   `transguid` bigint(20) unsigned NOT NULL default '0',
-  `gmstate` tinyint(3) unsigned NOT NULL default '0',
+  `extra_flags` tinyint(3) unsigned NOT NULL default '0',
   `stable_slots` tinyint(1) unsigned NOT NULL default '0',
   `at_login` int(11) unsigned NOT NULL default '0',
   `zone` int(11) unsigned NOT NULL default '0',
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
-- 
cgit v1.2.3