aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authortobmaps <spambot42@yandex.ru>2011-05-31 05:47:17 +0700
committertobmaps <spambot42@yandex.ru>2011-05-31 05:47:17 +0700
commit600cc16c9496ec74d66e4d6b77fba085a71fd293 (patch)
tree3f386f76cdf3051ebb1330627a702c326bea647c /sql
parent7f573dbcb8a24dbec14ab4f6a3cf85f1a6d20906 (diff)
Core/Players: Pet talents can be reset at a pet trainer for free, original idea by rsa
Diffstat (limited to 'sql')
-rw-r--r--sql/base/characters_database.sql2
-rw-r--r--sql/updates/characters/2011_05_31_0_characters_character_pet.sql3
2 files changed, 3 insertions, 2 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index ad33354aaf7..75a0723235a 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -739,8 +739,6 @@ CREATE TABLE `character_pet` (
`curmana` int(10) unsigned NOT NULL DEFAULT '0',
`curhappiness` int(10) unsigned NOT NULL DEFAULT '0',
`savetime` int(10) unsigned NOT NULL DEFAULT '0',
- `resettalents_cost` int(10) unsigned NOT NULL DEFAULT '0',
- `resettalents_time` int(10) unsigned NOT NULL DEFAULT '0',
`abdata` text,
PRIMARY KEY (`id`),
KEY `owner` (`owner`),
diff --git a/sql/updates/characters/2011_05_31_0_characters_character_pet.sql b/sql/updates/characters/2011_05_31_0_characters_character_pet.sql
new file mode 100644
index 00000000000..f36bc806de7
--- /dev/null
+++ b/sql/updates/characters/2011_05_31_0_characters_character_pet.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `character_pet`
+DROP COLUMN `resettalents_cost`,
+DROP COLUMN `resettalents_time`;