From 9696d6ba7b02b722b4a03e253ffa653e16940af1 Mon Sep 17 00:00:00 2001 From: kaelima 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/updates/characters/2011_11_25_00_characters_character_stats.sql | 5 +++++ sql/updates/characters/2011_11_25_01_characters_characters.sql | 5 +++++ sql/updates/characters/2011_11_25_02_characters_character_pet.sql | 1 + 3 files changed, 11 insertions(+) create mode 100644 sql/updates/characters/2011_11_25_00_characters_character_stats.sql create mode 100644 sql/updates/characters/2011_11_25_01_characters_characters.sql create mode 100644 sql/updates/characters/2011_11_25_02_characters_character_pet.sql (limited to 'sql/updates') diff --git a/sql/updates/characters/2011_11_25_00_characters_character_stats.sql b/sql/updates/characters/2011_11_25_00_characters_character_stats.sql new file mode 100644 index 00000000000..60506a491e3 --- /dev/null +++ b/sql/updates/characters/2011_11_25_00_characters_character_stats.sql @@ -0,0 +1,5 @@ +ALTER TABLE `character_stats` +ADD COLUMN `maxpower8` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `maxpower7`, +ADD COLUMN `maxpower9` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `maxpower8`, +ADD COLUMN `maxpower10` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `maxpower9`, +ADD COLUMN `maxpower11` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `maxpower10`; diff --git a/sql/updates/characters/2011_11_25_01_characters_characters.sql b/sql/updates/characters/2011_11_25_01_characters_characters.sql new file mode 100644 index 00000000000..6e56aaf9aea --- /dev/null +++ b/sql/updates/characters/2011_11_25_01_characters_characters.sql @@ -0,0 +1,5 @@ +ALTER TABLE `characters` +ADD COLUMN `power8` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `power7`, +ADD COLUMN `power9` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `power8`, +ADD COLUMN `power10` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `power9`, +ADD COLUMN `power11` int(10) UNSIGNED NOT NULL DEFAULT '0' AFTER `power10`; diff --git a/sql/updates/characters/2011_11_25_02_characters_character_pet.sql b/sql/updates/characters/2011_11_25_02_characters_character_pet.sql new file mode 100644 index 00000000000..61a1490b219 --- /dev/null +++ b/sql/updates/characters/2011_11_25_02_characters_character_pet.sql @@ -0,0 +1 @@ +ALTER TABLE `character_pet` DROP COLUMN `curhappiness`; -- cgit v1.2.3