From 74ccd57597441a22f01b168a4dd2ce0a2cd38fb2 Mon Sep 17 00:00:00 2001
From: Brian <runningnak3d@gmail.com>
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

