aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDrahy <none@none>2009-03-24 22:21:16 +0100
committerDrahy <none@none>2009-03-24 22:21:16 +0100
commitdf82ebcbfe2e3b4e577d08404ffed8967a7a3c17 (patch)
treeb31a20b42be72dfeb5bdad62735cb2af8c9e9833
parentf6b78fe39dfe6806f34371b28e7b382de578163f (diff)
* Partly revered 14f8e0828c0f 2131_world was ok and changes are in 2160 already
* Clean up the rest of sqls --HG-- branch : trunk
-rw-r--r--sql/updates/2131_world.sql2
-rw-r--r--sql/updates/2160_world.sql6
-rw-r--r--sql/updates/2161_world.sql4
3 files changed, 6 insertions, 6 deletions
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