From 08e4346ab2f840b777bffb494e8153e0144f1561 Mon Sep 17 00:00:00 2001
From: nihal <none@none>
Date: Sun, 24 Jan 2010 15:59:10 +0100
Subject: Some good old fashioned proper Trinity Standard sql renaming and
 formatting. Also added missing data to world.sql.

--HG--
branch : trunk
---
 sql/updates/7090_world_scriptname.sql               | 1 -
 sql/updates/7134_world_command.sql                  | 2 +-
 sql/updates/7147_world_creature_classlevelstats.sql | 1 -
 sql/updates/7147_world_creature_template.sql        | 1 -
 sql/updates/7167_world_spell_stack_masks.sql        | 7 +++++++
 sql/updates/7168_world_spell_stack_masks.sql        | 7 -------
 6 files changed, 8 insertions(+), 11 deletions(-)
 create mode 100644 sql/updates/7167_world_spell_stack_masks.sql
 delete mode 100644 sql/updates/7168_world_spell_stack_masks.sql

(limited to 'sql/updates')

diff --git a/sql/updates/7090_world_scriptname.sql b/sql/updates/7090_world_scriptname.sql
index a67bc5cbceb..7f6bf7cfa32 100644
--- a/sql/updates/7090_world_scriptname.sql
+++ b/sql/updates/7090_world_scriptname.sql
@@ -1,2 +1 @@
 UPDATE `item_template` SET `ScriptName`='item_petrov_cluster_bombs' WHERE `entry`=33098;
-
diff --git a/sql/updates/7134_world_command.sql b/sql/updates/7134_world_command.sql
index a0727046d48..528e8d776dd 100644
--- a/sql/updates/7134_world_command.sql
+++ b/sql/updates/7134_world_command.sql
@@ -7,4 +7,4 @@ VALUES
 ('titles current',2,'Syntax: .titles current #title\r\nSet title #title (id or shift-link) as current selected titl for selected player. If title not in known title list for player then it will be added to list.'),
 ('titles remove',2,'Syntax: .titles remove #title\r\nRemove title #title (id or shift-link) from known titles list for selected player.'),
 ('titles setmask',2,'Syntax: .titles setmask #mask\r\n\r\nAllows user to use all titles from #mask.\r\n\r\n #mask=0 disables the title-choose-field'),
-('lookup title',2,'Syntax: .lookup title $$namepart\r\n\r\nLooks up a title by $namepart, and returns all matches with their title ID\'s and index\'s.');
\ No newline at end of file
+('lookup title',2,'Syntax: .lookup title $$namepart\r\n\r\nLooks up a title by $namepart, and returns all matches with their title ID\'s and index\'s.');
diff --git a/sql/updates/7147_world_creature_classlevelstats.sql b/sql/updates/7147_world_creature_classlevelstats.sql
index 6b10bb9806c..dff9eb89316 100644
--- a/sql/updates/7147_world_creature_classlevelstats.sql
+++ b/sql/updates/7147_world_creature_classlevelstats.sql
@@ -1,4 +1,3 @@
 ALTER TABLE `creature_classlevelstats`
 DROP COLUMN `basedmg`,
 DROP COLUMN `baserangeddmg`;
-
diff --git a/sql/updates/7147_world_creature_template.sql b/sql/updates/7147_world_creature_template.sql
index 7202edab18a..9c92fa05388 100644
--- a/sql/updates/7147_world_creature_template.sql
+++ b/sql/updates/7147_world_creature_template.sql
@@ -7,4 +7,3 @@ ADD COLUMN `attackpower` int(10) unsigned NOT NULL DEFAULT '0' AFTER `dmgschool`
 ADD COLUMN `minrangedmg` float NOT NULL DEFAULT '0' AFTER `trainer_race`,
 ADD COLUMN `maxrangedmg` float NOT NULL DEFAULT '0' AFTER `minrangedmg`,
 ADD COLUMN `rangedattackpower` smallint(5) unsigned NOT NULL DEFAULT '0' AFTER `maxrangedmg`;
-
diff --git a/sql/updates/7167_world_spell_stack_masks.sql b/sql/updates/7167_world_spell_stack_masks.sql
new file mode 100644
index 00000000000..2e7d449593c
--- /dev/null
+++ b/sql/updates/7167_world_spell_stack_masks.sql
@@ -0,0 +1,7 @@
+DROP TABLE IF EXISTS `spell_stack_masks`;
+
+CREATE TABLE `spell_stack_masks` (
+  `id` int(32) unsigned NOT NULL default '0',
+  `mask` int(64) unsigned NOT NULL default '0',
+  PRIMARY KEY  (`id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
diff --git a/sql/updates/7168_world_spell_stack_masks.sql b/sql/updates/7168_world_spell_stack_masks.sql
deleted file mode 100644
index 2e7d449593c..00000000000
--- a/sql/updates/7168_world_spell_stack_masks.sql
+++ /dev/null
@@ -1,7 +0,0 @@
-DROP TABLE IF EXISTS `spell_stack_masks`;
-
-CREATE TABLE `spell_stack_masks` (
-  `id` int(32) unsigned NOT NULL default '0',
-  `mask` int(64) unsigned NOT NULL default '0',
-  PRIMARY KEY  (`id`)
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 
cgit v1.2.3