diff options
| author | kaelima <kaelima@live.se> | 2011-11-25 15:28:36 +0100 |
|---|---|---|
| committer | kaelima <kaelima@live.se> | 2011-11-25 15:28:36 +0100 |
| commit | 9696d6ba7b02b722b4a03e253ffa653e16940af1 (patch) | |
| tree | 409e18b34eff3bfa442d81601824bc9527ce8f5c /sql/base | |
| parent | ec3880a1d062c6b933feaf26de6a92c3cb5d98e2 (diff) | |
Core/Mechanics:
- Add basic support for focus used by players (hunters)
- Drop all support for pet happieness (as it has been completely removed)
- Add new fields to characters db to store new power values
(Should now be able to create characters again)
Diffstat (limited to 'sql/base')
| -rw-r--r-- | sql/base/characters_database.sql | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 6296351f52f..1410a5b0008 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -737,7 +737,6 @@ CREATE TABLE `character_pet` ( `slot` tinyint(3) unsigned NOT NULL DEFAULT '0', `curhealth` int(10) unsigned NOT NULL DEFAULT '1', `curmana` int(10) unsigned NOT NULL DEFAULT '0', - `curhappiness` int(10) unsigned NOT NULL DEFAULT '0', `savetime` int(10) unsigned NOT NULL DEFAULT '0', `abdata` text, PRIMARY KEY (`id`), @@ -1034,6 +1033,10 @@ CREATE TABLE `character_stats` ( `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', @@ -1160,6 +1163,10 @@ 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', + `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', |