From a6847b336fdb4062dfb25582b2cea86c96df8957 Mon Sep 17 00:00:00 2001 From: megamage Date: Fri, 19 Dec 2008 16:43:34 -0600 Subject: *Merge Mangos to 6717. Source: Mangos. *Major change: update arena code. (The commit message of the last rev was wrong. But HG does not allow me to rollback.) --HG-- branch : trunk --- sql/updates/541_characters.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) create mode 100644 sql/updates/541_characters.sql (limited to 'sql/updates/541_characters.sql') diff --git a/sql/updates/541_characters.sql b/sql/updates/541_characters.sql new file mode 100644 index 00000000000..99a083d0387 --- /dev/null +++ b/sql/updates/541_characters.sql @@ -0,0 +1,12 @@ +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 CHANGE games_week played_week int(10) unsigned NOT NULL default '0'; +ALTER TABLE arena_team_member CHANGE wins_week wons_week int(10) unsigned NOT NULL default '0'; +ALTER TABLE arena_team_member CHANGE games_season played_season int(10) unsigned NOT NULL default '0'; +ALTER TABLE arena_team_member CHANGE wins_season wons_season int(10) unsigned NOT NULL default '0'; + +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`; \ No newline at end of file -- cgit v1.2.3