diff options
| author | Spp <none@none> | 2010-03-26 16:48:33 +0100 |
|---|---|---|
| committer | Spp <none@none> | 2010-03-26 16:48:33 +0100 |
| commit | cd372966af061258f64035ba40f7aca561b3f083 (patch) | |
| tree | 9bdc1f2ea28f95b418dbb048e71dc68944ed5a07 /sql/updates | |
| parent | afbb5f2e3c369e0690c781a58b759750b6f88773 (diff) | |
* 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
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/7705_characters_worldstates.sql | 9 |
1 files changed, 9 insertions, 0 deletions
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 |