From ab6a2c04c842dea77a7de05428e6e98f3d654265 Mon Sep 17 00:00:00 2001 From: ApoC Date: Tue, 16 Dec 2008 02:20:45 +0100 Subject: [PATCH] Added missing alters to db_version. Signed-off-by: ApoC --- sql/characters.sql | 2 +- sql/mangos.sql | 2 +- sql/updates/2008_12_15_01_character_arenas.sql | 2 ++ sql/updates/2008_12_15_01_mangos_arenas.sql | 2 ++ 4 files changed, 6 insertions(+), 2 deletions(-) diff --git a/sql/characters.sql b/sql/characters.sql index c5fd2a6bd..fc4c3e95a 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -30,7 +30,7 @@ CREATE TABLE `saved_variables` ( DROP TABLE IF EXISTS `character_db_version`; CREATE TABLE `character_db_version` ( - `required_2008_12_03_01_character_guild_member` bit(1) default NULL + `required_2008_12_15_01_character_arenas` bit(1) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Last applied sql update to DB'; -- diff --git a/sql/mangos.sql b/sql/mangos.sql index ab1d64f9b..081d18fbd 100644 --- a/sql/mangos.sql +++ b/sql/mangos.sql @@ -22,7 +22,7 @@ DROP TABLE IF EXISTS `db_version`; CREATE TABLE `db_version` ( `version` varchar(120) default NULL, - `required_2008_11_29_02_mangos_spell_elixir` bit(1) default NULL + `required_2008_12_15_01_mangos_arenas` bit(1) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes'; -- diff --git a/sql/updates/2008_12_15_01_character_arenas.sql b/sql/updates/2008_12_15_01_character_arenas.sql index 2976d343e..5fdf0870f 100644 --- a/sql/updates/2008_12_15_01_character_arenas.sql +++ b/sql/updates/2008_12_15_01_character_arenas.sql @@ -1,3 +1,5 @@ +ALTER TABLE character_db_version CHANGE COLUMN required_2008_12_03_01_character_guild_member required_2008_12_15_01_character_arenas bit; + CREATE TABLE `saved_variables` ( `NextArenaPointDistributionTime` bigint(40) UNSIGNED NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves'; diff --git a/sql/updates/2008_12_15_01_mangos_arenas.sql b/sql/updates/2008_12_15_01_mangos_arenas.sql index 589aacfb6..c8208b844 100644 --- a/sql/updates/2008_12_15_01_mangos_arenas.sql +++ b/sql/updates/2008_12_15_01_mangos_arenas.sql @@ -1,3 +1,5 @@ +ALTER TABLE db_version CHANGE COLUMN required_2008_11_29_02_mangos_spell_elixir required_2008_12_15_01_mangos_arenas bit; + DELETE FROM `command` WHERE `name` = "flusharenapoints"; INSERT INTO `command` (`name`, `security`, `help`) VALUES ('flusharenapoints','3','Syntax: .flusharenapoints\r\n\r\nUse it to distribute arena points based on arena team ratings, and start a new week.'); -- 2.11.4.GIT