aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorShocker <shocker@freakz.ro>2011-05-09 17:01:10 +0300
committerShocker <shocker@freakz.ro>2011-05-09 17:01:10 +0300
commit3fa651ce199e3e9fe65328c5c8fb9b916eb5647b (patch)
treebd4cebd665ffc9829fdf93e5d583e44fc43ee4eb /sql
parent8a2b1c302b963db961b1f43c6e718eab0ae42537 (diff)
Core/Misc: Include resilience in character_stats
Diffstat (limited to 'sql')
-rw-r--r--sql/base/characters_database.sql1
-rw-r--r--sql/updates/auth_char/2011_05_09_00_characters_character_stats.sql1
2 files changed, 2 insertions, 0 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 1351baae44f..0f8aa2fd9b0 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -1055,6 +1055,7 @@ CREATE TABLE `character_stats` (
`attackPower` int(10) unsigned NOT NULL DEFAULT '0',
`rangedAttackPower` int(10) unsigned NOT NULL DEFAULT '0',
`spellPower` int(10) unsigned NOT NULL DEFAULT '0',
+ `resilience` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`guid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
diff --git a/sql/updates/auth_char/2011_05_09_00_characters_character_stats.sql b/sql/updates/auth_char/2011_05_09_00_characters_character_stats.sql
new file mode 100644
index 00000000000..24defd48f60
--- /dev/null
+++ b/sql/updates/auth_char/2011_05_09_00_characters_character_stats.sql
@@ -0,0 +1 @@
+ALTER TABLE `character_stats` ADD `resilience` INT UNSIGNED NOT NULL DEFAULT 0;