From 4b47c30641d31661c530e21dfd24a79b405736d2 Mon Sep 17 00:00:00 2001 From: "runningnak3d@mangos.zipwow.ano" Date: Mon, 15 Dec 2008 10:42:35 +0000 Subject: * Fix revent SQL commits * Fix EOL issues on all SQL files --HG-- branch : trunk --- sql/updates/146_world.sql | 184 +++++++++++++++++++++++----------------------- 1 file changed, 92 insertions(+), 92 deletions(-) (limited to 'sql/updates/146_world.sql') diff --git a/sql/updates/146_world.sql b/sql/updates/146_world.sql index b37bcb2583d..31999cd97e4 100644 --- a/sql/updates/146_world.sql +++ b/sql/updates/146_world.sql @@ -1,93 +1,93 @@ -DROP TABLE IF EXISTS `spell_linked_spell`; -CREATE TABLE `spell_linked_spell` ( - `spell_trigger` int(10) NOT NULL, - `spell_effect` int(10) NOT NULL default '0', - `type` smallint(3) unsigned NOT NULL default '0', - `comment` text NOT NULL, - PRIMARY KEY (`spell_trigger`) -) ENGINE=MyISAM DEFAULT CHARSET=utf8; - -INSERT INTO spell_linked_spell - (`spell_trigger`, `spell_effect`, `type`, `comment`) -VALUES - (44008, 45265, 1, 'Static Disruption Visual'); - -INSERT INTO spell_linked_spell - (`spell_trigger`, `spell_effect`, `type`, `comment`) -VALUES - (-30410, 44032, 0, 'Manticron Cube Mind Exhaustion'); - -INSERT INTO spell_linked_spell - (`spell_trigger`, `spell_effect`, `type`, `comment`) -VALUES - (45661, 45665, 1, 'Encapsulate\r\n'); - -INSERT INTO spell_linked_spell - (`spell_trigger`, `spell_effect`, `type`, `comment`) -VALUES - (40604, 40616, 1, 'Fel Rage Aura'); - -INSERT INTO spell_linked_spell - (`spell_trigger`, `spell_effect`, `type`, `comment`) -VALUES - (40616, 41625, 1, 'Fel Rage Aura'); - -INSERT INTO spell_linked_spell - (`spell_trigger`, `spell_effect`, `type`, `comment`) -VALUES - (41292, 42017, 1, 'Aura of Suffering'); - -INSERT INTO spell_linked_spell - (`spell_trigger`, `spell_effect`, `type`, `comment`) -VALUES - (-41292, -42017, 0, 'Aura of Suffering'); - -INSERT INTO spell_linked_spell - (`spell_trigger`, `spell_effect`, `type`, `comment`) -VALUES - (45347, -45348, 1, 'Remove Flame Touched'); - -INSERT INTO spell_linked_spell - (`spell_trigger`, `spell_effect`, `type`, `comment`) -VALUES - (45348, -45347, 1, 'Remove Dark Touched'); - -INSERT INTO spell_linked_spell - (`spell_trigger`, `spell_effect`, `type`, `comment`) -VALUES - (45248, 45347, 1, 'Apply Dark Touched'); - -INSERT INTO spell_linked_spell - (`spell_trigger`, `spell_effect`, `type`, `comment`) -VALUES - (45329, 45347, 1, 'Apply Dark Touched'); - -INSERT INTO spell_linked_spell - (`spell_trigger`, `spell_effect`, `type`, `comment`) -VALUES - (45256, 45347, 1, 'Apply Dark Touched'); - -INSERT INTO spell_linked_spell - (`spell_trigger`, `spell_effect`, `type`, `comment`) -VALUES - (45270, 45347, 1, 'Apply Dark Touched'); - -INSERT INTO spell_linked_spell - (`spell_trigger`, `spell_effect`, `type`, `comment`) -VALUES - (45342, 45348, 1, 'Apply Flame Touched'); - -INSERT INTO spell_linked_spell - (`spell_trigger`, `spell_effect`, `type`, `comment`) -VALUES - (46771, 45348, 1, 'Apply Flame Touched'); - -INSERT INTO spell_linked_spell - (`spell_trigger`, `spell_effect`, `type`, `comment`) -VALUES - (45271, 45347, 1, 'Apply Dark Touched'); - -INSERT INTO spell_linked_spell - (`spell_trigger`, `spell_effect`, `type`, `comment`) -VALUES +DROP TABLE IF EXISTS `spell_linked_spell`; +CREATE TABLE `spell_linked_spell` ( + `spell_trigger` int(10) NOT NULL, + `spell_effect` int(10) NOT NULL default '0', + `type` smallint(3) unsigned NOT NULL default '0', + `comment` text NOT NULL, + PRIMARY KEY (`spell_trigger`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +INSERT INTO spell_linked_spell + (`spell_trigger`, `spell_effect`, `type`, `comment`) +VALUES + (44008, 45265, 1, 'Static Disruption Visual'); + +INSERT INTO spell_linked_spell + (`spell_trigger`, `spell_effect`, `type`, `comment`) +VALUES + (-30410, 44032, 0, 'Manticron Cube Mind Exhaustion'); + +INSERT INTO spell_linked_spell + (`spell_trigger`, `spell_effect`, `type`, `comment`) +VALUES + (45661, 45665, 1, 'Encapsulate\r\n'); + +INSERT INTO spell_linked_spell + (`spell_trigger`, `spell_effect`, `type`, `comment`) +VALUES + (40604, 40616, 1, 'Fel Rage Aura'); + +INSERT INTO spell_linked_spell + (`spell_trigger`, `spell_effect`, `type`, `comment`) +VALUES + (40616, 41625, 1, 'Fel Rage Aura'); + +INSERT INTO spell_linked_spell + (`spell_trigger`, `spell_effect`, `type`, `comment`) +VALUES + (41292, 42017, 1, 'Aura of Suffering'); + +INSERT INTO spell_linked_spell + (`spell_trigger`, `spell_effect`, `type`, `comment`) +VALUES + (-41292, -42017, 0, 'Aura of Suffering'); + +INSERT INTO spell_linked_spell + (`spell_trigger`, `spell_effect`, `type`, `comment`) +VALUES + (45347, -45348, 1, 'Remove Flame Touched'); + +INSERT INTO spell_linked_spell + (`spell_trigger`, `spell_effect`, `type`, `comment`) +VALUES + (45348, -45347, 1, 'Remove Dark Touched'); + +INSERT INTO spell_linked_spell + (`spell_trigger`, `spell_effect`, `type`, `comment`) +VALUES + (45248, 45347, 1, 'Apply Dark Touched'); + +INSERT INTO spell_linked_spell + (`spell_trigger`, `spell_effect`, `type`, `comment`) +VALUES + (45329, 45347, 1, 'Apply Dark Touched'); + +INSERT INTO spell_linked_spell + (`spell_trigger`, `spell_effect`, `type`, `comment`) +VALUES + (45256, 45347, 1, 'Apply Dark Touched'); + +INSERT INTO spell_linked_spell + (`spell_trigger`, `spell_effect`, `type`, `comment`) +VALUES + (45270, 45347, 1, 'Apply Dark Touched'); + +INSERT INTO spell_linked_spell + (`spell_trigger`, `spell_effect`, `type`, `comment`) +VALUES + (45342, 45348, 1, 'Apply Flame Touched'); + +INSERT INTO spell_linked_spell + (`spell_trigger`, `spell_effect`, `type`, `comment`) +VALUES + (46771, 45348, 1, 'Apply Flame Touched'); + +INSERT INTO spell_linked_spell + (`spell_trigger`, `spell_effect`, `type`, `comment`) +VALUES + (45271, 45347, 1, 'Apply Dark Touched'); + +INSERT INTO spell_linked_spell + (`spell_trigger`, `spell_effect`, `type`, `comment`) +VALUES (45246, 45348, 1, 'Apply Flame Touched'); \ No newline at end of file -- cgit v1.2.3