diff options
| author | runningnak3d@mangos.zipwow.ano <none@none> | 2008-12-15 10:42:35 +0000 |
|---|---|---|
| committer | runningnak3d@mangos.zipwow.ano <none@none> | 2008-12-15 10:42:35 +0000 |
| commit | 4b47c30641d31661c530e21dfd24a79b405736d2 (patch) | |
| tree | edbc6dbe32f693fe3ae7bd9bde505686db32fbcb /sql/updates/146_world.sql | |
| parent | 7ed8e2993f37006a4f455f995ef61b6d0f867656 (diff) | |
* Fix revent SQL commits
* Fix EOL issues on all SQL files
--HG--
branch : trunk
Diffstat (limited to 'sql/updates/146_world.sql')
| -rw-r--r-- | sql/updates/146_world.sql | 184 |
1 files changed, 92 insertions, 92 deletions
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 |
