diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/base/world_database.sql | 4 | ||||
| -rw-r--r-- | sql/updates/world/2011_04_28_00_world_instance_template.sql | 6 |
2 files changed, 6 insertions, 4 deletions
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; |