From d96636edd3a9f1b96ea2a0b229f5354bd1fdcfcf Mon Sep 17 00:00:00 2001 From: VladimirMangos Date: Sat, 12 Sep 2009 04:15:26 +0400 Subject: [PATCH] [8491] Add absent empty line to end of sql updates. Thanks to mns for pointing to problem. Signed-off-by: VladimirMangos --- sql/updates/8030_01_characters_character_spell.sql | 2 +- sql/updates/8030_03_mangos_npc_trainer.sql | 2 +- sql/updates/8050_01_mangos_spell_proc_event.sql | 2 +- sql/updates/8050_02_mangos_spell_bonus_data.sql | 2 +- sql/updates/8065_01_mangos_spell_proc_event.sql | 2 +- sql/updates/8112_01_mangos_spell_proc_event.sql | 2 +- sql/updates/8140_01_mangos_spell_proc_event.sql | 2 +- sql/updates/8213_01_mangos_spell_bonus_data.sql | 2 +- sql/updates/8237_01_mangos_creature_template.sql | 2 +- sql/updates/8250_01_mangos_spell_threat.sql | 2 +- sql/updates/8402_01_characters_guild_eventlog.sql | 2 +- sql/updates/8402_02_characters_guild_bank_eventlog.sql | 2 +- sql/updates/8409_01_characters_guild.sql | 2 +- sql/updates/8433_01_characters_character_account_data.sql | 2 +- sql/updates/8487_02_mangos_spell_proc_event.sql | 2 +- src/shared/revision_nr.h | 2 +- 16 files changed, 16 insertions(+), 16 deletions(-) diff --git a/sql/updates/8030_01_characters_character_spell.sql b/sql/updates/8030_01_characters_character_spell.sql index 9ff2ede71..e9b210a59 100644 --- a/sql/updates/8030_01_characters_character_spell.sql +++ b/sql/updates/8030_01_characters_character_spell.sql @@ -4,4 +4,4 @@ UPDATE IGNORE character_spell SET spell = 64901 WHERE spell = 64904; -DELETE FROM character_spell WHERE spell = 64904; \ No newline at end of file +DELETE FROM character_spell WHERE spell = 64904; diff --git a/sql/updates/8030_03_mangos_npc_trainer.sql b/sql/updates/8030_03_mangos_npc_trainer.sql index bf480c28f..85d70a1c0 100644 --- a/sql/updates/8030_03_mangos_npc_trainer.sql +++ b/sql/updates/8030_03_mangos_npc_trainer.sql @@ -1,3 +1,3 @@ ALTER TABLE db_version CHANGE COLUMN required_8021_01_mangos_spell_proc_event required_8030_03_mangos_npc_trainer bit; -DELETE FROM npc_trainer WHERE spell = 64904; \ No newline at end of file +DELETE FROM npc_trainer WHERE spell = 64904; diff --git a/sql/updates/8050_01_mangos_spell_proc_event.sql b/sql/updates/8050_01_mangos_spell_proc_event.sql index b36a9670e..f43b314b0 100644 --- a/sql/updates/8050_01_mangos_spell_proc_event.sql +++ b/sql/updates/8050_01_mangos_spell_proc_event.sql @@ -1,4 +1,4 @@ ALTER TABLE db_version CHANGE COLUMN required_8030_03_mangos_npc_trainer required_8050_01_mangos_spell_proc_event bit; DELETE FROM spell_proc_event WHERE entry = 63108; -INSERT INTO spell_proc_event VALUES (63108, 0x00, 5, 0x00000002, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0); \ No newline at end of file +INSERT INTO spell_proc_event VALUES (63108, 0x00, 5, 0x00000002, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0); diff --git a/sql/updates/8050_02_mangos_spell_bonus_data.sql b/sql/updates/8050_02_mangos_spell_bonus_data.sql index b3f1fdf87..2af1261d7 100644 --- a/sql/updates/8050_02_mangos_spell_bonus_data.sql +++ b/sql/updates/8050_02_mangos_spell_bonus_data.sql @@ -1,4 +1,4 @@ ALTER TABLE db_version CHANGE COLUMN required_8050_01_mangos_spell_proc_event required_8050_02_mangos_spell_bonus_data bit; DELETE FROM spell_bonus_data WHERE entry = 63106; -INSERT INTO spell_bonus_data VALUES (63106, 0, 0, 0, 'Warlock - Siphon Life Triggered'); \ No newline at end of file +INSERT INTO spell_bonus_data VALUES (63106, 0, 0, 0, 'Warlock - Siphon Life Triggered'); diff --git a/sql/updates/8065_01_mangos_spell_proc_event.sql b/sql/updates/8065_01_mangos_spell_proc_event.sql index aa44e757d..a4dd7df4f 100644 --- a/sql/updates/8065_01_mangos_spell_proc_event.sql +++ b/sql/updates/8065_01_mangos_spell_proc_event.sql @@ -1,3 +1,3 @@ ALTER TABLE db_version CHANGE COLUMN required_8064_01_mangos_spell_chain required_8065_01_mangos_spell_proc_event bit; -DELETE FROM spell_proc_event WHERE entry IN (47535, 47536, 47537, 58435); \ No newline at end of file +DELETE FROM spell_proc_event WHERE entry IN (47535, 47536, 47537, 58435); diff --git a/sql/updates/8112_01_mangos_spell_proc_event.sql b/sql/updates/8112_01_mangos_spell_proc_event.sql index b882e66ee..017059c24 100644 --- a/sql/updates/8112_01_mangos_spell_proc_event.sql +++ b/sql/updates/8112_01_mangos_spell_proc_event.sql @@ -3,4 +3,4 @@ ALTER TABLE db_version CHANGE COLUMN required_8098_02_mangos_playercreateinfo_ac DELETE FROM spell_proc_event WHERE entry IN (63156, 63158); INSERT INTO spell_proc_event VALUES (63156, 0x00000000, 0, 0x00000001, 0x00000040, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0), -(63158, 0x00000000, 0, 0x00000001, 0x00000040, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0); \ No newline at end of file +(63158, 0x00000000, 0, 0x00000001, 0x00000040, 0x00000000, 0x00000000, 0x00000000, 0.000000, 0.000000, 0); diff --git a/sql/updates/8140_01_mangos_spell_proc_event.sql b/sql/updates/8140_01_mangos_spell_proc_event.sql index 84a6ef378..5d9730f0a 100644 --- a/sql/updates/8140_01_mangos_spell_proc_event.sql +++ b/sql/updates/8140_01_mangos_spell_proc_event.sql @@ -4,4 +4,4 @@ DELETE FROM spell_proc_event WHERE entry IN (31876, 31877, 31878); INSERT INTO spell_proc_event VALUES (31876, 0x00000000, 10, 0x00800000, 0x00000000, 0x00000008, 0x00004110, 0x00000000, 0.000000, 0.000000, 0), (31877, 0x00000000, 10, 0x00800000, 0x00000000, 0x00000008, 0x00004110, 0x00000000, 0.000000, 0.000000, 0), -(31878, 0x00000000, 10, 0x00800000, 0x00000000, 0x00000008, 0x00004110, 0x00000000, 0.000000, 0.000000, 0); \ No newline at end of file +(31878, 0x00000000, 10, 0x00800000, 0x00000000, 0x00000008, 0x00004110, 0x00000000, 0.000000, 0.000000, 0); diff --git a/sql/updates/8213_01_mangos_spell_bonus_data.sql b/sql/updates/8213_01_mangos_spell_bonus_data.sql index 9ccc350ba..4a2c9647f 100644 --- a/sql/updates/8213_01_mangos_spell_bonus_data.sql +++ b/sql/updates/8213_01_mangos_spell_bonus_data.sql @@ -1,4 +1,4 @@ ALTER TABLE db_version CHANGE COLUMN required_8212_01_mangos_spell_proc_event required_8213_01_mangos_spell_bonus_data bit; DELETE FROM `spell_bonus_data` where entry='17962'; -INSERT INTO `spell_bonus_data` (`entry`) VALUES ('17962'); \ No newline at end of file +INSERT INTO `spell_bonus_data` (`entry`) VALUES ('17962'); diff --git a/sql/updates/8237_01_mangos_creature_template.sql b/sql/updates/8237_01_mangos_creature_template.sql index 89b433cc2..df425ea41 100644 --- a/sql/updates/8237_01_mangos_creature_template.sql +++ b/sql/updates/8237_01_mangos_creature_template.sql @@ -1,4 +1,4 @@ ALTER TABLE db_version CHANGE COLUMN required_8227_01_mangos_spell_proc_event required_8237_01_mangos_creature_template bit; UPDATE creature_template - SET mindmg = ROUND(mindmg + attackpower), maxdmg=ROUND(maxdmg+attackpower); \ No newline at end of file + SET mindmg = ROUND(mindmg + attackpower), maxdmg=ROUND(maxdmg+attackpower); diff --git a/sql/updates/8250_01_mangos_spell_threat.sql b/sql/updates/8250_01_mangos_spell_threat.sql index 6bc81761c..b9aee8129 100644 --- a/sql/updates/8250_01_mangos_spell_threat.sql +++ b/sql/updates/8250_01_mangos_spell_threat.sql @@ -1,3 +1,3 @@ ALTER TABLE db_version CHANGE COLUMN required_8249_02_mangos_spell_chain required_8250_01_mangos_spell_threat bit; -DELETE FROM `spell_threat` WHERE `entry` IN (778,9749,9907,14274,15629,15630,15631,15632,17390,17391,17392,26993,27011); \ No newline at end of file +DELETE FROM `spell_threat` WHERE `entry` IN (778,9749,9907,14274,15629,15630,15631,15632,17390,17391,17392,26993,27011); diff --git a/sql/updates/8402_01_characters_guild_eventlog.sql b/sql/updates/8402_01_characters_guild_eventlog.sql index 32f5b09a9..107639d39 100644 --- a/sql/updates/8402_01_characters_guild_eventlog.sql +++ b/sql/updates/8402_01_characters_guild_eventlog.sql @@ -17,4 +17,4 @@ CREATE TABLE `guild_eventlog` ( -- The reason i decided for such dramatic change is that old guild_eventlog table didn't have Primary key and -- used LogGuids from 0 to infinity --- New system uses LogGuids from 0 to number defined in config. \ No newline at end of file +-- New system uses LogGuids from 0 to number defined in config. diff --git a/sql/updates/8402_02_characters_guild_bank_eventlog.sql b/sql/updates/8402_02_characters_guild_bank_eventlog.sql index e2c271373..0cee36c4c 100644 --- a/sql/updates/8402_02_characters_guild_bank_eventlog.sql +++ b/sql/updates/8402_02_characters_guild_bank_eventlog.sql @@ -20,4 +20,4 @@ CREATE TABLE `guild_bank_eventlog` ( -- The reason i decided for such dramatic change is that old guild_bank_eventlog table used `TabId` = 0 for Money events and -- used `LogGuid` from 0 to infinity --- New system uses `LogGuid` from 0 to number defined in config. \ No newline at end of file +-- New system uses `LogGuid` from 0 to number defined in config. diff --git a/sql/updates/8409_01_characters_guild.sql b/sql/updates/8409_01_characters_guild.sql index f08f861bb..7d879a811 100644 --- a/sql/updates/8409_01_characters_guild.sql +++ b/sql/updates/8409_01_characters_guild.sql @@ -14,4 +14,4 @@ ALTER TABLE guild ADD COLUMN createdate bigint(20) NOT NULL default '0' AFTER mo -- copy data to new column UPDATE guild set createdate = created_temp; -- remove old column -ALTER TABLE guild DROP COLUMN created_temp; \ No newline at end of file +ALTER TABLE guild DROP COLUMN created_temp; diff --git a/sql/updates/8433_01_characters_character_account_data.sql b/sql/updates/8433_01_characters_character_account_data.sql index 88402b294..5f0aacd0d 100644 --- a/sql/updates/8433_01_characters_character_account_data.sql +++ b/sql/updates/8433_01_characters_character_account_data.sql @@ -13,4 +13,4 @@ INSERT INTO character_account_data SELECT c.guid as guid, a.type as type, a.time as time, a.data as data FROM characters c LEFT JOIN account_data a ON c.account = a.account WHERE a.type IN (1, 3, 5, 6, 7); -DELETE FROM account_data WHERE type IN (1, 3, 5, 6, 7); \ No newline at end of file +DELETE FROM account_data WHERE type IN (1, 3, 5, 6, 7); diff --git a/sql/updates/8487_02_mangos_spell_proc_event.sql b/sql/updates/8487_02_mangos_spell_proc_event.sql index 2ca276dd8..bbe4f9108 100644 --- a/sql/updates/8487_02_mangos_spell_proc_event.sql +++ b/sql/updates/8487_02_mangos_spell_proc_event.sql @@ -1,3 +1,3 @@ ALTER TABLE db_version CHANGE COLUMN required_8487_01_mangos_spell_bonus_data required_8487_02_mangos_spell_proc_event bit; -DELETE FROM `spell_proc_event` WHERE `entry` IN (31801, 53736); \ No newline at end of file +DELETE FROM `spell_proc_event` WHERE `entry` IN (31801, 53736); diff --git a/src/shared/revision_nr.h b/src/shared/revision_nr.h index 2f8d69385..d09f5d985 100644 --- a/src/shared/revision_nr.h +++ b/src/shared/revision_nr.h @@ -1,4 +1,4 @@ #ifndef __REVISION_NR_H__ #define __REVISION_NR_H__ - #define REVISION_NR "8490" + #define REVISION_NR "8491" #endif // __REVISION_NR_H__ -- 2.11.4.GIT