From 9696d6ba7b02b722b4a03e253ffa653e16940af1 Mon Sep 17 00:00:00 2001
From: kaelima <kaelima@live.se>
Date: Fri, 25 Nov 2011 15:28:36 +0100
Subject: 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)
---
 sql/base/characters_database.sql | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)

(limited to 'sql/base/characters_database.sql')

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',
-- 
cgit v1.2.3

