diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/characters.sql | 2 | ||||
| -rw-r--r-- | sql/updates/79_characters.sql | 2 | ||||
| -rw-r--r-- | sql/updates/79_world.sql | 6 |
3 files changed, 9 insertions, 1 deletions
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 |