From 1f55614e7038cde7bdb7b3fdf898a0abae42623e Mon Sep 17 00:00:00 2001
From: megamage <none@none>
Date: Wed, 15 Apr 2009 17:10:43 -0500
Subject: *Remove duplicated TC1 sql.

--HG--
branch : trunk
---
 sql/updates/1358_characters.sql                        |  1 -
 sql/updates/1358_world.sql                             |  3 ---
 sql/updates/1362_world.sql                             | 10 ----------
 sql/updates/1366_characters.sql                        |  4 ----
 sql/updates/1366_world.sql                             |  1 -
 sql/updates/TC1_1362_world_creature_linked_respawn.sql | 10 ++++++++++
 6 files changed, 10 insertions(+), 19 deletions(-)
 delete mode 100644 sql/updates/1358_characters.sql
 delete mode 100644 sql/updates/1358_world.sql
 delete mode 100644 sql/updates/1362_world.sql
 delete mode 100644 sql/updates/1366_characters.sql
 delete mode 100644 sql/updates/1366_world.sql
 create mode 100644 sql/updates/TC1_1362_world_creature_linked_respawn.sql

(limited to 'sql/updates')

diff --git a/sql/updates/1358_characters.sql b/sql/updates/1358_characters.sql
deleted file mode 100644
index 688e151b430..00000000000
--- a/sql/updates/1358_characters.sql
+++ /dev/null
@@ -1 +0,0 @@
-ALTER TABLE `gm_tickets` ADD COLUMN `createtime` int(10) NOT NULL after `message`;
diff --git a/sql/updates/1358_world.sql b/sql/updates/1358_world.sql
deleted file mode 100644
index ead79e05b61..00000000000
--- a/sql/updates/1358_world.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-DELETE FROM `trinity_string` WHERE `entry`=2025;
-INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES
-('2025','|cff00ff00Created|r:|cff00ccff %s ago|r ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
diff --git a/sql/updates/1362_world.sql b/sql/updates/1362_world.sql
deleted file mode 100644
index a6d786871d6..00000000000
--- a/sql/updates/1362_world.sql
+++ /dev/null
@@ -1,10 +0,0 @@
-DROP TABLE IF EXISTS `creature_linked_respawn`;
-CREATE TABLE `creature_linked_respawn` (
-  `guid` int(10) unsigned NOT NULL COMMENT 'dependent creature',
-  `linkedGuid` int(10) unsigned NOT NULL COMMENT 'master creature',
-  PRIMARY KEY (`guid`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature Respawn Link System';
-
-DELETE FROM `trinity_string` WHERE `entry` = '750';
-INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES
-('750', 'linkGUID: %u, Entry: %u (%s)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
diff --git a/sql/updates/1366_characters.sql b/sql/updates/1366_characters.sql
deleted file mode 100644
index 8a8d61c2b91..00000000000
--- a/sql/updates/1366_characters.sql
+++ /dev/null
@@ -1,4 +0,0 @@
-ALTER TABLE `gm_tickets` ADD COLUMN `map` INT NOT NULL DEFAULT '0' AFTER `createtime`;
-ALTER TABLE `gm_tickets` ADD COLUMN `posX` FLOAT NOT NULL DEFAULT '0' AFTER `map`;
-ALTER TABLE `gm_tickets` ADD COLUMN `posY` FLOAT NOT NULL DEFAULT '0' AFTER `posX`;
-ALTER TABLE `gm_tickets` ADD COLUMN `posZ` FLOAT NOT NULL DEFAULT '0' AFTER `posY`;
diff --git a/sql/updates/1366_world.sql b/sql/updates/1366_world.sql
deleted file mode 100644
index a22254a9d2a..00000000000
--- a/sql/updates/1366_world.sql
+++ /dev/null
@@ -1 +0,0 @@
-insert into `command` (`name`, `security`, `help`) values('go ticket','1','Syntax: .go ticket #ticketid\r\nTeleports the user to the location where $ticketid was created.');
diff --git a/sql/updates/TC1_1362_world_creature_linked_respawn.sql b/sql/updates/TC1_1362_world_creature_linked_respawn.sql
new file mode 100644
index 00000000000..a6d786871d6
--- /dev/null
+++ b/sql/updates/TC1_1362_world_creature_linked_respawn.sql
@@ -0,0 +1,10 @@
+DROP TABLE IF EXISTS `creature_linked_respawn`;
+CREATE TABLE `creature_linked_respawn` (
+  `guid` int(10) unsigned NOT NULL COMMENT 'dependent creature',
+  `linkedGuid` int(10) unsigned NOT NULL COMMENT 'master creature',
+  PRIMARY KEY (`guid`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature Respawn Link System';
+
+DELETE FROM `trinity_string` WHERE `entry` = '750';
+INSERT INTO `trinity_string` (`entry`, `content_default`, `content_loc1`, `content_loc2`, `content_loc3`, `content_loc4`, `content_loc5`, `content_loc6`, `content_loc7`, `content_loc8`) VALUES
+('750', 'linkGUID: %u, Entry: %u (%s)', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
-- 
cgit v1.2.3