From cfa2e223c03b2b6fbc7bce39ba942ebbecd95c5a Mon Sep 17 00:00:00 2001
From: megamage <none@none>
Date: Thu, 28 May 2009 18:22:54 -0500
Subject:     [7903] Load and save for pets only talents. Not store unused (in
 fact) free talent point amount. Author: VladimirMangos

    * Other pet spell types auto-learned at level setup/load.
    * Code will cleanup pet_spell table from non-talents spell if detect any at load.
    * Free talents points recalculated at loading and levelup so store its in DB useless.

    Note: bug with not highlighting learned pet talents (except first line) until learn one more talent not fixed.

--HG--
branch : trunk
---
 sql/characters.sql                               | 23 ++++++++++++++++++++++-
 sql/updates/7903_01_characters_character_pet.sql |  4 ++++
 2 files changed, 26 insertions(+), 1 deletion(-)
 create mode 100644 sql/updates/7903_01_characters_character_pet.sql

(limited to 'sql')

diff --git a/sql/characters.sql b/sql/characters.sql
index 6785c3a59a8..6b27a1753cd 100644
--- a/sql/characters.sql
+++ b/sql/characters.sql
@@ -15,6 +15,28 @@
 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 
+/*
+
+--
+-- Table structure for table `character_db_version`
+--
+
+DROP TABLE IF EXISTS `character_db_version`;
+CREATE TABLE `character_db_version` (
+  `required_7903_01_characters_character_pet` bit(1) default NULL
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Last applied sql update to DB';
+
+--
+-- Dumping data for table `character_db_version`
+--
+
+LOCK TABLES `character_db_version` WRITE;
+INSERT INTO `character_db_version` VALUES
+(NULL);
+UNLOCK TABLES;
+
+*/
+
 --
 -- Table structure for table `account_data`
 --
@@ -538,7 +560,6 @@ CREATE TABLE `character_pet` (
   `level` int(11) unsigned NOT NULL default '1',
   `exp` int(11) unsigned NOT NULL default '0',
   `Reactstate` tinyint(1) unsigned NOT NULL default '0',
-  `talentpoints` int(11) unsigned NOT NULL default '0',
   `name` varchar(100) default 'Pet',
   `renamed` tinyint(1) unsigned NOT NULL default '0',
   `slot` int(11) unsigned NOT NULL default '0',
diff --git a/sql/updates/7903_01_characters_character_pet.sql b/sql/updates/7903_01_characters_character_pet.sql
new file mode 100644
index 00000000000..834aac200bb
--- /dev/null
+++ b/sql/updates/7903_01_characters_character_pet.sql
@@ -0,0 +1,4 @@
+ALTER TABLE character_db_version CHANGE COLUMN required_7887_01_characters_character_pet required_7903_01_characters_character_pet bit;
+
+ALTER TABLE `character_pet`
+  DROP `talentpoints`;
-- 
cgit v1.2.3