From adf25d2db6a65772d778fb7b8e52be2a709f229f Mon Sep 17 00:00:00 2001
From: Drahy <none@none>
Date: Fri, 27 Mar 2009 17:35:41 +0100
Subject: * Used trinity sql coding style * Remember to use
 2227_mangos_7546_02_realmd_uptime to your realm database * Be careful
 2227_mangos_7544_01_world_uptime will wipe all your data in uptime table *
 Added 2254_world for correction in command table * Fixed linux compile

--HG--
branch : trunk
---
 sql/updates/2227_mangos_7544_01_world_uptime.sql  |  3 +++
 sql/updates/2227_mangos_7546_02_realmd_uptime.sql | 15 +++++++++++++++
 sql/updates/2254_world.sql                        | 13 +++++++++++++
 sql/updates/7544_01_mangos_uptime.sql             |  3 ---
 sql/updates/7546_02_realmd_uptime.sql             | 16 ----------------
 5 files changed, 31 insertions(+), 19 deletions(-)
 create mode 100644 sql/updates/2227_mangos_7544_01_world_uptime.sql
 create mode 100644 sql/updates/2227_mangos_7546_02_realmd_uptime.sql
 create mode 100644 sql/updates/2254_world.sql
 delete mode 100644 sql/updates/7544_01_mangos_uptime.sql
 delete mode 100644 sql/updates/7546_02_realmd_uptime.sql

(limited to 'sql')

diff --git a/sql/updates/2227_mangos_7544_01_world_uptime.sql b/sql/updates/2227_mangos_7544_01_world_uptime.sql
new file mode 100644
index 00000000000..0889d78c1a0
--- /dev/null
+++ b/sql/updates/2227_mangos_7544_01_world_uptime.sql
@@ -0,0 +1,3 @@
+/*ALTER TABLE db_version CHANGE COLUMN required_7536_01_mangos_spell_chain required_7544_01_mangos_uptime bit;*/
+
+DROP TABLE IF EXISTS `uptime`;
\ No newline at end of file
diff --git a/sql/updates/2227_mangos_7546_02_realmd_uptime.sql b/sql/updates/2227_mangos_7546_02_realmd_uptime.sql
new file mode 100644
index 00000000000..6ba9b17deaf
--- /dev/null
+++ b/sql/updates/2227_mangos_7546_02_realmd_uptime.sql
@@ -0,0 +1,15 @@
+/*ALTER TABLE realmd_db_version CHANGE COLUMN required_6976_01_realmd_realmd_db_version required_7546_02_realmd_uptime bit;*/
+
+--
+-- Table structure for table `uptime`
+--
+
+DROP TABLE IF EXISTS `uptime`;
+CREATE TABLE `uptime` (
+  `realmid` int(11) unsigned NOT NULL,
+  `starttime` bigint(20) unsigned NOT NULL default '0',
+  `startstring` varchar(64) NOT NULL default '',
+  `uptime` bigint(20) unsigned NOT NULL default '0',
+  `maxplayers` smallint(5) unsigned NOT NULL default '0',
+  PRIMARY KEY  (`realmid`,`starttime`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Uptime system';
\ No newline at end of file
diff --git a/sql/updates/2254_world.sql b/sql/updates/2254_world.sql
new file mode 100644
index 00000000000..0741985ebfe
--- /dev/null
+++ b/sql/updates/2254_world.sql
@@ -0,0 +1,13 @@
+DELETE FROM `command` WHERE `name` IN ('server difftime', 'addmove', 'Mod32Value', 'allowmove', 'reload tickets', 'npc tempadd', 'gobject tempadd', 'gobject addtemp', 'npc addtemp');
+INSERT INTO `command` VALUES
+('gobject tempadd','2','Adds a temporary gameobject that is not saved to DB.'),
+('npc tempadd','2','Adds temporary NPC, not saved to database.');
+UPDATE `command` SET `name`="ahbotoption" WHERE `name`="ahbotoptions";
+DELETE FROM `command` WHERE `name` LIKE "path%";
+DELETE FROM `command` WHERE `name` LIKE "wp%";
+INSERT INTO `command` VALUES 
+('wp load',2,'Syntax: .wp load $pathid\nLoad pathid number for selected creature. Creature must have no waypoint data.'),
+('wp event',2,'Syntax: .wp event $subcommand\nType .path event to see the list of possible subcommands or .help path event $subcommand to see info on subcommands.'),
+('wp unload',2,'Syntax: .wp unload\nUnload path for selected creature.'),
+('wp show',2,'Syntax: .wp show $option\nOptions:\non $pathid (or selected creature with loaded path) - Show path\noff - Hide path\ninfo $slected_waypoint - Show info for selected waypoint.'),
+('wp mod',2,'Syntax: .wp mod\nType .path mod to see the list of possible subcommands or .help path mod $subcommand to see info on subcommands.'),
\ No newline at end of file
diff --git a/sql/updates/7544_01_mangos_uptime.sql b/sql/updates/7544_01_mangos_uptime.sql
deleted file mode 100644
index 223f3f63069..00000000000
--- a/sql/updates/7544_01_mangos_uptime.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-ALTER TABLE db_version CHANGE COLUMN required_7536_01_mangos_spell_chain required_7544_01_mangos_uptime bit;
-
-DROP TABLE IF EXISTS `uptime`;
\ No newline at end of file
diff --git a/sql/updates/7546_02_realmd_uptime.sql b/sql/updates/7546_02_realmd_uptime.sql
deleted file mode 100644
index a53b0f95ff5..00000000000
--- a/sql/updates/7546_02_realmd_uptime.sql
+++ /dev/null
@@ -1,16 +0,0 @@
-ALTER TABLE realmd_db_version CHANGE COLUMN required_6976_01_realmd_realmd_db_version required_7546_02_realmd_uptime bit;
-
-
---
--- Table structure for table `uptime`
---
-
-DROP TABLE IF EXISTS `uptime`;
-CREATE TABLE `uptime` (
-  `realmid` int(11) unsigned NOT NULL,
-  `starttime` bigint(20) unsigned NOT NULL default '0',
-  `startstring` varchar(64) NOT NULL default '',
-  `uptime` bigint(20) unsigned NOT NULL default '0',
-  `maxplayers` smallint(5) unsigned NOT NULL default '0',
-  PRIMARY KEY  (`realmid`,`starttime`)
-) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Uptime system';
-- 
cgit v1.2.3