From c1df981f0ccc3b6453dce7bf5cfe8ddd274e4f0f Mon Sep 17 00:00:00 2001 From: Shauren Date: Sun, 26 Jun 2011 14:09:32 +0200 Subject: SQL: Fixed line endings --- sql/updates/world/2011_06_26_04_world_spell_proc.sql | 20 +++++++++++++++++++- sql/updates/world/2011_06_26_05_world_command.sql | 4 +++- 2 files changed, 22 insertions(+), 2 deletions(-) (limited to 'sql/updates') diff --git a/sql/updates/world/2011_06_26_04_world_spell_proc.sql b/sql/updates/world/2011_06_26_04_world_spell_proc.sql index 5a5ea9973e5..063a3edd3bf 100644 --- a/sql/updates/world/2011_06_26_04_world_spell_proc.sql +++ b/sql/updates/world/2011_06_26_04_world_spell_proc.sql @@ -1 +1,19 @@ -DROP TABLE IF EXISTS `spell_proc`; CREATE TABLE `spell_proc` ( `spellId` mediumint(8) NOT NULL DEFAULT '0', `schoolMask` tinyint(4) NOT NULL DEFAULT '0', `spellFamilyName` smallint(5) unsigned NOT NULL DEFAULT '0', `spellFamilyMask0` int(10) unsigned NOT NULL DEFAULT '0', `spellFamilyMask1` int(10) unsigned NOT NULL DEFAULT '0', `spellFamilyMask2` int(10) unsigned NOT NULL DEFAULT '0', `typeMask` int(10) unsigned NOT NULL DEFAULT '0', `spellTypeMask` int(10) unsigned NOT NULL DEFAULT '0', `spellPhaseMask` int(10) NOT NULL DEFAULT '0', `hitMask` int(10) NOT NULL DEFAULT '0', `attributesMask` int(10) unsigned NOT NULL DEFAULT '0', `ratePerMinute` float NOT NULL DEFAULT '0', `chance` float NOT NULL DEFAULT '0', `cooldown` float unsigned NOT NULL DEFAULT '0', `charges` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`spellId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; \ No newline at end of file +DROP TABLE IF EXISTS `spell_proc`; +CREATE TABLE `spell_proc` ( + `spellId` mediumint(8) NOT NULL DEFAULT '0', + `schoolMask` tinyint(4) NOT NULL DEFAULT '0', + `spellFamilyName` smallint(5) unsigned NOT NULL DEFAULT '0', + `spellFamilyMask0` int(10) unsigned NOT NULL DEFAULT '0', + `spellFamilyMask1` int(10) unsigned NOT NULL DEFAULT '0', + `spellFamilyMask2` int(10) unsigned NOT NULL DEFAULT '0', + `typeMask` int(10) unsigned NOT NULL DEFAULT '0', + `spellTypeMask` int(10) unsigned NOT NULL DEFAULT '0', + `spellPhaseMask` int(10) NOT NULL DEFAULT '0', + `hitMask` int(10) NOT NULL DEFAULT '0', + `attributesMask` int(10) unsigned NOT NULL DEFAULT '0', + `ratePerMinute` float NOT NULL DEFAULT '0', + `chance` float NOT NULL DEFAULT '0', + `cooldown` float unsigned NOT NULL DEFAULT '0', + `charges` int(10) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`spellId`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; diff --git a/sql/updates/world/2011_06_26_05_world_command.sql b/sql/updates/world/2011_06_26_05_world_command.sql index 81259662612..b18bbe61954 100644 --- a/sql/updates/world/2011_06_26_05_world_command.sql +++ b/sql/updates/world/2011_06_26_05_world_command.sql @@ -1 +1,3 @@ -DELETE FROM `command` WHERE `name` = 'reload spell_proc'; INSERT INTO `command` VALUES ('reload spell_proc',3,'Syntax: .reload spell_proc\nReload spell_proc table.'); \ No newline at end of file +DELETE FROM `command` WHERE `name` = 'reload spell_proc'; +INSERT INTO `command` VALUES +('reload spell_proc',3,'Syntax: .reload spell_proc\nReload spell_proc table.'); -- cgit v1.2.3