diff options
| author | p0wer <none@none> | 2010-03-02 19:45:32 -0600 |
|---|---|---|
| committer | p0wer <none@none> | 2010-03-02 19:45:32 -0600 |
| commit | f4a4a6bfc2c3b4ef78baebd57a5563f862ccdbb8 (patch) | |
| tree | 67c6db61e52437095996dfff9e9e769e6efab9bc /sql/characters.sql | |
| parent | 2942a19592d2820e6bd284a909a532bc0015a3d0 (diff) | |
| parent | 74ccd57597441a22f01b168a4dd2ce0a2cd38fb2 (diff) | |
Merge. ><
--HG--
branch : trunk
Diffstat (limited to 'sql/characters.sql')
| -rw-r--r-- | sql/characters.sql | 20 |
1 files changed, 19 insertions, 1 deletions
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', |