From 5aeb4fe794174c1269b4efcb43556a8b69d2b26a Mon Sep 17 00:00:00 2001 From: leak Date: Thu, 28 Apr 2011 22:16:13 +0200 Subject: Core/ObjectMgr: Refactor sInstanceTemplate --- sql/base/world_database.sql | 4 ---- sql/updates/world/2011_04_28_00_world_instance_template.sql | 6 ++++++ 2 files changed, 6 insertions(+), 4 deletions(-) create mode 100644 sql/updates/world/2011_04_28_00_world_instance_template.sql (limited to 'sql') diff --git a/sql/base/world_database.sql b/sql/base/world_database.sql index 4683fb86de1..835642bf041 100644 --- a/sql/base/world_database.sql +++ b/sql/base/world_database.sql @@ -2847,10 +2847,6 @@ DROP TABLE IF EXISTS `instance_template`; CREATE TABLE `instance_template` ( `map` smallint(5) unsigned NOT NULL, `parent` int(10) unsigned NOT NULL, - `startLocX` float DEFAULT NULL, - `startLocY` float DEFAULT NULL, - `startLocZ` float DEFAULT NULL, - `startLocO` float DEFAULT NULL, `script` varchar(128) NOT NULL DEFAULT '', `allowMount` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`map`) diff --git a/sql/updates/world/2011_04_28_00_world_instance_template.sql b/sql/updates/world/2011_04_28_00_world_instance_template.sql new file mode 100644 index 00000000000..178c58173c8 --- /dev/null +++ b/sql/updates/world/2011_04_28_00_world_instance_template.sql @@ -0,0 +1,6 @@ +ALTER TABLE `instance_template` +DROP COLUMN `startLocX`, +DROP COLUMN `startLocY`, +DROP COLUMN `startLocZ`, +DROP COLUMN `startLocO`, +CHANGE `parent` `parent` SMALLINT(5) UNSIGNED NOT NULL; -- cgit v1.2.3