From c76cb0ce7cae42970ac1b0792a9ee4ed33a23386 Mon Sep 17 00:00:00 2001 From: Tartalo Date: Thu, 25 Feb 2010 16:26:03 +0100 Subject: Add new flagged column to access_requirement to set instances opened/closed. This way is possible to open a raid on 10man mode while the rest of modes are closed (for example). Ingame commands to open/close instances coming soon ;) --HG-- branch : trunk --- sql/updates/7432_world_access_requirement.sql | 1 + sql/updates/7432_world_trinity_string.sql | 1 + 2 files changed, 2 insertions(+) create mode 100644 sql/updates/7432_world_access_requirement.sql create mode 100644 sql/updates/7432_world_trinity_string.sql (limited to 'sql/updates') diff --git a/sql/updates/7432_world_access_requirement.sql b/sql/updates/7432_world_access_requirement.sql new file mode 100644 index 00000000000..fcaabd1de2f --- /dev/null +++ b/sql/updates/7432_world_access_requirement.sql @@ -0,0 +1 @@ +ALTER TABLE `access_requirement` ADD COLUMN `status` TINYINT UNSIGNED DEFAULT 15 COMMENT 'instance status (open/close)'; diff --git a/sql/updates/7432_world_trinity_string.sql b/sql/updates/7432_world_trinity_string.sql new file mode 100644 index 00000000000..798cebb91be --- /dev/null +++ b/sql/updates/7432_world_trinity_string.sql @@ -0,0 +1 @@ +INSERT INTO `trinity_string` (`entry`,`content_default`) VALUES (5008,'This instance is closed.'); -- cgit v1.2.3