From a6847b336fdb4062dfb25582b2cea86c96df8957 Mon Sep 17 00:00:00 2001
From: megamage <none@none>
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

