aboutsummaryrefslogtreecommitdiff
path: root/sql/updates
diff options
context:
space:
mode:
authorTartalo <none@none>2010-02-25 16:26:03 +0100
committerTartalo <none@none>2010-02-25 16:26:03 +0100
commitc76cb0ce7cae42970ac1b0792a9ee4ed33a23386 (patch)
tree5b8fa4196ec0451aa8ea6660faee7e3095bce352 /sql/updates
parent8c06fe676faa0e2a60f8848be0ae94d2cf0b2329 (diff)
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
Diffstat (limited to 'sql/updates')
-rw-r--r--sql/updates/7432_world_access_requirement.sql1
-rw-r--r--sql/updates/7432_world_trinity_string.sql1
2 files changed, 2 insertions, 0 deletions
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.');