From 74ccd57597441a22f01b168a4dd2ce0a2cd38fb2 Mon Sep 17 00:00:00 2001 From: Brian Date: Tue, 2 Mar 2010 10:12:47 -0700 Subject: * Move some values out of the data blob in the characters table * (honor, kills, title, currencies, watched faction, drunken-status, health and power) * Original Author Hunuza - thank you * Ported to Trinity by RammboNr5 - thank you * Tested by Aokromes - thank you * Closes Issue #911 --HG-- branch : trunk --- sql/characters.sql | 20 +++++++++++++++++++- 1 file changed, 19 insertions(+), 1 deletion(-) (limited to 'sql/characters.sql') diff --git a/sql/characters.sql b/sql/characters.sql index d8663ba59ac..bede8fe15b2 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -366,7 +366,25 @@ CREATE TABLE `characters` ( `zone` int(11) unsigned NOT NULL default '0', `death_expire_time` bigint(20) unsigned NOT NULL default '0', `taxi_path` text, - `arena_pending_points` int(10) UNSIGNED NOT NULL default '0', + `arenaPoints` int(10) unsigned NOT NULL default'0', + `totalHonorPoints` int(10) unsigned NOT NULL default'0', + `todayHonorPoints` int(10) unsigned NOT NULL default'0', + `yesterdayHonorPoints` int(10) unsigned NOT NULL default'0', + `totalKills` int(10) unsigned NOT NULL default'0', + `todayKills` smallint(5) unsigned NOT NULL default'0', + `yesterdayKills` smallint(5) unsigned NOT NULL default'0', + `chosenTitle` int(10) unsigned NOT NULL default'0', + `knownCurrencies` bigint(20) unsigned NOT NULL default'0', + `watchedFaction` int(10) unsigned NOT NULL default'0', + `drunk` smallint(5) unsigned NOT NULL default'0', + `health` int(10) unsigned NOT NULL default'0', + `power1` int(10) unsigned NOT NULL default'0', + `power2` int(10) unsigned NOT NULL default'0', + `power3` int(10) unsigned NOT NULL default'0', + `power4` int(10) unsigned NOT NULL default'0', + `power5` int(10) unsigned NOT NULL default'0', + `power6` int(10) unsigned NOT NULL default'0', + `power7` int(10) unsigned NOT NULL default'0', `speccount` tinyint(3) unsigned NOT NULL default 1, `activespec` tinyint(3) unsigned NOT NULL default 0, `latency` int(11) unsigned NOT NULL default '0', -- cgit v1.2.3