blob: 39e731b679b84569e40059129903b78cef82a39b (
plain)
1
2
3
4
5
6
7
8
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';
|
