diff options
| author | Rat <gmstreetrat@gmail.com> | 2011-11-27 09:37:32 +0100 |
|---|---|---|
| committer | Rat <gmstreetrat@gmail.com> | 2011-11-27 09:37:32 +0100 |
| commit | 70c3488dd0c5aa123cd1c15242add92187af7048 (patch) | |
| tree | 84d2fce5148042f9c700da43ee933170251cae8e /sql/base/characters_database.sql | |
| parent | b84d82e569848f6be08049c2c81f26b89ed30efa (diff) | |
Core/Player: fixed player loading to reflect new DB changes
- added missing changes to characters_datasabase.sql
Diffstat (limited to 'sql/base/characters_database.sql')
| -rw-r--r-- | sql/base/characters_database.sql | 20 |
1 files changed, 2 insertions, 18 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 1410a5b0008..bce0a211b3c 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -1031,12 +1031,6 @@ CREATE TABLE `character_stats` ( `maxpower3` int(10) unsigned NOT NULL DEFAULT '0', `maxpower4` int(10) unsigned NOT NULL DEFAULT '0', `maxpower5` int(10) unsigned NOT NULL DEFAULT '0', - `maxpower6` int(10) unsigned NOT NULL DEFAULT '0', - `maxpower7` int(10) unsigned NOT NULL DEFAULT '0', - `maxpower8` int(10) unsigned NOT NULL DEFAULT '0', - `maxpower9` int(10) unsigned NOT NULL DEFAULT '0', - `maxpower10` int(10) unsigned NOT NULL DEFAULT '0', - `maxpower11` int(10) unsigned NOT NULL DEFAULT '0', `strength` int(10) unsigned NOT NULL DEFAULT '0', `agility` int(10) unsigned NOT NULL DEFAULT '0', `stamina` int(10) unsigned NOT NULL DEFAULT '0', @@ -1144,15 +1138,12 @@ CREATE TABLE `characters` ( `zone` smallint(5) unsigned NOT NULL DEFAULT '0', `death_expire_time` int(10) unsigned NOT NULL DEFAULT '0', `taxi_path` text, - `arenaPoints` int(10) unsigned NOT NULL DEFAULT '0', + `conquestPoints` 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', @@ -1161,21 +1152,15 @@ CREATE TABLE `characters` ( `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', - `power8` int(10) unsigned NOT NULL DEFAULT '0', - `power9` int(10) unsigned NOT NULL DEFAULT '0', - `power10` int(10) unsigned NOT NULL DEFAULT '0', - `power11` int(10) unsigned NOT NULL DEFAULT '0', `latency` mediumint(8) unsigned NOT NULL DEFAULT '0', `speccount` tinyint(3) unsigned NOT NULL DEFAULT '1', `activespec` tinyint(3) unsigned NOT NULL DEFAULT '0', `exploredZones` longtext, `equipmentCache` longtext, - `ammoId` int(10) unsigned NOT NULL DEFAULT '0', `knownTitles` longtext, `actionBars` tinyint(3) unsigned NOT NULL DEFAULT '0', `grantableLevels` tinyint(3) unsigned NOT NULL DEFAULT '0', + `guildId` int(10) unsigned NOT NULL DEFAULT '0', `deleteInfos_Account` int(10) unsigned DEFAULT NULL, `deleteInfos_Name` varchar(12) DEFAULT NULL, `deleteDate` int(10) unsigned DEFAULT NULL, @@ -1215,7 +1200,6 @@ CREATE TABLE `corpse` ( `itemCache` text NOT NULL, `bytes1` int(10) unsigned NOT NULL DEFAULT '0', `bytes2` int(10) unsigned NOT NULL DEFAULT '0', - `guildId` int(10) unsigned NOT NULL DEFAULT '0', `flags` tinyint(3) unsigned NOT NULL DEFAULT '0', `dynFlags` tinyint(3) unsigned NOT NULL DEFAULT '0', `time` int(10) unsigned NOT NULL DEFAULT '0', |