aboutsummaryrefslogtreecommitdiff
path: root/sql/updates/characters
diff options
context:
space:
mode:
authorShauren <shauren.trinity@gmail.com>2012-08-07 17:45:10 +0200
committerShauren <shauren.trinity@gmail.com>2012-08-07 17:45:10 +0200
commitf8cd39b2ed1056f409c2690ac8bb661fbcb68e18 (patch)
tree6667b32a6e00d5616061245e5588341680429f4c /sql/updates/characters
parent429130522e223c8a5cd80d6e23fda4cc30ce5132 (diff)
Core/Players: Improved alcohol handling, weeeeeeeeeeeeeeeee
Closes #7293
Diffstat (limited to 'sql/updates/characters')
-rw-r--r--sql/updates/characters/2012_08_07_00_characters_characters.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/updates/characters/2012_08_07_00_characters_characters.sql b/sql/updates/characters/2012_08_07_00_characters_characters.sql
new file mode 100644
index 00000000000..e9bea82ad4b
--- /dev/null
+++ b/sql/updates/characters/2012_08_07_00_characters_characters.sql
@@ -0,0 +1,2 @@
+UPDATE characters SET drunk = (drunk / 256) & 0xFF;
+ALTER TABLE characters CHANGE drunk drunk tinyint(3) unsigned NOT NULL DEFAULT '0';