diff options
| -rw-r--r-- | sql/base/characters_database.sql | 4 | ||||
| -rw-r--r-- | sql/updates/auth_char/2011_04_08_02_characters_arena_team.sql | 3 |
2 files changed, 5 insertions, 2 deletions
diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql index 4de56b8fb5d..fabd0308899 100644 --- a/sql/base/characters_database.sql +++ b/sql/base/characters_database.sql @@ -129,12 +129,12 @@ CREATE TABLE `arena_team` ( `name` varchar(24) NOT NULL, `captainGuid` int(10) unsigned NOT NULL DEFAULT '0', `type` tinyint(3) unsigned NOT NULL DEFAULT '0', - `rating` smallint(5) unsigned NOT NULL, + `rating` smallint(5) unsigned NOT NULL DEFAULT '0', `seasonGames` smallint(5) unsigned NOT NULL DEFAULT '0', `seasonWins` smallint(5) unsigned NOT NULL DEFAULT '0', `weekGames` smallint(5) unsigned NOT NULL DEFAULT '0', `weekWins` smallint(5) unsigned NOT NULL DEFAULT '0', - `rank` int(10) unsigned NOT NULL, + `rank` int(10) unsigned NOT NULL DEFAULT '0', `backgroundColor` int(10) unsigned NOT NULL DEFAULT '0', `emblemStyle` tinyint(3) unsigned NOT NULL DEFAULT '0', `emblemColor` int(10) unsigned NOT NULL DEFAULT '0', diff --git a/sql/updates/auth_char/2011_04_08_02_characters_arena_team.sql b/sql/updates/auth_char/2011_04_08_02_characters_arena_team.sql new file mode 100644 index 00000000000..62b51ef1529 --- /dev/null +++ b/sql/updates/auth_char/2011_04_08_02_characters_arena_team.sql @@ -0,0 +1,3 @@ +ALTER TABLE `arena_team` +CHANGE `rating` `rating` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', +CHANGE `rank` `rank` INT(10) UNSIGNED NOT NULL DEFAULT '0'; |