From df82ebcbfe2e3b4e577d08404ffed8967a7a3c17 Mon Sep 17 00:00:00 2001 From: Drahy Date: Tue, 24 Mar 2009 22:21:16 +0100 Subject: * Partly revered 14f8e0828c0f 2131_world was ok and changes are in 2160 already * Clean up the rest of sqls --HG-- branch : trunk --- sql/updates/2131_world.sql | 2 +- sql/updates/2160_world.sql | 6 +++--- sql/updates/2161_world.sql | 4 ++-- 3 files changed, 6 insertions(+), 6 deletions(-) (limited to 'sql') diff --git a/sql/updates/2131_world.sql b/sql/updates/2131_world.sql index db0f517e61e..76fb0b69c52 100644 --- a/sql/updates/2131_world.sql +++ b/sql/updates/2131_world.sql @@ -1,4 +1,4 @@ -DELETE FROM `command` WHERE `name` IN ('server difftime', 'npc addtemp', 'gobject addtemp', ''); +DELETE FROM `command` WHERE `name` IN ('server difftime', 'npc tempadd', 'gobject tempadd', ''); 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.'); diff --git a/sql/updates/2160_world.sql b/sql/updates/2160_world.sql index a4b308d60cb..40d2c9d1bb6 100644 --- a/sql/updates/2160_world.sql +++ b/sql/updates/2160_world.sql @@ -1,3 +1,3 @@ -DELETE FROM command WHERE name LIKE "ahbotoption %"; -DELETE FROM command WHERE name LIKE "ahbotoptions %"; -DELETE FROM command WHERE name IN ('gobject addtemp','npc addtemp'); \ No newline at end of file +DELETE FROM `command` WHERE `name` LIKE "ahbotoption %"; +DELETE FROM `command` WHERE `name` LIKE "ahbotoptions %"; +DELETE FROM `command` WHERE `name` IN ('gobject addtemp','npc addtemp'); \ No newline at end of file diff --git a/sql/updates/2161_world.sql b/sql/updates/2161_world.sql index 718130ebe38..1e45d6b33ed 100644 --- a/sql/updates/2161_world.sql +++ b/sql/updates/2161_world.sql @@ -1,2 +1,2 @@ -DELETE FROM command WHERE name LIKE "wp mod %"; -DELETE FROM command WHERE name LIKE "wp event %"; \ No newline at end of file +DELETE FROM `command` WHERE `name` LIKE "wp mod %"; +DELETE FROM `command` WHERE `name` LIKE "wp event %"; \ No newline at end of file -- cgit v1.2.3