diff options
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 |