From d2e1f5a2592dbfeecd188c5edc78e38617257f05 Mon Sep 17 00:00:00 2001 From: QAston Date: Sun, 26 Jun 2011 13:58:34 +0200 Subject: Misc: Rename update sqls to follow the standards. --- sql/updates/world/2011_06_26_01_world_spell_proc.sql | 1 - sql/updates/world/2011_06_26_02_world_command.sql | 1 - sql/updates/world/2011_06_26_04_world_spell_proc.sql | 1 + sql/updates/world/2011_06_26_05_world_command.sql | 1 + 4 files changed, 2 insertions(+), 2 deletions(-) delete mode 100644 sql/updates/world/2011_06_26_01_world_spell_proc.sql delete mode 100644 sql/updates/world/2011_06_26_02_world_command.sql create mode 100644 sql/updates/world/2011_06_26_04_world_spell_proc.sql create mode 100644 sql/updates/world/2011_06_26_05_world_command.sql (limited to 'sql') diff --git a/sql/updates/world/2011_06_26_01_world_spell_proc.sql b/sql/updates/world/2011_06_26_01_world_spell_proc.sql deleted file mode 100644 index 5a5ea9973e5..00000000000 --- a/sql/updates/world/2011_06_26_01_world_spell_proc.sql +++ /dev/null @@ -1 +0,0 @@ -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 diff --git a/sql/updates/world/2011_06_26_02_world_command.sql b/sql/updates/world/2011_06_26_02_world_command.sql deleted file mode 100644 index 81259662612..00000000000 --- a/sql/updates/world/2011_06_26_02_world_command.sql +++ /dev/null @@ -1 +0,0 @@ -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 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 new file mode 100644 index 00000000000..5a5ea9973e5 --- /dev/null +++ b/sql/updates/world/2011_06_26_04_world_spell_proc.sql @@ -0,0 +1 @@ +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 diff --git a/sql/updates/world/2011_06_26_05_world_command.sql b/sql/updates/world/2011_06_26_05_world_command.sql new file mode 100644 index 00000000000..81259662612 --- /dev/null +++ b/sql/updates/world/2011_06_26_05_world_command.sql @@ -0,0 +1 @@ +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 -- cgit v1.2.3