From cd372966af061258f64035ba40f7aca561b3f083 Mon Sep 17 00:00:00 2001
From: Spp <none@none>
Date: Fri, 26 Mar 2010 16:48:33 +0100
Subject: * Add support to save and load worldstates. will be mainly used by
 outdoorPvP system * Update next arena auto distribute points time to custom
 worldstate

--HG--
branch : trunk
---
 sql/updates/7705_characters_worldstates.sql | 9 +++++++++
 1 file changed, 9 insertions(+)
 create mode 100644 sql/updates/7705_characters_worldstates.sql

(limited to 'sql/updates')

diff --git a/sql/updates/7705_characters_worldstates.sql b/sql/updates/7705_characters_worldstates.sql
new file mode 100644
index 00000000000..7c43bc06617
--- /dev/null
+++ b/sql/updates/7705_characters_worldstates.sql
@@ -0,0 +1,9 @@
+ALTER TABLE `saved_variables` CHANGE `NextArenaPointDistributionTime` `value` bigint(40) UNSIGNED NOT NULL DEFAULT '0',
+ADD COLUMN `entry` mediumint(11) UNSIGNED NOT NULL DEFAULT '0' FIRST,
+ADD COLUMN `comment` text NOT NULL,
+ADD PRIMARY KEY  (`entry`),
+RENAME `worldstates`,
+ROW_FORMAT=DYNAMIC;
+
+-- Only posible value is NextArenaPointDistributionTime so make the conversion to custom worldstate
+UPDATE `worldstates` SET `entry`=20001, `comment`='NextArenaPointDistributionTime';
\ No newline at end of file
-- 
cgit v1.2.3