aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
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`;