diff options
| author | n0n4m3 <none@none> | 2010-04-11 11:00:02 +0400 |
|---|---|---|
| committer | n0n4m3 <none@none> | 2010-04-11 11:00:02 +0400 |
| commit | 1dc4f7c745f9f061a545c11c0132a67e5f828702 (patch) | |
| tree | 0231fa152a78a56f5852513e6bc7d612dac2a385 /sql/characters.sql | |
| parent | 420496c92a23c0a7ecddefc4a0ca08ca8f901983 (diff) | |
Drop characters data blob. Bit thx to hunuza.
--HG--
branch : trunk
Diffstat (limited to 'sql/characters.sql')
| -rw-r--r-- | sql/characters.sql | 7 |
1 files changed, 5 insertions, 2 deletions
diff --git a/sql/characters.sql b/sql/characters.sql index bec2793647c..a36764752e6 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -327,7 +327,6 @@ DROP TABLE IF EXISTS `characters`; CREATE TABLE `characters` ( `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier', `account` int(11) unsigned NOT NULL default '0' COMMENT 'Account Identifier', - `data` longtext, `name` varchar(12) NOT NULL default '', `race` tinyint(3) unsigned NOT NULL default '0', `class` tinyint(3) unsigned NOT NULL default '0', @@ -385,9 +384,13 @@ CREATE TABLE `characters` ( `power5` int(10) unsigned NOT NULL default'0', `power6` int(10) unsigned NOT NULL default'0', `power7` int(10) unsigned NOT NULL default'0', + `latency` int(11) 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', + `exploredZones` longtext, + `equipmentCache` longtext, + `ammoId` int(10) UNSIGNED NOT NULL default '0', + `knownTitles` longtext, PRIMARY KEY (`guid`), KEY `idx_account` (`account`), KEY `idx_online` (`online`), |