From 97b2c725df72c9d18fddbcdf79acf750546d1051 Mon Sep 17 00:00:00 2001 From: runningnak3d Date: Fri, 19 Dec 2008 15:46:23 +0000 Subject: * Some much needed SQL clean up * more to come :) --HG-- branch : trunk --- sql/updates/262_world.sql | 35 +++++++++++++++++++++++++++++++++-- 1 file changed, 33 insertions(+), 2 deletions(-) (limited to 'sql/updates/262_world.sql') diff --git a/sql/updates/262_world.sql b/sql/updates/262_world.sql index 2fe599e76e7..6c97d9798d5 100644 --- a/sql/updates/262_world.sql +++ b/sql/updates/262_world.sql @@ -55,7 +55,7 @@ DELETE FROM `command` WHERE `name` IN ( ); INSERT INTO `command` (`name`, `security`, `help`) VALUES -('server exit',4,'Syntax: .server exit\r\n\r\nTerminate mangosd NOW. Exit code 0.'), +('server exit',4,'Syntax: .server exit\r\n\r\nTerminate trinity-core NOW. Exit code 0.'), ('server idleshutdown',3,'Syntax: .server idleshutdown #delay [#exist_code]\r\n\r\nShut the server down after #delay seconds if no active connections are present (no players). Use #exist_code or 0 as program exist code.'), ('server idleshutdown cancel',3,'Syntax: .server idleshutdown cancel\r\n\r\nCancel the restart/shutdown timer if any.'), ('server idlerestart',3,'Syntax: .server idlerestart #delay\r\n\r\nRestart the server after #delay seconds if no active connections are present (no players). Use #exist_code or 2 as program exist code.'), @@ -67,4 +67,35 @@ INSERT INTO `command` (`name`, `security`, `help`) VALUES DELETE FROM trinity_string WHERE entry IN (251); INSERT INTO trinity_string VALUES -(251,'Text%d (ID: %i): %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); \ No newline at end of file +(251,'Text%d (ID: %i): %s',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL); +ALTER TABLE event_scripts + DROP datatext, + ADD COLUMN dataint int(11) NOT NULL default '0' AFTER datalong2; + +ALTER TABLE gameobject_scripts + DROP datatext, + ADD COLUMN dataint int(11) NOT NULL default '0' AFTER datalong2; + +ALTER TABLE quest_end_scripts + DROP datatext, + ADD COLUMN dataint int(11) NOT NULL default '0' AFTER datalong2; + +ALTER TABLE quest_start_scripts + DROP datatext, + ADD COLUMN dataint int(11) NOT NULL default '0' AFTER datalong2; + +ALTER TABLE spell_scripts + DROP datatext, + ADD COLUMN dataint int(11) NOT NULL default '0' AFTER datalong2; + +ALTER TABLE creature_movement + DROP `text1`, + DROP `text2`, + DROP `text3`, + DROP `text4`, + DROP `text5`, + ADD COLUMN textid1 int(11) NOT NULL default '0' AFTER waittime, + ADD COLUMN textid2 int(11) NOT NULL default '0' AFTER textid1, + ADD COLUMN textid3 int(11) NOT NULL default '0' AFTER textid2, + ADD COLUMN textid4 int(11) NOT NULL default '0' AFTER textid3, + ADD COLUMN textid5 int(11) NOT NULL default '0' AFTER textid4; \ No newline at end of file -- cgit v1.2.3