diff options
Diffstat (limited to 'sql/old/2.4.3/00541_characters.sql')
| -rw-r--r-- | sql/old/2.4.3/00541_characters.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/old/2.4.3/00541_characters.sql b/sql/old/2.4.3/00541_characters.sql new file mode 100644 index 00000000000..2651c069e05 --- /dev/null +++ b/sql/old/2.4.3/00541_characters.sql @@ -0,0 +1,8 @@ +DROP TABLE IF EXISTS `saved_variables`; +CREATE TABLE `saved_variables` ( + `NextArenaPointDistributionTime` bigint(40) UNSIGNED NOT NULL DEFAULT '0' +) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves'; + +ALTER TABLE `arena_team_member` DROP COLUMN `points_to_add`; +ALTER TABLE `arena_team_member` ADD COLUMN `personal_rating` int(10) UNSIGNED NOT NULL DEFAULT '0'; +ALTER TABLE `characters` ADD COLUMN `arena_pending_points` int(10) UNSIGNED NOT NULL default '0' AFTER `taxi_path`; |