diff options
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', |